suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IT21906 Status: Closed

NSE CHACKNSEINDEX UTILITY MAY RETURN CTE5257E REASON CODE "2"

product:
DB2 FOR LUW / DB2FORLUW / B10 - DB2
Problem description:
An example of symptom and its command.
$ checknseindex -p /db2inst1/SAMPLE/NODE0000 -i IXnnnnn -v
==> receives CTE5257E

When the base table primary keys are variable length,
checknseindex shouldn't fail index test when finding
mismatching number of data blocks in the forward and
backward mapping files. When the number of data blocks
from these two files are not equal, checknseindex should
scan both files and compare the mapping record counts in
both files - pass the test when the mapping record counts
match and report index corruption when mismatch.
Problem Summary:
****************************************************************
* USERS AFFECTED:                                              *
* Db2 Version 11.1                                             *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Db2 Version 11.1 Mod 2 Fix Pack 2.                *
****************************************************************
Local Fix:
Solution
Workaround
not known / see Local fix
BUG-Tracking
forerunner  : IT19842 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
09.08.2017
10.10.2017
10.10.2017
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)