Teradata1401安装文档(Linux).docx

Teradata1401安装文档（Linux）1. 环境说明操作系统：Red Hat Enterprise Linux Server release 6.4 (Santiago)IP地址：128.64.108.146数据库IP：128.192.145.228/128.192.145.229/128.192.145.2302. 环境准备2.1. 登录使用root登录128.64.108.1462.2. 上传安装介质假定介质存放目录为/home/ap/dwetl/software将TTU1401_LINUX.tar、libstdc+6-32bit-4.7.2_20130108-2.1.6.x86_64.rpm、DBI-1.609.tar、DBD-Teradata-1.52.tar上传到/home/ap/dwetl/software2.3. 解压文件mkdir -p TTU1401_LINUX/lib DBD DBItar -xf TTU1401_LINUX.tar -C TTU1401_LINUXcd /home/ap/dwetl/softwaremv libstdc+6-32bit-4.7.2_20130108-2.1.6.x86_64.rpm ./TTU1401_LINUX/libtar -xf DBD-Teradata-1.52.tar -C DBDtar -xf DBI-1.609.tar -C DBI3. 安装3.1. 安装lib包如在安装lib包前已安装Teradata，需先卸载Teradata相关包后，再按lib、Teradata的顺序安装。cd /home/ap/dwetl/software/TTU1401_LINUX/librpm -ivh libstdc+6-32bit-4.7.2_20130108-2.1.6.x86_64.rpm3.2. 安装Teradatacd /home/ap/dwetl/software/TTU1401_LINUXsh .setup.shEnter one or more selections(separated by space):a如果是重装，会出现如下提示，按y即可。Do you want to reinstall the package? y/n (default:n) : y3.3. 安装DBI（如程序中未使用DBI方式连接TD数据库可不安装）cd DBI/DBI-1.609perl Makefile.PLmakemake install3.4. 安装DBDcd /home/ap/dwetl/software/DBD/DBD-Teradata-1.52perl Makefile.PLmakemake install3.5. 配置ODBC路径cd /opt/teradata/clientln -sf /opt/teradata/client/14.00/odbc_32 ODBC_32ln -sf /opt/teradata/client/14.00/odbc_64 ODBC_644. 验证4.1. Teradata验证1) 配置/etc/hosts，添加Teradata数据源配置2) Teradata验证选取bteq工具测试。登录服务器后，输入bteq3) 显示“Teradata BTEQ 14.00.00.02 for LINUX”，输入.logon dbc/dwarc4) 输入密码，提示“Logon successfully completed.”即表示Teradata安装成功。4.2. DBI&DBD验证1) 创建testdbd.pl，内容如下：use DBI;my $tdpname=dbccop1;my $username=username; #此处请修改为实际用户名my $password=password; #此处请修改为实际用户密码my $dbh = DBI-connect(dbi:Teradata:$tdpname,$username,$password, AutoCommit = 1, PrintError = 0, RaiseError = 0 ) ;die cannt connect database $! unless(define($dbh);my $sql=SELECT USER;my $sth=$dbh-prepare($sql);unless($sth)print ERROR - Unable to prepare statement for $sqln;exit 1;my $ret=$sth-execute();unless($ret)print ERROR - Unable to prepare statement for $sqln;exit 1;while( my record=$sth-fetchrow() )print REC