BT16 - Introduction to the IBM Mainframe and DB2 - 5 Days

Course Description

The course provides technical and non technical personnel with an overview of IT tools, terminology, methodology and techniques used on the IBM Mainframe. It contains lectures and demonstrations to ensure a brief familiarity with the range of products and tools available.

The course also covers the usage of TSO/ISPF and includes ISPF options such as Dataset Allocation, Editing, Browsing, Copying etc. using practical exercises to build the students knowledge.

Job Control Language is used to execute simple jobs on the z/OS platform which copy, extract and sort data.

Finally, the course introduces the delegate to the IBM DB2 database, covering all SQL statements required to read, manipulate and join a DB2 table.

Pre-requisites

None.

Objectives

Whilst covering the basics of TSO/ISPF and JCL and how it is used, this course also aims to give an insight into manipulating data and datasets, writing and testing JCL. The delegate will also be given an introduction to DB2 and SQL.

On completion of this course the student will be able to:

  • Navigate ISPF screens to perform a variety of tasks
  • Use the correct options to create datasets
  • Use the correct options and commands to edit data within a dataset
  • Use the correct options to perform various utility functions
  • Understand and code a valid JCL JOB statement
  • Understand, code and execute simple JCL jobs
  • Understand, code and execute JCL using Generation Data Groups
  • Understand, code and execute JCL in-stream and catalogued procedures using symbolic variables
  • Understand, code and execute JCL dynamically overriding JCL parameters
  • Understand, code and execute JCL using JCLLIB, INCLUDE and SET Statements
  • understand how DB2 tables are defined
  • describe the data types available when defining DB2 columns
  • describe the importance of an Index for certain queries
  • use DB2I and SPUFI
  • write SELECT, UPDATE, DELETE and INSERT SQL statements
  • join tables together
  • use inner joins and outer joins

Environment

Development will be performed using:

  • IBM Mainframe
  • DB2 for z/OS

Customisation

For on-site courses (i.e. at your premises), we are more than happy to tailor the course agenda to suit your exact requirements. In many cases, we are able to build your in-house standards and naming conventions into the delivered course.

Course Details

INTRODUCTION TO TSO / ISPF
Introduction To Program Development
TSO
Interactive System Productivity Facility - ISPF

LOGGING ON / OFF
Logging On
Logging Off - Option X
Log and List Datasets

ISPF NAVIGATION & COMMANDS
ISPF Main Menu
Command & Option Line
Fastpath
ISPF Primary Commands
Help
Split
Split New
Swap Next/Prev/n
Swap List
Swapbar
End
Return
Rfind
Rchange
Up
Down
Right
Left
Retrieve
Nretriev
Settings
Userid
Sysname
Sarea
Keys
Programmable Function Keys
Autotype

STORAGE OF DATA
Data Storage
Disk Drive
Tapes
Cartridges
Datasets
Sequential Dataset
Partitioned Dataset (PDS) - Libraries
Other Dataset Types
Storage Management Subsystem

DATASET PROCESSING
Dataset Allocation – ISPF Option 3.2
Dataset Allocation Parameters
Dataset Name Entry
Member Name Entry
No Member Name Entry
Partial Member Name Entry
Multi-Part Dataset Names
Member Lists
Locate Command
Sort Command
Filter Command
Dataset Browse/View – ISPF Option 1
View A Dataset
Changing the Encoding Scheme
Dataset Edit – ISPF Option 2

EDITING A DATASET
Editing a Dataset – Line Commands
Insert
Repeat
Delete
Copy
Move
After and Before
Overlay
Multiple Targets for MOVE / COPY Operations
Exclude
Shift Data
Lower and Upper Case
Text Commands
Cols
Mask
Bnd
Hex
Editing a Dataset – Primary Commands
Find
Change
Exclude
Flip
Del
Sort
Copy
Move
Create
Replace
Cut and Paste
Profile
Number On/Off
Unnum
Bnds
Autosave On/Off
Reset
Cancel
Max
Submit
Hex On/Off
Hilite
Recovery On
Undo
Caps On/Off
Nulls On/Off
Renum
Tabs
Compare
Display
Model
Editing / Browsing a Dataset - Scroll Commands
Edit Labels and Line Ranges
File-AID

LIBRARY – OPTION 3.1
Library Utility
Member List
Compress
Index Listing
Print Dataset or Member
Dataset Information
Edit Member

VSAM UTILITIES – OPTION 3.2V
VSAM Utilities
VSAM File - Define
GDG – Display Information

MOVE & COPY – OPTION 3.3
Move/Copy Data

DATASET LIST – OPTION 3.4
Dataset List
Dataset List Options
Recent New Features
VTOC Information
Dataset Views
Referral Lists

COMPARE – OPTION 3.12/13
Dataset Comparison

SEARCH – OPTION 3.14/15
Dataset Search

MISC
TSO Commands
List Dataset - Listalc
List User - LU

