DB2 for z/OS

DB2 for z/OS Information Roadmap

This roadmap outlines the information resources that are available for installation, administration, and programming for DB2 for z/OS.

PDF files require Adobe® Reader®

		Information Management Software for z/OS Solutions Information Center (Type: Information center) Visit the Information Management Software for z/OS Solutions Information Center to find all the information that you need to install, configure, maintain, and use IBM products for managing your information on z/OS.
		DB2 for z/OS - Technical Resources (Type: Technote) Here is your complete DB2 for z/OS information resource! Here you can find DB2 for z/OS technical manuals, information about related tools, and valuable technical tips.
		DB2 9 for z/OS Technical Overview (Type: IBM Redbooks) This IBM redbook introduces the enhancements made available with DB2 9 for z/OS. Its helps you understand the new functions, justify investment in migrating, and plan for exploiting the key new capabilities.
		DB2 Family Fundamentals (Type: Classroom course) Learn about the functions and components of IBM DB2, a relational database manager, that you can install on a variety of operating systems. This course addresses DB2 running on z/OS, AIX, Linux, HP-UX, Sun, and Windows operating systems. This course focuses on the services that DB2 provides and how they work.
		DB2 UDB for z/OS Version 8: Everything You Ever Wanted to Know, ... and More (Type: IBM Redbooks) This IBM Redbook explains the capabilities of DB2 Version 8. This information helps you to evaluate the applicability of Version 8 to your environment, as well as to plan for the installation of DB2 V8 or the migration from DB2 V7.
		Greatest Hits & Myths - Roger Miller (Type: Presentation; Format: PDF) This presentation discusses the areas of greatest improvements in Version 8 and reasons for migration to Version 8. The value and effort of Version 8 vary widely for different customers. This presentation also discusses the many rumors about DB2 Version 8.
		DB2 Version 9.1 for z/OS This Web page describes the new features of DB2 Version 9.1 for z/OS.
		The Official Introduction to DB2 for z/OS (Type: Book) This retail book introduces you to DB2 Version 8. By focusing on administration and development, it also helps you prepare for the IBM® DB2 Family Fundamentals certification exam.
		DB2 for z/OS Version 8 - Driving Business Value (Type: White paper; Format: PDF) This paper provides a high-level overview of the major features of DB2 for z/OS, Version 8. Written by a consultant especially for IT executives, the paper emphasizes how Version 8 can deliver underlying business value.
		The Big Picture: IBM DB2 Information Management Software and DB2 Universal Database (Type: Article) This article provides a brief history of the DB2 family of products, a technology overview, and a discussion of the role of DB2 software in On Demand business.
		Customer Testimonials (Type: Other) This Web page enables you to listen to IBM zSeries® customers tell their own stories.
		DB2 for z/OS Version 8: Point and Counterpoint (Type: Presentation; Format: PDF) In this presentation, IBM and a DB2 customer both give their opinions of Version 8.
		IBM Software for zSeries Webcasts (Type: Presentation) Check the listing for upcoming Webcasts or choose from among the various Webcast replays, available 24 hours a day, seven days a week.
		Tutorials: DB2 Version 8 Family Fundamentals Preparation (Type: Certification) This series of six tutorials is designed to help you prepare for the DB2 Version 8 Family Fundamentals certification exam (Exam 700).

Back to top

General planning for DB2 UDB for z/OS
		Release announcement for DB2 9 for z/OS (Type: Product description) This announcement letter summarizes the key enhancements that are available in DB2 Version 9 for z/OS.
		Program directories for DB2 Version 9 for z/OS (Type: Manual) This Web page links to Program Directories for related DB2 components. Program Directories provide helpful information that you need when you install or migrate to a new version of a product.
		Virtual Storage Management 2005 Revisited (Type: Presentation; Format: PDF) This presentation provides a detailed and thorough update on managing virtual storage constraint, above and below 16MB line, with both Version 7 and Version 8.
		DB2 UDB for z/OS Version 8 Migration Experiences (Type: Presentation; Format: PDF) This presentation shares early experiences of users and the value provided by the Version 8 release. Lessons learned, surprises, and recommendations are included. Performance and availability considerations are also addressed.
		DB2 UDB for z/OS V8 What's New? (Type: Manual;  Format: PDF) This book provides detailed information to help you plan for Version 8 of DB2 UDB for z/OS. These topics summarize the Version 8 enhancements, including availability, scalability, performance, development, and integration of e-business applications, migration, conversion, and fallback.
		DB2 UDB for z/OS Version 8: Everything You Ever Wanted to Know, ... and More (Type: IBM Redbooks) This IBM Redbook introduces the many enhancements that are available with DB2 Version 8 and helps you plan for the installation of DB2 V8 or the migration from DB2 V7.
		Planning for Version 8 (Type: Information center) These topics summarize the key Version 8 changes and additions to the DB2 product. This is the same information that is in the DB2 Release Planning Guide.
		Planning and installing DB2 (Type: Information center) These topics describe the tasks of estimating DB2 storage needs, loading DB2 libraries, installing DB2, migrating to conversion mode, enabling new-function mode, verifying your installation or migration with the sample applications, and connecting the IMS attachment facility.
		DB2 UDB for z/OS Version 8 presentation (Type: Presentation;  Format: PDF) This presentation describes DB2 for z/OS Version 8. The key focus points are SQL improvements, performance, synergy with zSeries and the DB2 family, continuous availability, applications, and business intelligence.
		DB2 UDB for z/OS Version 8 Migration Experiences (Type: Presentation;   Format: PDF) This presentation shares early experiences of users and the value provided by the Version 8 release. Lessons learned, surprises, and recommendations are included. Performance and availability considerations are also addressed.
		DB2 Program Directory (Type: Manual;  Format: PDF) This document provides the SMP/E installation sample jobs and instructions.
		Program Directories for DB2 UDB for z/OS Version 8 (Type: Manual) This Web page links to Program Directories for related DB2 components. Program Directories provide helpful information that you need when you install or migrate to a new version of a product.
Planning for specific functions in DB2 UDB for z/OS
		Planning for DB2 data sharing (Type: Information center) These topics provide information about planning for DB2 data sharing, establishing naming conventions, estimating storage requirements, and so on.
		DB2 UDB for z/OS Version 8 Major Security Improvements (Type: Presentation;   Format: PDF) This presentation describes the security features in Version 8, including multilevel security, row-level security, and encryption. The primary focus is on security, privacy, and auditing.
		Utility Work Ahead in DB2 for z/OS Version 8 (Type: Presentation; Format: PDF) This presentation provides an overview of utility enhancements in Version 7 and Version 8, as well as improvements to look forward to in future versions of DB2 for z/OS utilities.
		DB2 Utilities Suite for z/OS, Version 8 (Type: Product description) This Web page contains basic information about the Version 8 Utilities Suite, including the key features and system requirements.
