Module 1: Pathway introduction

• Online transaction processing (OLTP) in the NonStop server environment
• The requester-server approach to online transaction processing
• Pathway application and its role in online transaction processing
• Components of a Pathway environment
• Starting PATHMON and PATHCOM
• Client/server options available in the Pathway environment

Module 2: Pathway configuration and operation

• Difference between global and object-specific configuration parameters
• Configuring global and object-specific parameters
• Cold starting and cool starting a Pathway system
• Starting the Pathway objects individually
• Monitoring and maintaining a Pathway system
• Shutting down a Pathway system
• Capturing the current Pathway environment
• Lab Exercise (30 minutes): Starting a Pathway System
• Establish your individual lab environment
• Start and stop a Pathway application environment
• Lab Exercise (1 hour): Configuring a Pathway System—leads you through the series of commands to create, start, and exit from a Pathway application environment
• Configure Pathway TCP, TERM, PROGRAM, and SERVER objects
• Display Pathway object attributes and information
• Shut down a Pathway application environment
• Lab Exercise (1 hour): Managing and Monitoring a Pathway System
• Use a series of commands to manage and monitor a Pathway application environment
• Practice the steps to capture the current configuration

Module 3: Server fundamentals

• Requester-server model
• Basic function of a server
• Function of $RECEIVE in interprocess communication
• Steps that make up the basic structure of a server program
• Why servers should be context-free
• Recognizing and addressing the problems with concurrent database access by servers
• Coding the Guardian procedures for server message processing
• Differences between application messages and system messages

Module 4: Inspect debugging

• Basic syntax and use of the more common Inspect commands for debugging C programs
• Components of the Inspect debugging environment
• Steps required to debug a stand-alone process
• Steps necessary to debug a Pathway server

Module 5: Enscribe database access

Module 6: NonStop SQL database access

• Use of NonStop SQL statements to insert, update, and delete rows in an SQL database
• Identifying and defining host variables
• Operation of a cursor
• Writing statements to report SQL run-time errors
• Process involved in building a C program with embedded SQL statements
• Lab Exercise (2 hours): Locate Vehicle (Enscribe and SQL)
• Code a server to access either an Enscribe or an SQL database to fetch records
• Use Guardian procedures to access an Enscribe database
• Use SQL statements for cursor handling in SQL database access
• Lab Exercise (2 hours): New Vehicle (Enscribe and SQL)
• Code a server to access either an Enscribe or an SQL database to perform updates
• Use Guardian procedures to perform record positioning and insertion in an Enscribe database
• Use SQL statements to fetch and insert rows in an SQL database

Module 7: NonStop Transaction Services/MP (TS/MP) programming

• Major components that make up the NonStop TS/MP environment
• Pathsend environment and the capabilities of a Pathsend requester
• Coding the Pathsend procedures
• Coding nowait Pathsend operations
• Design considerations in using the Pathsend facility
• NonStop TS/MP server design considerations

Module 8: Data integrity and application availability threats to data integrity

• Guardian procedure calls that ensure database integrity through the TM/MP subsystem
• Writing Guardian procedure calls to invoke services from the TM/MP subsystem
• Use of the TS/MP subsystem to provide for continuous availability of processes
• Lab Exercise (1 hour): Pathsend Lab
• Code the Pathsend procedure to submit a request to a Pathway server class
• Code the Pathsend procedure to perform error handling