you are here : home/TPFDF Database Administration & Internals

Home   |   About Us   |   Contact Us   |   Links|   Customers   

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

pcs-training.co.uk by Cold Blaze Design 2000. All rights reserved.