Planning for use of DB2 enterprise applications
		DB2 for z/OS and WebSphere: The Perfect Couple (Type: IBM Redbooks) This IBM Redbook describes installation, configuration, and use of the IBM DB2 Universal Driver for SQLJ and JDBC in a DB2 environment (DB2 for z/OS Version 8 or DB2 for z/OS and OS/390 Version), with IBM WebSphere Application Server for z/OS for z/OS Version 5.02.
		DB2 UDB for z/OS V8: Through the Looking Glass and What SAP Found There (Type: IBM Redbooks) This IBM Redbook introduces the new features of DB2 for z/OS Version 8. The book provides real-life examples from SAP to demonstrate the usefulness of the new features for SAP.
		SAP on DB2 for z/OS and OS/390: High Availability and Performance Monitoring with Data Sharing (Type: IBM Redbooks) This IBM Redbook addresses the challenges posed by monitoring high availability, scalability, and performance in an SAP Sysplex data sharing environment.
		SAP on DB2 Universal Database for OS/390 and z/OS: Multiple Components in One Database (MCOD) (Type: IBM Redbooks) This IBM Redbook helps system administrators, DBAs, and operations staff to plan, implement, and administer an SAP MCOD landscape with DB2 for z/OS.
		SAP on DB2 UDB for OS/390 and z/OS: High Availability Solution Using System Automation (Type: IBM Redbooks) This IBM Redbook explains the SAP high availability with System Automation solution. It also explains the planning and preparation steps needed for this solution.
		SAP on DB2 UDB for OS/390 and z/OS: Implementing Application Servers on Linux for zSeries (Type: IBM Redbooks) This IBM Redbook provides overviews of SAP and Linux and describes the planning needed for SAP on Linux for zSeries, including resource sharing considerations, hardware and software requirements, and support and maintenance.
		PeopleSoft V8 on zSeries Using Sysplex Data Sharing and Enterprise Storage Systems (Type: IBM Redbooks) This IBM Redbook, about PeopleSoft Version 8.4 on a zSeries Parallel Sysplex data sharing environment, focuses on all aspects of performance.
		Planning for a Migration of PeopleSoft 7.5 from Oracle/UNIX to DB2 for OS/390 (Type: IBM Redbooks) This IBM Redbook helps you plan the migration process from PeopleSoft Applications 7.5 on UNIX with Oracle to PeopleSoft Applications 7.5 on OS/390 with DB2.

Back to top

		DB2 for z/OS and Data Sharing Implementation (Type: Classroom course) Learn about the components of DB2 for z/OS and data sharing, and how to plan for and implement DB2 data sharing on the z/OS operating system. Set up a naming convention by renaming a non-data sharing DB2, enable a two-way DB2 data sharing group on a Parallel Sysplex environment, verify and test data sharing functions, and create a database in the data sharing group. Lab teams of two or three people perform the implementation steps of data sharing on their own Parallel Sysplex environment.
		DB2 9 for z/OS System Implementation Workshop (Type: Classroom course) Learn about installing DB2 UDB for z/OS, Version 8, and installing and migrating to DB2 9 for z/OS by using the installation CLIST. You will be involved in lectures to understand DB2 for z/OS components and pointer, and the processes involved to install or migrate DB2.
		DB2 UDB for z/OS V8 Migration: An Ironman® event (Type: Presentation; Format: PDF) This presentation reviews the Version 8 migration experience at Deere and Company, using a triathlon analogy, to help you prepare for your big migration event.
		The Good, the Bad, and the Really Ugly: DSNZPARM - Willie Favero (update) (Type: Presentation; Format: PDF) This presentation examines the realm of DSNZPARMs: hidden, opaque, and visible
		Installation and migration (Type: Information center) These topics explain how to install DB2 UDB for z/OS Version 8. This is the same information that is in the DB2 Installation Guide.
		Planning and installing DB2 (Type: Information center) These topics describe the tasks of estimating DB2 storage needs, loading DB2 libraries, installing DB2, migrating to conversion mode, enabling new-function mode, verifying your installation or migration with the sample applications, and connecting the IMS attachment facility.
		DB2 Program Directory (Type: Manual;  Format: PDF) This document provides the SMP/E installation sample jobs and instructions.
		DB2 utilities packaging (Type: Information center) This topic explains the packaging of the DB2 utilities and how to install them.
		DB2 Utilities Suite Program Directory (Type: Manual;  Format: PDF) This document provides the SMP/E installation sample jobs and instructions for the DB2 Utilities Suite.
		IBM DB2 Driver for JDBC and SQLJ installation (Type: Information center) These procedures describe what you need to do to install the DB2 Driver for JDBC and SQLJ.
		Installing a new data sharing group (Type: Information center) This procedure describes how to install and immediately enable DB2 data sharing on a new Version 9 member.
		Installing DB2 ODBC (Type: Information center) This topic explains how to edit and run SMP/E jobs to install DB2 ODBC.

Back to top

		How will my stored procedures be impacted by migration to Version 9.1? (Type: Technote) This technote gives an overview of the stored procedure changes in Version 9.1, including the new native SQL procedures.
		DB2 for z/OS Version 8 Transition Workshop (Type: Classroom course) Learn about the new features and enhancements of DB2 for z/OS Version 8, including the functional enhancements and the technical requirements of this very significant new version of DB2 for z/OS. Practice many of the new functions by performing hands-on machine exercises.
		DB2 UDB for z/OS V8 Migration: An Ironman® event (Type: Presentation; Format: PDF) This presentation reviews the Version 8 migration experience at Deere and Company, using a triathlon analogy, to help you prepare for your big migration event.
		Performance Issues in Migrating to DB2 UDB for z/OS - Akira Shibamiya (Type: Presentation; Format: PDF) This presentation covers several facets of migration, including: performance considerations and the impact on I/O time, real storage, and virtual storage. It also provides performance monitoring and tuning tips to reduce CPU usage of applications that are migrating to V8.
		The Good, the Bad, and the Really Ugly: DSNZPARM - Willie Favero (update) (Type: Presentation; Format: PDF) This presentation examines the realm of DSNZPARMs: hidden, opaque, and visible
		When Should I Migrate to DB2 UDB for z/OS Version 8? (Type: Article) This article describes the general actions that you need to perform for migration; it also offers related information that can help you justify why Version 8 is good for your business.
		Installation and migration (Type: Information center) These topics explain how to migrate to DB2 UDB for z/OS Version 8 from DB2 UDB for z/OS and OS/390 Version 7. This is the same information that is in the DB2 Installation Guide.
		V8 Migration Steps and Considerations (Type: Presentation;  Format: PDF) This presentation includes information about the following topics: new migration process, prerequisites, pre-migration, compatibility mode, enabling-new-function mode, and new-function mode.
		Migration to DB2 UDB for z/OS, Version 8 (Type: Presentation;  Format: PDF) This presentation, written for DBAs and programmers involved in migration activities, discusses the V7-to-V8 migration process and how to prepare for using new Version 8 functions.
		Planning for Version 8 (Type: Information center) These topics (from DB2 Release Planning Guide) summarize Version 8 enhancements and list changes to commands, SQL statements, utility control statements, messages, and codes.
		DB2 Program Directory (Type: Manual;  Format: PDF) This document provides the SMP/E installation sample jobs and instructions.
		Migrating to DB2 for z/OS Version 8: the Many Modes of V8 (Type: Presentation;  Format: PDF) This presentation unveils some mysteries of the DB2 catalog in the context of migration.
		DB2 9 for z/OS Transition Workshop (Type: Classroom course) Learn about the new features and enhancements of DB2 9 for z/OS, including the technical details of the functional enhancements of this significant new version of DB2 for z/OS. Practice several of the new functions by performing hands-on machine exercises.
		Greatest Hits and Myths: Migration to DB2 UDB for z/OS Version 8 (Type: Article) This article dispels myths and explains why Version 8 is a great hit.
		Internationalization Guide (Unicode) (Type: Manual;  Format: PDF) This manual explains character conversion and Unicode in the DB2 for z/OS Version 8 environment.
		Webcast: Migrate to DB2 Universal Database for z/OS Version 8: Assessing ROI from enhanced availability, scalability and security. (Type: Presentation) This special Webcast is for IT decision makers and professionals who need to understand the business justification for migrating to DB2 UDB for z/OS, Version 8.

