SAP on DB2 for z/OS - List of all documents (Archive)

2016
2015
2014
2013 and older

2016

Edition 12/2015 of Business Continuity Guide available

A new edition of the guide Business Continuity for SAP on IBM z Systems is available. It is the complete technical reference documentation for everything related to High Availability (HA) around SAP on System z. Major new topics covered in this guide include automation for SAP Solution Manager Diagnostics Agent (SMDA) instances on z/OS and the "SAP high availability policy feature" of System Automation for Multiplatforms 4.1 for automating application servers on AIX or Linux. 12 Jan 2016

2015

IBM Red Alert: z/OS Unicode Services Conversion Information Service fails after December 15, 2015

Unicode Services conversion information service on all current z/OS releases will return incorrect return code on systems IPLed on or after December 15, 2015 affecting many system services and applications. For details see IBM - Red Alerts subscription service .
This error affects NFS as well as any DB2 workload ! 08 Oct 2015

SAP on IBM z Systems: HA Verification with SAP HA Test Tool

This article is intended to provide “hands-on” assistance to test and verify the high availability of your SAP solution with the SAP High Availability (HA) Test Tool. The sample use cases can verify various aspects of high availability of your SAP on IBM® z Systems™ Business Continuity environment. They can be used to initially verify high availability and even after environment changes reassure high availability. 07 Oct 2015

Leveraging DB2 for z/OS Accounting Data within the SAP DBA Cockpit

This document describes new functionality within SAP's DBA Cockpit that lets you tie in historical DB2 accounting data provided via an accounting database. The example of the IBM Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS (OMEGAMON XE DB2 PE) Performance Database (PDB), which is the first vendor tool that has been integrated, is used to illustrate this new functionality. The new capability simplifies the analysis of database-related problems in SAP landscapes running on DB2 for z/OS. 09 Sep 2015

SAP Business Application Accelerator supported by DB2 for z/OS and the IBM DB2 Analytics Accelerator

The IBM DB2 Analytics Accelerator (DB2 Accelerator) is a workload-optimized appliance add-on to DB2 for z/OS that accelerates SQL queries with unprecedented response time. This documentation demonstrates how the DB2 Accelerator can be exploited to boost SAP business applications. 02 Apr 2015

DB2 Connect 10.5 FP5 released

DB2 Connect 10.5 FP5 is now available on Service Marketplace. As a prerequisite to use the new Fixpak in an ABAP environment you have to apply lib_dbsl according to note 2049140.
For Java environments of releases 7.00, 7.01, 7.02 the error described in note 2119284 is also fixed. 12 Feb 2015

Updated: Dynamically Exploit a HiperSockets Network

HiperSockets devices provide the fastest TCP/IP communication between applications running in different LPARs within a single System z machine. Providing that the SAP Application Server (AS) under Linux for IBM System z and the Database system (DB) both reside on the same physical System z machine (CEC), then the option to utilize the System z internal HiperSockets network interface is available to you. This article can help you to configure and dynamically activate a HiperSockets network interface.15 Jan 2015

Updated: Reference Architectures

The SAP for Insurance on IBM System z Reference Architecture and the SAP for Banking on System z Reference Architecture have been updated recently. Follow the links to access the current versions. 08 Jan 2015

2014

Edition 12/2014 of Business Continuity Guide available

A new edition of the guide "Business Continuity for SAP on IBM System z" is available. It is the complete technical reference documentation for everything related to High Availability (HA) for SAP on System z. Major new topics include coverage of IBM System Automation for z/OS 3.5 (generally available since Sept. 2014) and an improved SAP Web Dispatcher policy. 18 Dec 2014

DB2 Connect 10.5 FP4 released

DB2 Connect 10.5 SP4 is now available on Service Marketplace. As a prerequisite to use the new Fixpak in an ABAP environment you have to apply lib_dbsl according to note 2049140. 31 Oct 2014

Statement Cache History unwanted switched on

Statement Cache History unwanted switched on
Although you disabled the Statement Cache History in DBACockpit configuration it will be switched on automatically with SAPCL 7.20 PL16 (see note 913109 for corresponding patch levels of other releases). Note 2070370 documents the temporary workaround to disable the DSC history again, the issue will be fixed with SAPCL 7.20 PL17. 30 Sep 2014

SAP on IBM System z & DB2 for z/OS - Info Bundle

SAP and IBM compiled an information bundle which contains an overview presentation, solution briefs, architecture guides as well as many customer references. Follow this link or the link in the Key Topics section. 25 Aug 2014

Monitoring and Administration - News and Improvements

