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

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 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