DSNKIXDB DATA IN USE DURING ABEND

Jim Harrison

DSNKIXDB DATA IN USE DURING ABEND
Anyone have any idea what DSNKIXDB is? I can't seem to find a reference to
it anywhere - either on our subsystem or on the net. This happened during
a SELECT COUNT(*).

DSNI014I .DB2T DSNKIXDB DATA IN USE DURING ABEND
REASON 00C90101
ERQUAL 5009
TYPE 00000303
NAME SVCNMU01.NMUAFA03.X'00000002'
CONNECTION-ID=TSO
CORRELATION-ID=MV41
LUW-ID=*



Eric Pearson

Re: DSNKIXDB DATA IN USE DURING ABEND
(in response to Jim Harrison)
DSNKIXDB is the CSECT name which detected the error or sent
the error message. To find it on your subsystem you would need
to run the AMBLIST utility against the active load module.

Most likely places you might see a wee bit of doc
on the particular CSECT:

1) A STROBE report might give a few words describing
the CSECT.
2) You might get some hits (I got 27) via
an SIS search on IBMLINK. There were 7 matches
for search argument 'DSNKIXDB 00C90101'.
IBMLINK is a marvelous diagnostic aid.

Regards,
eric pearson
NS ITO Database Support


-----Original Message-----
From: Jim Harrison [mailto:[login to unmask email]
Sent: Wednesday, July 24, 2002 10:27 AM
To: [login to unmask email]
Subject: DSNKIXDB DATA IN USE DURING ABEND


Anyone have any idea what DSNKIXDB is? I can't seem to find a reference to
it anywhere - either on our subsystem or on the net. This happened during
a SELECT COUNT(*).

DSNI014I .DB2T DSNKIXDB DATA IN USE DURING ABEND
REASON 00C90101
ERQUAL 5009
TYPE 00000303
NAME SVCNMU01.NMUAFA03.X'00000002'
CONNECTION-ID=TSO
CORRELATION-ID=MV41
LUW-ID=*








Max Scarpa

Re: DSNKIXDB DATA IN USE DURING ABEND
(in response to Eric Pearson)
There are some APAR entries referencing DSNKIXDB (Index Descriptor Block I
think) and RC00C90101 ERRQUAL5003 as for example


PQ39064


HTH

Max Scarpa



Jim Harrison

Re: DSNKIXDB DATA IN USE DURING ABEND
(in response to Max Scarpa)
Doh! Sorry, I knew that - or should have. Must be running a caffeine
deficit this morning. I guess the name made me think it was some sort of
DB2 object, so I went hunting. Thanks!

At 10:51 AM 7/24/2002 -0400 Pearson, Eric L, said:
>DSNKIXDB is the CSECT name which detected the error or sent
>the error message. To find it on your subsystem you would need
>to run the AMBLIST utility against the active load module.



Thomas Schulz

Re: DSNKIXDB DATA IN USE DURING ABEND
(in response to Jim Harrison)
Hello JIM

Try PQ35625 or

http://techsupport.services.ibm.com/server/390.CAPARdb

May be you will find something there

Regards Tomas

Jim Harrison schrieb:
>
> Anyone have any idea what DSNKIXDB is? I can't seem to find a reference to
> it anywhere - either on our subsystem or on the net. This happened during
> a SELECT COUNT(*).
>
> DSNI014I .DB2T DSNKIXDB DATA IN USE DURING ABEND
> REASON 00C90101
> ERQUAL 5009
> TYPE 00000303
> NAME SVCNMU01.NMUAFA03.X'00000002'
> CONNECTION-ID=TSO
> CORRELATION-ID=MV41
> LUW-ID=*
>
>
>



Jeremiah Eden

Re: DSNKIXDB DATA IN USE DURING ABEND
(in response to Thomas Schulz)
DSNKIXDB is in module DSNK2DM. As Eric mentioned IBMLINK has a lot of
information on it
if you are interested, and there are several hits for rc00C90101 erqual5009
in V5, V6 and V7. But rebuilding the index might fix the problem.

-----Original Message-----
From: Pearson, Eric L, [mailto:[login to unmask email]
Sent: Wednesday, July 24, 2002 9:51 AM
To: [login to unmask email]
Subject: Re: DSNKIXDB DATA IN USE DURING ABEND


DSNKIXDB is the CSECT name which detected the error or sent
the error message. To find it on your subsystem you would need
to run the AMBLIST utility against the active load module.

Most likely places you might see a wee bit of doc
on the particular CSECT:

1) A STROBE report might give a few words describing
the CSECT.
2) You might get some hits (I got 27) via
an SIS search on IBMLINK. There were 7 matches
for search argument 'DSNKIXDB 00C90101'.
IBMLINK is a marvelous diagnostic aid.

