Recommended reading lists: DB2 for z/OS recommended reading list

Learn about IBM® DB2® for z/OS® using this list of essential reading material, compiled with the database administrator community and other database technical specialists in mind. The list below will help you learn about DB2 for z/OS in general as well as highlighting the best ways to port your applications to the z/OS platform and your database to DB2 for z/OS.

Share:

Introduction

This list of recommended reading connects you to the learning resources available for DB2 for z/OS. The DB2 Information Center is also a good source of information. Many of the items listed below are published as articles on IBM developerWorks® or as IBM Redbooks®. This list is intended for customers, consultants, and other technical specialists who simply want to learn more about DB2 for z/OS topics such as installation, migration, database administration, monitoring database performance, database tuning, high availability, database porting, and problem determination. The topics are organized under the following headings:


Product overview

DB2 9 for z/OS Technical Overview
http://www.redbooks.ibm.com/abstracts/sg247330.html/

  • Type: IBM Redbooks
  • This IBM Redbooks publication introduces the enhancements made available with DB2 9 for z/OS. It helps you understand the new functions, justify investment for migrating, and plan for exploiting the key new capabilities.

The Business Value of DB2 UDB for z/OS
http://www.redbooks.ibm.com/abstracts/sg246763.html/

  • Type: IBM Redbooks
  • This Redbooks publication helps you to position DB2 for z/OS as a springboard for the future. It examines how DB2 database servers integrate with, and enable the sharing of information across, multiple platforms. It looks at how the System z® server manages the explosion of data with reliability and security. Plus it explores how DB2 autonomic computing functions reduce skills and staffing requirements to minimize cost outlays and reduce risk.

DB2 UDB for z/OS Version 8: Everything You Ever Wanted to Know, ... and More
http://publib-b.boulder.ibm.com/abstracts/sg246079.html/

  • Type: IBM Redbooks
  • This book explains the capabilities of DB2 Version 8. This information helps you to evaluate the applicability of Version 8 to your environment, as well as to plan for the installation of DB2 V8 or the migration from DB2 V7.

The Big Picture: IBM DB2 Information Management Software and DB2 Universal Database
http://www.ibm.com/developerworks/db2/library/techarticle/0301jones/0301jones.html/

  • Type: Article
  • This article provides a brief history of the DB2 family of products, a technology overview, and a discussion of the role of DB2 software in On Demand business.

Introduction to the New Mainframe: z/OS Basics
http://www.redbooks.ibm.com/abstracts/sg246366.html

  • Type: IBM Redbooks
  • This Redbooks publication provides the background knowledge and skills necessary to begin using the basic facilities of a mainframe computer. You will learn the basic concepts of the mainframe, fundamentals of z/OS, an understanding of mainframe workloads and the major middleware applications in use on mainframes today.

Planning

DB2 for z/OS: Data Sharing in a Nutshell
http:http://www.redbooks.ibm.com/abstracts/sg247322.html

  • Type: IBM Redbooks
  • This Redbooks publication facilitates your journey towards data sharing by providing a cookbook approach to the main tasks of enabling data sharing and workload balancing.

DB2 for z/OS and WebSphere®: The Perfect Couple
http://www.redbooks.ibm.com/abstracts/sg246319.html/

  • Type: IBM Redbooks
  • This Redbooks publication describes installation, configuration, and use of the IBM DB2 Universal Driver for SQLJ and JDBC in a DB2 environment (DB2 for z/OS Version 8 or DB2 for z/OS and OS/390 Version), with IBM WebSphere Application Server for z/OS for z/OS Version 5.02.

Installation

The Good, the Bad, and the Really Ugly: DSNZPARM - Willie Favero (update)
http://www-1.ibm.com/support/docview.wss?rs=64&uid=swg27003698

  • Type: Presentation
  • This presentation examines the realm of DSNZPARMs: hidden, opaque, and visible.

Installing, migrating, and updating system parameters
http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db29.doc.inst/db2z_tailordb2jobswclist.htm

  • Type: Information Center
  • Tailoring DB2 jobs to your environment

IBM DB2 Driver for JDBC and SQLJ installation
http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db29.doc.java/db2z_jccinstall.htm

  • Type: Information Center
  • These procedures describe what you need to do to install the DB2 Driver for JDBC and SQLJ.

Installing DB2 ODBC
http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db29.doc.odbc/db2z_clinst.htm

  • Type: Information Center
  • This topic explains how to edit and run SMP/E jobs to install DB2 ODBC.

Configuration

