Managing Informix Dynamic Server using the Informix Enterprise Command Center

Table of Contents

Informix Enterprise Command Center (IECC) 

Rational Object manager 2.1 

Download ROM 2.1  

Informix Enterprise Command Center 

Goals of Performance Tuning 

Using the IECC to access the Sysmaster database  

What is the sysmaster database? 

What is the sysmaster database? 

Sysmaster database contains: 

SQL access to server information 

Key Tables in the Sysmaster Database 

Example SQL: dbwho.sql 

Dbwho shell script 

Performance of queries on sysmaster database 

Differences from other databases  

Isolation level is Dirty Read 

Using Triggers and Stored Procedures 

Sysmaster database may change 

Server configuration and statistics tables: 

Sysconfig (onstat -c) 

What is the current server configuration? 

SQL output 

Sysdri (onstat -g dri) 

Syslogs (onstat -l) 

What is the status of the logical logs? 

SQL output 

Sysprofile (onstat -p) 

What are some of the key server statistics? 

SQL output 

What percent of I/O is from buffers? 

SQL output 

Sysprofile values 

Sysvpprof (onstat -g) 

What is the status of the virtual processors? 

SQL output 

Dbspace & chunk tables: 

Sysdbspaces (onstat -d) 

Syschunks (onstat -d) 

Syschunks (continued) 

Syschkio (onstat -D) 

Syschfree* 

How much dbspace is free? 

SQL output 

How much blobspace is free? 

SQL output 

Where are blocks of free dbspace? 

SQL output 

What chunks have the most I/O? 

SQL output 

What is the status of chunks? 

SQL output 

Database & table information tables: 

Sysdatabases 

Systabnames 

Sysextents (oncheck -pe) 

Sysptprof 

Sysptprof (continued) 

Systabinfo* 

Systabinfo* (continued) 

What databases are on the server? 

SQL output 

What tables have extents? 

SQL output 

How calculate new extent sizes?  

SQL output 

What tables have the most I/O? 

SQL output  

User session information tables: 

Syssessions (onstat -g ses) 

Syssessions (continued) 

Syssesprof (onstat -g ses) 

Syssesprof (continued) 

Syslocks (onstat -k) 

Syslocks (continued) 

Syseswts 

List all Active Sessions 

List Users Waiting on Resources 

Monitor Resource Usage by User 

Display all Locks using Base Sysmaster Tables (1 of 2) 

Display all Locks (2 of 2) 

Some Undocumented Extras... 

Display Transactions and Logs  

Display Transactions and Logs (1 of 3) 

Display Transactions and Logs (2 of 3) 

Display Transactions and Logs (3 of 3) 

Display Transactions and Logs SQL Output 

Display Current SQL 

Current SQL Output 

Conclusion  

Contact information:

Email: lester@advancedatatools.com 

Home Page: www.iiug.org/~waiug/ 

Other information: 
Washington Area Informix User Group Forum 98 Presentation