Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2013
    Posts
    36

    Thumbs up Unanswered: Facing space issue while restoring DB backup with automatic tablespaces

    Hi DBA's,

    Need an urgent help for restoring a DB with Automatic tablespaces.
    1. I have a backup image of DB ABC.
    2. ABC DB size is around 200GB.
    3. I have a file system '/abc' with space 1TB.

    Now situation is, I have generated the script from the backup image. Now when I am trying to restore this backup image on /abc, My backup command is saying it completed successfully. But when I am trying to connect to connect the DB I am getting below error:
    SQL0752N Connecting to a database is not permitted within a logical unit of
    work when the CONNECT type 1 setting is in use.

    Output of restore log file is like below (for continue part):

    RESTORE DATABASE ABC CONTINUE
    SQL1277W A redirected restore operation is being performed. During a table
    space restore, only table spaces being restored can have their paths
    reconfigured. During a database restore, storage group storage paths and DMS
    table space containers can be reconfigured.
    DB20000I The RESTORE DATABASE command completed successfully.


    My doubt is its happening because of space issue.
    please help me to solve this issue. Please find some more info below:

    DB2 version : 10.5
    OS : UNIX
    Backup : offline backup

    Thanks in advance

  2. #2
    Join Date
    Jan 2003
    Posts
    4,286
    Provided Answers: 5
    Code:
    SQL0752N  Connecting to a database is not permitted within a logical
          unit of work when the CONNECT type 1 setting is in use.
    
    Explanation:
    
    An attempt was made to connect to either another database or the same
    database before issuing a COMMIT or ROLLBACK statement. The request
    cannot be processed within a CONNECT type 1 environment.
    
    User response:
    
    
    *  Submit a COMMIT or ROLLBACK statement before requesting a connection
       to another database.
    *  If multiple databases need to be updated within a unit of work,
       change the connection settings to SYNCPOINT TWOPHASE and CONNECT 2 by
       re-precompiling or by issuing the SET CLIENT API from within the
       application.
    
     sqlcode: -752
    
     sqlstate: 0A001
    Can you post all of the commands you use to do the restore and then connect along with their output?

    Andy

  3. #3
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    Hi,

    What appears in the db2diag.log when you issue a db2 backup command?

Posting Permissions

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