IT30204: INCORRECT ERROR LEVEL MESSAGE IS WRITTEN IN DB2DIAG.LOG

Db2 Version 11.1 Mod 4 Fix Pack 5 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 6 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 6 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error description

• Incorrect Error level message for sqlplGetLockWaitInfo function
  is written in db2diag.log.  It should be logged as
  informational.
  It just indications data has changed during snapshot monitoring.
  It can be safely ignored.
  
  2019-09-05-00.20.54.416404+540 E2188E594            LEVEL: Error
  PID     : 56736                TID : 70349831991648 PROC :
  db2sysc 0
  INSTANCE: DB2INST1               NODE : 000           DB   :MYDB
  APPHDL  : 0-10842              APPID: *N0.DB2.191012073522
  AUTHID  : DB2INST1               HOSTNAME: MYHOST1
  EDUID   : 43971                EDUNAME: db2agent (instance) 0
  FUNCTION: DB2 UDB, lock manager, sqlplGetLockWaitInfo, probe:519
  DATA #1 : <preformatted>
  DEBUG: catch error in
  sqlplGetLockWaitInfo()agtCB_waiter->dpsAgentCB =
  0x00003ffc1c100940 while dpsAgentCB = 0x0000000000000000
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * ALL                                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to Db2 11.1 Mod 4 Fixpack 5 or higher                *
  ****************************************************************
  

Problem conclusion

• First fixed in Db2 11.1 Mod 4 Fixpack 5
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  DB2 FOR LUW

• Fixed component ID

  DB2FORLUW

Applicable component levels

• RB10 PSN

     UP