IZ09989: CLI_DB2SCHEMA_SQLCOLUMNS() DOES NOT HANDLE CLISCHEMA NAME CORRECTLY.

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 is sysrouted FROM one or more of the following:

  IZ09988

• 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