The Tbstat Utility
The tbstat program gives you instantaneous data about the contents of the shared memory structures. It takes very little CPU time, and locks no tables and creates no latches. As such, you can consider that tbstat is essentially "free"; that is, it has a minuscule effect on database performance. You can let it run continuously in the background if you wish, collecting performance data and usage data with little or no performance cost.
There is only one option that could possibly cause you any problems, and that is the tbstat -o filename option. This option places the entire contents of shared memory into a file specified by filename. If you have a large shared memory, be sure that you have sufficient room in your UNIX file ...
Get Informix DBA Survival Guide, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
