IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

DB2 Recovery


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
geet16

New User


Joined: 22 Dec 2006
Posts: 24
Location: USA

PostPosted: Fri Feb 25, 2011 3:12 pm
Reply with quote

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
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1020
Location: India

PostPosted: Fri Feb 25, 2011 5:13 pm
Reply with quote

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
View user's profile Send private message
geet16

New User


Joined: 22 Dec 2006
Posts: 24
Location: USA

PostPosted: Fri Feb 25, 2011 6:00 pm
Reply with quote

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
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1281
Location: Belgium

PostPosted: Fri Feb 25, 2011 6:11 pm
Reply with quote

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
View user's profile Send private message
geet16

New User


Joined: 22 Dec 2006
Posts: 24
Location: USA

PostPosted: Fri Feb 25, 2011 7:22 pm
Reply with quote

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!! icon_biggrin.gif
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Recovery Routine/Abend exit to releas... PL/I & Assembler 14
No new posts DFSMShsm Dataset Recovery with B and ... JCL & VSAM 2
No new posts Need info with DBRC recovery IMS DB/DC 0
No new posts recovery from 904 ststus code DB2 2
No new posts Recovery of deleted dataset JCL & VSAM 3
Search our Forums:

Back to Top