Home
AdministeringIn addition to administering the database server, you can tune performance, replicate data, and archive data.
System administrationThese topics contain concepts, procedures, and reference information for database and database server administrators to use for managing and tuning HCL Informix® database servers.
Performance GuideThe Informix® Performance Guide describes how to configure and operate your HCL Informix® database server to improve overall system throughput and to improve the performance of SQL queries.
Effect of configuration on CPU utilizationThe combination of operating-system and Informix® configuration parameters can affect CPU utilization. You can change the settings of the Informix® configuration parameters that directly affect CPU utilization, and you can adjust the settings for different types of workloads.
Virtual processors and CPU utilizationWhile the database server is online, you can start and stop virtual processors (VPs) that belong to certain classes.
Monitoring virtual processorsMonitor the virtual processors to determine if the number of virtual processors configured for the database server is optimal for the current level of activity.
Using SMI tables to monitor virtual processorsYou can get information from system-monitoring interface (SMI) tables to use to monitor virtual processors.

Using SMI tables to monitor virtual processors

You can get information from system-monitoring interface (SMI) tables to use to monitor virtual processors.

You must connect to the sysmaster database to query the SMI tables. Query the sysvpprof SMI table to obtain information about the virtual processors that are currently running. This table contains the following columns.


Column	Description
vpid	ID number of the virtual processor
class	Class of the virtual processor
usercpu	Seconds of user CPU consumed
syscpu	Seconds of system CPU consumed

Rate this topic

5 stars 4 stars 3 stars 2 stars 1 star

Comment on this topic.

By clicking this box, you acknowledge that you are NOT a U.S. Federal Government employee or agency, nor are you submitting information with respect to or on behalf of one. HCL provides software and services to U.S. Federal Government customers through its partners immixGroup, Inc. Contact this team at https://hcltechsw.com/resources/us-government-contact. Do not include any personal data in this Comment box.