cancel
Showing results for 
Search instead for 
Did you mean: 

Redirected DB2 restores error out with 'SQL2062N an error occurred while accessing media "/usr/openv/netbackup/bin/nbdb2.sl64". Reason code: "516"'

Francois_de_Rid
Level 2

Is there anyone who got a DB2 alternate restore going from the documentation.

We are running NB 7.01 and the :

Symantec NetBackup ™ for
DB2 Administrator's Guide
UNIX and Linux
Release 7.0

is just a copy with all errors included of the DB2 v6.0 release.

I found the articles which indicate that there is serious errors being carried over from one Manual to the other. I also include links which was of great help in getting the backups restores on the same server going.

Errata to db2 6.0 documenation

http://www.symantec.com/business/support/index?page=content&id=TECH51846

This is to fix redirected DB2 restores error out with 'SQL2062N an error occurred while accessing media "/usr/openv/netbackup/bin/nbdb2.sl64". Reason code: "516"'

http://www.symantec.com/business/support/index?page=content&id=TECH77284

/usr/openv/netbackup/db/altnames/No.Restrictions issues

http://www.symantec.com/connect/forums/db2-alternate-restore-problems

This article cleared some stuff, but my success level is still zero.

http://www.ebenner.com/db2dba_blog/?p=594

IBM setup for dummies

http://www.ibm.com/developerworks/data/library/techarticle/dm-0402chong/index.html

The logfile directories permission is 777 if anyone think that is my issue for getting the error

 

I will log a request to Symantec to get the documentation in order.

 

Any help will be appreciated

 

1 ACCEPTED SOLUTION

Accepted Solutions

Francois_de_Rid
Level 2

I just like to confirm that the biggest issue I experience is the lack and unclarity of documentation.

If you add limited DB2 admin experience, this can be a nightmare.

The following steps is what I see needs to be followed during a redirect restore on DB2.

  1. Make sure that the backup is taken in the correct way.
    It is essential to follow the instructions as said out in:                                       http://www.symantec.com/business/support/index?page=content&id=TECH51846

    http://www.symantec.com/business/support/index?page=content&id=TECH77284

  2. When preparing the db2.conf file for the restore you need to give the folling infomation

    OBJECTTYPE ALTERNATE # Specifies an alternate restore
  3. SRCINST db2v832d     # Names the source instance that was backed up
  4. To get the SRCINST you can as the db2user on the source instance enter the following:    "db2ilist"
    SRCALIAS SAMPLE      # Names the source database that was backed up
  5. To get the SRCALIAS enter db2 list database directory show detail   The line         Database name                        = XXX is the correct one.
    DESTINST db2v832t    # Names the destination instance name
  6. To get the DESTINST you can as the db2user on the destination instance enter the following:    "db2ilist"
    DESTALIAS NEWSAMPL   # Names the destination database alias name
  7. To get the DESTALIAS enter db2 list database directory show detail   The line         Database name                        = XXX is the correct one.                      ENDOPER              # Ends the object identifier
  8. Start the restore with eg. db2 restore db QBI load /usr/openv/netbackup/bin/nbdb2.sl64 into QBI redirect
  9. The restore will now start and and the process will give a message like :
  10. temp:db2qbi 2> db2 restore db QBI load /usr/openv/netbackup/bin/nbdb2.sl64 into QBI redirect
    SQL2539W  Warning!  Restoring to an existing database that is the same as the
    backup image database.  The database files will be deleted                                                Do you want to continue ? (y/n) y
    SQL1277W  A redirected restore operation is being performed.  Table space
    configuration can now be viewed and table spaces that do not use automatic
    storage can have their containers reconfigured.
    DB20000I  The RESTORE DATABASE command completed successfully.
  11. When you get this message you will see that the restore process is still running. To get the datafiles back you need to enter the following
  12. db2 restore db QBI continue.
  13. You will notice that the next file in the backup is now being restored.
  14. If you do not enter this in the required time, the restore will fail on a return code 5.
  15. However I find that if you enter db2 restore db QBI continue even after it failed it starts a new process and continue.
  16. There is a lot of other parameters for specific time, user passwd etc. This can be find in some of the links originally post.

Any db2 administrator who can give a better understanding of what happens during this, please comment

  1.  

View solution in original post

3 REPLIES 3

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

I just had to look up reason code 516:

516
Message:
NetBackup Find Image Failed
Cause:
NetBackup encountered errors when attempting to locate a backup image.

 

Can you please post bprd log file on master? Please post log as attachment.

Are you able to run bplist from destination client?

/usr/openv/netbackup/bin/bplist -C <source-client> -s <start-date> -e <end-date>  -t 18 -R /

Francois_de_Rid
Level 2

I just like to confirm that the biggest issue I experience is the lack and unclarity of documentation.

If you add limited DB2 admin experience, this can be a nightmare.

The following steps is what I see needs to be followed during a redirect restore on DB2.

  1. Make sure that the backup is taken in the correct way.
    It is essential to follow the instructions as said out in:                                       http://www.symantec.com/business/support/index?page=content&id=TECH51846

    http://www.symantec.com/business/support/index?page=content&id=TECH77284

  2. When preparing the db2.conf file for the restore you need to give the folling infomation

    OBJECTTYPE ALTERNATE # Specifies an alternate restore
  3. SRCINST db2v832d     # Names the source instance that was backed up
  4. To get the SRCINST you can as the db2user on the source instance enter the following:    "db2ilist"
    SRCALIAS SAMPLE      # Names the source database that was backed up
  5. To get the SRCALIAS enter db2 list database directory show detail   The line         Database name                        = XXX is the correct one.
    DESTINST db2v832t    # Names the destination instance name
  6. To get the DESTINST you can as the db2user on the destination instance enter the following:    "db2ilist"
    DESTALIAS NEWSAMPL   # Names the destination database alias name
  7. To get the DESTALIAS enter db2 list database directory show detail   The line         Database name                        = XXX is the correct one.                      ENDOPER              # Ends the object identifier
  8. Start the restore with eg. db2 restore db QBI load /usr/openv/netbackup/bin/nbdb2.sl64 into QBI redirect
  9. The restore will now start and and the process will give a message like :
  10. temp:db2qbi 2> db2 restore db QBI load /usr/openv/netbackup/bin/nbdb2.sl64 into QBI redirect
    SQL2539W  Warning!  Restoring to an existing database that is the same as the
    backup image database.  The database files will be deleted                                                Do you want to continue ? (y/n) y
    SQL1277W  A redirected restore operation is being performed.  Table space
    configuration can now be viewed and table spaces that do not use automatic
    storage can have their containers reconfigured.
    DB20000I  The RESTORE DATABASE command completed successfully.
  11. When you get this message you will see that the restore process is still running. To get the datafiles back you need to enter the following
  12. db2 restore db QBI continue.
  13. You will notice that the next file in the backup is now being restored.
  14. If you do not enter this in the required time, the restore will fail on a return code 5.
  15. However I find that if you enter db2 restore db QBI continue even after it failed it starts a new process and continue.
  16. There is a lot of other parameters for specific time, user passwd etc. This can be find in some of the links originally post.

Any db2 administrator who can give a better understanding of what happens during this, please comment

  1.  

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

Thanks for the feedback! This seems like material for a HOW TO blog or article!

Since you managed to troubleshoot and solve the restore failure, I'm happy to mark the solution for you.