SYSPACKCOPY catalog table
The SYSPACKCOPY table contains one row for the previous version of each package and one row for the original version of each package. The schema is SYSIBM.
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. For a trigger package, it is the schema name of the trigger. | G |
NAME |
VARCHAR(128)
NOT NULL |
Name of the package. | G |
CONTOKEN |
CHAR(8)
NOT NULL WITH DEFAULT FOR BIT DATA |
Consistency token for the package. For a package derived from a Db2 DBRM, this is either:
|
S |
OWNER |
VARCHAR(128)
NOT NULL |
Authorization ID of the package owner. For a trigger package, the value is the authorization ID of the owner of the trigger, which is set to the current authorization ID (the plan or package owner for static CREATE TRIGGER statement; the CURRENT SQLID for a dynamic CREATE TRIGGER statement). | G |
CREATOR |
VARCHAR(128)
NOT NULL |
Authorization ID of the creator of the package. The creator is the authorization ID under which the package was bound or rebound. For a trigger package, the value is determined differently. For dynamic SQL, it is the primary authorization ID of the user who issued the CREATE TRIGGER statement. For static SQL, it is the authorization ID of the plan or package owner. | G |
TIMESTAMP |
TIMESTAMP
NOT NULL |
Timestamp indicating when the package was created.For the previous or original copy, this is the timestamp that indicates when the package was created. For the phased-out copy, this is the timestamp indicating when the copy became phased-out. | G |
BINDTIME |
TIMESTAMP
NOT NULL |
Timestamp indicating when the package was last bound. | G |
QUALIFIER |
VARCHAR(128)
NOT NULL |
Implicit qualifier for the unqualified table, view, index, and alias names in the static SQL statements of the package. | G |
PKSIZE |
INTEGER
NOT NULL |
Size of the base section1 of the package, in bytes. | G |
AVGSIZE |
INTEGER
NOT NULL |
Average size, in bytes, of those sections1 of the plan that contain SQL statements processed at bind time. | G |
SYSENTRIES |
SMALLINT
NOT NULL |
Number of enabled or disabled entries for this package in SYSIBM.SYSPKSYSTEM. A value of 0 if all types of connections are enabled. | G |
VALID |
CHAR(1)
NOT NULL |
Whether the package is valid:
|
G |
OPERATIVE |
CHAR(1)
NOT NULL |
Whether the package can be allocated:
|
G |
VALIDATE |
CHAR(1)
NOT NULL |
Whether validity checking can be deferred until run time:
|
G |
ISOLATION |
CHAR(1)
NOT NULL |
Isolation level when the package was last bound or rebound
|
G |
RELEASE |
CHAR(1)
NOT NULL |
The value used for RELEASE when the package was last bound or rebound:
|
G |
EXPLAIN |
CHAR(1)
NOT NULL |
EXPLAIN option specified for the package; that is, whether information on the package's statements was added to the owner of the PLAN_TABLE table:
|
G |
QUOTE |
CHAR(1)
NOT NULL |
SQL string delimiter for SQL statements in the package:
|
G |
COMMA |
CHAR(1)
NOT NULL |
Decimal point representation for SQL statements in package:
|
G |
HOSTLANG |
CHAR(1)
NOT NULL |
Host language, or a value set by the program preparation process:
|
G |
CHARSET |
CHAR(1)
NOT NULL |
Indicates whether the system CCSID for SBCS data was 290 (Katakana) when the program was precompiled:
|
G |
MIXED |
CHAR(1)
NOT NULL |
Indicates if mixed data was in effect when the package's program was precompiled (for more on when mixed data is in effect, see Character strings):
|
G |
DEC31 |
CHAR(1)
NOT NULL |
Indicates whether DEC31 was in effect when the package's program was precompiled (for more on when DEC31 is in effect, see Arithmetic with two decimal operands):
|
G |
DEFERPREP |
CHAR(1)
NOT NULL |
Indicates the CURRENTDATA option when the package was bound or rebound:
|
G |
SQLERROR |
CHAR(1)
NOT NULL |
Indicates the SQLERROR option on the most recent subcommand that bound or rebound the package:
|
G |
REMOTE |
CHAR(1)
NOT NULL |
Source of the package:
|
G |
PCTIMESTAMP |
TIMESTAMP
NOT NULL |
Date and time the application program was precompiled, or '0001-01-01-00.00.00.000000' if the LEVEL precompiler option was used, or if the package came from a non-Db2 location. | 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. RELBOUND should be used instead. |
G |
VERSION |
VARCHAR(122)
NOT NULL |
Version identifier for the package. The value is blank for a trigger package (TYPE='T'). | G |
PDSNAME |
VARCHAR(132)
NOT NULL |
For a locally bound package, the name of the PDS (library) in which the package's DBRM is a member. For a locally copied package, the value in SYSPACKAGE.PDSNAME for the source package. Otherwise, the product signature of the bind requester followed by one of the following:
|
G |
DEGREE |
CHAR(3)
NOT NULL WITH DEFAULT |
The DEGREE option used when the package was last bound:
|
G |
GROUP_MEMBER |
VARCHAR(24)
NOT NULL WITH DEFAULT |
The Db2 data sharing member name of the Db2 subsystem that performed the most recent bind. This column is blank if the Db2 subsystem was not in a Db2 data sharing environment when the bind was performed. | G |
DYNAMICRULES |
CHAR(1)
NOT NULL WITH DEFAULT |
The DYNAMICRULES option used when the package was last bound:
|
G |
DYNAMICRULES (cont.) |
|
||
REOPTVAR |
CHAR(1)
NOT NULL WITH DEFAULT 'N' |
Whether the access path is determined again at execution time using input variable values:
|
G |
DEFERPREPARE |
CHAR(1)
NOT NULL WITH DEFAULT |
Whether PREPARE processing is deferred until OPEN is executed:
|
G |
KEEPDYNAMIC |
CHAR(1)
NOT NULL WITH DEFAULT 'N' |
Whether prepared dynamic statements are to be purged at each commit point:
|
G |
PATHSCHEMAS |
VARCHAR(2048)
NOT NULL WITH DEFAULT |
SQL path specified on the BIND or REBIND command that bound the package. The path is used to resolve unqualified data type, function, and stored procedure names used in certain contexts. If the PATH bind option was not specified, the value in the column is a zero length string; however, Db2 uses the default SQL path. | G |
TYPE |
CHAR(1)
NOT NULL WITH DEFAULT |
Type of package. Identifies how the package is created:
|
G |
DBPROTOCOL |
CHAR(1)
NOT NULL WITH DEFAULT 'P' |
Whether remote access for SQL is implemented with DRDA access or DRDA access with the capability for package-based continuous block fetch:
|
G |
FUNCTIONTS |
TIMESTAMP
NOT NULL WITH DEFAULT |
Timestamp when the function was resolved. This value is set by the BIND and REBIND commands, but not by automatic rebinds (autobind). | G |
OPTHINT |
VARCHAR(128)
NOT NULL WITH DEFAULT |
Value of the OPTHINT bind option. Identifies rows in owner.PLAN_TABLE that are to be used as input to Db2. Refer to the ACCESSPATH column in the SYSPACKSTMT catalog table for information about which statements are using the specified hints. | G |
ENCODING_CCSID |
INTEGER
NOT NULL WITH DEFAULT |
The CCSID corresponding to the encoding scheme or CCSID as specified for the bind option ENCODING. The Encoding Scheme specified on the bind command:
|
G |
IMMEDWRITE |
CHAR(1)
NOT NULL WITH DEFAULT |
Indicates when writes of updated group buffer pool dependent pages are to be done. This option is only applicable for data sharing environments.
|
G |
RELBOUND |
CHAR(1)
NOT NULL WITH DEFAULT |
The release when the package was bound or rebound.
|
G |
CATENCODE |
CHAR(1)
|
Not used. | N |
REMARKS |
VARCHAR(550)
NOT NULL WITH DEFAULT |
A character string provided by the user with the COMMENT statement. | G |
OWNERTYPE |
CHAR(1)
NOT NULL WITH DEFAULT |
Indicates the type of owner
|
G |
ROUNDING |
CHAR(1)
NOT NULL WITH DEFAULT |
The ROUNDING option used when the package was last bound:
|
G |
DISTRIBUTE |
CHAR(1)
NOT NULL WITH DEFAULT 'N' |
Determines if Db2 should gather location names from SQL statements, and create remote packages for the user (This only has effect during local bind):
|
G |
LASTUSED |
DATE
NOT NULL WITH DEFAULT |
The last date that the corresponding objects are used. | G |
CONCUR_ACC_RES |
CHAR(1)
NOT NULL' |
Indicates the CONCURRENTACCESSRESOLUTION option when the package was bound or rebound:
|
G |
EXTENDEDINDICATOR
|
CHAR(1)
NOT NULL WITH DEFAULT |
The value of the EXTENDEDINDICATOR bind option:
|
G |
COPYID |
INTEGER
NOT NULL |
The version of the copy of the package that this row explains:
|
G |
PLANMGMT |
CHAR(1)
NOT NULL WITH DEFAULT |
The value of the PLANMGMT bind option:
|
G |
PLANMGMTSCOPE |
CHAR(1)
NOT NULL WITH DEFAULT |
The value of the PLANMGMTSCOPE bind option:
|
G |
APREUSE |
CHAR(1)
NOT NULL WITH DEFAULT |
The value of the APREUSE bind option:
|
I |
APRETAINDUP |
CHAR(1)
NOT NULL WITH DEFAULT |
The value of the APRETAINDUP bind option:
|
G |
SYSTIMESENSITIVE |
CHAR(1)
NOT NULL WITH DEFAULT 'N' |
The value of the SYSTIMESENSITIVE bind option:
|
G |
RECORDTEMPORALHIST |
CHAR(1)
NOT NULL WITH DEFAULT 'Y' |
Not used. | N |
BUSTIMESENSITIVE |
CHAR(1)
NOT NULL WITH DEFAULT 'N' |
The value of the BUSTIMESENSITIVE bind option:
|
G |
APPLCOMPAT |
VARCHAR(10)
NOT NULL WITH DEFAULT 'Y' |
The value of the APPLCOMPAT bind option:
|
G |
ARCHIVESENSITIVE |
CHAR(1)
NOT NULL WITH DEFAULT 'N' |
The value of the ARCHIVESENSITIVE bind option.
|
G |
EXTSEQNO |
INTEGER
NOT NULL WITH DEFAULT 0 |
Internal use only. | I |
DESCSTAT |
CHAR(1)
NOT NULL WITH DEFAULT |
The value of the DESCSTAT bind option.
|
G |
ORIGIN | CHAR(1) NOT NULL WITH DEFAULT | The origin of the EXPLAIN records:
|
G |
APREUSE_NO_FL | VARCHAR(10) NOT NULL WITH DEFAULT | The function level when the package was bound with APREUSE(NO), or blank if the package was bound before Db2 12, or not determined. This is the default value. | G |
APREUSE_NO_TS | TIMESTAMP NOT NULL WITH DEFAULT | The bind time when the package was bound with APREUSE(NO):
|
G |
CONC_STMT | CHAR(1) NOT NULL WITH DEFAULT 'N' | Whether statement concentration is enabled:
|
G |
FUNCTION_LVL | VARCHAR(10) | The function level of the package. | G |
DEPLEVEL | CHAR(1) NOT NULL WITH DEFAULT 'P' | Dependency level, which is used to indicate if the package contains statement-level dependencies in addition to package-level dependencies.
|
G |