Quiescent, indicates that IDS is running in a single user mode where only DBA can do administrative and maintenance work.Off-Line, indicates that IDS is not running.There are six operating modes, of which three are particularly important: In this case, Informix engine is "On-Line". The first line of the output displays the current IDS operating mode. Ovlock ovuserthread ovbuff usercpu syscpu numckpts flushesīufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans Gp_read gp_write gp_rewrt gp_del gp_alloc gp_free gp_curs Using the tools discussed above, we can effectively monitor all those >IDS activities.Ĭopy $ onstat -p IBM Informix Dynamic Server Version 12.10.FC7W1 - On-Line (Prim) - Up 15:24:48 - 7443636 Kbytesĭskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cachedħ981981 99445393 926195831 99.15 1109300 15536008 14594451 95.49 IDS activities can be classified into three categories: Refer to the Performance Guide for Informix Dynamic Server for more details on the onperf utility. It can also save those statistics into a text file for later analysis. Onperf collects IDS server performance statistics and plots it into metrics. Informix also provides a graphical monitoring tool - onperf. To get current statistics, we need to do onstat -z to zero out the old values. Therefore, we need to be very careful about those statistics, and always take into account IDS running time.įor example, 100,000 bufwaits for a server that has been running over one month is a lot different that 100,000 bufwaits in a single day. One thing we need to pay attention to is that statistics collected either by onstat or in the SMI tables are cumulative from the time of system reboot or IDS initialization. The onstat utility always presents statistics in a fixed way, whereas using SMI tables permits you to reorganize those statistics in a more meaningful, more readable format. Numerous system monitoring interface ( SMI) tables in the sysmaster database, which is created automatically at the time of IDS first initialization.īoth the onstat utility and SMI tables monitor IDS performance by examining IDS shared memory activities,īut there is a difference in the way of presenting those statistics.Informix provides two major tools to monitor system and database performance:
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |