[Info-ingres] B-Tree corrupt

[Zinndorf, Richard]

Hello,

a customer had the following problem with II 10.2.0 (a64.lnx/100) 15031:

"the table xxxxxx seems to have been corrupted (especially the btree on field group_code)

data could be retrieved  with following query
  select * from xxxxxx  where  group_code >  5093690

but it was not possible to access them directly with the individual values

        select * from  xxxxxx  where  group_code =  5093691
or    select * from  xxxxxx  where  group_code =  5093692

For those  which were before group-code 5093691   the following query was working  fine

         select * from  xxxxxx  where  group_code =  5093690

After recreation of the table with  copydb the application is working fine  again .. "

The problem occurred last Monday. The day before the following maintenance tasks had been performed:
usermod db
optimizedb -zk -uuser db
sysmod db

Does anyone have an idea how it is possible and how to  avoid such issue?
I would be grateful for any hint..

Mit freundlichen Grüßen / Regards
RICHARD ZINNDORF
DXC Technology

Neustadter Str. 62, 68309 Mannheim, Germany
Enhanced Technical Support MSS | p: +49.621.7001.0635 | f: +49.621.7001.6262 | m: +49.173.340.2127 | rzinndorf at csc.com<mailto:rzinndorf at csc.com> | www.csc.com/de<http://www.csc.com/de>

Twitter<http://twitter.com/CSC_DE> | Slideshare<http://www.slideshare.net/CSCDeutschland>

CSC * This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery.  NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose * CSC Deutschland GmbH * Registered Office: Abraham-Lincoln-Park 1, 65189 Wiesbaden, Germany * Board of Directors: Claus Schünemann (Chairman), Josef Ranner * Chairman of the Supervisory Board: William L. Deckelman * Registered in Germany: HRB 11307



CSC Deutschland GmbH - Registered Office: Hewlett-Packard-Str. 1, 61352 Bad Homburg, Germany - Board of Directors: Claus Schunemann (Chairman), Josef Ranner - Chairman of the Supervisory Board: William L. Deckelman - Registered in Wiesbaden: HRB 11307
DXC Technology Company -- This message is transmitted to you by or on behalf of DXC Technology Company or one of its affiliates. It is intended exclusively for the addressee. The substance of this message, along with any attachments, may contain proprietary, confidential or privileged information or information that is otherwise legally exempt from disclosure. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient of this message, you are not authorized to read, print, retain, copy or disseminate any part of this message. If you have received this message in error, please destroy and delete all copies and notify the sender by return e-mail. Regardless of content, this e-mail shall not operate to bind DXC Technology Company or any of its affiliates to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.planetingres.org/pipermail/info-ingres/attachments/20180306/b285056b/attachment.html>