Tabelas SYSIBM

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