Using Monitoring and Tracing Tools

This chapter describes monitoring and tracing tools that help you troubleshoot the Ingres installation.

Supported Monitoring and Tracing Tools

A number of tools are available to help you troubleshoot and maintain your installation. In addition to the standard commands and utilities, the tools include:

Special purpose utilities:
- Ingres system utilities
- Operating system utilities
Trace utilities:
- Ingres trace utilities
- Operating system trace utilities

Note: You can use Ingres Visual Manager, Visual Performance Monitor, and VCDA to visually monitor and maintain your installation. For additional information about these tools, see the chapter "Managing Your System and Monitoring Performance" and online help.

System Utilities

Ingres system utilities monitor aspects of the installation for troubleshooting or other special purposes. The system utilities are not needed for normal operation and are generally used with the help and advice of Technical Support. For more information about system utilities see the Command Reference Guide.

Day-to-day Ingres commands follow:

	Command	Name	Description
	cacheutil	Shared Buffer Cache Utility	Lists status information on active shared memory segments; can also be used to deallocate an inactive shared memory buffer cache.
Windows:	ipcclean	Shared Memory Allocation	Deallocates shared memory.
UNIX:	csinstall, cscleanup, ipcclean csreport	Shared Memory Allocation	Allocates, deallocates, and lists status of UNIX shared memory and semaphore resources. Allocation is based on the value assigned II_LG_MEMSIZE.
	iimonitor	Server Maintenance Utility	Lists DBMS server information; also allows a privileged user to stop the server or an active session.
	iinamu	Name Server Utility	Lists current servers; also allows a privileged user to add and delete servers.
VMS:	iishowres	Show Resources	Lists shared memory used by the locking and logging system.
	lartool	Logging, archiving and recovery tool	Allows the system administrator to manually abort or commit a distributed transaction involved in two-phase commit protocol.
	lockstat, logstat	Locking, Logging Status	Display information from the locking or logging system. These functions are replaced by the forms-based ipm utility.
	rcpconfig	Logging/ Locking Configuration	Manipulate log files or shut down the logging/locking systems (RCP module).
	ija	Logging, archiving, and recovery tool	Allows the system administrator to manually abort or commit a transaction involved in two-phase commit protocol.