Installation of Teradata on Windows 2000/XP

Installation of Teradata on Windows 2000/XP

  PREREQUISITES FOR A BASIC INSTALLATION (SMP):

• Raw Hardisk Partitions ( 2 Partitions Recommended)
• If you have no raw Partitions, create new partitions from

the free space available with an existing partition, using Partition Magic or Disk Management in Computer Management.

• Free Space to install Bynet and Teradata RDBMS

1)  Locating the Teradata Software

The network folder \\153.58.38.99\share\TNTPackages

contain Teradata Packages.

2)  Installation of ByNet.

Browse for the folder TNTPackages\bynet\BYNET

execute bynet(x86).exe and choose SMP option during installation.

  

Note: Bynet should be installed prior to the

 Installation of Teradata RDBMS.

3)  Installation of Teradata RDBMS

  

   Browse for the folder TNTPackages find out the latest 

   Version and go to that folder and now execute setup.exe

     choose complete install and finish the installation.

          

     Recommended: Don’t change the install folder paths.

4)  Post-Install Configuration of Teradata RDBMS

Copy the viewconfig.txt file from Folder TNTPackages

  To ..\NCR\Tdat\tdconfig directory.

PDISK

#CL_ID   VDISKID   SECTORS   ARRAY_TYPE  REDUNDANCY     PARTITION_NAME

   0        0     18539010   NONE          RM0    \Device\Harddisk1\partition2

   0        1     18089190   NONE          RM0     \Device\Harddisk1\Partition3

Go to Command prompt and run partitioninfo.Change the above      highlighted partition information with information retrieved     from partitioninfo tool.

                

Modify the file startup.txt in folders

..\NCR\Tdat\LPDE\etc and

..\Program Files\NCR\Tdat\PDE\06.01b.00.00\etc

(Note: 06.01b.00.00 may change with versions Of Teradata so browse the appropriate)

Such that the following lines are uncommented

Set segfilesize                 1    # number of 256MB chunks of segment space

Set fsgminampslots             64    # min 128KB FSG slots per AMPOnly for fresh

     Run vconfig from any command prompt to create vconfig gdo        and initialize it with the information in the vconfig.txt      file. You should run vconfig whenever the vconfig.txt file changes or vconfig gdo is deleted.

 Note: If your machine is Dell 370, then run ctl from command

 Prompt and type Parameter Flags[7]=1 and exit.

6) Start the Teradata RDBMS Service

   Issue the following command at command prompt

   > net start recond.

a.  This starts the reconcile process that in turn starts PDE to bring up the DBS. You should see:

The Teradata RDBMS Initiator service is starting...

The Teradata RDBMS Initiator service was started successfully.

b.  At this point if you enter command “pdestate –a” in any command prompt, you will see:

PDE state is RUN/READY.

DBS state is 0/-1: DBS is not running

7) If not the state will show, DBS is not running in that case,     Sysinit the system.                                                                               

SYSINIT

From the command prompt execute the following:

> Cnstool

6:Input Supervisor Command:

6:start sysinit      ===è (This command is to initiate the sysinit process.)

6:start sysinit

6:

6:←SRunning

6:Started 'sysinit' in window 1

6: at Fri Sep 10 17:55:44 2004

6:

1:←SRunning

1:←Tsysinit

1:←O

1:←C

6:

6:Input Supervisor Command:

6:←SReading

1:

1:

1: _______

1:    |                                |              |

1:    |    ___     __     ____         |    ____    __|__    ____

1:    |   /      |/  \    ____|    ____|    ____|     |      ____|

1:    |   ---    |       /    |   /    |   /    |     |     /    |

1:    |   \___   |       \____|   \____|   \____|     |__   \____|

1:

1:    Release V2R.06D.00.00.00 Version 06D.00.00.00

1:    SYSINIT Utility (June 2000)

1:

1:***********************************************************************

1:***********************************************************************

1:*****                                                             *****

1:*****                        W A R N I N G                        *****

1:*****                                                             *****

1:*****  This program will destroy all user and dictionary data on  *****

1:*****  the system.                                                *****

1:*****                                                             *****

1:***********************************************************************

1:***********************************************************************

1:

1:SYSINIT Master AMP Vproc is 0 at 17:55:45 on 04/09/10.

1:

1:The existing DBSCONTROL GDO will be used.

1:

1:The HashFuncDBC value in the DBSCONTROL GDO is Universal

1:

1:Universal hash is recommended for all new installations

1:

1:Do you wish to use Universal Hash (YES/NO/QUIT)?

1:←Sreading

1:yes                            ===è( Type in ‘Yes’)

1:yes

1:

1:←SRunning

1:

1:Enable Japanese language support (YES/NO/QUIT)?

1:←SReading

1:no                             ===è( Type in ‘Yes’/’No’ on need basis)

1:no

1:

1:←SRunning

1:

1:SYSINIT is about to destroy all user and dictionary data!!!

1:Are you sure that you want to do this (YES/NO/QUIT)?

1:←SReading

1:yes                            ===è( Type in ‘Yes’)

1:yes

1:

1:←SRunning

1:

1:Deleting all tables...

1:

1:Accessing the current configuration map...

1:

1:The current configuration map includes:

1:     1 PE(s) and 2 AMP(s)

1:

1:Enter a value for the current/new configuration maps:

1:

1:     1 for current:    1 PE(s)  and    2 AMP(s)

