IBM Books

Administration Guide

Recovering From Redistribution Errors

After the redistribution operation begins to execute, a file is written to the redist sub-directory of the sqllib directory. This status file lists any operations that are done on database partitions, the names of the tables that were redistributed, and the completion status of the operation. If a table cannot be redistributed, its name and the applicable SQLCODE is listed in the file. If the redistribution operation cannot begin because of an incorrect input parameter, the file is not written and an SQLCODE is returned.

The file has the following naming convention:

  databasename.nodegroupname.timestamp   (for UNIX platforms)
  databasename\nodegroupname\date\time   (for non-UNIX platforms)
Note:On non-UNIX platforms, only the first eight (8) bytes of the nodegroupname are used.

If the data redistribution operation fails, some tables may be redistributed, while others are not. This occurs because data redistribution is performed a table at a time. You have two options for recovery:

Before you can use either option, a previous data redistribution operation must have failed such that the REBALANCE_PMID column in the SYSNODEGROUPS catalog table is set to a non-NULL value.

If you happen to delete the status file by mistake, you can still attempt a CONTINUE operation.

[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]