POI Command Processors › OPSSMTBL Command Processor—Maintain the Directory Table

OPSSMTBL Command Processor—Maintain the Directory Table

The OPSSMTBL command processor enables you to maintain the directory table that the CA OPS/MVS System State Manager feature uses to manage tables containing information about system resources. With OPSSMTBL, you can modify the directory table, change some of the attributes of the resource information tables in the directory, and return the names of resource information tables into variables or as messages on your TSO terminal.

Alias: STATETBL is currently an accepted alias of OPSSMTBL. This alias can be removed in future releases of CA OPS/MVS.

For more information on the OPSSMTBL command processor and using it with System State Manager, see the User Guide.

This command has the following format:

OPSSMTBL
  [ADD(tablenames)]
  [CREATE]
  [CHANGE(tablenames)]
  [MODE(ACTIVE,mode)]
  [ACTION(actiontablename)]
  [CMDRESP(destination)]
  [DELETE(tablenames)]
  [LIST(tablenames)]
  [NOOUTPUT]
  [POST(tasknames)]
  [PREFIX(SSMTBL,prefix)]
  [UP(newstatename)]
  [DOWN(newstatename)]
  [UNKNOWN(newstatename)]
  [STATETBL(dirtablename)]
  SUBSYS(OPSS,ssid)
  SYSTEM(msfid)
  SYSWAIT(seconds)
  TNGELIGIBLE(YES|NO)

Note: Specifying a tablenames value for the LIST keyword is optional.

ADD

(Optional) The tablenames you specify are 1- to 18-character names of resource information tables to be added to the directory table of the System State Manager. If you specify multiple resource information tables, separate them with commas. When you specify a table, CA OPS/MVS checks to see whether the column names and attributes of that table conform to the System State Manager table requirements; if the table does not meet the requirements, CA OPS/MVS issues an error message.

CREATE

(Optional) If any of the resource information tables specified with the ADD keyword do not exist and you specify the CREATE keyword, CA OPS/MVS creates a model table with the name of the nonexistent table. The model table contains the columns required by the System State Manager. You can then use the SQL INSERT command or the Relational Data Framework (RDF) table editor to insert rows for each resource that you want the System State Manager to manage. The structure of any SSM table created by this keyword always matches the column requirements for the highest supported version of SSM.

CHANGE

(Optional) This keyword specifies the 1- to 18-character names of resource information tables whose processing modes you want to change. If you specify multiple table names, then separate them with commas.

MODE

(Optional) Specified with the ADD or CHANGE keyword, the MODE keyword defines how the System State Manager processes the resource information table that you are adding. Valid mode values are:

ACTIVE

The System State Manager is monitoring this table and acts when a resource changes state. ACTIVE is the default mode.

NOPREREQ

Same as ACTIVE mode, but the System State Manager does not perform prerequisite resource checking.

PASSIVE

The System State Manager is monitoring this table but does nothing when the state of a resource changes.

INACTIVE

The System State Manager is not monitoring this table.

ACTION

(Optional) Used with the ADD or CHANGE keyword, the ACTION keyword specifies the action table that you want to associate with a resource information table.

For the ADD table operation with a specified action table, the column structure of the action table is checked to verify that it conforms to the required standards of the version of the SSM task that is currently running.

CMDRESP

(Optional) This keyword specifies how CA OPS/MVS returns its response to the OPSSMTBL LIST command.

Possible values for destination are TERMINAL, CLIST, REXX, XDQ, and NOWHERE.

• If you specify the default CMDRESP(TERMINAL), CA OPS/MVS displays the output from the OPSSMTBL LIST command on your terminal.
• If you issue the OPSSMTBL LIST command from a TSO/E REXX program or from a CLIST, specify CMDRESP(CLIST) or CMDRESP(REXX) if you want the response to go only into CLIST or REXX variables.
• If you issue OPSSMTBL as an OPS/REXX function, you can specify CMDRESP(XDQ) to route all error messages to the external data queue.

  Note: If you issue the OPSSMTBL command from in an OPS/REXX program through the OI or OX commands, the result is always returned to the REXX external data queue in the terminal message format.

• Specifying CMDRESP(NOWHERE) is the same as specifying the NOOUTPUT keyword. No response is produced.

