Recovery Process Monitoring
If you are monitoring Ingres startup after a machine reboot, the following messages are displayed:
Starting Ingres Name Server...
Starting Ingres Communications Server...
Starting Ingres Recovery Process...
If the transaction log contained uncommitted transactions when the machine failure occurred, the startup script pauses while the recovery process recovers transactions from the transaction log file. No messages are printed to the screen.
If you are in doubt as to whether recovery is taking place during startup, or to monitor the recovery process, use the following procedure.
Display the recovery process log file by typing the following command at the operating system prompt:
Windows:
%II_SYSTEM%\ingres\files\iircp.log
UNIX:
tail -f iircp.log
VMS:
II_SYSTEM:[INGRES.FILES]IIRCP.LOG_nodename
If the system is recovering, the recovery actions are logged to the IIRCP.LOG file. This indicates that Ingres is automatically recovering from possible inconsistencies.
Messages are printed to the log file during recovery:
• The message at the beginning of recovering transactions indicates that transaction recovery has begun.
• Intermediate messages track recovery progress. As recovery proceeds, progress messages (for example, “Recovered 31 of 130 transactions”) are displayed.
• When done, the following message is printed:
Recovery complete.
You can also use an operating system command to determine whether the recovery process is recovering transactions by checking to see if it is accumulating CPU time.
VMS:
You can issue the following command at the operating system prompt several times:
show process/cont/id=xxxx
where:
xxxx is the process ID of the recovery process.
If the CPU time and disk I/O count taken by the process is increasing, the recovery process is most likely recovering transactions from the log file.
UNIX:
On UNIX, you can also monitor the files in the database directory of the database you suspect of being the target of the updates that are being backed out. The following command entered at the operating system prompt shows whether data files are being updated:
ls -lt
The file most recently updated is listed first along with the time of last update.
If any of the monitoring techniques above indicate that transaction recovery is taking place, continue to monitor the recovery process until recovery has completed. When the recovery process is complete, CPU time is not accumulated.
After the recovery process has finished, restart the installation with the ingstart command. The ingstart utility first shuts down and brings up all required installation processes. Programs can connect to the databases.