Teradata Tools and Utilities. Installation Guide for Microsoft Windows

(1)

Teradata Tools and Utilities

Installation Guide for Microsoft Windows

Release 12.00.00 B035-2407-067A December 2007

(2)

The product or products described in this book are licensed products of Teradata Corporation or its affiliates.

Teradata, BYNET, DBC/1012, DecisionCast, DecisionFlow, DecisionPoint, Eye logo design, InfoWise, Meta Warehouse, MyCommerce, SeeChain, SeeCommerce, SeeRisk, Teradata Decision Experts, Teradata Source Experts, WebAnalyst, and You’ve Never Seen Your Business Like This Before are trademarks or registered trademarks of Teradata Corporation or its affiliates.

Adaptec and SCSISelect are trademarks or registered trademarks of Adaptec, Inc. AMD Opteron and Opteron are trademarks of Advanced Micro Devices, Inc.

BakBone and NetVault are trademarks or registered trademarks of BakBone Software, Inc. EMC, PowerPath, SRDF, and Symmetrix are registered trademarks of EMC Corporation. GoldenGate is a trademark of GoldenGate Software, Inc.

Hewlett-Packard and HP are registered trademarks of Hewlett-Packard Company. Intel, Pentium, and XEON are registered trademarks of Intel Corporation.

IBM, CICS, DB2, MVS, RACF, Tivoli, and VM are registered trademarks of International Business Machines Corporation. Linux is a registered trademark of Linus Torvalds.

LSI and Engenio are registered trademarks of LSI Corporation.

Microsoft, Active Directory, Windows, Windows NT, and Windows Server are registered trademarks of Microsoft Corporation in the United States and other countries.

Novell and SUSE are registered trademarks of Novell, Inc., in the United States and other countries. QLogic and SANbox trademarks or registered trademarks of QLogic Corporation.

SAS and SAS/C are trademarks or registered trademarks of SAS Institute Inc. SPARC is a registered trademarks of SPARC International, Inc.

Sun Microsystems, Solaris, Sun, and Sun Java are trademarks or registered trademarks of Sun Microsystems, Inc., in the United States and other countries.

Symantec, NetBackup, and VERITAS are trademarks or registered trademarks of Symantec Corporation or its affiliates in the United States and other countries.

Unicode is a collective membership mark and a service mark of Unicode, Inc.

UNIX is a registered trademark of The Open Group in the United States and other countries.

Other product and company names mentioned herein may be the trademarks of their respective owners.

THEINFORMATIONCONTAINEDINTHISDOCUMENTISPROVIDEDONAN “AS-IS” BASIS, WITHOUTWARRANTYOFANYKIND, EITHER EXPRESSORIMPLIED, INCLUDINGTHEIMPLIEDWARRANTIESOFMERCHANTABILITY, FITNESSFORAPARTICULARPURPOSE, OR NON-INFRINGEMENT. SOMEJURISDICTIONSDONOTALLOWTHEEXCLUSIONOFIMPLIEDWARRANTIES, SOTHEABOVEEXCLUSION MAYNOTAPPLYTOYOU. INNOEVENTWILL TERADATA CORPORATIONBELIABLEFORANYINDIRECT, DIRECT, SPECIAL, INCIDENTAL, ORCONSEQUENTIALDAMAGES, INCLUDINGLOSTPROFITSORLOSTSAVINGS, EVENIFEXPRESSLYADVISEDOFTHEPOSSIBILITYOF SUCHDAMAGES.

The information contained in this document may contain references or cross-references to features, functions, products, or services that are not announced or available in your country. Such references do not imply that Teradata Corporation intends to announce such features, functions, products, or services in your country. Please consult your local Teradata Corporation representative for those features, functions, products, or services available in your country.

Information contained in this document may contain technical inaccuracies or typographical errors. Information may be changed or updated without notice. Teradata Corporation may also make improvements or changes in the products or services described in this information at any time without notice.

To maintain the quality of our products and services, we would like your comments on the accuracy, clarity, organization, and value of this document. Please e-mail: [email protected]

Any comments or materials (collectively referred to as “Feedback”) sent to Teradata Corporation will be deemed non-confidential. Teradata Corporation will have no obligation of any kind with respect to Feedback and will be free to use, reproduce, disclose, exhibit, display, transform, create derivative works of, and distribute the Feedback and derivative works thereof without limitation on a royalty-free basis. Further, Teradata Corporation will be free to use any ideas, concepts, know-how, or techniques contained in such Feedback for any purpose whatsoever, including developing, manufacturing, or marketing products or services incorporating Feedback.

(3)

Preface

Purpose

This book provides information about installing the Teradata Tools and Utilities Release 12.00.00 software on a computer that runs on a Windows operating system. Teradata Tools and Utilities is a group of products designed to work with Teradata Database.

Audience

This book is intended for use by:

• System and application programmers

• System administrators

• Database administrators and relational database developers

• System operators and other database specialists

Supported Releases

This book supports the following releases:

• Teradata Database 12.00.00

• Teradata Tools and Utilities 12.00.00

To locate detailed supported-release information: 1 Go to http://www.info.teradata.com.

2 Navigate to General Search>Publication Product ID. 3 Enter 3119.

4 Open the version of the Teradata Tools and Utilities 12.00.00 Supported Versions spreadsheet associated with this release.

The spreadsheet includes supported Teradata Database versions, platforms, and product release numbers.

Prerequisites

(4)

Preface

Changes to This Book

• Computer technology and terminology

• Relational database management systems

• Utilities that load and retrieve data

Changes to This Book

The following changes were made to this book in support of the current release. Changes are marked with change bars. For a complete list of changes to the product, see the Release Definition associated with this release.

Additional Information

Additional information that supports this product and Teradata Tools and Utilities is available at the web sites listed in the table that follows. In the table, mmyx represents the publication date of a manual, where mm is the month, y is the last digit of the year, and x is an internal publication code. Match the mmy of a related publication to the date on the cover of this book. This ensures that the publication selected supports the same release.

