DB2 Error message DB21017E Reason code = -2029060029

DB2 Error message DB21017E Reason code = -2029060029

Problem(Abstract)

Frequently getting error DB21017E The Command Line Processor encountered a system error with the front-end process output queue. Reason code = -2029060029.

Symptom

The following message will be returned in the db2diag.log file:

DB21017E The Command Line Processor encountered a system error with the front-end process output queue. Reason code = -2029060029. SQLO_QUE_EXCEED = maximum system queue limit exceeded.

Cause

A kernel resource limit has been reached. Specifically the MSGMNI kernel parameter value been exceeded.

 

Environment

DB2 LUW installed on Linux, HP-UX, SUN Solaris

 

Diagnosing the problem

For additional info on Return Codes run the following from the command line:

db2diag -rc  -2029060029

Resolving the problem

Increasing the system message queue ( MSGMNI) parameter value in the kernel will resolve the issue.

The DB2 Information Center contains information on how to modify the kernel parameters for your specific operating system: Linux, HP-UX, Solaris

 

http://www-01.ibm.com/support/docview.wss?uid=swg21395060