Back to top

		DB2 9 for z/OS Stored Procedures: Through the Call and Beyond (Type: IBM Redbooks) This IBM Redbook helps you design, install, manage, and tune stored procedures with DB2 9 for z/OS.
		DB2 for z/OS Stored Procedures: Through the CALL and Beyond (Type: IBM Redbooks) This IBM Redbook helps you design, install, manage, and tune stored procedures with DB2 for z/OS.
		Installing, migrating, and updating system parameters (Type: Information center) These topics explain how to change system parameters.
		Communicating with other systems (Type: Information center) These topics discuss communicating with other systems, including connecting distributed database systems, connecting systems with VTAM®, and connecting systems with TCP/IP.
		Connectivity Cheat Sheet for DB2 Universal Database Part 2 - DB2 for z/OS (Type: Article) This article gives you details for connecting DB2 UDB for z/OS clients to DB2 UDB for z/OS servers or to servers on other operating systems. The following three connectivity scenarios are included: - From a DB2 UDB for z/OS client to a DB2 UDB for Linux, UNIX, and Windows server - From a DB2 UDB for z/OS client to a DB2 UDB for iSeries server - From a DB2 UDB for z/OS client to another DB2 UDB for z/OS server
		Distributed Functions of DB2 for z/OS and OS/390 (Type: IBM Redbooks) This IBM Redbook describes how to set up a DDF environment, how to deploy DDF capabilities in different configurations, and how to develop applications that access distributed databases.
		Directory of subsystem parameters (Type: Information center) This topic describes the DB2 subsystem parameters.

Back to top

General administration information
		DB2 for z/OS Database Administration Workshop - Part 1 (Type: Classroom course) Learn how to physically implement a logical database design in DB2. Learn about DB2 data management, DB2 catalog tables, the bind process, database utilities, such as LOAD and REORG, and security considerations. A continuation of this workshop is provided by the course DB2 for z/OS Database Administration Workshop - Part 2.
		DB2 for z/OS Systems Administration (Type: Classroom course) Examine DB2 on the z/OS operating system. Learn to understand, evaluate, and manage DB2 system functions. Learn the basic processes that are involved in tailoring and installing DB2 and its attachment facilities. Discuss the basic concepts of DB2 system recovery and system performance.
		Data Archiving Techniques and Considerations for the DB2 Family (Type: Presentation; Format: PDF) This presentation describes the causes of data growth, proposes various archival and retrieval strategies for dealing with that growth, and focuses on elements for successful data management.
		DB2 administration (Type: Information center) Use these topics if you are a DB2 database or system administrator. These topics help you monitor, tune, operate, recover from problems, and manage security in a DB2 UDB for z/OS environment. This information is from the DB2 Administration Guide.
		DB2 commands (Type: Information center) These topics provide detailed reference information for DB2 and related commands, including environment information, the privileges and authorities for each command, syntax and option descriptions, and examples. This information is from the DB2 Command Reference.
		DB2 Administration Tool (Type: Product description) This Web page provides general information and resources for the DB2 Administration Tool, which provides a comprehensive set of functions that help DB2 personnel manage their DB2 environments efficiently and effectively.
		Internationalization Guide (Unicode) (Type: Manual; Format: PDF) This manual explains character conversion and Unicode in the DB2 for z/OS Version 8 environment.
		Large Objects with DB2 for z/OS and OS/390 (Type: IBM Redbooks) This IBM Redbook provides information about how to design and implement large objects (LOBs), examples of their use, programming considerations, and the processes that are necessary for administration and maintenance.
Administration for data sharing environments
		What's new in DB2 UDB for z/OS Locking and Concurrency - Jim Teng (Type: Presentation; Format: PDF) This presentation describes several new locking enhancements that were added to Version 7 and Version 8 to improve application availability. It explains how SQL and DB2 utilities handle concurrency control and it gives guidelines on how to design a database to improve concurrency.
		Planning for DB2 data sharing (Type: Information center) These topics provide information about planning for DB2 data sharing, establishing naming conventions, estimating storage requirements, and so on.
		Communicating with data sharing groups (Type: Information center) These topics explain how to use a data sharing group as a powerful server in your client/server environment.
		PeopleSoft V8 on zSeries Using Sysplex Data Sharing and Enterprise Storage Systems (Type: IBM Redbooks) This IBM Redbook, about PeopleSoft Version 8.4 on a zSeries Parallel Sysplex data sharing environment, focuses on all aspects of performance.
		SAP on DB2 for z/OS and OS/390: High Availability and Performance Monitoring with Data Sharing (Type: IBM Redbooks) This IBM Redbook addresses the challenges posed by monitoring high availability, scalability, and performance in an SAP Sysplex data sharing environment.
		Installing a new data sharing group (Type: Information center) This procedure describes how to install and immediately enable DB2 data sharing on a new Version 9 member.
		DB2 Coupling facility structure selections (Type: Other) Use this Web page to get help sizing your coupling facility structures based on data that you enter.
		z/OS V1R6.0 MVS Setting Up a Sysplex (Type: Manual) This document supports z/OS (5694-A01) and z/OS.e (5655-G52). This document contains information you need to set up a z/OS system to run in a Sysplex.
		DB2 for zSeries on Parallel Sysplex: Your Key to Application Availability, Scalability and High Performance (Type: White paper; Format: PDF) This paper shows the technology that makes IBM DB2 UDB for OS/390 and z/OS using Parallel Sysplex technology superior in terms of day-to-day performance, availability even during normal maintenance, scalability, and performance during recovery.
		Parallel Sysplex - Managing Software for Availability (Type: IBM Redbooks) This IBM Redbook was developed in response to customer requests for guidance on how to meet the conflicting requirements of keeping software up to date, while at the same time delivering increasing levels of availability.
		Parallel Sysplex Continuous Availability - Case Studies (Type: IBM Redbooks) This IBM Redbook discusses the topic of continuous availability in a Parallel Sysplex environment. The two case studies cover DB2 data sharing, and VSAM Record Level Sharing, and they provide specific technical tips that may assist other users in similar environments.
		System/390 Parallel Sysplex Performance (Type: IBM Redbooks) This IBM Redbook presents performance concepts and tips collected during the measurements of performance in specific configurations. Products measured in a Parallel Sysplex environment include the 9021, 9672, IMS/VS, CICS/VS, DB2, JES2, system logger, CICS® temporary storage, and XCF signalling.
Administration with DB2 utilities
		Data Recovery Now and Future Using IBM's Recovery Tools (Type: Presentation; Format: PDF) This presentation reviews all types of data recovery, IBM's current recovery offerings, and IBM's recovery tooling philosophy, including autonomic functions and high priority requirements that we are working on in the laboratory today.
		DB2 utilities (Type: Information center) These topics provide detailed information about the syntax and usage of the DB2 online and stand-alone utilities. This information is from the DB2 Utility Guide and Reference.
		DB2 for z/OS and OS/390 Version 7 Using the Utilities Suite (Type: IBM Redbooks) This IBM Redbook provides information about the use of wildcards in operational scenarios, optimizing concurrent execution of utilities for a shorter maintenance window, information about triggering utilities execution, and considerations related to partitioning. Although This IBM Redbook was written for DB2 Version 7, much of the information applies for Version 8.
		Moving Data Across the DB2 Family (Type: IBM Redbooks) This IBM Redbook provides an overview of what is currently available within the DB2 family of products (specifically DB2 for z/OS, and DB2 for UNIX and Windows). This book explains functions, tools, and utilities to satisfy the need for moving data. It focuses on High Performance Unload and Cross Loader.
		Programs vs. Utilities (Type: Article) This article in DB2 Magazine lists the ways that programmers can use DB2 utilities to lighten the programming load.
		Programs vs. Utilities Revisited (Type: Article) This article in DB2 Magazine explains how programmers can take advantage of the new features of the Version 8 utilities.
		DB2 V8 System Point-in-Time Recovery (Type: Presentation;  Format: PDF) This presentation describes the steps that are necessary to perform system-level point-in-time recovery by using the new DB2 for z/OS Version 8 utilities BACKUP SYSTEM and RESTORE SYSTEM.
		DB2 Utilities Suite (Type: Product description) This Web page provides general information and resources for the DB2 Utilities Suite for z/OS.