Connectivity Cheat Sheet for DB2 Universal Database Part 2 - DB2 for z/OS
http://www.ibm.com/developerworks/db2/library/techarticle/0310chong/0310chong.html

  • Type: Article
  • This article gives you details for connecting DB2 UDB for z/OS clients to DB2 UDB for z/OS servers or to servers on other operating systems. The following three connectivity scenarios are included:
    • From a DB2 UDB for z/OS client to a DB2 UDB for Linux, UNIX, and Windows server
    • From a DB2 UDB for z/OS client to a DB2 UDB for iSeries server
    • From a DB2 UDB for z/OS client to another DB2 UDB for z/OS server

Distributed Functions of DB2 for z/OS and OS/390
http://www.redbooks.ibm.com/abstracts/sg246952.html/

  • Type: IBM Redbooks
  • Level: Introductory
  • Date: September 2006
  • 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.

Administration

LOBs with DB2 for z/OS: Stronger and Faster
http://www.redbooks.ibm.com/abstracts/sg247270.html/

  • Type: IBM Redbooks
  • In this IBM Redbooks publication, we provide a totally revised description of the DB2 functions for LOB support as well as useful information about how to design and implement LOBs. We also offer examples of their use, programming considerations, and the enhanced processes used for their administration and maintenance. We also detail how SAP solutions use LOBs.

Large Objects with DB2 for z/OS and OS/390
http://www.redbooks.ibm.com/abstracts/SG246571.html

  • Type: IBM Redbooks
  • This IBM Redbooks publication provides information about how to design and implement large objects (LOBs), examples of their use, programming considerations, and the processes that are necessary for administration and maintenance.

Debug SQL stored procedures with IBM Database Add-Ins for Visual Studio 2005, Part 1: Start debugging your SQL stored procedures
http://www.ibm.com/developerworks/db2/library/techarticle/dm-0707johnson/

  • Type: Article
  • Learn how to use IBM Database Add-Ins for Visual Studio 2005 to debug stored procedures written in SQL. Discover how much has changed in SQL debugging support, when compared to previous versions of the DB2 Tools for Visual Studio. The revisions greatly simplify the process of building, debugging, revising, and rebuilding SQL stored procedures.

Creating and working with DB2 for z/OS stored procedures, Part 2: Alter DB2 for z/OS V9.1 stored procedures using IBM Database Add-ins for Visual Studio 2005
http://www.ibm.com/developerworks/db2/library/techarticle/dm-0703jayakumar2/

  • Type: Article
  • Learn how to alter IBM® DB2® for z/OS® stored procedures using non-destructive alteration techniques now available in the Procedure Designer, part of the IBM Database Add-ins for Visual Studio 2005. You can use the Procedure Designer to alter both external and native SQL procedures, as well as creating and managing several versions of native procedures, giving you an easy way to create, update, and manage your DB2 for z/OS stored procedures.

Create and work with DB2 for z/OS stored procedures, Part 3: Create package variations and perform deployment on procedures on DB2 for z/OS V9.1 using IBM Database Add-ins for Visual Studio 2005
http://www.ibm.com/developerworks/db2/library/techarticle/dm-0705jayakumar/

  • Type: Article
  • Using the IBM Database Add-ins for Visual Studio 2005, you can now avoid the manual steps that have previously been required to deploy a stored procedure on a second target server. In addition, you can also easily view, create, and drop packages for stored procedures. Each package allows you to run SQL statements in stored procedures with different behaviors, and allows you to save these options for future use.

Disaster Recovery with DB2 UDB for z/OS
http://www.redbooks.ibm.com/redpieces/abstracts/sg246370.html/

  • Type: IBM Redbooks
  • This IBM Redbooks publication first introduces the main concepts, and the primary components for possible solutions. It then describes the most common solutions, and implements several recovery scenarios. All tests were implemented with DB2 UDB for z/OS Version 8. It also includes criteria for choosing a solution, and recommendations based on recovery best practices.

Administration for data sharing environments

Planning for DB2 data sharing
http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db29.doc.dshare/db2z_planningdatasharing.htm

  • Type: Information Center
  • These topics are contained in DB2 Version 9.1 for z/OS Data Sharing: Planning and Administration (SC18-9845) which provide information about planning for DB2 data sharing, establishing naming conventions, estimating storage requirements, and so on.

Communicating with data sharing groups
http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db29.doc.dshare/db2z_communicatedsgroups.htm

  • Type: Information Center
  • These topics explain how to use a data sharing group as a powerful server in your client/server environment.

