Troubleshooting
Problem
SQL0443N with diagnostic text "SYSIBM:CLI:-805". SQLSTATE=38553 when calling stored procedure SYSIBM.SQLXXXXXXX()
Symptom
The error may be displayed differently depending on the calling application:
- When calling from a non-JDBC application or the legacy JDBC type 2 driver (db2java.zip), the error may be displayed similar to the following:
SQL0443N Routine "SYSIBM.SQLTABLES" (specific name "TABLES") has returned an
error SQLSTATE with diagnostic text "SYSIBM:CLI:-805". SQLSTATE=38553
- When calling from a JDBC application (db2jcc.jar), the error may be displayed similar to the following:
com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -443, SQLSTATE:
38553, SQLERRMC: SYSIBM.SQLPRIMARYKEYS;PRIMARYKEYS;SYSIBM:CLI:-805
Cause
A -805 error is defined as:
SQL0805N Package "<package-name>" was not found.
A package for catalog function support must be created in the database prior to the execution of the stored procedures. The following procedure names seen in the SQL0443N error require the prerequisite package:
SYSIBM.SQLATTRIBUTES
SYSIBM.SQLCOLPRIVILEGES
SYSIBM.SQLCOLUMNS
SYSIBM.SQLFOREIGNKEYS
SYSIBM.SQLFUNCTIONCOLS
SYSIBM.SQLFUNCTIONS
SYSIBM.SQLGETTYPEINFO
SYSIBM.SQLPRIMARYKEYS
SYSIBM.SQLPROCEDURECOLS
SYSIBM.SQLPROCEDURES
SYSIBM.SQLSPECIALCOLUMNS
SYSIBM.SQLSUPERTABLES
SYSIBM.SQLSUPERTYPES
SYSIBM.SQLSTATISTICS
SYSIBM.SQLTABLEPRIVILEGES
SYSIBM.SQLTABLES
SYSIBM.SQLUDTS
Environment
Database applications connecting to the following database server platforms:
- DB2 for Linux, Unix, or Windows
- DB2 for z/OS
- DB2 for iSeries
- DB2 for VM/VSE
Resolving The Problem
The method of creating the prerequisite package for catalog function support depends on the database server.
- DB2 for Linux, UNIX, or Windows:
The bind file db2schema.bnd must be bound to database. The db2schema.bnd used must be the same version and fixpack level of the database server instance.
1) Navigate to the bnd folder of the database server instance:
UNIX: $INSTHOME/sqllib/bnd.
Windows: DB2DIR\sqllib\bnd (The default DB2DIR on Windows is C:\Program Files\IBM\SQLLIB)
2) db2 connect to <database> user <username> using <password>
3) db2 bind db2schema.bnd blocking all grant public
- DB2 for z/OS:
The job DSNTIJSG must be ran to create the catalog functions as well as the corresponding packages. See "Job DSNTIJSG"
- DB2 for iSeries:
See article QSQIBMCHK Tool Added to V5R4 for details if the SYSIBM objects are missing
- DB2 for VM/VSE:
See "Appendix F. Preparing the Schema Stored Procedures for" of the DB2 for VM/VSE Database Administration Guide
Related Information
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21449630