I restored a db2 database from the Main server to a backup server using the backup db and the Restore commands. The restore command was successfully completed.
Now when i try to connect to the Backup database, it gives me the following error :- "SQL1091C The release number of the database is not valid. SQLSTATE=08004". I checked the version of the DB2 as well as the database and instance release level on both the servers, they are the same.
Can any one throw some more light on this error.
Thanks and reg
Thanks a million, Prashant, for that solution. Actually, i was not aware that my previous dba had applied patch 2 for the db, hence the error.
Actually i am a oracle dba and am new into db2. I am assigned a task to
design and implement a backup strategy for a live PROD database. I am
planning to go about it this way:-
1> Put the database in Archive mode.
2> Take complete online backup.
3> Backup the archive logs generated everyday.
4> After a period of 15 days, reset the archive logs by switching the USEREXIT and LOGRETAIN parameters on and off and repeat steps 2 onwards.
I plan to reset the archive logs every 15 days as this would avoid a large
recovery time incase of database crash. The last complete online backup would
have to be restored and only logs of last 15 days would have to be applied.
Could u please suggest me a beeter way or reseting logs (Oracle has ALTER DATABASe
RESET LOGs command) .
And is this a good strategy? I am also contemplating of implementing a inremental(Delta)
strategy in parallel.