By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,756 Members | 1,745 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,756 IT Pros & Developers. It's quick & easy.

Netbackup for DB2 Redirected restore

P: 1
Currently trying to perform a redirected restore of DB2 database using Netbackup in AIX environment. The restore command completes successfully but the set tablespace commands fail due to no database connection.

Tried connecting to the database before the set tablespace command but could not because a restore was in progress.

Netbackup support has no answers and says this is an IBM issue. When using TSM to restore this database the database connection is maintained via the db2 restore command. With Netbackup, this does not appear to be the case. Any ideas??

Expand|Select|Wrap|Line Numbers
  1. db2 restore db bsi80t load /usr/openv/netbackup/bin/nbdb2.sl open 1 sessions tak
  2. en at 20071129155734 to /db2dev60/bsi80t into bsi80t with 2 buffers buffer 1024 
  3. redirect without rolling forward
  4.  
  5.  
  6. SQL1277N  Restore has detected that one or more table space containers are 
  7.  
  8. inaccessible, or has set their state to 'storage must be defined'.
  9.  
  10. DB20000I  The RESTORE DATABASE command completed successfully.
  11.  
  12. $ db2 -tvf restore_bsi80t_dashlaw01.txt
  13.  
  14. SET TABLESPACE CONTAINERS FOR 0 IGNORE ROLLFORWARD CONTAINER OPERATIONS USING (P
  15.  
  16. ATH /db2dev60/bsi80t/db2dev/NODE0000/SQL00001/SQLT0000.0)
  17.  
  18. SQL1024N  A database connection does not exist.  SQLSTATE=08003
  19.  
  20.  
  21.  
  22. SET TABLESPACE CONTAINERS FOR 1 IGNORE ROLLFORWARD CONTAINER OPERATIONS USING (P
  23.  
  24. ATH /db2dev60/bsi80t/db2dev/NODE0000/SQL00001/SQLT0001.0)
  25.  
  26. SQL1024N  A database connection does not exist.  SQLSTATE=08003
  27.  
  28.  
  29.  
  30. SET TABLESPACE CONTAINERS FOR 2 IGNORE ROLLFORWARD CONTAINER OPERATIONS USING (P
  31.  
  32. ATH /db2dev60/bsi80t/db2dev/NODE0000/SQL00001/SQLT0002.0)
  33.  
  34. SQL1024N  A database connection does not exist.  SQLSTATE=08003
  35.  
  36.  
  37.  
  38. SET TABLESPACE CONTAINERS FOR 3 IGNORE ROLLFORWARD CONTAINER OPERATIONS USING (F
  39.  
  40. ILE /db2dev60/bsi80t/tf80.dbf 110000, FILE /db2dev60/bsi80t/tf801.dbf 110000)
  41.  
  42. SQL1024N  A database connection does not exist.  SQLSTATE=08003
  43.  
  44.  
  45.  
  46. SET TABLESPACE CONTAINERS FOR 4 IGNORE ROLLFORWARD CONTAINER OPERATIONS USING (P
  47.  
  48. ATH /db2dev60/bsi80t/db2dev/NODE0000/SQL00001/QCTEMPTS)
  49.  
  50. SQL1024N  A database connection does not exist.  SQLSTATE=08003
Dec 2 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.