Take advantage of spring savings with up to 50% off ILT training.

MyGK
Support
USA USA - English
Checkout

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:

    $

Subtotal

$

Checkout

or Continue Shopping

Contact Sales
Course  
Contact Sales
Support
Checkout

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:

    $

Subtotal

$

Checkout

or Continue Shopping

Request Group Training

IBM Introduction to DB2 for z/OS for Systems and Operations Personnel

Explore DB2 Objects Structured Query Language DB2 Commands DB2 Utilities DB2 Logging DB2 Program Preparation.

DB2 11 for z/OS beginning DBAs can develop fundamental skills or recognition through lectures and hands-on exercises of: DB2 Objects Structured Query Language DB2 Commands DB2 Utilities DB2 Logging DB2 Program Preparation The course materials cover DB2 11 for z/OS.

GK# 0259 Vendor# CV021G
Vendor Credits:
No matching courses available.
Start learning as soon as today! Click Add To Cart to continue shopping or Buy Now to check out immediately.
Access Period:
Scheduling a custom training event for your team is fast and easy! Click here to get started.
$
Your Selections:
Location:
Access Period:
No available dates
Add To Cart

BUY NOW

Request a quote

Is This The Right Course?

You should have a working knowledge of

  • z/OS, TSO, ISPF, and SDSF
  • Sequential, partitioned, and VSAM data sets
  • Basic JCL

Who Should Attend?

This course is for beginning DB2 for z/OS database administrators who need to acquire the basic skills required to administer a DB2 database in a z/OS environment.

What You'll Learn
  • Give an overview of the DB2 9 environment
  • Describe and utilize DB2 Objects
  • Understand DB2 Logging
  • Describe and utilize several DB2 Utilities
  • Describe DB2 program preparation process
  • Describe the DB2I (DB2 Interactive Facility) environment
  • Understand DB2 startup and shutdown
  • Use SPUFI (SQL Processing Using File Input) to compose and execute SQL
  • Understand and utilize DB2 recovery strategies

Course Outline
  • z/OS Prequisite Review
  • DB2 Relational Database Concepts
  • Structured Query Language (SQL) and SPUFI
  • The DB2 System
  • DB2 Commands and Program Preparation
  • DB2 Utilities
  • DB2 Shutdown, Startup, and Recovery
  • Course Summary
  • AGENDA

 

  • Day 1
    • (00:15) Welcome
    • (00:45) Exercise 4: Tables, Indexes, and views
    • (00:45) Exercise 7: DB2 Commands
    • (00:30) Unit 1: z/OS Prerequisite Review
    • (00:10) Exercise 1: Connecting to z/OS and Creating Data Sets
    • (00:05) Exercise 1 Review
    • (01:15) Unit 2: DB2 Relational Database Concepts
    • (01:15) Unit 3: Structured Query
    • Language (SQL) and SPUFI
    • (00:45) Exercise 2: SQL and SPUFI
    • (00:15) Exercise 2 Review
    • (01:30) Unit 4: DB2 Objects (Databases and Table Spaces)
    • (00:45) Exercise 3: Databases and Table Spaces
    • (00:15) Exercise 3 Review
    • (01:30) Unit 4: DB2 Objects (Tables, Indexes, and Views)
  • Day 2
    • (00:15) Exercise 4 Review
    • (01:00) Unit 4: DB2 Objects (Qualified Names, Implicit Object Creation, and SQL Statements)
    • (00:30) Exercise 5: Qualified Names, Implicit Object Creation, and SQL Statements
    • (00:15) Exercise 5 Review
    • (01:30) Unit 5: The DB2 System
    • (00:45) Exercise 6: The DB2 System
    • 00:15) Exercise 6 Review
    • (02:00) Unit 6: DB2 Commands and Program Preparation
  • Day 3
    • (00:15) Exercise 7 Review
    • (02:00) Unit 7: DB2 Utilities
    • (01:00) Exercise 8: DB2 Utilities
    • (00:15) Exercise 8 Review
    • (01:15) Unit 8: DB2 Shutdown, Startup, and Recovery
    • (00:45) Exercise 9: DB2 Recovery
    • (00:15) Exercise 9 Review
    • (00:30) Unit 9: Course Summary
BUY NOW

Prerequisites

You should have a working knowledge of

  • z/OS, TSO, ISPF, and SDSF
  • Sequential, partitioned, and VSAM data sets
  • Basic JCL