Administration with DB2 tools
		DB2 Administration Tool (Type: Product description) This Web page provides general information and resources for the DB2 Administration Tool, which provides a comprehensive set of functions that help DB2 personnel manage their DB2 environments efficiently and effectively.
		DB2 Automation Tool (Type: Product description) This Web page provides general information and resources for the DB2 Automation Tool, which automates maintenance tasks and provides statistical history reports for trend analysis and forecasting.
		DB2 Change Accumulation Tool (Type: Product description) This Web page provides general information and resources for the DB2 Change Accumulation Tool, which quickly restores database objects with precision and minimal disruption, setting the scope and specificity of image copy creation through the use of control cards.
		DB2 Data Archive Expert (Type: Product description) This Web page provides general information and resources for DB2 Data Archive Expert, which is a comprehensive data archiving tool that enables you to move seldom-used data to a less costly storage medium, without any programming.
		DB2 DataPropagator (Type: Product description) This Web page provides general information and resources for DB2 DataPropagator, which leverages the SQL replication architecture to flexibly manage scheduling, transformation, and distribution topologies.
		WebSphere Classic Federation Server for z/OS (Type: Product description) This Web page provides general information and resources for WebSphere Classic Federation Server for z/OS, which provides direct, real-time SQL access to mainframe databases and files without mainframe programming.
		DB2 High Performance Unload (Type: Product description) This Web page provides general information and resources for DB2 High Performance Unload, which is a high-speed DB2 utility for unloading DB2 tables from either a table space or a backup copy.
		DB2 Log Analysis Tool (Type: Product description) This Web page provides general information and resources for the DB2 Log Analysis Tool, which helps ensure high availability and complete control over data integrity.
		DB2 Object Comparison Tool (Type: Product description) This Web page provides general information and resources for the DB2 Object Comparison Tool, which maximizes system availability by keeping production and testing database environments running in parallel.
		DB2 Object Restore Tool (Type: Product description) This Web page provides general information and resources for the DB2 Object Restore Tool, which enables you to recover valuable data assets by quickly restoring dropped objects without down time, even if they no longer exist in the DB2 catalog.
		WebSphere Classic Data Event Publisher for z/OS (Type: Product description) This Web page provides general information and resources for WebSphere Classic Data Event Publisher, which captures changes made to mainframe databases or files and publishes these changes to WebSphere MQ.
Administration with DB2 enterprise applications
		Getting the most out of pooling and caching with WebSphere and DB2 for z/OS - Maryela Wiehrauch (Type: Presentation; Format: PDF) This presentation explains the concepts of statement caching and connection pools in DB2 UDB and WebSphere, and how to get the most out of these functions.
		WebSphere Business Integration for SAP (Type: IBM Redbooks) This IBM Redbook illustrates how to integrate data and processes located in SAP back-end systems using WebSphere Business Integration middleware technology.
		SAP on DB2 Universal Database for OS/390 and z/OS: Multiple Components in One Database (MCOD) (Type: IBM Redbooks) This IBM Redbook helps systems administrators, database administrators, managers, and operation staff to plan, implement, and administer an SAP MCOD landscape with DB2 Universal Database (UDB) for OS/390 and z/OS as the database management system.
		SAP on DB2 for z/OS and OS/390: DB2 System Cloning (Type: IBM Redbooks) This IBM Redbook shows the different techniques users can use to clone their DB2 subsystem.
		SAP R/3 on DB2 for OS/390: Database Availability Considerations (Type: IBM Redbooks) This IBM Redbook describes availability procedures for the database of an SAP R/3 4.6B installation that uses DB2 UDB for OS/390 as the SAP R/3 database server.
		Siebel 7 with DB2 for z/OS: Database Implementation and Administration Guide (Type: IBM Redbooks) This IBM Redbook describes the implementation, customization, and administration of the Siebel 7 database with DB2 UDB for z/OS and OS/390 V7 using AIX® V5L or Windows 2000 Siebel servers.
Certification for DB2 administrators
		IBM Certified Database Administrator - DB2 Universal Database V8.1 for z/OS (Type: Article) This article outlines the materials that you need to review and the tests that you need to take to become certified as a database administrator.
		DB2 version 8 certification: Everything you need to know (Type: Article) This article describes everything that you need to know about certification, including whether you should get certified, how you can get certified, and how you can prepare and study for the certification exam.
		DB2 Universal Database V8.1 Certification Test 700 Study Guide (Type: Book) This retail book prepares you for the DB2 UDB V8.1 Exam 700. It includes information about exam objectives, a review of the DB2 family of tools and products, and fundamental database concepts such as SQL and data consistency.
		DB2 for z/OS Version 8 DBA Certification Guide (Type: Book) IBM Gold Consultant, Susan Lawson, presents hundreds of practical techniques, expert guidelines, and useful tips for every facet of DB2 UDB database administration, including database implementation, operation, recovery, security, auditing, performance, installation, migration, SQL, and more.
		Professional Certification Preparation Documents (Type: Certification; Format: PDF) These preparation documents help you prepare for DB2 Information Management certification exams. Each document covers role descriptions, requirements, objectives, and preparation suggestions.

Back to top

General DB2 database programming
		DB2 SQL Workshop (Type: Classroom course) For the United States, there are now different workshops depending on user experience level. The original classroom course (CF120) has no description online. Self-paced virtual class Experienced users
		DB2 Programming Workshop for z/OS (Type: Classroom course) Acquire the skills necessary to produce application programs that manipulate DB2 databases. Emphasis is on embedding Structured Query Language (SQL) statements and preparing programs for execution.
		New & Cool SQL: Version 8 - Willie Favero (Type: Presentation; Format: PDF) This presentation is a high-level overview of the SQL that is delivered in DB2 Version 8, including: multiple row INSERT, FETCH, INSERT within SELECT, SEQUENCES, SET CURRENT PACKAGE PATH.
		Developing DB2 UDB Database Projects in Visual Studio .NET (Type: Tutorial) This tutorial demonstrates the use of the DB2 database project template of the IBM DB2 Development Add-In to create tables, indexes, views, triggers, and stored procedures for a DB2 for z/OS database environment. To demonstrate the ease of building such server objects, this tutorial walks you through the steps to build a sample application.
		DB2 for z/OS DB2 database design: Principles of peak performance (Type: Article) This article provides some general guidelines and recommendations for achieving better DB2 performance in z/OS environments.
		Application programming and SQL (Type: Information center) These topics provide detailed information about developing DB2 application programs that include SQL in languages other than Java and about using SQL queries to retrieve and modify DB2 data. This information is from the DB2 Application programming and SQL Guide
		DB2 SQL (Type: Information center) These topics provide detailed reference information about DB2 language elements, functions, queries, SQL statements, SQL control statements, and catalog tables.
		DB2 for z/OS Application Programming Topics (Type: IBM Redbooks) This IBM Redbook describes the major enhancements that affect application programming when accessing DB2 data on an OS/390 or zSeries platform. Although This IBM Redbook was written for DB2 Version 7, much of the information applies to Version 8.
		Programs vs. Utilities (Type: Article) This article in DB2 Magazine lists ways that programmers can use DB2 utilities to lighten the programming load.
		Programs vs. Utilities Revisited (Type: Article) This article in DB2 Magazine explains how programmers can take advantage of the new features of the Version 8 utilities.
		DB2 for z/OS DB2 Universal Database concurrency: Maximize access to relational data (Type: Article) This article provides some general guidelines and recommendations for improving concurrency in DB2 for z/OS environments.
		DB2 Development Add-In Technical Preview (Type: Article) The article introduces you to the features and rich functionality that have since been delivered in DB2 Development Add-in for Visual Studio .NET.
		Query Management Facility (Type: Product description) Offered with IBM DB2 Universal Database, DB2 QMF is a complete analysis package that can provide effective, visualized data in response to even the most complex of business queries.
