<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Helv;
panose-1:2 11 6 4 2 2 2 3 2 4;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 2.0cm 70.85pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="DE" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal">Hello, <o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span lang="EN-US">a customer had the following problem with II 10.2.0 (a64.lnx/100) 15031:<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">“</span><span lang="EN-US" style="font-size:10.0pt;font-family:"Arial",sans-serif">the table xxxxxx seems to have been corrupted (especially the btree on field group_code)</span><span lang="EN-US" style="font-size:10.0pt">
<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt"><br>
</span><span lang="EN-US" style="font-size:10.0pt;font-family:"Arial",sans-serif">data could be retrieved with following query
</span><span lang="EN-US" style="font-size:10.0pt"><br>
</span><i><span lang="EN-US" style="font-size:10.0pt;font-family:"Arial",sans-serif"> select * from xxxxxx where group_code</span></i><b><i><span lang="EN-US" style="font-size:18.0pt;font-family:"Arial",sans-serif"> >
</span></i></b><i><span lang="EN-US" style="font-size:10.0pt;font-family:"Arial",sans-serif"> 5093690
</span></i><span lang="EN-US" style="font-size:10.0pt"><br>
</span><span lang="EN-US" style="font-size:10.0pt;font-family:"Arial",sans-serif"><br>
but it was not possible to access them directly with the individual values </span><span lang="EN-US" style="font-size:10.0pt">
</span><span lang="EN-US" style="font-size:10.0pt;font-family:"Arial",sans-serif"><br>
</span><span lang="EN-US" style="font-size:10.0pt"> </span><i><span lang="EN-US" style="font-size:10.0pt;font-family:"Arial",sans-serif"><br>
select * from xxxxxx where group_code </span></i><i><span lang="EN-US" style="font-size:13.5pt;font-family:"Arial",sans-serif">= </span></i><i><span lang="EN-US" style="font-size:10.0pt;font-family:"Arial",sans-serif">5093691
<br>
or select * from xxxxxx where group_code </span></i><i><span lang="EN-US" style="font-size:13.5pt;font-family:"Arial",sans-serif">=
</span></i><i><span lang="EN-US" style="font-size:10.0pt;font-family:"Arial",sans-serif"> 5093692</span></i><span lang="EN-US" style="font-size:10.0pt">
<br>
</span><span lang="EN-US" style="font-size:10.0pt;font-family:"Arial",sans-serif"><br>
For those which were before group-code 5093691 the following query was working fine
</span><span lang="EN-US" style="font-size:10.0pt"><br>
</span><i><span lang="EN-US" style="font-size:10.0pt;font-family:"Arial",sans-serif"><br>
select * from xxxxxx where group_code = 5093690 </span></i><span lang="EN-US" style="font-size:10.0pt"><br>
</span><span lang="EN-US" style="font-size:10.0pt;font-family:"Arial",sans-serif"><br>
After recreation of the table with copydb the application is working fine again ..</span><span lang="EN-US" style="font-size:10.0pt">
</span><span lang="EN-US">”<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">The problem occurred last Monday. The day before the following maintenance tasks had been performed:<o:p></o:p></span></p>
<p class="MsoNormal">usermod db<o:p></o:p></p>
<p class="MsoNormal">optimizedb -zk -uuser db<o:p></o:p></p>
<p class="MsoNormal"><span lang="EN-US">sysmod db<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Does anyone have an idea </span><span lang="EN-US" style="font-size:10.0pt;font-family:"Arial",sans-serif">how it is possible and how to avoid such issue?</span><span lang="EN-US"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">I would be grateful for any hint..<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:DE">Mit freundlichen Grüßen / Regards<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Helv",sans-serif;color:black;mso-fareast-language:DE">RICHARD ZINNDORF<br>
</span><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black;mso-fareast-language:DE">DXC Technology</span><span style="font-size:10.0pt;font-family:"Helv",sans-serif;color:black;mso-fareast-language:DE"><br>
<br>
Neustadter Str. 62, 68309 Mannheim, Germany<br>
Enhanced Technical Support MSS | p: +49.621.7001.0635 | f: +49.621.7001.6262 | m: +49.173.340.2127 |
</span><span lang="EN-US" style="font-size:10.0pt;font-family:"Helv",sans-serif;color:black;mso-fareast-language:DE"><a href="mailto:rzinndorf@csc.com"><span lang="DE" style="color:#0563C1">rzinndorf@csc.com</span></a></span><span style="font-size:10.0pt;font-family:"Helv",sans-serif;color:black;mso-fareast-language:DE">
| <a href="http://www.csc.com/de"><span style="color:#0563C1">www.csc.com/de</span></a>
<br>
</span><u><span style="font-size:10.0pt;font-family:"Helv",sans-serif;color:blue;mso-fareast-language:DE"><br>
<a href="http://twitter.com/CSC_DE"><span style="color:#0563C1">Twitter</span></a></span></u><span style="font-size:10.0pt;font-family:"Helv",sans-serif;color:black;mso-fareast-language:DE"> |
<a href="http://www.slideshare.net/CSCDeutschland"><span style="color:#0563C1">Slideshare</span></a>
<br>
<br>
CSC • This is a PRIVATE message. </span><span lang="EN-US" style="font-size:10.0pt;font-family:"Helv",sans-serif;color:black;mso-fareast-language:DE">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</span><span lang="EN-US" style="mso-fareast-language:DE"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
</div>
<br>
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
<br>
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.
</body>
</html>