Results per page:
Exploring IBM Db2 for z/OS Continuous Delivery
Information Management
Redpaper, published 21 Mar 2018
This IBM® Redpaper™ publication provides key information about continuous delivery in IBM Db2® 12 for z/OS®. It discusses how continuous delivery works and the changes that have been made in Db2 12 to support continuous delivery, such as adding a new catalog table and changing existing catalog tables. Also the paper covers the effects on applications and how to take advantage of new function provided using the continuous delivery model.
IBM Db2 12 for z/OS Performance Topics
Information Management
Redbooks, published 19 Sep 2017
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 features, are delivered through function levels without waiting for a new release. Function levels 100 and 500 activate the initial set of enhancements and capabilities in Db2 12. For migration from Db2 11, most new capabilities become available in Db2 12 only after the ... [more]
DB2 12 for z/OS Technical Overview and Highlights
Information Management
Product Guide, published 30 Jun 2017, last updated 12 Jul 2017
This 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 ... [more]
DB2 12 for z Optimizer
Information Management
Redpaper, published 28 Jun 2017
There has been a considerable focus on performance improvements as one of the main themes in recent IBM DB2® releases, and DB2 12 for IBM z/OS® is certainly no exception. With the high-value data retained on DB2 for z/OS and the z Systems platform, customers are increasingly attempting to extract value from that data for competitive advantage. Although customers have historically moved data off platform to gain insight, the landscape has changed significantly and allowed z Systems to again converge operational systems with analytics for real-time insight. Business-critical analytics is now ... [more]
IBM DB2 12 for z/OS Technical Overview
Information Management
Redbooks, published 13 Dec 2016
IBM® DB2® 12 for z/OS® delivers key innovations that increase availability, reliability, scalability, and security for your business-critical information. In addition, DB2 12 for z/OS offers performance and functional improvements for both transactional and analytical workloads and makes installation and migration simpler and faster. DB2 12 for z/OS also allows you to develop applications for the cloud and mobile devices by providing self-provisioning, multitenancy, and self-managing capabilities in an agile development environment. DB2 12 for z/OS is also the first version of DB2 built for ... [more]
In-Place Analytics with Live Enterprise Data with IBM DB2 Query Management Facility
IBM Z
Redbooks, published 21 Oct 2016
IBM® DB2® Query Management Facility™ for z/OS® provides a zero-footprint, mobile-enabled, highly secure business analytics solution. IBM QMF™ V11.2.1 offers many significant new features and functions in keeping with the ongoing effort to broaden its usage and value to a wider set of users and business areas. In this IBM Redbooks® publication, we explore several of the new features and options that are available within this new release. This publication introduces TSO enhancements for QMF Analytics for TSO and QMF Enhanced Editor. A chapter describes how the QMF Data Service component ... [more]
DB2 11 for z/OS Technical Overview
Information Management
Redbooks, published 31 Dec 2013, last updated 5 May 2016
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 MVS™. 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 ... [more]
SQL Procedures, Triggers, and Functions on IBM DB2 for i
Power Systems
Redbooks, published 25 Apr 2016
Structured Query Language (SQL) procedures, triggers, and functions, which are also known as user-defined functions (UDFs), are the key database features for developing robust and distributed applications. IBM® DB2® for i supported these features for many years, and they are enhanced in IBM i versions 6.1, 7.1, and 7.2. DB2 for i refers to the IBM DB2 family member and relational database management system that is integrated within the IBM Power operating system that is known as IBM i. This IBM Redbooks® publication includes several of the announced features for SQL procedures, triggers, and ... [more]
New Approach to Analytics for IBM IMS Data
IBM Z
Solution Guide, published 17 Apr 2016
IBM® Information Management System (IMS™) applications and data are the core of critical online transaction processing (OLTP) workloads for many of the world’s major organizations. This operational data, when analyzed properly, forms the basis for making better decisions by organizations running IMS. With IBM DB2® Analytics Accelerator for z/OS®, you can exploit your IBM z Systems™ platform’s IMS data where it originates so that delivering new insights to improve efficiency and drive smart outcomes is possible. Critical business insights that are gained by performing analytics on IMS ... [more]
Improving Police "Body Cam" Programs with an End-to-End Solution
Information Management
Redpaper, published 8 Jan 2016, last updated 13 Jan 2016
Policing in the 21st Century saw major advances in technology and operational efficiency and an increased focus on accountability. Citizens play a huge role in the equation as critical first communicators at crime and accident scenes. The perspective of the law enforcement officer (LEO) is equally vital. And today, that perspective is frequently, and increasingly, captured by using body-worn cameras (BWCs). This IBM® Redpaper™ publication aims to identify the key technical areas to address when a police agency deploys BWCs. However, rather than focus on the camera itself, we describe a ... [more]
Accelerating Data Transformation with IBM DB2 Analytics Accelerator for z/OS
Information Management
Redbooks, published 10 Dec 2015, last updated 11 Dec 2015
Transforming data from operational data models to purpose-oriented data structures has been commonplace for the last decades. Data transformations are heavily used in all types of industries to provide information to various users at different levels. Depending on individual needs, the transformed data is stored in various different systems. Sending operational data to other systems for further processing is then required, and introduces much complexity to an existing information technology (IT) infrastructure. Although maintenance of additional hardware and software is one component, ... [more]
Building an API Bridge to Your IBM z Systems Applications and Data
IBM Z
Point-of-View, published 4 Dec 2015
Enterprises worldwide have a wealth of application logic and capabilities that have formed the backbone of their online transaction processing (OLTP) workloads for decades. This application logic and these capabilities are core business assets and are industrial strength, proven, and time-tested. The question enterprises are pondering today is: How can they extend the value these applications provide and reuse parts of the applications to reach new audiences? Application programming interfaces (APIs) make it possible for the enterprise's core assets to be reused, shared, and even monetized ... [more]
Modernize Your IBM DB2 for IBM z/OS Maintenance with Utility Autonomics
Information Management
Redbooks, published 20 Aug 2015
IBM® DB2® for IBM z/OS® helps lower the cost of managing data by automating administration, increasing storage efficiency, improving performance, and simplifying the deployment of virtual appliances. By automating tasks such as memory allocation, storage management, and business policy maintenance, DB2 is able to perform many management tasks itself, freeing up Database Administrators to focus on new projects. This IBM Redbooks® publication introduces autonomics for DB2 for z/OS. IBM provides several different components that, when combined, can create an autonomic database environment. All ... [more]
Subsystem and Transaction Monitoring and Tuning with DB2 11 for z/OS
Information Management
Redbooks, published 28 Feb 2014, last updated 29 Jul 2015
This IBM® Redbooks® publication discusses in detail the facilities of DB2® for z/OS®, which allow complete monitoring of a DB2 environment. It focuses on the use of the DB2 instrumentation facility component (IFC) to provide monitoring of DB2 data and events and includes suggestions for related tuning. We discuss the collection of statistics for the verification of performance of the various components of the DB2 system and accounting for tracking the behavior of the applications. We have intentionally omitted considerations for query optimization; they are worth a separate document. Use ... [more]
Optimizing Database Administration with IBM DB2 Autonomics for z/OS
Information Management
Solution Guide, published 17 Jul 2015
We live in an age when data is one of an organization’s most important assets. Companies want the ability to deliver the right information to the right people at the right time. Being agile and applying predictive analytics is the key to the insights needed to grow business so that it remains at a peak competitive edge. The cost of database administration can greatly exceed the cost of the database software and hardware, so it is critical that your database administrator’s time is used effectively and efficiently. IBM® DB2® for z/OS® helps lower the cost of managing data by automating ... [more]
Converting Adabas to IBM DB2 for z/OS with ConsistADS
Information Management
Redpaper, published 13 Jan 2015, last updated 12 Jun 2015
Consist Advanced Development Solution (ConsistADS) is an end-to-end conversion solution that conversion and transparency methods for migrating to IBM® DB2® for z/OS® software. The solution includes DB2 for z/OS and several DB2 tools as part of the package. This IBM Redpaper™ publication explains the Natural and Adabas conversion to DB2 for z/OS by using ConsistADS. It includes prerequisite technical assessment requirements and conversion challenges. It also describes a real customer conversion scenario that was provided by the IBM Business Partners that facilitated these conversions for ... [more]
Architecting and Deploying DB2 with BLU Acceleration
Information Management
Redbooks, published 13 Oct 2014, last updated 11 May 2015
IBM® DB2® with BLU Acceleration is a revolutionary technology that is delivered in DB2 for Linux, UNIX, and Windows Release 10.5. BLU Acceleration delivers breakthrough performance improvements for analytic queries by using dynamic in-memory columnar technologies. Different from other vendor solutions, BLU Acceleration allows the unified computing of OLTP and analytics data inside a single database, therefore, removing barriers and accelerating results for users. With observed hundredfold improvement in query response time, BLU Acceleration provides a simple, fast, and easy-to-use solution ... [more]
Implementation Best Practices for IBM DB2 BLU Acceleration with SAP BW on IBM Power Systems
Power Systems
Redbooks, published 11 May 2015
BLU Acceleration is a new technology that has been developed by IBM® and integrated directly into the IBM DB2® engine. BLU Acceleration is a new storage engine along with integrated run time (directly into the core DB2 engine) to support the storage and analysis of column-organized tables. The BLU Acceleration processing is parallel to the regular, row-based table processing found in the DB2 engine. This is not a bolt-on technology nor is it a separate analytic engine that sits outside of DB2. Much like when IBM added XML data as a first class object within the database along with all the ... [more]
Reliability and Performance with IBM DB2 Analytics Accelerator V4.1
Information Management
Redbooks, published 24 Sep 2014, last updated 11 May 2015
The IBM® DB2® Analytics Accelerator for IBM z/OS® is a high-performance appliance that integrates the IBM zEnterprise® infrastructure with IBM PureData™ for Analytics, powered by IBM Netezza® technology. With this integration, you can accelerate data-intensive and complex queries in a DB2 for z/OS highly secure and available environment. DB2 and the Analytics Accelerator appliance form a self-managing hybrid environment running online transaction processing and online transactional analytical processing concurrently and efficiently. These online transactions run together with business ... [more]
IBM Cloudant: Database as a Service Advanced Topics
Information Management
Redpaper, published 17 Apr 2015
This IBM® Redpaper™ publication describes advanced topics for IBM Cloudant, a NoSQL JSON document store that is optimized for handling heavy workloads of concurrent reads and writes in the cloud, a workload that is typical of large, fast-growing web and mobile apps. You can use Cloudant as a fully-managed DBaaS running on public cloud platforms like IBM SoftLayer or via an on-premise version called Cloudant Local that you can run yourself on any private, public, or hybrid cloud platform. This paper is the third in a series of IBM Redbooks® publications on Cloudant. Be sure to read the ... [more]
The above is a list of IBM Redbooks and Redpapers on Information Management, showing most recently published first. Most of these publications are available in Adobe PDF format and may be viewed online or downloaded for offline viewing and printing. Read our How to buy page for details on how to order a bound hardcopy.
RSS Feeds for IBM Information Management