Skip to Content

Issuing the QUERY SCHEDULE command

Use the QUERY SCHEDULE command to see which schedule, if any, is in effect. If a schedule is in effect, the current status of the individual elements are shown.

You can issue the SET SCHEDULE command from the Profile Selection List panel or from the Free Form panel.

To issue the QUERY SCHEDULE command from the Profile Selection List panel

  1. To determine which schedules are in effect and list the current status of their individual elements, type Y in the Issue QUERY command field on the Profile Selection List panel.
  2. To determine if a specific schedule profile is in effect and list the current status of its individual elements, type Q in the Act field next to the group name on the Profile Selection List panel.
  3. Press Enter. The Command Confirmation panel is displayed.
  4. To issue the command, type 1 in the selection field and press Enter. To cancel the command, type 2 in the selection field and press Enter.

To issue the QUERY SCHEDULE command from the Free Form panel

Use the following syntax:

image2018-12-27_14-23-24.png

Value

Description

DB2ssid

Db2 subsystem ID or the name of the Db2 data sharing group to which the command applies.

opertuneID

OPERTUNE system profile name (if OPERTUNE is running as a started task) or the batch job name (if OPERTUNE is running as a batch job).

scheduleName

The name of the schedule profile to which the QUERY command applies

Example

To query the schedule profiles in OPERTUNE DDTA, issue the following command from the Free Form panel:

IN(DB2A@DDTA) QUERY SCHEDULE


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

OPERTUNE for DB2 13.1