ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

View - SARDBASE RESTORE error message

book

Article ID: 226738

calendar_today

Updated On:

Products

View

Issue/Introduction

In trying to restore output from tape to a new db, we encountered the following error message: 

10/15/2021 10:20:23                          CA View Output Archival and Viewin
SARDBASE                                     DataBase Creation and Maintenance
RESTORE
SARDBR04  Requested tape file does not contain index backup

Below is the JCL that was used:

//XXXXXXXX JOB ...
//*********************************************************
//*   RESTORE JOB TO RECOVER DATA FROM TAPE ***************
//*   USE THE LABEL FROM SARTCP AND LATEST TAPESEQ*********
//*********************************************************
//OUT      OUTPUT CLASS=0,DEST=DEST001,FORMS=ABC,DEFAULT=YES,JESDS=ALL
//SARDBASE EXEC PGM=SARDBASE,PARM='VIEW.SYSTEM1'
//STEPLIB  DD  DISP=SHR,DSN=VIEW.CVDELOAD
//SYSPRINT DD  SYSOUT=*,OUTLIM=9999999
//SARTAPE  DD  DISP=SHR,DSN=VIEW.SYSTEM1.SARTAPE.T0013215,
//             LABEL=76106
//SYSUT2   DD  OUTPUT=(*.OUT),SYSOUT=(,)
//SYSIN    DD  *
RESTORE
/*

Environment

Release : 14.0

Component : CA View

Resolution

The following note is in the View SARDBASE RESTORE documentation:

 . Note: Due to IBM JCL limitations, the LABEL parameter cannot exceed 9999. 
             When the file number of the master index exceeds this value, use the SARRCOV utility to create a recovery file. 
              This file contains the data set name of the backup or DR tape and the file number of the master index. 
              Then leave out the SARTAPE DD statement and specify the name of the recovery file on the SARRECV DD statement.

--------------------------------------------------------------------------------------

As the label the client used was LABEL=76106, well beyond the maximum label of 9999, it was suggested that the client do the following:

 . Create a SARRECV file:

//XXXXXXXX JOB ...
//IEFBR14 EXEC PGM=IEFBR14
//DD1 DD DSN=VIEW.SARRECV,DISP=(,CATLG),
// UNIT=SYSDA,VOL=SER=xxxxxx,SPACE=(TRK,1)
//

 . Use the SARRCOV utility to populate the SARRECV file:

//XXXXXXXX JOB ...                                                
//SARRCOV  EXEC PGM=SARRCOV                                       
//STEPLIB  DD  DISP=SHR,DSN=VIEW.CVDELOAD     <=== MODIFY, IF USED
//REPORT   DD  SYSOUT=*                                           
//SYSUDUMP DD  SYSOUT=*                                           
//SARRECV  DD  DISP=SHR,DSN=VIEW.SARRECV                      
//SYSIN    DD  *                                                  
FILESEQ=76106                                                        
VIEW.SYSTEM1.SARTAPE.T0013215
/*                                                                
//   

 . Use the SARRECV file in the RESTORE job:

//XXXXXXXX JOB ...
//SARDBASE EXEC PGM=SARDBASE,PARM='view_hlq'  <=== Modify DB name
//STEPLIB  DD  DISP=SHR,DSN=VIEW.CVDELOAD    <=== Modify, if used
//SYSPRINT DD  SYSOUT=*
//SARRECV  DD  DISP=SHR,DSN=VIEW.SARRECV                      
//SYSIN    DD  *
RESTORE
/*
//