Trending Courses

Vendors

Skip Navigation Links

Overview

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

What You'll Learn

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

Who Should Attend

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

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

Learning Journey

Coming Soon...

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

This course is not associated with any Certification.

Frequently Asked Questions (FAQs)

  • Why get IBM certified?

    IBM certifications validate your skills and expertise in a wide range of technologies, including hybrid cloud, data & AI, security, IT infrastructure, and business applications.

    These certifications are globally recognized and can help you advance your career, increase your earning potential, and demonstrate your commitment to professional development.

    IBM-certified professionals are in high demand, making them valuable assets to any organization seeking to leverage IBM's innovative solutions.

  • What to expect for the examination?

    IBM offers a variety of certification exams at different levels (Basic, Intermediate, and Advanced) covering various technologies and job roles.

    Exams typically consist of multiple-choice questions and may include scenario-based questions that assess your ability to apply your knowledge in real-world situations.

    Note: Certification requirements and policies may be updated by IBM from time to time. We apologize for any discrepancies; do get in touch with us if you have any questions.

  • How long is IBM certification valid for?

    The validity period of IBM certifications varies. Some certifications, particularly those focused on specific product versions or technologies, may have expiration dates.

    However, many IBM certifications, especially those focused on broader skills or newer technologies, do not have an expiration date.

    Note: Certification requirements and policies may be updated by IBM from time to time. We apologize for any discrepancies; do get in touch with us if you have any questions.

  • Why take this course with Trainocate?

    Here’s what sets us apart:

    - Global Reach, Localized Accessibility: Benefit from our geographically diverse training hubs in 16 countries (and counting!).

    - Top-Rated Instructors: Our team of subject matter experts (with high average CSAT and MTM scores) are passionate to help you accelerate your digital transformation.

    - Customized Training Solutions: Choose from on-site, virtual classrooms, or self-paced learning to fit your organization and individual needs.

    - Experiential Learning: Dive into interactive training with our curated lesson plans. Participate in hands-on labs, solve real-world challenges, and take on comprehensive assessments.

    - Learn From The Best: With 30+ authorized training partnerships and countless awards from Microsoft, AWS, Google – you're guaranteed learning from the industry's elite.

    - Your Bridge To Success: We provide up-to-date course materials, helpful exam guides, and dedicated support to validate your expertise and elevate your career.

Keep Exploring

Course Curriculum

Course Curriculum

Training Schedule

Training Schedule

Exam & Certification

Exam & Certification

FAQs

Frequently Asked Questions

img-improve-career.jpg

Improve yourself and your career by taking this course.

More Courses By IBM

Browse All Courses
es90g-advanced-parallel-sysplex-operations-and-recovery-workshop-training
System Z

Advanced Parallel Sysplex Operations and Recovery Workshop

ES90G - Advanced Parallel Sysplex Operations and Recovery Workshop
ILT VILT
Course Duration 5 Days
b6258g-ibm-cognos-analytics-author-reports-fundamentals-v11
IBM Analytics

IBM Cognos Analytics: Author Reports Fundamentals v11.1.x

This course provides authors with an introduction to build reports using Cognos Analytics.
ILT VILT
Course Duration 3 Days
esb3g-ibm-z-os-management-facility-implementation-and-use-2-1-training
System Z

IBM z/OS Management Facility Implementation and Use 2.1

This course is designed to provide you with the skills required to install and customize, and use the functions and features provided by z/OSMF.
ILT VILT
Course Duration 3 Days
img-get-info.jpg

Ready to Take Your Business from Great to Awesome?

Level-up by partnering with Trainocate. Get in touch today.

Name
Email
Phone
I'm inquiring for

Inquiry Details

By providing your contact details, you agree to our Privacy Policy.

Stay Connected. Be the first to Know.

Company

Vendors

Services

Customer Service

© Copyright Trainocate 2024. All rights reserved.