468,512 Members | 1,660 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,512 developers. It's quick & easy.

Netbackup for DB2 Redirected restore

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
0 2858

Post your reply

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

Similar topics

9 posts views Thread by GL | last post: by
7 posts views Thread by CCC via DBMonster.com | last post: by
4 posts views Thread by africantract | last post: by
1 post views Thread by edmundleungs | last post: by
1 post views Thread by edmundleungs | last post: by
2 posts views Thread by Asphalt Blazer | last post: by
reply views Thread by NPC403 | last post: by
1 post views Thread by fmendoza | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.