Using Schedule Manager › Override Schedule Manager › System State Manager Resource Tables › SSMSCHED Sample Rule

SSMSCHED Sample Rule

The SSMSCHED sample command rule allows operators or automated procedures to set or display the SCHEDMODE of resources. You must enable the SSMSCHED sample rule before you can begin to use it. Descriptions of the two SSMSCHED commands follow.

Syntax to update the SSM schedule:

SSMSCHED UPDATE
   {RESOURCE(table.resource, . . .)}
   {SCHEDMODE(ACTIVE|INACTIVE)}

This command sets the SCHEDMODE values for each table.resource entry specified in the RESOURCE() list to the value specified on the SCHEDMODE() keyword. For each table.resource entry specified in the RESOURCE() list, the following SQL statement is executed:

UPDATE table SET SCHEDMODE='mode' WHERE NAME LIKE 'resource'

As shown in the above SQL statement, each table value specified must be a literal value; each resource value specified could be any valid value specified on an SQL LIKE keyword. Specify up to twenty table.resource entries in the RESOURCE() list.

Examples:

1. Command (and response) to turn off Schedule Manger control of some resources:

   SSMSCHED UPDATE RESOURCE(CICS_STCTBL.CICS%) SCHEDMODE(INACTIVE)
   OPR1000I SSMSCHED: UPDATE returned RC=00 / SQLCODE=00000 for resource CICS_STCTBL.CICS%
   

2. Command (and response) to turn on Schedule Manager control of a resource:

   SSMSCHED UPDATE RESOURCE(CICS_STCTBL.CICSTEST) SCHEDMODE(ACTIVE)
   OPR1000I SSMSCHED: UPDATE returned RC=00 / SQLCODE=00000 for resource CICS_STCTBL.CICSTEST
   

Syntax to select the SSM schedule:

SSMSCHED SELECT
   {RESOURCE(table.resource,...)}
   [SCHEDMODE(ACTIVE|INACTIVE)]

This command displays the SCHEDMODE values for each table.resource entry specified in the RESOURCE() list. Optionally, you may limit the display to only those resources whose SCHEDMODE value is equal to the value specified on the SCHEDMODE() keyword. For each table.resource entry specified in the RESOURCE() list, the following SQL statement is executed, and the results displayed:

SELECT SCHEDMODE NAME INTO :dmode dname FROM table
       WHERE NAME LIKE 'resource' {AND SCHEDMODE='mode'}

As shown in the previous SQL statement, each table value specified must be a literal value; each resource value specified could be any valid value specified on an SQL LIKE keyword. Specify up to twenty table.resource entries in the RESOURCE() list.

Examples:

1. Command (and response) to display the status of Schedule Manager control of some resources:

   SSMSCHED SELECT RESOURCE(CICS_STCTBL.CICS%)
   OPR1000I SSMSCHED: SELECT returned RC=00 / SQLCODE=00000 for resource  CICS_STCTBL.CICS%
   OPR1000I SSMSCHED:   SCHEDMODE=INACTIVE for resource                   CICS_STCTBL.CICS
   OPR1000I SSMSCHED:   SCHEDMODE=ACTIVE   for resource                   CICS_STCTBL.CICSTEST
   

2. Command (and response) to display only those resources in a table that are under Schedule Manager control:

   SSMSCHED SELECT RESOURCE(CICS_STCTBL.CICS%) SCHEDMODE(ACTIVE)
   OPR1000I SSMSCHED: SELECT returned RC=00 / SQLCODE=00000 for resource   CICS_STCTBL.CICS
   OPR1000I SSMSCHED: SCHEDMODE=ACTIVE for resource                        CICS_STCTBL.CICSTEST