SYSIBM.SYSPACKAGE table
The SYSIBM.SYSPACKAGE table contains a row for every package.
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 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 owner of the creator of the package version. 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. | 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 for the package's DBRM:
|
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 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. 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') and when the package is created using the BIND PACKAGE command the initial version of the package (TYPE='blank'). | 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 |
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 'D' |
Whether remote access for SQL with three-part names is implemented
with DRDA or DB2 private protocol access:
|
G |
FUNCTIONTS | TIMESTAMP
NOT NULL WITH DEFAULT |
Timestamp when the function was resolved. Set by the BIND and REBIND commands, but not by 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 SYSIBM.SYSPACKSTMT 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 |
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 package is used. The LASTUSED value is set to '0001-01-01' in response to any BIND command for the package, and the value is updated whenever the package is used. The REBIND command has no effect on the value of LASTUSED. | G |
CONCUR_ACC_RES | CHAR(1)
NOT NULL |
Indicates the CONCURRENTACCESSRESOLUTION option when the package was bound or rebound:
|
G |
EXTENDED-
INDICATOR |
CHAR(1)
NOT NULL WITH DEFAULT |
The value of the EXTENDEDINDICATOR bind option:
|
G |
INTEGER
NOT NULL |
Not used. | N | |
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:
|
G |
APRETAINDUP | CHAR(1)
NOT NULL WITH DEFAULT |
The value of the APRETAINDUP bind option:
|
G |
CHAR(1)
NOT NULL WITH DEFAULT 'N' |
Not used. | N | |
CHAR(1)
NOT NULL WITH DEFAULT 'Y' |
Not used. | N | |
ORIGIN | CHAR(1) NOT NULL WITH DEFAULT | The
origin of the EXPLAIN records:
|
G |