StarSQL System Requirements

Following are the system requirements for the StarSQL ODBC driver and StarSQL for Java, the StarQuest JDBC driver.

StarSQL for Java Client

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

The StarSQL ODBC driver is supported on all 32-bit platforms, including:

  • Windows Vista, Windows 2000, Windows XP, and Windows Server 2003 or 2008
  • AIX 4.3.3 or later
  • FreeBSD 6.1(x86) or later
  • HP-UX 11i (PA-RISC) or later
  • Red Hat Linux 9 (x86) or later
  • Sun Solaris 8 (SPARC) or later
  • SUSE Linux 9 (x86) and 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 StarSQL ODBC driver can be run from a Linux, UNIX, or Windows computer, using 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, such as:
    • Novell NetWare for SAA v2.2 & later
    • IBM Personal Communications AS/400 and 3270 v4.x & later
    • IBM Communications Server 5.01 & later
    • NetManage/Wall Data Rumba APPC
    • Attachmate Extra! v6.x

Host Databases

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

  • DB2 for z/OS (DB2 for OS/390) v5.1 and later
  • DB2 for VM & VSE ( SQL/DS) v3.3 and later (ODBC only)
  • DB2/400 (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 z/OS (DB2 for OS/390) v5.1 and later
  • DB2 for VM & VSE v6.1 and later
  • DB2/400 (OS/400) v4r2 and later
  • DB2 Universal Database for Linux, UNIX, and Windows v6.1 and later

Older versions of DB2 may be accessible using the TCP/IP to SNA gateway facility of StarPipes.