Who Should Read this Book
Who Should Read this Book
An Introduction to DB2 Connect
The Database Concept
Setting up DB2 Connect
DB2 Connect and SQL
Administration Utilities
DRDA and DB2 Connect
Remote Unit of Work
Distributed Request
Enabling Multisite Updates (Two-Phase Commit)
Host and AS/400 Multisite Update Scenarios that Require SPM
DRDA and Data Access
Using the Control Center to Enable Multisite Updates
Related DRDA Online Publications
Direct Database Access
DB2 Connect Enterprise Edition as a Connectivity Server
DB2 Connect and Web Applications
Advantages and Limitations of Traditional CGI Programming
DB2 Connect on the Web Server
DB2 Connect as a Java Application Server
Net.Data
IBM WebSphere
Using DB2 Connect with Application Servers
An Application Server Solution
Application Servers and DB2 Connect
DB2 Connect and Application Server Configurations
Using DB2 Connect with Transaction Processing Monitors
Examples of TP Monitors
Tuxedo and DB2 Connect
X/Open Distributed Transaction Processing (DTP) Model
How to Use DB2 Connect With an XA Compliant Transaction Manager
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
Multisite Update with DB2 Connect
Host or AS/400 Server SQL Statements Supported by DB2 Connect
Host or AS/400 Server SQL Statements Rejected by DB2 Connect
Implementing Charge-Back Accounting on DB2 Universal Database for OS/390
Sending Accounting Information to a DB2 for OS/390 Server
Setting the Accounting String
Useful Publications
Binding Database Utilities
Running CLI/ODBC Programs
Platform Specific Details for CLI/ODBC Access
Detailed Configuration Information
Running Java Programs
Configuring the Environment
Java Applications
Java Applets
Collecting Information
Node Directory
DCS Directory
System Database Directory
Defining Multiple Entries for the Same Database
Updating the Directories
The BIND Command
Rebinding
Monitoring Connections for Remote Clients
Turning on Monitor Switches for DB2 Connect
Listing the Status of Monitor Switches
Using the GET SNAPSHOT Commands
Listing DCS Application Status
LIST DCS APPLICATIONS
LIST DCS APPLICATIONS SHOW DETAIL
LIST DCS APPLICATIONS EXTENDED
Using the DB2 Control Center to List Extended DCS Applications Information
Using the Windows Performance Monitor
Command Line Processor
Using Import and Export Utilities
Moving Data from a Workstation to a S/390 or AS/400 Database Server
Moving Data from a DRDA Server to a Workstation
Mixed Single-Byte and Double-Byte Data
Replacement for SQLQMF Utility
Authentication
Security Types
Security Types for APPC Connections
Security Types for TCP/IP Connections
Discussion of Security Types
Changing Your MVS Password
Configuring the DB2 Connect Workstation for Password Expiration Management
Configuring the Host for Password Expiration Management
Additional Hints and Tips About Security
Extended Security Codes
TCP/IP Security Already Verified
Desktop ODBC and Java Application Security
Password Change Support
Turning Off SQLCODE Mapping
Tailoring the SQLCODE Mapping
Performance Concepts and Tools
Data Flows
Bottlenecks
Benchmarking
Performance Tools
Optimizing ODBC Access
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
Connection Pooling
How Connection Pooling Works
DB2 Connect Connection Concentrator
Database Tuning
Network Tuning
Contention for System Resources
Performance Troubleshooting
Additional SNA Performance Tuning Hints and Tips
General Performance Information for DB2 Connect
Selection and Tuning of the Network Attachment
Other DB2 Connect Performance Information Sources
Multi Path Channel Support for SNA over ESCON
How to Tune DB2 Connect Connections via NCP
Information about OSA-2 Enhancements
Other Information Sources
Other Publications
Using the World Wide Web
Additional Hints and Tips for SNA Users
Other Information Sources
Using the Troubleshooting Guide
Using the World Wide Web
APPC, CPI-C, and SNA Sense Codes Documentation
Gathering Relevant Information
Initial Connection is Not Successful
Problems Encountered after an Initial Connection
Diagnostic Tools
Trace Utility (ddcstrc)
Trace Syntax
Trace Parameters
Trace Output
Analyzing the Trace Output File
Most Common DB2 Connect Problems
SQL0965 or SQL0969
SQL1338 During CONNECT
SQL1403N During CONNECT
SQL5043N
SQL30020
SQL30060
SQL30061
SQL30073 with Return Code 119C During CONNECT
SQL30081N with Return Code 1
SQL30081N with Return Code 2
SQL30081N with Return Code 9
SQL30081N with Return code 10
SQL30081N with Return Code 20
SQL30081N with Return code 27
SQL30081N with Return Code 79
SQL30081N with Protocol Specific Error Code 10032
DB2 Connect Version 6 Release 1
DB2 Connect Version 5 Release 2
DB2 Connect Version 5.0
DDCS Version 2 Release 4
DDCS Version 2 Release 3
Conversion of Character Data
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
Target Environment
CLI/ODBC
The DB2 CLISCHEMA Initalization Keyword
Usage Notes
db2cli and bldschem Utilities
Suggested Approach
Additional Hints and Tips
db2ocat Catalog Optimizer Tool
Additional Information Sources
Other Related Publications
Product Information