DB2 UDB for z/OS Utilities & Commands

 LENGTH OF COURSE:
2 Days

DESCRIPTION: The course will concentrate on the administration and operations aspects of DB2 and DB2 Objects. In addition, students will learn commands and utilities that are critical to the DB2 production environment.

PREREQUISITES: Students should have a basic understanding of DB2 Terminology and Concepts.

INSTRUCTION TECHNIQUES: A combination of Lecture, Demonstration, and Labs (when/where available).

AUDIENCE

This course is designed for the Computer Operator, Analyst, or Administrator that needs to gain better understanding of the DB2 Utilities & Commands.
KEY HIGHLIGHTS:
  • Introduction to DB2 Administrative Functions
  • Review of DB2 Interactive
  • The DB2 Catalog and Utilities
  • Overview of Utilities
  • Stand-alone Utilities
  • Utility Data Sets
  • Utility Control Statements
  • Invoking Utilities
  • Using DB2I to run a utilities
  • Using DSNU CLIST
  • Creating JCL for utilities
  • Understand the following DB2 Utilities and key parameters:
    • CHECK
    • CHECK DATA
    • CHECK INDEX
    • COPY
    • LOAD DATA
    • MERGECOPY
    • MODIFY RECOVERY
    • MODIFY STATISTICS
    • QUIESCE
    • RECOVER TABLESPACE
    • RECOVER INDEX
    • REORG
    • REPAIR
    • RUNSTATS
    • DSN1CHKR
    • DSN1COPY
    • DSN1PRNT


  • Understand the following DB2 Commands and key parameters:
    • DCLGENs
    • BINDs
    • REBINDs
    • FREE
    • RUN and END
    • SPUFI
    • ARCHIVE LOG
    • DISPLAY
    • RECOVER
    • CANCEL
    • START
    • TRACE
    • STOP
    • DSNC Commands
    • TSO CLISTS
    • OS/390 DB2 Commands




FROM OUR STUDENT EVALUATIONS...
"I think John does an excellent job as instructor for this course. He knows the material very well and can relate it to practical experience."

John Pedercini
Niagara Mohawk Power Corporation

Return to Home Page.
Return to Alphabetic Listing of Courses.
Return to Courses by Subject.
Request More Information or Contact Us.