Media Problems

The following error message indicates possible media corruption:
view
The following error message indicates possible media corruption:
SARDBI02 PHYSICAL I/O ERROR - ECB=
xxxxxxxx
You can resolve this media error without using SARDBASE RESTORE to restore the database. Instead, you can use either SARDBASE COPY or SARDBASE UNLOAD and LOAD. In most cases, these processes involve minimal data loss.
If you determine there is no media problem, continue with the instructions in Integrity Problems.
Contents
UNLOAD to Tape and LOAD Back
If the database encountered a media problem, do the following steps to recover the database:
  1. Run the SARDBASE utility UNLOAD function to unload the database to tape.
    You can run SARBCH LIST before the UNLOAD and after the LOAD, to account for any data that were lost in the process.
  2. Run the SARDBASE utility ADDDS function to create a new database on alternate DASD.
  3. Run the SARDBASE utility LOAD function to reload the data from tape (from the UNLOAD) to the new database.
  4. If necessary, you can restore lost data from backup tapes using SARTDR TADD.
    The output from SARBCH LIST shows the tape sequence number for each SYSOUT. The tape sequence number is part of the last qualifier of the tape data set name, used by SARTDR TADD.
    Notes: 
    If many SYSOUTs are missing, you can save time by using SARDBASE RESTORE as an alternative to SARTDR TADD.
  5. Restart the
    View
    archival task and resume operation.
COPY Disk-to-Disk
If the database encountered a media problem, do the following steps to recover the database:
  1. Run the SARDBASE utility ADDDS function to create a new database on alternate DASD.
  2. Run the SARDBASE utility COPY function to copy the data from the old (damaged) database into the new database.
    You can run SARBCH LIST on the old and new databases, to account for any data that were lost in the process.
  3. If necessary, you can restore lost data from backup tapes using SARTDR TADD.
    The output from SARBCH LIST shows the tape sequence number for each SYSOUT. The tape sequence number is part of the last qualifier of the tape data set name, used by SARTDR TADD.
    Notes: 
    If many SYSOUTs are missing, you can save time by using SARDBASE RESTORE as an alternative to SARTDR TADD.
  4. After SARTDR TADD has run, run SARDBASE VERIFY to build the alternate index, used for date selection.
  5. Restart the
    View
    archival task and resume operation.