# empclean

    EMPCLEAN(1)                                                        EMPCLEAN(1)

    NAME
           empclean - Empress database integrity assurance utility

    SYNOPSIS
           empclean -m config_file

           empclean [-verify] database [commands ...]

           empclean [-verify] -f config_file [database [commands ...]]

    DESCRIPTION
           empclean  reports  on  and  repairs database inconsistencies.  Problems
           with dangling locks, transactions, temporary files, coordinator  infor-
           mation and other database problems can be detected and resolved.

           Regardless of which operations you specify in the configuration file or
           on the command line, empclean (except 'empclean  -m')  always  performs
           the following "basic set" of operations.  These operations must succeed
           before further checks can be done:

                o detect and resolve dangling transactions

                o detect and clear dangling locks

                o detect and restart dead servers and clear dangling

                o server locks and clients

                o detect and remove dangling coordinator information

                o detect and create missing shared memory

           -m config_file

                     Create a new  configuration  file  named  config_file.   This
                     starts  an interactive session during which empclean collects
                     information that it uses to create the file config_file.

           -f config_file

                     Execute the operations specified in config_file.   This  con-
                     figuration  file contains information about the host on which
                     you run empclean, servers, the databases you wish to examine,
                     the  clients of those databases and the temporary directories
                     you wish to clean up.

           database [command ...]

                     If preceded by the option '-f config' then execute the opera-
                     tions  specified  in  config for database only.  If a command
                     list is specified, only  those  commands  are  executed.   If
                     database is specified and the -f option is not specified, the
                     basic set of integrity check is performed in addition to  any
                     commands in the command list.

                     command must be one of:

                     data_check     detect and repair bad .rel and .dtf files

                     rebuild_user_indices  Recreate user table indexes.

                     recompile     recompile missing sys_dictionary entries

                     recompile_all  recompile sys_dictionary entry for all tables

                     replication_check  urge  logical  deleted  records  from mas-
                                    ter/replicate tables if required

                     table_check    remove dangling files  in  database  directory
                                    and remove dangling data dictionary entries

                     temp           remove dangling temporary files

           -verify

                     This  option  displays  the  problems which are found and the
                     changes which would be made to the database if the operations
                     in the specified configuration file were performed.  However,
                     the database is not modified.

    FILES
           Empress database files
           Empress transaction logs

    SEE ALSO
           Empress: Database Administrator's Guide

    DIAGNOSTICS
           Error messages are printed if a database is not  specified  or  if  the
           database is not a valid 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.                 EMPCLEAN(1)