empdblogstat

EMPDBLOGSTAT(1)                                                EMPDBLOGSTAT(1)



NAME
       empdblogstat - analyzes and displays data from the Empress Database Log
       File

SYNOPSIS
       empdblogstat LOGFILE_SPEC [KEYWORDS]...  [START_TIME  END_TIME  [INTER-
       VAL]] [dump]



DESCRIPTION
       Empress  Database  Log Analyzer Utility empdblogstat is used to analyze
       and display data from the Empress Database Log File.  Empress  Database
       Log  File  is created on a first access to an Empress Database. It con-
       tains useful information that could  be  used  in  order  to  get  more
       insight in the usage of the particular Empress Database.


       dump   option  which  suppresses most of the labels and forces printing
              values alone.  The values are separated by the special separator
              character CTRL-V.


LOGFILE_SPEC
       Log File Specification.

       DB_NAME
              This  utility  will retrieve the Database Log File name from the
              tabzero file, which contains default  values  for  a  number  of
              Empress database administrative variables.

       -f LOGFILE_NAME
              the  program  will  look  for  a  Database  log  file named LOG-
              FILE_NAME.


KEYWORDS
       keywords can be any combination of:

       user (or uniqueusers)
              Display unique user information

       conn (or connections)
              Display number of connections

       dur (or connectiondurations)
              Display connection duration

       lic (or licenceexceeded)
              Display number  of  rejected  connections  due  to  insufficient
              licenses


START_TIME
       start point to analyze statistical data, with following input format :

       start  start from the beginning of log file

       "yyyy-mm-dd hh:mm:ss"
              Full date and time. This should be specified as a quoted string.

       hh:mm:ss
              use today as date


END_TIME
       end point to analyze statistical data, with following input format :

       end    end at the end of log file

       "yyyy-mm-dd hh:mm:ss"
              Full date and time. This should be specified as a quoted string.

       hh:mm:ss
              use today as date


INTERVAL
       sample period to collect data for analyzing, with the input format:

       hh:mm:ss
              The  default  value  is calculated as: (end_time - start_time) /
              10. If the result is less than a second, a second will be chosen
              as the interval value.

FILES
       EMPRESS database files.

SEE ALSO
       empsql(1)

       Empress: Empress Database


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.             EMPDBLOGSTAT(1)