DB2 9 for z/OS Data Sharing: Distributed Load Balancing and Fault Tolerant Configuration
http://www.redbooks.ibm.com/abstracts/redp4449.html

  • Type: IBM Redpaper
  • This IBM Redpaper provides information about exploiting client load balancing and fail over capabilities across a DB2® data sharing group or a subset of the group members. The information provided will help network specialists and data base administrators in appropriately configuring data sharing groups as TCP/IP servers.

Administration with DB2 Utilities

Moving Data Across the DB2 Family
http://www.redbooks.ibm.com/abstracts/sg246905.html

  • Type: IBM Redbooks
  • This Redbooks publication provides an overview of what is currently available within the DB2 family of products (specifically DB2 for z/OS, and DB2 for UNIX and Windows). This book explains functions, tools, and utilities to satisfy the need for moving data. It focuses on High Performance Unload and Cross Loader.

Data Recovery Now and Future Using IBM's Recovery Tools
http://www.ibm.com/support/docview.wss?rs=64&uid=swg27004944

  • Type: Presentation
  • This presentation reviews all types of data recovery, IBM's current recovery offerings, and IBM's recovery tooling philosophy, including autonomic functions and high priority requirements that we are working on in the laboratory today.

DB2 V8 System Point-in-Time Recovery
http://www.ibm.com/support/docview.wss?rs=64&uid=swg27005758

  • Type: IDUG Presentation
  • This presentation describes the steps that are necessary to perform system-level point-in-time recovery by using the new DB2 for z/OS Version 8 utilities BACKUP SYSTEM and RESTORE SYSTEM.

Administration solution for DB2 z/OS
http://www.redbooks.ibm.com/abstracts/sg246685.html/

  • Type:IBM Redbooks
  • The purpose of this Redbooks publication is twofold: Help you understand the mapping of functions between the Candle DB2 DB/Tools products and DB2 Tools and facilitate the migration process to the relevant products Point out the major advantages available with the new suite of DB2 administration tools when accessing DB2 UDB for z/OS Version 8.

Programs vs. Utilities
http://www.dbmag.intelligententerprise.com/db_area/archives/2003/q2/programmers.shtml

  • Type: Article
  • This article from DB2 Magazine lists the ways that programmers can use DB2 utilities to lighten the programming load.

Programs vs. Utilities Revisited flow
http://www.dbmag.intelligententerprise.com/showArticle.jhtml?articleID=23903566

  • Type: Article
  • This article in DB2 Magazine explains how programmers can take advantage of the new features of the Version 8 utilities.

Certification for DB2 administrators

DB2 version 9 certification: Everything you need to know
http://www.ibm.com/developerworks/db2/library/techarticle/dm-0401fosdick/index.html

  • Type: Article
  • This article describes everything that you need to know about certification, including whether you should get certified, how you can get certified, and how you can prepare and study for the certification exam.

Professional Certification Preparation Documents
http://www.ibm.com/software/data/education/certprep.html#cm

  • Type: Article
  • These preparation documents help you prepare for DB2 Information Management certification exams. Each document covers role descriptions, requirements, objectives, and preparation suggestions.

IBM Certified Database Administrator - DB2 9 DBA for z/OS
http://www.ibm.com/certify/certs/08002303.shtml

  • Type: Website
  • This retail book prepares you for the DB2 UDB V8.1 Exam 700. It includes information about exam objectives, a review of the DB2 family of tools and products, and fundamental database concepts such as SQL and data consistency.

DB2 9 Fundamentals Certification Study Guide

  • Type: Book
  • Roger Sanders. This comprehensive study guide steps you through all of the topics that are covered on the test (EXAM 730): planning; database security; database objects; SQL, XQuery, and XML; tables, views, and indexes; database concurrency; and much more. Each chapter contains an extensive set of practice questions along with carefully explained answers.

Development

General DB2 database programming

Developing DB2 UDB Database Projects in Visual Studio .NET
http://www.ibm.com/developerworks/edu/dm-dw-dm-0305alazzawe-i.html

  • Type: Tutorial
  • This tutorial demonstrates the use of the DB2 database project template of the IBM DB2 Development Add-In to create tables, indexes, views, triggers, and stored procedures for a DB2 for z/OS database environment. To demonstrate the ease of building such server objects, this tutorial walks you through the steps to build a sample application.

DB2 for z/OS DB2 database design: Principles of peak performance
http://www.ibm.com/developerworks/db2/library/techarticle/dm-0408whitlark/index.html

  • Type: Article
  • This article provides some general guidelines and recommendations for achieving better DB2 performance in z/OS environments.

