Recovering from Failed Migration

To improve performance and storage efficiency on queries, the stDataFiles table is partitioned. The partitioning is performed during a new installation as well as when upgrading to LogLogic LMI 6.2.0 or later. It is possible to recover stDataFiles table if the partitioning fails during the upgrade process.

Procedure

  1. To restore stDataFiles backup, run the command: 
    /loglogic/scripts/dbPartitioner/revert_stDataFiles_Partition
  2. To run the partition process again, run the command: 
    /loglogic/scripts/dbPartitioner/build_partition
    Note: This command is executed during the upgrade process and must not be run manually unless there an exception in the normal flow.
  3. To remove the backup table that is created during partitioning, run the command:. 
    /loglogic/scripts/dbPartitioner/remove_stDataFiles_logical_backup
    Caution: After this command is executed, there is no way to restore stDataFiles to its state before the partitioning started.