View Single Post
  #3 (permalink)  
Old 12-29-08, 08:39
ak835 ak835 is offline
Registered User
 
Join Date: Apr 2008
Posts: 29
Arrow

ok...this is what i did

db2 -v restore db AAUD2305 from <PATH1> to <PATH> redirect
db2 -v "set tablespace containers for 2 using (path 'SQLT0002.0')"
db2 -v "set tablespace containers for 3 using (path 'tmp02')"
db2 -v "set tablespace containers for 5 using (path 'usr01')"
db2 -v "set tablespace containers for 6 using (path 'SYSTOOLSPACE')"
db2 -v restore database AAUD2305 continue

after this if i say "db2 connect to AAUD2305",it throws following error:

bash-3.00$ db2 connect to AAUD2305
SQL1119N A connection to or activation of database "AAUD2305" cannot be made
because a previous restore is incomplete. SQLSTATE=57019
& as per db2

bash-3.00$ db2 ? SQL1119N

SQL1119N A connection to or activation of database "<name>"
cannot be made because a previous restore is
incomplete.

Explanation:

The database is in an inconsistent state because a system error
occurred during a restore function.

No connection was made.

Where is the issue here? Why db is in inconsistent state?

Regards
Abhijeet
Reply With Quote