Home Services Partners Company
What’s new in high performance data connectivity to IBM DB2/400 on iSeries?

What’s new in high performance data connectivity to IBM DB2/400 on iSeries?

August 31, 2012 0 Comments

There is an increasing number of DB2 on iSeries projects that require enterprise DataDirect ODBC, JDBC, ADO.NET connectivity. From consulting on these projects, I hear great feedback on all the things we're doing right for DB2 on iSeries data access, and it's interesting to hear that core business systems -ERP, MRP, BCPS, etc- continue to run on this platform for decades across a wide range of industries.

Note: You may see DB2 on iSeries referenced as "IBM DB2 for I", "DB2 UDB for iSeries", "DB2/400" or "DB2 on AS/400".

How does DataDirect improve performance to DB2 on iSeries?

Progress DataDirect is focused on building high performance and feature rich data connectivity to DB2 on iSeries (as well as DB2 on LUW and z/OS). This is achieved through our wire protocol technology across ODBC, JDBC, ADO.NET (including Entity Framework) applications that run across all technologies and platforms. And absolutely NO database client libraries are required (read first hand how SPARDAT simplified their DB2 client architecture).

From recent projects, we have proven this architecture is superior for production loads in demanding business critical applications running on the latest physical and virtual systems across public and private clouds.

ADO.NET Architecture

So what's new?

In addition to improved performance with each release, the latest Connect for ODBC 7.0, JDBC 5.0 and ADO.NET 4.0 drivers include support for V7R1. Each driver supports multiple versions of DB2/400 including V5R3, V5R4, V6R1 and V7R1.

The Connect for ODBC DB2 for iSeries driver supports the latest 32-bit and 64-bit HP-UX PA-RISC, HP-UX Itanium, SUSE Linux, Redhat Linux, Solaris SPARC, Solaris x86, AIX and Windows platforms.

The Connect for JDBC DB2 for iSeries driver supports J2SE 5, Java SE 6 and Java 7 (32-bit and 64-bit).

The Connect for ADO.NET DB2 for iSeries driver supports .NET Framework Versions 2.0 SP1 or higher, 3.0 SP1, 4.0, and 4.0 SP1.

And the range of platform support is backed by the largest data connectivity verification suite in the world that run over 80 million tests and growing.

For DB2 on iSeries Entity Framework support, Microsoft has been getting a lot of requests for use with LightSwitch and we delivered the solution. And Alex Woodie from Four Hundred Stuff recently wrote an article about our DB2/400 support with LightSwitch.

We also certify our Connect for JDBC DB2 on iSeries drivers with Hibernate.

In summary, you can read about all the advanced DB2 on iSeries data connectivity features built into the drivers.

What are some recent use cases that improved performance?

  • A DB2 on iSeries shop processes and inserts large volumes of data into DB2/400 using Pervasive Data Integrator; and the overnight batch processing was starting to creep into the following business day. The DataDirect Connect for ODBC DB2 on iSeries Wire Protocol driver was dropped in and provided an instant performance boost to accommodate the load with plenty of room to grow.
  • Another DB2 on iSeries shop upgraded from SQL Server Integration Services 2005 to 2008; and found that SSIS fetch performance had decreased dramatically against DB2. Switching to the DataDirect Connect for ADO.NET DB2 on iSeries driver provided an instant application performance boost so they can continue to meet SLAs after the application upgrade.
  • We're seeing several new web applications (both public and intranet) and data services tiers built on the Entity Framework (EF) with the Connect for ADO.NET DB2 on iSeries provider. Support for EF improves developer productivity while providing a bullet proof run-time once applications go live. For one of the .NET projects, we added new Connection Pool Behaviors to optimize prestart jobs on the iSeries server. This dramatically improved resource usage and performance on both client and server!

What kind of iSeries "street cred" does DataDirect have?

DataDirect R&D and QA have decades of cumulative experience developing and testing connectivity to DB2 on iSeries including Ed Steward, Senior Software Engineer, who has 10+ years experience dating back to V5R1. And I have found iSeries experience in other corners on the 4th floor of the DataDirect office in Morrisville, NC. Bruce Rudd, DataDirect SupportLink Manager, started his career at a blue chip manufacturer developing COBOL applications on AS/400, and then developed a web application to route accounting software for delivery trucks. And Hugh Raiford, Vice President of Sales DataDirect Americas once lead product management and marketing efforts at ClientSoft which was a leader in AS/400 integration prior to be being acquired by NEON Systems and later acquired by Progress Software.

Get started in 15 minutes:

  • Download a trial of any or all ODBC, JDBC, ADO.NET drivers for DB2/400 on iSeries.
  • Or call 1-800-876-3101 to speak with a live Solutions Consultant to learn how other organizations are making progress with connectivity to DB2/400 on iSeries

Try Now

Sumit Sakar

Sumit Sarkar

Sumit Sarkar is a Chief Data Evangelist at Progress, with over 10 years experience working in the data connectivity field. The world's leading consultant on open data standards connectivity with cloud data, Sumit's interests include performance tuning of the data access layer for which he has developed a patent pending technology for its analysis; business intelligence and data warehousing for SaaS platforms; and data connectivity for aPaaS environments, with a focus on standards such as ODBC, JDBC, ADO.NET and ODATA. He is an IBM Certified Consultant for IBM Cognos Business Intelligence and TDWI member. He has presented sessions on data connectivity at various conferences including Dreamforce, Oracle OpenWorld, Strata Hadoop, MongoDB World and SAP Analytics and Business Objects Conference, among many others. 

Comments are disabled in preview mode.