1:               new:    1 PE(s)  and    2 AMP(s)

1:

1:     2 for current:    1 PE(s)  and    1 AMP(s)

1:               new:    1 PE(s)  and    1 AMP(s)

1:

1:     3 for current:    0 PE(s)  and    1 AMP(s)

1:               new:    1 PE(s)  and    2 AMP(s)

1:

1:     4 for current:    0 PE(s)  and    1 AMP(s)

1:               new:    0 PE(s)  and    1 AMP(s)

1:←Sreading

1:1                         ===è( Type in 1 or any other option u need)

1:

1:←SRunning

1:

1:Updating the new configuration to:

1:     1 PE(s)  and    2 AMP(s)

1:

1:Updating the current configuration to:

1:     1 PE(s)  and       2 AMP(s)

1:

1:Updating current hash maps...

1:

1:Would you like to continue with start up (YES/NO)?

1:←SReading

1:yes              ===è( Type in ‘Yes’)

1:yes

1:

1:←SRunning

1:

1:SYSINIT complete.

1:

0:←S1/1 WINVP185005-GAQ DBS Startup - Initializing DBS Vprocs

0:←S1/1 WINVP185005-GAQ DBS Startup - Starting AMP Partitions

1:←S

0:←S1/1 WINVP185005-GAQ TABLEINIT is running

0:←S1/1 WINVP185005-GAQ DBS Startup - Voting for Transaction Recovery

0:←S1/1 WINVP185005-GAQ DBS Startup - Starting PE Partitions

0:←S1/1 WINVP185005-GAQ Logons are enabled - The system is quiescent

6:Input Supervisor Command:

6:←SReading

6:start dip   ===è( This command initiates DIP).

6:start dip

6:

6:←SRunning

6:Started 'dip' in window 1

6: at Fri Sep 10 17:58:55 2004

6:

1:

1:←SRunning

1:←Tdip

1:←O

1: _______

6:

6:Input Supervisor Command:

1:    |                                |              |

1:    |    ___     __     ____         |    ____    __|__    ____

6:←SReading

1:    |   /      |/  \    ____|    ____|    ____|     |      ____|

1:    |   ---    |       /    |   /    |   /    |     |     /    |

1:    |   \___   |       \____|   \____|   \____|     |__   \____|

1:

1:    Release V2R.06D.00.00.00 Version 06D.00.00.00

1:    DIP Utility (Jul 95)

1:

1:Type the password for user DBC or press the Enter key to quit:

1:

1:←SReading

1:dbc     ===è( Type in ‘dbc’ as the password for the user DBC.)

1:dbc

1:

1:←SRunning

1:

1:*** Logon successfully completed.

1:

1:Select one of the following DIP SQL scripts to execute

1:or press the Enter key to quit:

1:

1: 1. DIPERR   - Error Messages

1: 2. DIPRSS   - ResUsage Tables

1: 3. DIPVIEW  - System Views

1: 4. DIPOLH   - Online Help

1: 5. DIPSYSFE - System FE Macros

1: 6. DIPACR   - Access Rights

1: 7. DIPCRASH - CrashDumps Database

1: 8. DIPRUM   - ResUsage Views/Macros

1: 9. DIPCAL   - Calendar Tables/Views

1:10. DIPCCS   - Client Character Sets

1:11. DIPOCES  - Cost Profiles

1:12. DIPUDT   - UDT Cast Macros

1:13. DIPALL   - All of the above

1:14. DIPACC   - Access Logging

1:15. DIPPATCH - Stand-alone patches

1:

1:←SReading

1:13     ===è( Type in 13 as the option to run all the dips.)

1:13

1:

1:←SRunning

1:

1:Executing DIPALL at Fri Sep 10 17:59:53 2004

1:Please wait...

0:←S1/1 WINVP185005-GAQ Logons are enabled - Users are logged on

1:←SReading

0:←S1/1 WINVP185005-GAQ Logons are enabled - The system is quiescent

1:Would you like to execute another DIP script (Y/N)?

1:

1:←SReading

1:n  ===è( Type in ‘Yes’/’No’ based on whether you want to run any other dip after 13.)

1:n

1:

1:←SRunning

1:

1:Exiting DIP...

1:←S

Installation of Teradata Client Utilities:

1.  Browse for the folder \\10.58.38.90\share\\Teradata Client Software\ttu71 and execute TTU.exe and click install product.

   It is a bundle of all Teradata Client Utiltites.

2.  Add a Record

  

   <Your machine ip>  <Name of the host: As you wish> <Name of the host with cop1 suffix>

   E.g.: 153.55.36.39 Teradata Teradatacop1

   in the file c:\windows\system32\drivers\etc\hosts

    

   So that BTeq will search for the server in the local

   machine. 

   Note: For any RDBMS server machine to which you need to connect from the applications (such as bteq) from your box, you need to have the IP in the hosts file as above.

3.  Now run BTEQ

      

 Teradata BTEQ 08.02.02.00 for WIN32.

 Copyright 1984-2004, NCR Corporation. ALL RIGHTS RESERVED.

 Enter your logon or BTEQ command:

.logon Teradata/dbc

.logon Teradata/dbc

Password:

 *** Logon successfully completed.

 *** Transaction Semantics are BTET.

 *** Character Set Name is 'ASCII'.

 *** Total elapsed time was 3 seconds.

 BTEQ -- Enter your DBC/SQL request or BTEQ command: