IT25589: LIST HISTORY COMMAND FAILS WITH DB21018E ERROR WHEN THE HISTORY FILE CONTAINS A DROPPED TABLE EVENT WITH LONGER TABLE NAME.

Known Issues

https://www.ibm.com/mysupport/s/defect/aCI3p000000kF7p/dt159458?language=en_US

IT25589: LIST HISTORY COMMAND FAILS WITH DB21018E ERROR WHEN THE HISTORY FILE CONTAINS A DROPPED TABLE EVENT WITH LONGER TABLE NAME.

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

Show less

****************************************************************

* USERS AFFECTED:                                              *

* ALL                                                          *

****************************************************************

* PROBLEM DESCRIPTION:                                         *

* See Error Description                                        *

****************************************************************

* RECOMMENDATION:                                              *

* Upgrade to Db2 11.1 Mod 4 Fixpack 5 or higher                *

****************************************************************