Redistribution event log files

During data redistribution event logging is performed. Event information is logged to event log files which can later be used to perform error recovery.

When data redistribution is performed, information about each table that is processed is logged in a pair of event log files. The event log files are named database-name.database-partition-group-name.timestamp.log and database-name.database-partition-group-name.timestamp.

The log files are located as follows:

The homeinst/sqllib/redist directory on Linux® and UNIX operating systems
The db2instprof\instance\redist directory on Windows operating systems, where db2instprof is the value of the DB2INSTPROF registry variable

The following is an example of the event log file names:

SAMPLE.IBMDEFAULTGROUP.2012012620240204
SAMPLE.IBMDEFAULTGROUP.2012012620240204.log

These files are for a redistribution operation on a database named SAMPLE with a database partition group named IBMDEFAULTGROUP. The files were created on January 26, 2012 at 8:24 PM local time.

The three main uses of the event log files are as follows:

To provide general information about the redistribute operation, such as the old and new distribution maps.
Provide users with information that helps them determine which tables have been redistributed so far by the utility.
To provide information about each table that has been redistributed, including the indexing mode being used for the table, an indication of whether the table was successfully redistributed or not, and the starting and ending times for the redistribution operation on the table.