16.10 - Example of a Reconfiguration Session - Teradata Database

Teradata Database Support Utilities

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

Configuration Session

Before the system can be reconfigured, you must run the Configuration utility to create a new configuration map and any new contiguous maps needed for data distribution. The Reconfiguration utility reads the maps and creates the new configuration. This is an example of a Configuration session to add two AMPs to a system. For more information about the Configuration utility, see Configuration Utility (config).

The CONFIG  program  provides the user with a facility  
to review and update the configuration of the DBS thru  
commands which are provided by this program.            
Press <F7> for help.

The following contiguous maps are defined on this system:
	 TD_GlobalMap (Map Number 1) has Amps 0-3 and 2 PEs defined.
	 TD_DataDictionaryMap (Map Number 2) has Amps 0-3 and 2 PEs defined.
	 TD_Map1 (Map Number 1025) has Amps 0-3 and 2 PEs defined (System Default Map).
	 TD_Map2 (Map Number 1031) has Amps 0-3 and 2 PEs defined.
	 TD_Map3 (Map Number 1032) has Amps 0-3 and 2 PEs defined.
>
bc

OK.
>
aa 4-5, cn = 1

OK. 
The AMPs 4 to 5 are added.
>
ec

OK. 
The session terminated. TD_Map4 is saved.>
>
s

Config is about to be stopped.

Reconfiguration Session

The following example shows the complete output from a system reconfiguration for the two added AMPs. (Some of the redistribution phase and deletion phase output has been eliminated for brevity.)

The RECONFIG program  provides the user with a facility 
to redistribute data when the configuration of a DBS is 
changed by pressing the appropriate function key.       

 
System Time (Reconfiguration): 17/02/01 13:30:59.10.
The following contiguous maps are defined on this system:
	 TD_GlobalMap (Map Number 1) has Amps 0-3 and 2 PEs defined.
	 TD_DataDictionaryMap (Map Number 2) has Amps 0-3 and 2 PEs defined.
	 TD_Map1 (Map Number 1025) has Amps 0-3 and 2 PEs defined (System Default Map).
	 TD_Map2 (Map Number 1031) has Amps 0-3 and 2 PEs defined.
	 TD_Map3 (Map Number 1032) has Amps 0-3 and 2 PEs defined.
	 TD_Map4 (Map Number 1033) has Amps 0-5 and 2 PEs defined (New Map).

Enter command or
Press <F2> for Reconfig command
      <F3> for Stop command
      <F4> for Query or Status command
      <F5> for Display Retry List command
      <F7> for help>
r


Reconfig will use 20-bit bucket size. 


AMPs are added into configuration, do you want all new space to go to user DBC?
(yes or no) 
(If you choose no, added space is divided among the impacted databases and users in proportion to their current space allocations.)> 
yes

Should the system default map be changed to TD_Map2 (Y/N)? >
y

Reconfig will update the system default map to TD_Map4 (Map Number 1033).
Reconfig will make the new map available.
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. >
1

Reconfig will update map GDOs only.

Write Constant = 0.000000
           Compress                                   DBlk    Sort    Redist  Deletion
