Arrow ECS Training

      Db2 12 for z/OS Basic Database Administration

      Arrow ECS Training
      In London

      Price on request
      Prefer to call the centre directly?
      08702... More
      Want to speak to an Advisor about this course?

      Important information

      Typology Course
      Location London
      Duration 3 Days
      • Course
      • London
      • Duration:
        3 Days

      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.

      Facilities (1)
      Where and when
      Starts Location
      On request
      Arrow Ecs Training, 56433, London, England
      See map
      Starts On request
      Arrow Ecs Training, 56433, London, England
      See map

      To take into account

      · What are the objectives of this course?

      Please refer to course overview

      · Who is it intended for?

      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.

      · Requirements

      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

      Questions & Answers

      Ask a question and other users will answer you

      What you'll learn on the course

      Database Design
      Database Administration
      Database training

      Course programme

      • 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 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, and views)
      • Tables
      o Aliases
      • Table constraints
      o Primary key
      o Foreign key
      o Check
      o Referential integrity
      • Indexes
      • Views
      • Qualified names
      • Implicit object creation

      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

      Compare to choose better:
      See all