Issue
A DB2 operation may generate a message like this:
Info |
---|
|
SQ99999 Diagnostic 30 QSQCLI QSYS *STMT QP2USER2 QSYS STMT From module . . . . . . . . : SQLPRD From procedure . . . . . . : SQLParamData Statement . . . . . . . . . : 12682 To module . . . . . . . . . : QP2API To procedure . . . . . . . : runpase_common__FiPvT2 Statement . . . . . . . . . : 5 Message . . . . : Error occurred in SQL Call Level Interface Cause . . . . . : A procedure call encountered an error. The error code is 9. Error codes are: 9 -- Argument value not valid. |
There may be thousands of these errors in the job logs for the Apache child jobs running PHP with calls to DB2 or the Toolkit. These errors are harmless, and do not indicate an actual crash, despite the level 30 applied to the message. They do fill up the logs with so many errors it can be difficult to find a relevant error when a crash does occur.
Note |
---|
icon | false |
---|
title | Note: This article only applies to Error Code 9, or code HY009. |
---|
|
The SQ99999 message is very generic, and can occur for many different reasons, each with a different error code. This article only applies to the error code 9 condition, which may also be indicated by a SQL state of HY009. |
Environment
Zend Server for IBM i, running on any supported version of IBM i.
Resolution
This issue has been resolved By IBM, APAR SE63076. Please apply the PTF appropriate for your version of the IBM i operating system:
Info |
---|
|
R710 SI59080 R720 SI58189 R730 SI58589 |