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 of DB2 10 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.
DB2 for z/OS New Functions and Features in V10 (Type: Classroom course) Learn about the new features and enhancements of DB2 10 for z/OS, including the technical detail of the functional enhancements of this significant new version of DB2 for z/OS. Get a better understanding of several of the new functions by performing hands-on machine exercises.
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 10 for z/OS (Type: Product description) This announcement letter summarizes the key enhancements that are available in DB2 10 for z/OS.
Program Directories for DB2 10 for z/OS (Type: Manual) This web page links to Program Directories for DB2 10 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 10 for z/OS Technical Overview (Type: IBM Redbooks) This IBM Redbooks publication introduces the enhancements made available with DB2 10 for z/OS. The contents help you understand the new functions and performance enhancements, start planning for exploiting the key new capabilities, and justify the investment in installing or migrating to DB2 10.
DB2 10 for z/OS What's New? (Type: Information center) This information provides an executive overview of the new functions in DB2 10 for z/OS. New functions are categorized according to user benefits, such as information on demand, availability, and performance.
Planning for DB2 10 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 10 for z/OS, helping you plan for this release.
Premigration checklist for migration to DB2 10 from Version 9.1 (Type: Information center) This checklist contains a list of tasks to complete in preparation for migrating from DB2 Version 9.1 to DB2 10.
Premigration checklist for migration to DB2 10 from Version 8 (Type: Information center) This checklist contains a list of tasks to complete in preparation for migrating from DB2 Version 8 to DB2 10.
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.
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 planning for DB2 10 for z/OS, 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.
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.
Installing
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 Directories for DB2 10 for z/OS (Type: Manual) This web page links to Program Directories for DB2 10 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 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 z/OS, Version 10.
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 10 member.
Installing DB2 ODBC (Type: Information center) This information explains how to edit and run SMP/E jobs to install DB2 ODBC.
Migrating
DB2 for z/OS New Functions and Features in V10 (Type: Classroom course) Learn about the new features and enhancements of DB2 10 for z/OS, including the technical detail of the functional enhancements of this significant new version of DB2 for z/OS. Get a better understanding of several of the new functions by performing hands-on machine exercises.
Checklist for migration to DB2 10 from Version 9.1 (Type: Information center) This checklist contains a list of tasks to complete for migration from DB2 Version 9.1 to DB2 10.
Checklist for migration to DB2 10 from Version 8 (Type: Information center) This checklist contains a list of tasks to complete for migration from DB2 Version 8 to DB2 10.
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 Directories for DB2 10 for z/OS (Type: Manual) This web page links to Program Directories for DB2 10 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.
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) Although this IBM Redbooks publication was written for DB2 9 for z/OS, this information is helpful as you design, install, manage, and tune stored procedures with DB2 10 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 10 for z/OS.
Directory of subsystem parameters and application default values (Type: Information center) This information describes the DB2 subsystem parameters in DB2 10 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 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 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 10 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.
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.
Managing DB2 10 for z/OS with DB2 Administration Tool for z/OS V10 (Type: IBM Redbooks) This IBM Redbooks publication highlights the data administration enhancements introduced by DB2 Administration Tool Version 10 showing scenarios of their use with the new functions provided by DB2 10 for z/OS.
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 9 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 their experiences in migrating our DB2 V8 SAP data sharing environment to DB2 9 for z/OS with a minimal amount of outage. Although written for DB2 9 for z/OS, this information might be useful to customers on DB2 10 for z/OS.
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. Although written for DB2 9 for z/OS, this information might be useful to customers on DB2 10 for z/OS.
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
DB2 10 for z/OS Database Administration Certification Crammer Course (Type: Classroom course) This is a high-level certification preparation course intended to help you take the DB2 9 Family Fundamentals exam (730) and the DB2 10 for z/OS Database Administration exam (612). By passing these exams, you receive certification as an IBM Certified Solutions Expert - DB2 10 for z/OS Database Administration.
DB2 10 for z/OS System Administrator Crammer Class for Exam #617 (Type: Classroom course) This one-day crammer class reviews the six certification testing topics relating to the following exams: IBM Certified System Administrator - DB2 10 for z/OS Certification Exam 000-617.
DB2 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
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) Although this IBM Redbooks publication was written for DB2 9 for z/OS, this information is helpful as you design, install, manage, and tune stored procedures with DB2 10 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. Although this publication was written for DB2 9 for z/OS, the information might be useful for customers on DB2 10 for z/OS.
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.
Extremely pureXML in DB2 10 for z/OS (Type: IBM Redbooks) This IBM Redbooks publication documents the steps for the implementation of a simple but meaningful XML application scenario.
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.
Certification for DB2 developers
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) Although this IBM Redbooks publication was written for DB2 9 for z/OS, this information is helpful as you design, install, manage, and tune stored procedures with DB2 10 for z/OS.
Data Studio and DB2 for z/OS Stored Procedures (Type: IBM Redbooks) This draft IBM Redpaper publication is devoted to tools that can be used for accelerating the development and debugging of DB2 stored procedures, in particular to the stored procedure support that is provided by IBM Data Studio.
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 10.
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 10 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 and debugging an application program on DB2 for z/OS (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
Security Functions of IBM DB2 10 for z/OS (Type: IBM Redbooks) This IBM Redbooks publication provides a detailed description of DB2 10 security functions from the implementation and usage point of view. This publication is intended to be used by database, audit, and security administrators.
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.
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. Although written for DB2 9 for z/OS, this information might be useful to customers on DB2 10 for z/OS.
Managing performance, Version 10 (Type: Information center) This information will help you monitor the performance of your DB2 10 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.
The value of IBM DB2 for z/OS hash access for OLTP transactions (Type: White paper; Format: PDF) This white paper provides an overview of how you can use the new hash organization in DB2 10 for z/OS to improve response times and reduce the cost of queries that retrieve single rows from a table containing unique keys. This information helps you to decide whether your environment can benefit from this new capability.
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 10, you can use 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.
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.
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
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 web site 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.
Original publication date
2009/10/11
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.