Bind Package Data

This section of the Explain report is shown if the object being explained is a package.

The information related to the binding of the package, such as package owner, bind time or isolation level, is presented.

This part of the report is only produced in connection with the first SQL statement of the package.

For details on how to specify Explain commands refer to the Report Command Reference.

Explain Report - Package Data Block

This is an example of the Bind Package data section.

LOCATION     : PMODA11
COLLECTION ID: KO2EX520
PACKAGE ID   : DGO@TPG3
VERSION ID   : OMPE_FINAL
CONSIST.TOKEN: X'18C8F8D602A50FF6'
PDSNAME      : D01OMPE.BASE51.TKO2DBRM

OWNER        : PMDEV52              QUOTE        : APOSTROPHE
CREATOR      : XRK                  COMMA        : PERIOD
BIND DATE    : 2016-02-15           HOSTLANG     : ASSEMBLER
BIND TIME    : 18.50.11.670393      CHARSET      : ALPHANUMERIC
CREATE DATE  : 2016-02-15           MIXED        : NO
CREATE TIME  : 18.49.53.347696      DEC31        : NO
QUALIFIER    : PMDEV52              DATA CURRENCY: ALLOW BLOCKING
BASE SIZE    :       5056           SQLERROR     : NOPACKAGE
AVERAGE SIZE :      47760           SOURCE       : DBRM
SYSENTRIES   :          0           PRECOMP. DATE: 2010-07-15
SQL STATEMENT:         17           PRECOMP. TIME: 13.20.55.105599
VALIDATE     : BIND                 VALID        : YES
ISOLATION    : UNCOMMITTED READ     OPERATIVE    : YES
RELEASE      : CHECK PLAN           REOPTIMIZAT. : NO
DEGREE       : 1                    DEFERPREPARE : INHERITED FROM PLAN
KEEP DYNAMIC : DRDA                 DDF PROTOCOL : INHERITED FROM PLAN
TYPE OF PACK.: BIND PACKAGE         OPT_HINT_ID  :
FNCT.RESOLVED: 2016-02-15-18.50.11.550346
      ....5....0....5....0....5....0....5....0....5....0....5....0....5..
PATH: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx