Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2010
    Posts
    123

    Unanswered: SQL0290N Table space access is not allowed. SQLSTATE=55039

    i am taken offline backup and restored in another db, now i am geeting above error while accessing the tables from ravi db. the commands which i used are

    db2 "backup database sample to d:\db2\offlinebackup with 4 buffers buffer 4096 parallelism 2 without prompting"

    db2 "restore database sample from d:\db2\offlinebackup taken at 20101209104008 into ravi without prompting"

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,369
    Did the restore command complete successfully or generated some warning message (ie. 2563 -> sql2563w)? You may need to redefine tablespace containers during restore. Check db2diag.log for any errors generated during the restore process.

  3. #3
    Join Date
    Dec 2010
    Posts
    123

    restore

    Yes ur correct, it generated some warning message ie. 2563, i found in diaglog as"Problem restoring table space VELOCISTSP, Skipping table space VELOCISTSP" , pls give me clear explanation, what i have do now, if possible provide explanation with commands???? my tablespace is in Quiesced Exclusive, its not allowing to set containers...
    Last edited by ravichandrapratap; 12-09-10 at 06:03.

  4. #4
    Join Date
    Mar 2008
    Posts
    136
    Hi, Please refer below link which will resolve your problem.

    DB2 Basics: Cloning DB2 Databases Using Redirected Restore
    Regards
    Pawan Kumar

  5. #5
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,369
    How you redefine tablespace containers during restore depends on whether tablespaces are using automatic storage or not. Check this forum link for some info:
    https://www.ibm.com/developerworks/f...ageID=14300006

Posting Permissions

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