Wednesday, May 25, 2011

Improve throughput of your CLI application using LOAD in ASYNC mode ...

In recent 9.7 FP4 release of DB2 Connect, CLI enhanced its LOAD operation to allow in asynchronous way. What this means is that CLI application can now do other activity while expensive LOAD operation is going on in the background (in async thread). This feature is really a boon for applications which are primarily targeted to insert/LOAD massive data to the database servers.

You can learn more about this from http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=/com.ibm.db2.luw.apdv.cli.doc/doc/r0006814.html, look for SQL_ATTR_ASYNC_ENABLE and SQL_ATTR_USE_LOAD_API.

There are bunch of other nice enhancements CLI has made in 9.7 FP4; which can be found here: http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=/com.ibm.db2.luw.wn.doc/doc/c0055321.html