Connectivity and distributed database development
		An Introduction to DB2 for OS/390 and z/OS System Structures for DB2 Distributed Users (Type: Article) Using analogies to DB2 distributed concepts, this article explains the basics of system administration on DB2 for z/OS, including subsystems, logging, configuration parameters, and more.
		DB2 for z/OS Stored Procedures: Through the CALL and Beyond (Type: IBM Redbooks) This IBM Redbook helps you design, install, manage, and tune stored procedures with DB2 for z/OS.
		DB2 Connect™ (Type: Product description) This Web page contains information about DB2 Connect, a tool that makes your company's host data directly available to your personal computer and LAN-based workstations.
		Connectivity Cheat Sheet for DB2 Universal Database Part 2 - DB2 for z/OS (Type: Article) This article gives you details for connecting DB2 UDB for z/OS clients to DB2 UDB for z/OS servers or to servers on other operating systems. The following three connectivity scenarios are included: - From a DB2 UDB for z/OS client to a DB2 UDB for Linux, UNIX, and Windows server - From a DB2 UDB for z/OS client to a DB2 UDB for iSeries server - From a DB2 UDB for z/OS client to another DB2 UDB for z/OS server
		Connectivity cheat sheet for Application Developers (Part 4) (Type: Article) This article discusses connectivity scenarios that involve DB2 UDB for Linux, UNIX, and Windows Version 8, DB2 UDB for iSeries 5.2, and DB2 UDB for z/OS Version 8. The focus of this article is on workstation application development connectivity using the C and Java languages.
		Distributed Functions of DB2 for z/OS and OS/390 (Type: IBM Redbooks) This IBM Redbook describes how to set up a DDF environment, how to deploy DDF capabilities in different configurations, and how to develop applications that access distributed databases.
		Programming for DRDA (Type: Information center) These topics provide detailed information about using Distributed Data Management (DDM) commands to track DRDA access to DB2 and to distribute requests among members of a data sharing group. This information is from the Reference for Remote DRDA Requesters and Servers.
		Programming for ODBC (Type: Information center) These topics provide guidance for DB2 ODBC application programming tasks. These topics also provide reference information about each DB2 ODBC function. This information is from the ODBC Guide and Reference.
		Communicating with data sharing groups (Type: Information center) These topics explain how to use a data sharing group as a powerful server in your client/server environment.
Porting data from another DBMS to DB2
		Porting to DB2 UDB: Technical resources and roadmap (Type: Other) This Web site explains the steps involved in moving an application and its associated data to a DB2 UDB database management system.
		Univar USA migrates with ease from Oracle to IBM DB2 V8 for z/OS (Type: Other) On this Web page, click "Univar" to listen to the value that Univar found in DB2 Version 8.
		WebSphere Classic Federation Server for z/OS (Type: Product description) This Web page provides general information and resources for WebSphere Classic Federation Server for z/OS, which provides direct, real-time SQL access to mainframe databases and files without mainframe programming.
		WebSphere Classic Replication Server for z/OS (Type: Product description) This Web page explains WebSphere Classic Replication Server for z/OS, which provides fast and flexible replication that helps administrators distribute, consolidate, and synchronize information across complex, multi-platform, multi-vendor IT environments.
		CICS VSAM transparency (Type: Product description) This Web page explains CICS VSAM Transparency, which enables efficient and effective migration of data from VSAM to DB2.
		Migrating Siebel Database from DB2/Oracle for NT to DB2 for OS/390 (Type: IBM Redbooks) The IBM Redbooks describes the migration experiences gained while migrating a Siebel 2000 database at the IBM ITSO Poughkeepsie Center in New York, and at the IBM Hursley Laboratory in the UK.
Developing DB2 stored procedures
		DB2 9 for z/OS Stored Procedures: Through the Call and Beyond (Type: IBM Redbooks) This IBM Redbook helps you design, install, manage, and tune stored procedures with DB2 9 for z/OS.
		Java stored procedures in DB2 for z/OS (Type: Presentation; Format: PDF) This presentation describes the setup and current environment for Java routines, including the Universal Java Driver and the latest IBM SDK for z/OS.
		DB2 for z/OS stored procedures: best practices & FAQ (Type: Presentation; Format: PDF) This presentation addresses the current hot topics in developing and managing stored procedures in DB2 for z/OS and OS/390.
		Stored procedure performance recommendations (Type: Technote) This technote contains general recommendations for improving the performance of stored procedures.
		Nested Stored Procedures (Type: Technote) This technote explains how to improve the performance of nested stored procedures by forcing them to run in the same WLM environment.
		Stored procedure priority (Type: Technote) This technote explains how stored procedure priority is determined.
		How can I redeploy an SQL stored procedure without rebuilding it? (Type: Technote) This technote provides instructions for moving and deploying any stored procedure to another system.
		Using DB2 for z/OS stored procedures with QMF (Type: Information center) This topic explains how to develop and run stored procedures from QMF.
		Creating a native SQL procedure (Type: Information center) This topic explains how to create native SQL procedures, which are new in Version 9.1.
		Cross-Platform DB2 Stored Procedures: Building and Debugging (Type: IBM Redbooks) This IBM Redbook explains how to implement stored procedures in DB2® for OS/390®, DB2 for Windows NT®, DB2 UDB for AIX®, and DB2 for AS/400® servers. Please include the trademarks in this description.
		Breaking the DB2 Platform Barrier (Type: White Paper; Format: PDF) This white paper is geared toward any DBA that is responsible for supporting DB2 on multiple platforms. This paper explains basic terminology for the different platforms, how the platforms differ, and the key architectural differences and administrative issues.
		Stored procedures (Type: Information center) These topics introduce DB2 stored procedures, and they explain how to write, prepare, run, and test stored procedures that are not written in Java.
		Leverage the power of SQL Procedural Language on DB2 for Linux, UNIX, Windows, i5/OS, and z/OS (Type: Article) Overview about writing portable and efficient SQL PL code on Linux, UNIX, Windows, i5/OS, and z/OS. This article contains a link to where you can purchase "DB2 SQL PL: Essential Guide for DB2 UDB on Linux, UNIX, Windows, i5/OS, and z/OS", the definitive guide to writing DB2 SQL Procedural Language stored procedures, triggers, user-defined functions, and dynamic compound SQL.
		Java stored procedures and user-defined functions (Type: Information center) These topics contain information that is specific to defining and writing Java user-defined functions and stored procedures.
