IBM Support

PM79615: High number of cursors remain open when using Content Store Database

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as fixed if next.

Error description

  • A high number of cursors remain open when cognos uses its
    Content Store Database.?Based on their monitoring, the SQL below
    is the one with too many open cursors. The Cursor Count is 1081.
    ? ?insert into CMTMPIDS (QUERYID, CMID) select 1,o.CMID from
    CM??2 different session but belong to COGNOS user as you can see
    here.?  5311 4600 239 HAVIQA01_COGNOS_USR dev663 JDBC Thin
    Client?  5560 46924 252 HAVIQA01_COGNOS_USR dev663 JDBC Thin
    Client??The DB cursor count continues to increase until it
    reaches the db limit and they are forced to restart cognos.?The
    current cursor count is very high and increasing at 12 cursor
    every day. This will soon hit the DB limit of 1.2k and
    subsequently the application will fail to open any cursor.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All Users                                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See error description.                                       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to IBM Cognos Business Intelligence 10.2 Refresh     *
    * Pack 1  or Upgrade to IBM Cognos Business Intelligence 10.2  *
    * Fix Pack 1 or IBM Cognos Business Intelligence 10.1.1 Fix    *
    * Pack 3                                                       *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PM79615

  • Reported component name

    COG INSTALL CON

  • Reported component ID

    5724W12IC

  • Reported release

    A10

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-12-20

  • Closed date

    2013-06-11

  • Last modified date

    2013-12-16

  • 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:
16 December 2013