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