View previous topic :: View next topic
|
Author |
Message |
geet16
New User
Joined: 22 Dec 2006 Posts: 24 Location: USA
|
|
|
|
Hi,
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.
Thank You!! |
|
Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
Hi Geet16,
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.
Thanks,
Sushanth |
|
Back to top |
|
|
geet16
New User
Joined: 22 Dec 2006 Posts: 24 Location: USA
|
|
|
|
Hi,
Thank You for the pointer!! will look thru a BMC documentation.
The Error Message i am getting for the recovery job is as follows:
Code: |
DSNU000I DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = USERID.USERIDZ
DSNU1044I DSNUGTIS - PROCESSING SYSIN AS EBCDIC
DSNU050I DSNUGUTC - RECOVER TABLESPACE XXXXSS.STABLE DSNUM ALL
DSNU510I -DB3 DSNUCALA - NO GOOD FULL IMAGE COPY DATA SET FOR RECOVERY OF
TABLESPACE XXXXSS.STABLE
DSNU521I -DB3 DSNUCALA - RECOVER UTILITY FAILED
UNABLE TO READ REQUIRED LOG RECORDS
DSNU1511I -DB3 DSNUCALA - FAST LOG APPLY WAS NOT USED FOR RECOVERY
DSNU1510I DSNUCBDR - LOG APPLY PHASE COMPLETE, ELAPSED TIME = 00:00:00
DSNU562I -DB3 DSNUGSRX - TABLESPACE XXXXSS.STABLE IS IN RECOVER PENDING
DSNU500I DSNUCBDR - RECOVERY COMPLETE, ELAPSED TIME=00:00:00
DSNU012I DSNUGBAC - UTILITY EXECUTION TERMINATED, HIGHEST RETURN CODE=8
|
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.
Problem determination
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.
Regards,
geet |
|
Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009 Posts: 1281 Location: Belgium
|
|
|
|
the first error says you don't have a good full image copy.
Code: |
select * from sysibm.syscopy where dbname = 'XXXXSS' and tsname = 'STABLE' and ictype = 'F' |
This doesn't have to be an error if the table has been recently created so it returns 0 |
|
Back to top |
|
|
geet16
New User
Joined: 22 Dec 2006 Posts: 24 Location: USA
|
|
|
|
Hi GuyC,
The query shared by cleared all my doubts, i was able to figure out what/how exactly the recovery utility finds the information it needs for recovery.
This really helps!!!
Thank You!! |
|
Back to top |
|
|
|