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)