Batch Management Overview › Batch Execution Method Comparison

Batch Execution Method Comparison

Two methods of batch execution work with CA Dataquery: Batch Online and Batch Signon. Both methods require submitting JCL that contains the information needed by CA Dataquery to process the query. Batch Online JCL is submitted from the Batch Execution panel and does not require signon or CA Dataquery input statements. Those items are provided by the online system. Batch Sign/On is submitted from another product and submits JCL and CA Dataquery statements as part of the job stream. Batch Sign/On requires control cards that may specify various options and must specify the statements for any query or dialog to be executed. The following table shows significant differences between these two batch methods:

Batch Online SUBMIT

End users can be authorized by the CA Dataquery Administrator to submit batch jobs with an online panel called Batch Execution (DQE40). This panel submits a JCL member containing information needed to process the query. Maintaining the JCL member is a CA Dataquery Administrator responsibility.

Users can submit queries or dialogs for batch execution with a panel in online CA Dataquery and the jobs will execute offline either immediately or at a deferred time. See the CA Dataquery User Guide for user information about batch online.

As the CA Dataquery Administrator, you can create JCL PROCs for users of Batch Online, permitting users to perform variable substitution. See Creating a JCL PROC for Online Submission for details. CA Dataquery Administrator information about Batch Online appears in Batch Online Management.

Batch Sign/On

The Batch Sign/On method requires JCL that submits CA Dataquery statements to the operating system from another product and processes a query or dialog. End users do not commonly use Batch Sign/On Mode. The JCL can be accessed through CA Roscoe IE, CA Vollie, TSO or any other batch job submission method and submitted for CA Dataquery signon and execution. Sign/On mode allows a user who cannot access a CICS monitor to submit batch CA Dataquery jobs through CA Roscoe IE or some other job submission method. See Batch Sign/On Management for more information about batch Sign/On.

Prerequisites for Using Batch CA Dataquery

To use batch CA Dataquery, you must:

1. Tailor the active System Option Table (DQOPTLST) for batch job submission. The following are the DQOPTLST parameters that impact batch job submission:
   • DQDBID=
   • EXPDEV= (z/VSE only)
   • LINPRTL=
   • LINPRTP=
   • RTIMDQE= (SQL Mode only)
   • RTIMDQW=
   • SEQBUFS=
   • SORTWK= (z/VSE only)
   • SUBEXIT=
   • SXBEXIT=
   • URTPRTY=
2. After modifying the DQOPTLST macro, reassemble and link edit it.
3. Place the updated System Option Table into effect in one of the following ways:
   • If the CICS RES count is zero, do a CICS NEWCOPY of DQSYSTBL.
   • If the CICS RES count is not zero, bring down the monitor and bring it back up again.
4. Check the parameters of the DQW (Work Table). See DQW: Work Table for instructions.
5. Set up the JCL members. Sample JCL for executing DQBATCH in Sign/On mode in z/OS and z/VSE is included at the end of this chapter.