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
- db2 restore db bsi80t load /usr/openv/netbackup/bin/nbdb2.sl open 1 sessions tak
- en at 20071129155734 to /db2dev60/bsi80t into bsi80t with 2 buffers buffer 1024
- redirect without rolling forward
- SQL1277N Restore has detected that one or more table space containers are
- inaccessible, or has set their state to 'storage must be defined'.
- DB20000I The RESTORE DATABASE command completed successfully.
- $ db2 -tvf restore_bsi80t_dashlaw01.txt
- SET TABLESPACE CONTAINERS FOR 0 IGNORE ROLLFORWARD CONTAINER OPERATIONS USING (P
- ATH /db2dev60/bsi80t/db2dev/NODE0000/SQL00001/SQLT0000.0)
- SQL1024N A database connection does not exist. SQLSTATE=08003
- SET TABLESPACE CONTAINERS FOR 1 IGNORE ROLLFORWARD CONTAINER OPERATIONS USING (P
- ATH /db2dev60/bsi80t/db2dev/NODE0000/SQL00001/SQLT0001.0)
- SQL1024N A database connection does not exist. SQLSTATE=08003
- SET TABLESPACE CONTAINERS FOR 2 IGNORE ROLLFORWARD CONTAINER OPERATIONS USING (P
- ATH /db2dev60/bsi80t/db2dev/NODE0000/SQL00001/SQLT0002.0)
- SQL1024N A database connection does not exist. SQLSTATE=08003
- SET TABLESPACE CONTAINERS FOR 3 IGNORE ROLLFORWARD CONTAINER OPERATIONS USING (F
- ILE /db2dev60/bsi80t/tf80.dbf 110000, FILE /db2dev60/bsi80t/tf801.dbf 110000)
- SQL1024N A database connection does not exist. SQLSTATE=08003
- SET TABLESPACE CONTAINERS FOR 4 IGNORE ROLLFORWARD CONTAINER OPERATIONS USING (P
- ATH /db2dev60/bsi80t/db2dev/NODE0000/SQL00001/QCTEMPTS)
- SQL1024N A database connection does not exist. SQLSTATE=08003