Supported Configurations and System Requirements

Supported Configurations

The following table shows all supported configurations for vFabric SQLFire. These include Supported Configurations and System Requirements for vFabric Suite.

Note:

The tables indicate whether the supported configuration is for production or development. Generally, production support means you can run your production application on the platform; developer support means you can develop on the platform but you should not run your production application on it.

Operating System	Processor Architecture	JVM	Production or Developer Support
Red Hat EL 5	x86 (64bit and 32 bit)	Java SE 6, update 0_26	Production
Red Hat EL 6	x86 (64bit and 32 bit)	Java SE 6, update 0_26	Production
Windows Server 2003 R2 SP2 Professional or Enterprise*	x86 (64bit and 32 bit)	Java SE 6, update 0_26	Production
Windows Server 2008 R2 Standard*	x8 (64bit and 32 bit)	Java SE 6, update 0_26	Production
Windows 7 SP1 Professional or Enterprise*	x8 (64bit and 32 bit)	Java SE 6, update 0_26	Developer
Windows XP	x86 (64 bit)	Java SE 6	Developer
Ubuntu 10.04	x86 (64 bit)	Java SE 6	Developer

*The Microsoft Loopback Adapter is not supported.

Note: The SQLFire product download does not include Java; you must download and install a supported JDK for your system.

Host Machine Requirements

Requirements for each host:

A supported Java SE installation.
File system that supports long file names.
Adequate per-user quota of file handles (ulimit for Linux)
TCP/IP.
System clock set to the correct time.
For each Linux host, the hostname and host files must be properly configured. See the system manpages for hostname and hosts.
Time synchronization service such as Network Time Protocol (NTP).

Note: For troubleshooting, you must run a time synchronization service on all hosts. Synchronized time stamps allow you to merge log messages from different hosts, for an accurate chronological history of a distributed run.

Increase Unicast Buffer Size on Linux Platforms

On Linux platforms, execute the following commands as the root user to increase the unicast buffer size:

Edit the /etc/sysctl.conf file to include the following lines:
```
net.core.rmem_max=1048576
net.core.wmem_max=1048576
```
Reload sysctl.conf:
```
sysctl -p
```

Disable SYN Cookies on Linux Platforms

Many default Linux installations use SYN cookies to protect the system against malicious attacks that flood TCP SYN packets. The use of SYN cookies dramatically reduces network bandwidth, and can be triggered by a running SQLFire distributed system.

If your SQLFire distributed system is otherwise protected against such attacks, disable SYN cookies to ensure that SQLFire network throughput is not affected.

To disable SYN cookies permanently:

Edit the /etc/sysctl.conf file to include the following line:
```
net.ipv4.tcp_syncookies = 0
```
Setting this value to zero disables SYN cookies.
Reload sysctl.conf:
```
sysctl -p
```

Client Requirements

SQLFire supports two JDBC drivers: a thin client JDBC driver and a peer JDBC driver. SQLFire server instances and the peer driver are supported only with Java SE 6. You can download Java from http://www.oracle.com/technetwork/java/javase/downloads/index.htm.

SQLFire provides a managed ADO.NET driver that you can use for developing non-Java client applications. The ADO.NET driver uses IKVM technology to translate SQLFire JDBC core libraries to .NET MSIL. The ADO.NET driver is supported for applications built using the Microsoft .NET 2.0 SP1 or higher framework.