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.