The error SQL0443N with 'SYSIBM:CLI:-805' occurs after upgrading to
DB2 UDB Version 8.1 Fix Pack 10
An error occurs with the SQLTables if the database was created before applying
IBM DB2 V8.1 Fix Pack 10 (also known as Version 8.2 Fix Pack 3), you encounter
an SQL0443N error if you run a DB2 Call Level Interface (CLI) catalog function
(such as SQLTables(), SQLColumns(), or SQLStatistics()). The following is an
example of the error in a log:
(430F82BD.0000-3C4:khdxodbc.cpp,319,"initializeDatabase") Connection with
Datasource "ITM Warehouse" successful
(430F82BD.0001-3C4:khdxbase.cpp,250,"setError") Error 20/3/-443(FFFFFE45)/0
executing SQLTables
(430F82BD.0002-3C4:khdxbase.cpp,266,"setError") Error "[IBM][CLI Driver][DB2/NT]
SQL0443N Routine "SYSIBM.SQLTABLES" (specific name "TABLES") has returned an
error SQLSTATE with diagnostic text "SYSIBM:CLI:-805". SQLSTATE=38553
+430F82BD.0002 "
Bind the db2schema.bnd file against each database to resolve this error. Run the
following command from a DB2 command prompt:
1. db2 connect to dbname (Warehouse Database)
where:
dbname
Specifies the name of a database to which you want to bind the
utilities, or the Warehouse Database name.
2. DB2 bind path_name
where:
path_name
Specifies the full path name of the directory where the bind files are
located, usually sqllib/bnd.
The following examples shows the rebinding commands from the
c:\SQLLIB\bnd>DB2 directory:
c:\SQLLIB\bnd>DB2 connect to dbname (Warehouse Database)
c:\SQLLIB\bnd>DB2 bind @db2ubind.lst blocking all grant public
c:\SQLLIB\bnd>DB2 bind @db2cli.lst blocking all grant public
c:\SQLLIB\bnd>DB2 bind db2schema.bnd blocking all grant public
Using DB2 v8.1, Warehouse Proxy Agent crashes
DB2 8.1 FP16 or higher is required.
Using DB2 V9.1 for z/OS, Warehouse Proxy agent encounters a large
number of disconnections
When using DB2 for z/OS 9.1 for the warehouse database, the Warehouse Proxy
agent can encounter repeated disconnections from the database. The default idle
thread timeout value (DSN6FAC IDTHTOIN in DSNZPxxx) is 120 seconds. The
Warehouse Proxy agent uses a pool of database connections to process export
requests from monitoring agents. The warehousing interval used by agents can be
set to values ranging from 15 minutes up to 24 hours. The database connections
are idle between export requests, and if the idle thread timeout value is less than
the warehousing interval, the database connections may timeout. This results in
numerous error messages written to the Warehouse Proxy agent log. The
Warehouse Proxy agent "Statistics" workspace will also show a large number of
Disconnections in the "Failure / Disconnections" view.
Chapter 13. Database troubleshooting 227
To Next Page
Loading...
Need help?
General
