IBM i - SQ99999 error code 21 or Toolkit request request failed HY021

This article is now available in our new knowledge base: IBM i - SQ99999 error code 21 or Toolkit request request failed HY021

Issue

A DB2 operation may fail with a message like this:

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 21. Error codes are: 21 -- Descriptor or           
descriptor information not valid.   

This may be related to this Toolkit error:

Toolkit request failed. Possible reason: a CCSID not matching that of system, or updated PTFs 
may be required. Database code (if any): HY021. Message: Error occurred in SQL Call Level Interface

Note: This article only applies to Error Code 21, or code HY021.

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 21 condition, which may also be indicated by a SQL code of HY021.

Environment

Zend Server for IBM i, running on any supported version of IBM i.

Resolution

This issue has been resolved By IBM, APAR SE64565.  Please apply the PTF appropriate for your version of the IBM i operating system:

R710 SI62839
R720 SI60350
R730 SI60355