| Nome da coluna |
Tipo de dados |
Descrição |
Uso |
| LOCATION |
CHAR(16) NOT NULL |
Always contains blanks |
S |
| COLLID |
CHAR(18) NOT NULL |
Name of the package collection. For a trigger package, it is the schema
name of the trigger. |
G |
| NAME |
CHAR(8) NOT NULL |
Name of the package. |
G |
| CONTOKEN |
CHAR(8) NOT NULL |
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. |
S |
| OWNER |
CHAR(8) 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 packge owner for static CREATE
TRIGGER statement; the current SQLID for a dynamic CREATE TRIGGER
statement). |
G |
| CREATOR |
CHAR(8) 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 |
CHAR(8) 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 section (48) of the package, in bytes. |
G |
| AVGSIZE |
INTEGER NOT NULL |
Average size, in bytes, of those sections (48) 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:
A An ALTER statement changed the description of the table or base table
of a view referred to by the package. 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 |
G |
| OPERATIVE |
CHAR(1) NOT NULL |
Whether the package can be allocated:
N
No; an explicit BIND or REBIND is required before the package
can be allocated.
Y Yes |
G |
| VALIDATE |
CHAR(1) NOT NULL |
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. |
G |
| ISOLATION |
CHAR(1) NOT NULL |
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 |
G |
| RELEASE |
CHAR(1)> NOT NULL |
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. |
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:
N No
Y Yes |
G |
| QUOTE |
CHAR(1) NOT NULL |
SQL string delimiter for SQL statements in the package:
N Apostrophe
Y Quotation mark |
G |
| COMMA |
CHAR(1) NOT NULL |
Decimal point representation for SQL statements in package:
N Period
Y Comma |
G
|
| HOSTLANG |
CHAR(1) NOT NULL |
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(TM))
3
IBM COBOL (Release 2 or subsequent releases)
4 C++
blank For remotely bound packages, or trigger packages (TYPE='T') |
G |
| CHARSET |
CHAR(1) NOT NULL |
Indicates whether the system CCSID for SBCS data was 290 (Katakana) when the program was precompiled:
K Yes
A No |
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" in topic 2.8.1):
N No
Y Yes |
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" in topic 2.20.6. If this option is specified at
precompile time in the form D31.s, where s is a scale from 1 to 9, then
DEC31 is in effect. If this option is specified at precompile time in the
form D15.s, then DEC15 is in effect.
N No
Y Yes |
G |
| DEFERPREP |
CHAR(1) NOT NULL |
Indicates the CURRENTDATA option when the package was bound or
rebound:
A
Data currency is required for all cursors. Inhibit blocking for
A
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. |
G |
| SQLERROR |
CHAR(1) NOT NULL |
Indicates the SQLERROR option on the most recent subcommand that
bound or rebound the package:
C CONTINUE
N NOPACKAGE |
G |
| REMOTE |
CHAR(1) NOT NULL |
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. |
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 intopic D.0. |
G |
| VERSION |
VARCHAR(64) NOT NUL |
Version identifier for the package. The value is blank for a trigger
package (TYPE='T'). |
G |
| PDSNAME |
VARCHAR(44) 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:
° The requester's location name if the product is DB2
° Otherwise, the requester's LU name enclosed in angle brackets; for
example, "<LUSQLDS>." |
G |
| DEGREE |
CHAR(3)NOT NULL
WITH DEFAULT |
The DEGREE option used when the package was last bound:
ANY DEGREE(ANY)
1 or blank DEGREE(1). Blank if the package was migrated. |
G |
| GROUP_MEMBER |
CHAR(8) 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:
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.
For a description of the DYNAMICRULES behaviors, see "Authorization
IDs and dynamic SQL" in topic 2.7.3 |
G |
| REOPTVAR |
CHAR(1) NOT NULL
WITH DEFAULT 'N' |
Whether the access path is determined again at execution time using
input variable values:
N Bind option NOREOPT(VARS) indicates that the access path is
determined at bind time.
Y Bind option REOPT(VARS) indicates that the access path is
determined at execution time for SQL statements with variable
values. |
G |
| DEFERPREPARE |
CHAR(1) NOT NULL
WITH DEFAULT |
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. |
G |
| KEEPDYNAMIC |
CHAR(1) NOT NULL
WITH DEFAULT 'N' |
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. |
G |
| PATHSCHEMAS |
VARCHAR(254) 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 a default SQL path of: SYSIBM, SYSFUN, SYSPROC,
package qualifier. |
G |
| TYPE |
CHAR(1) NOT NULL
WITH DEFAULT |
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. |
G |
| DBPROTOCOL |
CHAR(1) NOT NULL
WITH DEFAULT 'P' |
Whether remote access for SQL with three-part names is implemented
with DRDA or DB2 private protocol access:
D DRDA
P DB2 private protocol |
G |
| FUNCTIONTS |
TIMESTAMPNOT NULL
WITH DEFAULT |
Timestamp when the function was resolved. Set by the BIND and REBIND
commands, but not by AUTOBIND. |
G |
| OPTHINT |
CHAR(8) NOT NULL
WITH DEFAULT |
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. |
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:
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. |
G |
| IMMEDWRITE |
CHAR(1) NOT NULL
WITH DEFAULT |
Indicates when writes of updated
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. |
G |
| RELBOUND |
CHAR(1) NOT NULL
WITH DEFAULT |
The release when the package was
| G |
