Virtual Instructor-Led Training

Onsite Training

Database Administrator

Db2 13 for z/OS Basic Database Administration (CV845G)

AI & Data

Innovation

Vendor Neutral - Technical

<ul><li>Relational Database design</li><li>Data access</li><li>Interacting with Db2• Catalog and directory</li></ul>

Db2 Relational database concepts

<ul><li>SQL SELECT statement review</li><li>SQL INSERT, UPDATE, DELETE review</li><li>SQL COMMIT and ROLLBACK review</li><li>Joining tables</li><li>Executing SQL using SPUFI</li></ul>

SQL and SPUFI

<ul><li>Object concepts</li><li>Storage Groups</li><li>Databases</li><li>Table Spaces</li></ul>

Db2 objects (Storage groups, databases, and table spaces)

<ul><li>Tables</li><li>Indexes</li><li>Views</li></ul>

Db2 Objects

<ul><li>Utility Categories</li><li>Load Utility</li><li>Check Data Utility</li><li>Unload Utility</li><li>Runstats Utility</li><li>Reorg Utility</li></ul>

Utilities

<ul><li>Db2 Command Structure</li><li>Display Command</li><li>Archiving Logs</li><li>Stop and Start Commands</li><li>Executing Commands</li><li>Program Preparation</li></ul>

Commands and program preparation

<ul><li>System Parameters (zParms)</li><li>Address Spaces</li><li>System Databases</li><li>Buffer Pools</li><li>Logging</li><li>Integrity</li><li>Security</li></ul>

The Db2 system

<ul><li>Start and Stop Commands</li><li>Db2 Shutdown Process</li><li>Db2 Startup Phases</li><li>System Recovery</li><li>Object Recovery</li><li>Copy Utility</li><li>Recover Utility</li></ul>

Db2 Shutdown, startup, and recovery

Familiarity with the z/OS operating system, including TSO, ISPF, and SDSF

Familiarity with SQL data manipulation statements (SELECT, INSERT, UPDATE, and DELETE) to access and change the contents of Db2 tables

courseBanner

Course Banner

courseOverview

Course Overview section

courseAnnouncement

Additional information.

courseDetails

What you will learn

targetAudience

Who should attend

courseOutline

Course Outline

courseFAQ

Coursepromobanner

Course Promobanner Section

courseRelatedTargets

Course Related Targets

courseTicker

Course Ticker

preRequisites

Prerequisites

course_related_links

courseTestimonials

Customer Testimonials

courseLocations

Find More Locations by NetCom Learning For This Training

For Your convenience we are offering This course at more locations. Expand your training options and accelerate your learning journey with NetCom.

Learn the fundamentals of Db2 13 for z/OS database administration, including database design, SQL operations, utilities, program preparation, and recovery processes.

Db2 13 for z/OS Basic Database Administration Course

A Database Administrator assists with the administration and management of database management systems and with the creation and management of databases, database performance, monitoring, tuning and capacity planning.

Microsoft

AI CERTs™

Google Cloud

Cisco

Amazon Web Services

CompTIA

EC-Council

ISC2

ITIL

Autodesk

Cloud

Security

Networking

App Development

Architecture & Design

Business Applications

Business Process

Business & Leadership

e-Learning

Trainings

Managed Learning Services

NetCom365

Learning Passport

EdAssist

Talents for Hire

NetCom Learning Academy

AI Summer Skill Fest 2025

Financial Services

Healthcare

Federal Government

State & Local Government

Technology

Complimentary AI+ Foundation™ Training

Free AI Training Consultation

AI Certs Training Bundles

CompTIA Continuing Education (CE)

CompTIA Exam Prep e-Learning Bundles

Microsoft ECIF Program

Microsoft QuickStart Program

Microsoft Partner Training

Microsoft AI Bootcamp for Educators

Microsoft Applied Skills

AWS Skill Builder

AWS Blended Learning

AWS Learning Needs Analysis (LNA)

AWS e-Learning

Cisco Continuing Education (CE)

Cisco Learning Credits

Cisco U

Free Networking Training Consultation

Google Cloud Leadership AI Training

Solutions

Resources

Company