Product documentation
Abstract
This roadmap outlines the information resources that are available for installation, administration, and programming for DB2 for z/OS.
Content
Tab navigation
Product overview
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 PDF books for information center topics (Type: Information center, Manual) This information center topic contains links that you can use to download DB2 for z/OS technical manuals (in PDF format) and links to the information center topics that correspond to each manual.
DB2 for z/OS - Technical Resources (Type: Manual, Information center) This technote provides an information center search box, links to where you can find PDF manuals in the information center, links to DB2 for z/OS and related Program Directories, and links to other valuable information resources.
DB2 for z/OS Family (Type: Product description) This web page describes the new features and benefits of DB2 for z/OS.
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.
Information Management software lifecycle dates (Type: Other) The Information Management software lifecycle page shows the dates that marketing and support services are available for each version of DB2 for z/OS, along with the end-of-service (EOS) dates.
Customer Testimonials (Type: Other) This web page enables you to listen to IBM zSeries® customers tell their own stories.
Planning
General planning for DB2 for z/OS
Release announcement for DB2 Version 9.1 for z/OS (Type: Product description) This announcement letter summarizes the key enhancements that are available in DB2 Version 9.1 for z/OS.
Program Directories for DB2 Version 9.1 for z/OS (Type: Manual) This web page links to Program Directories for DB2 9 for z/OS and related components. Program Directories provide helpful information that you need when you install or migrate to a new version of a product.
DB2 9 for z/OS Technical Overview (Type: IBM Redbooks) This IBM Redbooks publication introduces the enhancements made available with DB2 9 for z/OS. This publication helps you understand the new functions, justify investment in migrating, and plan for exploiting the key new capabilities.
DB2 Version 9.1 for z/OS What's New? (Type: Information center) This information provides an executive overview of the new functions in DB2 Version 9.1 for z/OS. New functions are categorized according to user benefits, such as information on demand, availability, and performance.
Planning for DB2 Version 9.1 for z/OS (Type: Information center) This information summarizes changes to DB2 commands, DB2 utilities, SQL statements, the DB2 catalog, DB2 performance monitoring, and instrumentation facility component identifiers (IFCIDs) in DB2 Version 9.1 for z/OS, helping you plan for this release.
Preparing your system to install or migrate DB2 (Type: Information center) This information describes 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.
Planning for specific functions in DB2 for z/OS
Preparing for DB2 data sharing (Type: Information center) This information provides details about planning for DB2 data sharing, establishing naming conventions, estimating storage requirements, and so on.
DB2 Utilities Suite for z/OS (Type: Product description) This web page contains basic information about the DB2 Utilities Suite, including the key features and system requirements.
Planning for use of DB2 enterprise applications
DB2 9 for z/OS: Deploying SOA Solutions (Type: IBM Redbooks) This IBM Redbooks publication helps you get started with SOA. We show you how to implement the minimum requirements by using functions that DB2 for z/OS provides, such as pureXML and SOAP user-defined functions, in conjunction with the functions that Data Studio, DataPower, and WebSphere Application Server provide.
Installing
DB2 9 for z/OS Implementation Workshop (Type: Classroom course) Learn about 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 9 for z/OS Data Sharing Implementation Workshop (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.
Preparing your system to install or migrate DB2 (Type: Information center) This information describes 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.
Program Directory for DB2 9 for z/OS (Type: Manual; Format: PDF) This information provides the SMP/E installation sample jobs and instructions.
DB2 utilities packaging (Type: Information center) This information explains the packaging of the DB2 utilities and how to install them.
Program Directory for DB2 Utilities Suite for z/OS (Type: Manual; Format: PDF) This information provides the SMP/E installation sample jobs and instructions for the DB2 Utilities Suite for DB2 9 for z/OS.
Installing the IBM Data Server Driver for JDBC and SQLJ (Type: Information center) This information describes how to install the IBM Data Server Driver for JDBC and SQLJ.
Installing a new data sharing group (Type: Information center) This information describes how to install and immediately enable DB2 data sharing on a new Version 9 member.
Installing DB2 ODBC (Type: Information center) This information explains how to edit and run SMP/E jobs to install DB2 ODBC.
Migrating
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.
Preparing your system to install or migrate DB2 Version 9 (Type: Information center) This information describes 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.
Program Directory for DB2 9 for z/OS (Type: Manual; Format: PDF) This information provides the SMP/E installation sample jobs and instructions.
DB2 for z/OS Best Practices (Type: Website) Are you looking for recommendations and tips on how to best use DB2 for z/OS to meet your business needs? This website provides best practices recommendations on a variety of subjects, including migration, from some of your favorite DB2 experts based on field experience. You can download and watch presentations, listen to podcasts and previously recorded webcasts, and read articles.
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.
Introduction to character conversion (Type: Information center) This information provides basic guidance about international data, character conversion, and how Unicode works in a DB2 for z/OS environment. Topics include detailed information about character conversion and about how to communicate with other subsystems that use different encoding schemes.
Configuring
DB2 9 for z/OS Stored Procedures: Through the CALL and Beyond (Type: IBM Redbooks) This IBM Redbooks publication helps you design, install, manage, and tune stored procedures with DB2 9 for z/OS.
Tailoring DB2 jobs to your environment using the installation CLIST (Type: Information center) This information explains how to change system parameters in DB2 9 for z/OS.
Directory of subsystem parameters and DSNHDECP values (Type: Information center) This information describes the DB2 subsystem parameters in DB2 9 for z/OS.
Working with additional capabilities for DB2 (Type: Information center) This information discusses communicating with other systems, including connecting distributed database systems, connecting systems with VTAM®, and connecting systems with TCP/IP.
DB2 9 for z/OS: Distributed Functions (Type: IBM Redbooks) This IBM Redbooks publication 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.
DB2 for z/OS Best Practices (Type: Website) Are you looking for recommendations and tips on how to best use DB2 for z/OS to meet your business needs? This website provides best practices recommendations on a variety of subjects, including configuration, from some of your favorite DB2 experts based on field experience. You can download and watch presentations, listen to podcasts and previously recorded webcasts, and read articles.
Administering
General administration information
DB2 9 for z/OS Database Administration Workshop Part 1 (Type: Classroom course) This course provides you with instruction on how to physically implement a logical database design in DB2 9 for z/OS. The course includes instruction on DB2 data management, DB2 catalog tables, the bind process, database utilities such as LOAD and REORG, and security considerations. A continuation of this course is provided in "DB2 9 for z/OS Database Administration Workshop Part 2."
DB2 9 for z/OS System Administration (Type: Classroom course) In this course, administrators of DB2 9 for z/OS can acquire a view of the architecture and fundamental processes required to manage a DB2 9 for z/OS subsystem. Gain experience by engaging in lectures and hands-on labs.
DB2 administration (Type: Information center) This information is designed for DB2 database or system administrators. This information helps you operate, recover from problems, and manage security in a DB2 for z/OS environment.
DB2 commands (Type: Information center) This information provides detailed reference information for DB2 and related commands, including environment information, the privileges and authorities for each command, syntax and option descriptions, and examples.
DB2 Administration Tool for z/OS (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.
Introduction to character conversion (Type: Information center) This information provides basic guidance about international data, character conversion, and how Unicode works in a DB2 for z/OS environment. Topics include detailed information about character conversion and about how to communicate with other subsystems that use different encoding schemes.
DB2 for z/OS Best Practices (Type: Website) Are you looking for recommendations and tips on how to best use DB2 for z/OS to meet your business needs? This website provides best practices recommendations on a variety of subjects, including administration, from some of your favorite DB2 experts based on field experience. You can download and watch presentations, listen to podcasts and previously recorded webcasts, and read articles.
Administration for data sharing environments
Preparing for DB2 data sharing (Type: Information center) This information provides details about planning for DB2 data sharing, establishing naming conventions, estimating storage requirements, and so on.
Communicating with data sharing groups (Type: Information center) This information explains how to use a data sharing group as a powerful server in your client/server environment.
Installing a new data sharing group (Type: Information center) This information describes how to install and immediately enable DB2 data sharing on a new Version 9 member.
SAP on DB2 for z/OS and OS/390: High Availability and Performance Monitoring with Data Sharing (Type: IBM Redbooks) This IBM Redbooks publication addresses the challenges posed by monitoring high availability, scalability, and performance in an SAP Sysplex data sharing environment.
PeopleSoft V8 on zSeries Using Sysplex Data Sharing and Enterprise Storage Systems (Type: IBM Redbooks) This IBM Redbooks publication is about PeopleSoft Version 8.4 on a zSeries Parallel Sysplex data sharing environment and focuses on all aspects of performance.
Parallel Sysplex Continuous Availability - Case Studies (Type: IBM Redbooks) This IBM Redbooks publication 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 might assist other users in similar environments.
Administration with DB2 utilities
DB2 Utilities Suite for z/OS (Type: Product description) This web page contains basic information about the DB2 Utilities Suite, including the key features and system requirements.
DB2 utilities (Type: Information center) This information provides detailed information about the syntax and usage of the DB2 online and stand-alone utilities. This is the same information that is in DB2 Utility Guide and Reference.
Moving Data Across the DB2 Family (Type: IBM Redbooks) This IBM Redbooks publication provides an overview of what is currently available within the DB2 family of products (specifically DB2 for z/OS and DB2 for Linux, UNIX, and Windows). This book explains functions, tools, and utilities to satisfy the need for moving data. This publication also focuses on High Performance Unload and Cross Loader.
Administration with DB2 Tools
InfoSphere Optim Data Management Solutions (Type: Product description) InfoSphere Optim Data Management solutions manage data from requirements to retirement. Use these products to boost performance, empower collaboration, and improve governance across applications, databases and platforms.
DB2 Tools information (Type: Information center) Visit the Information Management Software for z/OS Solutions Information Center to find the information that you need to install, customize, manage, and support tools for DB2 databases.
DB2 Administration Tool for z/OS (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 for z/OS (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 for z/OS (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 Log Analysis Tool for z/OS (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 for z/OS (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 for z/OS (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.
Administration with DB2 enterprise applications
Enhancing SAP by Using DB2 9 for z/OS (Type: IBM Redbooks) This IBM Redbooks publication presents many of the new and improved features and functions of DB2 V9.1 for z/OS and DB2 Connect V9.1. It explains how they complement and benefit your SAP NetWeaver environment. This book also shares some of our experiences in migrating our DB2 V8 SAP data sharing environment to DB2 9 for z/OS with a minimal amount of outage.
Best Practices for SAP BI using DB2 9 for z/OS (Type: IBM Redbooks) Clients want to know how to exploit the new features of both DB2 V9 and SAP in their SAP BI environments. This IBM Redbooks publication describes the benefits of DB2 V9 for SAP Business Information Warehouse. It covers best practices and provides performance and tuning recommendations.
WebSphere Business Integration for SAP (Type: IBM Redbooks) This IBM Redbooks publication illustrates how to integrate data and processes located in SAP back-end systems by using WebSphere Business Integration middleware technology.
Certifications for DB2 administrators
IBM Certified Database Administrator - DB2 9 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 9 for z/OS Database Administration: Certification Study Guide (Type: Book) Written by two members of the team who participated in writing the exam, this specialized study guide covers every topic that you will need to know to pass Exam 732. Topics include database design and implementation, operation and recovery, security and auditing, performance, and installation and migration. It also covers the new features of DB2 9 for both database and application development.
DB2 9 certification: Everything you need to know (Type: Article) This article tells you what you need to know to decide if DB2 certification is for you, and if so, the secrets to doing it successfully, quickly and inexpensively. This information applies to DB2 products on all of the different operating systems, including z/OS.
Exam Preparation Guides (Type: Certification; Format: PDF) These complimentary preparation guides help to provide you with the information that you need to prepare for Information Management certification exams. Each guide covers role descriptions, requirements, objectives and preparation suggestions.
Developing
General DB2 database programming
DB2 9 for z/OS Application Programming Workshop (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.
Application programming and SQL (Type: Information center) This information provides details 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 is the same information that is in the DB2 Application Programming and SQL Guide.
DB2 SQL (Type: Information center) This information provides detailed reference information about DB2 language elements, functions, queries, SQL statements, SQL control statements, and catalog tables.
DB2 Query Management Facility (Type: Product description) DB2 Query Management Facility for z/OS is a complete analysis package that can provide effective, visualized data in response to even the most complex business queries.
DB2 for z/OS Best Practices (Type: Website) Are you looking for recommendations and tips on how to best use DB2 for z/OS to meet your business needs? This website provides best practices recommendations on a variety of subjects, including development topics, from some of your favorite DB2 experts based on field experience. You can download and watch presentations, listen to podcasts and previously recorded webcasts, and read articles.
Connectivity and distributed database development
DB2 9 for z/OS Stored Procedures: Through the CALL and Beyond (Type: IBM Redbooks) This IBM Redbooks publication helps you design, install, manage, and tune stored procedures with DB2 9 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.
DB2 9 for z/OS: Distributed Functions (Type: IBM Redbooks) This IBM Redbooks publication 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) This information provides details 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 is the same information that is in Reference for Remote DRDA Requesters and Servers.
Programming for ODBC (Type: Information center) This information provides guidance for DB2 ODBC application programming tasks, and reference information about each DB2 ODBC function. This is the same information that is in ODBC Guide and Reference.
Communicating with data sharing groups (Type: Information center) This information explains how to use a data sharing group as a powerful server in your client/server environment.
Porting data from another DBMS to DB2
InfoSphere Replication Server for z/OS (Type: Product description) This web page explains InfoSphere Replication Server for z/OS, a product that distributes, consolidates, and synchronizes data. This enterprise software application moves large volumes of data at high speeds to help businesses connect globally-distributed operations, respond quickly to customers, and rapidly recover from problems that impact critical database systems.
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.
Development of Java™, JDBC, and J2EE programs
DB2 and Java: The Big Picture (Type: Article) Start here for your introduction to Java support in DB2 for z/OS.
Programming for Java (Type: Information center) This information provides details about developing Java programs that access DB2 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 Redbooks publication 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.
Development of XML programs
Programming for XML (Type: Information center) This information provides details about creating and altering tables to store XML data, creating and altering indexes on XML data, creating XML schemas for validation of XML data, and writing and preparing programs that access XML data in DB2 for z/OS databases.
Remote access to DB2 for z/OS (Type: Presentation; Format: PDF) Slides 22-26 of this presentation contain useful information about XML support in DB2.
Developing with Developer Workbench
Get your DB2 for z/OS system ready for Developer Workbench V9.2 (Type: Article) This article discusses the system-related tasks that you, as a DB2 9 for z/OS user, should consider when utilizing the functions in Developer Workbench (DWB), which replaces the Development Center. It provides an overview of DWB, and discusses customization JCLs, RACF, and migration considerations. You will also take a look at some common set-up errors and problems.
Certification for DB2 developers
DB2 9 Application Developer (Type: Certification; Format: PDF) This information explains how you become an IBM Certified Application Developer and provides links to training materials. This information applies to DB2 products on all of the different operating systems, including z/OS.
DB2 9 certification: Everything you need to know (Type: Article) This article tells you what you need to know to decide if DB2 certification is for you, and if so, the secrets to doing it successfully, quickly and inexpensively. This information applies to DB2 products on all of the different operating systems, including z/OS.
Exam Preparation Guides (Type: Certification; Format: PDF) These complimentary preparation guides help to provide you with the information that you need to prepare for Information Management certification exams. Each guide covers role descriptions, requirements, objectives and preparation suggestions.
DB2 stored procedures
DB2 9 for z/OS Stored Procedures: Through the CALL and Beyond (Type: IBM Redbooks) This IBM Redbooks publication helps you design, install, manage, and tune stored procedures with DB2 9 for z/OS.
Using DB2 for z/OS stored procedures with QMF (Type: Information center) This information explains how to develop and run stored procedures from QMF.
Creating a native SQL procedure (Type: Information center) This information explains how to create native SQL procedures, which are new in Version 9.1.
DB2 for z/OS Best Practices (Type: Website) Are you looking for recommendations and tips on how to best use DB2 for z/OS to meet your business needs? This website provides best practices recommendations on a variety of subjects, including stored procedures, from some of your favorite DB2 experts based on field experience. You can download and watch presentations, listen to podcasts and previously recorded webcasts, and read articles.
Breaking the DB2 Platform Barrier (Type: White paper; Format: PDF) This white paper is for 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) This information introduces DB2 stored procedures, and explains how to write, prepare, run, and test stored procedures that are not written in Java.
Java stored procedures and user-defined functions (Type: Information center) This information is specific to defining and writing Java user-defined functions and stored procedures.
Leverage the power of SQL Procedural Language on DB2 for Linux, UNIX, Windows, i5/OS, and z/OS (Type: Article) This article provides an overview about writing portable and efficient SQL PL code on Linux, UNIX, Windows, i5/OS, and z/OS. This article also 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.
Scenarios
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.
Samples
Verifying that installation or migration was successful with the sample applications (Type: Information center) This information explains 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 developerWorks Exchange (Type: User group) This forum enables you to exchange sample programs, SQL statements, utility jobs, and more with your colleagues.
IDUG Codeplace (Type: User group) On this section of the International DB2 Users Group (IDUG) website, you can find scripts, code fragments, and samples for DB2 technology. You can also submit your own samples.
Debugging and testing
Debugging your program (Type: Information center) Many organizations have guidelines regarding what to do if your program abends. This information contains some common suggestions.
How to order DB2 Diagnosis Guide and Reference (Type: Technote) This technote provides information about how to order DB2 Diagnosis Guide and Reference. This book provides information for diagnosing DB2 problems.
Testing an application program (Type: Information center) This information 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. This information contains some alternative testing strategies to consider.
Security
Securing DB2 and Implementing MLS on z/OS (Type: IBM Redbooks) This IBM Redbooks publication discusses the choices that DB2 offers to secure your data.
Security and auditing (Type: Information center) This information provides details about security and auditing for DB2. This is the same information that is in the DB2 Administration Guide.
DB2 for z/OS Best Practices (Type: Website) Are you looking for recommendations and tips on how to best use DB2 for z/OS to meet your business needs? This website provides best practices recommendations on a variety of subjects, including security, from some of your favorite DB2 experts based on field experience. You can download and watch presentations, listen to podcasts and previously recorded webcasts, and read articles.
Managing performance
General 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: Buffer Pool Monitoring and Tuning (Type: IBM Redbooks) This IBM Redpaper publication describes the functions of DB2 buffer pools, introduces read and write performance metrics for buffer pools, recommends how to set up and monitor DB2 buffer pools, and shares actual results from customers. This information is intended for DB2 system administrators and z/OS performance specialists.
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 9 for z/OS System Performance Analysis and Tuning (Type: Classroom course) This classroom course explains how to monitor and tune DB2 9 for z/OS from a system point of view.
Managing performance, Version 9 (Type: Information center) This information will help you monitor the performance of your DB2 9 subsystem and tune various aspects of system and application performance.
DB2 for z/OS Best Practices (Type: Website) Are you looking for recommendations and tips on how to best use DB2 for z/OS to meet your business needs? This website provides best practices recommendations on a variety of subjects, including monitoring and tuning performance, from some of your favorite DB2 experts based on field experience. You can download and watch presentations, listen to podcasts and previously recorded webcasts, and read articles.
Tune SQL like an expert in DB2 for z/OS (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. (The information in this presentation applies to all in-service versions of DB2; however, Visual Explain is only available for DB2 UDB for z/OS, Version 8. For DB2 9, you can use Optimization Service Center or Data Studio to obtain similar information.)
DB2 for z/OS and OS/390: Squeezing the Most Out of Dynamic SQL (Type: IBM Redbooks) This IBM Redbooks publication explains some myths and misconceptions about dynamic SQL by presenting a balanced discussion of issues such as complexity, performance, and control.
Using performance tools
InfoSphere Optim Data Management Solutions (Type: Product description) InfoSphere Optim Data Management solutions manage data from requirements to retirement. Use these products to boost performance, empower collaboration, and improve governance across applications, databases and platforms.
Optimization Service Center for DB2 for z/OS (Type: Product description) Optimization Service Center for DB2 for z/OS is a workstation tool for monitoring and tuning the SQL statements that run on DB2 9 for z/OS. You can use Optimization Service Center to identify and analyze problem SQL statements and to perform many tuning tasks.
Optim Query Tuner for DB2 for z/OS (Type: Product description) Optim Query Tuner for DB2 for z/OS helps developers create efficient queries and build tuning skills. Optim Query Tuner cuts cost and improves performance by providing expert advice on writing high-quality queries and improving database design. Its easy-to-use advisors can help developers to write more efficient SQL queries.
IBM DB2 9 for z/OS: New Tools for Query Optimization (Type: IBM Redbooks) This IBM Redbooks publication describes how to install, customize, and use DB2 Optimization Service Center and DB2 Optimization Expert.
SAP on DB2 for z/OS and OS/390: High Availability and Performance Monitoring with Data Sharing (Type: IBM Redbooks) This IBM Redbooks publication addresses the challenges posed by monitoring high availability, scalability, and performance in an SAP Sysplex data sharing environment.
DB2 Query Monitor for z/OS (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.
Troubleshooting and support
Code fixes
APARs (Type: Web page) 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.
Getting fixes (Type: Information center) This topic contains information that will help you find and get PTFs to resolve problems with DB2 for z/OS.
Technical information to help solve problems
DB2 9 for z/OS Data Sharing Recovery/Restart Workshop (Type: Classroom course) Learn to plan and implement recovery procedures for a DB2 9 for z/OS data sharing installation. This hands-on course is designed to help you in planning, setting up, and implementing recovery procedures for local recovery and disaster recovery for a DB2 for z/OS data sharing environment. Recovery processes for DB2 disaster recovery and coupling facility recovery processes are covered.
DB2 9 for z/OS Advanced System and Disaster Recovery Workshop (Type: Classroom course) This advanced course is designed for anyone responsible for DB2 system or database recovery. You are provided instruction in the design and implementation of recovery and restart procedures for DB2, maximizing availability.
Subscribing to Support updates (Type: Information center) To stay informed of important information about the IBM products that you use, subscribe to updates. By subscribing to receive updates, you can receive important technical information and updates for specific Support tools and resources.
Searching for messages and codes (Type: Information center) This information provides details about how you can find information about DB2 messages and codes by using the information center.
Recovering from different DB2 for z/OS problems (Type: Information center) This information provides details about how you can troubleshoot and recover from many problems on your own by using recovery procedures.
How to order DB2 Diagnosis Guide and Reference (Type: Technote) This technote provides information about how to order DB2 Diagnosis Guide and Reference. This book provides information for diagnosing DB2 problems.
Links to current FAQ technotes (Type: Web page) This web page displays a list of the most current IBM Software Support technotes that answer frequently asked questions and provide useful information.
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
IBM developerWorks DB2 for z/OS forum (Type: Forum) This forum mirrors the ibm.software.db2.mvs newsgroup and is a venue for the DB2 for z/OS community to discuss and share solutions for technology-related and product-related issues.
International DB2 Users Group (IDUG) (Type: User group) This user 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.
General IBM Software Support information
Troubleshooting overview (Type: Information center) This information provides details 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) This manual provides guidelines and reference materials that you might need when you require help from IBM Software Support.
Acronyms, abbreviations, and terms (Type: Manual) This glossary in the Software Support Handbook lists acronyms and terms that are used frequently by IBM Software Support when solving customer problems.
Reference
DB2 SQL (Type: Information center) This information provides detailed reference information about DB2 language elements, functions, queries, SQL statements, SQL control statements, and catalog tables. This is the same information that is in 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 DB2 family of products.
DB2 commands (Type: Information center) This information provides detailed reference information about the DB2 commands and the commands of related products with which DB2 operates. This is the same information that is in DB2 Command Reference.
DB2 utilities (Type: Information center) This information provides details about the syntax and usage of the DB2 online and stand-alone utilities. This is the same information that is in DB2 Utility Guide and Reference.
Information Management software lifecycle dates (Type: Other) The Information Management software lifecycle page shows the dates that marketing and support services are available for each version of DB2 for z/OS, along with the end-of-service (EOS) dates.
Parallel Sysplex: Coupling Facility Levels (Type: Other) This website 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.
Community resources
This section may provide links or references to non-IBM websites and resources. IBM makes no representations, warranties, or other commitments whatsoever about any non-IBM websites or third-party resources (including any Lenovo website) that may be referenced, accessible from, or linked to any IBM site. A link to a non-IBM website does not mean that IBM endorses the content or use of such website 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 website, 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 website. 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 Communities (Type: Website) This website provides convenient links to a variety of user groups and forums, where the Information Management user community can connect, discuss, and learn from each others' experiences using IBM Information Management software solutions.
International DB2 Users Group (IDUG) (Type: User group) This user 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: User group) This forum enables you to exchange sample programs, SQL statements, utility jobs, and more with your colleagues.
DB2 for z/OS Best Practices (Type: Website) Are you looking for recommendations and tips on how to best use DB2 for z/OS to meet your business needs? This website provides best practices recommendations on a variety of subjects from some of your favorite DB2 experts based on field experience. You can download and watch presentations, listen to podcasts and previously recorded webcasts, and read articles.
DB2utor (Type: Blog) This blog provides hints, tips, and best practices for using DB2 for z/OS and related products.
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 DB2 blog (Type: Blog) In this blog, Robert Catterall, an IBM DB2 specialist, 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.
DB2usa: Blog about DB2 for z/OS (Type: Blog) Visit this blog site each week to find the latest technical information that is available on the web about DB2 for z/OS.
The World of DB2 for z/OS (Type: Other) This networking site provides a variety of resources about DB2, including videos, blogs, podcasts, and discussions.
IBMDB2 Twitter (Type: Other) DB2 for z/OS is on Twitter! Watch our posts to find the latest information about what's happening with DB2 for z/OS.
DB2 for z/OS - Stay In Touch! (Type: Other) Be a part of the DB2 for z/OS community on LinkedIn. This group communicates to our customers and business partners what is happening in the world of DB2 for z/OS.
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.
Send feedback
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.
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.