Forums & Discussions Home

    A place for members, communities, and committees to have discussions online and via e-mail.
    Click a category or topic to below to start the conversation...

    You are currently in view only mode for this forum. Please click the appropriate below to login as a member and participate. If you are not a member, please CLICK HERE for more information.


    Jul 24
    2002

    DSNKIXDB DATA IN USE DURING ABEND

    Jim Harrison
    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
    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
    [Cx SpA]
    There are some APAR entries referencing DSNKIXDB (Index Descriptor Block I
    think) and RC00C90101 ERRQUAL5003 as for example


    PQ39064


    HTH

    Max Scarpa



    Jim Harrison
    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
    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
    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
    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
    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
    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




    All Times America/New_York

    Copyright © 2014 IDUG. All Rights Reserved

    All material, files, logos and trademarks within this site are properties of their respective organizations.

    Terms of Service - Privacy Policy - Contact