SAP Note 152872 - Varying fetch times displayed in ST05 trace of an SQL statem

Component : DB2 Universal Database for Unix / NT - Database Interface/DBMS for DB2 Universal Database

Solution : https://service.sap.com/sap/support/notes/152872 (SAP Service marketplace login required)

Key words :
result sets include variable length columns, db2 update dbm cfg, local memory cache depends, additional key words tcp_nodelay, symptom varying fetch times, db2 automatically sets tcp_nodelay, andthe fetches times vary, rqioblk database configuration parameter, db2 client retrieving information, approximately 5 times longer

Related Notes :

72638Performance problems with SQL*Net