IBM Support

PM90671: ADVANCED PARAMETER CM.DBCONNECTPOOLMAX NOT WORKING

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as unreproducible.

Error description

  • There are close to 5000 idle connections being made between the
    DB2 content store and Cognos 10.2. This is causing the DB2
    process to exhaust the memory on the machine (8.00 GB of ram) to
    the point where they must restart the server. For example,
    during a conference call, DB2 was using 4.5 GB's and was
    steadily climbing while Cognos was using around 700 MB - 800 MB.
    This only occurs when Cognos is running. We attempted to use the
    advanced parameter "CM.DbConnectPoolMax" to limit the number of
    connections but it had no effect.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All Users                                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See error description.                                       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to IBM Cognos Business Intelligence 10.2.1 Fix Pack  *
    * 1                                                            *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PM90671

  • Reported component name

    COG INSTALL CON

  • Reported component ID

    5724W12IC

  • Reported release

    A10

  • Status

    CLOSED UR3

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-06-07

  • Closed date

    2013-09-13

  • Last modified date

    2013-09-13

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

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

Fix information

  • Fixed component name

    COG ADMINISTRAT

  • Fixed component ID

    5724W12AD

Applicable component levels

  • RA21 PSN

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCHM94","label":"Administration and Configuration v11x"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"A10","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
13 September 2013