15.00 - Reconfiguration Example - Teradata Database

Teradata Database Support Utilities

prodname
Teradata Database
vrm_release
15.00
category
Configuration
featnum
B035-1180-015K

Reconfiguration Example

The following is a Reconfiguration example. Most of the detailed table redistribution text is eliminated for brevity.

 _______
    |                                |              |
    |    ___     __     ____         |    ____    __|__    ____
    |   /      |/  \    ____|    ____|    ____|     |      ____|
    |   ---    |       /    |   /    |   /    |     |     /    |
    |   \___   |       \____|   \____|   \____|     |__   \____|
 
    Release 14g.00.00.225 Version 14g.00.00.286
    RECONFIG Utility (Dec 94)
 
 
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): 11/11/10 13:08:57.
 
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 16-bit bucket size. 
 
Should reconfig run in online mode with logons enabled (y/n)? >
y
 
 
User prefer to run ONLINE on both REDISTRIBUTION and DELETION. 
 
                                            DBlk  Sort    Redist  Deletion
TableSize         RowCount  NUSICount  FB   Size  Flag  Estimate  Estimate  Database.Table
---------  ---------------  ---------  --  -----  ----  --------  --------  -----------------------------
   4.00KB                4          0   Y   63KB    N  00:00:00  00:00:00  DBC.RCConfiguration 
                                                                           (0000H 0007H)
   5.00KB                6          0   Y   63KB    N  00:00:00  00:00:00  DBC.Global (0000H 0019H)
   4.00KB                4          0   N   63KB    N  00:00:00  00:00:00  DBC.TransientJournal 
                                                                           (0000H 001AH)
  15.00KB              394          0   Y   63KB    N  00:00:00  00:00:00  DBC.Owners (0000H 001BH)
  16.00KB              394          0   Y   63KB    N  00:00:00  00:00:00  DBC.Parents (0000H 001CH)
 834.00KB            6,854          0   Y   63KB    N  00:00:00  00:00:00  DBC.ErrorMsgs (0000H 001EH)
...
  10.00KB                4          0   N  126KB    N  00:00:00  00:00:00  oarc_otop018db1.tab_jn 
                                                                           (4000H 09B9H)
  34.00KB              332          0   N  126KB    N  00:00:00  00:00:00  oarc_oth004db1.tab_jn 
                                                                           (4000H 09BDH)
 
The current configuration has: 1 Nodes with 4 AMPs 
The new configuration will be: 1 Nodes with 8 AMPs 
There are 4 AMPs added to the new configuration
The system has: 1308 tables using 15.44GB of data
The estimated table redistribution time will be:
     0.09 hours (for offline reconfig).
     0.14 hours (for online reconfig with system 25% busy).
     0.20 hours (for online reconfig with system 50% busy).
     0.27 hours (for online reconfig with system 75% busy).
     0.35 hours (for online reconfig with system 100% busy).
The estimated table deletion time will be:
     0.21 hours (for offline reconfig).
 
     0.33 hours (for online reconfig with system 25% busy).
     0.47 hours (for online reconfig with system 50% busy).
     0.64 hours (for online reconfig with system 75% busy).
     0.84 hours (for online reconfig with system 100% busy).
 
This reconfig estimate is based upon 48XX/49XX/52XX OR LATER.
 
11/11/10 13:09:20 Hash Map Calculation Phase Begins
11/11/10 13:09:21 Hash Map Calculation Phase Ends
11/11/10 13:09:21 Table Redistribution Phase Begins
11/11/10 13:09:21  Task 00 Begin redistribution TDSTATS.ExcludedTbl (0000H 0823H) online.
11/11/10 13:09:21  Task 00 End redistribution TDSTATS.ExcludedTbl (0000H 0823H).
  Statistics:        RowCount ByteCount TotSecs         CPUSecs         IOCount
     AllAmps:               0    0.00KB      24               0             196
11/11/10 13:09:21  Task 01 Begin redistribution TDSTATS.CommandsTbl (0000H 0825H) online.
11/11/10 13:09:21  Task 00 Begin redistribution TDSTATS.CommandsBatchDtlTbl (0000H 0828H) online.
11/11/10 13:09:21  Task 01 End redistribution TDSTATS.CommandsTbl (0000H 0825H).
  Statistics:        RowCount ByteCount TotSecs         CPUSecs         IOCount
     AllAmps:               0    0.00KB      24               0             280
11/11/10 13:09:21  Task 00 End redistribution TDSTATS.CommandsBatchDtlTbl (0000H 0828H).
  Statistics:        RowCount ByteCount TotSecs         CPUSecs         IOCount
     AllAmps:               0    0.00KB      24               0             196
11/11/10 13:09:21  Task 01 Begin redistribution TDSTATS.StatsTbl (0000H 0829H) online.
11/11/10 13:09:21  Task 00 Begin redistribution TDSTATS.udfConcat (0000H 082AH) online.
...
11/11/10 13:13:51  Task 01 Table in-use by Permanent Journaling, skipping oarc_oth004db1.tab_jn 
                   (4000H 09BDH).
11/11/10 13:13:51  Task 01 End redistribution oarc_oth004db1.tab_jn (4000H 09BDH).
  Statistics:        RowCount ByteCount TotSecs         CPUSecs         IOCount
     AllAmps:               0    0.00KB      24               0             220
Online Redistribution Completed. 
Reconfig is waiting for all Online Archive logging 
activities to be turned off. 
50 table(s) currently have Online Archive logging enabled. 
DBC.ArchiveLoggingObjsV view can be used to retrieve 
the objects that still have online archive logging enabled. 
11/11/10 13:14:21  Task 29 Begin replay ReconfigJournal.
11/11/10 13:14:21  Task 29 End replay ReconfigJournal.
***********************************************************
*  In order to finish, reconfig must now run offline.     *
*  All sessions must logoff and logons must be disabled.  *
***********************************************************
11/11/10 13:23:59  Task 29 Begin final replay ReconfigJournal.
11/11/10 13:23:59  Task 00 End redistribution load_mlppi.LINEITEM (0000H 09E7H).
  Statistics:        RowCount ByteCount TotSecs         CPUSecs         IOCount
     AllAmps:      11,999,546    1.58GB     143              50         135,599
11/11/10 13:23:59  Task 01 Begin redistribution DBC.RCConfiguration (0000H 0007H).
11/11/10 13:23:59  Task 29 End final replay ReconfigJournal.
11/11/10 13:23:59  Task 00 Begin redistribution DBC.Global (0000H 0019H).
11/11/10 13:23:59  Task 01 End redistribution DBC.RCConfiguration (0000H 0007H).
  Statistics:        RowCount ByteCount TotSecs         CPUSecs         IOCount
     AllAmps:               0    0.00KB      24               0             244
...
11/11/10 13:24:22  Task 00 End redistribution oarc_oth004db1.tab_jn (4000H 09BDH).
  Statistics:        RowCount ByteCount TotSecs         CPUSecs         IOCount
     AllAmps:               0    0.00KB      24               0             160
11/11/10 13:24:22 Table Redistribution Phase Ends
11/11/10 13:24:22 Saving New Primary Hash Map Phase Begins
11/11/10 13:24:23 Saving New Primary Hash Map Phase Ends
11/11/10 13:24:23 Saving New Fallback Hash Map Phase Begins
11/11/10 13:24:23 Saving New Fallback Hash Map Phase Ends
11/11/10 13:24:23 Saving Current Primary Hash Map Phase Begins
11/11/10 13:24:23 Saving Current Primary Hash Map Phase Ends
11/11/10 13:24:23 Saving Current Fallback Hash Map Phase Begins
11/11/10 13:24:23 Saving Current Fallback Hash Map Phase Ends
11/11/10 13:24:23 Saving Current Configuration Map Phase Begins
11/11/10 13:24:23 Saving Current Configuration Map Phase Ends
11/11/10 13:24:23 Saving New Configuration Map Phase Begins
11/11/10 13:24:23 Saving New Configuration Map Phase Ends
11/11/10 13:24:23 Saving Backup IDs Phase Begins
11/11/10 13:24:23 Saving Backup IDs Phase Ends
11/11/10 13:24:23 Deleting New Hash Maps Phase Begins
11/11/10 13:24:23 Deleting New Hash Maps Phase Ends
11/11/10 13:24:23 Saving Bitmap Hash Table Phase Begins
11/11/10 13:24:23 Saving Bitmap Hash Table Phase Ends
11/11/10 13:24:23 Updating Disk Space Phase Begins
11/11/10 13:24:24 Updating Disk Space Phase Ends
11/11/10 13:24:24 Updating Vproc Configuration Begins
11/11/10 13:24:24 Updating Vproc Configuration Ends
 
System is about to be reset for reconfig online.
 
 
 
 
 _______
    |                                |              |
    |    ___     __     ____         |    ____    __|__    ____
    |   /      |/  \    ____|    ____|    ____|     |      ____|
    |   ---    |       /    |   /    |   /    |     |     /    |
    |   \___   |       \____|   \____|   \____|     |__   \____|
 
    Release 14g.00.00.225 Version 14g.00.00.286
    RECONFIG Utility (Dec 94)
 
 
Restart RECONFIG
Reconfig already entered the irreversible phase on 11/11/10 at 13:24:51.
11/11/10 13:24:51 Old Table Deletion Phase Begins
11/11/10 13:24:52  Task 00 Begin deletion DBC.RCConfiguration (0000H 0007H).
11/11/10 13:24:52  Task 00 End deletion DBC.RCConfiguration (0000H 0007H).
  Statistics:   FSysCallCount ByteCount TotSecs         CPUSecs         IOCount
     AllAmps:               0    0.00KB       0               0             688
11/11/10 13:24:52  Task 01 Begin deletion DBC.Global (0000H 0019H).
11/11/10 13:24:52  Task 00 Begin deletion DBC.TransientJournal (0000H 001AH).
11/11/10 13:24:52  Task 02 Begin deletion DBC.Owners (0000H 001BH).
...
11/11/10 13:25:07  Task 01 End deletion SYSUDTLIB.TestRelEqUdt_Ordering (0000H 0B74H).
  Statistics:   FSysCallCount ByteCount TotSecs         CPUSecs         IOCount
     AllAmps:               0    0.00KB       0               0             660
11/11/10 13:27:23  Task 00 End deletion oarc_oth004db1.tab_jn (4000H 09BDH).
  Statistics:   FSysCallCount ByteCount TotSecs         CPUSecs         IOCount
     AllAmps:               0    0.00KB       0               0             146
11/11/10 13:27:54  Task 01 End deletion load_mlppi.LINEITEM (0000H 09E7H).
  Statistics:   FSysCallCount ByteCount TotSecs         CPUSecs         IOCount
     AllAmps:      11,999,546    1.58GB     107              24         108,986
11/11/10 13:27:54 Old Table Deletion Phase Ends
System Time (Reconfiguration): 11/11/10 13:27:54
        6179: Reconfig online finished.
 
RECONFIG is about to be stopped.