| Nome da coluna |
Tipo de dados |
Descrição |
Uso |
| NAME |
CHAR(8) NOT NULL |
Name of the application plan. |
G |
| CREATOR |
CHAR(8) NOT NULL |
Authorization ID of the owner of the application plan. |
G |
| BINDDATE |
CHAR(6) NOT NULL |
The date on which the plan was last bound, in the form yymmdd. |
G |
| VALIDATE |
CHAR(1) NOT NULL |
Whether validity checking can be deferred until run time:
B All checking must be performed during BIND.
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 for the plan:
R RR (repeatable read)
T RS (read stability)
S CS (cursor stability)
U UR (uncommitted read)
|
G |
| VALID |
CHAR(1) NOT NULL |
Whether the application plan is valid:
A The description of the table or base table of a view referenced by the
application plan was changed by the ALTER TABLE statement. The
change did not require the invalidation of the application plan.
H The description of the table or base table of a view referenced by the
application plan was changed by the ALTER TABLE statement. The
change will invalidate the plan for a DB2 release prior to Version 5.
N No
Y Yes |
G |
| OPERATIVE |
CHAR(1) NOT NULL |
Whether the application plan can be allocated:
N No; an explicit BIND or REBIND is required before the plan can be
allocated
Y Yes |
G |
| BINDTIME |
CHAR(8) NOT NULL |
Time of the BIND in the form hhmmssth. |
G |
| PLSIZE |
INTEGER NOT NULL |
Size of the base section (41) of the plan, in bytes. |
G |
| IBMREQD |
CHAR(1) NOT NULL |
Whether the row came from the basic machine-readable material (MRM)
tape:
N No
Y Yes
B V1R3 dependency indicator; not from MRM tape
C V2R1 dependency indicator; not from MRM tape
D V2R2 dependency indicator; not from MRM tape
E V2R3 dependency indicator; not from MRM tape
F V3R1 dependency indicator; not from MRM tape
G V4 dependency indicator; not from MRM tape
H V5 dependency indicator; not from MRM tape |
G |
| AVGSIZE |
INTEGER NOT NULL |
Average size, in bytes, of those sections (41) of the plan that contain SQL
statements processed at bind time. |
G |
| ACQUIRE |
CHAR(1) NOT NULL |
When resources are acquired:
A At allocation
U At first use |
G |
| RELEASE |
CHAR(1) NOT NULL |
When resources are released:
C At commit
D At deallocation
|
G |
| |
CHAR(1) NOT NULL |
Not used |
N |
| |
CHAR(1) NOT NULL |
Not used |
N |
| |
CHAR(1) NOT NULL |
Not used |
N |
| EXPLAN |
CHAR(1) NOT NULL |
EXPLAIN option specified for the plan; that is, whether information on
the plan's statements was added to the owner's PLAN_TABLE table:
N No
Y Yes |
G |
| EXPREDICATE |
CHAR(1) NOT NULL |
Indicates the CURRENTDATA option when the plan was bound or
rebound:
B Data currency is not required for ambiguous cursors. Allow blocking
for ambiguous cursors.
C Data currency is required for ambiguous cursors. Inhibit blocking for
ambiguous cursors.
N Blocking is inhibited for ambiguous cursors, but the plan was created
before the CURRENTDATA option was available. |
G |
| BOUNDBY |
CHAR(8) NOT NULL
WITH DEFAULT |
Primary authorization ID of the binder of the plan. |
G |
| QUALIFIER |
CHAR(8) NOT NULL
WITH DEFAULT |
Implicit qualifier for the unqualified table, view, index, and alias names
in the static SQL statements of the plan. |
G |
| CACHESIZE |
SMALLINT NOT NULL
WITH DEFAULT |
Size, in bytes, of the cache to be acquired for the plan. A value of zero
indicates that no cache is used. |
G |
| PLENTRIES |
SMALLINT NOT NULL
WITH DEFAULT |
Number of package list entries for the plan. The negative of that number
if there are rows for the plan in SYSIBM.SYPACKLIST but the plan was
bound in a prior release after fallback. |
G |
| DEFERPREP |
CHAR(1) NOT NULL
WITH DEFAULT |
Whether the package was last bound with the DEFER(PREPARE) option:
N No
Y Yes |
G |
| CURRENTSERVER |
CHAR(16) NOT NULL
WITH DEFAULT |
Location name specified with the CURRENTSERVER option when the
plan was last bound. Blank if none was specified, implying that the first
server is the local DB2 subsystem. |
G |
| SYSENTRIES |
SMALLINT NOT NULL
WITH DEFAULT |
Number of rows associated with the plan in SYSIBM.SYSPLSYSTEM. The
negative of that number if such rows exist but the plan was bound in a
prior release after fallback. A negative value or zero means that all
connections are enabled. |
G |
| DEGREE |
CHAR(3) NOT NULL
WITH DEFAULT |
The DEGREE option used when the plan was last bound:
ANY DEGREE(ANY)
1 or blank DEGREE(1). Blank if the plan was migrated. |
G |
| SQLRULES |
CHAR(1) NOT NULL
WITH DEFAULT |
The SQLRULES option used when the plan was last bound:
D or blank SQLRULES(DB2)
S
SQLRULES(STD)
blank A migrated plan |
G |
| DISCONNECT |
CHAR(1) NOT NULL
WITH DEFAULT |
The DISCONNECT option used when the plan was last bound:
E or blank DISCONNECT (EXPLICIT)
A
DISCONNECT (AUTOMATIC)
C
DISCONNECT (CONDITIONAL)
blank a migrated plan. |
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 |
B
Dynamic SQL statements are handled like static SQL
statements at run time.
blank Dynamic SQL statements are handled like
dynamic SQL
statements at run time. |
G |
| BOUNDTS |
TIMESTAMP NOT NULL
WITH DEFAULT |
Time when the plan was bound. |
G |
| REOPTVAR |
CHAR(1) NOT NULL 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 |
| KEEPDYNAMIC |
CHAR(1) NOT NULL 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 or rollback.
Y The bind option is KEEPDYNAMIC(YES). Prepared dynamic SQL
statements are kept past commit or rollback. |
G |
