SYSIBM.SYSPACKSTMT db2 存储statement的表

xinxuaw231

SYSIBM.SYSPACKSTMT table



The SYSIBM.SYSPACKSTMT table contains one or more rows for each statement in a package.

Column nameData typeDescriptionUseLOCATION

VARCHAR(128)
NOT NULLAlways contains blanksSCOLLID

VARCHAR(128)
NOT NULLName of the package collection.GNAME

VARCHAR(128)
NOT NULLName of the package.GCONTOKEN

CHAR(8)
NOT NULL
FOR BIT DATAConsistency token for the package. 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
  

SSEQNO

INTEGER
NOT NULL Not used. GSTMTNO

SMALLINT
NOT NULLThe statement number of the statement in the source program. A statement number greater than 32767 is stored as zero1 or as a negative number2. If the value is zero, see STMTNOI for the statement number.GSECTNO

SMALLINT
NOT NULLThe section number of the statement.2GBINDERROR

CHAR(1)
NOT NULLWhether an SQL error was detected at bind time:NNoYYesGIBMREQD

CHAR(1)
NOT NULLA value of Y indicates that the row came from the basic machine-readable material (MRM) tape. For all other values, see Release dependency indicators.　　The value in this field is not a reliable indicator of release dependencies.
GVERSION

VARCHAR(122)
NOT NULLVersion identifier for the package.G

VARCHAR(3500)
NOT NULL WITH
DEFAULT
FOR BIT DATAInternal use only.IISOLATION

CHAR(1)
NOT NULL WITH
DEFAULT
Isolation level for the SQL statement:RRR (repeatable read)TRS (read stability)SCS (cursor stability)UUR (uncommitted read)LRS isolation, with a lock-clauseXRR isolation, with a lock-clauseblankThe WITH clause was not specified on this statement. The isolation level is recorded in SYSPACKAGE.ISOLATION and in SYSPLAN.ISOLATION.GSTATUS

CHAR(1)
NOT NULL WITH
DEFAULTStatus of binding the statement:ADistributed - 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.BDistributed - 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.CCompiled - statement was bound successfully using defaults for input variables during access path selection.DDistributed - statement references a remote object using a three-part name. DB2 will implicitly use DRDA® access either because the DBPROTOCOL bind option was not specified (defaults to DRDA), or the bind option DBPROTOCOL(DRDA) was explicitly specified. This option allows the use of three-part names with DRDA access but it requires that the package be bound at the target remote site.EExplain - statement is an SQL EXPLAIN statement. The explain is done at bind time using defaults for input variables during access path selection.FParsed - 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.GCompiled - statement bound successfully, but REOPT is specified. The statement will be rebound at execution time using values for input variables during access path selection.HParsed - 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.IIndefinite - statement is dynamic. The statement will be bound at execution time using defaults for input variables during access path selection.SSTATUS (cont.) JIndefinite - statement is dynamic. The statement will be bound at execution time using values for input variables during access path selection.KControl - CALL statement.LBad - the statement has some allowable error. The bind continues but the statement cannot be executed.MParsed - statement references a table that is qualified with SESSION and was not bound because the table reference could be for a declared temporary table that will not be defined until the package or plan is run. The SQL statement will be rebound at execution time using values for input variables during access path selection.OCompiled for acceleration. The static query was bound successfully for acceleration and will be routed to an accelerator when executed.blankThe statement is non-executable, or was bound in a DB2 release prior to Version 5. ACCESSPATH

CHAR(1)
NOT NULL WITH
DEFAULTFor static statements, indicates if the access path for the statement is based on user-specified optimization hints:HOptimization hints were used.AThe access path was reused because of the APREUSE bind option.blankOne of the following situations:

• The access path was determined without the use of hints, and a previous access path was not reused.
  
• No access path is associated with the statement.
  
• The statement is a dynamic SQL statement
  

GSTMTNOI

INTEGER
NOT NULL WITH
DEFAULTIf the value of STMTNO is zero, the column contains the statement number of the statement in the source program. If both STMTNO and STMTNOI are zero, the statement number is greater than 32767.GSECTNOI

INTEGER
NOT NULL WITH
DEFAULTThe section number of the statement.GEXPLAINABLE

CHAR(1)
NOT NULL WITH
DEFAULTContains one of the following values:YIndicates that the SQL statement can be used with the EXPLAIN function and might have rows describing its access path in the owner.PLAN_TABLE.NIndicates that the SQL statement does not have any rows describing its access path in the owner.PLAN_TABLE.blankIndicates that the SQL statement was bound prior to Version 7.GQUERYNO

INTEGER
NOT NULL WITH
DEFAULT –1The query number of the SQL statement in the source program. SQL statements bound prior to Version 7 have a default value of –1. Statements bound in Version 7 or later use the value specified on the QUERYNO clause on SELECT, UPDATE, INSERT, DELETE, EXPLAIN, DECLARE CURSOR, or REFRESH TABLE statements. If the QUERYNO clause is not specified, the query number is set to the statement number.GROWID

ROWID
NULL GENERATED
ALWAYSROWID column, created for the lob columns in this table.GSTMT_ID

BIGINT
NOT NULLA unique statement identifier.GSTATEMENT

CLOB(2M)
NOT NULL
WITH DEFAULTThe complete text for the SQL statement that the row represents.G

BLOB(2M)
NOT NULL
WITH DEFAULTInternal use only.I
1 Rows in which the value of SEQNO, STMTNO, and SECTNO are zero are for internal use.
2 To convert a negative STMTNO to a meaningful statement number that corresponds to your precompile output, add 65536 to it. For example, -26472 is equivalent to +39064 (-26472 + 65536).