6. Troubleshooting Ingres : Performance Problems : Diagnose DBMS Server Due to Logging System Problem
 
Share this page                  
Diagnose DBMS Server Due to Logging System Problem
Use the following procedure to diagnose a DBMS server that is not responding due to logging system problems.
1. Check the logging system by issuing the following command at the operating system prompt to invoke the logstat utility:
Windows:
logstat | more
UNIX:
logstat | more
VMS:
define sys$output filename
logstat
deassign sys$output
2. If you are unable to start up logstat, the recovery process (see page Recovery Process Monitoring) has probably taken an exclusive lock and is in recovery.
3. If logstat starts up, check the status field, as described in Logstat Status Fields (see page Logstat Status Fields).