If you ran a SARTCP tapemap and the reports are still available on the tape, then SARTDR TADD can be run to add the reports back into the Sysout Selection List.
Since you have the backup tape with the reports that have expired on it, we can recover those reports by running a SARTDR TADD. This job will put the entries back in the Sysout Selection List. You can put an entry for:
1. all the reports that are on the tape
2. all the entries for a particular generation on the tape
3. a particular reportid
The entries are placed in the Sysout Selection List and any that remain expired will fall off with the next backup evaluation. If you use the NGEND and NGENT initialization parameters for retention, increase these values. If you use ERO retention, increase the retention in the ERO table for these reports.
Before the next backup, set the EROPRO parameter to EROPRO=ALL. Run the SARINIT job to store this new value in the database. The next backup will evaluate everything according to the ERO Table and then change the value back to NEW automatically.
The SARINIT JCL for updating the EROPRO initialization parameter follows:
//STEP1 EXEC PGM=SARINIT
//STEPLIB DD DSN=.......CVDELOAD,DISP=SHR
//SYSPRINT DD SYSOUT=*
//SYSIN DD *
NAME=....database HLQ....
EROPRO=ALL
/*
//
The SARTDR TADD JCL for adding the entire tape follows:
//SARTDR EXEC PGM=SARTDR,PARM='APCMTL.VIEW.R120'
//STEPLIB DD DSN=........CVDELOAD,DISP=SHR
//SYSPRINT DD SYSOUT=*
//TAPEIN DD DSN=.......SARTAPE.T0000014,DISP=SHR
//SYSIN DD *
/TADD DDNAME=TAPEIN
/*
//
The SARTDR TADD JCL for adding one or more generations from the tape:
//SARTDR EXEC PGM=SARTDR,PARM='APCMTL.VIEW.R120'
//STEPLIB DD DSN=........CVDELOAD,DISP=SHR
//SYSPRINT DD SYSOUT=*
//TAPEIN DD DSN=.......SARTAPE.T0000014,DISP=SHR
//SYSIN DD *
/TADD DDNAME=TAPEIN GEN=(GEN, )
/*
//
The SARTDR TADD JCL for adding one or more sysouts from the tape:
//SARTDR EXEC PGM=SARTDR,PARM='APCMTL.VIEW.R120'
//STEPLIB DD DSN=........CVDELOAD,DISP=SHR
//SYSPRINT DD SYSOUT=*
//TAPEIN DD DSN=.......SARTAPE.T0000014,DISP=SHR
//SYSIN DD *
/TADD DDNAME=TAPEIN ID=(SYSOUT-ID, )
/*
//
For more information on the SARTDR utility, refer to the chapter on Database Utilities in the CA View Reference Guide.