I am working on recovery steps for our DB2 DB. We have our full image copies created using ACPMAIN, a BMC utility and our recovery job uses DSNUTILB, a DB2 utility. Should there be any issues caused by this?
I am encountering issues while i was testing the recovery and hence wanted to be sure.
I found no information hence posting this question. I am a novice in field of DB2 DBA and any pointers will be highly appreciated.
You are taking image copy using a BMC utility and for recovery you are IBM's RECOVER utility, right. My experiences are with CA utilities, most of the time, IC's are compatible with RECOVER utility. Look into BMC manual, you will find compatibility information there.
What is the error you are getting ? You have to post more information to get good reply's.
I did some analysis on IBM website for the log and here I found out that
"DSNU521I -DB3 DSNUCALA - RECOVER UTILITY FAILED UNABLE TO READ REQUIRED LOG RECORDS" is the reason i received a RC of 8 for the recovery job.
If no listed data set contains the required RBA or LRSN, one of the following might have occurred:
* The data set was deleted from the bootstrap data set (BSDS) by the change log inventory (DSNJU003) utility. Rerun the utility to insert the missing data set name. DB2 must be stopped to run this utility.
* The BSDS was damaged. The BSDS can be restored using the dump and the most recent archive log data set. Run the change log inventory (DSNJU003) tility to supply changes that occurred during and after the last offload operation. Changes can be determined from the operator's console listing.
If a listed log data set contains the required RBA or LRSN, this message is preceded by one or more DSNJxxx error messages. See the explanation of those messages for the appropriate action.
We have forwarded the details to our Sys DB2 DBA but I wanted to cover our bases.