Skip to main content

Techdocs Library > Hints, tips & Technotes >

Maximizing offload to zIIP processors with DB2 9 for z/OS native SQL stored procedures

Document Author:

Richard Corrihons

Document ID:


Doc. Organization:

IBM Systems

Document Revised:


Product(s) covered:

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.

Maximizing offload to zIIP processors with DB2 9 for zOS native SQL stored procedures V1.0.pdf






IBM System z Family

S/W Pillar(s):

Information Management




stored procedures, native, SQL PL, DB2 for z/OS, DB2 v9, DB2 9, zIIP, IIP, JDBC, DRDA, type 2, type 4, scalability, performance

The Techdocs Library
Is this your first visit to Techdocs (the Technical Sales Library)?

Learn more

Techdocs QuickSearch