Use the following guidelines to troubleshoot heavy problems:
- Patch databases and operating systems regularly.
- Contact database and o/s vendors to see if patches are
associated with problems.
- Insure Unix kernel tuning parameters match parameters specified
by database and o/s documentation.
- Insure your machine has adequate memory and processor
- Comparison test Multi-Tier drivers when Single-Tier drivers
appear to expose limitations in a database native client.
- Re-link Multi-Tier database agents against databases,
especially patched databases.
- Insure PortHigh is set in the [Protocol TCP] section of the
Multi-Tier Session Rules Book. This is the oplrqb.ini file that
resides in the /bin sub-directory of the server components
- Multi-Tier users perform the following test:
- login to the machine that contains the OpenLink server
- Run oplshut -s on the command-line.
- Compare the output to the Windows Task Manager or Unix ps
- Upgrade server components if oplshut shows fewer processes when
compared to the Task Manager or ps.
Multi-Tier users experiment with database agent reuse. Users
should do comparison test with the following values:
- ifsame process, upto 5
- ifsame application, upto 5
- ifsame database, upto 5