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 for Me (Login required).

Search for additional results

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