DB2 Version 9.7 for Linux, UNIX, and Windows

SYSCAT.PACKAGES catalog view

Each row represents a package that has been created by binding an application program.

Table 1. SYSCAT.PACKAGES Catalog View
Column Name	Data Type	Nullable	Description
PKGSCHEMA	VARCHAR (128)		Schema name of the package.
PKGNAME	VARCHAR (128)		Unqualified name of the package.
BOUNDBY	VARCHAR (128)		Authorization ID of the binder and owner of the package.
BOUNDBYTYPE	CHAR (1)		U = The binder and owner is an individual user
OWNER	VARCHAR (128)		Authorization ID of the binder and owner of the package.
OWNERTYPE	CHAR (1)		U = The binder and owner is an individual user
DEFAULT_SCHEMA	VARCHAR (128)		Default schema name used for unqualified names in static SQL statements.
VALID¹	CHAR (1)		N = Needs rebinding V = Validate at run time X = Package is inoperative because some function instance on which it depends has been dropped; explicit rebind is needed Y = Valid
UNIQUE_ID	CHAR (8) FOR BIT DATA		Identifier for a specific package when multiple packages having the same name exist.
TOTAL_SECT	SMALLINT		Number of sections in the package.
FORMAT	CHAR (1)		Date and time format associated with the package. 0 = Format associated with the territory code of the client 1 = USA 2 = EUR 3 = ISO 4 = JIS 5 = LOCAL
ISOLATION	CHAR (2)	Y	Isolation level. CS = Cursor Stability RR = Repeatable Read RS = Read Stability UR = Uncommitted Read
CONCURRENTACCESSRESOLUTION	CHAR (1)	Y	The value of the CONCURRENTACCESSRESOLUTION bind option: U = USE CURRENTLY COMMITTED W = WAIT FOR OUTCOME Blank = Not specified
BLOCKING	CHAR (1)	Y	Cursor blocking option. B = Block all cursors N = No blocking U = Block unambiguous cursors
INSERT_BUF	CHAR (1)		Setting of the INSERT bind option (applies to partitioned database systems). N = Inserts are not buffered Y = Inserts are buffered at the coordinator database partition to minimize traffic among database partitions
LANG_LEVEL	CHAR (1)	Y	Setting of the LANGLEVEL bind option. 0 = SAA1 1 = MIA 2 = SQL92E
FUNC_PATH	CLOB (2K)		SQL path in effect when the package was bound.
QUERYOPT	INTEGER		Optimization class under which this package was bound. Used for rebind operations.
EXPLAIN_LEVEL	CHAR (1)		Indicates whether Explain was requested using the EXPLAIN or EXPLSNAP bind option. P = Package selection level Blank = No Explain requested
EXPLAIN_MODE	CHAR (1)		Value of the EXPLAIN bind option. A = ALL N = No R = REOPT Y = Yes
EXPLAIN_SNAPSHOT	CHAR (1)		Value of the EXPLSNAP bind option. A = ALL N = No R = REOPT Y = Yes
SQLWARN	CHAR (1)		Indicates whether or not positive SQLCODEs resulting from dynamic SQL statements are returned to the application. N = No, they are suppressed Y = Yes
SQLMATHWARN	CHAR (1)		Value of the dft_sqlmathwarn database configuration parameter at bind time. Indicates whether arithmetic and retrieval conversion errors return warnings and null values (indicator -2), allowing query processing to continue whenever possible. N = No, errors are returned Y = Yes, warnings are returned
CREATE_TIME	TIMESTAMP		Time at which the package was first bound.
EXPLICIT_BIND_TIME	TIMESTAMP		Time at which this package was last changed by: BIND REBIND (explicit)
LAST_BIND_TIME	TIMESTAMP		Time at which the package was last changed by: BIND REBIND (explicit) REBIND (implicit)
ALTER_TIME	TIMESTAMP		Time at which this package was last changed by: BIND REBIND (explicit) REBIND (implicit) ALTER PACKAGE
CODEPAGE	SMALLINT		Application code page at bind time; -1 if not known.
COLLATIONSCHEMA	VARCHAR (128)		Schema name of the collation for the package.
COLLATIONNAME	VARCHAR (128)		Unqualified name of the collation for the package.
COLLATIONSCHEMA_ORDERBY	VARCHAR (128)		Schema name of the collation for ORDER BY clauses in the package.
COLLATIONNAME_ORDERBY	VARCHAR (128)		Unqualified name of the collation for ORDER BY clauses in the package.
DEGREE	CHAR (5)		Degree of intra-partition parallelism that was specified when the package was bound. 1 = No parallelism 2-32767 = User-specified limit ANY = Degree determined by the system (no limit specified)
MULTINODE_PLANS	CHAR (1)		N = Package was not bound in a partitioned database environment Y = Package was bound in a partitioned database environment
INTRA_PARALLEL	CHAR (1)		Use of intra-partition parallelism by static SQL statements within the package. F = One or more static SQL statements in this package can use intra-partition parallelism; this parallelism has been disabled for use on a system that is not configured for intra-partition parallelism N = No static SQL statement uses intra-partition parallelism Y = One or more static SQL statements in the package use intra-partition parallelism
VALIDATE	CHAR (1)		Indicates whether validity checking can be deferred until run time. B = All checking must be performed at bind time R = Validation of tables, views, and privileges that do not exist at bind time is performed at run time
DYNAMICRULES	CHAR (1)		B = BIND; dynamic SQL statements are executed with DYNAMICRULES BIND behavior D = DEFINERBIND; when the package is run within a routine context, dynamic SQL statements in the package are executed with DEFINE behavior; when the package is not run within a routine context, dynamic SQL statements in the package are executed with BIND behavior E = DEFINERRUN; when the package is run within a routine context, dynamic SQL statements in the package are executed with DEFINE behavior; when the package is not run within a routine context, dynamic SQL statements in the package are executed with RUN behavior H = INVOKEBIND; when the package is run within a routine context, dynamic SQL statements in the package are executed with INVOKE behavior; when the package is not run within a routine context, dynamic SQL statements in the package are executed with BIND behavior I = INVOKERUN; when the package is run within a routine context, dynamic SQL statements in the package are executed with INVOKE behavior; when the package is not run within a routine context, dynamic SQL statements in the package are executed with RUN behavior R = RUN; dynamic SQL statements are executed with RUN behavior; this is the default
SQLERROR	CHAR (1)		SQLERROR option on the most recent subcommand that bound or rebound the package. C = CONTINUE; creates a package, even if errors occur while binding SQL statements N = NOPACKAGE; does not create a package or a bind file if an error occurs
REFRESHAGE	DECIMAL (20,6)		Timestamp duration indicating the maximum length of time between execution of a REFRESH TABLE statement for a materialized query table (MQT) and when that MQT is used in place of a base table.
FEDERATED	CHAR (1)		N = FEDERATED bind or prep option is turned off U = FEDERATED bind or prep option was not specified Y = FEDERATED bind or prep option is turned on
TRANSFORMGROUP	VARCHAR (1024)	Y	Value of the TRANSFORM GROUP bind option; the null value if a transform group is not specified.
REOPTVAR	CHAR (1)		Indicates whether the access path is determined again at execution time using input variable values. A = Access path is reoptimized for every OPEN or EXECUTE request N = Access path is determined at bind time O = Access path is reoptimized only at the first OPEN or EXECUTE request; it is subsequently cached
OS_PTR_SIZE	INTEGER		Word size for the platform on which the package was created. 32 = Package is a 32-bit package 64 = Package is a 64-bit package
PKGVERSION	VARCHAR (64)		Version identifier for the package.
STATICREADONLY	CHAR (1)		Indicates whether or not static cursors will be treated as READ ONLY. Possible values are: I = Any static cursor that does not contain the FOR UPDATE clause is considered READ ONLY and INSENSITIVE N = Static cursors take on the attributes that would normally be generated for the given statement text and the setting of the LANGLEVEL precompile option Y = Any static cursor that does not contain the FOR UPDATE or the FOR READ ONLY clause is considered READ ONLY
FEDERATED_ASYNCHRONY	INTEGER		Indicates the limit on asynchrony (the number of ATQs in the plan) as a bind option when the package was bound. 0 = No asynchrony n = User-specified limit (32 767 maximum) -1 = Degree of asynchrony determined by the system -2 = Degree of asynchrony not specified For a non-federated system, the value is 0.
ANONBLOCK	CHAR (1)		N = The package is not associated with an anonymous block Y = The package is associated with an anonymous block
OPTPROFILESCHEMA	VARCHAR (128)	Y	Value of the optimization profile schema specified as part of the OPTPROFILE bind option.
OPTPROFILENAME	VARCHAR (128)	Y	Value of the optimization profile name specified as part of the OPTPROFILE bind option.
PKGID	BIGINT		Identifier for the package.
DBPARTITIONNUM	SMALLINT		Number of the database partition where the package was bound.
DEFINER²	VARCHAR (128)		Authorization ID of the binder and owner of the package.
PKG_CREATE_TIME³	TIMESTAMP		Time at which the package was first bound.
APREUSE	CHAR (1)		N = The query compiler will not attempt to reuse access plans Y = The access plans in this package should be reused, meaning that at rebind time the query compiler will attempt to choose plans like the ones currently in the package
EXTENDEDINDICATOR	CHAR (1)		N = Extended indicator variables are not enabled Y = Extended indicator variables are enabled
LASTUSED	DATE		Date when any statement in the package was last executed. This column is not updated for a package associated with an anonymous block. This column is not updated when a statement in the package is executed on an HADR standby database. The default value is '0001-01-01'. This value is updated asynchronously not more than once within a 24 hour period and might not reflect usage within the last 15 minutes.
REMARKS	VARCHAR (254)	Y	User-provided comments, or the null value.
Note: If a function instance with dependencies is dropped, the package is put into an "inoperative" state, and it must be explicitly rebound. If any other object with dependencies is dropped, the package is put into an "invalid" state, and the system will attempt to rebind the package automatically when it is first referenced. The DEFINER column is included for backwards compatibility. See OWNER. The PKG_CREATE_TIME column is included for backwards compatibility. See CREATE_TIME.