Fixes are available
DB2 Version 9.5 Fix Pack 3b for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 2a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 4a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
APAR status
Closed as program error.
Error description
The first/last character of CLISCHEMA name could be truncated by CLI_db2schema_SQLColumns(). The problem can be recreated as follows, 1. Make a connection to a database. 2. Call cli stored procedure: sysibm.sqlcolumns() ---------------------------------------------------- db2 "call sysibm.sqlcolumns(null,null,'SESSIONS','%','DATATY PE=JDBC;DYNAMIC=0;REPORTPUBLICPRIVILEGES=1;CLISCHEMA=DB2ADMIN;CU RSORHOLD=0')" ---------------------------------------------------- The above sql should be able to retrieve all columns for DB2ADMIN.SESSIONS table. 3. It fails with SQL0443N error. ---------------------------------------------------- SQL0443N Routine "SYSIBM.SQLCOLUMNS" (specific name "COLUMNS") has returned an error SQLSTATE with diagnostic text "SYSIBM:CLI:-727". SQLSTATE=38553 ---------------------------------------------------- 4. db2 trace shows CLISCHEMA "DB2ADMIN" is truncated to "B2ADMI", ---------------------------------------------------- 3141 mbt DB2 UDB call level interface CLI_db2schema_SQLColumns fnc (6.3.42.865.0.32774) pid 4380 tid 5512 cpid 4140 node 0 sec 1 nsec 596548215 Marker:PD_CLI_DB2SCHEMA_SQLCOLUMNS_STMT Description: SQLColumns executing a dynamic statement bytes 338 Data1 (PD_TYPE_STRINGN,330) String with size: SELECT TABLE_CAT, TABLE_SCHEM, TABLE_NAME, COLUMN_NAME, DATA_TYPE, TYPE_NAME, COLUMN_SIZE, BUFFER_LENGTH, DECIMAL_DIGITS, NUM_PREC_RADIX, NULLABLE, REMARKS, COLUMN_DEF, SQL_DATA_TYPE, SQL_DATETIME_SUB, CHAR_OCTET_LENGTH, ORDINAL_POSITION, IS_NULLABLE FROM B2ADMI.COLUMNS WHERE TABLE_NAME = 'SESSIONS' ORDER BY 1,2,3,17 ----------------------------------------------------
Local fix
Problem summary
All users use this cli stored procedure are affected.
Problem conclusion
First fixed in DB2 version 9.5 fixpack 2. This error is caused by the first/last character of CLISCHEMA name could be truncated by CLI_db2schema_SQLColumns().
Temporary fix
Comments
APAR Information
APAR number
IZ09993
Reported component name
DB2 CEE AIX
Reported component ID
5765F3000
Reported release
950
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2007-12-04
Closed date
2008-08-26
Last modified date
2008-08-26
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
DB2 CEE AIX
Fixed component ID
5765F3000
Applicable component levels
R950 PSY
UP
Document Information
Modified date:
26 August 2008