IBM Support

SQL0443N with diagnostic text "SYSIBM:CLI:-805". SQLSTATE=38553 when calling stored procedure SYSIBM.SQLXXXXXXX()

Technote (troubleshooting)


Problem(Abstract)

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

Related information

Job DSNTIJSG
DB2 CLI bind files and package names
BIND
QSQIBMCHK Tool Added to V5R4
DB2 for VM/VSE Database Administration

Cross reference information
Segment Product Component Platform Version Edition
Information Management DB2 Connect AIX, HP-UX, Linux, Windows 9.7, 9.5, 9.1, 10.1, 10.5

Document information

More support for: DB2 for Linux, UNIX and Windows
OTHER - Uncategorised

Software version: 9.1, 9.5, 9.7, 10.1, 10.5, 11.1

Operating system(s): AIX, HP-UX, Linux, Solaris, Windows

Software edition: Enterprise Server, Express, Personal, Workgroup Server

Reference #: 1449630

Modified date: 18 July 2016