User's Guide

Functions Delivered in Previous Releases

Distributed Database Connection Services (DDCS) for Windows Single-User Version 2.4 introduced:

A Data Sources Setup tool to help you define connections to host and AS/400 servers quickly and easily.
Integrated SNA Support, to provide you with the communications support required to make these connections.
A DB2 Password Expiration Maintenance utility (DB2PEM), which enables you to change your DB2 for MVS/ESA password without logging on to TSO.
Enhancements to improve the performance and flexibility of DB2 Connect:
- Deferred Prepare, which improves the performance of ODBC and other dynamic SQL applications by attaching the PREPARE request to a subsequent request instead of sending it separately.
- Asynchronous ODBC, which improves the availability of ODBC applications. Previously, these might have appeared to be delayed while processing long queries in some network situations.
- On AIX and OS/2, support for multi-threaded applications, which gives non-ODBC applications the ability to maintain multiple database connections with their own contexts.

New features in DDCS Version 2 Release 3.1 included:

Two-phase commit for DRDA connections using the LU6.2 Syncpoint Manager (SPM) on OS/2 and AIX.

New features in DDCS Version 2 Release 3.0 included:

Client application performance could be improved by running stored procedures on DB2 for MVS/ESA Version 4.1 and DB2 for AS/400 Version 3.1 servers. See "Stored Procedures".
Able to work with multiple databases in a single transaction. See "Distributed Unit of Work".
Able to improve performance by concatenating SQL statements. See "NOT ATOMIC Compound SQL" and "Using Import and Export Utilities".
Able to implement chargeback accounting by using accounting strings. See "Implementing Chargeback Accounting".
Able to use many new bind options when binding applications to a DRDA application server. See "The BIND Command".
When using a DCE directory, the ability to consolidate the directory information needed by all your clients in a central repository. See Appendix C. "Using DCE Directory Services".
Greater flexibility in SQLCODE processing. See Chapter 8. "SQLCODE Mapping".
Diagnostic information stored in a readable format and consolidated in a single location (the first failure service log). For more information, see the Troubleshooting Guide.
The DDCSSETP environment variable was replaced by BIND and PREPARE options such as SQLERROR CONTINUE, simplifying operations.
Various other performance improvements were also implemented.

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