Installing and Configuring IBM Db2 AI for IBM z/OS v1.4.0


Book Description

Artificial intelligence (AI) enables computers and machines to mimic the perception, learning, problem-solving, and decision-making capabilities of the human mind. AI development is made possible by the availability of large amounts of data and the corresponding development and wide availability of computer systems that can process all that data faster and more accurately than humans can. What happens if you infuse AI with a world-class database management system, such as IBM Db2®? IBM® has done just that with Db2 AI for z/OS (Db2ZAI). Db2ZAI is built to infuse AI and data science to assist businesses in the use of AI to develop applications more easily. With Db2ZAI, the following benefits are realized: Data science functionality Better built applications Improved database performance (and DBA's time and efforts are saved) through simplification and automation of error reporting and routine tasks Machine learning (ML) optimizer to improve query access paths and reduce the need for manual tuning and query optimization Integrated data access that makes data available from various vendors including private cloud providers. This IBM Redpaper® publication helps to simplify your installation by tailoring and configuration of Db2 AI for z/OS®. It was written for system programmers, system administrators, and database administrators.




IBM Integrated Synchronization: Incremental Updates Unleashed


Book Description

The IBM® Db2® Analytics Accelerator (Accelerator) is a logical extension of Db2 for IBM z/OS® that provides a high-speed query engine that efficiently and cost-effectively runs analytics workloads. The Accelerator is an integrated back-end component of Db2 for z/OS. Together, they provide a hybrid workload-optimized database management system that seamlessly manages queries that are found in transactional workloads to Db2 for z/OS and queries that are found in analytics applications to Accelerator. Each query runs in its optimal environment for maximum speed and cost efficiency. The incremental update function of Db2 Analytics Accelerator for z/OS updates Accelerator-shadow tables continually. Changes to the data in original Db2 for z/OS tables are propagated to the corresponding target tables with a high frequency and a brief delay. Query results from Accelerator are always extracted from recent, close-to-real-time data. An incremental update capability that is called IBM InfoSphere® Change Data Capture (InfoSphere CDC) is provided by IBM InfoSphere Data Replication for z/OS up to Db2 Analytics Accelerator V7.5. Since then, an extra new replication protocol between Db2 for z/OS and Accelerator that is called IBM Integrated Synchronization was introduced. With Db2 Analytics Accelerator V7.5, customers can choose which one to use. IBM Integrated Synchronization is a built-in product feature that you use to set up incremental updates. It does not require InfoSphere CDC, which is bundled with IBM Db2 Analytics Accelerator. In addition, IBM Integrated Synchronization has more advantages: Simplified administration, packaging, upgrades, and support. These items are managed as part of the Db2 for z/OS maintenance stream. Updates are processed quickly. Reduced CPU consumption on the mainframe due to a streamlined, optimized design where most of the processing is done on the Accelerator. This situation provides reduced latency. Uses IBM Z® Integrated Information Processor (zIIP) on Db2 for z/OS, which leads to reduced CPU costs on IBM Z and better overall performance data, such as throughput and synchronized rows per second. On z/OS, the workload to capture the table changes was reduced, and the remainder can be handled by zIIPs. With the introduction of an enterprise-grade Hybrid Transactional Analytics Processing (HTAP) enabler that is also known as the Wait for Data protocol, the integrated low latency protocol is now enabled to support more analytical queries running against the latest committed data. IBM Db2 for z/OS Data Gate simplifies delivering data from IBM Db2 for z/OS to IBM Cloud® Pak® for Data for direct access by new applications. It uses the special-purpose integrated synchronization protocol to maintain data currency with low latency between Db2 for z/OS and dedicated target databases on IBM Cloud Pak for Data.




Apache Spark Implementation on IBM z/OS


Book Description

The term big data refers to extremely large sets of data that are analyzed to reveal insights, such as patterns, trends, and associations. The algorithms that analyze this data to provide these insights must extract value from a wide range of data sources, including business data and live, streaming, social media data. However, the real value of these insights comes from their timeliness. Rapid delivery of insights enables anyone (not only data scientists) to make effective decisions, applying deep intelligence to every enterprise application. Apache Spark is an integrated analytics framework and runtime to accelerate and simplify algorithm development, depoyment, and realization of business insight from analytics. Apache Spark on IBM® z/OS® puts the open source engine, augmented with unique differentiated features, built specifically for data science, where big data resides. This IBM Redbooks® publication describes the installation and configuration of IBM z/OS Platform for Apache Spark for field teams and clients. Additionally, it includes examples of business analytics scenarios.




DB2 11 for z/OS Technical Overview


Book Description

IBM® DB2® Version 11.1 for z/OS® (DB2 11 for z/OS or just DB2 11 throughout this book) is the fifteenth release of DB2 for IBM MVSTM. It brings performance and synergy with the IBM System z® hardware and opportunities to drive business value in the following areas. DB2 11 can provide unmatched reliability, availability, and scalability - Improved data sharing performance and efficiency - Less downtime by removing growth limitations - Simplified management, improved autonomics, and reduced planned outages DB2 11 can save money and save time - Aggressive CPU reduction goals - Additional utilities performance and CPU improvements - Save time and resources with new autonomic and application development capabilities DB2 11 provides simpler, faster migration - SQL compatibility, divorce system migration from application migration - Access path stability improvements - Better application performance with SQL and XML enhancements DB2 11 includes enhanced business analytics - Faster, more efficient performance for query workloads - Accelerator enhancements - More efficient inline database scoring enables predictive analytics The DB2 11 environment is available either for new installations of DB2 or for migrations from DB2 10 for z/OS subsystems only. This IBM Redbooks® publication introduces the enhancements made available with DB2 11 for z/OS. The contents help database administrators to understand the new functions and performance enhancements, to plan for ways to use the key new capabilities, and to justify the investment in installing or migrating to DB2 11.




IBM Z Integration Guide for Hybrid Cloud


Book Description

Today, organizations are responding to market demands and regulatory requirements faster than ever by extending their applications and data to new digital applications. This drive to deliver new functions at speed has paved the way for a huge growth in cloud-native applications, hosted in both public and private cloud infrastructures. Leading organizations are now exploiting the best of both worlds by combining their traditional enterprise IT with cloud. This hybrid cloud approach places new requirements on the integration architectures needed to bring these two worlds together. One of the largest providers of application logic and data services in enterprises today is IBM Z, making it a critical service provider in a hybrid cloud architecture. The primary goal of this IBM Redpaper publication is to help IT architects choose between the different application integration architectures that can be used for hybrid integration with IBM Z, including REST APIs, messaging, and event streams.




Using IBM z/OS WLM to Measure Mobile and Other Workloads


Book Description

This IBM® RedpaperTM publication discusses the need to monitor and measure different workloads, especially mobile workloads. It introduces the workload classification capabilities of IBM z SystemsTM platforms and helps you to understand how recent enhancements to IBM MVSTM Workload Management (WLM) and other IBM software products can be used to measure the processor cost of mobile workloads. This paper looks at how mobile-initiated and other transactions in IBM CICS®, IMSTM, DB2®, and WebSphere® Application Server can be "tagged and tracked" using WLM. For each of these subsystems, the options for classifying mobile requests and using WLM to measure mobile workloads are reviewed. A scenario is considered in which a bank is witnessing a significant growth in mobile initiated transactions, and wants to monitor and measure the mobile channels more closely. This paper outlines how the bank can use WLM to do this. This publication can help you to configure WLM mobile classification rules. It can also help you to interpret Workload Activity reports from IBM RMFTM Post Processor and to report on the CPU consumption of different workloads, including mobile and public cloud workloads.







Machine Learning with Business Rules on IBM Z: Acting on Your Insights


Book Description

This Redpaper introduces the integration between two IBM products that you might like to consider when implementing a modern agile solution on your Z systems. The document briefly introduces Operational Decision Manager on z/OS and Machine learning on z/OS. In the case of Machine Learning we focus on the aspect of real-time scoring models and how these can be used with Business Rules to give better decisions. Note: Important changes since this document was written: This document was written for an older release of Operational Decision Manager for z/OS (ODM for z/OS). ODM for z/OS 8.9.1 required the writing of custom Java code to access a Watson Machine Learning for z/OS Scoring Service (this can be seen in ). Since that time ODM for z/OS version 8.10.1 has been released and much improves the integration experience. Integrating the two products no longer requires custom Java code. Using ODM for z/OS 8.10.1 or later you can use an automated wizard in the ODM tooling to: Browse and select a model from Watson Machine Learning Import the Machine Learning data model into your rule project Automatically generate a template rule that integrates a call to the Watson Machine Learning scoring service Download and read this document for: Individual introductions to ODM for z/OS and Machine learning Discussions on the benefits of using the two technologies together Information on integrating if you have not yet updated to ODM for z/OS 8.10.1 For information about the machine learning integration in ODM for z/OS 8.10.1 see IBM Watson Machine Learning for z/OS integration topic in the ODM for z/OS 8.10.x Knowledge Center




z/OS Version 1 Release 12 Implementation


Book Description

This IBM® Redbooks® publication describes changes in installation and migration when migrating from a current z/OS® V1R10 and z/OS V1R11 to z/OS V1R12. Also described are tasks to prepare for the installation of z/OS V1R12, including ensuring that driving system and target system requirements are met, and coexistence requirements are satisfied. New migration actions are introduced in z/OS V1R12. This book focuses on identifying some of the new migration actions that must be performed for selected elements when migrating to z/OS V1R12. This book describes the following enhancements: z/OS V1R12 installation, HiperDispatch, System Logger, Auto-reply to WTORs, Real Storage Manager (RSM) DFSMS, DFSORT, Services aids, z/OS Infoprint Server, TSO/E, RMFTM, Language Environment®, BCP allocation XML System Services, z/OS UNIX® System Services, BCP supervisor, Extended Address Volumes HyperSwap®. BCPii, (de)ciphering, Predictive Failure Analysis, C language, Hardware instrumentation services FICON® dynamic channel-path management, Workload Manager, SDSF, JES2, JES3, SMF, GRS, XCF, HCD Unicode, Capacity provisioning, RRS, Parallel subsystems initialization z/OS Management Facility (z/OSMF)




Hybrid Analytics Solution using IBM DB2 Analytics Accelerator for z/OS V3.1


Book Description

The IBM® DB2® Analytics Accelerator Version 3.1 for IBM z/OS® (simply called Accelerator in this book) is a union of the IBM System z® quality of service and IBM Netezza® technology to accelerate complex queries in a DB2 for z/OS highly secure and available environment. Superior performance and scalability with rapid appliance deployment provide an ideal solution for complex analysis. In this IBM Redbooks® publication, we provide technical decision-makers with a broad understanding of the benefits of Version 3.1 of the Accelerator's major new functions. We describe their installation and the advantages to existing analytical processes as measured in our test environment. We also describe the IBM zEnterprise® Analytics System 9700, a hybrid System z solution offering that is surrounded by a complete set of optional packs to enable customers to custom tailor the system to their unique needs..