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.10
Published
June 2017
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
iwr1478709689896.ditamap
dita:ditavalPath
2207_ICUCustomer_vp_1610.ditaval.ditaval
dita:id
B035-2207
lifecycle
previous
Product Category
Analytical Ecosystem
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 will 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 ensure 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, ensure 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.