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
 

 

Questions related to DB2 utilities and Logs

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
rajulan

New User


Joined: 11 Jan 2008
Posts: 66
Location: India

PostPosted: Sun May 17, 2009 11:43 am    Post subject: Questions related to DB2 utilities and Logs
Reply with quote

Hi all,

1. How to recover the data from Active and Archieve logs?
Where do you get the RBA address?

I have executed the -Display Log

i got the below screen.

Code:
DSNJ370I  - DSNJC00A LOG DISPLAY                             
CURRENT COPY1 LOG = OZADB2.LOGCOPY1.DS02 IS 1% FULL           
CURRENT COPY2 LOG = OZADB2.LOGCOPY2.DS02 IS 1% FULL           
          H/W RBA = 0148AFFFD6BC                             
          H/O RBA = 0148AFFF9FFF                             
          FULL LOGS TO OFFLOAD = 0 OF 6                       
          OFFLOAD TASK IS (AVAILABLE)                         
DSNJ371I  - DB2 RESTARTED 23:37:16 FEB 26, 2009               
          RESTART RBA 0147084B2000                           
          CHECKPOINT FREQUENCY 50000 LOGRECORDS               
          LAST SYSTEM CHECKPOINT TAKEN 00:02:00 MAY 17, 2009 
DSN9022I  - DSNJC001 '-DISPLAY LOG' NORMAL COMPLETION         
***                                                           


From this H/W RBA = 0148AFFFD6BC ,

Can I get the records back? If yes, how?

2. Reload process is abended , what are the steps to followed?

Thanks,
Raju
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sun May 17, 2009 1:21 pm    Post subject:
Reply with quote

Hello,

When were the last backups taken? How were the last backups taken?

What abend(s) occur when you try to reload? Post your jcl, control statements, and all diagnostic info including the message ids.

Have the backups ever been reloaded to ensure that proper backups have been taken? If not, you have a set fo files with questionable content. No backup process should be trudted until the data on the backup has been reloaded and verified.
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 Viewing executing process in NDM .. q... Debb.Brant IBM Tools 0 Wed Dec 14, 2016 10:55 pm
No new posts 24x7 online logs using DSN1LOGP (simi... SRICOBSAS DB2 3 Thu Aug 18, 2016 11:52 am
No new posts INCLUDE condition questions van bui DFSORT/ICETOOL 1 Thu Jun 30, 2016 9:52 am
No new posts SAS Programming - Basic Questions Techelm All Other Mainframe Topics 3 Fri Mar 18, 2016 10:53 pm
No new posts SQL Order By related question Joseph K Thomas DB2 8 Fri Mar 18, 2016 12:53 pm


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