Training

 

 

Popular Courses

Browse Our Free Resources

  • whitepapers
  • whitepapers
  • webinars
  • blogs

Our Locations

Training Centres

Vancouver, BC
Calgary, AB
Edmonton, AB
Toronto, ON
Ottawa, ON
Montreal, QC
Hunt Valley
Columbia

locations map

Calgary

550 6th Av SW
Suite 475
Calgary, AB
T2P 0S2

Toronto

821A Bloor Street West
Toronto, ON
M6G 1M1

Vancouver

409 Granville St
Suite 902
Vancouver, BC
V6C 1T2

U.S. Office

436 York Road
Suite 1
Jenkintown, PA
19046

Other Locations

Dallas, TX
Miami, FL

Home > Training > DB2 > DB2 for z/OS: DB2 Utilities for DBAs Training

DB2 for z/OS: DB2 Utilities for DBAs Training

Course#: WA2225

An ability to use and exploit the utilities provided with DB2 for z/OS is essential for today's DBAs. This course provides an in-depth understanding of the utilities provided with DB2 for z/OS, explaining the need for the utility, the major control statements used and operational considerations. All online and stand-alone utilities are discussed and explained.

Objectives

On successful completion of this course attendees will be able to:

  • identify and describe the need for the various DB2 utilities
  • understand the main control statement options for each online utility
  • understand the main parameters for controlling each stand-alone utility
  • identify and describe the operational considerations when using utility jobs.

Audience

This course is intended for DB2 database administrators and other DB2 support personnel.

Prerequisites

Experience of working with DB2 for z/OS in a support or administrator role.

Duration

3 days

Outline of WA2225 DB2 for z/OS: DB2 Utilities for DBAs Training

1. Utilities for Data Integrity & Consistency

  • The CHECK DATA, CHECK INDEX and CHECK LOB online utilities.

2. Utilities for Data Management

  • The LOAD and UNLOAD online utilities.

3. Utilities for Data Backup and Recovery

  • The COPY, COPYTOCOPY, MERGECOPY, RECOVER, REBUILD, QUIESCE and REPORT online utilities.

4. Utilities for Maintenance and Housekeeping

  • The REORG TABLESPACE, REORG INDEX, RUNSTATS, MODIFY, STOSPACE and REPAIR online utilities.

5. Utilities for System-wide Backup and Recovery

  • The BACKUP SYSTEM and RESTORE SYSTEM online utilities.

6. Stand-alone Utilities

  • The DSN1COPY, DSN1PRNT, DSN1LOGP, DSN1COMP, DSN1CHKR, DSNJU004, DSNJU003 and DSNJLOGF stand-alone utilities.

7. Operational Considerations

  • Concurrency between utilities; availability; CLAIMS and DRAINS; utility restrictive states.

 

We regularly offer classes in these and other cities. Atlanta, Austin, Baltimore, Calgary, Chicago, Cleveland, Dallas, Denver, Detroit, Houston, Jacksonville, Miami, Montreal, New York City, Orlando, Ottawa, Philadelphia, Phoenix, Pittsburgh, Seattle, Toronto, Vancouver, Washington DC.
*Your name:

*Your e-mail:

*Phone:

*Company name:

Additional notes:

We have received your message. A sales representative will contact you soon.

Thank you!.

more details
buy this course

Register for a courseware sample

It's simple, and free.

 

Thank You!

You will receive an email shortly containing a link to download the requested sample of the labs for this course.