IBM Support

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

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

[{"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"OTHER - Uncategorised","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.7;9.5;9.1;10.1;10.5;11.1","Edition":"Enterprise Server;Express;Personal;Workgroup Server","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Product":{"code":"SSEPDU","label":"DB2 Connect"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":" ","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"9.7;9.5;9.1;10.1;10.5","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
16 June 2018

UID

swg21449630