Date and Release Description December 2007

12.00.00

Changed dependent product in example for “Installation of Dependent Products” from ODBC Driver for Teradata to Teradata Call-Level Interface version 2.

September 2007 12.00.00

Removed information on Teradata “Dynamic” Query Director.

August 2007 12.00.00

Removed ESDM information.

July 2007 12.00.00

Updated installation procedures to reflect Teradata products added to Teradata Tools and Utilities Release 12.00.00.

Type of Information Description Access to Information

Release overview Late information

Use the Release Definition for the following information:

• Overview of all of the products in the release

• Information received too late to be included in the manuals

• Operating systems and Teradata Database versions that are certified to work with each product

1 Go to http://www.info.teradata.com.

2 Select the General Search check box.

3 In the Publication Product ID box, type 2029. 4 Click Search.

5 Select the appropriate Release Definition from the search results.

(5)

Preface Additional Information

• Information about available training and the support center

• Version numbers of each product and the documentation for each product Additional product

information

Use the Teradata Information Products Publishing Library site to view or download specific manuals that supply related or additional information to this manual.

2 Select the Teradata Data Warehousing check box.

3 Do one of the following:

• For a list of Teradata Tools and Utilities documents, click Teradata Tools and Utilities and then select a release or a specific title. • Select a link to any of the data warehousing

publications categories listed.

Specific books related to Teradata Tools and Utilities are as follows:

• Messages

B035-1096-mmyA

• Teradata Tools and Utilities Command Summary

B035-2401-mmyA

• Teradata Manager Installation Guide

B035-2402-mmyA

• Teradata Driver for the JDBC Interface User Guide

B035-2403-mmyA

• Teradata Tools and Utilities Installation Guide for Microsoft Windows

B035-2407-mmyA

• Teradata MultiLoad Reference

B035-2409-mmyA

• Teradata FastExport Reference

B035-2410-mmyA

• Teradata FastLoad Reference

B035-2411-mmyA

• Teradata Archive/Recovery Utility Reference

B035-2412-mmyA

• Basic Teradata Query Reference

B035-2414-mmyA

• Teradata Director Program Reference

B035-2416-mmyA

• Teradata Call-Level Interface Version 2 Reference for Channel-Attached Systems

B035-2417-mmyA

(6)

Preface

Additional Information

• (Continued from the bulleted list above) in the Publication Product ID field, enter one of the following book numbers:

• Teradata Call-Level Interface Version 2 Reference for Network-Attached Systems

B035-2418-mmyA

• Teradata Transparency Series/ Application Programming Interface User Guide

B035-2419-mmyA

• Teradata Tools and Utilities Installation Guide for IBM VM

B035-2422-mmyA

• Teradata Tools and Utilities Access Module Programmer Guide

B035-2424-mmyA

• Teradata Tools and Utilities Access Module Reference

B035-2425-mmyA

• Teradata Manager User Guide

B035-2428-mmyA

• Teradata SQL Assistant for Microsoft Windows User Guide

B035-2430-mmyA

• Teradata Parallel Transporter Reference

B035-2436-mmyA

• Teradata Access Module for Tivoli Installation and User Guide

B035-2444-mmyA

• Teradata Parallel Transporter User Guide

B035-2445-mmyA

• Teradata Preprocessor2 for Embedded SQL Programmer Guide

B035-2446-mmyA

• IBM IMS/DC Interface for Teradata Reference

B035-2447-mmyA

• IBM CICS Interface for Teradata Reference

B035-2448-mmyA

• Interactive Teradata Query Reference

B035-2451-mmyA

• Interactive Teradata Query User Guide

B035-2452-mmyA

• Teradata Tools and Utilities Installation Guide for IBM z/OS

B035-2458-mmyA

• Teradata Tools and Utilities Installation Guide for UNIX and Linux

B035-2459-mmyA

(7)

Preface Additional Information

• (Continued from the bulleted list above) in the Publication Product ID field, enter one of the following book numbers:

• Teradata System Emulation Tool User Guide

B035-2492-mmyA

• OLE DB Provider for Teradata Installation and User Guide

B035-2498-mmyA

• Teradata Administrator User Guide

B035-2502-mmyA

• Teradata Statistics Wizard User Guide

B035-2503-mmyA

• Teradata Visual Explain User Guide

B035-2504-mmyA

• Teradata SQL Assistant/Web Edition User Guide

B035-2505-mmyA

• Teradata Index Wizard User Guide

B035-2506-mmyA

• ODBC Driver for Teradata User Guide

B035-2509-mmyA

• Teradata Query Director User Guide

B035-2510-mmyA

• Teradata Query Scheduler Administrator Guide

B035-2511-mmyA

• Teradata Query Scheduler User Guide

B035-2512-mmyA

• Teradata Dynamic Workload Manager User Guide

B035-2513-mmyA

• Teradata Workload Analyzer User Guide

B035-2514-mmyA

• Teradata Parallel Transporter Application Programming Interface Programmer Guide

B035-2516-mmyA

• Teradata Parallel Data Pump Reference

B035-3021-mmyA

• Teradata Meta Data Services Installation and Administration Guide

B035-3118-mmyA

• Teradata Meta Data Services Programmer Guide

B035-3047-mmyA CD-ROM images Access a link to a downloadable CD-ROM

image of all customer documentation for this release. Customers are authorized to create CD-ROMs for their use from this image.

2 Select the General Search check box.

3 In the Title or Keyword box, type CD-ROM. 4 Click Search.

(8)

Preface

Additional Information

Ordering information for manuals

Use the Teradata Information Products Publishing Library site to order printed versions of manuals.

2 Select the How to Order check box under Print & CD Publications.

3 Follow the ordering instructions. General information

about Teradata

The Teradata home page provides links to numerous sources of information about Teradata. Links include:

