This post is more than 5 years old
37 Posts
0
7931
May 7th, 2015 04:00
NMDA & DB2 & Lockbox
Hi, this is my first try to backup DB2. Could you please take a look where I was wrong.
1. Installed Client+NMDA+Node.
2. Discovered and configured VTL drives from DD. Added Storage Node.
3. Created a group and added client.
4. Created lockbox for the host
5. Client settings:
DB2INSTANCE:"db2dhubi"; DB2_ALIAS:"DTHUB"; DB2_INSTALL_PATH:"/opt/IBM/db2/V10.1_ESE"; DB2_NODE_NAME:"db2dhubi"; DB2_NODE_NUM:"0"; DB2_OPTIONS:"DB2BACKUP_DB","DB2BACKUP_FULL","DB2BACKUP_ONLINE","DB2BACKUP_INCLUDE_LOGS"; DB2_SESSIONS:"1"; INSTHOME:"/dh/db2dhubi"; NSR_DR_BACKUP_INFO:"TRUE"; name:"DB2"; type:"NSR DB2 Config";
DB2_USER:"rbsSQLNWBackup";
Please note that rbsSQLNWBackup is a domain user at the same domain as DB2 server. Shall I use domain\rbsSQLNWBackup format?
6. Created Lockbox and added rbsSQLNWBackup to Users.
7. Not sure how to add password to lockbox using GUI.
8. Created cfg file from template and added USER_PSWD to it using nsrdaadmin -P -z to cfg. Where shall I copy this this cfg file?
9. Tried to run group. As result:
Unable to obtain the user credentials from the lockbox due to the following error: 'Failed to retrieve item NMDB2:db2dhubi:DATAHUB:rbsSQLNWBackup from lockbox /nsr/lockbox/name.serv.ver/clb.lb'.Confirm that the user 'rbsSQLNWBackup' on the host ame.serv.ver' is in the Users attribute of the lockbox resource.ERROR: Error retrieving password from the Networker lockbox.
NMDA backup failed.
72104:nsrdasv: ERROR: Error retrieving password from the Networker lockbox.
----------------------------------------
Thank you very much for your time
elvinperez
87 Posts
0
May 7th, 2015 09:00
Hi Godzy,
U can configuration the backup manual and specified the password in the file directly.
nsrdaadmin -P /nsr/apps/config/nmda_db2.cfg
Database or application Mandatory parameters for scheduled NMDA backups
DB2 • DB2INSTANCE (UNIX only)
• DB2_NODE_NAME
• DB2PATH (Windows only)
• DB2_TBS_LIST (tablespace backup only)
• DB2_USER
• INSTHOME (UNIX only)
• USER_PSWD
Note: Set the encrypted DB2 user password in the
USER_PSWD parameter with the nsrdaadmin -P command as
described in “USER_PSWD” on page 370.
elvinperez
87 Posts
0
May 7th, 2015 06:00
Hi Godzy,
You must use the configuration wizard again for the change password.
Regards,
Godzy
37 Posts
0
May 7th, 2015 06:00
Yes, but where should I add the password? is it cfg file or how to add password to lockbox? It is unclear for me now
elvinperez
87 Posts
0
May 7th, 2015 06:00
Hi Godzy,
Depending on the error the problem is the password that you have specified.
Error.
Unable to obtain the user credentials from the lockbox due to the following error: 'Failed to retrieve item NMDB2:db2dhubi:DATAHUB:rbsSQLNWBackup from lockbox /nsr/lockbox/name.serv.ver/clb.lb'.Confirm that the user 'rbsSQLNWBackup' on the host ame.serv.ver' is in the Users attribute of the lockbox resource.ERROR: Error retrieving password from the Networker lockbox.
Regards,
Elvin..
Godzy
37 Posts
0
May 7th, 2015 06:00
Thank you very much. Will try
Godzy
37 Posts
0
May 7th, 2015 09:00
Tried to recreate client. It looks like password problem again. Is the reason that DB2 uses LDAP authentication and it is not possible to use accounts like Domain\Username ? It looks like piPassword is a USER_PSWD parameter.
Password is 100% correct.
Backing up the 'DATAHUB' database.
Unable to backup DATAHUB database due to backup request failure, SQLCODE : -2034, SQL2034N The address of the "piPassword" parameter is not valid.
.