Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2002
    Location
    San Mateo, CA
    Posts
    2

    Unanswered: Restore from different host system

    Hi! I have a database backup file from system A and I need to restore it onto system B.
    SYstem A and B have the same OS, the two DB2 instances are at the same version. New database was created and it has the same tablespace names and the same number of containers. However, the root directory names are different between the two systems. The source system A has "/rtmq01" the instance name as the root, and the target system B has "data" as the root.

    I used "TO" command to specify the target file directory, but I'm not sure how many levels is the correct db level, should I stop before or after the common subdirectory name for all the tablespaces?

    I'm also getting a weird permission error that seems a simple REDIRECT will not help, because the target database was created with default, it does not have a tablespace specific for catalog :

    2006-06-12-13.34.19.643655-420 I1136242C294 LEVEL: Error
    PID : 20373 TID : 1 PROC : db2bm.15390.0 0
    INSTANCE: rtqa3 NODE : 000
    FUNCTION: DB2 UDB, buffer pool services, sqlbCreateAndLockParent, probe:920
    MESSAGE : Failed at directory /rtmqi01.

    2006-06-12-13.34.19.644106-420 I1136537C418 LEVEL: Error
    PID : 20373 TID : 1 PROC : db2bm.15390.0 0
    INSTANCE: rtqa3 NODE : 000
    FUNCTION: DB2 UDB, buffer pool services, sqlbDMSAddContainerRequest, probe:805
    RETCODE : ZRC=0x840F0001=-2079391743=SQLO_ACCD "Access Denied"
    DIA8701C Access denied for resource "", operating system return code
    was "".

    2006-06-12-13.34.19.654808-420 I1136956C393 LEVEL: Error
    PID : 20373 TID : 1 PROC : db2bm.15390.0 0
    INSTANCE: rtqa3 NODE : 000
    FUNCTION: DB2 UDB, buffer pool services, sqlbDMSAddContainerRequest, probe:805
    MESSAGE : Error acquiring container 0
    (/rtmqi01/dbsys0001/RTMQ01/TBLSPACE/catalog.ts1) for tbsp 0. Rc = 840F0001

    Anyhelp in resolving the root directory and the tablespace catalog issues are greatly appreciated!

    Regards, Nancy

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Go to system A and issue the following command:

    db2 list db directory

    This will tell you what directory the database is installed at, so you install the database at an appropriate directory on System B.

    The database directory, and the tablespace directories, must be owned by the instance owner, not root.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    I think Nancy will need to use REDIRECT option in any case - the container paths seem to be different between the two servers. Just don't create the database on the target system prior to the restore - let restore do it.

Posting Permissions

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