Systems and Technology Group
DB2 for z/OS and OS/390
|Abstract: This document is based on what has been observed and measured during the benchmark of an OLTP banking application that makes extensive use of the new native SQL language stored procedures support in DB2 9® for z/OS.|
We conducted several tests from transaction unit test to multiple LPAR (horizontal) scalability tests to find out how native SQL stored procedures behave in a stress test environment. We compared JDBC® type 2 versus type 4 connections, in order to give recommendations for a production environment. As native SQL stored procedures are zIIP eligible under certain conditions, we also measured the exact zIIP offload.
IBM System z Family
stored procedures, native, SQL PL, DB2 for z/OS, DB2 v9, DB2 9, zIIP, IIP, JDBC, DRDA, type 2, type 4, scalability, performance
|Is this your first visit to Techdocs (the Technical Sales Library)?