TPFDF Database Administration
& Internals
Overview
This 3 day course is designed to build on existing knowledge of the
TPFDF product. The course includes a brief introduction to Data
Base Structures, Components and Terminology and is followed by a more
in depth study of the components of TPFDF such as DBDEFs, File
Algorithms, ZUDFM entries etc. The class includes frequent
exercises to reinforce knowledge gained during the lecture sessions.
NOTE – at this time
this class has not been updated for the z/TPFDF changes
Audience
Attendees should have a reasonable understanding of coding and testing
using TPFDF.
Student
Numbers
The
maximum recommended student to instructor ratio is 10:1
Objectives
By the end of the course, the delegates will be able, with the aid of
course notes to:
·
Code and update Database Definitions (DBDEFs).
·
List the available file algorithms.
·
Use ZUDFM entries to maintain and support database
administration.
·
Understand the internal concepts of TPFDF.
Course Outline
Introduction
|
Review
existing knowledge
Example programs
|
TPFDF
Interfaces
|
Original
Method
Dynamic SW00SR allocation
Database Interface Block (DBIFB)
SW00SR Layout.
|
Databases
|
Database
Design overview
Performance implications
File Organisation
Understanding TPFDF Algorithms
Index Files - how and why.
|
DBDEFs
|
Understanding
the DBDEFs
General Parameters
Default Keys
Index definitions
|
Miscellaneous
|
T-Types
Lrecs
Debugging Tips
TPFDF Dump Analysis
|
back to top
|