Results 1 to 8 of 8
  1. #1
    Join Date
    Aug 2010
    Location
    Singapore
    Posts
    197

    Red face Unanswered: Error in redirect restore

    Hi, When i try to do redirect restore i end up with "filesystem full error"

    [ctginst1@linux-server2 StgBackup]$ db2 -tvf ABC.sql
    UPDATE COMMAND OPTIONS USING S ON Z ON MAXDB71_NODE0000.out V ON
    DB20000I The UPDATE COMMAND OPTIONS command completed successfully.

    SET CLIENT ATTACH_DBPARTITIONNUM 0
    DB20000I The SET CLIENT command completed successfully.

    SET CLIENT CONNECT_DBPARTITIONNUM 0
    DB20000I The SET CLIENT command completed successfully.

    RESTORE DATABASE MAXDB71 FROM '/StgBackup/' TAKEN AT 20120109113635 ON '/db_bkp' INTO MAXDB71 REDIRECT
    SQL2523W Warning! Restoring to an existing database that is different from
    the database on the backup image, but have matching names. The target database
    will be overwritten by the backup version. The Roll-forward recovery logs
    associated with the target database will be deleted.
    Do you want to continue ? (y/n) y
    SQL1277W A redirected restore operation is being performed. Table space
    configuration can now be viewed and table spaces that do not use automatic
    storage can have their containers reconfigured.
    DB20000I The RESTORE DATABASE command completed successfully.

    SET TABLESPACE CONTAINERS FOR 3 USING ( FILE 'CTGDAT/MAXDATA/container1' 600000 )
    SQL0968C The file system is full. SQLSTATE=57011


    I use db29.1 fp6,

    I have 40Gb available in the path where i am restoring, where db is just 16 gb.

    Please help me... thanks

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    check the diag.log
    it is possible that the home directory is full - that is where the db is created
    on xxx is for datapath for automatic storage
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  3. #3
    Join Date
    Aug 2010
    Location
    Singapore
    Posts
    197
    hey thanks for your reply..

    i have given the DBPATH in script or do i need to specify the same in Target directory?

    RESTORE DATABASE MAXDB71
    -- USER <username>
    -- USING '<password>'
    FROM '/StgBackup/'
    TAKEN AT 20120109113635
    ON '/db_bkp'
    -- , '/opt/ctginst1'
    -- , '/opt/ctginst1/ctginst1/MAX_Container'
    -- DBPATH ON '<target-directory>'
    INTO MAXDB71
    -- NEWLOGPATH '/opt/ctginst1/ctginst1/NODE0000/SQL00001/SQLOGDIR/'
    -- WITH <num-buff> BUFFERS
    -- BUFFER <buffer-size>
    -- REPLACE HISTORY FILE
    -- REPLACE EXISTING
    REDIRECT
    -- PARALLELISM <n>
    -- COMPRLIB '<lib-name>'
    -- COMPROPTS '<options-string>'
    -- WITHOUT ROLLING FORWARD
    -- WITHOUT PROMPTING

    i get this error when restoring a particular Tablepace...

  4. #4
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    on is for datapath for automatic storage
    dbpath is for the config files and others
    this is displayed when doing db2 list db directory
    check infocenter/doc for details of each option
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  5. #5
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by alwayssathya View Post
    SET TABLESPACE CONTAINERS FOR 3 USING ( FILE 'CTGDAT/MAXDATA/container1' 600000 )
    SQL0968C The file system is full. SQLSTATE=57011[/B]
    Looks like you're specifying a relative path, not absolute, so it is being created in the database directory (/db_bkp).

    Check also ulimit and/or disk quotas.

  6. #6
    Join Date
    Aug 2010
    Location
    Singapore
    Posts
    197
    Issue got resolved...

    problem i had was "disk full issue", which is because one of the tablespace not able to restore. when i check it in source db it was having 51gb. But i don have enough space in target db.

    Then i altered the number pages to a value close to High water Mark.

    Then the tablespace got restored.

    I don know it is a correct way.. but it worked for me.

    thanks for all your sugestions...

  7. #7
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by alwayssathya View Post
    when i check it in source db it was having 51gb.
    That's not what you said initially:

    Quote Originally Posted by alwayssathya
    I have 40Gb available in the path where i am restoring, where db is just 16 gb.
    So, you've just wasted everybody's time (including your own) by not providing full information.

  8. #8
    Join Date
    Aug 2010
    Location
    Singapore
    Posts
    197
    No, please don say that...

    I still stand to my point, I found the db size was 16GB
    And one of the TBS is around 12GB size, But the capacity of the TBS was
    51GB. I had 40GB space in my Target DB path.

    So i told what i faced, Changing the capacity value came just as a luck.

Posting Permissions

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