Professional Web Applications Themes

Determine index specified in db2diag.log - IBM DB2

Hi, We had the following entries in our db2diag.log file after our tablespace ran full: 2003-07-16-13.36.59.621943 Instance:db2dev Node:000 PID:17496(db2agent (DEV)) Appid:*LOCAL.db2dev.030713101724 index_manager sqligtpg Probe:750 Database:DEV DIA9999E An internal error occurred. Report the following error code : "0xFFFFD121". 2003-07-16-13.36.59.622874 Instance:db2dev Node:000 PID:17496(db2agent (DEV)) Appid:*LOCAL.db2dev.030713101724 index_manager sqligtpg Probe:522 Database:DEV Error fixing page 1024 Obj = {27;518;INX} Par={26;520} Now we know this is a index in tablespace ID 27 (which is the tablespace that ran full). But how do we get the index name itself? We checked IID in syscat.indexes but that is not the value. We know that the table for this ...

  1. #1

    Default Determine index specified in db2diag.log

    Hi,

    We had the following entries in our db2diag.log file after our tablespace
    ran full:

    2003-07-16-13.36.59.621943 Instance:db2dev Node:000
    PID:17496(db2agent (DEV)) Appid:*LOCAL.db2dev.030713101724
    index_manager sqligtpg Probe:750 Database:DEV
    DIA9999E An internal error occurred. Report the following error code :
    "0xFFFFD121".

    2003-07-16-13.36.59.622874 Instance:db2dev Node:000
    PID:17496(db2agent (DEV)) Appid:*LOCAL.db2dev.030713101724
    index_manager sqligtpg Probe:522 Database:DEV

    Error fixing page 1024 Obj = {27;518;INX} Par={26;520}

    Now we know this is a index in tablespace ID 27 (which is the tablespace
    that ran full). But how do we get the index name itself? We checked IID in
    syscat.indexes but that is not the value.
    We know that the table for this index is in tablespace ID 26 (which is
    correct) and it's object number is 520 (which if we run db2dart on that
    tablespace for that table, we do indeed get errors on obj 518).
    Luckily we only have 1 index on this table thus dropping the index and then
    recreating it again should fix this problem. However, what if we had
    multiple indexes? How can we get the index name from obj 518?

    Thanks.


    Erik Hendrix Guest

  2. #2

    Default Re: Determine index specified in db2diag.log

    Does it correspond to the IID for the index in syscat.indexes?
    cchattoraj Guest

  3. #3

    Default Re: Determine index specified in db2diag.log

    [email]chumki_chattorajhotmail.com[/email] (cchattoraj) wrote in message news:<6b8c09db.0307170635.69140592posting.google. com>...
    > Does it correspond to the IID for the index in syscat.indexes?
    IID is an incremented count of indexes, starting from 1, for each
    table. I don't see how that corresponds with the 518 from db2diag.log
    to find the index name.
    Greg Crawley Guest

Similar Threads

  1. tabnavigator determine selected index
    By nrutter in forum Macromedia Flex General Discussion
    Replies: 2
    Last Post: April 30th, 07:30 PM
  2. Replies: 0
    Last Post: November 17th, 10:38 PM
  3. archArray in db2diag.log
    By russcwatson in forum IBM DB2
    Replies: 1
    Last Post: September 18th, 01:42 PM
  4. db2diag.log - Package Cache max
    By andreyp#Antispam@mapsitnA#e-vision-group.com in forum IBM DB2
    Replies: 1
    Last Post: September 8th, 04:59 PM
  5. Replies: 4
    Last Post: July 31st, 12:51 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139