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:

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.

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



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

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

Learn more


Techdocs QuickSearch

: