System shutdown

Automatic Server shutdown

 
For simplicity both the EDMserver^ and the _EDMappServer^_ (s) can be stopped automatically using a command script calling another command script. The example below shows how to do it. The EDMconnector™ is used instead of the EDMsupervisor™, because the no license problem will be obtained. The command script can for example be named "stop_servers.cmd" and contain the line:
%EDM_HOME%\bin\Edms_connector.exe shutdown_edm.EDM_SCRIPT
The script "shutdown_edm.EDM_SCRIPT" must contain the lines:
RemoteSystems>Servercontext>DefineContext(shutdown, superuser, $, pwd, tcp, localhost, 9090, $, $, $, $, $, $, $, $)
RemoteSystems>Server>Terminate>(shutdown, pwd, $,"ALL_SERVERS,FORCE_TO_TERMINATE")
Exit>Exit()
 
The password named 'pwd' must be edited correctly. Before using the script "stop_servers.cmd", all users should be informed to log off from the database. See how the servers were started in Automatic Server start-up

EDM Server shutdown

 
The EDMsupervisor™ or EDMconnector™ should be used to stop the EDMserver™ and the EDMappServer™(s) in a controlled way, either manually or automatically with a script (see next chapter). Before the EDMdatabase™ is stopped, it is advised that all clients (users) should complete their work and log out – or they are interrupted and may lose some of their work. The EDMserver™/ EDMappserver^ should not be handled as a simple application that can be started and stopped at any time by just shutting down the processes.
By default the configuration parameter EDM_TRANSACTION_SECURITY is set to BIM_LOG (Before Image Log). This normal setting should secure that all committed transactions are stored (safe) into the EDMdatabase^. In case of an abnormal termination of the EDMserver™ no committed transaction should be lost with this option.
The EDMsupervisor™ is available both as an EDMfatClient & EDMremoteClient (edms_client.exe) and as an EDMstandAlone and & EDMremoteClient (edms.exe). Therefore a double set of commands is available. The EDMconnector™ only has the EDMremoteClient commands available. Both sets of commands are given below:
 

 
Note: These commands will stop the EDMserver™ and all EDMappServers™ if the option ALL_SERVERS is used. The option FORCE_TO_TERMINATE will force the servers to terminate even if some clients are connected.

System Startup

Automatic Server start-up

 
For simplicity both the EDM Server and the EDM Application Server(s) can be started automatically using a command script. This script can be written/modified by a person knowing a little about Windows script programming. An example is presented below to show how to do it. This script can for example be named "start_servers.cmd" and contain the lines:
start edmserver –s9090 –l../projabc/db -nabc –pabc –o
start edmappserver.exe –s9090
start edmappserver.exe –s9090
 
Then the servers needed to operate on database "abc" (with name "abc" and password "abc") can be started from the directory where this script is stored with the simple command: "start_servers".

EDM Application Server start-up

 
At least one EDM Application Server, called EDMappserver^, is needed to use the EDMI Remote Interface. The EDMappserver^ allows multiple clients to access the EDMserver^ simultaneously, and encloses all work intensive operations to improve performance.
The EDMappserver^ is available for the WINDOWS platform.
The program is located in the %EDM_HOME%\bin directory.
Due to performance reasons, the EDM Application Server(s) will normally run in the same system as the EDMserver^. However, the configuration is so flexible that an EDMappserver^ may run in any system in the network.
Some options are available when the EDMappserver^ is started. The only mandatory parameter is the server port number. Some of the trace output from the EDMappserver^ is added to the trace generated from the EDMserver^ to produce a complete trace list. Under normal conditions, no trace output should be used.
Some of the options (can be lower or upper letter) are listed below:
-h<host-name> specify the server host name (default is localhost)
-s<port-number> specify the server port number
-ap<port-number> specify EDMappserver^ port number (By default, the EDMappserver™ port number is incremented by 1 for each EDMappserver^ process started, starting at the EDMserver^ port number +1)
-t trace message headers
-w trace message body
-?  display the complete options list
 
Examples of EDMappserver^ startup commands:
start %EDM_HOME%\bin\edmappserver – s4530
or
start edmappserver.exe –s9090 –t -w

EDM Database Server start-up

 
The EDMserver^ version 5.0 is running on the Windows platform. Supported environment is described in the EXPRESS Data Manager^ Installation Guide.
The EDMserver^ may be installed on a dedicated host (PC) or on the same PC where the EDM client is running. The program is located in the $EDM_HOME\bin directory.
EDMserver^ is started with a list of selected startup parameters. The only mandatory parameter is the server port number. For debugging purposes it is useful to use the trace output parameters, but under normal conditions no trace should be used. It is possible to connect to the database directly when the EDMserver^ is started, by giving database location, database name, database password and one of the database options, like -o.
Some of the options are listed below. Options are case insensitive. For a complete list, use the -? or –h option.
-s<port-number> specify server port number
-l<db-location> specify database location (directory containing database)
-n<db-name> database name
-p<db-password> database password
-c create database
-d delete database (will destroy old database!)
-o open database
-t trace message headers
-w trace message body
-?  display the complete options list
 
Examples of EDMserver^ startup commands:
start %EDM_HOME%\bin\edmserver.exe –s9090 –t –w
or
start %EDM_HOME%\bin\edmserver –s4530 –Lc:\home\db -Nmydb –Ppwd –o
There is also implemented command line options for scheduled online backups, please see EDMserver Scheduled Online Backup if you want to use these options.