Development of Java™, JDBC, and J2EE programs
		Programming for Java (Type: Information center) These topics (from DB2 Application Programming Guide and Reference for Java) provide details about developing Java programs that access DB2 UDB for z/OS data.
		Managing Enterprise Java Applications for DB2 (Type: White Paper; Format: PDF) This paper helps customers who want more control over their Java applications.
		DB2 for z/OS and OS/390: Ready for Java (Type: IBM Redbooks) This IBM Redbook offers guidance on different ways to set up your environment to connect a Java program to a DB2 for z/OS subsystem, through JDBC or SQLJ, using a Type 2 or Type 4 driver.
		DB2 and Java: The Big Picture (Type: Article) Start here for your introduction to Java support in DB2 Universal Database.
		How to set up WebSphere Application Server 5.0.2 to connect to DB2/390 using the Type 4 DB2 Universal JDBC Driver (Type: Technote) These instructions help you set up the connection between WebSphere Application Server 5.0.2 and a DB2 for OS/390 database using the Type-4 DB2 Universal JDBC Driver.
		DB2 and WebSphere Studio: The Big Picture (Type: Article) This article describes the IBM WebSphere Studio family of products, which provide powerful tools, built-in facilities, and plug-ins that ease the task of accessing DB2 Universal Database data.
Development of XML programs
		DB2 UDB for OS/390 and z/OS XML Extender (Type: Product description) This Web page describes XML Extenders for OS/390 and z/OS, and it links to more information, including downloads.
		DB2 Version 8 SQL/XML and Materialized Query Tables (Type: Presentation; Format: PDF) This presentation introduces materialized query tables and XML publishing functions that are available in DB2 for z/OS, Version 8.
		Remote access to DB2 for z/OS (Type: Presentation; Format: PDF) Slides 22-26 of this presentation contain information about XML support in DB2.
		DB2 UDB for z/OS Version 8: Everything You Ever Wanted to Know, ... and More (Type: IBM Redbooks) Chapter 5.4 of This IBM Redbook contains information about the new XML publishing functions.
Developing with the DB2 Development Center
		Developer Workbench (Type: Product description) This topic describes the Developer Workbench, which replaces the DB2 Development Center in DB2 V9.1. The Developer Workbench is an Eclipse-based tool that offers functionality that is comparable to the DB2 Development Center along with some new features.
		DB2 Development Center - Tips to Get Up and Running (Type: Article) This article explains why the DB2 Development Center is a great tool specifically designed for server-side database development. This article answers some common questions that you might have when setting up and using the tool for the first time.
		DB2 Development Center -- The Next Generation AD Tooling for DB2 (Type: Article) This article describes some of the technical highlights of the DB2 Development Center and describes some of the major tasks you can do with the center, such as developing stored procedures, user-defined functions, and specialized table functions.
Certification for DB2 developers
		DB2 version 8 certification: Everything you need to know (Type: Certification) This article describes everything that you need to know about certification, including whether you should get certified, how you can get certified, and how you can prepare and study for the certification exam.
		Professional Certification Preparation Documents (Type: Certification; Format: PDF) These preparation documents help you prepare for DB2 Information Management certification exams. Each document covers role descriptions, requirements, objectives, and preparation suggestions.
		DB2 V8 Application Development certification prep tutorials (Type: Certification) This series of seven free tutorials is designed to help you prepare for the DB2 UDB V8.1 Family Application Development certification exam (Exam 703). This set of tutorials applies to the DB2 UDB products on all of the different operating systems, including z/OS.

Back to top

		HOME DEPOT spotlight for "IBM eServer zseries: On demand business makes it necessary, zSeries makes it possible" (Type: Marketing; Format: Other) This video show how Home Depot uses DB2 in a z/OS environment to successfully manage its data.
		Connectivity Cheat Sheet for DB2 Universal Database Part 2 - DB2 for z/OS (Type: Article) This article gives you details for connecting DB2 UDB for z/OS clients to DB2 UDB for z/OS servers or to servers on other operating systems. The following connectivity scenarios are included: -From a DB2 UDB for z/OS client to a DB2 UDB for Linux™, UNIX®, and Windows™ server -From a DB2 UDB for z/OS client to a DB2 UDB for iSeries™ server -From a DB2 UDB for z/OS client to another DB2 UDB for z/OS server
		Connectivity cheat sheet for Application Developers (Part 4) (Type: Article) This article discusses connectivity scenarios that involve DB2 UDB for Linux, UNIX, and Windows Version 8, DB2 UDB for iSeries 5.2, and DB2 UDB for z/OS Version 8. The focus of this article is on workstation application development connectivity using the C and Java languages.
		An Introduction to Distributed Processing with DB2 for z/OS (Type: Presentation; Format: PDF) This presentation provides information about the basics of DB2 for z/OS distributed processing. It includes a brief overview of the supported database interchange protocol that DB2 for z/OS supports, Distributed Relational Database Architecture™ (DRDA®), and then the article discusses DDF.
		Distributed Processing with DB2 for z/OS - Advanced Topics (Type: Presentation; Format: PDF) This presentation focuses on the distributed processing in detail and covers more advanced topics.
		Parallel Sysplex Continuous Availability - Case Studies (Type: IBM Redbooks) This IBM Redbook discusses the topic of continuous availability in a Parallel Sysplex® environment. The two case studies cover DB2 data sharing, and VSAM Record Level Sharing and they provide specific technical tips that may assist other users in similar environments.
		Smoke and Mirrors 2 (Type: Presentation; Format: PDF) This presentation describes several disaster recovery scenarios that use DASD mirroring. You can evaluate each scenario in light of DB2 recovery, in terms of timing, scope, and complexity.

Back to top

		Verifying installation with the sample applications (Type: Information center) These topics explain how to use sample applications that are provided with DB2 to verify a successful migration to or installation of DB2 Version 9.1 for z/OS.
		DB2 for z/OS Exchange (Type: Forum) Use this Web site to find and exchange sample code with other users.
		IDUG Insider (Type: Forum) On the Insider section of the International DB2 Users Group (IDUG) Web site, you can find scripts, code fragments, and samples for DB2 technology. You can also submit your own samples.

Back to top

		Debugging Options for DB2 UDB Stored Procedures (Type: Article) This article briefly describes your options for debugging DB2 stored procedures on DB2 UDB for z/OS and OS/390 V6, V7, and V8.
		Debugging Java Stored Procedures on DB2 UDB for z/OS (Type: Article) In this article, Peggy Rader briefly describes your options for debugging Java stored procedures on DB2 UDB for z/OS and provides a hint for making it work with the IBM SDK 1.3.1.
		Debugging your program (Type: Information center) Many organizations have guidelines regarding what to do if your program abends. These topics contain some common suggestions.
		How to order the DB2 Diagnosis Guide and Reference (Type: Technote) This technote provides information about how to order the DB2 Diagnosis Guide and Reference. The DB2 Diagnosis Guide and Reference provides information for diagnosing DB2 problems.

Back to top

		Testing an application program (Type: Information center) This topic discusses how to set up a test environment, test SQL statements, debug your programs, and read output from the precompiler.
		Debugging a stored procedure (Type: Information center) Some commonly used debugging tools, such as TSO TEST, are not available in the environment where stored procedures run. These topics contain some alternative testing strategies to consider.
		DB2 Test Database Generator (Type: Product description) This Web page contains general information and resources for DB2 Test Database Generator, which rapidly populates application and testing environments and simplifies problem resolution.

Back to top

		Securing DB2 and Implementing MLS on z/OS (Type: IBM Redbooks) This IBM Redbook discusses the choices that DB2 offers to secure your data.
		Security and auditing (Type: Information center) These topics provide information about security and auditing for DB2. This information is from the DB2 Administration Guide.
		DB2 UDB for z/OS Version 8 Major Security Improvements (Type: Presentation; Format: PDF) This presentation describes the security features in Version 8, including multilevel security, row-level security, and encryption. The primary focus is on security, privacy, and auditing.
		DB2 for z/OS and OS/390 Security: Protect Your Assets (Type: Presentation; Format: PDF) This presentation by Roger L. Miller, DB2 Architect and Lead Strategist, is an overview (with speaker notes) of the security features in DB2 for z/OS and OS/390. This overview can help you make decisions about choosing the best security options in DB2 for z/OS and OS/390 for your requirements.

