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.
Red Alarm DBSPACETEMP
Red Alarm Logical Log File StorageThe 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 disks.
Red Alarm Physical Log StorageThe 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.
Yellow Alarm OS Virtual ProcessorsThe 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 Disk SortsThe 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.
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.