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.
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.
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.
elvinperez
87 Posts
4898
0
Posted 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.