DB2 12 for z/OS Technical Overview and HighlightsThis paper provides a high-level overview of the functions, features, and improvements that were introduced in IBM DB2® 12 for z/OS®. These businesses gain a competitive advantage, improve business efficiency and effectiveness, and discover business insights from their existing data. The paper is intended for DB2 system administrators, database administrators, and application programmers, but might also be of interest to IT managers and executives. A more detailed description of DB2 12 is available in IBM DB2 12 for z/OS Technical Overview, SG24-8383. The purpose of this paper is to provide the reader with an understanding of some of the key changes that were introduced in DB2 12 for z/OS, including the following topics:
|
Common terms and phrases
access path avoid buffer pool CPU reduction data set data sharing data type DB2 12 introduces DB2 catalog DB2 development DB2 for z/OS default DELETE DFSMShsm DSSIZE dynamic SQL statements dynamic statement cache EBCDIC feature filtering format FTB area function Global DSC Global Variables IBM DB2 IBM Redbooks IFCID In-Memory insert algorithm introduced in DB2 invalid JSON LOAD REPLACE LOAD utility lock log records LPAR MEMBER CLUSTER modern applications multi-index Netezza objects OLTP optimizer option outer join package pending alters performance enhancements performance improvements plan stability predicates profiles query performance query workloads real memory REBIND reduce relative page numbering release of DB2 REORG utility rows RUNSTATS scalability schema space search specify SQL PL static SQL statistics profiles stored procedure Sysplex system parameter table space target trademarks transaction UDFs Unicode updates upgrade usability UTS PBR values VARCHAR zIIP ZPARM