DB2 UDB V9.1.3, Database crash, crash recovery fail, no backup.
in [DB2]
|
From: Anwei Shen on 28 Jun 2010 18:23 Here is some error message. 2010-06-23-12.38.11.725463-240 I4923E509 LEVEL: Error PID : 23864 TID : 47931742066512PROC : db2redow (REPORTER) 0 INSTANCE: db2inst1 NODE : 000 DB : REPORTER APPHDL : 0-545 APPID: AC1084CA.F44C.16170C260BA9 AUTHID : DB2INST1 FUNCTION: DB2 UDB, Common Trace API, sqlbfix, probe:621 MESSAGE : ZRC=0x84020009=-2080243703=SQLB_RC_PG_NUM_ERR "Page number exceeds max -8100" DIA8709E Segmented table page number was too high. 2010-06-23-12.38.11.725720-240 I5433E511 LEVEL: Severe PID : 23864 TID : 47931742066512PROC : db2redow (REPORTER) 0 INSTANCE: db2inst1 NODE : 000 DB : REPORTER APPHDL : 0-545 APPID: AC1084CA.F44C.16170C260BA9 AUTHID : DB2INST1 FUNCTION: DB2 UDB, data management, sqldRedo, probe:6265 RETCODE : ZRC=0x84020009=-2080243703=SQLB_RC_PG_NUM_ERR "Page number exceeds max -8100" DIA8709E Segmented table page number was too high. 2010-06-23-12.38.11.725977-240 I5945E510 LEVEL: Severe PID : 23864 TID : 47931742066512PROC : db2redow (REPORTER) 0 INSTANCE: db2inst1 NODE : 000 DB : REPORTER APPHDL : 0-545 APPID: AC1084CA.F44C.16170C260BA9 AUTHID : DB2INST1 FUNCTION: DB2 UDB, data management, sqldmrdo, probe:780 RETCODE : ZRC=0x84020009=-2080243703=SQLB_RC_PG_NUM_ERR "Page number exceeds max -8100" DIA8709E Segmented table page number was too high. 2010-06-23-12.38.11.726196-240 I6456E486 LEVEL: Severe PID : 23864 TID : 47931742066512PROC : db2redow (REPORTER) 0 INSTANCE: db2inst1 NODE : 000 DB : REPORTER APPHDL : 0-545 APPID: AC1084CA.F44C.16170C260BA9 AUTHID : DB2INST1 FUNCTION: DB2 UDB, data management, sqldmrdo, probe:780 MESSAGE : Error during REDO of LSN: DATA #1 : Hexdump, 6 bytes 0x000000024B35FD9A : 0074 B884 9C4C .t...L 2010-06-23-12.38.11.726371-240 I6943E499 LEVEL: Severe PID : 23864 TID : 47931742066512PROC : db2redow (REPORTER) 0 INSTANCE: db2inst1 NODE : 000 DB : REPORTER APPHDL : 0-545 APPID: AC1084CA.F44C.16170C260BA9 AUTHID : DB2INST1 FUNCTION: DB2 UDB, data management, sqldmrdo, probe:780 MESSAGE : Error during REDO of log record: DATA #1 : Hexdump, 12 bytes 0x000000024B35FDF0 : 0167 0200 0400 0000 0988 0001 .g.......... 2010-06-23-12.38.11.726547-240 I7443E576 LEVEL: Error PID : 23864 TID : 47931742066512PROC : db2redow (REPORTER) 0 INSTANCE: db2inst1 NODE : 000 DB : REPORTER APPHDL : 0-545 APPID: AC1084CA.F44C.16170C260BA9 AUTHID : DB2INST1 FUNCTION: DB2 UDB, recovery manager, sqlpRecDbRedo, probe:155 MESSAGE : ZRC=0x84020009=-2080243703=SQLB_RC_PG_NUM_ERR "Page number exceeds max -8100" DIA8709E Segmented table page number was too high. DATA #1 : <preformatted> REDO failed on LSN 00000074B8849C4C 2010-06-23-12.38.11.726773-240 I8020E651 LEVEL: Error PID : 23864 TID : 47931742066512PROC : db2redow (REPORTER) 0 INSTANCE: db2inst1 NODE : 000 DB : REPORTER APPHDL : 0-545 APPID: AC1084CA.F44C.16170C260BA9 AUTHID : DB2INST1 FUNCTION: DB2 UDB, recovery manager, sqlpRecDbRedo, probe:160 DATA #1 : Hexdump, 32 bytes 0x000000024B35FDA8 : 0C00 0000 5200 0000 0000 0000 0000 0000 ....R........... 0x000000024B35FDB8 : 0A85 62C4 0000 0000 0000 0000 0000 0000 ..b............. DATA #2 : Hexdump, 12 bytes 0x000000024B35FDF0 : 0167 0200 0400 0000 0988 0001 .g.......... 2010-06-23-12.38.11.726932-240 I8672E517 LEVEL: Error PID : 23864 TID : 47931742066512PROC : db2redow (REPORTER) 0 INSTANCE: db2inst1 NODE : 000 DB : REPORTER APPHDL : 0-545 APPID: AC1084CA.F44C.16170C260BA9 AUTHID : DB2INST1 FUNCTION: DB2 UDB, recovery manager, sqlpPRecProcLog, probe:250 RETCODE : ZRC=0x84020009=-2080243703=SQLB_RC_PG_NUM_ERR "Page number exceeds max -8100" DIA8709E Segmented table page number was too high. 2010-06-23-12.38.11.727114-240 I9190E655 LEVEL: Error PID : 23864 TID : 47931742066512PROC : db2redow (REPORTER) 0 INSTANCE: db2inst1 NODE : 000 DB : REPORTER APPHDL : 0-545 APPID: AC1084CA.F44C.16170C260BA9 AUTHID : DB2INST1 FUNCTION: DB2 UDB, recovery manager, sqlpPRecProcLog, probe:250 MESSAGE : qEntry for 00000074B8849C4CentryFlags 5 queueId 13 waitOthers 0x24b1e4d60 numBlocked 1 lrHeader: DATA #1 : Hexdump, 32 bytes
From: Helmut Tessarek on 28 Jun 2010 18:38 Hi Anwei, As I have already mentioned before, my hands are tied. You will have to open a PMR with IBM support. On 28.06.10 18:23 , Anwei Shen wrote: > Here is some error message. > > 2010-06-23-12.38.11.725463-240 I4923E509 LEVEL: Error > PID : 23864 TID : 47931742066512PROC : db2redow > (REPORTER) 0 > INSTANCE: db2inst1 NODE : 000 DB : REPORTER > APPHDL : 0-545 APPID: AC1084CA.F44C.16170C260BA9 > AUTHID : DB2INST1 > FUNCTION: DB2 UDB, Common Trace API, sqlbfix, probe:621 > MESSAGE : ZRC=0x84020009=-2080243703=SQLB_RC_PG_NUM_ERR > "Page number exceeds max -8100" > DIA8709E Segmented table page number was too high. > > 2010-06-23-12.38.11.725720-240 I5433E511 LEVEL: Severe > PID : 23864 TID : 47931742066512PROC : db2redow > (REPORTER) 0 > INSTANCE: db2inst1 NODE : 000 DB : REPORTER > APPHDL : 0-545 APPID: AC1084CA.F44C.16170C260BA9 > AUTHID : DB2INST1 > FUNCTION: DB2 UDB, data management, sqldRedo, probe:6265 > RETCODE : ZRC=0x84020009=-2080243703=SQLB_RC_PG_NUM_ERR > "Page number exceeds max -8100" > DIA8709E Segmented table page number was too high. > > 2010-06-23-12.38.11.725977-240 I5945E510 LEVEL: Severe > PID : 23864 TID : 47931742066512PROC : db2redow > (REPORTER) 0 > INSTANCE: db2inst1 NODE : 000 DB : REPORTER > APPHDL : 0-545 APPID: AC1084CA.F44C.16170C260BA9 > AUTHID : DB2INST1 > FUNCTION: DB2 UDB, data management, sqldmrdo, probe:780 > RETCODE : ZRC=0x84020009=-2080243703=SQLB_RC_PG_NUM_ERR > "Page number exceeds max -8100" > DIA8709E Segmented table page number was too high. > > 2010-06-23-12.38.11.726196-240 I6456E486 LEVEL: Severe > PID : 23864 TID : 47931742066512PROC : db2redow > (REPORTER) 0 > INSTANCE: db2inst1 NODE : 000 DB : REPORTER > APPHDL : 0-545 APPID: AC1084CA.F44C.16170C260BA9 > AUTHID : DB2INST1 > FUNCTION: DB2 UDB, data management, sqldmrdo, probe:780 > MESSAGE : Error during REDO of LSN: > DATA #1 : Hexdump, 6 bytes > 0x000000024B35FD9A : 0074 B884 9C4C .t...L > > 2010-06-23-12.38.11.726371-240 I6943E499 LEVEL: Severe > PID : 23864 TID : 47931742066512PROC : db2redow > (REPORTER) 0 > INSTANCE: db2inst1 NODE : 000 DB : REPORTER > APPHDL : 0-545 APPID: AC1084CA.F44C.16170C260BA9 > AUTHID : DB2INST1 > FUNCTION: DB2 UDB, data management, sqldmrdo, probe:780 > MESSAGE : Error during REDO of log record: > DATA #1 : Hexdump, 12 bytes > 0x000000024B35FDF0 : 0167 0200 0400 0000 0988 > 0001 .g.......... > > 2010-06-23-12.38.11.726547-240 I7443E576 LEVEL: Error > PID : 23864 TID : 47931742066512PROC : db2redow > (REPORTER) 0 > INSTANCE: db2inst1 NODE : 000 DB : REPORTER > APPHDL : 0-545 APPID: AC1084CA.F44C.16170C260BA9 > AUTHID : DB2INST1 > FUNCTION: DB2 UDB, recovery manager, sqlpRecDbRedo, probe:155 > MESSAGE : ZRC=0x84020009=-2080243703=SQLB_RC_PG_NUM_ERR > "Page number exceeds max -8100" > DIA8709E Segmented table page number was too high. > DATA #1 : <preformatted> > REDO failed on LSN 00000074B8849C4C > > 2010-06-23-12.38.11.726773-240 I8020E651 LEVEL: Error > PID : 23864 TID : 47931742066512PROC : db2redow > (REPORTER) 0 > INSTANCE: db2inst1 NODE : 000 DB : REPORTER > APPHDL : 0-545 APPID: AC1084CA.F44C.16170C260BA9 > AUTHID : DB2INST1 > FUNCTION: DB2 UDB, recovery manager, sqlpRecDbRedo, probe:160 > DATA #1 : Hexdump, 32 bytes > 0x000000024B35FDA8 : 0C00 0000 5200 0000 0000 0000 0000 > 0000 ....R........... > 0x000000024B35FDB8 : 0A85 62C4 0000 0000 0000 0000 0000 > 0000 ..b............. > DATA #2 : Hexdump, 12 bytes > 0x000000024B35FDF0 : 0167 0200 0400 0000 0988 > 0001 .g.......... > > 2010-06-23-12.38.11.726932-240 I8672E517 LEVEL: Error > PID : 23864 TID : 47931742066512PROC : db2redow > (REPORTER) 0 > INSTANCE: db2inst1 NODE : 000 DB : REPORTER > APPHDL : 0-545 APPID: AC1084CA.F44C.16170C260BA9 > AUTHID : DB2INST1 > FUNCTION: DB2 UDB, recovery manager, sqlpPRecProcLog, probe:250 > RETCODE : ZRC=0x84020009=-2080243703=SQLB_RC_PG_NUM_ERR > "Page number exceeds max -8100" > DIA8709E Segmented table page number was too high. > > 2010-06-23-12.38.11.727114-240 I9190E655 LEVEL: Error > PID : 23864 TID : 47931742066512PROC : db2redow > (REPORTER) 0 > INSTANCE: db2inst1 NODE : 000 DB : REPORTER > APPHDL : 0-545 APPID: AC1084CA.F44C.16170C260BA9 > AUTHID : DB2INST1 > FUNCTION: DB2 UDB, recovery manager, sqlpPRecProcLog, probe:250 > MESSAGE : qEntry for 00000074B8849C4CentryFlags 5 queueId 13 > waitOthers 0x24b1e4d60 numBlocked 1 lrHeader: > DATA #1 : Hexdump, 32 bytes -- Helmut K. C. Tessarek DB2 Performance and Development /* Thou shalt not follow the NULL pointer for chaos and madness await thee at its end. */
First
|
Prev
|
Pages: 1 2 Prev: CREATE DATABASE returns SQL ERROR SQL0101N Next: Rollforward after a Redirect restore |