Teradata1401安裝文檔(Linux).docx

Teradata1401安裝文檔（Linux）1. 環(huán)境說明操作系統(tǒng)：Red Hat Enterprise Linux Server release 6.4 (Santiago)IP地址：128.64.108.146數(shù)據(jù)庫IP：128.192.145.228/128.192.145.229/128.192.145.2302. 環(huán)境準(zhǔn)備2.1. 登錄使用root登錄128.64.108.1462.2. 上傳安裝介質(zhì)假定介質(zhì)存放目錄為/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相關(guān)包后，再按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如果是重裝，會(huì)出現(xiàn)如下提示，按y即可。Do you want to reinstall the package? y/n (default:n) : y3.3. 安裝DBI（如程序中未使用DBI方式連接TD數(shù)據(jù)庫可不安裝）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. 驗(yàn)證4.1. Teradata驗(yàn)證1) 配置/etc/hosts，添加Teradata數(shù)據(jù)源配置2) Teradata驗(yàn)證選取bteq工具測試。登錄服務(wù)器后，輸入bteq3) 顯示“Teradata BTEQ 14.00.00.02 for LINUX”，輸入.logon dbc/dwarc4) 輸入密碼，提示“Logon successfully completed.”即表示Teradata安裝成功。4.2. DBI&DBD驗(yàn)證1) 創(chuàng)建testdbd.pl，內(nèi)容如下：use DBI;my $tdpname=dbccop1;my $username=username; #此處請(qǐng)修改為實(shí)際用戶名my $password=password; #此處請(qǐng)修改為實(shí)際用戶密碼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