Results 1 to 3 of 3

Thread: database crash.

  1. #1
    Join Date
    May 2002
    Posts
    73

    Unanswered: database crash.

    People:

    I have a weird problem:

    I have a big database with millions of records. I dont know why but whenever I try to read/modify/delete an specific row(only one row already identified) the database crashes.

    Could you suggest something to understand this event?

    Regards

  2. #2
    Join Date
    Apr 2002
    Posts
    188

    Re: database crash.

    Originally posted by jeremas
    People:

    I have a weird problem:

    I have a big database with millions of records. I dont know why but whenever I try to read/modify/delete an specific row(only one row already identified) the database crashes.

    Could you suggest something to understand this event?

    Regards
    Any log information you can provided

  3. #3
    Join Date
    May 2002
    Posts
    73

    logs during db crash

    2002-10-18-03.15.24.995627 Instancerod40 Node:000
    PID:87820(db2agent (EPDDACT)) Appid:*LOCAL.prod40.021018071048
    index_manager sqlischd.proc_leaf Probe:44 Database:EPDDACT

    Obj={5;4;INX} Par={5;4} slotinfo=0,10,18 inkeyd=x23EBA0D page=1007779 origpage=196433 lkey_rc=0 retry=0

    2002-10-18-03.15.25.054091 Instancerod40 Node:000
    PID:87820(db2agent (EPDDACT)) Appid:*LOCAL.prod40.021018071048
    index_manager sqlischd.proc_leaf Probe:45 Database:EPDDACT

    Data Title:inkey PID:87820 Node:000
    0002 0003 0001 0002 2026 75fc 0004 0000 ........ &u....
    0001 0002 2026 7600 0004 0000 0006 31e5 .... &v.......1
    d1a3 86f4 2ff1 9bb0 0000 0000 f07c 5028 ѣ./.....|P(
    2ff1 9c78 0000 0008 0000 0333 0000 0352 /.x.......3...R
    0000 0000 2ff1 9c90 2ff1 9c74 f06c 60ec ..../../.tl`
    2ff1 9cec f06c 7440 2ff1 9c60 0000 0000 /.lt@/.`....
    d14b ab58 781d db5c 0000 0000 0000 0000 KXx.\........
    0016 700b 3567 0000 2ff1 9c80 4003 8030 ..p.5g../..@..0
    0001 701a 0000 0000 2ff1 9ca0 4007 a280 ..p...../.@..

    String Title: PID:87820 Node:000
    kp[1]: dataptr=20267600 type=INTEGER len=4 ind=0x2


    String Title: PID:87820 Node:000
    0000051F ....
    Dump File:/usr/prepaid/currentVersion/db/log/87820.000 DataQLB_PAGE

    2002-10-18-03.15.25.362498 Instancerod40 Node:000
    PID:87820(db2agent (EPDDACT)) Appid:*LOCAL.prod40.021018071048
    index_manager sqlischd Probe:99 Database:EPDDACT

    Obj={5;4;INX} Par={5;4} pagenum: 0002 ff51 ..Q
    2002-10-18-03.15.25.810527 Instancerod40 Node:000
    PID:87820(db2agent (EPDDACT)) Appid:*LOCAL.prod40.021018071048
    index_manager sqlidelk Probe:99 Database:EPDDACT
    DIA3841C The index key could not be found, the value was "".

    ZRC=FFFFF92C

    String Title: PID:87820 Node:000
    Obj={5;4;INX} Par={5;4} RID=x23EBA0D

    Standard input

Posting Permissions

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