• Topic
  • Discussion
  • UdaWikiWeb.TroubleshootingUDADBMSVersions(Last) -- Owiki? , 2016-08-19 15:01:06 Edit owiki 2016-08-19 15:01:06

    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)
    AIX lsattr -E -l sys0
    FreeBSD sysctl -a
    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
    Solaris sysdef -i
    Tru64 sysconfig
    dxkerneltuner
    cat /etc/sysconfigtab
    cat /sys/conf/ HOSTNAME

    Referenced by...