db2 redirect restore

nagaraju.bandaru · #1 (**permalink**) 01-31-11, 23:28

Hi all,
After i am restoring the database from one system backup into another , i typed the list tablespaces, those are in Restore Pending + Storage May be Defined. How to rectify this problem.

DB_N00b · #2 (**permalink**) 02-01-11, 04:17

Do you have any SQL Error Code?

I think your tablespaces have to be restored!

sathyaram_s · #3 (**permalink**) 02-01-11, 07:29

Can you post the script you are using?
looks like you are not using automatic storage.

so, the script should look similar to this ..

restore db sample redirect
set tablespace containers for 1 using (file 'xxx' 100mb)
restore db sample continue

ravichandrapratap · #4 (**permalink**) 02-07-11, 04:02

Quote:

Originally Posted by nagaraju.bandaru

Hi all,
After i am restoring the database from one system backup into another , i typed the list tablespaces, those are in Restore Pending + Storage May be Defined. How to rectify this problem.

The following link can help you out

DB2 Basics: Cloning DB2 Databases Using Redirected Restore

Internet Services

Web Development

Digital Marketing

Consumer Tech