2. Planning for Installation and Use of CA MICS › 2.3 Installation Planning and Parameter Specification › 2.3.1 Database Complex Planning and Parameters › 2.3.1.12 Q&R User Table (MQRUTAB)
2.3.1.12 Q&R User Table (MQRUTAB)
* This member is used to specify the dynamic JCL parameter values
* needed to execute a Q&R query. See the CA MICS Q&R Administration
* Guide for documentation on how to complete these parameters.
*
**********************************************************************
* After modifying this member, you must restart the Q&R Mainframe *
* Server in order for the changes to take effect. *
* *
* The Q&R Build/Refresh Meta utility runs under the authority of the *
* USER assigned to the Q&R Mainframe Server. That USER must be *
* defined in this member. *
* *
* Users for Q&R Query Execution must also be defined in this member *
* when running the Q&R Mainframe Server in full security mode. *
**********************************************************************
*
* The values are specified as KEYWORD=VALUE pairs. Any JCL parameter
* encapsulated with % % within the template MUST be specified here for
* each user defined in this member.
*
* The format is:
* userid followed by keyword=value pairs. The userid MUST be the
* first value, and MUST begin in column 1.
*
* The '?' in the JOBNAME value is a placeholder character that is
* replaced by a digit from an internal counter in the Mainframe
* Server. This enables the Mainframe Server to generate a potentially
* unique jobname to avoid contention with a previously-submitted
* query.
*
* Below is a sample user definition. The JOBNAME, DSNPRFX, STORCLAS
* and PRDPDS keywords must be defined for each Q&R user defined in
* this member.
*
CAMICSQ
JOBNAME=CAMIC?? DSNPRFX=PUBLIC.MICSUSR STORCLAS=WORK
PRDPDS=sharedprefix.MICS.MQR.PUTPDS
*
* Beginning in r12.9, Q&R saves queries into the location
* sharedprefix.MICS.MQR.PUTPDS by default. If you want to use Q&R
* r12.9 with the previous releases of Q&R Query, you can set PRDPDS
* to the data set name used in the previous release.
*
* Below is an example where a value has been added, UACCT to this user
* table AND the keyword has been added to the template by modifying
* the QRDFLT1 sharedprefix.MICS.PROTOLIB member.
*
* When the job is executed, the %UACCT% in the template will be
* replaced by the value of UACCT= defined here. See the Q&R
* Administration Guide for more information.
*
*JOBNAME=CAMIC?? DSNPRFX=PUBLIC.MICSUSR STORCLAS=WORK UACCT=123456789
*PRDPDS=PUBLIC.MICSUSR.PRDQ
*
* Below is an example of the +GLOBAL+ parameter which can be coded
* to specify defaults for keyword values for each user when MQRSEC=Y
* is specified in sp.PARMS(MQRPARMS). By coding the example below,
* you may omit the JOBNAME= parameter on the user definitions.
*
*+GLOBAL+
* JOBNAME=CAMIC??
*
Copyright © 2014 CA.
All rights reserved.
|
|