IBM Books

User's Guide

This document contains proprietary information of IBM. It is provided under a license agreement and is protected by copyright law. The information contained in this publication does not include any product warranties and any statements provided in this manual should not be interpreted as such.

Order publications through your IBM representative or the IBM branch office serving your locality or by calling 1-800-879-2755 in U.S. or 1-800-IBM-4YOU in Canada.

When you send information to IBM, you grant IBM a nonexclusive right to use or distribute the information in any way it believes appropriate without incurring any obligation to you.

© Copyright International Business Machines Corporation 1993, 1997. All rights reserved.
Note to U.S. government Users -- Documentation related to restricted rights -- Use, duplication or disclosure is subject to restrictions set forth in GSA ADP Schedule contract with IBM Corp.

Table of Contents

About This Book

  • How This Book is Structured
  • Other Information Sources
  • Using the World Wide Web
  • Related DRDA Publications
  • Related DRDA Server Publications
  • Other Related Publications

    • Chapter 1. DB2 Connect Overview

  • The Database Concept
  • Setting up DB2 Connect
  • DB2 Connect and SQL
  • Administration Utilities
  • What's New in DB2 Connect Version 5?
  • Functions Delivered in Previous Releases
  • DDCS Version 2 Release 4
  • DDCS Version 2 Release 3

    • Chapter 2. Distributed Relational Database Architecture Concepts

  • DRDA and DB2 Connect
  • Remote Unit of Work
  • Distributed Unit of Work
  • DRDA and Data Access

    • Chapter 3. Updating Database Directories

  • Collecting Information
  • Node Directory
  • DCS Directory
  • System Database Directory
  • Defining Multiple Entries for the Same Database
  • Updating the Directories

    • Chapter 4. Binding Applications and Utilities

  • The BIND Command
  • Rebinding

    • Chapter 5. DB2 Connect Administration Utilities

  • Command Line Processor
  • Database System Monitor
  • Using Import and Export Utilities
  • Moving Data from a Workstation to a DRDA Server
  • Moving Data from a DRDA Server to a Workstation
  • Mixed Single-Byte and Double-Byte Data
  • Replacement for SQLQMF Utility
  • Trace Utility (ddcstrc)
  • Trace Syntax
  • Trace Parameters
  • Trace Output
  • Analyzing the Trace Output File

    • Chapter 6. Security

  • Authentication
  • Security Types
  • Security Types for APPC Connections
  • Security Types for TCP/IP Connections
  • Discussion of Security Types
  • Additional Hints and Tips About Security
  • Extended Security Codes
  • TCP/IP Security Already Verified
  • ODBC Application Security

    • Chapter 7. Programming in a DRDA Environment

  • Programming in a Distributed Environment
  • Using Data Definition Language (DDL)
  • Using Data Manipulation Language (DML)
  • Using Data Control Language (DCL)
  • Connecting and Disconnecting
  • Precompiling
  • Defining a Sort Order
  • Managing Referential Integrity
  • Locking
  • Differences in SQLCODEs and SQLSTATEs
  • Using System Catalogs
  • Numeric Conversion Overflows on Retrieval Assignments
  • Isolation Levels
  • Stored Procedures
  • NOT ATOMIC Compound SQL
  • Distributed Unit of Work with DB2 Connect
  • DRDA Server SQL Statements Supported by DB2 Connect
  • DRDA Server SQL Statements Rejected by DB2 Connect
  • Implementing Chargeback Accounting
  • Useful Publications

    • Chapter 8. SQLCODE Mapping

  • Turning Off SQLCODE Mapping
  • Tailoring the SQLCODE Mapping

    • Chapter 9. Problem Determination

  • Other Information Sources
  • Using the Troubleshooting Guide
  • Using the World Wide Web
  • Gathering Relevant Information
  • Initial Connection is Not Successful
  • Problems Encountered after an Initial Connection
  • Diagnostic Tools

    • Chapter 10. DB2 Connect Performance

  • Other Information Sources
  • Other Publications
  • Using the World Wide Web
  • Performance Concepts and Tools
  • Data Flows
  • Bottlenecks
  • Benchmarking
  • Performance Tools
  • Application Design
  • Compound SQL and Stored Procedures
  • Grouping Requests
  • Predicate Logic
  • Data Blocking
  • Static and Dynamic SQL
  • Other SQL Considerations
  • DB2 Connect Tuning
  • RQRIOBLK
  • DIR_CACHE
  • Other DB2 Connect Parameters
  • Database Tuning
  • Data Conversion
  • Data Types for Character Data
  • Communication System Tuning (SNA)
  • Network Hardware
  • Contention for System Resources
  • Performance Troubleshooting

    • Appendix A. Directory Customization Worksheet

    Appendix B. National Language Support Considerations

  • Conversion of Character Data

    • Appendix C. Using DCE Directory Services

  • Creating a Database Object
  • Creating a Database Locator Object
  • Creating a Routing Information Object
  • Setting Configuration Parameters
  • Cataloging the Database
  • Security with DCE Directory Services

    • Appendix D. Binding Utilities for Back-Level Clients

    Appendix E. Contacting IBM

    Appendix F. Notices

  • Trademarks
  • Trademarks of Other Companies

    • Index

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

    [ DB2 List of Books | Search the DB2 Books ]