gtpa3m02Application Requester User's Guide

Application Requester User's Guide


Contents

Figures

Tables

Notices

  • Trademarks
  • About This Book

  • Who Should Read This Book
  • Conventions Used in the TPF Library
  • Related Information
  • How to Send Your Comments
  • The TPF Application Requester (TPFAR) Feature

  • Introduction
  • Access to Remote Data
  • Moving TPF Data to a DB2 Database without TPFAR
  • Moving TPF Data to and from a DB2 Database Using TPFAR
  • How TPFAR Works
  • Methods for Using TPFAR in Your Enterprise
  • Transaction Logging
  • Bulk Data Transfer
  • Single Line Query
  • Block Query
  • Preparing Your Environment for TPF Application Requester

  • TPF Requirements
  • Configuring TPFAR
  • Defining the Applications for LU 6.2
  • Defining the Local TPF/APPC Applications for LU 6.2
  • Defining the Remote DB2 PLU Application for LU 6.2
  • Attaching to the LU 6.2 Communications Cloud
  • Defining the TPFAR Storage Areas
  • Other TPF System Storage Requirements
  • LU 6.2 Requirements
  • TCP/IP Requirements
  • Commands
  • Coding the SQL Trace Table User Exit
  • Character Sets
  • Loosely Coupled Requirements
  • Subsystem Requirements
  • VTAM Requirements for LU 6.2
  • Mode Names
  • RU Sizes and Pacing Considerations
  • Connecting a TPF System and a DB2 System Using LU 6.2
  • Defining the TPF Application LUs to VTAM
  • Configuring the TPF System and a DB2/6000 System
  • DB2 Requirements
  • Putting It All Together
  • Starting the TPF/APPC Application for Use with TPFAR
  • Setting the Stage with a Telephone Directory Application

  • A Few Words about Relational Databases
  • Creating the Telephone Directory
  • SQL Considerations
  • Length of Time Field
  • Request Unit Size Considerations
  • Number of Cursors
  • Protect Key
  • Addressing Mode
  • Registers
  • Dynamic SQL
  • Collection Identifiers
  • TPFAR Working Storage Blocks
  • Synchronizing Updates
  • C Language Header Files
  • Error Handling
  • Preparing an Application
  • Using the TPF DB2 Postprocessor (TPF DB2PP)
  • Database Resource Management (DBRM)
  • Using the Same Cursor in Multiple Programs
  • TARGET C Language Modifications
  • Assembler Modifications
  • Using TPF C with TPFAR

  • The Root Segment for the Telephone Directory Application
  • Inserting a Telephone Directory Entry
  • Removing a Telephone Directory Entry
  • Updating a Telephone Directory Entry
  • Displaying Entries in the Telephone Directory
  • Using Assembler Language with TPFAR

  • Offloading Data from the TPF System
  • Setting Up the Application Server
  • Assembler Program QXRK
  • Assembler Program QXRL
  • Performance and Tuning for TPFAR

  • Considerations That Are the Same
  • Considerations That Are Different
  • Communications Overhead and Hotcons
  • Application Overhead
  • CTC Considerations for LU 6.2
  • Specific Performance Considerations
  • Methods of Calculating Response Time
  • Segment Allocation
  • TPF Utilization Impact
  • SQL Commands Supported by TPFAR

    Appendix A. TPFAR SQLCODEs

    Glossary of Terms Related to TPFAR

    Index