Expand an Existing Vantage on VMware System | Teradata Vantage on VMware - Expanding an Existing Teradata Vantage on VMware System - Teradata Vantage on VMware

Teradata Vantage™ on VMware Base, Advanced, Enterprise Tiers Getting Started Guide

Product
Teradata Vantage on VMware
Release Number
Deployer 3.04
Published
October 2021
Language
English (United States)
Last Update
2021-10-29
dita:mapPath
qbi1545241606156.ditamap
dita:ditavalPath
lyx1526581533412.ditaval
dita:id
B035-5958
Product Category
Cloud
PrerequisiteThe existing system must meet the following requirements:
  • SQL Engine 16.20.xx or later.
  • Expansion must have an even number of nodes, with a minimum of two virtual nodes.
  • Sufficient resources to fully deploy identical additional TPA VMs, including image and database space, vCPUs, memory, virtual switches.
  • Must be fully licensed.
  • Available license quantity must be sufficient for the nodes to be added by the expansion.
  • Vantage requirements:
    • Join index tables and NoPI tables must be included in reconfiguration.
    • PPI table data must be properly distributed among rows and hash buckets.
    • Value-ordered index tables and hash index tables must be removed before reconfiguration. These can be recreated after reconfiguration is completed.
Due to the complexity of system expansion, contact Teradata Consulting. See https://www.teradata.com/Consulting/Velocity.
You can expand the existing system by an even number of nodes only.
  1. Open a VMware vSphere PowerCLI shell version 6.0 or later.
  2. Navigate to the directory containing the Vantage on VMware deployment executable file:
    C:\mylocation\Vantage_Deployer\
  3. Ensure that your Vantage on VMware ecosystem is powered on and Vantage is running.
    You may continue to use your system during cloning. System expansion does not affect the functionality of the database.
  4. Create a backup copy of the node.IT.properties.json file used to deploy the existing system.
    The file resides in the directory /root/tvme/ on any Vantage node in the system.
  5. Add an even number of new SQL Engine (tpa) nodes to the node.IT.properties.json file.
    For example:
    	{
    	"ESXiHost": "esxi-1.company-domain.com",
    	"OS_Datastore": "esxi-1.datastore",
    	"vmName": "lirasmp1",
    	"eth0": "xx.xx.xx.xx",
    	"vmType": "tpa",
    	"Template":
    	"Vantage_Advanced_SQLE_Template_Name"
    	},
    
    	{
    	"ESXiHost": "esxi-1.company-domain.com",
    	"OS_Datastore": "esxi-1.datastore",
    	"vmName": "lirasmp2",
    	"eth0": "xx.xx.xx.xx",
    	"vmType": "tpa",
    	"Template":
    	"Vantage_Advanced_SQLE_Template_Name"
    	}
  6. Run ./tdc.deploy.exe.
  7. Type expand_system to clone new nodes from the existing system.
  8. Press Enter.
  9. Select the properties files:
    1. Select the same common.IT.properties.json file used to deploy the original system to use for the new nodes.
      The file resides in the directory /root/tvme/ on any Vantage node in the system.
    2. Select the new node.IT.properties.json containing the newly added Vantage nodes.
  10. At the prompts, enter the same passwords used for the existing nodes.
  11. Type Yes to confirm you want to deploy the new nodes.
When expansion is complete, the following backup files from the existing (pre-expansion) system are created in /root/tvme/Backup/:
  • host
  • common.IT.properties.json
  • node.IT.properties.json
The new (post-expansion) versions of these files reside in /root/tvme/.