-Why the prospect of having your Db2 load modules go to a new code level when you do a regular quarterly (for example) upgrade of the Db2 maintenance level: the new code level will not affect your system until you activatethe associated function level •In other words, updating Db2 12 code to support a new function level (via application of a fix) Abstract. Db2 12 for IBM z/OS® delivers several significant business values, such as cost reductions, scalability improvement, and improved application enablement for cloud and mobile environment. Db2 12 also introduces a foundation of continuous delivery. In continuous delivery, new capabilities and enhancements, including performance Db2 12 for z/OS extends the core capabilities of Db2 and empowers its scalability, security, reliability, and efficiency. Db2 12 was created to empower the next wave of applications in the cloud, mobile, and analytics spaces. Db2 12 provides users with the continuous delivery of new capabilities and enhancements as they are made, marking IBM So, what's new with DB2 12 • Performance • Performance Management • Changes for Applications • Scalability • Availability -Now you are able to use DB2 V12 GA new functionality • MODE - does not exist -CM/ENFM/NFM/CM*/ENFM* 43 . APPLCOMPAT • DSN6SPRM.APPLCOMPAT - V12R1M5nn IBM Documentation. newly defined active log data set to the active log inventory without stopping Db2 -Encrypt all active logs • Stop Db2. Copy the contents of the active log data set to an encrypted data set. Restart Db2. Archive logs -New archive logs automatically encrypted based on the key label setting Catalog and directory table spaces So, what [s new with Db2 12 Well take a quick look at the usual suspects: Reliability, Availability, Scalability, Security 2 ut….we cant forget about: Analytics, Autonomics, Cloud, Mobile. So, what [s new with Db2 12 • Performance • Performance Management • Changes for Applications • Scalability comprehensive view of DB2 environments of any level of complexity and to allow a quick and effective top down analysis of DB2 subsystems and workloads. •This goal is accomplished through a completely automated process, without any need for human intervention. 5 EPV for DB2 goals What it's new in EPV for D2 V12 As IBM® continues to enhance the functionality, performance, and availability of IBM Db2® for z/OS, the utilities have made significant strides towards self-management. IBM Db2 for z/OS utilities is leading the trend towards autonomics. During the last couple of (, for z/OS DB2 •New catalog objects. •Old Db2 features added to the catalog. •Modified catalog tablespaces, catalog tables, columns, indexes, relationships. •New Db2 12 features reflected in the catalog. 4 This presentation has 5 main topics: Objects removed from the Db2 catalog. New tablespaces and tables as well as indexes. Db2 AI -Pre-requisites In addition to the hardware requirements specified for Machine Learning for z/OS • An additional 1 GB memory and available capacity on the zIIP processors on the LPAR where Db2 12 is running • z/OS 2.1 or later, with the Product Registration Services component • Db2 12, plus Function Level 503 activated), plus •Under the category of 'What's new in DB2 12 function levels •V12 also increases number of engines from 600 900 SCALE AND SPEED on using new DB2 12 Faster Ingestion -Scale and Speed -Special Case 25 0.003 0.0035 0.004 0.0045 0.005 0.0055 0.006 0.0065 0.007 0.0075 0.008 •Under the catego