IT23135: DUMP.BIN FILES ARE GENERATED ON THE HADR PRIMARY SERVER

Db2 Version 11.1 Mod 3 Fix Pack 3 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix002 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 5 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 7 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error description

• *.dump.bin files may be dumped on HADR primary, db2diag.log
  shows:
  
  2017-09-18-13.53.27.362606-240 I42117799A520        LEVEL: Error
  PID     : 14942568             TID : 51664          PROC :
  db2sysc 0
  INSTANCE: XXXX   NODE : 000           DB   : COM
  HOSTNAME: XXXX
  EDUID   : 51664                EDUNAME: db2loggr (COM) 0
  FUNCTION: DB2 UDB, data protection services,
  sqpLoggrEdu::sqlpLogReclaimRuntime, probe:550
  DATA #1 : <preformatted>
  Reclaimed too much log space on log stream 0.
  Recalculating LogBytesInUse.
  Old LogBytesInUse: 40758779 New LogBytesInUse: 46
  
  2017-09-18-13.53.27.363366-240 I42118320A182      LEVEL: Error
  PID:14942568 TID:51664 NODE:000 Title: SQLP_DBCB
  Dump
  File:/udb/home/wptdev/sqllib/db2dump/14942568.51664.000.dump.bin
  
  2017-09-18-13.53.27.364690-240 I42118503A193      LEVEL: Error
  PID:14942568 TID:51664 NODE:000 Title: SQLPG_RETRIEVE_ARRAY
  Dump
  File:/udb/home/wptdev/sqllib/db2dump/14942568.51664.000.dump.bin
  
  2017-09-18-13.53.27.365606-240 I42118697A194      LEVEL: Error
  PID:14942568 TID:51664 NODE:000 Title: SQLP_TRAN_ENTRY_ARRAY
  Dump
  File:/udb/home/wptdev/sqllib/db2dump/14942568.51664.000.dump.bin
  
  2017-09-18-13.53.27.373634-240 I42118892A182      LEVEL: Error
  PID:14942568 TID:51664 NODE:000 Title: SQLP_LFPB
  Dump
  File:/udb/home/wptdev/sqllib/db2dump/14942568.51664.000.dump.bin
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * ALL                                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to Db2 11.1 Mod 3 Fix Pack 3 or higher               *
  ****************************************************************
  

Problem conclusion

• First fixed in Db2 11.1 Mod 3 Fix Pack 3
  

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