Db2 12 for z/OS beginning DBAs can develop fundamental skills or recognition through lectures and hands-on exercises of:
TSO/E and ISPF
Data sets
Db2 Objects
Structured Query Language
Db2 Commands
JCL and SDSF
Db2 Utilities
Db2 Logging
Db2 Program Preparation
The course materials cover Db2 12 for z/OS
Obiettivi
Describe several services provided in a z/OS environment
Explain workloads in the batch environment
Explain workloads in the online environment
Describe job roles in a z/OS environment
Log On to TSO/E
Navigate TSO/E and ISPF
Use TSO commands
Setup and utilize JCL (Job Control Language)
Utilize SDSF
Describe the different types of data sets in a z/OS environment
Allocate data sets and list data set information and content
Create and modify data set content
Give an overview of the Db2 9 environment
Describe and utilize Db2 Objects
Describe and utilize several DB2 Utilities
Describe the Db2I (Db2 Interactive Facility) environment
Use SPUFI (SQL Processing Using File Input) to compose and execute SQL
Setup and execute Db2 Commands
Understand Db2 Logging
Describe Db2 program preparation process
Understand Db2 startup and shutdown
Understand and utilize Db2 recovery strategies
Destinatari
This beginning Db2 basic course is for z/OS database administrators who need to acquire the basic skills required to administer a Db2 database in a z/OS environment.
Contenuti
Unit 1 Introduction
The modern Mainframe Environment
Defining z/OS
What are the benefits of z/OS?
Typical z/OS workloads
Batch processing
Online Transaction Processing
Job roles in the Mainframe environment
z/OS Components and Services
UNIX System Services
The Parallel Sysplex Environment
z/OS Management Interfaces
Unit 2 TSO/E and ISPF
Emulators
z/VM systems
2.1. TSO/E
TSO Logon panel
Changing passwords
Additional logon panel options
The Reconnect option
TSO READY prompt
TSO HELP command
LISTALC command
PROFILE command
Changing PROFILE
LOGOFF command
Scripting support
2.2. ISPF
What is ISPF
ISPF command
ISPF Primary Option Menu
Primary Option Menu Areas
Action Bar
Options option
ISPF Settings
Global Color Change Utility
Function Keys
Option or Command Prompt
Keylist Utility
F3 Exit
F1 Help
F2 Split
ISPF Navigation Techniques
PFSHOW
More ISPF commands
Option listing
ISPF Command Shell
TSO Command Prefix
Unit 3 Data Sets
Data sets
Types of data sets
DASD versus Tape
Volumes
Storage allocation
Data set naming conventions
Catalogs
Storage Management
Checkpoint
3.2. Sequential Data Sets
Creating data sets
Utility Selection Panel
Data Set Utility Panel
Creating a data set
Allocate New Data Set
Creating a sequential data set
Editing a sequential data set
ISPF Editor
ISPF Editor primary commands
ISPF Editor line commands
Data Set List Utility
Data set name wild cards
Data Set List Utility
DSLIST results
Select Action
HELP on Line Commands
DSLIST by volume
3.3. Partitioned Data Sets
Partitioned data sets
Creating a PDS
PDS members
Creating a PDS member – Library Utility Panel
DSLIST Utility
PDS Member List
Member Actions
3.4. VSAM Data Sets
VSAM data sets
VSAM data set components
Creating a VSAM data set
Unit 4 JCL and SDSF
4.1. JCL
Batch Jobs versus Online Transactions
Batch job activities
Creating the batch job
JCL: Job Control Language
Statement format
JOB statement
EXEC statement
DD statement
Instream Input Data Set
Instream Output Data Set
DD DUMMY
Sample Jobstream 1
Sample Jobstream 2
Submitting the job
Notification
4.2. SDSF
SDSF
SDSF Primary Option Menu
Output and Held queues
PREFIX command
Working with queue query
Select command
? command
Canceling or Purging output
Sample jobstream 1 revisited
Sample jobstream 2 revisited
Unit 5 Db2 Relational Database Concepts
Relational Database Systems
Db2 for z/OS and Db2 family
The Db2 Optimizer
Benefits of Db2 for z/OS
Database
Tables
Indexes
Primary Key
Relationships
Referential Integrity
Integrity Rules
Data domains
Table scan access
Index access
Interacting with Db2
Transactions
UNIT 6 Structured Query Language (SQL) and SPUFI
Structured Query Language (SQL)
SQL categories
SELECT statement
SELECT list
FROM clause
Simple SELECT statement
SUBSTR function
SELECT with SUBSTR function
WHEREÂ clause
SELECT with WHERE clause
IN operator
WHERE with IN operator
BETWEEN operator
WHERE with BETWEEN operator
LIKE operator
WHERE with LIKE operator
ORDER BY clause
The NULL value
SELECT with ORDER BY
Putting it all together
Joining tables
Correlation Names
Additional criteria
Cartesian products
Executing SQL
SQLCODE
Unit 7 Db2 Objects
7.1. Databases and Table Spaces
Db2 objects
The Db2 catalog
Storage group
Database
Table Space
Segmented table space
Partitioned table space
Partition By Growth table space
Partition By Range table space
VSAM data sets
7.2. Tables, Indexes and Views
Table
Partitioned table
Index
Clustering index
Index space
Partitioned index
View
7.3. Qualified names, Implicit Object Creation, and SQL statements