Showing documents 1 to 20 of 150  Next

Results per page: 5 | 10 | 20


cover image

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]


cover image

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]


cover image

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]


cover image

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]


cover image

In-Place Analytics with Live Enterprise Data with IBM DB2 Query Management Facility
z Systems

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]


cover image

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]


cover image

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]


cover image

New Approach to Analytics for IBM IMS Data
z Systems

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]


cover image

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]


cover image

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]


cover image

Building an API Bridge to Your IBM z Systems Applications and Data
z Systems

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]


cover image

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]


cover image

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]


cover image

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]


cover image

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]


cover image

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]


cover image

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]


cover image

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]


cover image

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]


cover image

Data Integration in the Big Data World Using IBM InfoSphere Information Server
Analytics

Solution Guide, published 29 Mar 2015

An Apache Hadoop infrastructure offers great promise for drastically reducing the costs of storing and processing large data volumes and increasing ROI. However, Hadoop cannot deliver the opportunities by using only its infrastructure. Success with Hadoop requires effectively managing data movement, data transformation and integration, data cleansing, data governance, data security, data privacy, and data analytics and reports. Many organizations are considering implementing a data lake solution. This is a set of one or more data repositories that have been created to support data discovery, ... [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.



IBM Redbooks Mobile App
Redbooks mobile app

The newest version of the official IBM Redbooks mobile app provides automated notifications for new and updated Redbooks content that is specifically tailored to your interests.


Follow IBM Redbooks

Follow IBM Redbooks