# 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)