Date: Thu, 28 Mar 2024 14:14:16 +0000 (UTC) Message-ID: <833898885.385.1711635256513@library.aws.roguewave.com> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_384_1929926394.1711635256511" ------=_Part_384_1929926394.1711635256511 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
A DB2 operation may generate a message like this:
SQ99999 Diagnostic 30 QSQCLI QSYS *STMT QP2USER2 QSYS STMT &nbs= p;
From module . . . . . . . . : SQLPRD &nb= sp; From procedure . . . . . . : SQLParamData &nb= sp;
Statement . . . . . . . = . . : 12682 =
 = ; &nb= sp; &= nbsp;
To module . . . . . . . . . : QP2API= &nbs= p;
To procedure . . . . . . . : runpase_common__FiP= vT2
Statement . . . . . . . = . . : 5 &nbs= p;
Message . . . . : Error o= ccurred in SQL Call Level Interface
Cause . . . . . : A pr= ocedure call encountered an error. The
error code is 10. = Error codes are: 10 -- Function sequence error.
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 in= dicate 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. Also, they can cause the logs= to overrun the limits, causing a crash if page wrapping is not in effect.&= nbsp; Also, if job logs are sent to spool files, the quantity of messages c= an be so great as to make a significant impact on storage capacity.<= /p>
Note: This article only applies to Err= or Code 10, or code HY010.
The SQ99999 message is very generi= c, and can occur for many different reasons, each with a different error co= de. This article only applies to the error code 10 condition, which m= ay also be indicated by a SQL state of HY010.
Zend Server for IBM i, running on any supported version of IB= M i.
This issue has been resolved By IBM, APAR SE62545. Plea= se apply the PTF appropriate for your version of the IBM i operating system= :
R710 SI62839
R720 SI62758
R730 SI62828