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:	TD104524
Doc. Organization:	Systems and Technology Group		Document Revised:	04/15/2008
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.

Classification:	Software	Category:	Performance
Platform(s):	IBM System z Family	S/W Pillar(s):	Information Management
O/S:	z/OS	Keywords:	stored procedures, native, SQL PL, DB2 for z/OS, DB2 v9, DB2 9, zIIP, IIP, JDBC, DRDA, type 2, type 4, scalability, performance