EncartaLabs

DB2 for zOS - System Administration

( Duration: 5 Days )

In DB2 for zOS System Administration training course, attendees will acquire a view of the architecture and fundamental processes required to manage DB2 for z/OS subsystem.

By attending DB2 for zOS System Administration workshop, attendees will learn to:

  • Relate the z/OS IPL process to a DB2 subsystem
  • Explain effects of stopping and starting DB2
  • Explain how DB2 sets and use Integrated Catalog Facility (ICF) catalog names
  • The use of DSN command processor running in batch and foreground
  • Use views to minimize users' ability to see into the DB2 catalog
  • See how the catalog (through grant activity) controls access to data
  • Search the catalog for problem situations
  • Use the catalog and DB2 utilities to determine data recovery requirements
  • Describe Internal Resource Lock Manager (IRLM) in a DB2 environment
  • Implement DB2 and Resource Access Control Facility (RACF) security
  • Describe DB2 program flow for all environments
  • Display normal and problem threads and database status
  • See how the SQL Processor Using File Input (SPUFI) AUTOCOMMIT option defers the COMMIT/ROLLBACK decision
  • Interpret lock displays
  • Identify and cancel particular threads
  • Describe available DB2 utilities to manage system and user page sets

  • An understanding of the objects (tables, indexes, databases, and so forth) used in DB2 systems, and of how those objects are created, managed, and recovered
  • Working knowledge of SQL
  • At least one year as a z/OS systems programmer experience Or, one year working with DB2 on the mainframe as a DBA on the mainframe or equivalent experience

This course is for System Administrators, Database Administrators.

COURSE AGENDA

1

Start and stop the DB2 subsystem

2

Explain the allocation CLIST used at logon for DB2 data sets

3

Use Set SYSPARM command

4

Locate the Command recognition character for the DB2 subsystem

5

Query the system log to gain knowledge about the IPL process and information in the system log when DB2 is initialized or stopped

6

Explore DB2 Address Spaces information

7

Select the DB2 functions that best satisfy Their site requirements

8

Explain the use of RACF for DB2 connection security

9

Explain the use of Roles and Trusted Context

10

Implement security procedures for a DB2 environment

11

Describe the components and address space structure of a DB2 subsystem

12

Explain DB2 Program Flow for all environments

13

Invoke and use DB2 TSO Facilities

14

Use the DB2 Catalog to monitor authorizations

15

Increase the size of the Active Log data sets

16

Explain DB2 Logging

17

Use SET LOG SUSPEND and SET LOG RESUME

18

Use DSNJU004 to Print Log Map

19

Interpret the output of the Print Log Map Utility DSNJU004

20

Use DSNJU003 to rename DB2 data sets

21

Plan for recovery of a BSDS failure

22

Monitor and control DB2

23

Explain transaction flow in IMS and CICS

24

Describe the CICS and DB2 environment

25

Make use and inplement the extended 10-byte RBA and LRSN

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