Datastage 配置操作步骤
- 格式:doc
- 大小:127.00 KB
- 文档页数:8
1部署软件环境
DB服务器:22.4.8.7
DB客户端:22.4.8.10,22.4.8.11,22.4.8.12,22.4.8.13
DataStage主服务器:22.4.8.11
DataStage备份服务器:22.4.8.13
DataStage节点:22.5.8.10,22.5.8.12
2创建用户
为每台机器创建dstage组和dsadm用户
➢运行smit命令,启动管理界面
➢在安装机器上创建dstage组
设置ADMINISTRATIVE USER 选项为true
设置GID设为300
➢创建用户dsadm
设置主属为dstage,
设置ADMINISTRATIVE USER 选项为true;
设置UID设为300;
设置Primary GROUP,Group SET,ADMINISTRATIVE GROUPS:均为dstage;
设置Soft FILE size [-1] (无限制)
设置Hard FILE size [-1] (无限制)
3修改系统参数
调整每台机器的最大进程数
查看用户进程最大数目:
lsattr -El sys0|grep maxuproc
如:
修改用户进程最大数目:
注意:要调整每个Datastage节点的最大进程数
用root用户登陆,键入即可。
chdev -l sys0 -a maxuproc=4096
4 DataStage安装
4.1上传DataStage介质到服务器上
将介质拷贝到终端上,然后ftp到22.4.8.11和22.4.8.13上,将介质放在/Ascential.media 目录下,并赋上所有权限:chmod -R 777 /Ascential.media
4.2安装DataStage
4.2.1进入/Ascential.media,运行sh ./install.sh –admin dsadm,中间安装过程请参考
上线文档,在安装过程中创建工程ETL_ODS.
4.2.2配置dsadm用户.profile环境变量,增加如下内容
22.4.8.11:
# The following three lines have been added by IBM DB2 instance utilities.
if [ -f /home/db2inst1/sqllib/db2profile ]; then
. /home/db2inst1/sqllib/db2profile
fi
#ds env
export ETLPLUS_HOME=/home/dsadm
export DSHOME=/home/dsadm/Ascential/DataStage/DSEngine
export APT_ORCHHOME=/home/dsadm/Ascential/DataStage/PXEngine
export DB2HOME=/home/db2inst1/sqllib
export
PATH=$PATH:$DSHOME/bin:$DB2HOME/include:/home/dsadm/Ascential/DataStage/ PXEngine.753.1/lib
export
LIBPATH=$LIBPATH:$DSHOME/lib:$APT_ORCHHOME/lib:/home/dsadm/Ascential/Dat aStage/PXEngine.753.1/lib
. $DSHOME/dsenv
22.4.8.13:
# The following three lines have been added by IBM DB2 instance utilities.
if [ -f /home/db2inst1/sqllib/db2profile ]; then
. /home/db2inst1/sqllib/db2profile
fi
#ds env
export ETLPLUS_HOME=/home/dsadm
export DSHOME=/home/dsadm/Ascential/DataStage/DSEngine
export APT_ORCHHOME=/home/dsadm/Ascential/DataStage/PXEngine
export DB2HOME=/home/db2inst1/sqllib
export
PATH=$PATH:$DSHOME/bin:$DB2HOME/include:/home/dsadm/Ascential/DataStage/ PXEngine.753.1/lib
export
LIBPATH=$LIBPATH:$DSHOME/lib:$APT_ORCHHOME/lib:/home/dsadm/Ascential/Dat aStage/PXEngine.753.1/lib
. $DSHOME/dsenv
22.4.8.10:
export DSHOME=/home/dsadm/Ascential/DataStage/DSEngine
export APT_ORCHHOME=/home/dsadm/Ascential/DataStage/PXEngine
export DB2DIR=/opt/IBM/db2/V9.5
export DB2INSTANCE=db2inst1