Back to top

General monitoring and tuning information
		DB2 9 for z/OS Performance Topics (Type: IBM Redbooks) This IBM Redbooks publication provides an overview of the performance impact of DB2 9 for z/OS, especially performance scalability for transactions, CPU, and elapsed time for queries and utilities.
		DB2 9 for z/OS Application Performance and Tuning (Type: Classroom course) Learn how to detect, fix, and prevent application performance problems with DB2 9 for z/OS. Complete design and tuning exercises that are based on real-life experiences. Gain skills to address the most common application performance problems, such as inadequate indexes, optimizer issues, lock waits, physical table design, and cursor design.
		DB2 for z/OS System Performance Analysis and Tuning (Type: Classroom course) Learn how to monitor and tune DB2 for z/OS from the point of view of a system programmer.
		DB2 UDB for z/OS Version 8 Performance Topics (Type: IBM Redbooks) This IBM Redbook introduces the major performance and availability changes in Version 8 as well as the performance characteristics of many new functions. This book also provides laboratory measurements to help you evaluate the performance impact of Version 8.
		Virtual Storage Management 2005 Revisited (Type: Presentation; Format: PDF) This presentation provides a detailed and thorough update on managing virtual storage constraint, above and below 16MB line, with both Version 7 and Version 8.
		Tune SQL like an expert in DB2 UDB z/OS V8 - Terry Purcell (Type: Presentation; Format: PDF) This presentation outlines a method for using the extensive and detailed access path information that is available with Version 8 of Visual Explain. This presentation will help you compare cost estimates with the actual reality for a given query without being an optimization expert.
		What's new in DB2 UDB for z/OS Buffer Pool Management (update) - Jim Teng (Type: Presentation; Format: PDF) This presentation explains the buffer pool enhancements that were delivered in DB2 UDB Version 7 and Version 8.
		Exciting SQL Performance Enhancements in DB2 for z/OS Version 8 - James Guo (update) (Type: Presentation; Format: PDF) This presentation discusses some of the highlights of Version 8 SQL performance enhancements. It focuses on use of SQL with materialized query tables, multiple row processing with FETCH and INSERT statements, stage 1 and indexable predicates with unmatched data types and lengths, parallel sort, and distribution statistics on non-indexed columns.
		Let's Look at Materialized Query Tables for DB2 UDB V8 z/OS - Randy Ebersole (Type: Presentation; Format: PDF) This presentation discusses the basics of materialized query tables and gives you an understanding of how you can best use this new functionality.
		What's new in DB2 UDB for z/OS Locking and Concurrency - Jim Teng (Type: Presentation; Format: PDF) This presentation describes several new locking enhancements that were added to Version 7 and Version 8 to improve application availability. It explains how SQL and DB2 utilities handle concurrency control and it gives guidelines on how to design a database to improve concurrency.
		Performance Issues in Migrating to DB2 UDB for z/OS - Akira Shibamiya (Type: Presentation; Format: PDF) This presentation covers several facets of migration, including: performance considerations and the impact on I/O time, real storage, and virtual storage. It also provides performance monitoring and tuning tips to reduce CPU usage of applications that are migrating to V8.
		Performance monitoring and tuning (Type: Information center) These topics provide information about tuning and monitoring the performance of DB2. These topics are from the DB2 for z/OS Performance Monitoring and Tuning Guide..
		DB2 for z/OS and OS/390 : Squeezing the Most Out of Dynamic SQL (Type: IBM Redbooks) This IBM Redbook explains myths and misconceptions about dynamic SQL by presenting a balanced discussion of issues such as complexity, performance, and control.
		DB2 for z/OS DB2 database design: Principles of peak performance (Type: Article) This article provides some general guidelines and recommendations for achieving better DB2 performance in z/OS environments.
		DB2 for z/OS V8 Performance (Type: Presentation; Format: PDF) This presentation discusses application and system performance topics.
		Health Checking Your DB2 System (Type: Presentation; Format: PDF) This presentation shares lessons learned from critical situations and customer health check studies, including information related to service, performance, restart and recovery, and storage.
		DB2 for z/OS and OS/390 Version 7 Selected Performance Topics (Type: IBM Redbooks) This IBM Redbook provides performance measurements and discusses the performance related maintenance that IBM shipped after general availability of DB2 for z/OS Version 7.
Using monitoring and performance tools
		Visual Explain for DB2 for z/OS, Version 8 (Type: Download) This Web page lets you download Visual Explain Version 8, which is a graphical tool you use to tune SQL statements. Visual Explain Version 8 works with DB2 for z/OS Version 7 or Version 8.
		DB2 Performance Expert (Type: Product description) This Web page describes IBM DB2 Performance Expert, which is a powerful tool for analyzing and optimizing DB2 performance.
		DB2 Performance Expert documentation (Type: Manuals) This Web page lists and provides links to the technical information about DB2 Performance Expert for z/OS, Multiplatforms, and Workgroups.
		IBM DB2 Performance Expert for z/OS Version 2 (Type: IBM Redbooks) This IBM Redbook is the update of the previous IBM Redbooks DB2 Performance Expert for z/OS and describes how to install, customize, and use DB2 Performance Expert for z/OS Version 2.
		SAP on DB2 for z/OS and OS/390: High Availability and Performance Monitoring with Data Sharing (Type: IBM Redbooks) This IBM Redbook addresses the challenges posed by monitoring high availability, scalability, and performance in an SAP Sysplex data sharing environment.
		IBM Tivoli® OMEGAMON® XE for DB2 on z/OS (Type: Product description) This Web page contains information about IBM Tivoli OMEGAMON XE for DB2 on z/OS, the next evolution in OMEGAMON performance and availability solutions.
		Using OMEGAMON to analyze DB2 application threads and subsystems (Type: Presentation; Format: PDF) These presentations explain how to use IBM Tivoli OMEGAMON XE for DB2 on z/OS.
		DB2 Query Monitor (Type: Product description) This Web page contains general information and resources for DB2 Query Monitor, which gives you the ability to efficiently customize and tune your SQL workload and DB2 objects.

Back to top

Code fixes
		APARs (Type: Download) This Web page displays the current list of DB2 for z/OS APARs. Each APAR contains links to the associated PTFs, which you can order as needed.
		Technical Help database (searching for APARs) (Type: Download) Use this Web site to search for APARs related to the mainframe environment.
		Getting fixes (Type: Information center) Use this topic to find and get PTFs to resolve problems with DB2 UDB for z/OS.
