Disable Automatic Recovery| Teradata Unity - Temporarily Disabling Automatic Recovery - Continuous Availability - Teradata Unity

Teradata® Unity™ Monitoring and Management Guide
Product
Continuous Availability
Teradata Unity
Release Number
17.00
Published
September 2020
Language
English (United States)
Last Update
2020-09-15
dita:mapPath
yuc1569253595897.ditamap
dita:ditavalPath
ft:empty
dita:id
yuc1569253595897
Product Category
Analytical Ecosystem
When a system or a large number of objects are interrupted, it may become a strain on Unity and managed system resources. To allow adequate time to analyze and correct any issues on the Teradata systems, temporarily disable automatic recovery. When the issues are resolved, re-enable automatic recovery.
  1. At unityadmin, run the following command: 
    CONFIG LIST KEY RECOVERYINTERVAL;
    Unity returns the sequencer system information, including the default recovery interval of 300 seconds, and a custom recovery interval if applicable. For example:
    Sequencer System Defaults
-------------------------

RecoveryInterval: 300

Sequencer User Set Values
-------------------------

RecoveryInterval: 600

    In this example, Unity is using a custom recovery interval of 600 seconds.

    When you initiate recovery, Unity sets the custom recovery interval back to the default.

  2. If you are using a custom recovery interval, make note of the value so you can reset the value after recovery.
  3. At unityadmin, run the following command to disable automatic recovery: 
    CONFIG UPDATE SEQUENCER RecoveryInterval 0 REASON 'Disabled Automatic Recovery for incident _______';
  4. At unityadmin, run the following command to confirm a recovery is not in progress: 
    SYSTEM RECOVERY STATUS;
  5. At unityadmin, run the following command to make sure no objects on the system are being restored: 
    STATUS;
  6. At unityadmin, run the following command to determine the cause of the mass interrupt event, then fix the errors: 
    SESSION LIST INTERRUPTED;
    If you cannot fix the issues, contact Teradata Customer Support for assistance before proceeding with recovery.
  7. At unityadmin, run the following command to start recovery for the specified system: 
    SYSTEM RECOVER <systemId>;
  8. At unityadmin, run the following command periodically to check recovery status: 
    SYSTEM RECOVERY STATUS;
    When recovery is complete, Unity returns the status recovery not in progress.
  9. At unityadmin, run the following command after recovery is complete to check for new interrupts: 
    SESSION LIST INTERRUPTED;
  10. Do one of the following:
    Recovery Status Action
    No new interrupts
    1. At unityadmin, run one of the following commands to restore automatic recovery:
      • If you are using a custom recovery interval: 
        CONFIG UPDATE SEQUENCER RECOVERYINTERVAL <recovery interval>;

        This restores automatic recovery to the custom recovery interval specified.

      • If you are using the default recovery interval: 
        CONFIG RESET SEQUENCER SEQUENCER RECOVERYINTERVAL;

        This restores automatic recovery to the default recovery interval of 300 seconds..
    New errors
    1. Fix the issues, then repeat the recovery process.
      If you cannot fix the issues, contact Teradata Customer Support for assistance before proceeding with another recovery attempt.