16.10 - Example - Teradata Database

Teradata Database Support Utilities

prodname
Teradata Database
vrm_release
16.10
created_date
June 2017
category
Configuration
featnum
B035-1180-161K

Reconfiguration Estimator Session

        Reconfig estimator Utility 
 
The new hardware clustering configuration is not defined.
If you continue, tables may be left out of the estimate.
Do you wish to continue (Y/N)? > 
y

Enter the total number of AMPs in the old configuration:> 
2

Enter the total number of AMPs in the new configuration:>
4

Enter the total number of Moved AMPs in the new configuration:>
0

Enter the total number of Nodes in the new configuration:>
1

Enter the number of tasks you want to run during reconfig:>
15

Which tables should reconfig process?.
1.  No tables
2.  Dictionary tables
3.  User tables with contiguous maps specified in DBC.ReconfigRedistOrderTbl
4.  All user tables with contiguous maps. >
4

Reconfig will process all user tables with contiguous maps.

Enter an existing Username and Password for Loading Sample Data 
 
or Press the Enter key to quit:


Enter UserName:>
username


Enter Password:>
password

Loading data for running pseudo reconfig at 17/03/18 14:23:51.60
Please wait...
Loading is complete at 17/03/18 14:24:01.70
Pseudo Reconfig Begins at 17/03/18 14:24:01.73
Please wait...
Pseudo Reconfig Ends at 17/03/18 14:24:05.95

Value of Constant for New Estimator is:0.087500

Write Constant = 0.008750
           Compress                                   DBlk    Sort    Redist  Deletion
TableSize     Ratio         RowCount  NUSICount  FB   Size    Flag  Estimate  Estimate  Database.Table
---------  --------  ---------------  ---------  --  -----  ------  --------  --------  --------------------------------------------------
  10.00KB    1.0000              402          0   Y  126KB  Y  00:00:00.00  00:00:00.00  RKPMED.Stores (0000H 0BC4H)
  10.00KB    1.0000              402          0   Y  126KB  Y  00:00:00.00  00:00:00.00  RKPMED.Items (0000H 0BC5H)
   5.37GB    1.0000      128,000,002          0   Y  126KB  Y  00:01:36.99  00:09:14.22  RKPMED.SIW_XXXX_USI_FB_1 (0000H 0BC8H)
   3.00KB    1.0000                2          0   Y  126KB  N  00:00:00.00  00:00:00.00  TD_SERVER_DB.TD_PushProfileInfo (0000H 0AAEH)
   2.00KB    1.0000                2          0   Y  126KB  N  00:00:00.00  00:00:00.00  TDMAPS.ObjectListTbl (0000H 0AC8H)
   2.00KB    1.0000                2          0   Y  126KB  N  00:00:00.00  00:00:00.00  TDMAPS.ObjectListEntry (0000H 0AC9H)
   2.00KB    1.0000                2          0   Y  126KB  N  00:00:00.00  00:00:00.00  TDMAPS.AnalyzeSPInstanceTbl (0000H 0ACAH)
   2.00KB    1.0000                2          0   Y  126KB  N  00:00:00.00  00:00:00.00  TDMAPS.CostConstantsTbl (0000H 0ACBH)
   2.00KB    1.0000                2          0   Y  126KB  N  00:00:00.00  00:00:00.00  TDMAPS.RanksTbl (0000H 0ACCH)
   6.00KB    1.0000               20          0   Y  126KB  Y  00:00:00.00  00:00:00.00  TDMAPS.SettingsTbl (0000H 0ACDH)
   2.00KB    1.0000                2          0   Y  126KB  N  00:00:00.00  00:00:00.00  TDMAPS.GT_DecidedAction (0000H 0ACFH)
   3.00KB    1.0000                2          0   Y  126KB  N  00:00:00.00  00:00:00.00  TDMAPS.ActionsTbl (0000H 0AD0H)

. . . [output trimmed for this example] . . .

 111.50KB    1.0000              879          0   N  126KB  Y  00:00:00.00  00:00:00.00  DBC.Acctg (0000H 00A9H)
   2.00KB    1.0000                2          0   N  126KB  N  00:00:00.00  00:00:00.00  DBC.ReconfigJournalTbl (0000H 00E4H)
   2.00KB    1.0000                2          0   N  126KB  N  00:00:00.00  00:00:00.00  DBC.OnlineJournalInfoTbl (0000H 00E9H)
   3.00KB    1.0000                2          0   N  126KB  N  00:00:00.00  00:00:00.00  DBC.DataBaseSpace_TD15 (0000H 0122H)
 416.50KB    1.0000            2,335          0   N  126KB  Y  00:00:00.00  00:00:00.00  DBC.DataBaseSpace (0000H 0170H)

The current configuration has: 		1 Nodes with 2 AMPs 
The new configuration will be: 		1 Nodes with 4 AMPs 
There are 2 AMPs added to the new configuration
The system has: 		160 tables using 5.38GB of data
The estimated table redistribution time will be:
 	 0.01 hours (for offline reconfig).
The estimated table deletion time will be:
 	 0.09 hours (for offline reconfig).


This reconfig estimate is based upon 48XX/49XX/52XX OR LATER.