IBM Support

IC79495: DB2EXFMT OUTPUT DOES NOT SHOW TO / FROM SUBSECTION LINE ON EACH TQ OPERATOR. THIS MAKE CORRELATING DB2EXFMT OUTPUT TO SNAPSHOTS

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • This APAR adds information about the runtime section to the
    explain_argument table for "current explain mode" settings of
    "explain",  "yes" and "reopt", and the "explain" bind options
    "yes", "all" and "reopt". With any of these explain settings,
    explain will gather information during the section code
    generation phase of optimization and add it to the explain
    tables. This makes matching up runtime section information to
    the explain generated plan much easier. The information will
    show up in the db2exfmt output under each DPF Table Queue
    operator as follows:
    
    TQNUMBER: (Runtime Table Queue number)
    1
    TQSECNFM: (Runtime Table Queue Receives From Section #)
    1
    TQSECNTO: (Runtime Table Queue Sends to Section #)
    0
    
    Take note that using the explain statement (explain plan for
    .... sql query ... ) does not generate a runtime section, and
    thus will not generate these new explain arguments.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * DPF users of DB2 for Linux, Unix, and Windows                *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * This APAR adds information about the runtime section to the  *
    *                                                              *
    * explain_argument table for "current explain mode" settings   *
    * of                                                           *
    * "explain",  "yes" and "reopt", and the "explain" bind        *
    * options                                                      *
    * "yes", "all" and "reopt". With any of these explain          *
    * settings,                                                    *
    * explain will gather information during the section code      *
    *                                                              *
    * generation phase of optimization and add it to the explain   *
    *                                                              *
    * tables. This makes matching up runtime section information   *
    * to                                                           *
    * the explain generated plan much easier. The information will *
    *                                                              *
    * show up in the db2exfmt output under each DPF Table Queue    *
    *                                                              *
    * operator as follows:                                         *
    *                                                              *
    *                                                              *
    *                                                              *
    * TQNUMBER: (Runtime Table Queue number)                       *
    *                                                              *
    * 1                                                            *
    *                                                              *
    * TQSECNFM: (Runtime Table Queue Receives From Section #)      *
    *                                                              *
    * 1                                                            *
    *                                                              *
    * TQSECNTO: (Runtime Table Queue Sends to Section #)           *
    *                                                              *
    * 0                                                            *
    *                                                              *
    *                                                              *
    *                                                              *
    * Take note that using the explain statement (explain plan for *
    *                                                              *
    * .... sql query ... ) does not generate a runtime section,    *
    * and                                                          *
    * thus will not generate these new explain arguments.          *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade the DB2 for Linux, Unix and Windows server to        *
    * Version 9.7, fixpack 6 or later.                             *
    ****************************************************************
    

Problem conclusion

  • Upgrade the DB2 for Linux, Unix and Windows server to Version
    9.7, fixpack 6 or later.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC79495

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-11-01

  • Closed date

    2012-06-05

  • Last modified date

    2012-06-05

  • APAR is sysrouted FROM one or more of the following:

    IC66160

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R950 PSN

       UP

  • R970 PSN

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.7","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
05 June 2012