DB2 - Problembeschreibung
Problem IT25589 | Status: Geschlossen |
LIST HISTORY COMMAND FAILS WITH DB21018E ERROR WHEN THE HISTORY FILE CONTAINS A DROPPED TABLE EVENT WITH LONGER TABLE NAME. | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problembeschreibung: | |
LIST HISTORY command fails with DB21018E error when the history file contains a DROPPED TABLE event which the length of the table name is longer than 128KB. $ db2 list history dropped table all for sample List History File for sample Number of matching file entries = 1 Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID -- --- ------------------ ---- --- ------------ ------------ -------------- D T 20180628135510 000000000000253700040004 ---------------------------------------------------------------- ------------ "DB2INST1 "."TABLE1" resides in 1 tablespace(s): 00001 TS8K ---------------------------------------------------------------- ------------ Comment: DROP TABLE Start Time: 20180628135510 End Time: 20180628135510 Status: A ---------------------------------------------------------------- ------------ EID: 5 DB21018E A system error occurred. The command line processor could not continue processing. The db2diag.log shows SQLO_QUE_BAD_HANDLE error as follows: 2018-06-28-14.11.52.809384-240 E82157A699 LEVEL: Error (OS) PID : 29294808 TID : 1 PROC : db2bp INSTANCE: db2inst1 NODE : 000 HOSTNAME: db2server EDUID : 1 FUNCTION: DB2 UDB, oper system services, sqlowqueInternal, probe:40 MESSAGE : ZRC=0x870F003E=-2029060034=SQLO_QUE_BAD_HANDLE "Bad Queue Handle" DIA8555C An invalid message queue handle was encountered. CALLED : OS, -, msgsnd OSERR : EINVAL (22) "A system call received a parameter that is not valid." DATA #1 : system V message queue identifier., PD_TYPE_SYSV_QUEUE_ID, 4 bytes 0x43544554 DATA #2 : Pointer, 8 bytes 0x000000011088f080 DATA #3 : unsigned integer, 8 bytes 65527 | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 11.1 Mod 4 Fixpack 5 or higher * **************************************************************** | |
Local-Fix: | |
Delete the problematic event by PRUNE HISTORY command. | |
Lösung | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 05.07.2018 16.01.2020 16.01.2020 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version |