Bind Plan Data
This section of the Explain report is shown if the object being explained is a plan or query number for a mini plan created by the bind process. Information related to the binding of the plan, such as plan binder, bind time, or isolation level, is presented.
This part of the report is only produced in connection with the first SQL statement of the plan.
When a plan is explained using OMEGAMON for DB2® Performance Expert explain, the bind-related data is stored in a DB2 table which enables you to compare relevant information for up to three generations of the plan.
If, in a given row, there is a difference among the three columns,
an arrow (
<===) is shown in the rightmost column.
The bottom part of this section shows data for each DBRM and package in the most recent plan generation. The report states the precompilation date and time, programming language, number of SQL statements, single-byte or double-byte character set, use of comma, use of decimal(31), type of source, and the DB2 release when the module was precompiled.
For details on how to specify EXPLAIN commands refer to the Report Command Reference.
Explain Report - Plan Data BlockThis is an example of the Bind Plan Data section.
PLAN NAME: LOXXPLAN LOCATION: SYSDSN5 CHANGES CREATOR : PMDEV BIND DATE: 2002-07-15 BIND TIME: 12:19:59.35 BOUND BY : JEN QUALIFIER: PMDEV BASE SIZE: 2040 AVG. SIZE: 0 CACHESIZE: 1024 PLENTRIES: 1 SYS.ENTR.: 0 SQL STMTS: 7 VALIDATE : BIND ISOLATION: CUR.STAB. VALID : YES OPERATIVE: YES ACQUIRE : USE RELEASE : COMMIT DEFERPREP: NO CURR.SERV: N/P <=== DEGREE : 1 REOPTIM. : NO DYN.RULES: KEEP DYN.: NO SQLRULES : DB2 PATH : DDF PROT.: DRDA FNCT.RES.: 2002-07-15-12 DISCONNCT: EXPLICIT OPTHINTID: STORED BY: PMDEV STORED AT: 2002-01-15 =============================================================================== DBRM/PACK PC-DATE PC-TIME LANG. SQLSTMT CHARSET COMMA DEC31 TYPE REL. --------- ------- ------- ----- ------- ------- ----- ----- ---- ----