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

Questions related to DB2 utilities and Logs


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
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
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

Moderator Emeritus


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

PostPosted: Sun May 17, 2009 1:21 pm
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Capturing logs from spool dd JCL & VSAM 6
No new posts How to collect Job logs from $savers All Other Mainframe Topics 7
No new posts Related to Unit Testing Testing & Performance 2
No new posts Installing sort utilities on hercules... DFSORT/ICETOOL 4
No new posts Strange MNOTE related to BMS using PI... CICS 0
Search our Forums:

Back to Top