Product documentation
Abstract
This roadmap outlines the information resources that are available for users who are new to DB2 for z/OS. These resources provide information about installation, administration, and programming for DB2 for z/OS.
Content
Tab navigation
Product overview
General information
Information Management Software for z/OS Solutions Information Center (Type: Information center) Visit the Information Management Software for z/OS Solutions Information Center to find all the information that you need to install, configure, maintain, and use IBM products for managing your information on z/OS.
DB2 for z/OS - Technical Resources (Type: 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.
Introduction to the New Mainframe: z/OS Basics (Type: IBM Redbooks) This IBM Redbooks publication provides you with the background knowledge and skills necessary to begin using the basic facilities of a mainframe computer. This book is designed to introduce new users to mainframe concepts and to help new users prepare for a career in large systems computing.
DB2 for z/OS training (Type: Classroom courses) Looking for educational courses about DB2 for z/OS? Visit this website to view recommended training paths and training options by topic area, such as administration, application programming, database design, DB2 Tools for z/OS, and more. Training opportunities are available online and onsite.
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.
Version 10 information
DB2 for z/OS PDF books for information center topics (DB2 10) (Type: Information center, Manual) This information center topic contains links that you can use to download DB2 10 for z/OS technical manuals (in PDF format) and links to the information center topics that correspond to each manual.
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.
Introduction to DB2 10 for z/OS (Type: Information center) This information is primarily intended for those people who are new to DB2 for z/OS. This introductory information explains the basic concepts that are associated with relational database management systems in general, and with DB2 for z/OS in particular.
Version 9.1 information
DB2 for z/OS PDF books for information center topics (DB2 9) (Type: Information center, Manual) This information center topic contains links that you can use to download DB2 9 for z/OS technical manuals (in PDF format) and links to the information center topics that correspond to each manual.
Introduction to DB2 Version 9.1 for z/OS (Type: Information center) This information is primarily intended for those people who are new to DB2 for z/OS. This introductory information explains the basic concepts that are associated with relational database management systems in general, and with DB2 for z/OS in particular.
Planning
Version 10 information
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 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.
Version 9.1 information
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.
Installing
Version 10 information
Installation and migration tools (Type: Information center) This information describes the several tools and capabilities that are included with DB2 to help you complete the steps that are involved in installing or migrating to Version 10.
Summary of installation steps (Type: Information center) This information identifies the steps that you perform to edit and run the jobs that install DB2 Version 10.
Version 9.1 information
Installation and migration tools (Type: Information center) This information describes the several tools and capabilities that are included with DB2 to help you complete the steps that are involved in installing or migrating to Version 9.1.
Summary of installation steps (Type: Information center) This information identifies the steps that you perform to edit and run the jobs that install DB2 Version 9.1.
Migrating
Version 10 information
Introduction to migration from DB2 Version 9.1 (to DB2 Version 10) (Type: Information center) This information provides an overview of migration, with is the process of upgrading from one DB2 release to a later release. In this case, the information describes migrating from Version 9.1 to Version 10.
Introduction to migration from DB2 Version 8 (to DB2 Version 10) (Type: Information center) This information provides an overview of migration, with is the process of upgrading from one DB2 release to a later release. In this case, the information describes migrating from Version 8 to Version 10.
Installation and migration tools (Type: Information center) This information describes the several tools and capabilities that are included with DB2 to help you complete the steps that are involved in installing or migrating to Version 10.
Version 9.1 information
Introduction to migration from DB2 Version 8 (to DB2 Version 9.1) (Type: Information center) This information provides an overview of migration, with is the process of upgrading from one DB2 release to a later release. In this case, the information describes migrating from Version 8 to Version 9.1.
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 the processes involved to install or migrate DB2.
Installation and migration tools (Type: Information center) This information describes the several tools and capabilities that are included with DB2 to help you complete the steps that are involved in installing or migrating to Version 9.1.
Administering
General administration information
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.
Database Administration and Change Management (Type: Website) This website provides you with information about the various tools that are available to help you manage database administration and change management processes.
Version 10 information
Designing a database (Type: Information center) This information provides details about designing and implementing a database, including logical and physical database design, and implementing and altering your database design in Version 10.
Introduction to data sharing (Type: Information center) This information provides an overview of the data sharing function of DB2 10 for z/OS, which enables multiple applications to read from, and write to, the same DB2 data concurrently.
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.
Introduction to DB2 utilities (Type: Information center) This information provides an overview of the basic characteristics of DB2 utilities and explains how they are packaged. Several utilities are included with DB2 10 for z/OS at no extra charge, and others are available as a separate product.
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.
Version 9.1 information
Designing a database (Type: Information center) This information provides details about designing and implementing a database, including logical and physical database design, and implementing and altering your database design in Version 9.1.
Introduction to data sharing (Type: Information center) This information provides an overview of the data sharing function of DB2 Version 9.1 for z/OS, which enables multiple applications to read from, and write to, the same DB2 data concurrently.
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.
Introduction to DB2 utilities (Type: Information center) This information provides an overview of the basic characteristics of DB2 utilities and explains how they are packaged. Several utilities are included with DB2 Version 9.1 for z/OS at no extra charge, and others are available as a separate product.
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.
Developing
Version 10 information
Developing SQL code for DB2 applications (Type: Information center) This information describes structured query language (SQL), which is the language that you use to access data in DB2 tables. SQL is a standardized language for defining and manipulating data in a relational database.
Developing applications for DB2 (Type: Information center) DB2 supports a wide variety of choices for designing and coding application programs. This information discusses application design choices and the wide range of options for tools and languages that are available for developing applications.
Developing DB2 applications for performance (Type: Information center) This information describes ways that you can achieve better performance from DB2 by considering performance as you program and deploy your applications.
Version 9.1 information
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.
Developing SQL code for DB2 applications (Type: Information center) This information describes structured query language (SQL), which is the language that you use to access data in DB2 tables. SQL is a standardized language for defining and manipulating data in a relational database.
Developing applications for DB2 (Type: Information center) DB2 supports a wide variety of choices for designing and coding application programs. This information discusses application design choices and the wide range of options for tools and languages that are available for developing applications.
Developing DB2 applications for performance (Type: Information center) This information describes ways that you can achieve better performance from DB2 by considering performance as you program and deploy your applications.
DB2 stored procedures
Version 10 information
Implementing DB2 stored procedures (Type: Information center) 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.
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.
Version 9.1 information
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.
Implementing DB2 stored procedures (Type: Information center) 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.
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.
Scenarios
Version 10 information
Scenarios for using DB2 for z/OS (Type: Information center) These scenarios illustrate how some organizations (an international bank, a multi-campus university system, and an electric company) might successfully use DB2 10 for z/OS.
Version 9.1 information
Scenarios for using DB2 for z/OS (Type: Information center) These scenarios illustrate how some organizations (an international bank, a multi-campus university system, and an electric company) might successfully use DB2 Version 9.1 for z/OS.
Samples
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
Version 10 information
Debugging an application program (Type: Information center) Many organizations have guidelines regarding what to do if your program abends. This information contains some common suggestions.
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.
Version 9.1 information
Debugging an application program (Type: Information center) Many organizations have guidelines regarding what to do if your program abends. This information contains some common suggestions.
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.
Security
Version 10 information
Getting started with DB2 security (Type: Information center) This information introduces DB2 10 security concepts, which refers to the protection of sensitive data and system resources by controlling access to DB2 objects, subsystems, and other assets.
Version 9.1 information
Getting started with DB2 security (Type: Information center) This information introduces DB2 Version 9.1 security concepts, which refers to the protection of sensitive data and system resources by controlling access to DB2 objects, subsystems, and other assets.
Managing performance
Version 10 information
Performance management for DB2 for z/OS (Type: Information center) Managing the performance of a DB2 subsystem involves understanding a wide range of system components. This information helps you understand the performance of those components, how to monitor the components, and how to identify problem areas.
Planning a performance strategy for DB2 for z/OS (Type: Information center) Planning a performance strategy helps to ensure that DB2 meets your performance requirements. This information describes how you can avoid some performance problems completely by planning for performance when you first design your system.
Version 9.1 information
Performance management for DB2 for z/OS (Type: Information center) Managing the performance of a DB2 subsystem involves understanding a wide range of system components. This information helps you understand the performance of those components, how to monitor the components, and how to identify problem areas.
Planning a performance strategy for DB2 for z/OS (Type: Information center) Planning a performance strategy helps to ensure that DB2 meets your performance requirements. This information describes how you can avoid some performance problems completely by planning for performance when you first design your system.
Troubleshooting and support
General 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.
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.
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.
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.
Version 10 information
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.
Version 9.1 information
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.
Reference
General information
DB2 glossary (Type: Information center) This glossary contains DB2 for z/OS terms.
Version 10 information
SQL: The language of DB2 for z/OS (Type: Information center) This information describes the many different types of SQL statements. The various types of SQL statements have different purposes, coding, and reasons for usage.
Description of DB2 and related commands (Type: Information center) This information provides detailed reference information for DB2 and related commands, including the environment in which each command is issued, the privileges and authorities that are required to issue each command, syntax and option descriptions, usage information, and examples.
Introduction to the DB2 utilities (Type: Information center) This information provides an overview of the basic characteristics of DB2 utilities and explains how they are packaged. Several utilities are included with DB2 10 for z/OS at no extra charge, and others are available as a separate product.
Version 9.1 information
SQL: The language of DB2 for z/OS (Type: Information center) This information describes the many different types of SQL statements. The various types of SQL statements have different purposes, coding, and reasons for usage.
Description of DB2 and related commands (Type: Information center) This information provides detailed reference information for DB2 and related commands, including the environment in which each command is issued, the privileges and authorities that are required to issue each command, syntax and option descriptions, usage information, and examples.
Introduction to the DB2 utilities (Type: Information center) This information provides an overview of the basic characteristics of DB2 utilities and explains how they are packaged. Several utilities are included with DB2 Version 9.1 for z/OS at no extra charge, and others are available as a separate product.
Community resources
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.
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.
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.
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.