Fixes are available
DB2 Version 9.1 Fix Pack 7 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 5 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 6 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 6a for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 7a for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 8 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 9 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 10 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12 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
CLI_db2schema_SQLColumns() does not handle CLISCHEMA name correctly.
Problem conclusion
First fixed in V91 FP5
Temporary fix
Comments
APAR Information
APAR number
IZ09989
Reported component name
DB2 CEE AIX
Reported component ID
5765F3000
Reported release
910
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2007-12-04
Closed date
2008-06-23
Last modified date
2008-06-23
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
R910 PSY
UP
Document Information
Modified date:
23 June 2008