The optional CMDRESP keyword determines whether the System State Manager creates the response variables described here:

• Variable contains the number of resource information tables listed in the directory table

  CMDRESP(CLIST) variable name: prefix

  CMDRESP(REXX) variable name: prefix.0

• Variable contains the resource information table name

  CMDRESP(CLIST) variable name: prefixn

  CMDRESP(REXX) variable name: prefix.n

• Variable contains the resource table mode

  CMDRESP(CLIST) variable name: prefixnMODE

  CMDRESP(REXX) variable name: prefix_MODE.n

• Variable contains the up-state name

  CMDRESP(CLIST) variable name: prefixnUP

  CMDRESP(REXX) variable name: prefix_UP.n

• Variable contains the down-state name

  CMDRESP(CLIST) variable name: prefixnDOWN

  CMDRESP(REXX) variable name: prefix_DOWN.n

• Variable contains the unknown-state name

  CMDRESP(CLIST) variable name: prefixnUNKNOWN

  CMDRESP(REXX) variable name: prefix_UNKNOWN.n

• Variable contains the action table name

  CMDRESP(CLIST) variable name: prefixnACTION

  CMDRESP(REXX) variable name: prefix_ACTION.n

• Variable contains the TNGELIGIBLE value

  CMDRESP(CLIST) variable name: prefixnTNG

  CMDRESP(REXX) variable name: prefix_TNG.n

Note: The default value for prefix is SSMTBL.

DELETE

(Optional) This keyword specifies the 1- to 18-character names of resource information tables to be deleted from the list of managed tables of the System State Manager. If you specify multiple table names, separate them with commas.

LIST

(Optional) The LIST keyword lists the resource information tables that the System State Manager is currently managing. The optional tablenames value allows you to list the resource information for a specific table or tables.

NOOUTPUT

(Optional) Specify the NOOUTPUT keyword if you do not want a response from the command.

POST

(Optional) The tasknames provided are predefined names of SSM-related subtasks that typically enter a wait state until a recognized event occurs, such as the update of an SSM-monitored column in an SSM resource table.

The POST keyword activates the specified tasks without creating a recognized event. If you specify multiple task names, then separate them with commas. Valid task names are:

• SSM-Post the SSM main task to initiate an SSM resource scan.
• SSMSUB-Post the SSM subtask to execute the associated AOF request rule specified in the parameter SSMSUBRULE.

PREFIX

(Optional) If you issue the OPSSMTBL LIST command with the CMDRESP keyword, CA OPS/MVS generates arrays of CLIST or REXX variables. The variables contain values corresponding to the names and attributes of the resource information tables managed by System State Manager. The PREFIX keyword supplies the prefix for these variables. When CA OPS/MVS generates the variable array, it creates a variable named prefix (SSMTBL by default), which stores a count of resource information table names (as shown in the table in the CMDRESP keyword description).

UP

(Optional) This keyword specifies the new one- to eight-character value that you have chosen to replace the default up-state value of UP.

DOWN

(Optional) This keyword specifies the new one- to eight-character value that you have chosen to replace the default down-state value of DOWN.

UNKNOWN

(Optional) This keyword specifies the new one- to eight-character value that you have chosen to replace the default unknown-state value of UNKNOWN.

STATETBL

(Optional) Use the STATETBL keyword to specify the name of the System State Manager resource directory table. The default is the value of the STATETBL parameter on the system that is the target of the command.

SUBSYS

(Optional) For more information on the SUBSYS keyword, see Specifying a Subsystem ID on a POI Command Processor in this chapter.

SYSTEM

(Optional) For more information on the SYSTEM keyword, see Specifying an MSF ID on a POI Command Processor in this chapter.

Note: You may specify a single system only.

SYSWAIT

(Optional) Used in conjunction with the SYSTEM keyword, the SYSWAIT keyword specifies the number of seconds that the CA OPS/MVS product waits for remote SQL responses. The range is 1 to 300; the default is the MSFSYSWAIT value.

TNGELIGIBLE

(Optional) Allows the TNGELIGIBLE column used by the CA Event Manager to be set to YES or NO when it exists in the resource directory table. If the column does not exist in the table, this keyword is ignored. The default is NO.