Was this helpful?
System Utilities
Vector 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 Actian Support. For more information about system utilities see the Command Reference.
Day-to-day Vector commands follow:
Command
Name
Description
vwinfo
Vector database information utility
Lists information on the database, including various statistics, configuration settings, and disk usage of Vector tables.
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
Linux:
csinstall,
cscleanup,
ipcclean 
csreport
Shared Memory Allocation
Allocates, deallocates, and lists status of Linux 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
 
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
Displays information from the locking or logging system. These functions are replaced by the forms-based ipm utility.
This command can be run by any user and requires the database server to operational.
 
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
 
iilockstat, iilogstat
Locking, Logging Status
Identical to lockstat and logstat, this command displays the information from the locking or logging system with the following requirements:
- It can be run only by the installation owner.
- It can be run even if the database server is not operational.
Last modified date: 12/19/2024