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.
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?
Joined: 23 Nov 2006 Posts: 19270 Location: Inside the Matrix
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.