File Management Classes

	(FM050) Overview of File Concepts
	(FM100) File Design and Management
	(FM350) File Performance and Tuning

User Language Programming Classes

	(UL150) Introduction to User Language
	(UL200) Programmer's User Language
	(UL250) Implementing Online Applications
	(UL300) Application Development Techniques
	(UL350) User Language Performance & Tuning
	(UL400) Application Development and the Subsystem Facility
	(AP100) Application Subsystem Facility

System Management Classes

	(SM050) Overview of System Concepts
	(SM100) Introduction to System Management
	(SM120) Recovery and Enqueuing
	(SM160) Problem Determination and Resolution
	(SM350) System Performance and Tuning
Model 204 version 6.1.0 Upgrade Course
	(UP610) Model 204 version 6.1.0 Upgrade Course

File Management
(FM050) Overview of File Concepts	1 Day
Designed for Programmers, System Managers/Administrators, and anyone interested in receiving a short overview of Model 204 Files, this one-day course acquaints the student with the structures within a Model 204 file and their associated functions. Access methods for each internal table are covered, along with detailed descriptions of the information contained in each table. Students will better understand how the Model 204 physical file structure supports the operation of User Language. Learn how to: Assign field attributes and determine which fields should be indexed. Use Model 204 commands and User Language to find out more about your files. Set up file recovery and reorganization jobs and understand online Transaction BackOut (TBO).
(FM100) File Design and Management	4 Days
Designed for File or System Managers responsible for creating or maintaining files, the class walks students through the steps for creating a file using the File Management Facility of Dictionary. Also included are lectures about functional and representational field attributes, design considerations, space estimations, and file integrity. Learn how to: Design a Model 204 file from start to finish. Choose the appropriate file organization (such as hashed or order entry). Load and reorganize a file. Accurately size Tables A, B, C, and D to avoid reorganizing the file. Assign field attributes and determine which fields should be indexed. Create file groups. DUMP and RESTORE files.
(FM350) File Performance and Tuning	2 Days
Designed for File or System Managers who have taken the File Design and Management (FM100) class or the Introduction to System Management (SM100) class, this course emphasizes the aspects of file design and creation that affect application performance at the file level. It focuses on reducing physical I/O to Tables A, B, C, and D through appropriate parameter settings and field descriptions. Learn how to: Ý Reduce physical I/O to Tables A, B, C, and D. Control the number of buffers by setting CCAIN parameters. Enable the Look-Ahead Read feature (and learn what it affects). Implement File Scattering. Use groups to improve performance. Identify candidates for DASD Fast-Write. Monitor space utilization in Table B. Note: CCA recommends that you complete the following course before taking this class: File Design and Management (FM100) class or Introduction to System Management (SM100). Students are asked to bring listings containing the following command output from one of their database files: VIEW FPARMS; VIEW TABLES; VIEW OINODES, OIDEPTH, OILEAVES, OINYTES, OILPACT; TABLEB LIST of a representative set of pages; TABLEC or any utilization statistics for that file (from audit trail).
User Language Programming
(UL150) Introduction to User Language	3 Days
Designed for individuals who are new to Model 204, as well as new programmers or others who need to write ad hoc queries or understand prewritten procedures. Lectures combine information on Model 204 User Language syntax with discussions of common programming techniques such as branching and looping. Through classroom training and hands-on exercises, learn how to: Find out more about your data using Model 204 commands. Write requests using ranging and pattern matching without performing Table B scans. Format your reports using headers, sorted data, and ordered fields. Use variables for totals, averages, and accumulators. Access multiply-occurring field values using special syntax. Test conditions within your request and perform specific functions if the conditions are true. Read Model 204 error messages and debug your procedures.
(UL200) Programmer's User Language	5 Days
Designed for Programmers who need to write basic and advanced User Language procedures that access Model 204 data, the course begins with a discussion of internal file tables and the techniques used to access both the index and records within the file. In addition to examining basic User Language constructs, the course covers special facilities for screen management, modular program design, program-to-program communication, and controlling the online user's environment. Learn how to: Write efficient requests to avoid Table B scans. Write requests using ranging and pattern matching. Add, change, or delete fields and records. Perform string manipulation and convert dates using $functions. Pass data from one request to another or process data in non-Model 204 files using images. Use global variables to pass information from one request to another. Read Model 204 error messages and debug your procedures.
(UL250) Implementing Online Applications	4 Days*
Designed for Programmers who have completed the Programmer's User Language class and need to write or maintain an online system, this course focuses on designing and implementing full-screen applications in Model 204 User Language. Through a hands-on case study, students will learn how to: Control the program flow using a driver. Validate PFKEY usage. Handle multiple screens in the same request using global screens. Write code to add or update records via a screen. Maximize data sharing. Ensure data recovery if a system crash occurs. Design an application for use with the Application Subsystem Facility.
(UL300) Application Development Techniques	3 Days
Designed for programmers who have completed the Programmer’s User Language class and have at least three months User Language experience, this course focuses on implementing advanced User Language techniques and features that result in efficient structured programs. Topics include the effective use of images, arrays, lists, complex subroutines and ON UNITS. Learn how to: Modularize your procedures using subroutines Verify the syntax of code when performing pattern matching Write code that tells Model 204 what to do programmatically if one or more users or programs want to access the same record at the same time Write code using images to read or write data from or to an external or Model 204 file Create and maintain lists Use global screens and objects to pass large amounts of data between requests Efficiently test your code
(UL350) User Language Performance & Tuning	3 Days
Designed for experienced programmers who want to fine-tune their programming skills to write the most efficient code possible, the course covers the various file and system structures to consider when developing User Language procedures. Also covered is how to determine and monitor the actual efficiency level of a procedure. Learn how to: Examine the internal workings of coding structures to determine the most efficient programming approach Diagnose User Language performance problems Use tuning techniques and tools to optimize User Language code Write or revise applications to reduce overall CPU usage and disk I/O
(UL400) Application Development and the Subsystem Facility	5 Days
Designed for programmers who have taken UL200 - Programmer's User Language class and have subsequently been coding or maintaining User Language for at least three months. This class builds on and extends coding techniques covered in the UL200 class: IMAGES SCREENS FOR EACH VALUE (FRV) LISTS GLOBAL OBJECTS New techniques and features to write efficient structured programs will also be covered. In addition, this course will introduce the framework needed to maintain or develop full screen User Language applications that run under the control of the Application Subsystem Facility (APSY).
(AP100) Application Subsystem Facility	1 Day
Students will be able to identify the coding, operational, and performance considerations for designing and maintaining subsystems. Through hands-on sessions using an actual prototype, learn how to: Differentiate between what can be handled by APSY and what needs to be handled programmatically. Code LOGIN, ERROR and EXIT procedures. Create groups as APSY procedure files. Define a new subsystem. Define user classes and grant user privileges. Start, stop, test, debug, and monitor subsystems.
System Management
(SM050) Overview of System Concepts	1 Day

