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: Database Administration Training

DB2 for z/OS: Database Administration Training

Course#: WA2273

This course provides a detailed understanding of the DB2 for z/OS facilities and procedures required to provide database users with efficient administration and support. It explains the system architecture and facilities of DB2 including monitoring, security and recovery techniques.

Objectives

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

  • describe the DB2 environment, and understand the use of key DB2 components such as buffer pools, the DB2 catalog and directory, logging data sets, etc.
  • describe the internal structure of DB2 UDB for z/OS databases
  • understand and assess security and related requirements
  • use DB2 commands to monitor and control DB2 objects, processes and operations
  • understand and use the full complement of DB2 online data and recovery utilities
  • understand and use the DB2 stand-alone utilities
  • use DB2 traces to record performance monitoring information
  • understand and interpret information in DB2PM accounting and statistics reports.

Audience

Those responsible for the ongoing support and administration of DB2 for z/OS databases.

Prerequisites

Attendees should be familiar with the DB2 environment and have knowledge of SQL or have attended the RSM courses DB2 for z/OS: Introduction, Concepts & Facilities and DB2 for z/OS: SQL for Query Users.

Duration

3 days

Outline of WA2273 DB2 for z/OS: Database Administration Training

1. DB2 Environment Overview

  • DB2 address spaces
  • Attachments
  • Log data sets
  • Catalog
  • Directory
  • Buffer pools
  • bufferpool thresholds
  • bufferpool hit ratio
  • usage considerations.

2. DB2 Pagesets

  • Pageset structure
  • Tablespace types and defaults
  • Index structure
  • Data compression.

2. DB2 Security & Data Control Language

  • The grant and revoke statements
  • Explicit and implicit privileges
  • Object privileges
  • Administrative privileges
  • Install SYSADM/SYSOPR
  • Using RACF profiles
  • Multilevel security
  • row & column level security.

3. Utilities Overview

  • Online utilities
  • stand-alone utilities
  • control statements
  • DB2I Utilities option
  • using LISTDEF
  • using TEMPLATE
  • OPTIONS statement.

4. Online Data Utilities

  • RUNSTATS
  • LOAD
  • UNLOAD
  • CHECK DATA
  • CHECK INDEX
  • CHECK LOB
  • REORG
  • STOSPACE
  • REPAIR.

5. Online Recovery Utilities

  • Recovery components
  • COPY
  • COPYTOCOPY
  • MERGECOPY
  • REPORT
  • QUIESCE
  • RECOVER
  • REBUILD
  • MODIFY
  • BACKUP SYSTEM
  • RESTORE SYSTEM.

6. Stand-alone Utilities

  • DSN1COPY
  • DSN1PRNT, DSN1LOGP
  • DSN1COMP
  • DSN1CHKR
  • DSNJU004
  • DSNJU003
  • DSNJLOGF.

7. Catalog & Directory Recovery

  • Catalog / Directory recovery
  • Recovery sequence
  • Point-in-time recovery implications.

8. Performance Monitoring

  • DB2 traces
  • Controlling traces
  • DB2PM Accounting reports
  • DB2PM Statistics reports.

9. Practical Exercises

  • Using data utilities
  • using backup & recovery utilities
  • using stand-alone utilities.
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.