SQL0290N Table space access is not allowed. SQLSTATE=55039

ravichandrapratap · #1 (**permalink**) 12-09-10, 02:29

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"

db2girl · #2 (**permalink**) 12-09-10, 03:00

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.

ravichandrapratap · #3 (**permalink**) 12-09-10, 04:26

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...

Pawan Kumar · #4 (**permalink**) 12-09-10, 04:42

Hi, Please refer below link which will resolve your problem.

DB2 Basics: Cloning DB2 Databases Using Redirected Restore

db2girl · #5 (**permalink**) 12-09-10, 18:47

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

Internet Services

Web Development

Digital Marketing

Consumer Tech