Shut down servers in the following order:
To stop Historical Server on Windows NT, use any of these methods:
Click the Stop button on the Windows NT Control Panel Services window.
Issue the hs_shutdown command from isql.
If start-up was done from the command-line or by means of a batch file, then Historical Server is associated with the login that started it. In these cases, you cause Historical Server to shut down if you close the window in which the Historical Server was started or log off of the system.
If the controlled shutdown of Historical Server takes longer than a predetermined time interval (five seconds for closing the window or twenty seconds for logoff), the system displays a pop-up dialog box at regular intervals, asking you whether or not to terminate the process.
WARNING! Unless you respond with Wait each time the dialog box is presented, Historical Server shuts down in an uncontrolled way, risking data loss and file corruption.
To stop Historical Server using isql:
Connect to Historical Server using isql:
isql -Uhs_supersuer_name -Phs_superuser_password -Shistorical_server
superuser_name is the name that was used with the -U parameter to the Historical Server start-up command. If -U was not used in the start-up command, any user can stop Historical Server, and this parameter is optional.
superuser_password is the password that was used with the -P parameter to the Historical Server start-up command. If -U was not used in the start-up command, any user can stop Historical Server, and this parameter is optional.
historical_server is the name of the Historical Server you want to stop.
To determine current activity on Historical Server, issue the following command when the isql prompt appears:
1> hs_status activity 2> go
When the isql prompt appears, issue one of the following commands:
1> hs_shutdown 2> go
1> hs_shutdown no_wait 2> go