|
Problem IC62333
|
Status: Closed |
DB2 crashes - SQLICVTUNIQ, PROBE:1030 |
| product: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| Problem description: |
Crash recovery seems to be failing on about 20 nodes while
trying to change the indextype of an index. Here's the messages
from the diag log:
2009-08-02-01.34.39.468813+330 I97288A498 LEVEL: Severe
PID : 169756 TID : 21429 PROC : db2sysc
20
INSTANCE: db2inst1 NODE : 020 DB :
PRODLTRA
APPHDL : 0-452 APPID: *N0.db2inst1.090801200422
AUTHID : DB2INST1
EDUID : 21429 EDUNAME: db2redom (PRODLTRA) 20
FUNCTION: DB2 UDB, index manager, sqliCvtUniq, probe:1030
DATA #1 : Hexdump, 4 bytes
0x07000001AB7FB610 : 8709 0054
...T
2009-08-02-01.34.39.469048+330 I97787A526 LEVEL: Severe
PID : 169756 TID : 21429 PROC : db2sysc
20
INSTANCE: db2inst1 NODE : 020 DB :
PRODLTRA
APPHDL : 0-452 APPID: *N0.db2inst1.090801200422
AUTHID : DB2INST1
EDUID : 21429 EDUNAME: db2redom (PRODLTRA) 20
FUNCTION: DB2 UDB, index manager, sqliRedo, probe:0
RETCODE : ZRC=0x87090054=-2029453228=SQLI_PRG_ERR "Program
error"
DIA8575C An index manager programming error occurred.
2009-08-02-01.34.39.469413+330 I98314A546 LEVEL: Severe
PID : 169756 TID : 21429 PROC : db2sysc
20
INSTANCE: db2inst1 NODE : 020 DB :
PRODLTRA
APPHDL : 0-452 APPID: *N0.db2inst1.090801200422
AUTHID : DB2INST1
EDUID : 21429 EDUNAME: db2redom (PRODLTRA) 20
FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary
logging func, probe:0
MESSAGE : SQLP_LSN
DATA #1 : Hexdump, 6 bytes
0x070000022B0047DA : 00C2 FCA1 37C6 |
| Problem Summary: |
Users Affected: All
Problem description:
Crash recovery fails on nodes while trying to change the
indextype of an index. Here's the messages from the diag log:
2009-08-02-01.34.39.468813+330 I97288A498 LEVEL: Severe
PID : 169756 TID : 21429 PROC : db2sys
20
INSTANCE: db2inst1 NODE : 020 DB :
PRODLTRA
APPHDL : 0-452 APPID: *N0.db2inst1.090801200422
AUTHID : DB2INST1
EDUID : 21429 EDUNAME: db2redom (PRODLTRA) 20
FUNCTION: DB2 UDB, index manager, sqliCvtUniq, probe:1030
DATA #1 : Hexdump, 4 bytes
0x07000001AB7FB610 : 8709 0054
...T
2009-08-02-01.34.39.469048+330 I97787A526 LEVEL: Severe
PID : 169756 TID : 21429 PROC : db2sys
20
INSTANCE: db2inst1 NODE : 020 DB :
PRODLTRA
APPHDL : 0-452 APPID: *N0.db2inst1.090801200422
AUTHID : DB2INST1
EDUID : 21429 EDUNAME: db2redom (PRODLTRA) 20
FUNCTION: DB2 UDB, index manager, sqliRedo, probe:0
RETCODE : ZRC=0x87090054=-2029453228=SQLI_PRG_ERR "Program
error"
DIA8575C An index manager programming error occurred.
2009-08-02-01.34.39.469413+330 I98314A546 LEVEL: Severe
PID : 169756 TID : 21429 PROC : db2sys
20
INSTANCE: db2inst1 NODE : 020 DB :
PRODLTRA
APPHDL : 0-452 APPID: *N0.db2inst1.090801200422
AUTHID : DB2INST1
EDUID : 21429 EDUNAME: db2redom (PRODLTRA) 20
FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary
logging func, probe:0
MESSAGE : SQLP_LSN
DATA #1 : Hexdump, 6 bytes
0x070000022B0047DA : 00C2 FCA1 37C6
LOCAL FIX:
None |
| Local Fix: |
|
| available fix packs: |
DB2 Version 9.5 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
First fixed in V95 FP 5
c
c
c |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 03.08.2009
17.12.2009
17.12.2009 |
| Problem solved at the following versions (IBM BugInfos) |
9.5.FP5
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.5.0.5
|
 |