• Executive reports, case studies of customer experiences with Teradata, and thought leadership

• Technical information, solutions, and expert advice

• Press releases, mentions, and media resources

1 Go to Teradata.com.

2 Select a link.

(9)

Preface

. . . .3 Purpose . . . .3 Audience . . . .3 Supported Releases . . . .3 Prerequisites . . . .3

Changes to This Book . . . .4

Additional Information . . . .4

Chapter 1:

Introduction

. . . 21

System Configuration Information . . . 22

System Requirements. . . 26

Software Requirements . . . 28

Product Dependencies . . . 28

Installation Kit . . . 33

Teradata Software Server. . . 34

IBM VM and IBM z/OS. . . 34

Teradata Driver for the JDBC Interface . . . 34

Teradata Parallel Transporter Wizard . . . 34

Teradata Tools and Utilities CDs . . . 34

Chapter 2:

Before You Install

. . . 45

Installation Recommendations . . . 45

Installing on Windows Vista . . . 46

Installing on EM64T Systems . . . 46

Minimum and Recommended Configurations. . . 47

Shared ICU Libraries for Teradata Recommendations . . . 48

Installation of Dependent Products . . . 48

Teradata Generic Security Services. . . 49

(10)

Table of Contents

Typical, Custom, and Network Installations. . . .50

Command Line Installations. . . .50

Teradata Download Center Installations . . . .50

Teradata Parallel Transporter Installation. . . .50

Uninstalling Previous Software . . . .51

Default Folders . . . .51

Default Product Response Files . . . .51

Restarting After Installation. . . .56

Technical Assistance . . . .56

Installing Required Software for Teradata SQL Assistant/Web Edition . . . .57

Installing Microsoft Internet Information Services . . . .58

Installing ASP.NET for Windows Server 2003 . . . .58

Installing Microsoft .NET Framework (version 1.1) . . . .59

Installing Microsoft Visual J#.Net Redistributable Package (version 1.1) . . . .59

Installing the Cumulative Security Patch for IIS. . . .60

Changing Microsoft Internet Explorer Security Settings . . . .60

Changing Cookies Settings on Microsoft Internet Explorer . . . .61

Setting the Number of Client Connections . . . .62

Setting the Number of Clients on Windows Vista . . . .63

Updating the Teradata Parallel Transporter API . . . .64

Chapter 3:

Installing the Teradata Tools and Utilities Software

. . . .65

Types of Installation . . . .65

Installing Using PUT . . . .66

Installing Using the Client Main Install . . . .67

Initial Procedure for Typical, Custom or Network Installations. . . .67

Typical Installation . . . .68

Custom Installation . . . .78

Network Installation . . . .82

Installing a Package from the Command Prompt . . . .84

Sample Package Folder Installation . . . .84

Installation Commands . . . .85

Configuring the Products . . . .89

Installing the Teradata Driver for the JDBC Interface. . . .89

(11)

Table of Contents

Chapter 4:

Configuring the Teradata Tools and Utilities Software

. . . 91

Configuring Teradata Administrator . . . 91

Configuring the ODBC Driver, Teradata Query Scheduler, and Teradata Manager . . . 92

Configuring Teradata Call-Level Interface version 2 (CLIv2) for Windows . . . 93

Setting Network Parameters . . . 93

Setting Environment Parameters . . . 95

Setting System Parameters . . . 97

Adding CLI User Exit Functions. . . 97

Configuring Teradata Parallel Transporter . . . 98

Changing the twbcfg.ini File . . . 98

Switching Teradata Parallel Transporter Software Versions . . . 99

User Environment Variables. . . 101

System Environment Variable ORACLE_HOME. . . 102

Uninstalling Teradata Parallel Transporter . . . 102

Order to Remove Teradata Parallel Transporter Software. . . 102

Configuring Teradata Access Module for JMS . . . 103

Chapter 5:

Verifying the Installation

. . . 105

Verifying the Installation of Individual Products . . . 107

Verifying Basic Teradata Query (BTEQ) . . . 107

Verifying Named Pipes Access Module . . . 108

Verifying ODBC Driver for Teradata. . . 108

Verifying Shared ICU Libraries for Teradata . . . 109

Verifying Teradata Access Module for JMS. . . 110

Verifying Teradata Access Module for Tivoli . . . 110

Verifying Teradata Archive/Recovery Utility (ARC) . . . 111

Verifying Teradata C Preprocessor2. . . 111

Verifying Teradata Call-Level Interface version 2 (CLIv2) . . . 111

Verifying Teradata Data Connector . . . 113

Verifying Teradata Driver for the JDBC Interface . . . 114

Verifying Teradata Dynamic Workload Manager. . . 114

Verifying Teradata FastExport . . . 115

Verifying Teradata FastLoad . . . 115

Verifying Teradata MultiLoad . . . 116

Verifying Teradata MultiTool. . . 116

Verifying Teradata OLE DB Access Module . . . 117

(12)

Table of Contents

Verifying Teradata Parallel Transporter Data Connector Operator . . . .125

Verifying Teradata Parallel Transporter DDL Operator . . . .125

Verifying Teradata Parallel Transporter Export Operator . . . .126

Verifying Teradata Parallel Transporter ICU Library. . . .126

Verifying Teradata Parallel Transporter Infrastructure . . . .127

Verifying Teradata Parallel Transporter Load Operator . . . .129

Verifying Teradata Parallel Transporter ODBC Operator . . . .130

Verifying Teradata Parallel Transporter Operator Support Library . . . .130

Verifying Teradata Parallel Transporter OS Command Operator . . . .131

Verifying Teradata Parallel Transporter SQL Inserter Operator . . . .131

Verifying Teradata Parallel Transporter SQL Selector Operator. . . .131

Verifying Teradata Parallel Transporter Stream Operator. . . .132

Verifying Teradata Parallel Transporter Update Operator . . . .132

Verifying Teradata Parallel Transporter Wizard. . . .133

