View Single Post
  #1 (permalink)  
Old 08-27-03, 19:24
niran niran is offline
Registered User
 
Join Date: Aug 2003
Posts: 2
Rollforward and db connect problems

I am facing problems with a database rollforward db to end of logs. The log files are backed up using a user exit and so has timestamp appended to the SQL0112918.LOG files. However I don't have user exit enabled on my machine and so the rollforward is not able to know these log files having the timestamp as the extension. Due to time constraints, I restored these files from TSM server to a dummy directoy and then copied them to the active log directory and renamed them to have just the .LOG extension and issued the command:
rollforward db <dbname> to end of logs.

However the rollforward was still looking for the next file. I knew that I have provided the last log file (as listed in the history information) and so I issued a rollforward complete command.
The database was still in the rollforward state. I stopped db2 (db2stop) and then db2start. This took the database out of rollforward state and restore pending state but now I have a diff problem now.
I cannot connect to the database, it comes out with SQL0293N error. which is error accessing a table space container. ANY HELP PLEASE !!!!
Reply With Quote