2. Using Ingres Commands : logstat Command—Display Logging Status
 
Share this page                  
logstat Command—Display Logging Status
Permission required: Installation owner.
The logstat utility displays logging status. Logstat output has the following sections:
Logging System Summary
Current log file header
List of active processes
List of active databases
List of active transactions
Note:  Logstat functions are included in the forms-based Interactive Performance Monitor (ipm) utility. You can also monitor log information using Actian Director.
For more information on the information displayed by the logstat command, see the Interactive Performance Monitor User Guide.
The logstat command has the following format:
logstat [-buffers] [-databases] [-header] [-statistics]
[-processes] [-transactions] [-user_transactions]
[-special_transactions] [-all_transactions] [-verbose] [-help]
dynamic
-buffers
Displays list of log buffers and their usage
-databases
Displays information on databases connected to the logging system
-header
Displays current log file header
-statistics
Displays logging system summary
-processes
Displays a list of processes connected to the logging system
-transactions
Displays information on all transactions (same as -all_transactions)
-user_transactions
Displays information on user transactions
-special_transactions
Displays information on system transactions
-all_transactions
Displays information on all transactions (same as -transactions)
-verbose
Displays all information
-help
Displays command options online
dynamic
Displays a line of the current log information to a command window every few seconds