A service pack is available from IBM that can improve the performance of slow ODBC connections

Date:19 January 2015
Product/Release:LANSA Composer - All versions
Abstract:A service pack is available from IBM that can improve the performance of ODBC connections.
Submitted By:LANSA Technical Support

IBM has released a Service Pack, SI53809, containing a fix to an issue that caused poorly performing ODBC connections. If you develop transformation maps against remote IBM i's, you should install the Service Pack.

IBM i Access ODBC driver has a default block size of 256KB but it was actually blocked by 4KB. The slowness caused by small block size is noticeable when MapForce is querying against a remote IBM i. This issue has been corrected in the latest SP for 7.1. The performance improvements can be significant, for example, a shipped EDI map against a remote IBM i took appromimately 89 second to open without the SP but took 23 seconds with the Service Pack applied, a map with complex IBM I database component went from 81.4 seconds to 44 second.

Note: "Prepare" times (in the "Generating code" step) should exhibit a performance improvement too.

Instructions to install the service pack for IBM i Access for Windows:

If you have 7.1 installed on your PC:

  • Download SI53809 package from IBM i Access for Windows Service Pack Web site, and install it

If you have 6.1 or older (i.e. 6.1 or 5.4) installed on your PC:

  • Uninstall the current version
  • Install 7.1 from software DVD or IFS, and then apply SI53809 if your 7.1 installation image is not the latest level.

Note: IBM I Access for Windows version is backward compatible. You can use 7.1 Access to connect V5R4, 6.1, 7.1 or 7.2 server.