Query about an IC58999 number

Hi all, Can anyone tell me about this IC number (IC58999) as the link from the RSS feed and from the support search site on IBM is broken (says Page Not Found). I can ring tech support and raise a PMR to get them to send me the detail - so if noone can help I'll do that. >From the RSS feed http://www.ibm.com/software/support/rss/db2/630.xml?rss=s630&ca=rssdb2 IC58999: SELECT STATEMENT WITH NVL AND GROUP BY RESULTS IN -768 ERROR (INCONSISTENT INDEX ) Under a narrow range of conditions you will receive a -768 error: We do a lot of NVL stuff, so I would like to know these conditions. Thanks for the help in advance Jarrod Teale Team Lead - Manufacturing Execution Systems Automation & Process Control Group NZ Technical Fonterra jarrod.teale@fonterra.com <mailto:jarrod.teale@fonterra.com> DISCLAIMER: This email contains confidential information and may be legally privileged. If you are not the intended recipient or have received this email in error, please notify the sender immediately and destroy this email. You may not use, disclose or copy this email or its attachments in any way. Any opinions expressed in this email are those of the author and are not necessarily those of the Fonterra Co-operative Group. http://www.fonterra.com/

On Nov 23, 4:56 pm, "Jarrod Teale" <Jarrod.Te...@fonterra.com> wrote: > Hi all, > Can anyone tell me about this IC number (IC58999) as the link from the > RSS feed and from the support search site on IBM is broken (says Page > Not Found). > I can ring tech support and raise a PMR to get them to send me the > detail - so if noone can help I'll do that. > > >From the RSS feed > > http://www.ibm.com/software/support/rss/db2/630.xml?rss=s630&ca=rssdb2 > IC58999: SELECT STATEMENT WITH NVL AND GROUP BY RESULTS IN -768 ERROR > (INCONSISTENT INDEX ) > Under a narrow range of conditions you will receive a -768 error: > > We do a lot of NVL stuff, so I would like to know these conditions. The bug report contains the information: A customer discovered that under a narrow range of conditions he can consistently get a -768 error with his table -- only when the query involves NVL() and group by functions in the query. -- update statistics has to be run on individual columns rather than in a grouped expression e.g., : -- if the update stats is run as a single parameterized list, the query runs with no errors. UPDATE STATISTICS MEDIUM FOR TABLE tlog(item_descr, item_id, line_number, store_id, trans_code, trans_date, trans_id, trans_type,zoned); .(...the select query runs ok) -- if update stats is run with individual columns, the select query results in a -768 error e.g., update stats run like this casues the avove query to fail: UPDATE STATISTICS MEDIUM FOR TABLE tlog(item_descr);[...] UPDATE STATISTICS MEDIUM FOR TABLE tlog(zoned);(-- after this the select query consistently returns the 768 error.) Other observations: Additional test were done on other releases: 11.10.FC2 - problem reproduces 11.10.FC2W1 - problem reproduces 11.10.FC2W2 - problem does not reproduce 11.10.FC3N067 - problem does not reproduce I don't know whether this was a 64-bit only problem (the versions listed are all 64-bit, but that may not be significant). -=JL=-

If you click on the link in the RSS and sign in to the support website using an IBM ID you will see further information relating to the defect along the lines of what John has displayed above : Under a narrow range of conditions you will receive a -768 error: -- only when the query involves NVL() and group by functions in the query. -- update statistics has to be run on individual columns rather than in a grouped expression If you do not have an IBM ID that you can sign in to the IBM support website with I really do suggest you create one!