DBPedias

All your database knowledge are belong to you

DB2 zOS

SYSIBM.SYSPACKAGE (V8)

Description: Contains a row for every package.

Tablespace: SYSPKAGE

Indexes(Fields):
DSNKKX01(LOCATION.COLLID.NAME.VERSION)
DSNKKX02(LOCATION.COLLID.NAME.CONTOKEN)

Column name Description Data type
LOCATION Always contains blanks
NOT NULL
COLLID Name of the package collection. For a trigger package, it is the schema name of the trigger.
NOT NULL
NAME Name of the package.
NOT NULL
CONTOKEN Consistency token for the package. For a package derived from a DB2 DBRM, 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.

NOT NULL WITH
DEFAULT
FOR BIT DATA
OWNER 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).
NOT NULL
CREATOR 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.
NOT NULL
TIMESTAMP Timestamp indicating when the package was created.
NOT NULL
BINDTIME Timestamp indicating when the package was last bound.
NOT NULL
QUALIFIER Implicit qualifier for the unqualified table, view, index, and alias names in the static SQL statements of the package.
NOT NULL
PKSIZE Size of the base section of the package, in bytes.
NOT NULL
AVGSIZE Average size, in bytes, of those sections of the plan that contain SQL statements processed at bind time.
NOT NULL
SYSENTRIES Number of enabled or disabled entries for this package in SYSIBM.SYSPKSYSTEM. A value of 0 if all types of connections are enabled.
NOT NULL
VALID Whether the package is valid: ; A
An ALTER statement changed the description of the table or base table of a view referred to by the package. For a CREATE INDEX statement involving data sharing, VALID is also marked as "A". The changes do not invalidate the package.
H
An ALTER TABLE statement changed the description of the table or base table of a view referred to by the package. For releases of DB2 prior to V5R1, the change invalidates the package.
N
No
Y
Yes

NOT NULL
OPERATIVE Whether the package can be allocated: ; N
No; an explicit BIND or REBIND is required before the package can be allocated.
Y
Yes

NOT NULL
VALIDATE Whether validity checking can be deferred until run time: ; B
All checking must be performed at bind time.
R
Validation is done at run time for tables, views, and privileges that do not exist at bind time.

NOT NULL
ISOLATION Isolation level when the package was last bound or rebound ; R
RR (repeatable read)
S
CS (cursor stability)
T
RS (read stability)
U
UR (uncommitted read)
blank
Not specified, and therefore at the level specified for the plan executing the package

NOT NULL
RELEASE The value used for RELEASE when the package was last bound or rebound: ; C
Value used was COMMIT.
D
Value used was DEALLOCATE.
blank
Not specified, and therefore the value specified for the plan executing the package.

NOT NULL
EXPLAIN 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: ; N
No
Y
Yes

NOT NULL
QUOTE SQL string delimiter for SQL statements in the package: ; N
Apostrophe
Y
Quotation mark

NOT NULL
COMMA Decimal point representation for SQL statements in package: ; N
Period
Y
Comma

NOT NULL
HOSTLANG Host language for the package's DBRM: ; B
Assembler language
C
OS/VS COBOL
D
C
F
Fortran
P
PL/I
2
VS COBOL II or IBM COBOL Release 1 (formerly called COBOL/370™)
3
IBM COBOL (Release 2 or subsequent releases)
4
C++
blank
For remotely bound packages, or trigger packages (TYPE='T')

NOT NULL
CHARSET Indicates whether the system CCSID for SBCS data was 290 (Katakana) when the program was precompiled: ; K
Yes
A
No

NOT NULL
MIXED Indicates if mixed data was in effect when the package's program was precompiled: ; N
No
Y
Yes

NOT NULL
DEC31 Indicates whether DEC31 was in effect when the package's program was precompiled: ; N
No
Y
Yes

NOT NULL
DEFERPREP Indicates the CURRENTDATA option when the package was bound or rebound: ; A
Data currency is required for all cursors. Inhibit blocking for all cursors.
B
Data currency is not required for ambiguous cursors.
C
Data currency is required for ambiguous cursors.
blank
The package was created before the CURRENTDATA option was available.

NOT NULL
SQLERROR Indicates the SQLERROR option on the most recent subcommand that bound or rebound the package: ; C
CONTINUE
N
NOPACKAGE

NOT NULL
REMOTE Source of the package: ; C
Package was created by BIND COPY.
D
Package was created by BIND COPY with the OPTIONS(COMMAND) option.
K
The package was copied from a package that was originally bound on behalf of a remote requester.
L
The package was copied with the OPTIONS(COMMAND) option from a package that was originally bound on behalf of a remote requester.
N
Package was locally bound from a DBRM.
Y
Package was bound on behalf of a remote requester.

NOT NULL
PCTIMESTAMP 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.
NOT NULL
IBMREQD A value of Y indicates that the row came from the basic machine-readable material (MRM) tape.
NOT NULL
VERSION Version identifier for the package. The value is blank for a trigger package (TYPE='T').
NOT NULL
PDSNAME 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: * The requester's location name if the product is DB2
  • Otherwise, the requester's LU name enclosed in angle brackets; for example, "<LUSQLDS>".

NOT NULL
DEGREE The DEGREE option used when the package was last bound: ; ANY
DEGREE(ANY)
1 or blank
DEGREE(1). Blank if the package was migrated.

NOT NULL WITH
DEFAULT
GROUP_MEMBER 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.
NOT NULL WITH
DEFAULT
DYNAMICRULES The DYNAMICRULES option used when the package was last bound: ; B
BIND. Dynamic SQL statements are executed with DYNAMICRULES bind behavior.
D
DEFINEBIND. When the package is run under an active stored procedure or user-defined function, dynamic SQL statements in the package are executed with DYNAMICRULES define behavior.
When the package is not run under an active stored procedure or 
       user-defined function, dynamic SQL statements in the package are
       executed with DYNAMICRULES bind behavior.
E
DEFINERUN. When the package is run under an active stored procedure or user-defined function, dynamic SQL statements in the package are executed with DYNAMICRULES define behavior.
When the package is not run under an active stored procedure or 
       user-defined function, dynamic SQL statements in the package are
       executed with DYNAMICRULES run behavior.
H
INVOKEBIND. When the package is run under an active stored procedure or user-defined function, dynamic SQL statements in the package are executed with DYNAMICRULES invoke behavior.
When the package is not run under an active stored procedure or 
       user-defined function, dynamic SQL statements in the package are
       executed with DYNAMICRULES bind behavior.
I
INVOKERUN. When the package is run under an active stored procedure or user-defined function, dynamic SQL statements in the package are executed with DYNAMICRULES invoke behavior.
When the package is not run under an active stored procedure or 
       user-defined function, dynamic SQL statements in the package are
       executed with DYNAMICRULES run behavior.
R
RUN. Dynamic SQL statements are executed with DYNAMICRULES run behavior.
blank
DYNAMICRULES is not specified for the package. The package uses the DYNAMICRULES value of the plan to which the package is appended at execution time.

NOT NULL WITH
DEFAULT
REOPTVAR Whether the access path is determined again at execution time using input variable values: ; N
Bind option REOPT(NONE) indicates that the access path is determined at bind time.
Y
Bind option REOPT(ALWAYS) indicates that the access path is determined at execution time for SQL statements with variable values.
1
Bind option REOPT(ONCE) indicates that the access path is determined only once at execution time, using the first set of input variable values, regardless of how many times the same statement is executed.

NOT NULL WITH
DEFAULT 'N'
DEFERPREPARE Whether PREPARE processing is deferred until OPEN is executed: ; N
Bind option NODEFER(PREPARE) indicates that PREPARE processing is not deferred until OPEN is executed.
Y
Bind option DEFER(PREPARE) indicates that PREPARE processing is deferred until OPEN is executed.
blank
Bind option not specified for the package. It is inherited from the plan.

NOT NULL WITH
DEFAULT
KEEPDYNAMIC Whether prepared dynamic statements are to be purged at each commit point: ; N
The bind option is KEEPDYNAMIC(NO). Prepared dynamic SQL statements are destroyed at commit.
Y
The bind option is KEEPDYNAMIC(YES). Prepared dynamic SQL statements are kept past commit.

NOT NULL WITH
DEFAULT 'N'
PATHSCHEMAS 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 a default SQL path of: SYSIBM, SYSFUN, SYSPROC, .
NOT NULL WITH
DEFAULT
TYPE Type of package. Identifies how the package was created: ; blank
BIND PACKAGE command created the package.
T
CREATE TRIGGER statement created the package, and the package is a trigger package.

NOT NULL WITH
DEFAULT
DBPROTOCOL Whether remote access for SQL with three-part names is implemented with DRDA or DB2 private protocol access: ; D
DRDA
P
DB2 private protocol

NOT NULL WITH
DEFAULT 'P'
FUNCTIONTS Timestamp when the function was resolved. Set by the BIND and REBIND commands, but not by AUTOBIND.
NOT NULL WITH
DEFAULT
OPTHINT Value of the OPTHINT bind option. Identifies rows in the authid.PLAN_TABLE to be used as input to the optimizer. Contains blanks if no rows in the authid.PLAN_TABLE are to be used as input.
NOT NULL WITH
DEFAULT
ENCODING_CCSID The CCSID corresponding to the encoding scheme or CCSID as specified for the bind option ENCODING. The Encoding Scheme specified on the bind command: ; ccsid
The specified or derived CCSID.
0
The default CCSID as specified on panel DSNTIPF at installation time. Used when the package was bound prior to Version 7.

NOT NULL WITH
DEFAULT
IMMEDWRITE Indicates when writes of updated group buffer pool dependent pages are to be done. This option is only applicable for data sharing environments. ; N
Bind option IMMEDWRITE(NO) indicates normal write activity is done.
Y
Bind option IMMEDWRITE(YES) indicates that immediate writes are done for updated group buffer pool dependent pages.
1
Bind option IMMEDWRITE(PH1) indicates that updated group buffer pool dependent pages are written at or before phase 1 commit.
blank
A migrated package.

NOT NULL WITH
DEFAULT
RELBOUND The release when the package was bound or rebound. ; blank
Bound prior to Version 7
K
Bound on Version 7

NOT NULL WITH
DEFAULT
Not used.
REMARKS A character string provided by the user with the COMMENT statement.
NOT NULL WITH
DEFAULT

Adapted from material found in the IBM DB2 Universal Database for z/OS V8 SQL Reference (SC18-7426-02).

Retrieved from "http://dbpedias.com/w/index.php?title=DB2_zOS:SYSIBM.SYSPACKAGE_(V8)&oldid=21994"