During data redistribution event logging is performed.
Event information is logged to an event log file which can later be
used to perform error recovery.
When data redistribution is performed, information about
each table which is processed is logged in a single redistribute event
log file.
The format of the event log file name is
database-name.database-partition-group-name.timestamp.log.
The log files are located as follows:
- The homeinst/sqllib/redist directory on Linux®
and UNIX® based 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 an event log file name:
DB819.NG1.2007062419415651.log
This
event log file is for a redistribute operation on a database named
DB819 with a database partition group named NG1 that was created on
June 24, 2007 at 7:41 PM local time.
The three main uses of
the event log file are as follows:
- To provide general information about the redistribute operation,
such as the old and new distribution maps.
- Provide users with information that will help them keep track
of 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.