Verifying Teradata Query Scheduler Administrator. . . .134

Verifying Teradata Query Scheduler Client. . . .134

Verifying Teradata Query Scheduler Server . . . .134

Verifying Teradata TPump . . . .135

Verifying WebSphere MQ Access Module . . . .135

Verifying Teradata Workload Analyzer . . . .135

Verifying the Installation Using the CLI Sample Program, clisamp . . . .136

Chapter 6:

Connecting to a Teradata Database

. . . .139

Making the Database Connection . . . .139

Overview of Logon Procedures . . . .139

Connecting in GUI Applications . . . .140

Connecting in Command Line Driven Applications . . . .142

Example Logons from the Command Line . . . .143

Connecting to a Teradata Database Programmatically . . . .149

Logon Error Messages . . . .150

Chapter 7:

Troubleshooting

. . . .151

Technical Assistance . . . .151

Client Computer Problems . . . .151

Cannot Communicate Over the Network with Teradata Database . . . .151

(13)

Table of Contents

File localisation.dll Could Not Be Opened . . . 152

File icuuctd28.dll Could Not Be Found . . . 152

Incorrect Path Name in COPANOMLOG. . . 153

Incorrect CLIv2 Libraries Referenced . . . 153

CLIv2 DLLs Load Error . . . 153

Incorrect Entries in the hosts File . . . 153

Missing Entries in the services File . . . 153

Incorrect clispb.dat Parameters . . . 153

Cannot Log On from CLI Application. . . 154

Cannot Log On to the Teradata Database . . . 154

MSVCR71.DLL not found Message . . . 154

Network Problems . . . 154

Software Problems . . . 155

Error Running ttu.exe . . . 155

Install Button Does Not Work . . . 155

InstallShield 1603 Error. . . 155

InstallShield 1607 Error. . . 156

InstallShield 432 Error . . . 158

Teradata Database Hardware Problems . . . 158

Silent Installation Result Codes . . . 160

Location of the Setup Log . . . 160

InstallShield Result Codes . . . 160

(14)

(15)

List of Figures

(16)

(17)

List of Tables

Table 1: Platforms Supported by Each Product . . . 22

Table 2: Product Dependencies . . . 28

Table 3: Teradata Utility Pak CD#1 (Windows Products) . . . 34

Table 4: Teradata Utility Pak CD#2 (HP-UX, Linux and MP-RAS Products) . . . 35

Table 5: Teradata Utility Pak CD#3 (AIX and Solaris Products) . . . 35

Table 6: Data Management CD . . . 36

Table 7: Preprocessors CD#1 (Windows Products). . . 36

Table 8: Preprocessors CD#2 (HP, Linux, and MP-RAS Products). . . 37

Table 9: Preprocessors CD#3 (AIX and Solaris Products) . . . 37

Table 10: Load/Unload CD#1 (Windows Products) . . . 37

Table 11: Load/Unload CD#2 (HP-UX, Linux and MP-RAS Products) . . . 38

Table 12: Load/Unload CD#3 (AIX and Solaris Products) . . . 38

Table 13: Parallel Transporter CD#1 (Windows Products) . . . 39

Table 14: Parallel Transporter CD#2 (HP-UX, Linux, and MP-RAS Products). . . 40

Table 15: Parallel Transporter CD#3 (AIX and Solaris Products) . . . 41

Table 16: Tape Storage Management Enablers CD . . . 42

Table 17: Query Director CD. . . 43

Table 18: MetaData Services CD . . . 43

Table 19: Minimum Configurations for Teradata Tools and Utilities. . . 47

Table 20: Recommended Configurations for Teradata Tools and Utilities. . . 48

Table 21: Default CD Folders. . . 51

Table 22: Default Folders and Product Response Files . . . 52

Table 23: setup.exe . . . 84

Table 24: setup.exe command parameters . . . 85

Table 25: Command Prompt Installation Command . . . 86

Table 26: Configuring ODBC, Teradata Query Scheduler and Teradata Manager . . . 92

Table 27: Adding an Entry to the hosts File . . . 93

Table 28: hosts File Syntax . . . 94

Table 29: Environment Parameters . . . 95

Table 30: Setting Environment Parameters . . . 95

Table 31: Logon Parameters. . . 96

(18)

List of Tables

Table 33: Port Number Parameters. . . .96

Table 34: Setting TDMSTPORT . . . .97

Table 35: Basic Teradata Query (BTEQ) Files 32-bit Platforms . . . .107

Table 36: Named Pipes Access Module 32-bit Files. . . .108

Table 37: ODBC Driver for Teradata 32-bit Files . . . .108

Table 38: ODBC Driver for Teradata 64-bit Files . . . .109

Table 39: Share ICU Libraries for Teradata 32-bit Files . . . .109

Table 40: Shared ICU Libraries for Teradata 64-bit Files . . . .110

Table 41: Teradata Access Module for JMS Files . . . .110

Table 42: Teradata Access Module for Tivoli Files. . . .110

Table 43: Teradata Archive/Recovery Utility (ARC) 32-bit Files . . . .111

Table 44: Teradata C Preprocessor2 32-bit and 64-bit Files . . . .111

Table 45: Teradata Call-Level Interface version 2 (CLIv2), 32-bit Files . . . .111

Table 46: Teradata Call-Level Interface version 2 (CLIv2), 64-bit Files . . . .112

Table 47: Teradata Data Connector 32-bit Files . . . .113

Table 48: Teradata Data Connector 64-bit Files . . . .114

Table 49: Teradata Driver for the JDBC Interface . . . .114

Table 50: Teradata Dynamic Workload Manager Files . . . .114

Table 51: Teradata FastExport 32-bit Files . . . .115

Table 52: Teradata FastLoad 32-bit Files . . . .115

Table 53: Teradata MultiLoad 32-bit Files . . . .116

Table 54: Teradata MultiTool 32-bit Files . . . .116

Table 55: Teradata OLE DB Access Module 32-bit Files . . . .117

Table 56: 32-bit Teradata Parallel Transporter API. . . .117

Table 57: 64-bit Teradata Parallel Transporter API. . . .121

Table 58: Teradata Parallel Transporter Data Connector Operator. . . .125

Table 59: Teradata Parallel Transporter DDL Operator . . . .125

Table 60: 32-bit Teradata Parallel Transporter Export Operator . . . .126

Table 61: 64-bit Teradata Parallel Transporter Export Operator . . . .126

Table 62: 32-bit Teradata Parallel Transporter ICU Library Files . . . .126

Table 63: 64-bit Teradata Parallel Transporter ICU Library Files . . . .126

Table 64: Teradata Parallel Transporter Infrastructure Files . . . .127

Table 65: 32-bit Teradata Parallel Transporter Load Operator . . . .129

Table 66: 64-bit Teradata Parallel Transporter Load Operator . . . .130

Table 67: Teradata Parallel Transporter ODBC Operator . . . .130

(19)

List of Tables

Table 69: 64-bit Teradata Parallel Transporter Operator Support Library . . . 130

Table 70: Teradata Parallel Transporter OS Command Operator . . . 131

Table 71: Teradata Parallel Transporter SQL Inserter Operator . . . 131

Table 72: Teradata Parallel Transporter SQL Selector Operator . . . 131

Table 73: 32-bit Teradata Parallel Transporter Stream Operator. . . 132

Table 74: 64-bit Teradata Parallel Transporter Stream Operator. . . 132

Table 75: 32-bit Teradata Parallel Transporter Update Operator . . . 132

Table 76: 64-bit Teradata Parallel Transporter Update Operator . . . 132

Table 77: Teradata Parallel Transporter Wizard . . . 133

Table 78: Teradata Query Scheduler Administrator 32-bit Files . . . 134

Table 79: Teradata Query Scheduler Client 32-bit Files . . . 134

Table 80: Teradata Query Scheduler Server 32-bit Files . . . 134

Table 81: Teradata TPump 32-bit Files. . . 135

Table 82: WebSphere MQ Access Module . . . 135

Table 83: Teradata Workload Analyzer Files . . . 135

(20)

(21)

CHAPTER 1

Introduction

This chapter provides background information you will need before installing the Teradata Tools and Utilities software.

The section topics are:

• System Configuration Information

• Software Requirements

(22)

Chapter 1: Introduction

System Configuration Information

The Teradata Tools and Utilities software, together with the Teradata Database software, permits communication between a Teradata client and a Teradata Database.

Table 1: Platforms Supported by Each Product

Windows 2000 XP Server 2003 Vista

Product Micros oft W ind ows 2000 Profession al Server and Adva nced Server , w ith sp4 , runn in g on Intel x86 (3 2-bi t T era data To ol s and Utilit ies) Micros oft W ind ows XP Profession al, w ith sp2 , run nin g on Intel x86 (3 2-bi t T erad ata T ool s an d Uti lit ies ) Micros oft W ind ows XP Profession al, w ith sp2 , run nin g on I ntel X eon wi th EM 64T/ O pt eron (3 2-bi t T erad ata T ool s an d Uti lit ies ) Micros oft W ind ows XP Profession al, x64, with sp 2, run nin g on I ntel X eon wi th EM 64T/ O pt eron (3 2-bi t T era data To ol s and Utilit ies) Micros oft W ind ows XP Profession al, x64, with sp 2, run nin g on I ntel X eon wi th EM 64T/ O pt eron (6 4-bi t T era data To ol s and Utilit ies) Micros oft W ind

ows Server 2003 Enterpr

ise and Standa rd Ed itions, with sp 2, run ning on Intel x86 (3 2-bi t T erad ata T ool s an d Uti lit ies ) Micros oft W ind

ise and Stand ard Ed iti ons, with sp 2, run ni ng on In tel X eon w ith EM 64T /O pteron 32-b it (3 2-bi t T erad ata T ool s an d Uti lit ies ) Micros oft W ind

ise x64 and Stand ard x64 Ed iti ons, with sp 2, run ni ng on In tel X eon w ith EM 64T /O pteron (3 2-bi t T erad ata T ool s an d Uti lit ies ) Micros oft W ind

