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

DateLocationDurationCostEnrolEnquiry
2022-10-03Virtual5 Days £1800.00 (plus VAT)
Enquire

Course Description


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