Administrator information roadmap

This roadmap outlines the information resources that are available for DB2® for z/OS® administrators. These resources provide information about various subject areas, such as installation, administration, and troubleshooting for DB2 for z/OS.

Tip: This roadmap identifies information resources that are most appropriate for experienced DB2 for z/OS administrators. If you are just getting started with DB2 for z/OS, see New-user information roadmap.

If you are an experienced application developer, see the programming resources in Application Developer information roadmap

Product overview

IBM® DB2 for z/OS: The Database for Critical Transactions and Analytics: This web page describes the features and benefits of DB2 for z/OS.
DB2 for z/OS Product Documentation: This technote provides links to the DB2 for z/OS product information in PDF format, along with links to DB2 for z/OS and related Program Directories and other valuable information resources.
Mainframe success stories: Read what our clients are saying about the power and flexibility of IBM Z.

Planning

General planning

Release announcement for DB2 10 for z/OS: This announcement letter summarizes the key enhancements that are available in this release of DB2 for z/OS.
DB2 10 for z/OS Technical Overview: This IBM Redbooks® publication introduces the enhancements made available DB2 10. 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.

Planning for specific functions

Preparing for DB2 data sharing: 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: This web page contains basic information about the DB2 Utilities Suite for z/OS Utilities Suite, including the key features and system requirements.
DB2 Utilities best practices: This webcast, which was developed as part of the DB2 for z/OS Best Practices series on developerWorks®, reviews recommendations for the use of various DB2 for z/OS utilities.

Installing and migrating

Preparing your system to install or migrate DB2: 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 for z/OS: This web page links to Program Directories for DB2 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.

Configuring

Configuring TLS/SSL for Secure Client-Server Communications: This IBM Redpaper provides information about how to set up and configure DB2 for z/OS with Transport Layer Security (TLS), the modern version of Secure Sockets Layer (SSL).
System z® Parallel Sysplex® Best Practices: This IBM Redbooks publication provides information about the best way to design, implement, and manage an IBM Z Parallel Sysplex to deliver the levels of performance and availability that are required by your organization.

Administering

Certifications for DB2 administrators

DB2 for z/OS Database Administration Core training path: Use this training path to see the courses that you need to take for DB2 for z/OS database administration.
IBM Professional Certification Program: This web page provides you with information about DB2 certification. This information applies to DB2 products on all of the different operating systems, including z/OS.

DB2 utilities

DB2 for z/OS Utilities Development Blog: A community hints and tips blog for DB2 utilities.

Administration with DB2 Tools

DB2 Tools for z/OS: This website provides you with information about the various tools that are available to simplify management, maximize performance, and lower operating costs.
DB2 Administration Tool for z/OS: This web page provides general information and resources for the DB2 Administration Tool for z/OS, which provides a comprehensive set of functions that help DB2 personnel manage their DB2 environments efficiently and effectively.
Managing DB2 10 for z/OS Using the IBM DB2 Administration Tool for z/OS Version 10: This IBM Redbooks publication highlights the data administration enhancements introduced by DB2 Administration Tool for z/OS Version 10, showing scenarios of their use with the new functions provided by DB2 10. Although written in particular for DB2 10, this publication is also helpful as you administer later releases of DB2 for z/OS.
DB2 Administration Solution Pack for z/OS: Streamlining DB2 for z/OS Database Administration: This IBM Redbooks publication discusses how the products in the DB2 Administration Solution Pack for z/OS can help database administrators more efficiently complete tasks that are associated with object management, change management, application management, and configuration management.
Managing DB2 for z/OS Utilities with DB2 Tools Solution Packs: This IBM Redbooks publication highlights productivity and performance gains for database administrators when using the IBM DB2 Utilities Solution Pack and the IBM DB2 Fast Copy Solution Pack. This publication explains the functions of the tools in these solution packs, and provides real-life scenarios and best practices for adopting utilities.

Security

DB2 security: An interactive model: This interactive model provides an overview of key DB2 security components and processes. Hover over the objects to explore and learn more about the basics of DB2 security in the z/OS environment.
Security Functions of IBM DB2 10 for z/OS: This IBM Redbooks publication highlights added functions in the areas of security, regulatory compliance, and audit capability. Although written for DB2 10, this information is helpful when managing security in later releases of DB2 for z/OS.

DB2 stored procedures

Implementing DB2 stored procedures: A stored procedure is executable code that can be called by other programs. You might choose to use stored procedures for code that is used repeatedly. This information describes some benefits of using stored procedures and how to create and call stored procedures.
Data Studio and DB2 for z/OS Stored Procedures: This IBM Redpaper publication discusses how you can use tools, in particular IBM Data Studio, to accelerate the process of developing and debugging stored procedures. This paper is a major update to Part 6, "Cool tools for an easier life," of the IBM Redbooks publication DB2 9 for z/OS Stored Procedures: Through the CALL and Beyond.
DB2 for z/OS Stored Procedures: Through the CALL and Beyond (IBM Redbooks): Although this IBM Redbooks publication was written for DB2 9, this information is also helpful as you design, install, manage, and tune stored procedures with later releases of DB2 for z/OS.

Scenarios

