16.20 - Troubleshooting a Full System Restore - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ NewSQL Engine Node Software Migration Guide

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
created_date
March 2019
category
Administration
Configuration
Installation
featnum
B035-5942-162K

If you have problems with a full system restore, try the following.

Verify the Media Server IP Addresses

  1. Ping the IP address from the media server to the database.
  2. Ping the IP address from the database to the media server.
  3. Trim any invalid or unused IP addresses.

post_dbc_restore Script Fails to Launch

If the restore works, but fails to launch the post_dbc_restore script, you receive a message similar to the following:
1079 Post dbc restore script not started. Please run the post_dbc_restore script manually with the following command: /opt/teradata/PUTTools/td16.20.xx.xx/IUMB_scripts/post_dbc_restore -s -N -j 3 TDT5WSDB/'dbc',<dbc_password>.
In addition, the table SYSBAR.DSAConnectionsTbl is not repopulated and you receive a message similar to this:
1001   SQL Exception 3807 3807: DBCSQL Exception: Object 'SYSBAR.DSAConnectionsTbl' does not exist.  DSAConnectionsTbl INSERT failed.  All DSCs should activate system <system_name>

Follow these steps:

  1. Manually launch the post_dbc_restore script:

    /opt/teradata/PUTTools/td16.20.xx.xx/IUMB_scripts/post_dbc_restore -s -N -j 3 TDT5WSDB/'dbc',<dbc_password>

  2. Run DIPBAR to repopulate the SYSBAR database.
  3. Repopulate the DSAConnectionsTbl:
    Interface Steps
    BAR Setup portlet Check the activation status of the destination system in the BAR Setup portlet and do one of the following:
    • If the destination system is configured and enabled, click Update for Selector: Update system selector for JMS messages
    • If the destination system is not configured, add the system and click Apply.
    Command line Check the activation status of the system:

    dsc list_components -t system and do one of the following:

    • If the destination system is configured and enabled, run this command:

      dsc config_systems -f configsystem.xml -s selector

    • If the destination system is not configured, add the system:

      dsc config_systems -f configsystem.xml where configsystem.xml is similar to the example shown in Full System Restore Using the Command Line.

  4. On the destination system, start DSMain from the Database Window (DBW) console supervisor screen by entering:

    start bardsmain -d DSCName , where DSCName is the unique name of your DSC server