SYSIBM.SYSPKSYSTEM table

The SYSIBM.SYSPKSYSTEM table contains zero or more rows for every package. Each row for a given package represents one or more connections to an environment in which the package could be executed.

Column name Data type Description Use
LOCATION
VARCHAR(128)
NOT NULL
 Always contains blanks S
COLLID
VARCHAR(128)
NOT NULL
 Name of the package collection. G
NAME
VARCHAR(128)
NOT NULL
 Name of the package. G
CONTOKEN
CHAR(8)
NOT NULL
FOR BIT DATA
 Consistency token for the package. This is either:
  • The "level" as specified by the LEVEL option when the package's program was precompiled
  • The timestamp indicating when the package's program was precompiled, in an internal format.
 S
SYSTEM
VARCHAR(24)
NOT NULL
 Environment. Values can be:
BATCH
TSO batch
CICS®
Customer Information Control System
DB2CALL
DB2® call attachment facility
DLIBATCH
DLI batch support facility
IMSBMP
IMS™ BMP region
IMSMPP
IMS MPP and IFP region
REMOTE
remote server
 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 LU name for a database server if SYSTEM=REMOTE
  • Either the requester's location (if the product is DB2) or the requester's LU name enclosed in angle brackets if SYSTEM=REMOTE.
  • 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 servers or connections for the indicated environment.

 G
IBMREQD
CHAR(1)
NOT NULL
 A value of Y indicates that the row came from the basic machine-readable material (MRM) tape. For all other values, see Release dependency indicators.

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

 G