Jim, it looks like DSNKIXDB is the DB2 Index Manager module.
Take a look at Item PQ39064, which describes several index problems
can cause your error message:
Code was added to check the validity of the index directory
page when the page set is opened and the IXD is built. If
it's not a valid directory page, DB2 abends in DSNKIXDB with
ABEND04E RC00C90101 ERQUAL5007 or ERQUAL5009.
DB2 must abend with this type of error or the invalid directory
page could cause some unpredictable problems and compromise the
data integrity of the index.
At offset x'88' in a dsn1copy of the index header page is the
field HPGIDP. The valid values for HPGIDP are zero, x'4' or
greater. Index pages x'1',x'2' and x'3' can not be used as a
index directory page.
A Rebuild or REORG IBM utility should be used to correct any
problems with an invalid directory page.
WARNING: If you use an NON IBM utility, contact your vendor
before running the utility to verify that if their product
allocates an index directory page, they are allocating a
valid index directory page.
If the NON IBM utility allocates an invalid directory page,
access to the index will be restricted and the ABEND04E from
DSNKIXDB will be issued.
Hope this helps...
David S. Waugh, NCW
DSW Consulting & Services
<[login to unmask email] To: [login to unmask email]
Sent by: DB2 Data Subject: DSNKIXDB DATA IN USE DURING ABEND
<[login to unmask email]
07/24/02 09:27 AM
Please respond to
DB2 Data Base
Anyone have any idea what DSNKIXDB is? I can't seem to find a
it anywhere - either on our subsystem or on the net. This happened
a SELECT COUNT(*).
DSNI014I .DB2T DSNKIXDB DATA IN USE DURING ABEND
the DB2-L webpage at http://listserv.ylassoc.com.
owners of the list