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

All information submitted is secure.

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.

All information submitted is secure.

My developerWorks:

My notifications:

Sign out

Select a language:

DB2 for z/OS

DB2® on the mainframe allows you to run powerful enterprise applications and make e-commerce a reality. developerWorks is the technical resource center for DB2 for z/OS® and OS/390®.

DB2 10.x certification: Everything you need to know

Learn how the IBM DB2 certification process works, how tests are developed, and whether getting certified is right for you. Review the many resources included in this article to help you in every phase of the certification process. More >

Featured content

06 Jun 2013 — Show descriptions | Hide descriptions

e-Learning Course for InfoSphere Optim Query Capture and Replay
Get an overview of IBM InfoSphere Optim Query Capture and Replay, its architecture, and the workflow in this interactive tutorial that shows you how to complete the basic capture and replay workflow in a DB2 for z/OS environment.
Online DB2 for z/OS migration
Get hints and tips to make your online migration successful. Discover how the DB2 migration process has been designed specifically to allow the business application set to continue to run while you migrate.
Technical tip: Maintain high availability on DB2 for z/OS on single LPAR systems
Use a method to map your test program onto production qualifiers and retrieve data directly from production to maintain high availability during the test, development, and production cycle.
Optim Query Tuner: Capture and tune DB2 z/OS SQL statements using a user-defined SQL repository
Create query workloads directly from your own SQL repository, without the overhead of archiving or staging your workload data. Leverage the Query Tuner user interface to define dynamic and static SQL statement filters, and tune the saved workload without implementing your own client.
Modeling created global temporary tables for DB2 with InfoSphere Data Architect 8.5, Part 2: Modifying an existing data model
In Part 2 of this article series, use InfoSphere Data Architect 8.5 to modify an existing data model to incorporate changes in requirements for the created global temporary table.
Modeling created global temporary tables for DB2 with InfoSphere Data Architect 8.5, Part 1: Getting Started
Leverage InfoSphere Data Architect to create a physical data model with CGTT (created global temporary tables) and then generate a DDL with CGTT-specific syntax that you can run on a database server.
DB2 Tools corner: Using IBM Tools Customizer for z/OS in a multiple-LPAR environment
Customize your DB2 for z/OS tools using a standard, repeatable process in a multiple-LPAR environment using IBM Tools Customizer for z/OS.
Update: Selected common SQL features for developers of portable DB2 applications
Make sure your DB2 applications are portable across platforms. The tables in this article summarize common SQL application features and make it easy for you to develop apps that are portable across the DB2 family. Updated for the latest DB2 versions.
Using DB2 for z/OS pureXML to process SEPA transactions: A practical guide to performance improvement based on experience
Achieve high performance goals for the processing of standard payment messages stored using DB2 for z/OS and pureXML.