ZIIP
From Wikipedia, the free encyclopedia
- The correct title of this article is zIIP. The initial letter is shown capitalized due to technical restrictions.
IBM System z9 Integrated Information Processor (IBM zIIP) is the latest special purpose mainframe processor following the zAAP and IFL. The main purpose of the zIIP is to offload DB2 processing from the general central processors (CPs) to the less expensive zIIP, much like how the zAAP and IFL offload Java and Linux processing, respectively. DB2 V8 for z/OS is the first application to exploit the zIIP. The zIIP requires a System z9 mainframe, and IBM offers PTFs for z/OS 1.6 and 1.7 to enable zIIP usage. (z/OS 1.8 and the forthcoming DB2 V9 for z/OS exploit zIIPs in their first releases, without PTFs.)
IBM publicly disclosed information about zIIP technology on January 24, 2006. The zIIP hardware (i.e. microcode) became generally available in May, 2006. The z/OS and DB2 PTFs to take advantage of the zIIP hardware became generally available in late June, 2006.
zIIPs add lower cost capacity for three types of DB2 work:
- Remote DRDA access via TCP/IP. This category includes JDBC and ODBC access to DB2, including access across LPARs via Hipersockets, such as Linux on System z9. The exception is access to DB2 V8 stored procedures.
- Business intelligence queries, specifically star schema.
- Parallel query operations
- Certain DB2 utilities processing.