FILE MANAGER
File Manager Overview
Browsing and Editing Data
Copybook Templates

INTRODUCTION TO JCL
Job Control Language
Job Control Language Terminology
JCL Statements

JOB STATEMENT
Job Statement
Job Operands
Job Account / Accounting Information
Programmer Name
Class
Msgclass
Msglevel
Notify
Typrun
Perform
Prty
Region
Time
Bytes And Lines
Cards
Pages
User
Group
Password
Restart

EXEC STATEMENT
Exec Statement
Exec Operands
PGM & Proc
Parm
Time & Region
Acct
Cond
If / Else Condition Code Testing

DD STATEMENT
DD Statement
DD Operands
DDNames
Dsname or Dsn
Reserved DDNames
Disp
Space
DCB
Lrecl, Recfm and BLKSIZE
Volume
Label
Unit
Expdt
Retpd
Temporary Datasets
Refer Back
JCL Modifications When Using SMS
SMS Parameter
Dataclas
Mgmtclas
Storclas
Avgrec
Dsntype

OTHER JCL STATEMENTS
Statement Continuation
Comments
Delimiter
The NULL Statement
Dataset Concatenation

SPECIAL DD NAMES
Sysin DD Name
Sysout DD Name
Joblib/Steplib
Sysudump, Sysabend, Sysabout and Sysdbout
Sysmdump

SPECIAL DATASETS
In-Stream Dataset / Delimiters
Data Dataset Name
Print and Punch Datasets - Sysout
Sysout Dataset
Copies
Dest
Fcb
Hold
Outlim
Output
DUMMY Dataset
Nullfile Dataset

GENERATION DATA GROUPS
GDG Overview
GDG Base Entries - Create
GDG Base Entries - Delete
Referring To GDGS
Model DSCB

PROCEDURES AND INCLUDES
Procedures
In-Stream Procedures
Cataloged Procedures
Locating Cataloged Procedures - Jcllib Statement
Dynamically Modifying Procedures - Overriding
Symbolic Variables
Sysuid Variable
Include Statement
Set Statement

JES STATEMENTS
Jes2 Commands
Jes3 Commands
Jes Statements in JCL
Jobparm Statement
QUEUE Keyword
AFTER Keyword
CARDS Keyword
Lines Keyword
TAPES Keyword
OUTPUT Statement
ROUTE Statement
Message Statement
Priority Statement

IEBGENER
Purpose
IEBGENER Copy
IEBGENER JCL Statements
IEBGENER Control Statements
Generate
Changing The Blocksize Of A Dataset
Creating Different PDS Members From One Source
Reformatting Records

IEFBR14
IEFBR14

SORT
Purpose
Sort
Merge
Copy
Sort JCL Statements
Sort Work Files
Allocating Sort Work Files
Improving Sort Performance
Sort Control Statements Format
Sort Control Statements
Altseq
Debug
End
Include/Omit
Inrec/Outrec
Merge
Mods
Option
Record
Sort
Sum
Sorting Files

SDSF
SDSF
Console Messages
Jes Job Statistics
JCL Listing
Allocation/Termination Messages
SDSF Access
Primary Menu
Input Queue
Active Jobs
Held Output Queue
Output Queue
Status
Job Selection
Job Filtering
Pre Command
Owner Command

INTRODUCTION TO DB2
The Relational Model
Data Representation
The DB2 Environment
Data Definition Language
The DB2 Table
Column Types
INTEGER
SMALLINT
CHAR
VARCHAR
DATE
DATE formats
TIME
TIMESTAMP
Null Values
Default Values
Indexes
Index Columns
Tablespace scan vs. Index access

DB2 INTERACTIVE (DB2I)
DB2I Options
SPUFI - SQL Processor Using File Input
Running Queries
SPUFI Defaults
SPUFI - Setting AUTOCOMMIT to NO
DB2 Commands
DB2 Utilities
The DB2I Defaults Panel

DATA MANIPULATION LANGUAGE
SQL - Structured Query Language
DB2 Environments
SQL Features
SQL Query Results
The Select Statement
The xxAsxx Clause
The Where Clause
Special Operators
Not Operand
In Operand
Like Operand
Between Operand
Statements Using Nulls
Is Not Distinct From
Column Functions
Using xxDistinctxx
Multiple Distinct
Group By Clause
Expressions / Functions in Group By
Having Clause
Order By Clause
Fetch First xxnxx Rows Only Clause
Special Registers (Date, Time, Timestamp And User)
Current Date
Current Time
Current Timestamp
User Keyword
The Update Statement
Update with Subselect
The Delete Statement
The Insert Statement
The Mass Insert Statement
Select from Insert
Select from Merge
Select from Update
Select from Delete
Scalar Functions
Function Examples
Date, Time And Timestamp Functions
The Case Statement
Table Join
Outer Joins
Outer Join Syntax
Joining More Than 2 Tables (using Newer Syntax)
Outer Join - Where Clause

Course Enquiry