 |
|

Database Connectivity for DB2 LUW
|

Standard Edition
|
HiT ODBC Server/DB2
HiT ODBC Server/DB2 Developer Edition
HiT ODBC Server/DB2 (for DB2 for LUW or for DB2 for z/OS)
provides a secure, centralized, Open Database Connectivity (ODBC) service for Windows
Server applications and for ODBC client applications. HiT ODBC Server/DB2 enables
Windows Server software, such as Microsoft IIS, access to DB2 data and thereby
to clients of the server software. HiT ODBC Server/DB2 enables NT Server software,
such as Microsoft IIS, access to DB2 data and thereby to clients of the server software.
HiT ODBC Server/DB2 Developer Edition (DE) includes the C# Toolkit.
It contains source code examples for accessing data using ADO.NET. It
significantly cuts application development time by providing developers working C# samples to
query and update DB2 tables and retrieve DB2 data for redirection to applications. Included
source code demonstrates connections using ADO.NET recordsets, executing stored procedures, retrieving
table data, inserting table data, and displaying results.
| Key Features |
 |
|
Benefits |
 |
ODBC level 3.x conformance
ADO level 2.x compliance
ADO.NET compliance |
 |
|
Latest tools accessibility
|
 |
Stored procedures and multiple result sets
support
Static SQL/package support
|
 |
|
Fast data access
|
 |
Distributed Transaction Support
|
 |
|
Complex transactions support over multiple
databases |
 |
| Multi-threading support |
 |
|
Performance and scalability |
 |
| dbExpress and Connection Pooling |
 |
|
Performance |
 |
SSL v3.x encryption and authentication
support |
 |
|
Secure data transmission
|
 |
| Legacy DB2 LUW and UDB Support |
 |
|
Flexible deployment |
 |
| Debug/trace tools |
 |
|
Fast diagnostics |
 |
| Silent install support |
 |
|
Fewer IT support issues during deployment |
 |
| TCP/IP or APPC connectivity support |
 |
|
Common network transport |
 |
| Double-byte support
|
 |
|
International DB2 server access |
 |
DRDA Native protocol support
|
 |
|
Server Stability |
 |
Distributed program call support CL
Command Execution
|
 |
|
Business logic and utility access
|
 |
Complete set of data types supported
and documented
|
 |
|
Seamless translation between EBCDIC and
ANSI character sets |
 |
HiT Server Manager and C# Toolkit
with Developer Edition
|
 |
|
Remote monitoring management and
reduced development time |
 |
Security
HiT ODBC Server/DB2 allows an administrator to pre-define data sources for server and downstream Windows
clients. These data sources are maintained at the server and cannot be modified. The included HiT ODBC
thin client only communicates with the ODBC server, providing a security gateway before the DB2 host
server.
Configurations
HiT ODBC Server/DB2 can be used in two configurations:
· Server ODBC Applications
A Windows NT server application or service locally uses the ODBC service to access DB2 data and
redirect it where necessary. For example, using the Microsoft IIS web server and Active Server
Pages, downstream web browser clients can access DB2 data.

· Client ODBC Applications
A thin client presents the ODBC API to a Windows client application and transports the ODBC
commands to the ODBC service. Only server-defined data sources are available to client ODBC
applications. For example, a custom Visual Basic application uses the thin client ODBC API to
access DB2 data via the ODBC service.

Server Requirements:
For the Windows Server
· Windows Server 2008 (32/64-bit), Windows Server 2003 (32/64 bit),
Windows Server 2000 or Windows NT Server 4.0
· TCP/IP or APPC connection to the DB2 Server
DB2 LUW (Linux, UNIX, Windows)
· DB2 version 5.0 or later
DB2 for i (iSeries, AS/400)
· IBM OS/400 Operating System V3R7 or higher
DB2 for z/OS (OS/390)
· DB2 for OS/390 version 5.0, or above

Standard Edition
Full Support
during Trial Period |

Developer Edition
Full Support
during Trial Period |
|