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.
After the redistribution operation begins to execute, a file is written to the redist sub-directory of the sqllib directory. This 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. |
This file lists any operations that are done on nodes, 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. If the redistribution operation cannot begin because of an incorrect input parameter, the file is not written and an SQLCODE is returned.
Should you happen to delete this file by mistake, you are still able to attempt a CONTINUE operation.