attempting to use restore redirect for 3 tablespaces. Job fails SQL2034N The address

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • ljkarl
    New Member
    • Sep 2016
    • 1

    attempting to use restore redirect for 3 tablespaces. Job fails SQL2034N The address

    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
Working...