Db2 12 for z/OS Basic Database Administration – CV844G

Course Name:

Db2 12 for z/OS Basic Database Administration

CV844G

Skill Level:

Basic

Modality:

ILO – Instructor Lead Online Training

Duration:

3 Day/s

Price:
Request Quote

Overview:

This course will expose the beginning z/OS DBAs (Database Administrators) to fundamentals of Database Administration for a Db2 12 for z/OS.

This course will expose the beginning z/OS DBAs (Database Administrators) to fundamentals of Database Administration for a Db2 12 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.


Enroll here

Please enable JavaScript in your browser to complete this form.
Email
Multiple Choice
How did you hear about us?
Yes, I would like to receive special offers from CRS.
Yes, I would like to receive special offers from CRS.


Target Audience:

    _x000D_

  • 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.
  • _x000D_

[List]

Prerequisites:

    _x000D_

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

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

Topic:

Preface

  • Course Overview
  • Intended Audience
  • Course Objectives
  • Prerequisites

 

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

 

Appendix A – Demonstration solutions

Objective:

Please refer to course overview

Remarks:

Prior to enrolling, IBM Employees must follow their Division/Department processes to obtain approval to attend this public training class. Failure to follow Division/Department approval processes may result in the IBM Employee being personally responsible for the class charges.

_x000D_
_x000D_

GBS practitioners that use the EViTA system for requesting external training should use that same process for this course. Go to the EViTA site to start this process:

_x000D_
_x000D_

http://w3.ibm.com/services/gbs/evita/BCSVTEnrl.nsf

_x000D_
_x000D_

Once you enroll in a GTP class, you will receive a confirmation letter that should show:

_x000D_
_x000D_

    _x000D_

  • The current GTP list price
  • _x000D_

  • The 20% discounted price available to IBMers. This is the price you will be invoiced for the class.
  • _x000D_

Category:

Data and AI

Product Name:

IBM Db2 Utilities Solution Pack for z/OS

Badge and Certification Info:

3894a4a5-09f7-467f-aa72-80870fe55300

Db2 12 for z/OS Basic Database Administration – Code: CV844G

https://www.CR – Classroom Trainingedly.com/org/ibm/badge/db2-12-for-z-os-basic-database-administration-code-cv844g

https://images.CR – Classroom Trainingedly.com/images/a8f2ef2b-2d49-4245-a945-38f68928c228/Db2_12_for_z_OS_Basic_Database_Administration_-_Code_-_CV844G.png

0

Brand: 

Analytics

Follow on Courses:

 

 

Replaced By:

z;z/os;db2;admin;dba

z – Plex & VM-2 (2)

Lab Access Duration:

 

CRS is the top Global Training Provider for some of the world’s biggest brands.

Call Now +27 12 023 1959