| Nome da coluna |
Tipo de dados |
Descrição |
Uso |
| NAME |
CHAR(8) NOT NULL |
Name of the DBRM. |
G |
| PLNAME |
CHAR(8) NOT NULL |
Name of the application plan. |
G |
| PLCREATOR |
CHAR(8) NOT NULL |
Authorization ID of the owner of the application plan. |
G |
| SEQNO |
SMALLINT NOT NULL |
The sequence number of this row with respect to a statement of the
DBRM (42). The numbering starts with zero. |
G |
| STMTNO |
SMALLINT NOT NULL |
Statement number of the SQL statement in the source program. A
statement number greater than 32767 will be displayed as zero (42). |
G |
| SECTNO |
SMALLINT NOT NULL |
The section number of the section within the DBRM identified in the
NAME column (42). |
G |
| IBMREQD |
CHAR(1) NOT NULL |
Whether the row came from the basic machine-readable material (MRM)
tape:
N No
Y Yes |
G |
| TEXT |
VARCHAR(254) NOT NULL |
The text or portion of the text of the SQL statement. |
G |
| ISOLATION |
CHAR(1) NOT NULL
WITH DEFAULT |
Isolation level for the SQL statement.
R RR (repeatable read)
T RS (read stability)
S CS (cursor stability)
U UR (uncommitted read)
L KEEP UPDATE LOCKS for an RS isolation
X KEEP UPDATE LOCKS for an RR isolation
blank The WITH clause was not specified on this statement.
The isolation level is recorded in SYSPACKAGE.ISOLATION
and in SYSPLAN.ISOLATION. |
G |
| STATUS |
CHAR(1) NOT NULL
WITH DEFAULT |
Status of binding the statement.
A
Distributed - statement uses DB2 private protocol access. The
statement will be parsed and executed at the server using
defaults for input variables during access path selection.
B
Distributed - statement uses DB2 private protocol access. The
statement will be parsed and executed at the server using
values for input variables during access path selection.
C
Compiled - statement was bound successfully using defaults for
input variables during access path selection.
E
Explain - statement is an SQL EXPLAIN statement. The explain
is done at bind time using defaults for input variables during
access path selection.
F
Parsed - statement did not bind successfully and VALIDATE
(RUN) was used. The statement will be rebound at execution
time using values for input variables during access path
selection.
G
Compiled - statement bound successfully, but REOPT is
specified. The statement will be rebound at execution time
using values for input variables during access path selection.
H
Parsed - statement is either a data definition statement or a
statement that did not bind successfully and VALIDATE(RUN)
was used. The statement will be rebound at execution time
using defaults for input variables during access path selection.
Data manipulation statements use defaults for input variables
during access path selection.
I
Indefinite - statement is dynamic. The statement will be bound
at execution time using defaults for input variables during
access path selection.
J
Indefinite - statement is dynamic. The statement will be bound
at execution time using values for input variables during
access path selection.
K Control - CALL statement.
L
Bad - the statement has some allowable error. The bind
continues but the statement cannot be executed.
blank The statement is non-executable, or was bound in a DB2
release prior to Version 5. |
S |
