7. Using Monitoring and Tracing Tools : System Utilities
 
Share this page                  
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