Migrate Teradata Data Labs to a New Teradata System | Teradata Viewpoint - 16.20 - 16.50 - Migrating Teradata Data Labs to a New Teradata System - Teradata Viewpoint

Teradata® Viewpoint Installation, Configuration, and Upgrade Guide for Customers

Product
Teradata Viewpoint
Release Number
16.20
16.50
Release Date
July 2021
Content Type
Administration
Configuration
Installation
Publication ID
B035-2207-071K
Language
English (United States)
When you have a new Teradata system, you must migrate the data labs metadata associated with the original Teradata system to the new Teradata system. After completing this procedure, all existing lab groups for the original system appear under the new system in the Data Labs portlet, and all currently pending requests and future requests are performed against the new system. The lab groups that are migrated no longer appear in the Data Labs portlet for the original system.
  1. Transfer data from the old Teradata system to the new Teradata system, including lab group users, lab databases, and lab group roles.
  2. From the Monitored Systems portlet, do the following:
    1. Verify both the old and new Teradata systems are present in the Monitored Systems portlet.
    2. Verify both systems are enabled.
    3. Verify the Dictionary collector is enabled for both systems.
  3. Type the following command to shut down the DCS from the active cache database server:
    /etc/init.d/dcs stop
  4. Run the dcsadmin command from the active cache database server:
    /opt/teradata/viewpoint/dcs/bin/dcsadmin.sh
  5. Type help to verify the migratedatalabssystem command is available.
  6. Run the migratedatalabssystem command.
  7. Select a source system (original system).
  8. Select a target system (new system).
  9. Verify output to make sure the migration was successful.
  10. Type the following command to start the DCS from the active cache database server:
    /etc/init.d/dcs start
    The migration is ready to be validated.
  11. From the Data Labs portlet, make sure the migration completed successfully by doing the following:
    1. Verify the new system has all the data labs data that was on the original system. Also verify any pending Data Lab approvals migrated successfully.
    2. Verify the original system does not have any data labs configured.