Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2007
    Posts
    66

    Unanswered: Redirected restore urgent help

    I am trying redirected restore and it is failing with the following errors please help. I am using SMS tablespaces

    redirected restore script commands::


    db2 "restore db MARKETDB replace existing redirect"

    db2 "set tablespace containers for 0 using (path '/home/db2inst1/db2inst1/NODE0000/SQL00001/SQLT0000.0', path '/db2fs/marketdb/db2inst1/NODE0000/SQL00001/SQLT0000.0')"


    db2 "set tablespace containers for 2 using (path '/home/db2inst1/db2inst1/NODE0000/SQL00001/SQLT0002.0', path '/db2fs/marketdb/db2inst1/NODE0000/SQL00001/SQLT0002.0')"


    db2 "set tablespace containers for 3 using (path '/home/db2inst1/db2inst1/NODE0000/SQL00001/SYSTOOLSPACE', path '/db2fs/marketdb/db2inst1/NODE0000/SQL00001/SYSTOOLSPACE')"


    db2 "set tablespace containers for 32 using (path '/home/db2inst1/db2inst1/NODE0000/SQL00001/SYSTOOLSTMPSPACE', path '/db2fs/marketdb/db2inst1/NODE0000/SQL00001/SYSTOOLSTMP
    SPACE')"



    db2 "set tablespace containers for 49 using (path '/home/db2inst1/db2inst1/NODE0000/SQL00001/QCTEMPTS', path '/db2fs/marketdb/db2inst1/NODE0000/SQL00001/QCTEMPTS')"


    db2 "restore db MARKETDB continue"



    Output messages file for the above commands::






    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.
    DB20000I The SET TABLESPACE CONTAINERS command completed successfully.
    SQL0298N Bad container path. SQLSTATE=428B2
    DB20000I The SET TABLESPACE CONTAINERS command completed successfully.
    DB20000I The SET TABLESPACE CONTAINERS command completed successfully.
    SQL0298N Bad container path. SQLSTATE=428B2
    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.

  2. #2
    Join Date
    Feb 2005
    Location
    Bangalore,India
    Posts
    39
    As it states,container path is not correct.The path you have mentioned is not exist in the box OR the path being used by some other container.

    run ls -l for all the paths.
    say, ls -l /home/db2inst1/db2inst1/NODE0000/SQL00001/SQLT0000.0

    if you see any file(s) under this(SQLTAG.NAM),just drop it and rerun your SET stmts followed by RESTORE CONTINUE.If you get any error ,means your path is not correct..specify the correct one.

    --Naga

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •