Problem:

How can I fix a slowly query problem on Linux ES4 (CentOS 4)?

Resolution:

There is a known problem with version 11 (and previous versions).  However, there is a service pack available on ftp.liant.com.  

Here are the instructions to install it:

1) ftp ftp.liant.com

2) Login with anonymous, using your email address as the password.

3) cd pub/rel/outgoing

4) binary

5) get reldbsrv1100SP2LNX.zip

6) bye

7) Unzip reldbsrv1100SP2LNX.zip.  The password is '30Nov07'.  Extract the contained file reldbsrv1100SP2LNX.tar.

8) Binary ftp reldbsrv1100SP2LNX.tar to the RelRM11.00 on the machine running the Data Server.

9) Login as root to the machine running the Data Server.

10) Change directory to the RelRM11.00 directory.

11) mkdir save

12) mv reldbsrv save

13) mv reldbsrv.rm save

14) mv relfm_rm.o save

15) tar xvf reldbsrv1100SP2LNX.tar

16) ln reldbsrv.rm reldbsrv

17) ./STOP

18) If the Data Server is configured to automatically restart, then the STOP command should report that it has restarted. If the Data Server is not configured to automatically restart, restart it with the command ./RUN.    The patched Data Server should now the running.

This service pack contains the fix present in the previous service pack.