Other commands
OPERTUNE offers a variety of commands:
- Element commands are described in Element-descriptions
- Operational assist commands are described in Performing-group-buffer-pool-operations
- Group commands are described in Adding-group-profiles.
- Schedule commands are described in Adding-and-copying-a-new-schedule-profile.
- ALTER-commands
- DISPLAY-commands
- Start-and-stop-commands
- MAINT-command
All other OPERTUNE commands are described in this topic. The HISTORY, QUERY ALL, and RESET ALL commands. The HISTORY and QUERY ALL commands are informational. The RESET ALL command allows you to return elements, groups, and schedules to their original values.
HISTORY command
Use the HISTORY command to display a recent audit log of changes made to all of the subsystems under the control of your OPERTUNE. The number of messages returned depends on the Log Buffer Size parameter set in the system profile (see System-profiles).
The command syntax for the HISTORY command is as follows:
The HISTORY command does not allow the specification of the subsystem recognition character because it is not a subsystem command.
Use the QUERY ALL command to display all changes that have been implemented for a specific subsystem. The current status of elements, groups, and schedules along with their original values are provided.
QUERY ALL command
Value | Description |
|---|---|
DB2ssid | Db2 subsystem ID or the name of the Db2 data sharing group to which the command applies. |
opertuneID | The 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) |
RESET ALL command
Use the RESET ALL command to issue a RESET command against the specified subsystem for all implemented elements, groups, and schedules, returning them to their original values. This command is automatically issued for each subsystem when OPERTUNE is stopped.
Value | Description |
|---|---|
DB2ssid | Db2 subsystem ID or the name of the Db2 data sharing group to which the command applies. |
opertuneID | The OPERTUNEsystem profile name (if OPERTUNE is running as a started task) or the batch job name (if OPERTUNE is running as a batch job) |
SHOW ELEMENTS command
Use the SHOW ELEMENTS command to produce a list of the current element values for the target Db2, or to produce a list of only the elements that are different between two Db2 subsystems.
Value | Description |
|---|---|
DB2ssid | The target Db2. If the command is issued without the UNLIKE parameter, all current element values for this subsystem will be returned. If the UNLIKE parameter is specified, only the element values for this subsystem that are different from the element values for DB2ssis2 will be returned (see Sample output from the SHOW ZPARMS UNLIKE command). |
opertuneID | The 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) |
DB2ssid2 | Specify a Db2 subsystem with which to compare the values for the target Db2. No values are returned for this subsystem. |
SHOW ZPARMS command
Use the SHOW ZPARMS command to produce a list of the current ZPARM values for the target Db2, or to produce a list of only the ZPARMs that are different between two Db2 subsystems. You can also show ZPARMs found in specific control blocks or macros.
Value | Description |
|---|---|
DB2ssid | The target Db2. If the command is issued without the UNLIKE parameter, all current ZPARM values for this subsystem will be returned. If the UNLIKE parameter is specified, only the ZPARM values for this subsystem that are different from the ZPARM values for db2-2 will be returned (see Sample output from the SHOW ZPARMS UNLIKE command). |
opertuneID | The 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) |
UNLIKE | Show all ZPARMS that are unlike the values for the target Db2 (db2-2). You must specify a Db2 subsystem if you use this option. |
ALT | Show all ZPARMS that are alterable by using OPERTUNE |
SPRM | Show only the ZPARMS that are found in the DSN6SPRM control block or macro. |
SYSP | Show only the ZPARMS that are found in the DSN6SYSP control block or macro. |
FAC | Show only the ZPARMS that are found in the DSN6FAC control block or macro. |
LOGP | Show only the ZPARMS that are found in the DSN6LOGP control block or macro. |
GRP | Show only the ZPARMS that are found in the DSN6GRP control block or macro. |
DECP | Show only the ZPARMS that are found in the DSN6DECP control block or macro. |
Sample output from the SHOW ZPARMS UNLIKE command
Command ===> SCROLL ===> CSR
Review the response messages below. Commands: FIND
To exit, type End and press Enter. F
Response Messages
IN(DHB3@DDTO) SHOW ZPARMS UNLIKE(DGB1)
BMC31164I DDTO IN(DHB3@DDTO) SHOW ZPARMS UNLIKE(DGB1)
ABIND ENABLE AUTOMATIC REBIND YES
IMMEDWRI IMMEDIATE WRITE INDICATOR NO
ARCALLOC ARCHIVE PRIMARY ALLOCATION 40
ARCALLOC ARCHIVE SECONDARY ALLOCATION 2
ARCALLOC ARCHIVE ALLOCATION UNIT CYL
ARCBLKSZ ARCHIVE DATA SETS BLOCK SIZE 24K
ARCHIVE LOG ARCHIVING SWITCH Y
ARCPREF ARCHIVE DATA SET COPY 1 PREFIX DSNDHB.DHB3.ARCLG1
ARCPREF ARCHIVE DATA SET COPY 2 PREFIX DSNDHB.DHB3.ARCLG2
ARCUNIT ARCHIVE UNIT1 PARAMETER SYSALLDA
ASSIST ASSIST PARALLEL PROCESSING N
BP0 VIRTUAL/MINIMUM BP SIZE 20000
BP0 VP SEQ STEAL THRESHOLD 80
BP0 VP PARALLEL SEQ THRESHOLD 50
BP0 DEF WRITE THRESHOLD 30