16.10 - Sysinit Examples - Teradata Database

Teradata Database Support Utilities

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

Example: Sysinit cannot run while the DBS is running

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

                   SYSINIT Utility 
               
               
               *********************************************************************
               *********************************************************************
               *****                                                             ***
               *****                        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: Sysinit complete session

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. New Universal Hash is accepted.

    SYSINIT Utility 
 
***********************************************************************
***********************************************************************
*****                                                             *****
*****                        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 
New Universal hash (6) is recommended for all new installations
Do you wish to use HashFuncDBC (6) (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.