Technical information to help solve problems
		DB2 for z/OS and Data Sharing Recovery/Restart Workshop (Type: Classroom course) Learn to plan and implement recovery procedures for a DB2 UDB for z/OS, Version 8 data sharing installation. This course provides information about expanding all local recovery and disaster recovery procedures to support a DB2 data sharing environment. You also examine the automatic restart of members, testing data sharing functions and utilities, rebuilding Shared Communications Area (SCA), and more.
		DB2 for z/OS System/Disaster Recovery Workshop (Type: Classroom course) Learn how to design and implement recovery and restart procedures for DB2 for z/OS. This course emphasizes the three most difficult recovery emergencies: conditional restart, broken catalog/directory, and off-site recovery. Design and set up procedures for database recovery and catalog/directory, or database broken data recovery. More than half of the course is devoted to hands-on labs and lab reviews.
		Disaster Recovery with DB2 UDB for z/OS (Type: IBM Redbooks) This IBM Redbook focuses on disaster recovery solutions and best practices. It consists of the most common solutions and shows how to implement them using several recovery scenarios.
		Messages and codes (Type: Information center) These topics provide detailed descriptions of the messages and codes that are issued by DB2, with explanations and user responses for the situations that are associated with these messages and codes. This information comes from the two books, DB2 Messages and DB2 Codes. These books are available in PDF to download.
		LookAT (Type: Error message) Search for information about DB2 messages or codes using the IBM LookAt tool.
		How to order the DB2 Diagnosis Guide and Reference (Type: Technote) This technote provides information about how to order the DB2 Diagnosis Guide and Reference. The DB2 Diagnosis Guide and Reference provides information for diagnosing DB2 problems.
		Current list of technotes (Type: Technote) This Web page displays a list of the most current Support technotes that answer frequently asked questions and provide useful information.
		Information updates (Type: Article) This Web page contains links to recent updates to DB2 information and documentation.
		Finding the most current DB2 documentation and answers to other documentation questions (Type: Technote) This technote explains where you can find the most current documentation for DB2 for z/OS, why some books are not available on the library Web page, and how you can send feedback. This technote also answers other common documentation questions.
Newsgroups and forums for sharing troubleshooting information
		developerWorks® DB2 UDB for OS/390 and z/OS forum (Type: Forum) This forum mirrors the ibm.software.db2.mvs newsgroup.
		IDUG Discussion List (Type: Forum) IDUG provides a forum for users to share DB2 knowledge and experiences.
General IBM Software Support information
		Data Recovery Now and Future Using IBM's Recovery Tools (Type: Presentation; Format: PDF) This presentation reviews all types of data recovery, IBM's current recovery offerings, and IBM's recovery tooling philosophy, including autonomic functions and high priority requirements that we are working on in the laboratory today.
		Troubleshooting overview (Type: Information center) These topics provide information about how to troubleshoot a problem with your IBM software, including instructions for searching knowledge bases, getting fixes, and contacting IBM Software Support.
		Software Support Handbook (Type: Manual) The purpose of this document is to provide guidelines and reference materials that you might need when you require IBM Software Support.
		Support acronyms and other terms (Type: Manual) This glossary lists acronyms and terms that are used frequently by IBM Software Support when solving customer problems.

Back to top

		DB2 SQL (Type: Information center) These topics provide detailed reference information about DB2 language elements, functions, queries, SQL statements, SQL control statements, and catalog tables. This information comes from the DB2 SQL Reference.
		The SQL Reference for Cross-Platform Development (Type: Manual; Format: PDF) This book provides detailed reference information that is useful for people who use SQL in application programs that need to be portable across the IBM DB2 Universal Database family of products.
		DB2 commands (Type: Information center) These topics provide detailed reference information about the DB2 commands and the commands of related products with which DB2 operates. This information comes from the DB2 Command Reference.
		DB2 utilities (Type: Information center) These topics provide detailed information about the syntax and usage of the DB2 online and stand-alone utilities. This information comes from the DB2 Utility Guide and Reference.
		Product Support Lifecycle (Type: Other) The IBM Software Support Lifecyle page shows the dates that marketing and support services are available, and end-of-service (EOS) dates, for each version of DB2 for z/OS.
		CF Level and the Coupling Facility (Type: Other) This Web page contains information about coupling facility (CF) levels, including which ones are currently supported.
		DB2 glossary (Type: Information center) This glossary contains DB2 for z/OS terms.
		Terminology and citations (Type: Information center) This topic explains terminology and citations that are used in DB2 documentation.

Back to top

This section may provide links or references to non-IBM Web sites and resources. IBM makes no representations, warranties, or other commitments whatsoever about any non-IBM Web sites or third-party resources (including any Lenovo Web site) that may be referenced, accessible from, or linked to any IBM site. A link to a non-IBM Web site does not mean that IBM endorses the content or use of such Web site or its owner. In addition, IBM is not a party to or responsible for any transactions you may enter into with third parties, even if you learn of such parties (or use a link to such parties) from an IBM site. Accordingly, you acknowledge and agree that IBM is not responsible for the availability of such external sites or resources, and is not responsible or liable for any content, services, products, or other materials on or available from those sites or resources. When you access a non-IBM Web site, even one that may contain the IBM-logo, please understand that it is independent from IBM, and that IBM does not control the content on that Web site. It is up to you to take precautions to protect yourself from viruses, worms, trojan horses, and other potentially destructive programs, and to protect your information as you deem appropriate.
		IBM Information Management user groups (Type: User group) These user groups provide a forum where the Information Management user community can communicate, meet, and learn from each others' experiences using IBM Information Management software solutions.
		International DB2 Users Group (IDUG) (Type: User group) This users group provides a forum for the DB2 community to learn and share experiences about effectively using the DB2 family of products, including DB2 for z/OS, DB2 for Linux, UNIX, and Windows, DB2 for IBM i, DB2 Express, DB2 Everywhere, and DB2 Data Warehouse Edition.
		SHARE (Type: User group) This community provides Information Technology professionals with access to continuous education and training, and valuable professional networking, helping you to achieve your business goals.
		IBM developerWorks Information Management forums (Type: Forum) These forums provide a venue for the Information Management community to discuss and share solutions for technology-related and product-related issues.
		DB2 for z/OS developerWorks Exchange (Type: Forum) This forum enables you to exchange sample programs, SQL statements, utility jobs, and more with your colleagues.
		Information Management blogs (Type: Blog) This Web site provides links to blogs about DB2, Informix, and a variety of Information Management topics. These blogs contain different types of information, from tips and techniques to news, views, and more.
		DB2utor (Type: Blog) This blog provides hints, tips, and best practices for using DB2 for z/OS and related products.
		DB2Portal.com (Type: Blog) This site provides useful links to DB2 for z/OS resources, such as blogs.
		Getting the most of DB2 for z/OS and System z (Type: Blog) This blog by Willie Favero, a certified IT software specialist for DB2 for z/OS, offers hints and tips about DB2 for z/OS and System z, including tips on migration, performance, and maintenance.
		Robert's Blog (Type: Blog) In this blog, Robert Catterall, Catterall Consulting, writes about DB2 for z/OS, providing information about topics such as performance tuning, data warehousing, data sharing, service-oriented architecture (SOA), and more.
		DB2Portal blog (Type: Blog) This blog by Craig Mullins, a data management strategist and consultant, offers news, views, and items of interest on DB2 database management and mainframe systems.
		IBM Database Magazine Wiki (Type: Other) Provided by IBM Database Magazine, this wiki gathers know-how about DB2, Informix, U2, IMS, solidDB, and other Information Management products and makes the information available to the IBM Information Management user community. You can post new material to this wiki, or edit existing posts.
		ChannelDB2 (Type: Other) This networking site provides a variety of resources about DB2, including videos, blogs, podcasts, and discussions.
		DB2 Facebook community (Type: Other) This site connects members of the DB2 community. On this Facebook page, you can find links to blogs and videos about DB2, and become a fan of DB2 on Facebook.
		DB2 Docs Facebook community (Type: Other) This site connects members of the DB2 community who are interested in DB2 documentation. Join this Facebook group to discuss and provide feedback on the documentation, and to read posts about news and issues.

Back to top

		Send documentation feedback (Type: Other) We welcome your feedback about any of the books, online help, wizards, or information center topics for Information Management products. Your comments are sent to the authors to help improve IBM product information.
		Send product feedback (Type: Other) We want to improve IBM software for you! Take the Consumability Survey.

Back to top

Items marked with this symbol are available to customers who have an IBM Registration ID.