Case studies: BMW Group develops eco-friendly innovation for smart drivers with IBM: This case study shares the success that BMW Group had migrating to and using DB2 11 as part of the Early Support Program (ESP).
Case studies: JN Data gets the early-adopter advantage for its growing business: This case study shares the success that JN Data has had as an early-adopter of DB2 11.

Samples

DB2 programming samples

You can find application programming samples that you can use to get started creating applications that access data in DB2 for z/OS. The collection of samples come from various sources, including:

Content that is adapted from existing IBM developerWorks and other articles from around the web.
Samples that were previously delivered throughout in the existing DB2 programming information.
Examples that were previously supplied with DB2 in the DSN1010.SDSNSAMP library, but only recently included in their entirety in the documentation.

DB2 for z/OS developerWorks Exchange

This forum enables you to exchange sample programs, SQL statements, utility jobs, and more with your colleagues.

IDUG Codeplace

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.

Managing performance

General information

DB2 10 for z/OS Performance Topics: This IBM Redbooks publication provides an overview of the performance improvements in DB2 10, which can reduce CPU usage by five to 20 percent compared to previous releases. This book discusses possible impacts when moving from version to version and includes performance measurements that were made in the laboratory.
IBM DB2 11 for z/OS: Buffer Pool Monitoring and Tuning: This IBM Redpaper publication provides valuable information about monitoring and tuning buffer pools. Although written specifically for DB2 11, this information can also be applied to DB2 10.
The value of IBM DB2 for z/OS hash access for OLTP transactions: This white paper provides an overview of how you can use the new hash organization in DB2 10 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.

Using performance tools

Enabling DB2 to work with IBM DB2 Analytics Accelerator for z/OS: This information discusses how you can use IBM DB2 Analytics Accelerator for z/OS, or an equivalent accelerator, to run queries on behalf of DB2. For certain types of queries, such as business intelligence (BI) queries, processing on an accelerator server can be faster than processing on DB2.
Reliability and Performance with IBM DB2 Analytics Accelerator for z/OS Version 4.1: This IBM Redbooks publication helps technical decision makers understand the benefits of IBM DB2 Analytics Accelerator for z/OS, Version 4.1 when used with DB2 11.
Hybrid Analytics Solution using IBM DB2 Analytics Accelerator for z/OS V3.1: This IBM Redbooks publication helps technical decision makers understand the benefits and major new functions of IBM DB2 Analytics Accelerator for z/OS, Version 3.1.
Optimizing DB2 Queries with IBM DB2 Analytics Accelerator for z/OS: This IBM Redbooks publication evaluates the potential benefits of using IBM DB2 Analytics Accelerator for z/OS, a high-performance accelerator appliance, to optimize the processing of certain DB2 queries. This publication defines a business analytics scenario, describes the installation and integration steps with the DB2 environment, and evaluates performance improvements.
DB2 Query Monitor for z/OS information: This information supports DB2 Query Monitor, which gives you the ability to efficiently customize and tune your SQL workload and DB2 objects.
Optim™ Query Tuner for DB2 for z/OS: Optim Query Tuner for DB2 for z/OS helps developers create efficient queries and build tuning skills. Optim Query Tuner for DB2 for z/OS 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.

Troubleshooting and support

Code fixes

IBM Support Portal: DB2 for z/OS: Use the IBM Support Portal for DB2 for z/OS to search for both PTFs and APARs. This website also provides links to common troubleshooting topics.
DB2 for z/OS keywords for searching APAR text: This document contains keywords that you can use to optimize your results when searching APAR text.

General IBM Software Support information

Introduction to troubleshooting problems in DB2 for z/OS: If you are new to DB2 for z/OS, you should learn about the tools and techniques that are available to help you troubleshoot and resolve problems.
How to obtain a copy of DB2 Diagnosis Guide and Reference: This technote provides information about how to obtain a copy of DB2 Diagnosis Guide and Reference. This book provides information for diagnosing DB2 problems.
Software Support Handbook: This manual provides guidelines and reference materials that you might need when you require help from IBM Software Support.
APAR Closing Codes and Acronyms: This section of the Software Support Handbook provides lists of acronyms and terms that are used frequently by IBM Software Support when solving customer problems.

Reference

Information Management software lifecycle dates: 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.

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.

Forums and organizations

IBM Information Management Communities: 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): 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 i, DB2 Express®, DB2 Everywhere, and DB2 Data Warehouse Edition.
SHARE: This community provides Information Technology professionals with access to continuous education and training, and valuable professional networking, helping you to achieve your business goals.

Blogs

Getting the most out of DB2 12: 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 IBM Z, including tips on migration, performance, and maintenance.
DB2utor: This blog by Troy Coleman provides hints, tips, and best practices for using DB2 for z/OS and related products.
Robert's DB2 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: 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.
DB2 for z/OS Utilities Development Blog: A community hints and tips blog for DB2 utilities.
DB2usa: Blog about DB2 for z/OS: Visit this blog site each week to find the latest technical information that is available on the web about DB2 for z/OS.

Social media

The World of DB2 for z/OS: This networking site provides a variety of resources about DB2, including videos, blogs, podcasts, and discussions.
@IBMDB2 Twitter: 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!: 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: 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.