I seem to have gone brain dead. How would I know when the DOORS database server last started or stopped? surely there is some logging I've forgotten about.
PRM 27000164XW1 Post
Re: Database Start/Stop Logging2013-08-28T00:24:52ZThis is the accepted answer. This is the accepted answer.
Two possible ways of doing this.
- Wade your way through the myriad of system events logged by the Windows Event Viewer console.
- Configure DOORS to create a DB Server Log - this will record when the DOORS DB Service has been started and stopped plus a lot of other stuff, just search for "starting server" and "Shutdown"
If you're interested in option 2, here is what you need to do
- Create two new string values in the Registry - the registray path below is for DOORS 9.2 and earlier, it will be something similar for DOORS 9.3 and beyond but perhaps under a Rational or IBM folder.
- HKEY_LOCAL_MACHINE\SOFTWARE\Telelogic\DOORS_Server\9.x\Config (In Windows 7 or the latest Winows Server O/S's, this path could be HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Telelogic\DOORS_Server\9.x\Config)
- Create a "LogLevel" string value and set the value to 4
- Create a "LogFile" string value and enter the path and filename of where you want the text log file to be dumped.
- The DOORS DB Server must be restarted for logging to start.
- Caution - this can load down the server if there is a lot of user activity going on. The log file will rapidly fill and may need to be cleared out every day.
Pekka_Makinen 120000QEGF5 Posts
Re: Database Start/Stop Logging2013-08-28T13:15:28ZThis is the accepted answer. This is the accepted answer.
- PRM 27000164XW
Windows Event Viewer has also Find function - of course might be dependent on version, but at least on my Windows 7 Pro I can use Find to search for DOORS items in the System log. There is also a Filter, but I have not been successful with that.
kourosh 27000212K626 Posts
Re: Database Start/Stop Logging2013-08-28T22:22:55ZThis is the accepted answer. This is the accepted answer.
You can also check the $ServerData folder on the DOORS server machine and look at what the creation date of a file called servdata.dtc is. This file gets created every time the DOORS database server is started. But don't mess with the file itself or any of the other data files!Updated on 2013-08-28T22:24:21Z at 2013-08-28T22:24:21Z by kourosh