New-user information roadmap

Product overview

z/OS Basic Skills education

New to z/OS? You've come to the right place! The z/OS Basic Skills education offers the fastest way to learn and become productive onz/OS.

Introduction to the New Mainframe: z/OS Basics

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.

IBM Mainframe: Make the Extraordinary Possible

This video explains how the mainframe is essential in today's digital world, enabling 90% of Fortune 500 companies.

zIQ by IBM Z

This series of videos explains the relevance and power of IBM Z.

DB2 for z/OS training paths

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, IBM DB2 Tools for z/OS, and more. Training opportunities are available online and onsite.

IBM IBM Z Course Materials for the Community

This web page contains course materials to assist the mainframe community with skills. Most of the materials are intended for use in a 15-week semester IT course; however, some of these resources are smaller and can be used independently.

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.

Planning

DB2 10 Technical Overview

This IBM Redbooks publication introduces the enhancements made available with this version of DB2 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.

Installing and migrating

Introduction to installation and migration

This information provides an overview of the essential steps involved in installing or migrating to a new release of DB2 for z/OS.

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.

Administering

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.

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.

Scenarios

Scenarios for using DB2

These scenarios illustrate how some organizations (an international bank, a multi-campus university system, and an electric company) might successfully use DB2 for z/OS.

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.

Getting started

DB2 basics tutorial: Working with DB2 for z/OS interactively

This tutorial shows you how to use DB2 for z/OS in the z/OS terminal interface to complete some basic database administration tasks.

Tutorial: Using the command line processor

This tutorial demonstrates how you can interactively query and modify DB2 data, call stored procedures, and issue z/OS UNIX System Services commands through the command line processor.

Developing

Application programming for DB2

You use application programs that contain SQL statements to perform data definition or data manipulation operations on DB2 objects. This information guides you through the basic concepts that you need to know before you start writing SQL applications.

DB2 for z/OS Best Practices

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 developing application programs, 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.

DB2 and Java: The Big Picture

This developerWorks article provides an introduction to Java support in DB2 for z/OS.

Processing XML data with DB2 pureXML®

Learn how you can use pureXML with your client applications to manage XML data in DB2 tables. You can store well-formed XML documents in their hierarchical form and retrieve all or portions of those documents.

Tutorial for pureXML

This tutorial demonstrates how to set up a DB2 database system to store XML data and to perform basic operations with XML data.

Managing performance

DB2 performance management

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.

DB2 10 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.

Troubleshooting and support

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.