Inserter caching is implemented by setting the field SQL_DESC_ARRAY_SIZE on the SQLHSTMT's APD (Application Parameter Descriptor). Inserter caching is fully supported by the DB2 CLI Access Library. By default, the cache size is set at 10.
Reader caching is internally implemented by setting the SQL_ATTR_ROW_ARRAY_SIZE attribute on the SQLHSTMT being used. Reader caching is fully supported by the DB2 CLI Access Library.
Increasing the cache parameter when producing an RWDBReader increases the number of rows fetched at a time, which can improve performance. By default, the cache size is set at 10.
©Copyright 2000, Rogue Wave Software, Inc.
Contact Rogue Wave about documentation or support issues.