TableSize     Ratio         RowCount  NUSICount  FB   Size    Flag  Estimate  Estimate  Database.Table
---------  --------  ---------------  ---------  --  -----  ------  --------  --------  --------------------------------------------------
   4.00KB    1.0000                4          0   N  126KB  N  00:00:00.00  00:00:00.00  DBC.TransientJournal (0000H 001AH)
   4.00KB    1.0000                4          0   N  126KB  N  00:00:00.00  00:00:00.00  DBC.ChangedRowJournal (0000H 0020H)
   4.00KB    1.0000                4          0   N  126KB  N  00:00:00.00  00:00:00.00  DBC.SavedTransactionStatusTable (0000H 0024H)
   4.00KB    1.0000                4          0   N  126KB  N  00:00:00.00  00:00:00.00  DBC.LocalTransactionStatusTable (0000H 0025H)
   4.00KB    1.0000                4          0   N  126KB  N  00:00:00.00  00:00:00.00  DBC.UtilityLockJournalTable (0000H 0027H)
   4.00KB    1.0000                4          0   N  126KB  N  00:00:00.00  00:00:00.00  DBC.LocalSessionStatusTable (0000H 0028H)
  60.00KB    1.0000               44          0   N  126KB  Y  00:00:00.00  00:00:00.00  DBC.SysRcvStatJournal (0000H 0029H)
   4.00KB    1.0000                4          0   N  126KB  N  00:00:00.00  00:00:00.00  DBC.OrdSysChngTable (0000H 002AH)
   4.00KB    1.0000                4          0   N  126KB  N  00:00:00.00  00:00:00.00  DBC.RecoveryLockTable (0000H 0049H)
   4.00KB    1.0000                4          0   N  126KB  N  00:00:00.00  00:00:00.00  DBC.RecoveryPJTable (0000H 004AH)
   6.00KB    1.0000                8          0   N  126KB  N  00:00:00.00  00:00:00.00  DBC.Acctg (0000H 00A9H)
   4.00KB    1.0000                4          0   N  126KB  N  00:00:00.00  00:00:00.00  DBC.ReconfigJournalTbl (0000H 00E4H)
   4.00KB    1.0000                4          0   N  126KB  N  00:00:00.00  00:00:00.00  DBC.OnlineJournalInfoTbl (0000H 00E9H)
   6.00KB    1.0000                4          0   N  126KB  N  00:00:00.00  00:00:00.00  DBC.DataBaseSpace_TD15 (0000H 0122H)
 164.00KB    1.0000              824          0   N  126KB  Y  00:00:00.00  00:00:00.00  DBC.DataBaseSpace (0000H 0170H)

The current configuration has: 		1 Nodes with 4 AMPs 
The new configuration will be: 		1 Nodes with 6 AMPs 
There are 2 AMPs added to the new configuration
The system has: 		15 tables using 280.00KB of data
The estimated table redistribution time will be:
 	 0.00 hours (for offline reconfig).
The estimated table deletion time will be:
 	 0.00 hours (for offline reconfig).


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

Reconfig waiting for Recovery to complete...
Recovery has been stopped
17/02/01 13:31:23.32 Hash Map Calculation Phase Begins
17/02/01 13:31:24.40 Hash Map Calculation Phase Ends
17/02/01 13:31:24.40 Table Redistribution Phase Begins
17/02/01 13:31:24.46  Task 00 Begin redistribution DBC.TransientJournal (0000H 001AH)(No Sort).
17/02/01 13:31:24.58  Task 01 Begin redistribution DBC.ChangedRowJournal (0000H 0020H)(No Sort).
17/02/01 13:31:24.66  Task 00 End redistribution DBC.TransientJournal (0000H 001AH).
  Statistics:        RowCount ByteCount            TotSecs            CPUSecs            IOCount
     AllAmps:               0    0.00KB               0.20               0.00               5
17/02/01 13:31:24.77  Task 01 End redistribution DBC.ChangedRowJournal (0000H 0020H).
  Statistics:        RowCount ByteCount            TotSecs            CPUSecs            IOCount
     AllAmps:               0    0.00KB               0.19               0.00               5
17/02/01 13:31:24.77  Task 02 Begin redistribution DBC.SavedTransactionStatusTable (0000H 0024H)(No Sort).
17/02/01 13:31:24.82  Task 00 Begin redistribution DBC.LocalTransactionStatusTable (0000H 0025H)(No Sort).
17/02/01 13:31:24.86  Task 02 End redistribution DBC.SavedTransactionStatusTable (0000H 0024H).
  Statistics:        RowCount ByteCount            TotSecs            CPUSecs            IOCount
     AllAmps:               0    0.00KB               0.07               0.00               5
17/02/01 13:31:24.86  Task 01 Begin redistribution DBC.UtilityLockJournalTable (0000H 0027H)(No Sort).
17/02/01 13:31:24.92  Task 00 End redistribution DBC.LocalTransactionStatusTable (0000H 0025H).
  Statistics:        RowCount ByteCount            TotSecs            CPUSecs            IOCount
     AllAmps:               0    0.00KB               0.09               0.00               7
