SAP Knowledge Base Article - Preview

3040461 - DB6: Backup fails due to message queue limit exceeded

Symptom

Online backup job scheduled in DB13 fails.

1. Job log

|2021-03-21|01:00:00|Backup_Dev: DB Error: Yes | DB6PM | 000 | S |
|2021-03-21|01:00:00|Backup_Dev: SQL Code: 2044- | DB6PM | 000 | S |
|2021-03-21|01:00:00|Backup_Dev: SQL Message: SQL2044N An error occurred while accessing a message | DB6PM | 000 | S |
|2021-03-21|01:00:00|Backup_Dev: queue. Reason code: "1 row=1


2. db2diag.log

2021-03-21-01.00.00.000000+060 E4453095628A665 LEVEL: Error (OS)
PID : 12345 TID : 57890 PROC : db2sysc 0
INSTANCE: db2ABC NODE : 000 DB : ABC
APPHDL : 0-64516 APPID: *LOCAL.db2ABC.210324190050
AUTHID : DB2ABC HOSTNAME: ABC1
EDUID : 67890 EDUNAME: db2agent (ABC) 0
FUNCTION: DB2 UDB, oper system services, sqloMLNique, probe:4
MESSAGE : ZRC=0x870F0043=-2029060029=SQLO_QUE_EXCEED
"Maximum system queue limit exceeded"
DIA8559C A message queue limit has been exceeded.
CALLED : OS, -, msgget
OSERR : ENOSPC (28) "No space left on device"


Read more...

Environment

  • IBM Db2 database 
  • Linux and Unix

Keywords

DIA8559C, SQL2044N, message queue, limit, , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.