The Monitoring and Administration page has been updated with the latest news. 19 Aug 2014

Rapid Direct Access to Transactional Data in DB2 for z/OS by SAP NetWeaver Business Warehouse

The IBM DB2 Analytics Accelerator (DB2 Accelerator) is a workload optimized appliance add-on to DB2 for z/OS that accelerates SQL queries with unprecedented response time. The DB2 Accelerator can dramatically speed-up access to data that resides in a transactional system for reporting in SAP NetWeaver Business Warehouse (SAP BW) without extracting, transferring and loading the data to the SAP BW system. The approach shown in this documentation allows near real-time operational business intelligence and snap shot reporting with minimal impact on resource consumption in the transactional system. 15 May 2014

Casebook: DB2 backup, recovery and cloning for SAP environments - Update

As a strategic solution, DB2 for z/OS provides the integrated BACKUP SYSTEM and RESTORE SYSTEM utilities, which internally rely on DS8000 FlashCopy and z/OS DFSMShsm technology. The DB2 Cloning Tool and the DB2 Recovery Expert for z/OS can be optionally used to further facilitate, automate and accelerate many of the tasks. The 2014 edition provides hands-on tips and tricks based on DB2 11 and z/OS 2.1 for using the above mentioned DB2 utilities and tools in SAP environments in the most beneficial way.

For DB2 10 and z/OS 1.13 the 2012 edition is still valid. 2 May 2014

Setup of New DB2 Data-Sharing Failover Solution with the SAP Failover Configuration Tool

The Failover Configuration Tool is a tool, that eases the definition of connections to an IBM DB2 for z/OS database and assists in the setup of a failover configuration environment. This article describes how to use the Failover Configuration Tool in detail and provides several screenshots that visualize the configuration of an ABAP-based SAP system. 14 Apr 2014

User Guide for SAP DB2 Conversion Tool - Update

The SAP DB2 Conversion Tool is a generic tool, which converts various storage parameters of SAP objects and stores them on the IBM database DB2 for z/OS. The updated article describes the use of the SAP DB2 Conversion Tool in detail and provides screenshots for an ABAP-based SAP system. 10 Apr 2014

DB2 11 for Mission-Critical SAP Solutions

Mission-critical SAP Business Suite applications like ERP or SAP industry solutions like SAP for Banking have been successfully deployed by leading customers on DB2 for z/OS. To learn more about the technology intersections between SAP and System z, refer to this article in IBM Systems Magazine. 24 Jan 2014

2013 and older

New Edition of Business Continuity Guide available

The 12/2013 edition of the Business Continuity for SAP on IBM System z covers the latest releases of the SAP and IBM software components and has special focus on enhancements in the *SAPSRV add-on policy which comes with System Automation for z/OS 3.4 (APAR OA43145). 17 Dec 2013

PTF Checker requires updates

Due to changes in the SAP internal notes infrastructure the PTF check tool had to be changed (report RSDB2FIX). Apply note 1942514 to get the required corrections, otherwise outdated versions of notes 81737 and 364109 are read instead of the current versions. 16 Dec 2013

New Best Practice document for DB2 11

A new Best Practice document for the migration to DB2 11 is available now, see Related Recources section below. 4 Nov 2013

HAlib implementation for SA z/OS available

The System Automation (SA) for z/OS APAR OA41749 delivers an implementation of SAP's HAlib functionality for SAP Central Services on z/OS. Together with the *SAPSRV 'best-practice' policy the HAlib ensures seamless integration of SAPlifecycle operations (e.g. via SAP MC or SAP SUM/EhPI) and SA z/OS.
For details see the documentation that comes with OA41749 and the SAP Community Network at http://scn.sap.com/docs/DOC-70154. 19 Jul 2013

High Availability with SA z/OS updates and fixes

A new SAP Note 1823660 "High Availability with SA z/OS updates and fixes" is available. Customers with HA-installations should refer to this note for up-to-date information about new HA functionality and required service levels. The note should be used together with the Business Continuity for SAP on IBM System z guide when implementing HA installations for on System z. 12 Mar 2013

RELEASED: SAP Import with Fastload on DB2 10

After an elaborate implementation and test program we are now able to support the Fastload feature for SAP installations, unicode conversions and system copies on DB2 10 for z/OS. Fastload is up to 5 times faster than the standard INSERT based load mechanism. Furthermore, massive logging activities are avoided and indexes are built up very quickly. For details refer to SAP Notes 1062976 and 1780204. 07 Jan 2013

SAP Legacy Connector (SAPLCO)

