IBM Support

LI74098: MORE INFORMATION THAN NECESSARY IS COLLECTED WHEN GENERATING DB2SUPPORT WITH OPTIMIZER INFORMATION.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as fixed if next.

Error description

  • The db2support.zip contains information that is not needed when
    investigting optimizer issues.  To reduce the size and amount of
    time to generate the db2support, the '-B' option has been added
    to collect only the optimizer information.
    

Local fix

  • N/A
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Users who need only the optimizer information without        *
    * collecting all db2support data                               *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * When investigating optimizer issues, it is not always        *
    * necessary to collect all information that is gathered into a *
    * standard db2support.zip.  This APAR adds the ability to      *
    * collect only the optimizer information.                      *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * This is first introduced in DB2 v9.1 FP9                     *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    LI74098

  • Reported component name

    DB2 UDE ESE LIN

  • Reported component ID

    5765F4104

  • Reported release

    910

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2008-12-29

  • Closed date

    2010-04-19

  • Last modified date

    2010-04-19

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

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

Fix information

Applicable component levels

  • R910 PSY

       UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"910","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
17 October 2021