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 Block

This 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.
 --------- -------    -------  ----- -------  -------   ----- ----- ----  ----