ise x64 and Stand ard x64 Ed iti ons, with sp 2, run ni ng on In tel X eon w ith EM 64T /O pteron (6 4-bi t T era data To ol s and Utilit ies) ]M icro sof t W in do ws V ist a En terpri se Ed itio n run nin g on Intel x86 (3 2-bi t T era data To ol s and Utilit ies Mi cros oft W ind ows V ista En terp ris e Ed itio n run nin g on E M 64T /O ptero n x32-bit (3 2-bi t T era data To ol s and Utilit ies) Mi cros oft W ind ows V ista En terp ris e Ed itio n run nin g on E M 64T /O ptero n x64-bit (3 2-bi t T era data To ol s and Utilit ies Mi cros oft W ind ows V ista En terp ris e Ed itio n run nin g on E M 64T /O ptero n x64-bit (6 4-bi t T era data To ol s and Utilit ies

Basic Teradata Query (BTEQ) YES YES YES YES NO YES YES YES NO YES YES YES NO

BTEQWin YES YES NO YES NO NO YES YES NO NO NO NO NO

Named Pipes Access Module a YES YES YES YES NO YES YES YES NO YES YES YES NO ODBC Driver for Teradata YES YES YES YES YES YES YES YES YES YES YES YES YES OLEDB Provider for Teradata YES YES YES YES NO YES YES YES NO YES YES YES NO Shared ICU Libraries for

Teradata

YES YES YES YES YES YES YES YES YES YES YES YES YES

Teradata Access Module for JMS YES YES YES YES YES YES YES YES NO YES YES YES YES Teradata Access Module for

Tivoli

YES NO NO NO NO NO NO NO NO NO NO NO NO

Teradata Administrator YES YES YES YES NO YES YES YES NO YES YES YES NO Teradata Archive/Recovery

Utility (ARC) b

*YES *YE S

*YES YES NO *YE S

*YE S

YES NO NO NO NO NO

Teradata C Preprocessor2 YES YES YES YES YES YES YES YES YES YES YES YES YES Teradata Call-Level Interface

version 2 (CLIv2)

(23)

Chapter 1: Introduction System Configuration Information

Teradata Driver for the JDBC Interface

YES YES NO YES YES YES YES YES YES YES NO YES YES

Teradata Dynamic Workload Manager

(Teradata DWM)

YES YES YES YES NO YES YES YES NO YES YES YES NO

Teradata FastExport YES YES YES YES NO YES YES YES NO YES YES YES NO

Teradata FastLoad YES YES YES YES NO YES YES YES NO YES YES YES NO

Teradata Generic Security Services (TeraGSS) Client (Java support)

Teradata Generic Security Services (TeraGSS) Client (C support)

Teradata Index Wizard YES YES YES YES NO YES YES YES NO YES YES YES NO

Teradata Manager YES YES YES YES NO YES YES YES NO YES YES YES NO

Teradata MultiLoad YES YES YES YES NO YES YES YES NO YES YES YES NO

Teradata MultiTool c YES NO NO NO NO YES YES NO NO YES YES YES NO

Teradata OLE DB Access Module YES YES YES YES NO YES YES YES NO YES YES YES NO Teradata Parallel Transporter

API

Teradata Parallel Transporter Data Connector Operator

Teradata Parallel Transporter DDL Operator

Table 1: Platforms Supported by Each Product (continued)

Product Micro soft Win dow s 20 00 Pro fe ssio nal Server an d Ad vance d Serv er , wit h sp 4, ru nning on Intel x8 6 (32-bi t T eradata To ols an d Uti lit ies ) M icro soft Win dow s XP Pro fe ssio nal, wit h s p2, ru nni ng on In tel x8 6 (32-bit T eradata T ools an d Uti lit ies ) M icro soft Win dow s XP Pro fe ssio nal, wit h s p2, ru nni ng on In tel X eo n w ith EM 64 T/O ptero n (32-bit T eradata T ools an d Uti lit ies ) M icro soft Win dow s XP Pro fe ssio nal, x64, w ith sp2, ru nni ng on In tel X eo n w ith EM 64 T/O ptero n (32-bi t T eradata To ols an d Uti lit ies ) M icro soft Win dow s XP Pro fe ssio nal, x64, w ith sp2, ru nni ng on In tel X eo n w ith EM 64 T/O ptero n (64-bi t T eradata To ols an d Uti lit ies ) M icro soft Win dow s Serve r 20 03 Enterp rise an d Stand ard Edit ion s, with s p2, ru nning o n Intel x 86 (32-bit T eradata T ools an d Uti lit ies ) M icro soft Win dow s Serve r 20 03 Enterp rise an d Stan dard Ed itio ns, with sp 2, run ni ng on In te l X eon wit h EM 64T /Op teron 32-b it (32-bit T eradata T ools an d Uti lit ies ) M icro soft Win dow s Serve r 20 03 Enterp rise x6 4 an d Stan dard x64 Ed itio ns, with sp 2, run ni ng on In te l X eon wit h EM 64T /Op teron (32-bit T eradata T ools an d Uti lit ies ) M icro soft Win dow s Serve r 20 03 Enterp rise x6 4 an d Stan dard x64 Ed itio ns, with sp 2, run ni ng on In te l X eon wit h EM 64T /Op teron (64-bi t T eradata To ols an d Uti lit ies ) ]Micro soft Wind ow s V ista Enter prise Editio n ru nni ng on In tel x8 6 (32-bi t T eradata To ols an d Uti lit ies M icro soft Win dow s V ista En te rprise Ed ition ru nning on EM 64T/Opter on x32-bit (32-bi t T eradata To ols an d Uti lit ies ) M icro soft Win dow s V ista En te rprise Ed ition ru nning on EM 64T/Opter on x64-bit (32-bi t T eradata To ols an d Uti lit ies M icro soft Win dow s V ista En te rprise Ed ition ru nning on EM 64T/Opter on x64-bit (64-bi t T eradata To ols an d Uti lit ies

(24)

Teradata Parallel Transporter Export Operator

Teradata Parallel Transporter FastExport OUTMOD Adapter Operator d

Teradata Parallel Transporter FastLoad INMOD Adapter Operator e

Teradata Parallel Transporter ICU Library

Teradata Parallel Transporter Infrastructure

Teradata Parallel Transporter Load Operator

Teradata Parallel Transporter MultiLoad INMOD Adapter Operatorf

Teradata Parallel Transporter ODBC Operator

Teradata Parallel Transporter Operator Support Library

Teradata Parallel Transporter OS Command Operator

Teradata Parallel Transporter SQL Inserter Operator

Teradata Parallel Transporter SQL Selector Operator

(25)

Teradata Parallel Transporter Stream Operator

Teradata Parallel Transporter Update Operator

Teradata Parallel Transporter Wizard

Teradata Performance Monitor YES YES YES YES NO YES YES YES NO YES YES YES NO Teradata Query Director YES YES YES YES NO YES YES YES NO YES YES YES NO Teradata Query Scheduler

Administrator

Teradata Query Scheduler Client YES YES YES YES NO YES YES YES NO YES YES YES NO Teradata Query Scheduler Server YES YES YES YES NO YES YES YES YES YES YES NO NO Teradata SQL Assistant YES YES YES YES NO YES YES YES NO YES YES YES NO Teradata SQL Assistant/Web

Edition

Teradata Statistics Wizard YES YES YES YES NO YES YES YES NO YES YES YES NO Teradata System Emulation Tool YES YES YES YES NO YES YES YES NO YES YES YES NO

Teradata TPump YES YES YES YES NO YES YES YES NO YES YES YES NO

Teradata Visual Explain YES YES YES YES NO YES YES YES NO YES YES YES NO Teradata Workload Analyzer YES YES YES YES NO YES YES YES NO YES YES YES NO WebSphere MQ Access Module

for Teradata

(26)

a Named Pipes Access Module installs files for both the utility version and the Teradata Parallel Transporter version. It is included as a free product if you ordered any of the following products:

b The Teradata Archive and Recovery Utility (ARC) is included for Open Teradata Backup and is not sold as an individual product.

c Teradata MultiTool cannot be installed if Teradata Database is already installed, because the installation of Teradata Database installs Teradata MultiTool.

d FastExport OUTMOD Adapter Operator is installed as part of the Teradata Parallel Transporter Infrastructure installation.

e FastLoad INMOD Adapter Operator is installed as part of the Teradata Parallel Transporter Infrastructure installation.

f MultiLoad INMOD Adapter Operator is installed as part of the Teradata Parallel Transporter Infrastructure installation.

System Requirements

To use the Teradata Tools and Utilities software, you must have an i386-based or greater computer with:

• An appropriate network card

• Ethernet or Token Ring LAN cards

• 345.9MB of free disk space for a full installation

• FAT or NTFS for Teradata Generic Security Services (TeraGSS) Client

Platform Requirements

Before installing the Teradata Tools and Utilities software, your computer must run on one of the following operating systems:

Windows 2000

• Microsoft Windows 2000 Professional Server and Advanced Server, with sp4, running on Intel x86 (32-bit Teradata Tools and Utilities)

Windows XP Professional

• Microsoft Windows XP Professional, with sp2, running on Intel x86 (32-bit Teradata Tools and Utilities)

• Microsoft Windows XP Professional, with sp2, running on Intel Xeon with EM64T/ Opteron (32-bit Teradata Tools and Utilities)

• Microsoft Windows XP Professional, x64, with sp2, running on Intel Xeon with EM64T/ Opteron (32-bit Teradata Tools and Utilities)

Archive and Recovery Utility (ARC) Teradata FastLoad Basic Teradata Query (BTEQ) Teradata MultiLoad Teradata FastExport Teradata TPump

(27)

• Microsoft Windows XP Professional, x64, with sp2, running on Intel Xeon with EM64T/ Opteron(64-bit Teradata Tools and Utilities)

Windows Server 2003

• Microsoft Windows Server 2003 Enterprise and Standard Editions, with sp2, running on Intel x86 (32-bit Teradata Tools and Utilities)

• Microsoft Windows Server 2003 Enterprise and Standard Editions, with sp2, running on Intel Xeon with EM64T/Opteron x32-bit (64-bit Teradata Tools and Utilities)

• Microsoft Windows Server 2003 Enterprise x64 and Standard x64 Editions, with sp2, running on Intel Xeon with EM64T/Opteron(32-bit Teradata Tools and Utilities)

• Microsoft Windows Server 2003 Enterprise x64 and Standard x64 Editions, with sp2, running on Intel Xeon with EM64T/Opteron (64-bit Teradata Tools and Utilities) Windows Vista

• Microsoft Windows Vista Enterprise Edition, running on Intel x86 (32-bit Teradata Tools and Utilities)

• Microsoft Windows Vista Enterprise Edition, running on EM64T/Opteron x32-bit (32-bit Teradata Tools and Utilities)

Table 1 on page 22 shows which Windows platforms are supported by each product.

Administrator Privileges

You must have administrator privileges for the computer on which you will be installing the Teradata Tools and Utilities software.

Network Requirements

Your computer should be able to communicate with a network-attached Teradata Database that is using the TCP/IP protocol with Winsock version 2.0 support.

For an up-to-date description of which software the Teradata Database should be running, refer to the Teradata Tools and Utilities Release Definition, Release 12.0.

Teradata Database Requirements

The appropriate Ethernet hardware and software, supporting a TCP/IP-based network, must be installed on every Teradata Database with which your computer will communicate.

(28)

Chapter 1: Introduction Software Requirements

Software Requirements

Product Dependencies

In the following table, the products in the first column are dependent upon, and must be installed with the products in the second column.

Table 2: Product Dependencies

These products... require these installations...

Basic Teradata Query (BTEQ) version 12.00.00 • CLIv2 version 12.00.00 or later

• Teradata Data Connector version 12.00.00 or later • Shared ICU Libraries for Teradata version 12.00.00 or

later

BTEQWin version 12.00.00 • BTEQ version 12.00.00

Named Pipes Access Module version 12.00.00 • No dependencies NetBackup Teradata Extension version 12.00.00 • No dependencies

ODBC Driver for Teradata version 12.00.00 • Microsoft Data Access Components (MDAC), version 2.8 sp1 (on distribution CD)

• Shared ICU Libraries for Teradata version 12.00.00 • Teradata Generic Security Services version 12.00.00 or

later

TeraGSS - Client package Shared ICU Libraries for Teradata version 12.00.00 • No dependencies

Teradata Access Module for JMS version 12.00.00 • Teradata Data Connector version 12.00.00 or later • JDK 1.4 or later

• JMS enabled Messaging System Teradata Access Module for Tivoli version 12.00.00 • No dependencies

Teradata Administrator version 12.00.00 • ODBC Driver for Teradata version 12.00.00 or later Teradata Archive/Recovery Utility (ARC) version 12.00.00 • CLIv2 version 12.00.00or later

• Teradata Data Connector version 12.00.00 or later Note: ARC is not distributed as a stand-alone product. It is installed with Open Teradata Backup on MP-RAS and Windows 2000.

Teradata C Preprocessor2 version 12.00.00 • CLIv2 version 12.00.00 or later

(29)

Teradata Call-Level Interface version 2 (CLIv2) version 12.00.00

• Shared ICU Libraries for Teradata version 12.00.00 or later

• Teradata Generic Security Services version 12.00.00 or later

TDGSS - Server package TeraGSS - Client package Teradata Data Connector version 12.00.00 • No dependencies

Teradata Dynamic Workload Manager version 12.00.00 • CLIv2 version 12.00.00 or later Teradata FastExport version 12.00.00 • CLIv2 version 12.00.00 or later

• Teradata Data Connector version 12.00.00 or later Teradata FastLoad version 12.00.00 • CLIv2 version 12.00.00 or later

• Teradata Data Connector version 12.00.00 or later Teradata Generic Security Services Client (TeraGSS) version

12.00.00

• No dependencies

Teradata Generic Security Services Client Java (TeraGSSJava) version12.00.00

• No dependencies

Teradata Index Wizard version 12.00.00 • CLIv2 version 12.00.00 or later or

• ODBC Driver for Teradata version 12.00.00 or later Teradata Manager version 12.00.00 • CLIv2 version 12.00.00or later

Teradata MultiLoad version 12.00.00 • CLIv2 version 12.00.00 or later

• Teradata Data Connector version 12.00.00 or later Teradata MultiTool version 12.00.00 • Java 2 Runtime Environment 1.5 or later

Note: The environment can be downloaded from the Sun website at: http://java.sun.com/products/archive/j2se/1.4.0/ index.html

Teradata OLE DB Access Module version 12.00.00 • ODBC Driver for Teradata version 12.00.00 or later Teradata Performance Monitor version 12.00.00 • CLIv2 version 12.00.00 or later

Teradata Query Director version 12.00.00 • CLIv2 version 12.00.00 or later

• Shared ICU Libraries for Teradata version 12.00.00 • Teradata_GSS_Client version 12.00.00 or later Teradata Query Scheduler Administrator version 12.00.00 • CLIv2 version 12.00.00 or later

Teradata Query Scheduler Client version 12.00.00 • CLIv2 version 12.00.00 or later Teradata Query Scheduler Server version 12.00.00 • CLIv2 version 12.00.00 or later

• Teradata Query Scheduler Client version 12.00.00 Table 2: Product Dependencies (continued)

(30)

Teradata SQL Assistant version 12.00.00 • ODBC Driver for Teradata version 12.00.00 or later Teradata SQL Assistant/Web Edition version 12.00.00 • ODBC Driver for Teradata version 12.00.00 or later

To install, your PC must run one of the following. It will not work with other Windows operating systems:

• Windows 2000 Professional • Windows 2000 Server

• Windows 2000 Advanced Server • Windows 2003, or

• 32-bit Windows XP.

Note: See “Installing Required Software for Teradata SQL Assistant/Web Edition” on page 57. This section documents the additional software that must be installed prior to installing Teradata SQL Assistant/Web Edition. Teradata Statistics Wizard version 12.00.00 • CLIv2 version 12.00.00 or later

Teradata System Emulation Tool version 12.00.00 • CLIv2 version 12.00.00 or later or

• ODBC Driver for Teradata version 12.00.00 or later Teradata TPump version 12.00.00 • CLIv2 version 12.00.00 or later

• Teradata Data Connector version 12.00.00 or later • Shared ICU Libraries for Teradata version 12.00.00 Teradata Visual Explain version 12.00.00 • CLIv2 version 12.00.00 or later

or

• ODBC Driver for Teradata version 12.00.00 or later Teradata Parallel Transporter version 12.00.00

• Teradata Parallel Transporter API version 12.00.00 • Teradata Parallel Transporter Load Operator 12.00.00 or later

• Teradata Parallel Transporter Update Operator 12.00.00 or later

• Teradata Parallel Transporter Stream Operator 12.00.00 or later

• Teradata Parallel Transporter Export Operator 12.00.00 or later

• Teradata Parallel Transporter ICU Library version 12.00.00

• Teradata Parallel Transporter Infrastructure version 12.00.00

Table 2: Product Dependencies (continued)

(31)

• Teradata Parallel Transporter DataConnector Operator version 12.00.00

• Teradata Parallel Transporter Operator Support Library 12.00.00 or later

• Teradata Parallel Transporter Infrastructure 12.00.00 or later

• Teradata Parallel Transporter DDL Operator version 12.00.00

• CLIv2 12.00.00 or later

• Teradata Parallel Transporter Export Operator version 12.00.00

• Teradata Parallel Transporter FastExport OUTMOD Adapter Operator a version 12.00.00

• Teradata Parallel Transporter FastLoad INMOD Adapter Operator b version 12.00.00

• Shared ICU Libraries for Teradata 12.00.00 or later

• Teradata Parallel Transporter Load Operator version 12.00.00

Teradata Parallel Transporter MultiLoad INMOD Adapter Operatorc version 12.00.00

• Teradata Parallel Transporter ODBC Operator version 12.00.00

(32)

a FastExport OUTMOD Adapter Operator is installed as part of the Teradata Parallel Transporter Infrastructure installation.

b FastLoad INMOD Adapter Operator is installed as part of the Teradata Parallel Transporter Infrastructure installation.

• Teradata Parallel Transporter Operator Support Library version 12.00.00

• Teradata Parallel Transporter ICU Library version 12.00.00 or later

• Teradata Parallel Transporter OS Command Operator version 12.00.00

• Teradata Parallel Transporter SQL Inserter Operator version 12.00.00

• Teradata Parallel Transporter SQL Selector Operator version 12.00.00

• Teradata Parallel Transporter Stream Operator version 12.00.00

• Teradata Parallel Transporter Update Operator version 12.00.00

• Teradata Parallel Transporter Wizard version 12.00.00 • Teradata Parallel Transporter Infrastructure 12.00.00 or later

Teradata Workload Analyzer version 12.00.00 • CLIv2 version 12.00.00 or later

WebSphere MQ Access Module version 12.00.00 • Teradata Data Connector 12.00.00 or later • WebSphere MQ V5.2