I noticed three tablespaces initially in a State X4000. I also noticed I did not have a valid backup. Therefore, I attempted to do a restore redirect using a offline backup image from another server for the three tablespaces.
I modified the restore redirect script to provide valid file paths for the containers. When I execute the script I get the following error
SET CLIENT CONNECT_MEMBER 0
DB20000I The SET CLIENT command completed successfully.
RESTORE DATABASE SHOP390 TABLESPACE ( "TSERVICELEVELT S" , "TSERVICELEVELI S" , "CDTSERVICELEVE LTS" ) FROM '/db/a3inshpt/db2backup' TAKEN AT 20160907102438 INTO SHOP390 REDIRECT
SQL2034N The address of the "tablespace s" parameter is not valid.
DB20000I The UPDATE COMMAND OPTIONS command completed successfully.
SET CLIENT ATTACH_MEMBER 0
DB20000I The SET CLIENT command completed successfully.
SET CLIENT CONNECT_MEMBER 0
DB20000I The SET CLIENT command completed successfully.
RESTORE DATABASE SHOP390 TABLESPACE ( "TSERVICELEVELT S" , "TSERVICELEVELI S" , "CDTSERVICELEVE LTS" ) FROM '/db/a3inshpt/db2backup' TAKEN AT 20160907103721 INTO SHOP390 REDIRECT
SQL2034N The address of the "tablespace s" parameter is not valid.
Does anyone know how to resolve this?
Also, the tablespaces are now in a recover pending state.
I would like to drop the tables and the three tablespaces and rebuild them, but due to them in the recovery pending state this is prohibited. Does anyone know how to drop tables when the tablespaces are in recovery pending?
Thanks
Larry Karl
I modified the restore redirect script to provide valid file paths for the containers. When I execute the script I get the following error
SET CLIENT CONNECT_MEMBER 0
DB20000I The SET CLIENT command completed successfully.
RESTORE DATABASE SHOP390 TABLESPACE ( "TSERVICELEVELT S" , "TSERVICELEVELI S" , "CDTSERVICELEVE LTS" ) FROM '/db/a3inshpt/db2backup' TAKEN AT 20160907102438 INTO SHOP390 REDIRECT
SQL2034N The address of the "tablespace s" parameter is not valid.
DB20000I The UPDATE COMMAND OPTIONS command completed successfully.
SET CLIENT ATTACH_MEMBER 0
DB20000I The SET CLIENT command completed successfully.
SET CLIENT CONNECT_MEMBER 0
DB20000I The SET CLIENT command completed successfully.
RESTORE DATABASE SHOP390 TABLESPACE ( "TSERVICELEVELT S" , "TSERVICELEVELI S" , "CDTSERVICELEVE LTS" ) FROM '/db/a3inshpt/db2backup' TAKEN AT 20160907103721 INTO SHOP390 REDIRECT
SQL2034N The address of the "tablespace s" parameter is not valid.
Does anyone know how to resolve this?
Also, the tablespaces are now in a recover pending state.
I would like to drop the tables and the three tablespaces and rebuild them, but due to them in the recovery pending state this is prohibited. Does anyone know how to drop tables when the tablespaces are in recovery pending?
Thanks
Larry Karl