Godzy

updated

11 years ago

G

Godzy

37 Posts

0

8066

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

    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.

  • elvinperez

    87 Posts

    4898

    0

    Posted May 7th, 2015 06:00

    Hi Godzy,

    You must use the configuration wizard again for the change password.

    Regards,

  • Godzy

    37 Posts

    4898

    0

    Posted 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

    4898

    0

    Posted 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

    4898

    0

    Posted May 7th, 2015 06:00

    Thank you very much. Will try

  • Godzy

    37 Posts

    4898

    0

    Posted 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.

    .