Running the Script to Rebuild AMPs

To fully restore a local storage instance after a node failure, you can run a script to rebuild the AMPs. Until the AMPs are rebuilt, data is maintained in fallback rows on the other AMPs.

For a list of available command options you can use with the script, see Rebuilding AMPs after Failure.

For assistance, contact Teradata Customer Support.

  1. At the command prompt, enter one of the following commands to start the script.
    • To run in interactive mode, enter tdc-rebuild.
    • To run in non-interactive mode, enter tdc-rebuild -w.
  2. Enter the Teradata Database super user (dbc) password and press Enter.
    The script lists the AMPs that will be rebuilt. For example:
    FATAL AMPs are: AMP NodeId Cluster State
    ---- ------ ------- -------0   1-010FATAL**1   1-011FATAL**2   1-012FATAL**3   1-013FATAL**
    
  3. When prompted to rebuild the AMPs, enter one of the following:
    • y to continue with the rebuild process.
    • n to stop the process and not alter the database.
    For example:
    Rebuild these AMPs? (Y/N): y
    *** Stopping Teradata to initialize pdisks
    --- Initialized pdisk /dev/pdisk/dsk0
    --- Initialized pdisk /dev/pdisk/dsk1
    --- Initialized pdisk /dev/pdisk/dsk2
    --- Initialized pdisk /dev/pdisk/dsk3*** Restarting Teradata to contine after initializing pdisks
    --- Booting FATAL AMPs
    --- Initiating AMP rebuilds
      17:22:07 Background rebuild started, log into LOGAMP_0
      17:22:07 Background rebuild started, log into LOGAMP_1
      17:22:07 Background rebuild started, log into LOGAMP_2
      17:22:07 Background rebuild started, log into LOGAMP_3
    --- Rebuilds running
    Wait for rebuilds complete? (Y/N): n
    #
  4. If running in interactive mode, enter one of the following when prompted whether to wait for the rebuilds to complete:
    Option Actions
    To finish the rebuild without further interaction
    1. Enter y.
    To finish the rebuild based on your continued input
    1. Enter n.

      The script displays progress messages and then stops.

    2. Enter #tdc-rebuild to restart the script.
    3. Enter the Teradata Database super user (dbc) password and press Enter.
    4. Repeat the preceding two sub-steps each time the script stops until the rebuild finishes.
    The following output indicates rebuild completion.
    --- AMP rebuilds completed
    *** Restarting Teradata to set rebuilt AMPs online
    --- Rebuild complete

results matching ""

    No results matching ""