Designed for Programmers, File Managers, and anyone interested in receiving a short overview of the Model 204 system operation environment, this one-day course details the components of the Model 204 nucleus that handle scheduling, resource allocation, and system recovery. Students will acquire an understanding of how the Model 204 system operates to provide maximum throughput while performing all necessary system-level tasks. Learn about:

• User Roles in Model 204.
• Model 204 Online Configuration.
• System Recovery and Integrity.
• System Security.
• Controlling System Operations.

Intended for new System Managers, this course provides an overview of aspects of Model 204 that affect usage, performance, and integrity. Discussions of Model 204 system parameters and datasets are included, with an emphasis on those used for an online, multiuser job. Learn how to:
Calculate server sizes for maximum usability.

• Use and set server parameters.
• Monitor disk buffer allocation.
• Define the runtime environment (User 0 parameters) and user environment (I/O devices and servers).
• Control system operations (User 0).

Designed for System Managers who have completed the Introduction to System Management class (SM100), this course discusses in detail the recovery methods provided in Model 204. The class includes descriptions of how each method works, what is required to use it, and appropriate approaches for "real life" situations. Students will also learn about the different levels of enqueuing employed with Model 204. Learn how to:

• Run roll back-roll forward recovery (RESTART).
• Set applicable parameters for recovery.
• Interpret status and error messages.
• Identify situations requiring recovery.
• Develop a recovery scheme.
• Use commands to view enqueuing information.

Designed for System Managers who have completed the Introduction to System Management class and are responsible for or interested in security, this course gives a detailed description of Model 204 security features. Also discussed is how to use each feature alone and as part of an overall security scheme. Learn how to:

• Establish or change LOGIN privileges and account priorities
• Secure a file and change file passwords
• Set record security for APSY
• Control access to fields within a file
• Define security for a file group
• Restrict LOGIN, FILE, or GROUP passwords to specific user numbers
• Create subsystem security for APSY

Designed for System Managers, File Managers and DBA’s, this class discusses the tools and techniques for determining the nature of an operational problem. There is an in-depth discussion of the audit trial and the correct way to interpret it with several examples. The course covers reading and interpreting a snap dump, and how to determine when to forward a problem to CCA. Learn how to:

• Recognize, define and document a problem.
• Access and understand various sources of information.
• Auditing Information
• Subsystem Application Information
• Execute varied Model 204 utilities to help capture information.
• Use various methods and techniques to resolve problems.

Note: CCA recommends that you also complete the following course before taking this class: SM120 (Recovery and Enqueuing) and have knowledge of operating system concepts.

Designed for System Managers who have completed the Introduction to System Management class (SM100), this course explains how to identify performance problems in Model 204 and the host operating system. Lectures cover measuring and adjusting a Model 204 system using tuning techniques for both Model 204 and the operating system. Learn how to:

• Minimize disk I/0 using the Disk Buffer Monitor.
• Reduce server I/0 using the Resident QTBL.
• Ensure data integrity by monitoring the Record Locking Table.
• Accurately size the Resource Locking Table to avoid wasting memory and causing
  request cancellation.
• Monitor virtual storage use.

Note: CCA recommends that you also complete the following courses before taking this class: SM120 (Recovery and Enqueuing) and SM160 (Problem Determination and Resolution).
Students are asked to bring listings containing the following from their Model 204 online region: Audit Trail, CCAIN Stream, JCL Stream for MVS and IPS and ICS members from SYS1.PARMLIB.

This course is designed for programmers, system managers, and database administrators, and provides an overview of the new features within Model 204 version 6.1.0.