ALTER commands
This topic describes the ALTER commands available with OPERTUNE. The ALTER commands are used to change your system profile variables dynamically. These changes remain in effect only while the OPERTUNE system is active. The actual profile values in the system profile are not changed and are in effect the next time OPERTUNE is activated. To issue ALTER commands, the DDTOPER user profile must be authorized for the appropriate ALTER command. For more information on system profile variables, see System profiles.
Use the following syntax to issue the ALTER commands:
opertuneID is the OPERTUNE system profile name (if OPERTUNE is running as a started task) or the job name of the batch job (if OPERTUNE is running as a batch job).
ALTER ACTIVATE command
Use the ALTER ACTIVATE command to add a license for OPERTUNE to access Db2 without cycling OPERTUNE.
ALTER ADDSYS command
Use the ALTER ADDSYS command to place a new Db2 subsystem under the control of OPERTUNE. The specified subsystem must not already be under the control of another OPERTUNE.
Command syntax and parameters
Value | Description |
|---|---|
DB2ssid | Db2 subsystem ID to be added |
ALTER APPLID command
Using the ALTER APPLID command is like recycling OPERTUNE from a VTAM point of view. OPERTUNE stops using the previous APPLID and begins to use the APPLID specified in the command. All previous VTAM commands issued are no longer in effect.
Command syntax and parameters
Value | Description |
|---|---|
applID | The application ID of the VTAM to be used |
-NONE- | VTAM will no longer be used |
ALTER BUFSIZE command
Use the ALTER BUFSIZE command to change the number of records returned by the HISTORY command.
Value | Description |
|---|---|
value | The number of records you want returned by the HISTORY command. Each record uses 80 bytes. Specify a numerical value in the range 10–1000. |
ALTER LOG command
Use the ALTER LOG command to close the current audit log (if any) and open the log specified in the command parameters. The parameters allow for either a SYSOUT or an existing data set.
Command syntax and parameters
Value | Description |
|---|---|
dataSet | The name of the audit log data set to be opened. The data set attributes should be RECFM=FB and LRECL=121. |
class | The SYSOUT class for the log to be opened. |
DB2ssid | The subsystem ID of the Db2 the log will audit. |
ALTER RECINIT command
Use the ALTER RECINIT command to select whether to record the initial values of all subsystem parameters in the audit log.
Command syntax and parameters
Value | Description |
|---|---|
Y | Initial values of all subsystem parameters will be recorded in the audit log. |
N | Initial values of all subsystem parameters will not be recorded in the audit log. |
ALTER REMSYS command
Use the ALTER REMSYS command to remove control of the specified Db2 subsystem from the current OPERTUNE. A RESET ALL is issued for the subsystem before relinquishing control.
Command syntax and parameters
Value | Description |
|---|---|
DB2ssid | The subsystem ID of the Db2 you want to remove. |
ALTER RUSIZE command
Use the ALTER RUSIZE command to change the maximum size of the VTAM buffer that is used to send requests and responses between OPERTUNE systems.
Command syntax and parameters
Value | Description |
|---|---|
size | Specify the maximum size of the VTAM request unit buffer (the buffer used to send requests and responses between OPERTUNE systems). If you specify 0, the default value of 60 KB is used. If your network requires a smaller size, specify it here. The value specified must be a valid VTAM RUSIZE that can be specified as M*2**E: M—the mantissa; must be 8 to 15 E—the exponent; must be 5 to 12 The smallest RUSIZE is 256 (8*2**5) and the largest is 60 KB (15*2**12). If the default value is not used, all OPERTUNEs that communicate with each other must have the same VTAM RUSIZE. |
ALTER SAMPFREQ command
Use the ALTER SAMPFREQ command to specify how often the system checks to see whether a Db2 subsystem has been shut down or brought up. The new sample frequency takes effect after the current sample frequency has cycled.
Command syntax and parameters
Value | Description |
|---|---|
value | Specify the amount of time (in seconds) that you want the system to wait between checks to see if a Db2 subsystem has been shut down or brought up. Specify a numerical value in the range 1–99. |
ALTER SYNCTIME command
Use the ALTER SYNCTIME command to specify the interval that will elapse between issuing BMC31797 messages when a FREE TABLESPACE or STOP TABLESPACE command has not completed. The new value takes effect after the current interval expires.
Command syntax and parameters
Value | Description |
|---|---|
value | Specify the amount of time (in seconds) that you want the system to wait between issuing BMC31797 messages. Specify a numerical value in the range 60–3600 or 0 to prevent BMC31797 messages. |
ALTER SYSLOG command
Use the ALTER SYSLOG command to enable or disable the writing of dialog commands/responses to the SYSLOG.
Command syntax and parameters
Value | Description |
|---|---|
Y | Enable writing of dialog commands and responses to the SYSLOG. |
N | Disable writing of dialog commands and responses to the SYSLOG. |
ALTER TRACE command
Use the ALTER TRACE command to dynamically turn the tracing of user requests on or off for the OPERTUNE started task. Tracing is useful for problem diagnosis. You must specify the DDTTRACE DDNAME in the OPERTUNE started task procedure or batch job JCL to be able to turn on the tracing of user requests. Tracing is turned off by default.
Command syntax and parameters
The ALTER command does not allow specification of the subsystem recognition character because it is not a Db2 command.
Value | Description |
|---|---|
Y | Enable tracing of user requests. |
N | Disable tracing of user requests. |
ALTER UNITVAL command
Use the ALTER UNITVAL command to specify whether unit names are validated when a command changes a unit name.
Value | Description |
|---|---|
Y | Unit names are validated when a command changes a unit name. |
N | Unit names are not validated when a command changes a unit name. |
ALTER XCF command
Use the ALTER XCF command to change the OPERTUNE group name.
Command syntax and parameters
Value | Description |
|---|---|
groupName | The OPERTUNE group name to which the command applies. |
Related topic