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.
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