SAP Legacy Connector (SAP LCO) is a software package which is intended to support projects in the z/OS environment. SAP LCO makes it possible to communicate synchronously between CICS, IMS or Batch applications on IBM mainframes and SAP systems. With SAP LCO, you can also call simple CICS programs or IMS transactions from SAP programs. The documentation of this package has been updated. Updated 07 Jan 2013

SAP HA Installations on z/OS and Windows Application Servers

This document is intended to help you in using Windows Services for NFS to share data between SAP systems located on z/OS and Windows. Updated 10 Jan 2013

Casebook - 2012 Edition Tightly Integrated DB2 Backup, Recovery and Cloning for SAP Environments

Among the key capabilities of database systems relevant for SAP applications are non-disruptive and efficient backup methods, automated and fast recovery to current and to a prior point in time, and fast and flexible system cloning. The DB2 Cloning Tool and the DB2 Recovery Expert for z/OS can be used to further facilitate, automate and accelerate many of the tasks. See this article for all details. 19 Mar 2012

User Guide for SAP DB2 Conversion Tool

The SAP DB2 Conversion Tool is a generic tool, which converts various storage parameters of SAP objects and stores them on the IBM database DB2 for z/OS. This article describes the use of the SAP DB2 Conversion Tool in detail and provides screenshots for an ABAP-based SAP system. 5 Mar 2012

Using Database Performance Warehouse to Monitor IBM DB2 for z/OS - Customizing Reports (Part 3)

In the Database Performance Warehouse, all relevant data concerning database space consumption that is collected by the DBA Cockpit is stored in an SAP Business Intelligence (BI) system. This SAP BI system is used by the SAP Solution Manager Diagnostics (SMD) back end of an SAP Solution Manager system. SAP provides content for the DBA Cockpit to analyze the different technical areas related to space consumption of a DB2 system. See this article for more details. 16 Jan 2012

Rapid SAP NetWeaver BW ad-hoc Reporting Supported by IBM DB2 Analytics Accelerator for z/OS

IBM DB2 Analytics Accelerator for z/OS V2.1 powered by Netezza technology (IDAA) just has been released. This paper describes how the IDAA can be integrated into SAP NetWeaver BW. Furthermore, it shows that SAP BW ad-hoc reporting experiences a drastic decrease in elapsed time when supported by IDAA. 01 Dec 2011

Using Database Performance Warehouse to Monitor IBM DB2 for z/OS – The Content (Part 2)

SAP Business Suite on IBM System z Reference Architecture for System Infrastructure

This document describes a generic SAP on IBM® System z reference architecture. This reference architecture focuses on the system infrastructure for running SAP Business Suite or any of the available Industry Solutions. It is a guideline that describes how to best implement and run SAP solutions on System z 12 Dec 2010

SAP and IBM Tivoli Directory Server for z/OS

This article briefly explains how to move your LDAP user management to the highest level of security with Tivoli Directory Server (TDS) on z/OS. The article guides you through preparation, installation, and configuration and it provides you with the principals of usage of TDS on z/OS.09 Apr 2010

Virtualization on IBM System z

Customers are using virtualization technology to optimize their IT landscape and to cut their hardware and operating costs. On IBM System z, virtualization is part of the system platform. Therefore the operation of SAP systems is supported on any of the IBM system z virtualization technologies.

This page provides general information about IBM System z virtualization technologies as well as special information about running an SAP system in an IBM System z virtualized environment.v

Using Database Performance Warehouse to Monitor IBM DB2 for z/OS – General Overview (Part 1)

In the Database Performance Warehouse, all relevant data concerning database space consumption that is collected by the DBA Cockpit is stored in an SAP Business Intelligence (BI) system. This SAP BI system is used by the SAP Solution Manager Diagnostics (SMD) back end of an SAP Solution Manager system. All collected data has a time dimension, so the database space consumption can be analyzed for any point in time or over a specified time frame. See this document for details.22 Dec 2009

Setup for Remote Monitoring and Administration of DB2 for z/OS

The CCMS DBACockpit allows the connection to remote database systems. This document describes the prerequisites and steps for setting up the monitoring and administration of remote DB2 for z/OS subsystems.04 Aug 2009

Improving I/O Performance Using Solid-State Drive Technology

Solid-State Drive (SSD) technology is an important new technology that is being introduced into IBM System Storage solutions to significantly improve performance and reduce energy consumption. Measurements have shown that combining IBM System Storage with SSD, high-speed fiber connectivity, and DB2 can provide more options for improved system responsiveness and throughput for SAP applications. Details are described in this document.30 Jul 2009