Using System State Manager › Create Other Resource and Action Tables › Decide How Many Tables to Define › Sample SQL statement creating a resource table

Sample SQL statement creating a resource table

SQL CREATE TABLE SSM_TBL1
(NAME CHAR(18) UPPER CASE NULL PRIMARY KEY,
CURRENT_STATE CHAR(8) UPPER CASE DEFAULT 'UNKNOWN',
DESIRED_STATE CHAR(8) UPPER CASE DEFAULT 'UNKNOWN',
MODE CHAR(8) UPPER CASE DEFAULT 'ACTIVE',
PREMODE CHAR(8) UPPER CASE DEFAULT 'ACTIVE',
REFMODE CHAR(8) UPPER CASE DEFAULT 'ACTIVE',
ACTMODE CHAR(8) UPPER CASE DEFAULT 'ACTIVE',
SCHEDMODE CHAR(8) UPPER CASE DEFAULT 'ACTIVE',
JOBNAME CHAR(8) UPPER CASE,
TYPE CHAR(18) UPPER CASE,
CHKPOINT_STATE CHAR(8) UPPER CASE DEFAULT 'UNKNOWN',
IPL_STATE CHAR(8) UPPER CASE DEFAULT 'UNKNOWN',
PREREQ VARCHAR(250) UPPER CASE,
MISSING_PREREQ VARCHAR(250) UPPER CASE,
PREV_STATE CHAR(16) UPPER CASE,
INTERNAL_DATA1 HEX(32),
RESOURCE_TEXT VARCHAR(128), optional
PRIMARY_SYSTEM CHAR(8)) optional
PRIMARY_SYSTEM CHAR(8)) optional