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.
Improving individual query performanceYou can test, monitor, and improve queries.
Monitor transactionsYou can monitor transactions to track open transactions and the locks that those transactions hold. You can use several onstat utility options to view transaction, lock, and session statistics.

Monitor transactions

You can monitor transactions to track open transactions and the locks that those transactions hold. You can use several onstat utility options to view transaction, lock, and session statistics.

The following onstat command-line options display session information.


To monitor	Displays the output of	See
Transaction statistics	onstat -x	Display information about transactions
User session statistics	onstat -u	ids_prf_696.html#ids_prf_696
Lock statistics	onstat -k	ids_prf_695.html#ids_prf_695
Sessions running SQL statements	onstat -g sql `session-id`	Display statistics on sessions executing SQL statements

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.