Cours: DB2 9 pour z/OS : Formation pour la production

z/OS and DB2 Basics for DB2 for z/OS DBA Beginners will help beginning DBAs develop fundamental z/OS and DB2 for z/OS skills through lectures and hands-on labs in the areas of:

• z/OS
• TSO/E and ISPF
• Data sets
• JCL and SDSF
• DB2 Objects
• Structured Query Language
• DB2 Commands
• DB2 Utilities
• DB2 Logging
• DB2 Program Preparation

Voir ce cours dans d'autres pays

Schémas de filière:

• DB2 pour z/OS

Début

This advanced course is for beginning DB2 for z/OS database administrators who need to acquire the basic skills required to administer a DB2 database in a z/OS environment.

Début

You should be able to:

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

Début

• Tell some services provided in a z/OS environment
• Log On to TSO/E
• Navigate TSO/E and ISPF
• Use SDSF (SYSLOG Display and Search Facility)
• Give an overview of the DB2 9 environment
• Describe DB2 Objects
• Describe and use some DB2 Utilities
• Describe the DB2I (DB2 Interactive Facility) environment
• Setup and execute DB2 Commands from DB2I (DB2 Interactive Facility)
• Describe DB2 Logging
• Explain workloads in the batch environment
• Explain workloads in the online environment
• Describe job roles in a z/OS environment
• Use SPUFI (SQL Processing Using File Input) to compose and execute SQL
• Setup and use JCL (Job Control Language) to administer DB2 9 databases
• Describe the different types of data sets in a z/OS environment
• Use ISPF utilities to allocate a data set and list data set information and content
• Create and modify data set content
• Compare volume and logical partitions
• Describe DB2 program preparation process
• Use TSO commands

Début

Introduction

• List some benefits of z/OS
• Describe typical mainframe workloads
• Tell typical batch applications
• Explain online transaction processing
• Report job roles in the Mainframe environment

TSO/E and ISPF

• Invoke TSO from a desktop using IBM Personal Communications (PCOMM)
• Explain TSO Logon parameters
• Invoke ISPF from TSO
• Explain ISPF Primary options
• Swap screens within ISPF
• Customize ISPF

Data Sets (Part 1)

• Allocate a sequential data set
• Allocate a partitioned data set
• Describe a VSAM data set
• Maintain a sequential data set
• Maintain members of a partition data set
• Use ISPF Data Set List Utility

Introduction and Concepts

• List some benefits of using DB2
• Describe the structure of a DB2 table
• Give some rules for a relational data model
• State DB2 delete rules for referential integrity

Structured Query Language (SQL)

• Communicate the components of the SQL language
• Describe four SELECT statement clauses (SELECT, FROM, WHERE, ORDER BY) and their purpose
• Retrieve all rows of a table
• Retrieve specific columns
• Retrieve rows based on comparisons to numeric or alphanumeric column values
• Use the keywords BETWEEN, IN, LIKE, DISTINCT
• Order the resulting rows in a desired sequence
• Use some of the DB2I facilities to communicate with DB2

DB2 Objects

• Relate DB2 objects and their properties
• Create DB2 objects
• Explain DB2 object dependencies

Data Sets (Part 2)

• Define the acronyms:
  • VSAM
  • KSDS
  • ESDS
  • LDS
  • BSDS

• Describe a VSAM Cluster
• Explain VSAM Cluster definition syntax for a KSDS

DB2 Overview

• Identify Z/OS Allied Address Spaces
• Describe DB2 address space functions
• Explain the function of the IRLM (Internal Resource Lock Manager)
• Interact with the DB2 catalog
• Describe the DB2 Directory

DB2 Commands

• Relate ways to issue DB2 commands
• Identify the syntax of a DB2 command
• Demonstrate commands:
  • DISPLAY DATABASE
  • DISPLAY THREAD
  • DISPLAY UTILITY
  • DISPLAY GROUP
  • DISPLAY LOG
  • START DATABASE
  • STOP DATABASE
  • TERM UTILITY
  • ARCHIVE LOG
  • CANCEL THREAD
  • SET SYSPARM

JCL and SDSF

• Describe JCL-related activities
• Write JCL - Basic statements
• Make use of some SDSF options

Utilities

• Categorize DB2 utilities:
  • Online
  • Standalone
  • Service aids and samples

• Explain the sequence of the Load utility
• Explain the sequence of the DB2 Image copy
• Communicate with DB2 online utilities

DB2 Logging

• Explain at a high-level the DB2 logging process
• Relate the interaction of archive/active logs and the BSDS
• Recite the contents of the BSDS

Shutting down and Restarting the DB2

• Explain two-phase commit processing
• Relate the DB2 Restart phases

DB2 Program Preparation

• Explain the program preparation steps
• Explain:
  • DBRM
  • PLAN
  • PACKAGE

• Difference between BIND and REBIND

Agenda

Day 1

• Welcome
• Unit 1: Introduction
• Exercise 1
• Unit 2: TSO/E and ISPF
• Exercise 2
• Unit 3: Data Sets (Part 1)
• Exercise 3
• Unit 4: Introduction and Concepts

Day 2

• Exercise 4
• Unit 5: Structured Query Language (SQL)
• Exercise 5
• Exercise 6
• Unit 6: DB2 Objects
• Unit 7: Data Sets (Part 2)
• Exercise 7

Day 3

• Unit 8: DB2 Overview
• Exercise 8
• Unit 9: DB2 Commands
• Exercise 9
• Unit 10: JCL and SDSF

Day 4

• Exercise 10
• Unit 11: Utilities
• Exercise 11
• Exercise 12
• Exercise 13
• Exercise 14

Day 5

• Unit 12: DB2 Logging
• Unit 13: Shutting down and Restarting the DB2
• Unit 14: DB2 Program Preparation

Début