欢迎来到天天文库
浏览记录
ID:48878265
大小:121.50 KB
页数:10页
时间:2020-02-04
《Datastage__配置操作步骤.doc》由会员上传分享,免费在线阅读,更多相关内容在行业资料-天天文库。
1、ETL安装配置指南1部署软件环境DB服务器:22.4.8.7DB客户端:22.4.8.10,22.4.8.11,22.4.8.12,22.4.8.13DataStage主服务器:22.4.8.11DataStage备份服务器:22.4.8.13DataStage节点:22.5.8.10,22.5.8.122创建用户为每台机器创建dstage组和dsadm用户Ø运行smit命令,启动管理界面Ø在安装机器上创建dstage组设置ADMINISTRATIVEUSER选项为true设置GID设为300Ø创建用户dsadm设置主属为dstage,设置ADMINISTRATIVEUSER选项为tr
2、ue;设置UID设为300;设置PrimaryGROUP,GroupSET,ADMINISTRATIVEGROUPS:均为dstage;设置SoftFILEsize[-1](无限制)设置HardFILEsize[-1](无限制)3修改系统参数调整每台机器的最大进程数查看用户进程最大数目:lsattr-Elsys0
3、grepmaxuproc第10页共10页ETL安装配置指南如:修改用户进程最大数目:注意:要调整每个Datastage节点的最大进程数用root用户登陆,键入即可。chdev-lsys0-amaxuproc=40961DataStage安装1.1上传DataStage介质到服
4、务器上将介质拷贝到终端上,然后ftp到22.4.8.11和22.4.8.13上,将介质放在/Ascential.media目录下,并赋上所有权限:chmod-R777/Ascential.media1.2安装DataStage1.2.1进入/Ascential.media,运行sh./install.sh–admindsadm,中间安装过程请参考上线文档,在安装过程中创建工程ETL_ODS.1.2.2配置dsadm用户.profile环境变量,增加如下内容22.4.8.11:#ThefollowingthreelineshavebeenaddedbyIBMDB2instanceutil
5、ities.if[-f/home/db2inst1/sqllib/db2profile];then./home/db2inst1/sqllib/db2profilefi#dsenvexportETLPLUS_HOME=/home/dsadmexportDSHOME=/home/dsadm/Ascential/DataStage/DSEngineexportAPT_ORCHHOME=/home/dsadm/Ascential/DataStage/PXEngineexportDB2HOME=/home/db2inst1/sqllibexportPATH=$PATH:$DSHOME/bin:
6、$DB2HOME/include:/home/dsadm/Ascential/DataStage/PXEngine.753.1/libexport第10页共10页ETL安装配置指南LIBPATH=$LIBPATH:$DSHOME/lib:$APT_ORCHHOME/lib:/home/dsadm/Ascential/DataStage/PXEngine.753.1/lib.$DSHOME/dsenv22.4.8.13:#ThefollowingthreelineshavebeenaddedbyIBMDB2instanceutilities.if[-f/home/db2inst1/sql
7、lib/db2profile];then./home/db2inst1/sqllib/db2profilefi#dsenvexportETLPLUS_HOME=/home/dsadmexportDSHOME=/home/dsadm/Ascential/DataStage/DSEngineexportAPT_ORCHHOME=/home/dsadm/Ascential/DataStage/PXEngineexportDB2HOME=/home/db2inst1/sqllibexportPATH=$PATH:$DSHOME/bin:$DB2HOME/include:/home/dsadm/
8、Ascential/DataStage/PXEngine.753.1/libexportLIBPATH=$LIBPATH:$DSHOME/lib:$APT_ORCHHOME/lib:/home/dsadm/Ascential/DataStage/PXEngine.753.1/lib.$DSHOME/dsenv22.4.8.10:exportDSHOME=/home/dsadm/Ascential/DataStage/DSEngineexport
此文档下载收益归作者所有