# This script may also be sourced by bourne shells to establish # proper environment settings for local DataStage use. #

#################################################################### # PLATFORM SPECIFIC SECTION set +u

if [ -z \then

DSHOME=`cat /.dshome` export DSHOME fi

if [ -z \then

DSHOME=/app/dsadm/Ascential/DataStage/DSEngine; export DSHOME fi

if [ -z \then

APT_ORCHHOME=/app/dsadm/Ascential/DataStage/PXEngine; export APT_ORCHHOME fi

if [ -z \then

UDTHOME=/app/dsadm/Ascential/DataStage/ud41; export UDTHOME UDTBIN=/app/dsadm/Ascential/DataStage/ud41/bin; export UDTBIN fi

if [ -n \then

ODBCINI=$DSHOME/.odbc.ini; export ODBCINI HOME=${HOME:-/}; export HOME

#LANG=\

#LC_ALL=\#LC_CTYPE=\#LC_COLLATE=\#LC_MONETARY=\#LC_NUMERIC=\#LC_TIME=\

#LC_MESSAGES=\

LD_LIBRARY_PATH=`dirname

$DSHOME`/branded_odbc/lib:$DSHOME/lib:$DSHOME/uvdlls:$DSHOME/java/jre/lib/i386/client:$DSHOME/java/jre/lib/i386:$LD_LIBRARY_PATH export LD_LIBRARY_PATH fi

export ORACLE_BASE=/app/oracle

export ORACLE_HOME=/app/oracle/product/10.2

export TNS_ADMIN=/app/oracle/product/10.2/network/admin export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib export PATH=$PATH:$ORACLE_HOME/bin export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK

export LIBPATH=$ORACLE_HOME/rdbms/lib:$ORACLE_HOME/lib:$LIBPATH (2)编辑dsadm用户.bash_profile文件,我的该文件内容: # .bash_profile

# Get the aliases and functions if [ -f ~/.bashrc ]; then . ~/.bashrc fi

# User specific environment and startup programs PATH=$PATH:$HOME/bin export PATH

export DSHOME=/app/dsadm/Ascential/DataStage/DSEngine

. $DSHOME/dsenv

PATH=$PATH:$DSHOME/bin:$APT_ORCHHOME/bin:$DSHOME/lib:$DSHOME/branded_odcdbc/lib:$ORACLE_HOME/bin export PATH

export NLS_LANG=American_America.ZHS16GBK

alias 'l=ls -l' set -o vi unset USERNAME

这两个文件照着我的配就OK了,当中的相关目录(ds和oracle)得修改为你的安装目录. 执行动态链接库脚本

/app/dsadm/Ascential/DataStage/PXEngine/install/install.liborchoracle 出现Oracle Installation is complete才算安装成功. 在LIBPATH部分增加路径$ORACLE_HOME/lib

配置好后,进入对应目录使这两个文件立即生效 source dsenv source .bash_profile 重启DS uv -admin -stop uv -admin -start

在客户端新建JOB进行测试,下面的是我的测试JOB

oracle和DS是在同一台服务器上,DS使用oracle时候要对以下视图赋权限 DBA_DATA_FILES DBA_TAB_PARTITONS DBA_OBJECTS ALL_PART_INDEXES ALL_PART_TABLES ALL_INDEXES

SYS.GV_$INSTANCE (Only if Oracle Parallel Server is used) datastage自带的联机帮助文档上有说明这一点,

We suggest that you create a role that has the appropriate SELECT privileges, as follows: CREATE ROLE DSXE;

GRANT SELECT on sys.dba_extents to DSXE; GRANT SELECT on sys.dba_data_files to DSXE; GRANT SELECT on sys.dba_tab_partitions to DSXE; GRANT SELECT on sys.dba_objects to DSXE; GRANT SELECT on sys.all_part_indexes to DSXE; GRANT SELECT on sys.all_part_tables to DSXE; GRANT SELECT on sys.all_indexes to DSXE;

Once the role is created, grant it to users who will run DataStage jobs, as follows: GRANT DSXE to ; 到此位置datastage的安装基本结束。

6.

注意事项：

Datastage安装应该确认安装的机器是32位或64位，在安装出错，安装后安装路径下的文件不全，可能是install.sh的错误。安装正确则主目录/home/ap/dsadm/Ascential/DataStage/下存在一下文件目录 Configurations DSCAPIOp DSEngine DSParallel Datasets Datasets_bak Logfiles MsgHandlers PXEngine PXEngine.752.1 PXEngine.752.2 Plugins.ini Projects Scratch Scratch_bak Template Template.ini branded_odbc

Datastage 的服务端安装在安装前应尽可能确认数据库安装正确，且和datastage服务端机器是联通的。

一般datastage 服务端作为单独机器，若连接数据库为oracle，应该在安装前在机器上安装oracle客户端（参见oracle客户端安装文档），oracle 客户端安装应该以管理员模式安装，这样为了确保oracle工具安装全面，特别是sqlload可用。 Datastage工程创建后需要修改相应的参数，特别是要修改下面参数 APT_STRING_PADCHAR 0x20