Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

DB2 Recovery

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: DB2 Recovery
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: 1013
Location: India

PostPosted: Fri Feb 25, 2011 5:13 pm    Post subject:
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    Post subject: Reply to: DB2 Recovery
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: 1278
Location: Belgium

PostPosted: Fri Feb 25, 2011 6:11 pm    Post subject:
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    Post subject: Reply to: DB2 Recovery
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    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts recovery from 904 ststus code Tim Jones DB2 2 Mon Jun 04, 2012 6:33 pm
No new posts Recovery of deleted dataset mfguy01 JCL & VSAM 3 Tue Nov 29, 2011 4:10 pm
No new posts Issue in IMS recovery don.leahy IMS DB/DC 7 Wed Oct 12, 2011 4:03 pm
No new posts COBOL Abend recovery using check-point's Bill Woodger COBOL Programming 12 Fri Apr 15, 2011 6:15 pm
No new posts Recovery of deleted datasets jaggp JCL & VSAM 2 Tue Jan 18, 2011 1:51 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us