Regards,
eric pearson
NS ITO Database Support


-----Original Message-----
From: Jim Harrison [mailto:[login to unmask email]
Sent: Wednesday, July 24, 2002 10:27 AM
To: [login to unmask email]
Subject: DSNKIXDB DATA IN USE DURING ABEND


Anyone have any idea what DSNKIXDB is? I can't seem to find a reference to
it anywhere - either on our subsystem or on the net. This happened during
a SELECT COUNT(*).

DSNI014I .DB2T DSNKIXDB DATA IN USE DURING ABEND
REASON 00C90101
ERQUAL 5009
TYPE 00000303
NAME SVCNMU01.NMUAFA03.X'00000002'
CONNECTION-ID=TSO
CORRELATION-ID=MV41
LUW-ID=*













David S. Waugh

Re: DSNKIXDB DATA IN USE DURING ABEND
(in response to Jim Harrison)
Jim, it looks like DSNKIXDB is the DB2 Index Manager module.

Take a look at Item PQ39064, which describes several index problems that
can cause your error message:

PROBLEM CONCLUSION:
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





Jim Harrison
<[login to unmask email] To: [login to unmask email]
T> cc:
Sent by: DB2 Data Subject: DSNKIXDB DATA IN USE DURING ABEND
Base Discussion
List
<[login to unmask email]
LASSOC.COM>


07/24/02 09:27 AM
Please respond to
DB2 Data Base
Discussion List






Anyone have any idea what DSNKIXDB is? I can't seem to find a reference to
it anywhere - either on our subsystem or on the net. This happened during
a SELECT COUNT(*).

DSNI014I .DB2T DSNKIXDB DATA IN USE DURING ABEND
REASON 00C90101
ERQUAL 5009
TYPE 00000303
NAME SVCNMU01.NMUAFA03.X'00000002'
CONNECTION-ID=TSO
CORRELATION-ID=MV41
LUW-ID=*



the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list
can



Jim Harrison

Re: DSNKIXDB DATA IN USE DURING ABEND
(in response to Jeremiah Eden)
Yeah - DROP, COMMIT, CREATE did the trick, but I suppose rebuild would have
worked too. I did that right after I fired off the original message.

At 10:34 AM 7/24/2002 -0500 Jeremiah Eden said:
> But rebuilding the index might fix the problem.



Raymond Bell

Re: DSNKIXDB DATA IN USE DURING ABEND
(in response to David S. Waugh)
Jim,

You're not alone. I must confess, when I first read your note, I thought
to myself, 'I wonder what object that is. Catalog index, maybe?'. So
you're not the only one who hasn't had enough caffeine yet today!


Raymond



Jim Harrison
<[login to unmask email] To: [login to unmask email]
T> cc:
Sent by: DB2 Data Subject: Re: DSNKIXDB DATA IN USE DURING ABEND
Base Discussion
List
<[login to unmask email]
LASSOC.COM>


25/07/02 03:10
Please respond to
DB2 Data Base
Discussion List





Doh! Sorry, I knew that - or should have. Must be running a caffeine
deficit this morning. I guess the name made me think it was some sort of
DB2 object, so I went hunting. Thanks!

At 10:51 AM 7/24/2002 -0400 Pearson, Eric L, said:
>DSNKIXDB is the CSECT name which detected the error or sent
>the error message. To find it on your subsystem you would need
>to run the AMBLIST utility against the active load module.



the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list
can