DB2 for Operators (2 days)

Designed for: Operations analysts and senior operators

Primary Objective: To use the DB2 operator commands, utilities, and recovery facilities

Introduction
Comparison of DB2 tables with VSAM files and hierarchical databases (e.g. IMS, TOTAL).  Tasks and personnel involved in implementing a DB2 system.  Sample uses of DB2.

Tables
How data is arranged; views; basic table design.  Typical disk requirements.  Physical storage considerations.

Accessing DB2
How programs can access DB2, SQL language; precompile and BIND process.  Access from TSO and batch.  Functions and use of QMF, DXT, DBEDIT, DB2I and SPUFI.

Security considerations
Facilities which can be controlled.  Overview of locking.

Backup and recovery
Operational aspects; startup and shutdown; utilities for loading tables, reorganising table spaces, listing space utilisation information.  Generating reports for the database administrator (DB2PM).  Recovery/Restart considerations, operator commands.

OS/390, JCL, DB2, CICS, VSAM, REXX

Home Page  |  About Oakwood  |  VSE/ESA, JCL, POWER  |  UNIX, Scripts, INGRES  |  COBOL, PL/1, Assembler  |  Easytrieve, SELCOPY  |  3rd Party Software  |  New Graduate Schemes

oakcomp@globalnet.co.uk