SYSPLSYSTEM catalog table

The SYSPLSYSTEM table contains zero or more rows for every plan. Each row for a given plan represents one or more connections to an environment in which the plan could be used. The schema is SYSIBM.

Table 1. SYSIBM.SYSPLSYSTEM table column descriptions
Column name Data type Description Use
NAME
VARCHAR(24)
NOT NULL
 Name of the plan. G
SYSTEM
VARCHAR(24)
NOT NULL
 Environment. Values can be:
BATCH
TSO batch
DB2CALL
Db2 call attachment facility
CICS®
Customer Information Control System
DLIBATCH
DLI batch support facility
IMSBMP
IMS BMP region
IMSMPP
IMS MPP or IFP region
 G
ENABLE
CHAR(1)
NOT NULL
 Indicates whether the connections represented by the row are enabled or disabled:
N
Disabled
Y
Enabled
 G
CNAME
VARCHAR(60)
NOT NULL
 Identifies the connection or connections to which the row applies. Interpretation depends on the environment specified by SYSTEM. Values can be:
  • Blank if SYSTEM=BATCH or SYSTEM=DB2CALL
  • The name of a single connection if SYSTEM has any other value

CNAME can also be blank when SYSTEM is not equal to BATCH or DB2CALL. When this is so, the row applies to all connections for the indicated environment.

 G
IBMREQD
CHAR(1)
NOT NULL
 A value of Y indicates that the row was provided with the Db2 product code. For all other values, see Release dependency indicators.

The value in this field is not a reliable indicator of release dependencies.

 G