 |
      |
|
|
|
StarSQL ODBC/JDBC Database Drivers: fast, reliable access to IBM DB2 Databases The StarSQL driver provides fast, direct access to IBM’s DB2 relational databases. With a license to use StarSQL, you can use either the ODBC driver or the JDBC driver. Deploy the StarSQL driver on any number of Java, Linux, UNIX, or Windows client computers, and pay only for the number of connections that are needed at the same time. StarSQL licenses are suitable for Web servers and traditional client-server applications, with attractive entry-level pricing and volume-purchase discounts. The StarSQL ODBC driver can be used from any ODBC-based Windows or UNIX application. StarSQL for Java, a pure JDBC driver, can be used from any Java Database Connectivity (JDBC) compliant application. The StarSQL ODBC driver is compliant with the IBM CLI Version 2, the ODBC v3 standard, and DRDA Level 3. StarSQL for Java is a Type 4 JDBC driver that features comprehensive support for Version 3.0 of the JDBC standard, including support for J2EE, LOB (large object) data, encrypted passwords, connection pooling, and Two-Phase Commit (2PC) JTA-type transactions. With the StarSQL driver, users can access DB2 data seamlessly from spreadsheets, reporting applications, Visual Basic applications, and many other applications and development tools. StarSQL v5.5 is now available as a 32-bit and 64-bit ODBC driver for Windows, Linux and UNIX. Use the new 64-bit driver to unleash the power of 64-bit database applications running on 64-bit operating systems. You can install and use both the 32-bit and 64-bit StarSQL ODBC drivers on the same 64-bit Windows, Linux, or UNIX computer. The 32-bit ODBC driver is available for 32-bit Windows, Linux and UNIX systems. OVERVIEW StarSQL offers performance, ease-of-use, and reliability at a great value.
BENEFITS Leverage your existing hardware and network connections, as StarSQL runs on legacy systems as well as with the latest operating and database management systems. The StarSQL driver runs on a client computer, with no host software or proprietary gateway required, and uses existing TCP/IP or SNA connections to the host database. Connectivity to SNA networks is provided with StarQuest's StarPipes product. Flexible, Affordable Licensing StarSQL is offered with flexible packaging and licensing options. Licenses are priced according to the maximum number of StarSQL concurrent connections that are needed. This allows customers to deploy the StarSQL driver on any number of Java, Linux, UNIX, or Windows client computers, and pay only for the number of connections that are needed at the same time. StarSQL for Java also is available in attractively priced packages for customers who only need access to a particular IBM database, such as DB2 for iSeries or DB2 UDB for Linux, UNIX, and Windows. Easy-to-Implement and Easy-to-Use A Data Source Configuration Wizard steps users through the steps of configuring StarSQL to access a particular data source. You also can install custom, pre-defined Data Source Name definitions as StarSQL is deployed throughout an organization. StarSQL is compatible with most applications, providing users with immediate access to DB2 data. Robust Implementation and Performance StarSQL uses open industry standards to deliver rapid access to DB2. It implements unique, built-in memory management, collapsed protocol layers, and minimal data transfer, to provide the industry’s fastest remote data access. Support for All Major Languages StarSQL includes conversion support for all major language groups, including legacy hosts that use Extended EBCDIC for East Asian languages (Chinese, Japanese, and Korean). StarSQL also supports modern applications and hosts that take advantage of UNICODE encoding. Support for Two-Phase Commit Transactions StarSQL supports two-phase commit transactions over both TCP-IP and SNA networks to IBM mainframe, mid-range, and workstation-based hosts. StarSQL’s two-phase commit support provides high transaction throughput rates, seamlessly integrated with Microsoft’s Distributed Transaction Coordinator (DTC.) Support for LOB Data Types StarSQL provides efficient, high speed, access to LOB data types—Binary Large Objects (BLOB) and Character Large Objects (CLOB). LOB data is increasingly important for storing and retrieving rich content such as video, audio, and XML-based data. Secure Data Access StarSQL encrypts user IDs and passwords to provide greater security and data access control. The StarSQL driver respects the security protocols of the host and client computers, allowing users to access only the data they have permission to access. Enhanced Static SQL Enhanced static SQL support provides performance gains and improved control over data access. Users and developers can reuse the most frequently executed queries simply by using predefined static SQL packages stored on the DB2 host. Because the query is prepared in advance, dramatic performance improvements can be realized. .NET, ADO, and RDO Interface Support (ODBC driver only) StarSQL for Windows implements Microsoft's most advanced ODBC application programming interface so it works with the most advanced tools, such as Microsoft Transaction Server and Internet Information Server. StarSQL for Windows supports all ODBC calls that users demand when working with the parameter marker features of PowerBuilder or Microsoft’s advanced access methods, including .NET, Active Data Objects (ADO) and Remote Data Objects (RDO). Java, Linux, UNIX, and Windows Support StarSQL provides the same fast, reliable data access solution for all popular computing platforms. The StarSQL for UNIX driver software is currently available for FreeBSD, HP-UX, IBM AIX, Linux, and Sun Solaris. StarSQL for Windows can run on all the latest Windows systems, including Vista and Server 2008—the 64-bit version of StarSQL takes advantage of the Windows x64 architecture. StarSQL for Java uses JDBC to extend access from platforms such as Apple Macintosh. Seamless Connection with Flexibility StarSQL is completely thread-safe, so you can use StarSQL with Web servers, transaction processors, and data replication tools. Administration Utilities StarSQL includes time-saving tools for system administrators and software developers. The StarAdmin and StarScribe utilities that are included with StarSQL for Windows provide a graphical interface for easy administration of DB2 access and creation of static SQL. Compatible ODBC Applications and Languages The StarSQL ODBC driver is designed and developed to interoperate with the Microsoft ODBC Driver Manager on Windows computers and the unixODBC open-source Driver Manager on a Linux or UNIX computer. Following are a few of the popular client software packages that have been verified to work with StarSQL:
Compatible JDBC Applications and Languages Following are a few of the popular client software packages that have been verified to work with the StarSQL JDBC driver:
SYSTEM REQUIREMENTS Following are the system requirements for the StarSQL ODBC and JDBC drivers. StarSQL for Java Client (JDBC driver) StarSQL for Java runs on any system with a Java Virtual Machine (JVM) that is equivalent to that contained in the Java Development Kit (JDK) or the Java Runtime Environment (JRE) v1.4 or later. StarSQL for Linux, UNIX, and Windows Client (ODBC driver) The StarSQL 32-bit ODBC driver is supported on all 32-bit platforms, including:
The StarSQL32-bit and 64-bit ODBC driver is supported on the following 64-bit platforms:
Host Connectivity StarSQL for Java runs on the desktop, with no host software or proprietary gateways required, and works with existing TCP/IP connections to the host database. The driver uses the TCP/IP protocol to communicate either directly to DB2 host systems that implement DRDA over TCP/IP (e.g. DB2 for OS/390 v5.1 & later, OS/400 v4r2 & later, DB2 UDB for Linux, UNIX, and Windows v6.1 & later) or to any DB2 system through a StarPipes gateway. The 64-bit Windows version and all UNIX/Linux versions of the StarSQL ODBC driver work within a TCP/IP network, or in conjunction with the StarPipes gateway, to connect a client to a DB2 host. The 32-bit Windows version of the StarSQL ODBC driver can use any of the following networks for host connectivity:
Host Databases You can use the StarSQL driver to connect to any of the following host databases:
To support native DRDA over TCP/IP you must have one of the following versions of DB2:
To support large object data types (LOB) you must use a version of DB2 that supports LOBs, such as:
If you will be accessing Unicode or ASCII LOB data on DB2 for OS/390 or z/OS, be sure to apply the PTF's described in the IBM APAR PQ85495. MORE RESOURCES Contact us for a free evaluation or download the product directly from the StarQuest Web Site. StarSQL is a StarQuest Ventures Inc. product. |
|
|