Hi,
My application accesses DB2 over DB2 CLI and we use the calls
SQLTables, SQLTablePrivileges, SQLColoumns to retrieve the schema
information from the system catalog tables. When we call SQLTables
when using the DB2 Connect Client v7.1.0.40, the call results in the
following query
SQLTables( hStmt=1:1, szTableQualifier=Null Pointer,
cbTableQualifier=0, szTableOwner="P390", cbTableOwner=-3,
szTableName="%", cbTableName=-3, szTableType="TABLE", cbTableType=-3 )
---> Time elapsed - +1.045900E-002 seconds
( StmtOut.=" SELECT CREATOR, NAME, TYPE, REMARKS,
TBCREATOR,TBNAME,LOCATION FROM "SYSIBM".SYSTABLES WHERE CREATOR='P390'
AND CREATOR<>'SYSIBM' AND TYPE='T' ORDER BY 3, 1, 2 FOR FETCH ONLY" )
Our customer was seeing a huge delay when our application was loading
the schema on his production system. It turns out that they are using
the DB2 v7.1.0.93 (Fixpack 11) of DB2 Connect Client on Win2K. This
version uses RTRIM in the SQL call resulting from the application call
to SQLTables. (The 7.1.0.40 does not use RTRIM)
Is there any way I can setup the Connect client so that the RTRIM
function is not called? The DB2 DBA at the client end say that the use
of RTRIM prevents the use of indices, which will obviously impact
performance. Do you have any pointers for this?
Regards
~Rashmi