Db2 12 for z/OS Introduction to System Administration

IBM Training for Db2 12 for z/OS Introduction to System Administration

Skill Level: Basic

Modality: CR - Classroom based Trainng or ILO - Instructor Led Online Class

Duration: 3 Day/s

Starting Price: $ - 3,946

Overview:

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

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

Cyber Retaliator Solutions

CRS is the Top Global Training Provider for some of the world’s biggest brands.
Authorized Training delivered to you by the global leader in IBM Training.

Request a Quote

Target 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: _x000D_

Understanding of the objects (such as databases, table spaces, tables, indexes, and so forth) used in a Db2 subsystem

_x000D_

Basic knowledge of SQL

_x000D_

At least one year as a z/OS systems programmer or equivalent knowledge

_x000D_ _x000D_ _x000D_ OR_x000D_ _x000D_ _x000D_

At least one year as a Db2 for z/OS Database Administrator

_x000D_ .

Topic: 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 procredures 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

IBM Training

Objective: 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 procredures 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

Category: Data, Analytics, and AI

Product Name:

Db2 for z/OS

Badge and Certification Info:

Badge Title: Db2 12 for z/OS Introduction to System Administration - Code: CV853G

Badge ID: ddf0370c-7b4c-4aa4-991e-0793cc22c19e

Brand: Analytics

IBM Training is available now.

Cyber Retaliator Solutions (CRS) is a Cyber Security Distributor, Authorized IBM Training Center, Red Hat and SUSE Training Partner, and a CompTIA Training Delivery Partner, operating throughout the Globe. Our Head Office is in Centurion South Africa, with IBM Training Centers in Centurion, Midrand, Sandton, Cape Town, California CA, Florida FL, New York NY, Washington DC, Georgia GA, Texas TX.

CRS is the Top Global Training Provider for some of the world's biggest brands.

Authorized Training delivered to you by the global leader in IBM Training.

Select courses in:

IBM Cloud

DataPower

IBM Automation

IBM Rational

Watson

IBM Tivoli

IBM Systems

Cognos

IBM Storage

Mainframe

IBM Security

System Z

IBM Industry

IBM Asset Management

Websphere

IBM Data and AI

Get the Best IBM Training from CRS. As an IBM Training Provider, we've partnered with IBM through Arrow ECS to deliver training that covers the full portfolio of IBM systems and software.

Authorized IBM Training

RedHat Training

SUSE Training

Agile SAFe Training

Cyber Awareness Training

Cyber Security