DB2 for z/OS Application Programming Topics
http://publib-b.boulder.ibm.com/Redbooks.nsf/RedbookAbstracts/sg246300.html

  • Type: IBM Redbooks
  • This Redbooks publication describes some major enhancements that affect application programming when accessing DB2 data.

DB2 for z/OS DB2 Universal Database concurrency: Maximize access to relational data
http://www.ibm.com/developerworks/db2/library/techarticle/dm-0406whitlark/index.html

  • Type: Article
  • This article provides some general guidelines and recommendations for improving concurrency in DB2 for z/OS environments.

DB2 Development Add-In Technical Preview
http://www.ibm.com/developerworks/db2/library/techarticle/dm-0804shelton/index.html

  • Type: Article
  • The article introduces you to the features and rich functionality that have since been delivered in DB2 Development Add-in for Visual Studio .NET.

Comparing XML functionality in DB2 9 to DB2 V8
http://www.ibm.com/developerworks/db2/library/techarticle/0311alazzawe/0311alazzawe.html/

  • Type: Article
  • Understand the new XML features introduced in DB2 9 and their impact on migration of existing XML applications.

Connectivity and distributed database development

DB2 Connect
http://www.ibm.com/software/data/db2/db2connect/

  • Type: Website
  • This Web page contains information about DB2 Connect, a tool that makes your company's host data directly available to your personal computer and LAN-based workstations.

Connectivity Cheat Sheet for DB2 Universal Database Part 2 - DB2 for z/OS
http://www.ibm.com/developerworks/db2/library/techarticle/0310chong/0310chong.html

  • Type: Article
  • This article gives you details for connecting DB2 UDB for z/OS clients to DB2 UDB for z/OS servers or to servers on other operating systems. The following three connectivity scenarios are included:
    • From a DB2 UDB for z/OS client to a DB2 UDB for Linux, UNIX, and Windows server
    • From a DB2 UDB for z/OS client to a DB2 UDB for iSeries server
    • From a DB2 UDB for z/OS client to another DB2 UDB for z/OS server

Connectivity cheat sheet for Application Developers (Part 4)
http://www.ibm.com/developerworks/db2/library/techarticle/dm-0401chong/index.html

  • Type: Article
  • This article discusses connectivity scenarios that involve DB2 UDB for Linux, UNIX, and Windows Version 8, DB2 UDB for iSeries 5.2, and DB2 UDB for z/OS Version 8. The focus of this article is on workstation application development connectivity using the C and Java languages.

Distributed Functions of DB2 for z/OS and OS/390
http://www.redbooks.ibm.com/abstracts/sg246952.html/

  • Type: IBM Redbooks
  • This 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
http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db2.doc.drda/bjnuspsh.htm

  • Type: Information Center
  • These topics provide detailed information about using Distributed Data Management (DDM) commands to track DRDA access to DB2 and to distribute requests among members of a data sharing group. This information is from the Reference for Remote DRDA Requesters and Servers.

Programming for ODBC
http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db2.doc.odbc/bjnespsh.htm

  • Type: Information Center
  • These topics provide guidance for DB2 ODBC application programming tasks. These topics also provide reference information about each DB2 ODBC function. This information is from the ODBC Guide and Reference.

Porting data from another DBMS to DB2 (enablement)

Automate the Migration to DB2 using the Migration Tool Kit
http://www.ibm.com/developerworks/db2/library/techarticle/0209jarzebowicz/0209jarzebowicz.html

  • Type: Article
  • The no-charge IBM® Migration Toolkit (MTK) can simplify and improve your migration to DB2 Database for Linux, UNIX, and Windows, DB2 on iSeries, DB2 on z/OS, and Informix® Dynamic Server (IDS). This migration utility provides a wizard, an easy-to-use graphical interface with only five steps, as well as a command line interface to help you quickly convert existing Oracle, Sybase Adaptive Server Enterprise (ASE), Sybase SQL Anywhere (ASA), and Microsoft® SQL Server database objects to DB2 Database for Linux, UNIX, and Windows, DB2 on iSeries, DB2 on z/OS, and IDS.

Microsoft SQL Server to IBM DB2 UDB Conversion Guide
http://www.redbooks.ibm.com/abstracts/sg246672.html/

  • Type: IBM Redbooks
  • This IBM Redbooks publication is an informative guide that describes how to convert the database system and applications from Microsoft SQL Server to DB2 UDB Version 8.2. It presents the best practices in conversion strategy and planning, an architecture overview of the two relational database systems, migration tools, and practical conversion examples. It is intended for technical staff involved in a SQL Server to DB2 UDB conversion project.

