JCL for BSA database batch utilities

Sample JCL

This is the JCL required to execute batch commands for the administration and maintenance of databases.

+---------------------------------------------------------------+
|jobcard |
|//stepname EXEC PGM=BST01RFF,REGION=0M, |
|// PARM='S=nn,BnnLST=xx,PGM=yyyyyyyy,SIGNON=NO,SVC=zzz' |
|//* |
|//STEPLIB DD DISP=SHR, |
|// DSN=BSA.LOAD |
|// DD DISP=SHR, |
|// DSN=BETAnn.LOAD |
|//SFFPARM DD DISP=SHR, |
|// DSN=BETA.PARMLIB |
|//BnnDEF DD DISP=SHR, |
|// DSN=hlq.DEF |
|//* |
|//BQLIN DD * |
| command1 - |
| command2 - |
| commandn |
|/* |
|//BQLPRINT DD SYSOUT=* |
|//SYSPRINT DD SYSOUT=* |
|//BQLSAVE DD DISP=SHR, |
|// DSN=dsname |
|//* |
+---------------------------------------------------------------+

EXEC statement

//stepname EXEC PGM=BST01RFF,REGION=0M,
// PARM='S=nn,BnnLST=xx,PGM=yyyyyyyy,SIGNON=NO,SVC=zzz'

In the PARM parameter, replace:

  • nn with the product number
  • xx with the identifier of the LST member
  • yyyyyyyy with the name of the batch program
  • zzz with the SVC number

Note: SIGNON=NO is normally required for the BSA database batch utilities.

DD statements

DD name

Description

STEPLIB

Concatenation of the BSA load library and the product load library

SFFPARM

Startup parameter library

BnnDEF

Database definition file of the product

In the sample, replace nn with the product number and hlq with the high-level qualifier of the dataset name.

Note: You can use a DUMMY DD statement when the program signs on to the product started task (SIGNON=YES).

BQLIN

Specifies the instructions that are to be carried out

For a description of the commands, see the descriptions of the individual BSA database batch utilities.

Syntax: The following general syntax rules apply when specifying commands under DD BQLIN:

  • A command can start at any column on the line.
  • Use the continuation sign ( ‑ ) at the end of the line if the command is continued on the following line. The continuation sign must be separated from the rest of the line by at least one blank.

BQLPRINT

Log file used by the program

SYSPRINT

For programs that invoke IDCAMS:

Log file used by IDCAMS

BQLSAVE

For BST05DBL

Sequential file that is used by the program when unloading data from or loading data into the database

Return codes

0

The batch commands have been successfully completed.

16

An error occurred while executing the batch commands (command syntax or statement error).

Information codes

For a list of information codes, see "Database codes" in BSA Messages and Codes.