17/02/01 13:31:24.93  Task 01 End redistribution DBC.UtilityLockJournalTable (0000H 0027H).
  Statistics:        RowCount ByteCount            TotSecs            CPUSecs            IOCount
     AllAmps:               0    0.00KB               0.07               0.00               7
...

...

17/02/01 13:31:25.22  Task 01 Begin redistribution DBC.DataBaseSpace (0000H 0170H)(Sort).
17/02/01 13:31:25.25  Task 01 End redistribution DBC.DataBaseSpace (0000H 0170H).
  Statistics:        RowCount ByteCount            TotSecs            CPUSecs            IOCount
     AllAmps:               0    0.00KB               0.03               0.00              13
17/02/01 13:31:26.39 Table Redistribution Phase Ends
17/02/01 13:31:26.40 Old Table Deletion Phase Begins

17/02/01 13:31:27.04  Task 00 Begin deletion DBC.TransientJournal (0000H 001AH).
17/02/01 13:31:27.14  Task 01 Begin deletion DBC.ChangedRowJournal (0000H 0020H).
17/02/01 13:31:27.19  Task 02 Begin deletion DBC.SavedTransactionStatusTable (0000H 0024H).
17/02/01 13:31:27.30  Task 03 Begin deletion DBC.LocalTransactionStatusTable (0000H 0025H).
17/02/01 13:31:27.35  Task 04 Begin deletion DBC.UtilityLockJournalTable (0000H 0027H).
17/02/01 13:31:27.36  Task 00 End deletion DBC.TransientJournal (0000H 001AH).
  Statistics:   FSysCallCount ByteCount            TotSecs            CPUSecs            IOCount
     AllAmps:               0    0.00KB               0.31               0.10              56
17/02/01 13:31:27.42  Task 05 Begin deletion DBC.LocalSessionStatusTable (0000H 0028H).
17/02/01 13:31:27.43  Task 00 Begin deletion DBC.SysRcvStatJournal (0000H 0029H).
17/02/01 13:31:27.46  Task 06 Begin deletion DBC.OrdSysChngTable (0000H 002AH).
17/02/01 13:31:27.50  Task 00 End deletion DBC.SysRcvStatJournal (0000H 0029H).
  Statistics:   FSysCallCount ByteCount            TotSecs            CPUSecs            IOCount
     AllAmps:               0    0.00KB               0.06               0.01              49
17/02/01 13:31:27.51  Task 01 End deletion DBC.ChangedRowJournal (0000H 0020H).
  Statistics:   FSysCallCount ByteCount            TotSecs            CPUSecs            IOCount
     AllAmps:               0    0.00KB               0.44               0.08              56
...

17/02/01 13:31:28.51 Old Table Deletion Phase Ends
17/02/01 13:31:28.52 Saving Backup IDs Phase Begins
17/02/01 13:31:28.56 Saving Backup IDs Phase Ends
17/02/01 13:31:28.57 Insert/Update DBC.Maps Table Phase Begins
17/02/01 13:31:28.79 Insert/Update DBC.Maps Table Phase Ends
17/02/01 13:31:28.79 Saving Current Configuration Map Phase Begins
17/02/01 13:31:29.37 Saving Current Configuration Map Phase Ends
17/02/01 13:31:29.38 Saving New Configuration Map Phase Begins
17/02/01 13:31:29.38 Saving New Configuration Map Phase Ends
17/02/01 13:31:29.39 Saving Bitmap Hash Table Phase Begins
17/02/01 13:31:29.49 Saving Bitmap Hash Table Phase Ends
17/02/01 13:31:29.50 Updating Disk Space Phase Begins
17/02/01 13:31:29.65 Updating Disk Space Phase Ends
17/02/01 13:31:29.66 Updating Vproc Configuration Begins
17/02/01 13:31:29.67 Updating Vproc Configuration Ends
System Time (Reconfiguration): 17/02/01 13:31:29.68
        6120: Restarting DBS due to completion of reconfiguration.
System is about to be reset for reconfig offline.