WebSphere Classic Federation Server for z/OS
http://www.ibm.com/software/data/infosphere/classic-federation-server-z/

  • Type: Product description
  • The project code named pureQuery gives database application developers an easy, GUI-based means to significantly increase productivity in both the design and implementation phases. This is accomplished through user-initiated automatic transformation of relational data into Java objects for access and manipulation of data. In turn, these objects can be seamlessly utilized in a natural object-oriented (OO) programming paradigm to write the business logic and the underlying code. pureQuery's functionality in effect eliminates traditional JDBC programming by integrating the query language with Java itself.

WebSphere Classic Replication Server for z/OS
http://www.ibm.com/software/data/infosphere/classic-replication-server-z/

  • Type: Product description
  • This Web page explains WebSphere Classic Replication Server for z/OS, which provides fast and flexible replication that helps administrators distribute, consolidate, and synchronize information across complex, multi-platform, multi-vendor IT environments.

Development of DB2 stored procedures

DB2 9 for z/OS Stored Procedures: Through the Call and Beyond
http://www.redbooks.ibm.com/abstracts/sg247604.html/

  • Type: IBM Redbooks
  • This Redbooks publication helps you design, install, manage, and tune stored procedures with DB2 9 for z/OS.

Ask the Experts: Peggy Abelite on DB2 for z/OS and OS/390 Stored Procedures
http://www.ibm.com/developerworks/db2/library/techarticle/0303abelite/0303abelite.html

  • Type: Article
  • DB2 UDB for z/OS developer Peggy (Abelite) Zagelow answers users' questions about stored procedures on DB2 for OS/390 and z/OS.

Creating Web Services for DB2 UDB for OS/390 Stored Procedures Using WebSphere Studio Version 5
http://www.ibm.com/developerworks/db2/library/techarticle/0304xu/0304xu.html

  • Type: Article
  • This article teaches you how to create a Web service for DB2 UDB for OS/390 or z/OS stored procedures. The target audience for this article includes developers who have limited Java knowledge.

DB2 for z/OS stored procedures: Best practices & FAQ
http://www.ibm.com/support/docview.wss?rs=64&uid=swg27001257

  • Type: Presentation
  • This presentation addresses the current hot topics in developing and managing stored procedures in DB2 for z/OS and OS/390.

Stored procedures
http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db29.doc.apsg/db2z_storedprocedure.htm

  • Type: Information center
  • These topics introduce DB2 stored procedures, and they explain how to write, prepare, run, and test stored procedures that are not written in Java.

Java stored procedures and user-defined functions
http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db29.doc.java/db2z_javaroutines.htm

  • Type: Information center
  • These topics contain information that is specific to defining and writing Java user-defined functions and stored procedures.

External stored procedures
http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db29.doc.apsg/db2z_externalsp.htm

  • Type: Information center
  • These topics discuss writing and preparing stored procedures that are written in a host language.

Certification for DB2 developers

DB2 version 9 certification: Everything you need to know
http://www.ibm.com/developerworks/db2/library/techarticle/dm-0401fosdick/index.html

  • Type: Article
  • This article describes everything that you need to know about certification, including whether you should get certified, how you can get certified, and how you can prepare and study for the certification exam.

Professional Certification Preparation Guide
http://www-306.ibm.com/software/data/education/certprep.html#db

  • Type: Website
  • The preparation guides have been created to help provide you the information you will need to prepare for Information Management certification exams. Look for Exam 732, 733 for DB2 z/OS certification descriptions, requirements, objectives, and preparation suggestions.

Debugging and testing

Debugging Options for DB2 UDB Stored Procedures
http://www.ibm.com/developerworks/db2/library/techarticle/0310rader/0310rader.html

  • Type: Article
  • This article briefly describes your options for debugging DB2 stored procedures on DB2 UDB for z/OS and OS/390 V6, V7, and V8.

Testing an application program
http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db29.doc.apsg/db2z_testdebugapp.htm

  • Type: Information Center
  • This topic discusses how to set up a test environment, test SQL statements, debug your programs, and read output from the precompiler.

Debugging a stored procedure
http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db29.doc.apsg/db2z_debugsp.htm

  • Type: Information Center
  • Some commonly used debugging tools, such as TSO TEST, are not available in the environment where stored procedures run. These topics contain some alternative testing strategies to consider.

