DBMS Versions

DBMS server versions can provide a host of information:

1. Compare your DBMS version with the Multi-Tier database agent version string or Single-Tier driver version. Is the DBMS compatible with your Agent or Lite driver?
   
2. Compare your DBMS version with the DBMS version against which OpenLink's product was built. Are they the same? Differences in server version or patch level may contribute to a host of problems including outright compatibility or subtle stability issues.
   
3. Compare your DBMS version with the operating system version and patch level. Does the operating system meet the system requirements of the DBMS?
   
4. Is your DBMS running on Unix? If so, obtain your Unix server kernel tuning parameters. Do the tuning parameters match the requirements specified in the DBMS documentation? Insufficient tuning parameters contribute to stability problems. In fact, check the tuning parameters on any Unix machine that hosts unstable OpenLink drivers, regardless of whether the DBMS server is actually present.
   
5. Is your DBMS server version associated with limitations or bugs? Is the DBMS server's patch level current?

Note: Relink your Multi-Tier database agent, if your DBMS version and OpenLink database agent version strings differ. Relinking resolves some compatibility issues that arise when OpenLink builds against one set of DBMS libraries and you have a slightly different version of DBMS libraries.

Display Kernel Tuning Parameters Commands

OS	command(s)
HPUX	sysdef kmtune kmsystem
Linux	sysctl -a ulimit -a more /proc/sys/kernel/shmmax more /proc/sys/kernel/shmmni more /proc/sys/kernel/sem
SCO OpenServer 5	scoadmin configure cat /etc/conf/cf.d/stune
SCO Unixware 7	scoadmin /etc/conf/bin/idtune -g individual parameter
Tru64	sysconfig dxkerneltuner cat /etc/sysconfigtab cat /sys/conf/ HOSTNAME
AIX	lsattr -E -l sys0
FreeBSD	sysctl -a
Solaris	sysdef -i