Log Files

About Log Files

Several log files are generated during database creation, loading of seed data, regular and text index management, database administration and other EDM related activities. These log files are stored under $EDS_HOME/log directory. The log files are in the format:

<function name>_<instance name>_<database name>
. For example: CED_<instance>_aspdb

Where:

  • CED indicates create an empty database
  • <inst1> is the name of the instance
  • aspdb is the name of the database.

This table lists some of these log files:

Log File Description

Datebase Creation

CED_<instance name>_<database name>.log contains a list of database creation and tablespace creation steps.

CED_CUF_<instance name>_<database name>.log is a log of libraries linked to the user defined functions.

<instance name>_<database name>_summary.txt is a log of database configuration parameters and tablespaces used to create the database.

Load Seed Data

LSD_CREATEALL_<instance name>_<database name>.log is a log of CES system classes, sequences,  indexes and triggers that are created during Load Seed Data operation.

LSD_LOADALL_<instance name>_<database name>.log is a detailed log of the loading of seed data to CES system classes.

Database Upgrade

UDB_<instance name>_<database name>.log is a log file containing database upgrade steps.

UDB_CREATE_STOREDPROC_<instance name>_<database name>.log is a log of CES stored procedures that are created during the Database Server Upgrade operation.

Validate_<instance name>_<database name>.rep is a summary report of the validation checks on the CES system objects of stored procedures, functions, user defined functions and triggers.

Text Index Management

TIM_<instance name>_<database name>.log is a log of all Text Index Management operations.

CES Object Management

EOM_<instance name>_<database name>.log is a log of all CES Object Management operations.

Analyze Database Objects

ANL_<instance name>_<database name>.log contains details of all Analyze Database Objects operations.

Regular Index Management

RIM_<instance name>_<database name>.log is a log of all Regular Index Management operations.

Database Administration

DBA_<instance name>_<database name>.log is a log of all Database Administration operations.

DBA_EXP_<instance name>_<database name>.log is a log of the Export Database operation. This log gives a list of the tables exported and the number of rows of data exported.

DBA_IMP_<instance name>_<database name>.log is a log of the Import an CES database operation. This log lists the database create statements executed and lists the results of data loading to tables.

Session Log

EDM<datetime>.log is a log file containing details of the current EDM session.

Temporary Files in the Log Directory

This table lists the temporary script files that are generated in the $EDS_HOME/log directory, and can be used for debugging purposes:
 

File Description

Database Creation

crdb_<instance name>_<database name>.sh

ConfigDbase_<instance name>_<database name>.sh

dbmConfigDbase_<instance name>_<database name>.sh

Text Index Management

crTextSpace_<instance name>_<database name>.sh is generated during the creation of CISTEXT_SPACE tablespace.

Analyze Database Objects

runstats_<instance name>_<database name>.sh is generated during the Update Statistics and Rebind Packages options.