Home > Vendors > ibm > cv853g

CV853G - Db2 12 for z/OS Introduction to System Administration

This course provides students with an introduction to the skills and knowledge needed to administer a Db2 12 for z/OS system.

Duration: 3.0 days

Enquire Now

Start learning today!

Click Hereto customize your Training

Objectives

After completing this course, students should be able to:

Start and stop a Db2 subsystem
Use the SET SYSPARM command
Access the system log to gather information about the subsystem initialization, operation, or shutdown
Describe the components and address space structure of a Db2 subsystem
Explain the use of RACF (or another external security program) for Db2 connection security
Explain the use of Roles and Trusted Contexts
Implement security procedures for a Db2 subsystem
Explain Db2 program flow for all environments
Explain parameter setting for the IRLM
Invoke and utilitze Db2 TSO facilities
Use the Db2 Catalog to monitor subsystem authorizations
Work with the Active Log data sets
Explain Db2 logging
Use SET LOG SUSPEND and SET LOG RESUME
Use DSNJU004 to print log map and interpret the results
Use DSNJU003 to rename Db2 data sets
Plan for recovery of a BSDS failure
Monitor and control a Db2 subsystem
Explain transaction flow in IMS and CICS environments (optional)
Describe the CICS and DB2 environment (optional)
Explain the difference between JDBC and SQLJ
And much more

Content

1. Starting, stopping, and accessing Db2

Starting Db2 as part of the z/OS IPL process
Data set allocation and APF authorization
The START DB2 and STOP DB2 commands
zParms, DSNTIJUZ, and DSNZPARM
Address spaces
IRLM and lock storage

2. Db2 components and processes

BSDS and logging
Catalog and directory
Program preparation and execution
Transaction execution
Data sharing in the sysplex

3. System security

Protecting Db2 data sets
Controlling connections to Db2
Db2 authorization exits
Trusted context and roles
Securing an application server

4. Db2 authorization

Authorizations
Controlling access for dynamic and static SQL
Access control authorization exits
Distributed security

5. Program flow for all environments

Connection types and language interfaces
Program flow

6. TSO and batch environments

TSO
Utilities

7. Transaction flow in IMS and CICS (optional)

Transaction processing
Thread reuse
SIGNON exit

8. CICS - Db2 environment (optional)

CICS connections to Db2
DSNC transaction

9. IMS - Db2 environment (optional)

IMS-Db2 introduction
IMS TM
IMS/DLI batch environment

10. Distributed - Db2 environment

Distributed attachment
Location aliases
DDF profiling
Block fetch
Db2 REST services

11. Logging

The Db2 log
Log commands
Archiving considerations
BSDS

12. Db2 utilities

Categorization
DSNJU003 and DSNJU004
BACKUP and RESTORE SYSTEM

13. Operations (monitoring and controlling Db2)

Issuing Db2 commands
Basic workload controls
Monitoring and controlling utilities
DISPLAY commands
Starting / stopping databases

14. Recovery

Planning for recovery
Table space recovery
Log considerations
DISPLAY and SET LOG commands
Recovery considerations

15. System recover/restart

System checkpoints
System restart after normal shutdown
Page externalization
Two-phase commit processing
System restart after system failure
Recovery considerations

16. Java with Db2 (optional)

Java

17. Administrative task scheduler (optional)

Overview
Routines
Scheduling features
Life cycle
Syncronization
Commands

Audience

This course is intended for z/OS system administrators, database administrators, or other technical individuals who will be managing Db2 12 for z/OS.

Prerequisites

Understanding of the objects (such as databases, table spaces, tables, indexes, and so forth) used in a Db2 subsystem
Basic knowledge of SQL
At least one year as a z/OS systems programmer or equivalent knowledge
OR At least one year as a Db2 for z/OS Database Administrator

Certification

This course is not associated with any Certification.

Course Benefits

Career growth
Broad Career opportunities
Worldwide recognition from leaders
Up-to Date technical skills
Popular Certification Badges

IBM Popular Courses

1o276g

"IBM OpenPages: Create Standard Reports-Part 5" is a tutorial or instructional module that is likely part of a series on using the IBM OpenPages software. In th

6a302g

"IBM Safer Payments Hands-On Technical Primer Training (V6.3)" is an immersive and practical learning program designed to equip participants with the essential

6a322g

"IBM Safer Payments Hands-On SysOps Training (v6.3)" is a specialized and practical training program offered by IBM. This training focuses on educating System O

Enquire Now

u5wrXn

By clicking "Submit", I agree to the Terms Of Use and Privacy Policy

➤