Using DB2 Utilities to Load and Unload Tables:
for the Application Developer

This 1 day hands-on workshop trains:

the DB2 for z/OS and OS/390 application developer how to use DB2 utilities to perform table unloads and reloads. The attendee will learn how to use the LOAD utility to populate DB2 tables, to use the REORG UNLOAD EXTERNAL to unload the contents of tables in a format that can be used by the LOAD utility, to use the REORG DISCARD to perform purge processing and to use the DSNTIAUL sample application to unload data from tables when REORG cannot accomplish the unload requirement. DB2's utilities are often overlooked in the application design process, even though they normally perform better than application code.
 

Topics Covered:

• DB2 Utilities Overview
• Using LOAD to Populate Tables
• Using REORG to Unload Tables and Purge Unwanted Data
• Using DSNTIAUL

Objectives:

This class is designed to help the programming staff become familiar with tusing DB2 UDB's LOAD and REORG Utility . It introduces the parameters that are used in loading and unloading tables and provides reinforcement to the student with hands-on labs.

Duration: 1 day

Delivery: Lecture and Introductory hands-on Lab

Audience: 

Anyone who needs to use the DB2 utilities to load and unload tables, including end-users, programmers, application designers, database administrators, and system administrators who do not have a working knowledge of the usage of the utilities to accomplish application requirements.

Prerequisites:

Working knowledge of TSO, JCL and DB2 SQL

Outline:

1. DB2 Utilities Overview

DB2 Supplied Utilities
Run Time Environment
DSNUPROC
Controlling Utilities and Commands
Related Database Commands and Statuses

2. DB2 LOAD Utility

Introduction to the LOAD Utility
LOAD Purpose
LOAD Phases
Utility Control Statements
JCL Requirements
Load Utility Usage
After Load (Statuses and Recommendations)
Performance Issues
Termination and Restart
Workshop

3. DB2 REORG UNLOAD EXTERNAL & DISCARD

Introduction to the REORG Utility
REORG Purpose
REORG Phases
Utility Control Statements and JCL Requirements
Using REORG to UNLOAD Data
Using REORG to DISCARD (purge) Unwanted Data
Workshop

4. DSNTIAUL

Introduction to DSNTIAUL
JCL and Parameters
Data Set Requirements
Return Codes
Unloading Data from Tables and Views
DSNTIAUL VS REORG UNLOAD
Workshop