IC88626: DB2PD MAY UNDER THE COVERS RUN ALL DATABASE SCOPE OPTIONS WHEN ONLY ONE OR A FEW OPTIONS WERE REQUESTED

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • When db2pd is run with an option that retrieves a lot of data
    from the server e.g. -tcbstats or -dynamic
    it has to store the data in a local buffer before showing the
    output.
    If this initial buffer is too small, db2pd needs to reallocate
    the buffer.
    The retry logic involved in this has a problem whereby it would
    cause all database scope option of db2pd to be executed.
    This is incorrect as the retry logic should only re-execute the
    options that were passed to db2pd initially.
    
    
    A workaround exists by increasing the initial db2pd buffer size
    by setting an environment variable :  DB2PDBUFSIZE
    e.g.
    
    export DB2PDBUFSIZE=33554432
    ( 32MB )
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * all                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade the DB2 server to V10 Fix Pack 2 or above            *
    ****************************************************************
    

Problem conclusion

  • This problem has first been fixed in V10 Fix Pack 2
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC88626

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-11-27

  • Closed date

    2013-02-11

  • Last modified date

    2013-02-11

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

    IC83325

  • 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

  • RA10 PSN

       UP



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

DB2 for Linux, UNIX and Windows

Software version:

10.1

Reference #:

IC88626

Modified date:

2013-02-11

Translate my page

Machine Translation

Content navigation