Skip to main Content

Db2 13 for z/OS Basic Database Administration

  • Course Code CV845G
  • Duration 3 days

Course Delivery

Company Event Price

Please call

Request Group Training Add to Cart

Jump to:

Course Delivery

This course is available in the following formats:

  • Company Event

    Event at company

  • Virtual Learning

    Learning that is virtual

Request this course in a different delivery format.

Course Overview

Top
This course will expose the beginning z/OS DBAs (Database Administrators) to fundamentals of Database Administration for a Db2 13 for z/OS. This course will teach the students how to physically implement a logical database design using DDL, and teaches considerations of referentially related tables. This course discusses the use of basic utilities, program preparation, serialization, and basic database security. This course does not cover distributed data processing, nor does it cover data sharing.

Company Events

These events can be delivered exclusively for your company at our locations or yours, specifically for your delegates and your needs. The Company Events can be tailored or standard course deliveries.

Course Schedule

Top

Contact us for dates

Request Group Training Dates in Other Countries

Target Audience

Top
Students who will be performing the role of Db2 for z/OS database administrators who need to acquire the basic skills required to administer a Db2 database.
Show me more

Course Objectives

Top

Unit 1 - Db2 Relational database concepts

  • Relational Database design
  • Data access
  • Interacting with Db2• Catalog and directory

 Unit 2 - SQL and SPUFI

  • SQL SELECT statement review
  • SQL INSERT, UPDATE, DELETE review
  • SQL COMMIT and ROLLBACK review
  • Joining tables
  • Executing SQL using SPUFI

Unit 3 - Db2 objects (Storage groups, databases, and table spaces)

  • Object concepts
  • Storage Groups
  • Databases
  • Table Spaces

Unit 4 - Db2 Objects

  • Tables
  • Indexes
  • Views

 Unit 5 - Utilities

  • Utility Categories
  • Load Utility
  • Check Data Utility
  • Unload Utility
  • Runstats Utility
  • Reorg Utility

Unit 6 - Commands and program preparation

  • Db2 Command Structure
  • Display Command
  • Archiving Logs
  • Stop and Start Commands
  • Executing Commands
  • Program Preparation

Unit 7 - The Db2 system

  • System Parameters (zParms)
  • Address Spaces
  • System Databases
  • Buffer Pools
  • Logging
  • Integrity
  • Security

Unit 8 - Db2 Shutdown, startup, and recovery

  • Start and Stop Commands
  • Db2 Shutdown Process
  • Db2 Startup Phases
  • System Recovery
  • Object Recovery
  • Copy Utility
  • Recover Utility
Show me more

Course Prerequisites

Top
  • 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
Show me more

We Care About Your Privacy

We are using cookies to give you the best experience on our site. Cookies are files stored in your browser and are used by most websites to help personalise your web experience. By continuing to use our website without changing the settings, you are agreeing to our use of cookies.

About your Privacy

We process your data for purposes such as delivering content or advertisements and measuring the delivery of such content or advertisements to extract insights about our website. We may share this information with our partners. Cookies set by Global Knowledge are labelled “first party”; you may exercise your preferences in relation to first party cookies by toggling the switch for each first party cookie category below. The remaining cookies are third party cookies; you may exercise your preferences in relation to each purpose by toggling the relevant switch below or by vendor by clicking “List of IAB Vendors.” These choices will be signaled globally to other websites participating in the Transparency and Consent Framework.
Privacy Statement

Necessary Cookies

These are cookies that are required for the Global Knowledge website to function and cannot be switched off in our systems. They include, for example, cookies that enable you to use a shopping cart or log into the booking area of our website.

Analytics Cookies

Analytics cookies are an optional but important part of our website's functionality. They help us to understand how you interact with our site by collecting and reporting information anonymously. The data collected by analytics cookies is used to improve the website's performance and enhance the user experience. It is important to note that these cookies do not collect any personal information that can be used to identify you.

Preferences Cookies

The preference cookies are used to track visitors across websites with the intention to display ads that are relevant and engaging to your interests.

Performance Cookies

These cookies allow us to recognise and count the number of visitors to our website, traffic sources and to see how website visitors move around the website when they are using it. This helps us to improve the way the website works and improve your website experience. All information these cookies collect is aggregated and therefore anonymous.

Marketing Cookies

Marketing cookies help us understand how visitors interact with our website. Should you grant consent for marketing purposes, this information will be used for general marketing analysis — allowing us to measure the effectiveness of our campaigns, better understand our audience, and improve the content and offers we provide. These cookies are not essential to the website’s function, and you may withdraw or amend your consent at any time through our cookie settings.

Cookie Control toggle icon