Maintain the Database (SARDBASE)

The SARDBASE utility defines and maintains the database. This utility performs the following functions:
view122
The SARDBASE utility defines and maintains the database. This utility performs the following functions:
  • Defines a new database
  • Adds additional space to a database
  • Copies a database
  • Renames a database
  • Deletes a database
  • Provides usage statistics on a database
  • Loads the online library to a database
  • Produces a sequential copy of a master index
  • Recovers a database
  • Unloads a database to a sequential data set
  • Loads a database from a sequential data set
  • Reorganizes the index in a database
  • Verifies data in and corrects problems with a database
  • Defines a banner page library
  • Merges unloaded databases
  • Sets the version number of a database
Job Control Statements
Sample execution JCL can be found in member HAEXDBSE in your CVDEJCL data set.
These job control statements are required to execute SARDBASE:
  • JOB
    Initiates the job.
  • EXEC
    Specifies the program name (PGM=SARDBASE) and, optionally, the high-level name of the database as the PARM parameter (PARM='VIEW.SYSTEM1').
  • STEPLIB DD
    Defines the load library containing SARDBASE.
    If the program resides in a linklist library, omit this statement.
  • SYSPRINT DD
    Defines the sequential output data set (normally SYSOUT) used for listing the control statements and messages.
    If not a SYSOUT data set, DCB=BLKSIZE=nnn must be coded where nnn is a multiple of 133.
  • SARIOUT DD
    Defines a sequential output data set into which the master index is unloaded.
    The attributes of the data set are to be set to RECFM=VB, LRECL=6129, and BLKSIZE=0. The output data set blocksize is to be determined by the output media or can be specified on the JCL DD statement. For tape it will default to 32760 and for 3390 DASD it will default to 27998.
    The DD statement is only required for an IDXOUT operation.
  • SAROLIB DD
    Defines the online library containing the panel, message, and skeleton JCL members to be loaded to the database.
    The DD statement is only required for an OLOAD operation.
  • SARBLIB DD
    Defines the banner page library containing the model banner page members to be loaded to the database.
    The DD statement is only required for a BLOAD operation.
  • SARRECV DD
    Defines the recovery file.
    This statement is only used for a RESTORE operation. While this DD statement is optional, it can be included for a more efficient RESTORE operation.
  • SARTAPE DD
    Defines the archival or DR tape containing the backup of the master index.
    This statement is only used for a RESTORE operation. For a RESTORE operation, the DD statement is optional and is only used when there is no recovery data set or the SARRECV DD statement is missing. When used, the file sequence number of the LABEL parameter must specify the position number of the master index backup on the tape. The position of the backup can be obtained by mapping the tape with the SARTCP program.
    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 that contains the dataset 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. Sample JCL for this function can be found in CVDEJCL member HAEXRCOV.
  • SARLOAD DD
    Defines the device containing the unloaded database.
    This statement is only used for a LOAD operation.
  • SARUNLD DD
    Defines the device to which the database is unloaded.
    This statement is only used for an UNLOAD operation.
  • SARMERGn DD
    Defines the unloaded databases that are to be merged together.
    Replace n with a number from 1 - 9 so that each unloaded database is defined with a unique DD statement. These statements are only used for a MERGE operation.
  • SORTWKnn DD
    Defines temporary sort work disk space, where 
    nn
     typically represents a number from 1 through 6. In most cases, you specify a minimum of three SORTWKnn DD statements. 
    These statements are required for the CONVERT, COPY, LOAD, MERGE, REORG, RESTORE, and VERSION operations.
  • SYSOUT DD
    Defines a sequential output data set (normally SYOUT) to which SORT messages are written.
    The SYSOUT DD statement is needed for the CONVERT, COPY, LOAD, MERGE, REORG (standard), RESTORE, and VERSION operations.
  • SYSIN DD
    Defines a card image data set containing the control statements to be input.
SARDBASE Control Statements
Control statements have the following general syntax:
Syntax:
operation
 
operands
  • The operation can begin in column 1 or may be preceded by one or more blanks.
    Note: 
    A control statement is coded on a single card image between columns 1 and 71.
  • One or more blanks separate the operation and the first operand as well as individual operands.
  • Comments can be included in the control statements by coding an asterisk in column 1 of the card image containing the comment.