Technologies / Data & Analytics

IBM Db2 13 for z/OS Basic Database Administration

This intensive three-day training course introduces novice database administrators (DBAs) to the world of Db2 13 for z/OS system management. The course focuses on the fundamentals of database administration, presenting key aspects of working with this powerful relational database management system. Participants will learn practical techniques for implementing a logical database design using the Data Definition Language (DDL), explore the creation and management of relational linked tables, and learn how to effectively use basic administration tools.

Issues

The training covers a wide range of topics related to the administration of Db2 13 for z/OS, including:

Db2 system architecture and its components
Management of database objects (tables, indexes, views)
Implementation and management of data integrity constraints
Use of Db2 administrative tools
Optimize database queries and performance
Security and entitlement management
Monitoring and control of the Db2 subsystem
Basics of data recovery and log management
Preparation and execution of programs in the Db2 environment

The course combines theory and practice, offering participants the opportunity to gain the practical skills necessary for the daily work of a Db2 for z/OS database administrator.

Benefits

Effectively manage the Db2 13 for z/OS system
Implement a logical database design using DDL
Create and manage relationally linked tables
Use the basic administrative tools of Db2
Optimize database performance
Implement security mechanisms in Db2
Understand and control the flow of programs in different environments
Monitor and control the Db2 subsystem
Perform basic data recovery operations

Who is this training for?

Beginner database administrators Db2 for z/OS

IT professionals who want to expand their knowledge of Db2 administration

Database application developers who want to understand the administrator's perspective

Systems analysts interested in the administrative aspects of Db2

Persons transitioning to positions related to the administration of Db2 for z/OS databases

Prerequisites

Familiarity with z/OS operating system, including TSO, ISPF and SDSF
Basic knowledge of SQL data manipulation instructions (SELECT, INSERT, UPDATE and DELETE)
General understanding of relational database concepts
Basic knowledge of programming

Training program

Relational database design
Data access
Interacting with Db2
Catalog and system catalog
SQL and SPUFI
Overview of SELECT statements
Overview of INSERT, UPDATE, DELETE statements
Overview of COMMIT and ROLLBACK statements
Joining tables
Executing SQL using SPUFI
Db2 objects (memory groups, databases and tablespaces)
Object concepts
Memory groups
Databases
Tablespaces
Db2 objects (Tables, indexes and views)
Tables
Aliases
Table constraints
Primary key
Foreign key
Checking
Referential integrity
Indexes
Views
Qualified names
Implicit object creation
Tools
Categories of tools
Load tool
Check Data tool
Unload tool
Runstats tool
Reorg tool
Commands and program preparation
Db2 command structure
Display command
Log archiving
Stop and Start commands
Executing commands
Preparing programs
Db2 system
System parameters (zParms)
Address spaces
System database
Buffer pools
Logging
Integrity
Security
Shutdown, Startup and Recovery of Db2
Start and Stop Commands
Db2 Shutdown Process
Db2 Startup Phases
System Recovery
Object Recovery
Copy Tool
Recover Tool

Delivery Methods

Online

Convenience of participating from anywhere
Interactive live sessions with trainer
Materials available for 30 days
No travel costs

On-site

Direct contact with trainer and group
Intensive hands-on workshops
Networking with other participants
Full focus on learning

Frequently asked questions

What are the prerequisites for this training?

For IBM Db2 13 for z/OS Basic Database Administration we recommend: Familiarity with z/OS operating system, including TSO, ISPF and SDSF; Basic knowledge of SQL data manipulation instructions (SELECT, INSERT, UPDATE and DELETE); General understanding of relational database concepts.

What is the format and duration of this training?

The training lasts 3 days and is available in online and on-site format. Sessions run from 9:00 AM to 4:00 PM. We can also customize the schedule to fit your team's needs.

Who is this training designed for?

This training is designed for: Beginner database administrators Db2 for z/OS; IT professionals who want to expand their knowledge of Db2 administration; Database application developers who want to understand the administrator's perspective.