Postgres to Postgres Migration on New DSC - BAR - Data Stream Architecture - Data Stream Extensions

Teradata® DSA - DSE for IBM Spectrum Protect Installation, Configuration, and Upgrade Guide
Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
BAR
Data Stream Architecture
Data Stream Extensions
Release Number
17.20
Published
November 2022
Language
English (United States)
Last Update
2023-03-29
dita:mapPath
txy1632417625021.ditamap
dita:ditavalPath
gjr1576617673366.ditaval
dita:id
wrj1535405115215
Product Category
Software
Teradata Tools and Utilities
  1. Download and extract DSAMetadataMigrator-17.20.01.00 or later.
  2. Prepare or use previous dsa_inputs.yaml generated using ./generateYml.py.
  3. Only one Media_Server per Teradata MPP system is allowed when isMPP : true. It internally uses PCL tool to communicate with all other media_servers on Teradata MPP system.
  4. Run the following:
    • On SLES15 run python3 runAutoMigration.py - f
    • On SLES12.3-TDC/STND run python3.6 runAutoMigration.py - f
    • On SLES11.3 run ./runAutoMigration.py - f
    This script performs the following tasks:
    • SSH logon to old DSC and read the POSTGRES password from jdbc.properties.
    • Use PG_DUMP to read old DSC repo data and store it in LandingZone at new DSC.
    • Run restore with recover.sh utility into local new DSC Repo.
    • Validate with ROW count between old and new DSC.
    • Run upgrade scripts (change log) based on old DSC version.
    • If needed, update or modify DSC name.
    • Reconfigure only components given dsa_inputs.yml.
    • Compare list_consumers and list_components on old and new DSC.
    • Provide appropriate message or action or exit code.
      • EXIT 0 (Migration completed successfully).
      • EXIT 1 (Migration completed with warnings. Needs changes or executions).
      • EXIT 2 (Migration failed).