Table of Contents

About Distributed Database Programming

  • Who should read this information
  • What's new in V4R5 in the Distributed Database Programming book

    • Distributed Relational Database and the AS/400 System

  • Distributed relational database processing
  • Remote unit of work
  • Distributed unit of work
  • Other Distributed Relational Database terms and concepts
  • Distributed Relational Database Architecture Support
  • DRDA and CDRA support
  • Character conversion with CDRA
  • Application requester driver programs
  • Distributed relational database on the AS/400 system
  • Managing an AS/400 Distributed Relational Database
  • Considerations for implementing a distributed relational database
  • Planning and design for distributed relational databases
  • Configuring communications for DRDA implementation
  • Developing a security strategy for distributed relational databases
  • Setting up application requesters, applications servers, and directories for distributed relational databases
  • Monitoring distributed relational database administrative and operational tasks
  • Ensuring data protection and availability for a distributed relational database
  • Monitoring performance for a distributed relational database
  • Handling problems within a distributed relational database
  • Programming applications for the distributed relational database environment
  • Example: Spiffy Corporation distributed relational database
  • Spiffy Organization and system profile
  • Business processes of the Spiffy Corporation Automobile Service
  • Distributed Relational Database administration for the Spiffy Corporation

    • Planning and Design for Distributed Relational Database

  • Identifying your needs and expectations for a distributed relational database
  • Data needs for distributed relational databases
  • Distributed relational database capabilities
  • Goals and directions for a distributed relational database
  • Designing the application, network, and data for a distributed relational database
  • Designing distributed relational database applications -- Tips
  • Network considerations for a distributed relational database
  • Data considerations for a distributed relational database
  • Developing a management strategy for a distributed relational database
  • General operations for a distributed relational database
  • Security for a distributed relational database
  • Accounting for a distributed relational database
  • Problem analysis for a distributed relational database
  • Backup and recovery for a distributed relational database

    • Communications for an AS/400 Distributed Relational Database

  • Communications tools for DRDA implementation
  • Systems network architecture for a distributed relational database
  • APPC/APPN for a distributed relational database
  • Using DDM and Distributed Relational Database
  • Alert support for a distributed relational database
  • Distributed relational database network considerations
  • Configuring communications for a Distributed Relational Database
  • Configuring a communications network for APPC
  • Configuring a communications network for TCP/IP
  • Example: APPN configuration for a distributed relational database
  • Configuring alert support for a distributed relational database
  • Example: Configuration for alert support for a distributed relational database

    • Security for an AS/400 Distributed Relational Database

  • Elements of Distributed Relational Database security
  • Session level and location security for APPC connections
  • Conversation level security for APPC connections
  • DRDA security using TCP/IP
  • DRDA server access control exit programs
  • Object-related security for DRDA
  • Authority to Distributed Relational Database objects
  • Programs that run under adopted authority for a distributed relational database
  • Protection strategies in a Distributed Relational Database

    • Setting Up an AS/400 Distributed Relational Database

  • Work Management on the AS/400 system
  • Setting up your work management environment for DRDA
  • Work Management for DRDA use with TCP/IP
  • Considerations for setting up subsystems for APPC
  • Using the relational database directory
  • Working with the relational database directory
  • Relational database directory setup example
  • Setting up DRDA security
  • Setting up the TCP/IP Server for DRDA
  • Setting up SQL Packages for Interactive SQL
  • Setting up DDM files
  • Loading data into tables in a distributed relational database
  • Loading new data into the tables of a distributed relational database
  • Moving data from one AS/400 system to another
  • Moving a database to an AS/400 system from a non-AS/400 system

    • Distributed Relational Database Administration and Operation Tasks

  • Monitoring relational database activity
  • Working with jobs in a distributed relational database
  • Working with user jobs in a distributed relational database
  • Working with active jobs in a distributed relational database
  • Working with commitment definitions in a distributed relational database
  • Tracking request information with the job log of a distributed relational database
  • Locating distributed relational database jobs
  • Operating remote AS/400 systems
  • Starting and stopping other systems remotely
  • Submit Remote Command (SBMRMTCMD) command
  • Controlling DDM conversations
  • Reclaiming DDM resources
  • Displaying objects used by programs
  • Example: Display Program Reference
  • Dropping a collection from a distributed relational database
  • Job accounting in a distributed relational database
  • Managing the TCP/IP Server
  • DRDA terminology
  • TCP/IP communication support concepts for DRDA
  • QSYSWRK subsystem
  • Identifying Server Jobs
  • Canceling Distributed Relational Database work
  • End Job (ENDJOB) command
  • End Request (ENDRQS) Command
  • Auditing the relational database directory

    • Data Availability and Protection for a Distributed Relational Database

  • Recovery support for a distributed relational database
  • Uninterruptible power supply
  • Data recovery after disk failures for distributed relational databases
  • Journal management for distributed relational databases
  • Transaction recovery through commitment control
  • Writing data to auxiliary storage
  • Save and restore processing for a distributed relational database
  • Ensuring data availability for a distributed relational database
  • Network redundancy issues for a distributed relational database
  • Data redundancy in your distributed relational database network

    • Distributed Relational Database Performance

  • Improving distributed relational database performance hrough the network
  • DRDA unprotected conversations
  • Improving distributed relational database performance through the system
  • Observing DRDA system performance
  • Improving distributed relational database performance through the database
  • Deciding DRDA data location
  • Factors that Affect Blocking for DRDA
  • Factors that affect the size of DRDA query blocks

    • Handling Distributed Relational Database Problems

  • AS/400 Problem Handling Overview
  • Isolating Distributed Relational Database Problems
  • DRDA incorrect output problems
  • Application does not complete in the expected time problems
  • Working with distributed relational database users
  • Copy screen
  • Messages
  • Handling program start request failures for APPC
  • Handling connection request failures for TCP/IP
  • Application problems
  • Listings
  • SQLCODEs and SQLSTATEs
  • System and communications problems
  • AS/400 problem log
  • Alerts
  • Getting data to report a failure
  • Printing a job log
  • Finding job logs from TCP/IP server prestart jobs
  • Printing the product activity log
  • Trace job
  • Communications trace
  • Finding First-Failure Data Capture (FFDC) data
  • Interpreting FFDC data from the error log
  • Starting a service job to diagnose application server problems
  • Starting a service job for an APPC server
  • Starting a service job for a TCP/IP server
  • Setting QCNTSRVC as a TPN on a DB2 UDB for AS/400 Application Requester
  • Creating your own TPN for debugging a DB2 UDB for AS/400 AS job
  • Setting QCNTSRVC as a TPN on a DB2 for VM Application Requester
  • Setting QCNTSRVC as a TPN on a DB2 for OS/390 Application Requester
  • Setting QCNTSRVC as a TPN on a DB2 Connect Application Requester

    • Writing Distributed Relational Database Applications

  • Programming considerations for a Distributed Relational Database application
  • Naming distributed relational database objects
  • Connecting to a Distributed Relational Database
  • SQL Specific to distributed relational database and SQL CALL
  • Ending DRDA units of work
  • Coded Character Set Identifier (CCSID)
  • Other DRDA data conversion
  • DDM files and SQL
  • Preparing distributed relational database programs
  • Precompiling programs with SQL statements
  • Compiling an application program
  • Binding an application
  • Testing and debugging
  • Working with SQL packages
  • SQL package management
  • Create SQL Package (CRTSQLPKG) command
  • Delete SQL Package (DLTSQLPKG) command
  • SQL DROP PACKAGE statement

    • Appendix A. Application Programming Examples

  • Business requirement for distributed relational database example
  • Technical Notes
  • Example: Creating a collection and tables
  • Example: Inserting data into the tables
  • Example: RPG Program
  • Example: COBOL Program
  • Example: C Program
  • Example: Program Output

    • Appendix B. Cross-Platform Access Using DRDA

  • CCSID considerations
  • AS/400 system value QCCSID
  • CCSID conversion considerations for DB2 connect connections
  • CCSID conversion considerations for DB2 and DB2 server for VM Database Managers
  • Interactive SQL and Query Management setup on unlike application servers
  • Creating Interactive SQL packages on DB2 Server for VM
  • FAQs from users of DB2 Connect
  • Do AS/400 files have to be journaled?
  • When will query data be blocked for better performance?
  • Is the DB2 UDB Query Manager and SQL Development Kit product needed for collection and table creation?
  • How do you interpret an SQLCODE and the associated tokens reported in a DBM SQL0969N error message?
  • Other tips for interoperating with workstations using DB2 Connect and DB2 UDB
  • DB2 Connect versus DB2 UDB
  • Proper configuration and maintenance level
  • Table and collection naming
  • Granting privileges
  • APPC communications setup
  • Setting up the RDB directory
  • Setting up the SQL package for DB2 Connect
  • Using Interactive SQL to DB2 UDB

    • Appendix C. Interpreting Trace Job and FFDC Data

  • Interpreting data entries for the RW component of trace job
  • Example: Analyzing the RW trace data
  • Description of RW trace points
  • First-Failure Data Capture (FFDC)
  • An FFDC Dump
  • FFDC Dump Output Description
  • DDM Error Codes

    • Appendix D. DDM Architecture Command Support

    Bibliography

  • AS/400 System Information
  • Distributed Relational Database Library
  • Other IBM Distributed Relational Database Platform Libraries
  • DB2 Connect and Universal Database
  • DB2 for OS/390
  • DB2 Server for VSE and VM
  • Architecture Books
  • Redbooks

    • Index

    [ Top of Page | Previous Page | Next Page | Table of Contents | Index ]