StarSQL 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:

  • Windows 7, Vista, Windows 2000, Windows XP, and Windows Server 2003 or 2008
  • FreeBSD v7.0 (x86) or later
  • HP-UX 11i (PA-RISC) or later
  • IBM AIX 5.3 or later
  • Red Hat Enteprise Linux 5.3 (x86) or later
  • SUSE Linux 10 (x86) and later
  • Fedora 10 (x86) or later
  • Ubuntu 9.04 (x86) or later
  • Sun Solaris 10 (SPARC) or later

The StarSQL32-bit and 64-bit ODBC driver is supported on the following 64-bit platforms:

  • Windows 7 x64 Edition
  • Windows Server 2003 x64 Edition
  • Windows Server 2008 x64 Edition
  • Windows Vista x64 Edition
  • Windows XP x64 Edition
  • FreeBSD v7.0 (x64) or later
  • HP-UX 11i (PA-RISC) or later
  • Red Hat Enteprise Linux 5.3 (x64) or later
  • SUSE Linux 10 (x64) and later
  • Fedora 10 (x64) or later
  • Ubuntu 9.04 (x64) or later
  • Sun Solaris 10 (SPARC) or later

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:

  • TCP/IP
  • StarPipes
  • Microsoft SNA Server v2.1 or higher, or Microsoft Host Integration Server
  • NetManage AS400 Router
  • An SNA communications product that provides a 32-bit CPI-C interface

Host Databases

You can use the StarSQL driver to connect to any of the following host databases:

  • DB2 for OS/390 and z/OS v5.1 and later
  • DB2 Server for VSE & VM v7.1 and later (VSE/VM support with StarSQL ODBC driver; VM support with StarSQL JDBC driver)
  • DB2 for VM & VSE ( SQL/DS) v3.3 and later (StarSQL ODBC driver only)
  • DB2 for i (formerly known as DB2/400, DB2 UDB for iSeries, and DB2 for i5/OS) running OS/400 V3R2 and later
  • DB2 Universal Database (UDB) for Linux, UNIX, and Windows v6.x and later

To support native DRDA over TCP/IP you must have one of the following versions of DB2:

  • DB2 for OS/390 and z/OS v5.1 and later
  • DB2 for VM v6.1 and later
  • DB2 for VSE v7.1 and later
  • DB2 for i, running OS/400 V4R2 and later
  • DB2 Universal Database for Linux, UNIX, and Windows v6.1 and later

To support large object data types (LOB) you must use a version of DB2 that supports LOBs, such as:

  • DB2 for OS/390 and z/OS v6.1 and later
  • DB2 for i, running OS/400 V5R1 and later with appropriate PTFs
  • DB2 Universal Databasefor UNIX and Windows v8.1 and later

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.