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.
- 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 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 for
OS/390 Version 5.1 or higher )
- Usability:
- New installation method
- TCP/IP database connections are much easier to configure (requires DB2 for
OS/390 Version 5.1 or higher, or DB2 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 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 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
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 for
OS/390 V5.1 or higher )
- Ability to use DB2 for OS/390 for added reliability of transaction
coordination (requires DB2 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.
- 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 9. "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 ]