# empsvadm

    EMPSVADM(1)                                                        EMPSVADM(1)

    NAME
           empsvadm  -  provides   server  administrative  functions  for  Empress
           Servers.

    SYNOPSIS
           empsvadm -help

           empsvadm SERVER_NAME COMMAND

    DESCRIPTION
           empsvadm is the Empress Server  Administration  Utility.  It   provides
           administrative functions  for Empress Servers. An Empress Server can be
           a Replication Master Server, an ODBC Server, or a Database Server.

           This  utility is backward compatible with empsvadm utility that is used
           for  Database  Server.  Some   of   the   functionalities  are   common
           between  the old usage of utility and the new usage. In this case,  the
           old  functionalities are mapped to the  new  ones, and will be declared
           as obsolete function, but they will  be  retained  for  backward   com-
           patibility.  There  are  some functionalities that are only retained to
           be used with DB Server.

           For Replication Master Servers and ODBC Servers, Operation of  empsvadm
           are starting  an Empress Server, closing the connection of a client  of
           an Empress   Server,  getting  information   on   the  running  Empress
           Server  and  its  components, resetting maximum and minimum number   of
           Service Servers, stopping  an  Empress Server, regenerating  components
           of  an  Empress  Server, interrupting   an   Empress Server, and chang-
           ing the login password of the administrator and  users  of  an  Empress
           Server.

           For   Database   Servers,  empsvadm  lists  information  and statistics
           about  the  server,  shuts  down  the  server, removes client processes
           from  a  server,  changes  the number of  server   sub-processes,   and
           generates  diagnostics reports.   It  can  be  executed  on  either   a
           client  or  the host machine.

           For   Replication   Master Servers and ODBC Servers, Network Configura-
           tion Files are  either  of  the  Network  Server   Configuration  Files
           pointed  to by environment variable MSNETSERVERCONFIGFILE,  or  Network
           Type  Configuration   File pointed  to  by  environment variable MSNET-
           TYPECONFIGFILE.  Network Configuration   File   contains  configuration
           attributes  describing general  information about Empress Servers.  The
           SERVER_NAME  must be a valid Empress  Server as  named by NAME configu-
           ration attribute and described  in  the  Network  Server  Configuration
           File.

           For  Database Servers, Server Configuration File is pointed to by envi-
           ronment  variable MSSERVERCONFIGFILE. The SERVER_NAME must be  a  valid
           Database Server as described in the Server Configuration File.

           Some  of  the  functions  of empsvadm explained below are indicated  as
           "Administrative".  This  means   that   the requestor of  the  function
           must  be indicated by the of configuration attribute "ADMINISTRATOR" in
           network configuration files.

           -help  Displays a brief usage of the command and exits

    COMMAND for all Empress Servers
           These commands apply to all Empress Server Types.

           close CLIENT_ID
                  (Administrative)  Closes  the  client  connection  specified  by
                  CLIENT_ID.

           info   Provides  information about the Empress Server. This information
                  includes  type of the server, administration  port  and  service
                  port   numbers,    Server    IDs   assigned  by  Empress  Server
                  SERVER_NAME, Process IDs assigned by Operating  system,   number
                  of  clients currently  being  serviced by each server.  Minimum,
                  Maximum and currently  running  number  of  service servers,  as
                  well  as   information   about   all  the active clients of each
                  server  are  shown  by this command.

           start [START_OPTION]
                  (Administrative)  Starts  a  new Empress server.  A  logfile  to
                  keep  the history of the operations  performed  by  a server and
                  requests being made to the server   will   be   created     with
                  the name SERVER_NAME.log  if  not specified  differently by LOG-
                  FILE configuration attribute  of  Network  Configuration   File.
                  For  Replication  Master  Server and Empress Connectivity (ODBC)
                  Server,   START_OPTION   is    [-f    SERVER_START_CONFIG_FILE].
                  SERVER_START_CONFIG_FILE  is a configuration file that specifies
                  the tables that will be handled by SERVER_NAME.

           stop [force]
                  (Administrative)   Stops   the  Empress  Server  by  terminating
                  idle  service  servers,  the admin  server  and spooler. If used
                  without [force] option, the busy servers  will   be   terminated
                  only  after   their   task  is completed.  Option [force] causes
                  all idle and  busy  servers  to  stop  their  execution  immedi-
                  ately.

    COMMAND for Replication Master Servers and ODBC Servers
           These   commands   apply   only  to Replication Master Servers and ODBC
           Servers

           change_password [LOGIN_NAME]
                  (Administrative when changing other  users'  password)   Changes
                  the  password  for  users  (and  administrator)  of  the Empress
                  Server. If LOGIN_NAME is given, empsvadm will try to change  the
                  password  for the  user  with LOGIN_NAME. Only the administrator
                  of  an  Empress Server  can change other users' password.

           interrupt SERVER_ID
                  Sends  an interrupt to the server with SERVER_ID ID number.

           servers MIN_SERVERS [MAX_SERVERS]
                  (Administrative)  Changes   the   minimum   number   of  service
                  servers     that   should    be   started   by  SERVER_NAME.  If
                  MIN_SERVERS  service servers   are  busy,   the   spooler   will
                  spawn  more  services up to MAX_SERVERS number.  The default for
                  MAX_SERVERS is MIN_SERVERS. The initial maximum and minimum num-
                  ber  of  service  servers are  in  Network  Configuration Files,
                  specified   by   configuration  attributes  NUM_SERVERS_MIN  and
                  NUM_SERVERS_MAX.

           refresh
                  (Administrative)  The  Empress Server  refreshes  its components
                  by  terminating the  idle  servers,  and  creating  new  servers
                  instead of them.

    COMMAND for Empress Database Servers
           These commands apply only to Empress Database Servers

           svnprocs NPROCS
                  (Administrative)  Modifies  the  number  of server sub-processes
                  attached to the server.  If the number is increased, new clients
                  are  allocated  to  the  new server  processes.  If  the  number
                  is  decreased, server  sub-processes  without  any  clients  are
                  termi  nated   until  the correct number of server sub-processes
                  are left.   If  all  server   sub-processes   are  assigned   to
                  clients,  the  command  will  wait  until  a  server sub-process
                  becomes free and will then  terminate it.

           svrmall
                  (Administrative) Removes all clients from a server.
                                This should be done before   the   svshut   option
                  is
                                used.

           svshut Shuts  down  the  server.  All the server processes will be ter-
                  minated.

           svstats
                  Provides   detailed   statistics   about   the   server.   Basic
                  information  provided  by  the svinfo option is given as well as
                  cumulative  statistics  about the load  and  work  done  by  the
                  server.    Request   statistics   include   number  of  requests
                  received,  average size  of  requests  and   size   of   largest
                  request.  Counts of server and database operations  performed by
                  the server are given.  This information is useful for optimizing
                  the  server configuration  and understanding network traffic.

           svdiag [NUM_OF_SAMPLES]
                  Provides   a  diagnostic report of the communication between the
                  client and the server. The report  contains 5 sections:  Connec-
                  tivity, server Status, Maximum Packet Size,  Timing,  and  Reli-
                  ability.   The user can specify the number  of  sample  requests
                  sent to  the  server  for  generating  the   diagnostics report;
                  the default value is 10.

           svtiming PACKET_SIZE [NUM_OF_SAMPLES]
                  Provides  information  about  the  time required to send packets
                  of   the specified  size  between  the client  and server. There
                  are two kinds of measurement: a   client-server   trip   and   a
                  server-client trip.  A client-server  trip  is the time interval
                  between the instant the client sends a  packet  of  the   speci-
                  fied  size  to the server and the instant the client receives an
                  acknowledgement (ACK)  packet  (a   relatively   small   packet)
                  from  the  server.   A  server-client  trip is the time interval
                  between the instant  the client sends a request packet (a  rela-
                  tively  small  packet) to the server and the instant the  client
                  receives a packet of the specified size from  the  server.   The
                  user  can specify  the  number of  sample  requests  sent to and
                  received from the server; the default value is 10.

                  The empsvadm commands svstats, svinfo, svdiag, and svtiming  can
                  be used by any user.  The commands svrmall and svnprocs can only
                  be used by the server administrator or  the   user  who  started
                  the Server.

    FILES
           EMPRESS database files.

    SEE ALSO
           empsv(1)

           Empress: Database Server

    HISTORY
           Written  by  Empress  Software  Inc..   All material is copyrighted and
           licensed.  Use on non-licensed CPUs is prohibited.

    Empress 8.62                 Empress Software Inc.                 EMPSVADM(1)