The IBM® Informix® Health Advisor Plug-in for OpenAdmin Tool (OAT) analyzes the state of the Informix database server. The Health Advisor plug-in
gathers information about the database server, the databases, and the operating
system, and creates a report that contains the results and recommendations.
The Health Advisor plug-in includes a series of alarms that check
conditions on the database server: configuration, Enterprise Replication (ER),
operating system (OS), performance, and storage. You can create profiles that specify the alarms that are
enabled and the thresholds for the alarms. You can schedule a task to run the Health Advisor with a
specific profile at regular intervals. You can specify who receives an email notification of the
results. You can also run the Health Advisor on demand on the current
profile and view the report.
Here's an example of some of the types of advice the Health Advisor can give you:
Red Alarm DBSPACETEMP
The DBAPCETEMP configuration parameter is not set. For best
performance with temporary tables and sort files, use the DBSPACETEMP
configuration parameter to specify two or more dbspaces on separate
Red Alarm Logical Log File Storage
The logical log files are stored in the root dbspace (rootdbs).
Move the logical-log files out of the root dbspace to a dbspace on a
disk that is not shared by active tables or the physical log.
Red Alarm Physical Log Storage
The physical log is stored in the root dbspace (rootdbs). Move the
physical log out of the root dbspace to a dbspace on a disk that is not
shared by active tables or the logical log files.
Yellow Alarm OS Virtual Processors
The number of CPU virtual processors is less than 50.00
% of the CPUs in the operating system. Increasing the number of CPU
virtual processors might improve performance. Take appropriate action to
increase the number of CPU virtual processors.
Yellow Alarm Disk Sorts
The number of disk sorts is greater than 1.00 % of
total sorts. The current number of disk sorts is 1.22 %.
Investigate options for adding additional shared memory for sorts.