Controlling the default reply to the query governor inquiry message

 

The system administrator can control whether the interactive user has the option of ignoring the database query inquiry message by using the Change Job (CHGJOB) CL command.

Changes made include the following:

• If a value of *DFT is specified for the INQMSGRPY parameter of the Change Job (CHGJOB) CL command, the interactive user does not see the inquiry messages and the query is canceled immediately.

• If a value of *RQD is specified for the INQMSGRPY parameter of the Change Job (CHGJOB) CL command, the interactive user sees the inquiry and must reply to the inquiry.

• If a value of *SYSRPYL is specified for the INQMSGRPY parameter of the Change Job (CHGJOB) CL command, a system reply list is used to determine whether the interactive user sees the inquiry and whether a reply is necessary. The system reply list entries can be used to customize different default replies based on user profile name, user id, or process names. The fully qualified job name is available in the message data for inquiry message CPA4259. This will allow the keyword CMPDTA to be used to select the system reply list entry that applies to the process or user profile. The user profile name is 10 characters long and starts at position 51. The process name is 10 character long and starts at position 27.

• The following example will add a reply list element that will cause the default reply of C to cancel any requests for jobs whose user profile is 'QPGMR'.

  ADDRPYLE  SEQNBR(56) MSGID(CPA4259) CMPDTA(QPGMR      51) RPY(C)

  The following example will add a reply list element that will cause the default reply of C to cancel any requests for jobs whose process name is 'QPADEV0011'.

  ADDRPYLE  SEQNBR(57) MSGID(CPA4259) CMPDTA(QPADEV0011 27) RPY(C)

 

Parent topic:

Set resource limits with the Predictive Query Governor

 

Related information

Change Job (CHGJOB) command