Anyone else have this problem?

Jeremiah Eden

Anyone else have this problem?
We just started getting abend0CC in DSNXGRDS.DSNXOGCM+4A14 at UQ76597 on
2 different queries. An Explain also gets the same abend. DSNXOGCM is
documented as 'GET COST OF MULTIPLE INDEX ACCESS SCAN'. The strange
thing is that it just started occurring, and on different tables. Our
DB2 R710 system is at RSU0309 and hasn't changed or been cycled since
October 2003. There is nothing on IBMLINK that match the symptoms at our
maintenance level, and I have sent the Doc to IBM, but in the meantime.
. . has anyone had this happen and found a solution?

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Jeremiah Eden

Re: Anyone else have this problem?
(in response to Jeremiah Eden)
FYI, APAR PQ83266 was just opened this morning.

APAR Identifier ...... PQ83266 Last Changed ........ 04/01/15
ABEND0CC IN DSNXOGCM+4A14 WHEN RUNNING QUERY ON A TABLE IN A
PARTITIONED TABLESPACE WHERE PAGE RANGE REDUCTION IS POSSIBLE

LOCAL FIX:
To circumvent this problem, try running RUNSTATS to refresh
your statistics.

-----Original Message-----
From: Jeremiah Eden
Sent: Wednesday, January 14, 2004 3:29 PM
To: [login to unmask email]
Subject: Anyone else have this problem?


We just started getting abend0CC in DSNXGRDS.DSNXOGCM+4A14 at UQ76597 on
2 different queries. An Explain also gets the same abend. DSNXOGCM is
documented as 'GET COST OF MULTIPLE INDEX ACCESS SCAN'. The strange
thing is that it just started occurring, and on different tables. Our
DB2 R710 system is at RSU0309 and hasn't changed or been cycled since
October 2003. There is nothing on IBMLINK that match the symptoms at our
maintenance level, and I have sent the Doc to IBM, but in the meantime.
. . has anyone had this happen and found a solution?

------------------------------------------------------------------------
---------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that
page select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences
at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm