15.00 - Configuration and Reconfiguration Utilities - Teradata Database

Teradata Database Support Utilities

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

Configuration and Reconfiguration Utilities

After the Teradata Database system is initialized, run the Configuration and Reconfiguration utilities to define the AMPs and PEs that will operate together as a Teradata Database system.

The Configuration utility adds, changes, modifies, or displays vprocs or hosts in the new configuration map. The Reconfiguration utility then redefines the Teradata Database system configuration according to the new map.

For more information on the Configuration utility, see Utilities Volume 1. For more information on the Reconfiguration utility, see Utilities Volume 2.

Examples

Example  

This example shows that after the user started sysinit, a message stating that the Teradata Database system is running appears, and sysinit terminates.

               
                _______
                   |                                |              |
                   |    ___     __     ____         |    ____    __|__    ____
                   |   /      |/  \    ____|    ____|    ____|     |      ____|
                   |   ---    |       /    |   /    |   /    |     |     /    |
                   |   \___   |       \____|   \____|   \____|     |__   \____|
                   
                   Release 14.00.00.00 Version 14.00.00.00
                   SYSINIT Utility (June 2000)
               
               
               *********************************************************************
               *********************************************************************
               *****                                                             ***
               *****                        W A R N I N G                        ***
               *****                                                             ***
               *****  This program will destroy all user and dictionary data on  ***
               *****  the system.                                                ***
               *****                                                             ***
               *********************************************************************
               *********************************************************************
                
               SYSINIT Master AMP Vproc is 0 at 10:40:47 on 11/04/14.
                
                
               The DBS is currently running!!!
               SYSINIT cannot execute while the DBS is running.
               Would you like to restart the system without the DBS (YES/NO)?
               no
               
               
               Set the "Start DBS" flag to "Off" using the CTL utility program
               and restart the system prior to running SYSINIT again.
                
               SYSINIT terminated without updating disks.

Example  

The following example shows a complete sysinit session, including prompts, user responses, and messages. The example assumes a previously configured Teradata Database with an existing DBS Control Record and an existing current configuration map. Universal Hash is accepted.

 _______
    |                                |              |
    |    ___     __     ____         |    ____    __|__    ____
    |   /      |/  \    ____|    ____|    ____|     |      ____|
    |   ---    |       /    |   /    |   /    |     |     /    |
    |   \___   |       \____|   \____|   \____|     |__   \____|
 
    Release 14.00.00.00 Version 14.00.00.00
    SYSINIT Utility (June 2000)
 
***********************************************************************
***********************************************************************
*****                                                             *****
*****                        W A R N I N G                        *****
*****                                                             *****
*****  This program will destroy all user and dictionary data on  *****
*****  the system.                                                *****
*****                                                             *****
***********************************************************************
***********************************************************************
 
SYSINIT Master AMP Vproc is 0 at 16:32:15 on 11/10/22.
 
The existing DBSCONTROL GDO will be used.
 
System is being initialized to 20-bit hash buckets.
 
The HashFuncDBC value in the DBSCONTROL GDO is Universal 
 
Universal hash is recommended for all new installations
 
Do you wish to use Universal Hash (YES/NO/QUIT)?
yes
 
 
Enable Japanese language support (YES/NO/QUIT)?
no
 
 
SYSINIT is about to destroy all user and dictionary data!!!
Are you sure that you want to do this (YES/NO/QUIT)?
yes
 
 
Deleting all tables...
 
Accessing the current configuration map...
 
The current configuration map includes:
     1 PE(s) and 4 AMP(s)
 
Enter a value for the current/new configuration maps:
 
     1 for current:    1 PE(s)  and    4 AMP(s)
               new:    1 PE(s)  and    4 AMP(s)
 
     2 for current:    1 PE(s)  and    1 AMP(s)
               new:    1 PE(s)  and    1 AMP(s)
 
     3 for current:    0 PE(s)  and    1 AMP(s)
               new:    1 PE(s)  and    4 AMP(s)
 
     4 for current:    0 PE(s)  and    1 AMP(s)
               new:    0 PE(s)  and    1 AMP(s)
1
 
 
Updating the new configuration to: 
     1 PE(s)  and    4 AMP(s)
 
Updating the current configuration to: 
     1 PE(s)  and       4 AMP(s)
 
Updating current hash maps...
 
 
Would you like to continue with start up (YES/NO)?
yes
 
 
SYSINIT complete.