Course Outline
Pre-Requisites
An understanding of the objects (tables, indexes, databases, and so forth) used in DB2 systems, and of how those objects are created, managed, and recovered
A working knowledge of SQL
At least one year as a z/OS systems programmer or equivalent experience
Or, one year working with DB2 on the mainframe as a DBA on the mainframe or equivalent experience
DB2 Family Fundamentals
DB2 SQL Workshop
DB2 SQL Workshop for Experienced Users
Lessons
- Relate the z/OS IPL process to a DB2 subsystem
- Effects of stopping and starting DB2
- How DB2 sets and use Integrated Catalog Facility (ICF) catalog names
- Use of DSN command processor running in batch and foreground
- Use views to minimize users' ability to see into the DB2 catalog
- See how the catalog (through grant activity) controls access to data
- Search the catalog for problem situations
- Use the catalog and DB2 utilities to determine data recovery requirements
- Internal Resource Lock Manager (IRLM) in a DB2 environment
- Implement DB2 and Resource Access Control Facility (RACF) security
- DB2 program flow for all environments
- Display normal and problem threads and database status
- How the SQL Processor Using File Input (SPUFI) AUTOCOMMIT option defers the COMMIT/ROLLBACK decision
- Interpret lock displays
- Identify and cancel particular threads
- Available DB2 utilities to manage system and user page setsÂ
Cancellation Policy
We require 16 calendar days notice to reschedule or cancel any registration. Failure to provide the required notification will result in 100% charge of the course. If a student does not attend a scheduled course without prior notification it will result in full forfeiture of the funds and no reschedule will be allowed. Within the required notification period, only student substitutions will be permitted. Reschedules are permitted at anytime with 16 or more calendar days notice. Enrollments must be rescheduled within six months of the cancel date or funds on account will be forfeited.
Training Location
Online Classroom
your office
your city,
your province
your country
