EncartaLabs

DB2 for z/OS - Database Administration

The DB2 for z/OS Database Administration - Essentials training course provides attendees with instruction on how to physically implement a logical database design in DB2. The course includes instruction on DB2 data management, DB2 catalog tables, the bind process, database utilities such as LOAD and REORG, and security considerations.

The DB2 for z/OS Database Administration - Advanced training course will introduce advanced database administration skills, including program preparation and the use of packages, online schema changes, partition management, and stored procedures; as well as performance and availability features of utilities (including LOAD, REBUILD INDEX, REORG, and UNLOAD).

By attending DB2 for z/OS Database Administration - Essentials workshop, attendees will learn to:

  • Implement a DB2 database design
  • Use database utilities to load and reorganize data
  • Define and implement a DB2 database recovery strategy
  • Control access to database using DB2 authorization facilities

For DB2 for z/OS Database Administration - Essentials

  • Design a relational table
  • Describe the SQL data manipulation statements to access and change the contents of DB2 tables

For DB2 for z/OS Database Administration - Advanced

  • Familiarity with the z/OS operating system, including TSO, ISPF, and SDSF.
  • Familiarity with SQL DML (SELECT, INSERT, UPDATE, DELETE, and MERGE) and DDL (CREATE, ALTER, DROP) statements
  • Basic skills administering a Db2 12 for z/OS database environment, including the use of basic utilities, serialization, and basic database security.

This course is for future DB2 for z/OS database administrators who need to acquire skills required to administer a DB2 database.

COURSE AGENDA

DB2 for z/OS Database Administration - Essentials
(Duration : 5 Days)

1

Setting up a DB2 database

2

Referential integrity

3

Getting data into and out of DB2

4

Keeping your DB2 data in good shape

5

Application data recovery basics

6

Program preparation and Bind

7

Security

8

Serialization

DB2 for z/OS Database Administration - Advanced
(Duration : 2 Days)

1

Program preparation and the use of packages part 1

  • Program preparation overview
  • Execution time errors
  • BIND actions
  • Package status and REBIND
  • Deleting a package
  • Determining the table/view qualifier
2

Online schema changes

  • Changing data type
  • Adding columns to a table
  • Renaming columns in a table
  • Renaming indexes
  • Adding columns to indexes
  • Versioning
  • Pending online schema changes
  • Dropping columns from a table
  • Converting to UTS
  • Other pending changes
  • Impact of pending changes on immediate options
  • Restrictions and considerations
3

Partition management

  • Modifying limit keys
  • Rebalancing partitions
4

Stored procedures part 1

  • External stored procedures
  • WLM-established application environments
  • Altering and dropping a stored procedure
  • Commands for stored procedures
  • Execution privileges
  • Catalog information
5

LOAD and REBUILD INDEX

  • LOAD with parallel index build
  • LOAD partitions in parallel
  • REBUILD INDEX
  • Inline image copies and statistics
  • LOAD SHRLEVEL CHANGE
  • LOAD REPLACE SHRLEVEL REFERENCE
6

REORG

  • Performance features of REORG
  • Online REORG
  • Inline image copies and statistics
  • Considerations for PBG table spaces
  • Online REORG with LOBs (optional)
7

UNLOAD

  • Overview
  • Image copy specification
  • Table-only input specification
  • SHRLEVEL option
  • Modes of operation
8

Program preparation and the use of packages part 2 (optional)

  • Table mirroring
  • Package versioning
  • Plan management
  • Other REBIND PACKAGE options
  • Application compatibility
9

Stored procedures part 2 (optional)

  • Native stored procedures
  • Native procedure deployment

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 4,000 Modules on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting http://encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top