DB2 Test Database Generator
http://www.ibm.com/software/data/db2imstools/db2tools/db2tdbg/

  • Type: Product description
  • This Web page contains general information and resources for DB2 Test Database Generator, which rapidly populates application and testing environments and simplifies problem resolution.

Security

Securing DB2 and Implementing MLS on z/OS
http://www.redbooks.ibm.com/abstracts/sg246480.html/

  • Type: IBM Redbooks
  • This Redbooks publication discusses the choices that DB2 offers to secure (multilevel security) your data.

WebSphere Application Server for z/OS V5 and J2EE 1.3 Security Handbook
http://www.redbooks.ibm.com/abstracts/sg246086.html/

  • Type: IBM Redbooks
  • This Redbooks publication explains how you can run your Web-enabled applications with as high a level of security as other z/OS applications and subsystems, even if those applications were written or originally deployed on another platform, by using the Java 2 Platform Enterprise Edition (J2EE) programming model and IBM WebSphere Application Server for z/OS and OS/390.

Monitoring and tuning

DB2 UDB for z/OS Version 8 Performance Topics
http://www.redbooks.ibm.com/abstracts/SG246465.html/

  • Type: IBM Redbooks
  • This Redbooks publication introduces the major performance and availability changes as well as the performance characteristics of many new functions. It helps you understand the performance implications of migrating to DB2 V8 with considerations based on laboratory measurements. It provides the type of information needed to start evaluating the performance impact of DB2 V8 and its capacity planning needs.

DB2 9 for z/OS Performance Topics
http://www.redbooks.ibm.com/abstracts/sg247473.html/

  • 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.

A Deep Blue View of DB2 Performance: IBM Tivoli® OMEGAMON® XE for DB2 Performance Expert on z/OS
http://publib-b.boulder.ibm.com/abstracts/sg247224.html/

  • Type: IBM Redbooks
  • IBM Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS represents the effort on converging OMEGAMON XE for DB2 and DB2 Performance Expert into one product that retains the best features of each. This new tool gives you a single, comprehensive tool to help assess the efficiency of and optimize performance from your DB2 database in the z/OS environment. It automates the analysis of your database performance in real time and also adds expert database analysis functions to help you maximize performance and enhance productivity.

Tune SQL like an expert in DB2 UDB z/OS V8 - Terry Purcell
http://www.ibm.com/support/docview.wss?rs=64&uid=swg27006180

  • Type: Presentation
  • 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.

DB2 for z/OS and OS/390 : Squeezing the Most Out of Dynamic SQL
http://www.redbooks.ibm.com/abstracts/sg246418.html/

  • Type: IBM Redbooks
  • This Redbooks publication explains myths and misconceptions about dynamic SQL by presenting a balanced discussion of issues such as complexity, performance, and control.

DB2 for z/OS DB2 database design: Principles of peak performance
http://www.ibm.com/developerworks/db2/library/techarticle/dm-0408whitlark/index.html

  • Type: developerWorks article
  • This article provides some general guidelines and recommendations for achieving better DB2 performance in z/OS environments.

Acknowledgment

The author would like to thank the following people who contributed to this article through their reviews and suggestions for content: Dave Hauser, Don Kiefer, Rob Strong, Sam Poon, Sandra Chang, and Steven Hwung.

Resources

Learn

Get products and technologies

Discuss

Comments

developerWorks: Sign in

Required fields are indicated with an asterisk (*).


Need an IBM ID?
Forgot your IBM ID?


Forgot your password?
Change your password

By clicking Submit, you agree to the developerWorks terms of use.

 


The first time you sign into developerWorks, a profile is created for you. Information in your profile (your name, country/region, and company name) is displayed to the public and will accompany any content you post, unless you opt to hide your company name. You may update your IBM account at any time.

All information submitted is secure.

Choose your display name



The first time you sign in to developerWorks, a profile is created for you, so you need to choose a display name. Your display name accompanies the content you post on developerWorks.

Please choose a display name between 3-31 characters. Your display name must be unique in the developerWorks community and should not be your email address for privacy reasons.

Required fields are indicated with an asterisk (*).

(Must be between 3 – 31 characters.)

By clicking Submit, you agree to the developerWorks terms of use.

 


All information submitted is secure.

Dig deeper into Information management on developerWorks


static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=Information Management
ArticleID=460365
ArticleTitle=Recommended reading lists: DB2 for z/OS recommended reading list
publish-date=01072010