DB2 Connect User's Guide
Beginning with the most recent version and release, a summary of the
enhancements introduced at each version and release is presented.
DB2 Connect Version 5.2 included the following
enhancements for the host and AS/400 DRDA functions:
- DCE Cell Directory support
- Enhanced security failure notification
- Enhanced System/390 SYSPLEX exploitation
- Optimized Catalog Access for ODBC and JDBC Applications
- Microsoft Transaction Server support
- New BIND options (DYNAMICRULES)
- Set Client Information API enhancements
- SQLDescribeParam support for DB2 Connect
- Support for Bidirectional Languages
- System Monitor enhancements
- Two-phase commit support enhancements
- Simplified DB2 Syncpoint Manager Configuration
- Support for the SCO** operating system
- Support for Big Integer, Large Object, Row ID, and User Defined Distinct
data types.
- New easier to purchase packaging:
- A single DB2 Connect Personal Edition package that contains OS/2, Windows
3.1, Windows 95, and Windows NT versions of the product. This
package contains everything that is needed to get started, including a
complimentary copy of Lotus Approach.
- A single DB2 Connect Enterprise Edition package that contains OS/2,
Windows NT, and all UNIX versions.
- Capability:
- New Level 3 ODBC driver with many improvements
- Updated JDBC driver for better Java support
- Support for stored procedures that return multi-row result sets and
multiple result sets (requires DB2 Universal Database for OS/390 Version
5.1 or higher )
- Built-in replication support
- Generic bind option: you can specify any bind option supported by
the host database.
- SYSPLEX exploitation (DB2 Connect Personal Edition only; requires DB2
Universal Database for OS/390 Version 5.1 or higher )
- Usability:
- New installation method
- TCP/IP database connections are much easier to configure (requires DB2
Universal Database for OS/390 Version 5.1 or higher, or DB2 Universal
Database for AS/400 Version 4.2)
- Integrated SNA support with point-and click configuration (DB2 Connect
Personal Edition only)
- New point and click configuration utility for configuring host
connections.
- Much easier process for connecting desktop client systems to DB2 Connect
Enterprise Edition servers. Clients can discover DB2 Connect servers
and all of the databases that are defined on each server
- Improved ODBC traces with detailed information for performance analysis
- Control Center and other GUI tools that simplify several DBA tasks
- Security:
- DCE security (requires DB2 Universal Database for OS/390 Version
5.1 or higher )
- Ability to run ODBC applications without having to authorize each user to
base tables. Users can now bind their ODBC driver in such a way as to
allow applications to run under the authority of the person that bound the
ODBC driver.
- Performance:
- Faster access to the DB2 catalog for ODBC applications
- Reduced network traffic:
- Early close for cursors
- Deferred prepare
- Reduced byte count on Compound SQL
- Several other network flow enhancements
- Support for ASCII storage on the host (requires DB2 Universal Database for
OS/390 Version 5.1 or higher )
- Connectivity:
- Support for DRDA over TCP/IP connections to other IBM DRDA Application
Servers, as they introduce support for TCP/IP.
- SNA over TCP/IP via integrated MPTN support (requires AnyNet on the
host).
- Support for additional SNA connectivity options:
- IBM Communication Server for Windows NT
- IBM Personal Communications
- Other:
- Ability to initiate 2-phase commit transactions over TCP/IP (requires DB2
Universal Database for OS/390 Version 5.1 or higher)
- Ability for desktop applications to participate in a 2-phase commit
transactions without the need for a gateway (TCP/IP only, requires DB2
Universal Database for OS/390 V5.1 or higher )
- Ability to use DB2 Universal Database for OS/390 for added reliability of
transaction coordination (requires DB2 Universal Database for OS/390 Version
5.1 or higher, and TCP/IP)
- Numerous other enhancements and fixes affecting all aspects of system
performance, reliability, and usability.
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.
- Wall Data Rumba, 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 Universal Database
for AS/400 Version 3.1 servers. See Stored Procedures.
- Able to work with multiple databases in a single transaction. See Multisite Updates (Two-Phase Commit).
- 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 E, Using DCE Directory Services.
- Greater flexibility in SQLCODE processing. See 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 ]
[ DB2 List of Books |
Search the DB2 Books ]