DataStage8.7安装文档
【BI安装】Datastage_V8.1.0_for_Rhel5.4_64bit安装文档

Information Server8.1.0安装文档目录Information Server8.1.0安装文档 (1)备注说明: (1)安装前系统要求: (2)1)WAS安装包需求: (2)2)Infomation Server安装包需求: (3)3)Linux内核参数最低需求 (3)4)HP-UX内核参数最底要求 (4)5)产品和必须安装这些产品的层。
(4)安装步骤: (5)一、系统环境: (5)二、修改内核参数,安装必要必定包: (6)三、安装WAS和两个升级补丁包 (6)1)安装WAS (6)2)将WAS升级到6.0.2.0版本 (10)3)将WAS升级到6.0.2.7版本 (12)四、安装Information Server (18)参数配置: (29)1.配置dsenv文件 (29)2.配置ODBC参数 (30)3.配置DS编译器变量 (32)4.配置dsadm用户的.bash_profile文件 (32)IIS服务启动和停止: (32)1.服务停止 (32)3.服务启动 (33)备注说明:1.要在Linux®和UNIX®上复用现有的DB2安装,必须使用DB2故障监视组件(需要在/etc/inittab文件中输入故障监视器(db2fmcd)的路径)。
db2fmcd命令必须指向实际的可执行文件位置,例如:fmc:234:respawn:/u1/IBM/db2/V9/bin/db2fmcd#DB2Fault Monitor Coordinator2.需要的C++编译器和运行时库:对于64位HP-UX11i v2on Intel Itaium 6.16acc:HP C/aC++B3910B A.06.1432位和64位Red Hat Enterprise Linux5Advanced Platform GCC 4.1.2对于HP-UX11.x和10.x,用下面的命令确定版本:what/opt/CC/bin/CC3.WAS官网安装文档:/infocenter/wasinfo/v6r0/index.jspInfoServ文档:/infocenter/iisinfsv/v8r1/index.jsp?topic=/com.ibm.swg.im.iis.productization.iisinfsv.relinfo.doc/topics/iisihrinfo_infsv_rnote_v81ga.html各种指南:/support/docview.wss?rs=14&uid=swg27013660DB2官方文档:/infocenter/db2luw/v9r5/index.jsp?topic=/com.ibm.db2.luw.qb.se rver.doc/doc/t0006477.html结构拓扑图:安装前系统要求:1)WAS安装包需求:compat-libstdc++-33-3.2.3-61compat-db-4.2.52-5.1libXp-1.0.0-8rpm-build-4.4.2-37.el52)Infomation Server安装包需求:compat-db-4.2.52-5.1compat-libstdc++-33-3.2.3-61 elfutils-0.125-3.el5elfutils-libs-0.125-3.el5glibc-2.5-24libaio-0.3.105-2libgcc-4.1.2-42.el5libstdc++-4.1.2-42.el5libXmu-1.0.2-5libXt-1.0.2-3.1.fc6libX11-1.0.3-9.el5libXtst-1.0.1-3.1libXp-1.0.0-8.1libXext-1.0.1-2.1libSM-1.0.1-3.1libICE-1.0.1-2.1libXau-1.0.1-3.1libXdmcp-1.0.1-2.1pam-0.99.6.2-3.26.el53)Linux内核参数最低需求4)HP-UX内核参数最底要求5)产品和必须安装这些产品的层。
Red hat Enterprise Linux 5.5(64bit)操作系统下Datastage 8.1安装操作指南

Linux(64bit)操作系统下Datastage安装操作指南1.目的本流程旨在规范DataStage在Linux5(64bit)系列操作系统上的安装流程。
2.适用范围本文档适用于在所有操作系统为REDHAT LINUX 5 的DELL R系列PC Server服务器上安装DataStage8.1。
2.1.安装Linux的注意事项2.1.1.检查相关服务关闭防火墙和禁用SEliunx (此安全部件如果不禁用,会导致某些连接无法访问),也可以在安装完后找到/etc/SeLiunx/下config文件(如果在安装中禁用了,则没有这个文件夹):修改成SELINUX=disable 禁用SeLinux修改成SELINUX=enforcing 使用SeLinux防火墙开启和关闭:重启后生效开启:chkconfig iptables on关闭:chkconfig iptables off即时生效,重启后失效开启:service iptables start关闭:service iptables stop2.1.2.软件包是否安装齐全用rpm -qa | grep +文件名命令检查附:所有必须安装装软件包。
如果没有安装全建议配置yum源Yum数据源的创建编辑vi /etc/yum.repos.d/rhel-debuginfo.repo如下:[server]name=Red Hat Enterprise Linux $releasever - $basearch - Debugbaseurl=file:///media/Serverenabled=1gpgcheck=1gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-redhat-release进行yum测试测试yum源是否安装成功用yum数据源安装以下数据包:yum install compat*yum install elfutils*yum install glibc*yum install lib*yum install pam*图1 32位操作系统图2 64位操作系统2.1.3.创建安装目录#mkdir DSSetup,将DataStageSvr_v8.1_RHEL.tar.gz,updater.jar,BOClic_1.xml,patch,四个文件拷入/root/DSSetup , 将DataStageSvr_v8.1_RHEL.tar.gz解压之后得文件夹,is-ia-suite。
Datastage8.5安装手册with_Oracle_repository

Datastage8.5安装⼿册with_Oracle_repository ⽬录1.概述 (1)1.1⽬的 (1)1.2适⽤范围 (1)2.安装环境 (1)2.1软件环境 (1)2.2硬件环境 (1)2.3安装软硬件需求 (2)2.3.1操作系统 (2)2.3.2操作系统内核参数 (2)2.3.3依赖动态链接库 (2)2.3.4内存 (3)2.3.5硬盘 (3)2.3.6知识库 (3)3.安装步骤 (3)3.1创建知识库 (3)3.1.1获取知识库创建脚本 (4)3.1.2获取知识库创建脚本 (4)3.2C++编译器安装 (4)3.3D A TASTAGE S ERVER安装 (4)3.3.1介质上传及解压 (4)3.3.2启动安装程序 (4)3.3.3使⽤浏览器登陆安装界⾯ (5)3.3.4安装前浏览信息 (5)3.3.5软件许可协议 (6)3.3.6防⽕墙检查 (7)3.3.7早期安装需求检查 (8)3.3.8指定Information Server安装⽬录 (9)3.3.10选择安装软件 (11)3.3.11选择要安装的产品 (12)3.3.12选择要安装的版本 (15)3.3.13集群配置 (15)3.3.14安装Websphere Application Server (17)3.3.15指定Websphere Application Server⽬录 (17)3.3.16为Websphere Application Server分配监听端⼝ (18) 3.3.17Websphere Application Server管理员配置 (19) 3.3.18Infomation Server管理员配置 (21)3.3.19Datastage知识库选择 (21)3.3.20配置Datastage知识库连接 (22)3.3.21Infomation Server代理端⼝配置 (23)3.3.22配置Datastage管理员 (25)3.3.23Infomation Server作业监听端⼝配置 (27)3.3.24Infomation Server多实例设置 (28)3.3.25DS全球化⽀持 (29)3.3.26MQ插件选择 (30)3.3.27SAS组件配置 (31)3.3.28安装过程是否创建⼯程 (32)3.3.29Information Analyzer分析数据库连接配置 (33)3.3.30软件安装软硬件需求检测 (34)3.3.31安装过程相应⽂件 (34)3.3.32安装前摘要 (36)3.3.33开始安装 (36)3.3.34安装完成 (38)3.4D A TASTAGE C LIENT安装 (38)4.DATASTAGE配置 (38)4.1D A TASTAGE S ERVER配置 (38)4.1.2DS系统环境设置 (43)4.2D A TASTAGE C LIENT配置 (43)5.卸载 (44)6.数据库连接访问配置 (45)6.1O RACLE连接配置 (45)6.1.1Oracle客户端安装 (45)6.1.2Datastage⽤户组设置 (47)6.1.3Datastage⽤户环境配置 (47)6.1.4重启服务使得配置⽣效 (47)6.1.5Oracle⽤户权限设置 (49)7.ODBC配置 (50)7.1DSENV配置 (51)7.2ODBC.INI配置 (51)7.3修改UVODBC.CONFIG (52)8.安装验证 (53)8.1基本作业验证 (53)8.2编译器是否正常 (55)8.3O RACLE CONNECTOR验证 (57)9.注意事项 (57)1.概述1.1⽬的本⽂档旨在描述Datastage8.5在Redhat EE 64bit Server5.9安装执⾏步骤,以及注意事项。
DataStage客户端安装及使用文档

DataStage 客户端安装及使用文档1.客户端安装1.1 安装步骤解压客户端文件client_IA-suite.rar,完成后,进入目录,client_IA-suite,运行install.exe,会提示如下:选择英语,点击确定,安装时,最好关闭防火墙,选择要安装客户端的位置,点击NEXT:选择要安装的组件,点击NEXT:选择安装模式,点击NEXT:点击INSTALL后,开始安装:点击FINISH,安装完成。
安装完成后,在本机的HOSTS文件中需要配置一下:目录:C:\Windows\System32\drivers\etc在最后一行添加如下:# localhost name resolution is handled within DNS itself.# 127.0.0.1 localhost# ::1 localhost17.83.26.110(IP地址为服务器地址)ETL110(这个名字可以自己取)1.2 DataStage Client组件安装完成后有如下组件:1.Administrator Client用于创建DataStage 用户,创建,移动项目,设置清除标准的用户界面。
2.Director Client用来验证,计划时间,运行,监控DataStage 作业的用户界面。
3.Designer Client用来创建DataStage 应用(或作业)的设计接口。
每个作业都指定数据源,所需的转换和数据的目的地。
作业被编译成可执行的,由Director 计划,由Server 运行(主机作业被转移,在主机上运行)。
4.Datastage Manager用于存储和管理JOB 的元数据,使之可以在DataStage Designer 中再度被使用,包括库表定义、集中的转换程序等,并对工程备份和恢复。
2.组件使用2.1Administrator Client2.1.1登陆界面ETL110为刚刚我们在HOSTS中配置的名字,端口一般都是9080输入DOMAIN和账号密码完成后,点击DATASTAGE SERVER 右边的小三角,这时DATASTAGE会去验证用户名密码,成功后,会出来下拉框,这时证明已经联通了,选中一个SERVER,点击OK即可登陆2.1.2设置参数登陆成功后,界面如下:General页签:Projects页签:点击工程属性按钮后,显示界面如下:General 页签:Protect Projec t :设置项目为protected, 如果一个项目已经是protected,则按钮就显示为“Unprotect Project”Auto-purge of job log:每个Job 都对应一个log 文件,Job 的每一次运行都会产生新的log 附加到log 文件中,如果不及时清除无用的log,将会占用大量的空间,同时还会影响Job 的运行效率。
DataStage 8.1 for windows 2003安装文档

IBM Information Server(DataStage)安装注:抱歉现在不能上传图片,CSDN啥时候才能传图片呢一、安装条件——系统需求.二、安装步骤.1. 安装文件说明:.2. 安装步骤说明:.a)安装DB2用于元数据管理.b)安装WebSphere Application Server用于发布.c)配置IBM Information Server服务管理员.d)添加Datastage项目.e) Information Analyzer数据库.f) DB2服务信息.g) DB2实例信息.3. 安装过程步骤图例:.三、各组件功能介绍.1. IBM Information Server 控制台.2. IBMInformation Server Web 控制台.3. Introduction to IBM Information Server FastTrack4. Multi-Client Manager5. Designer客户机.6. Administrator or客户机.7. Director客户机.四、添加用户、组及凭证.1. 登陆IBMInformation Server Web 控制台.2. 添加管理用户和组.3. 配置凭证.五、配置对Oracle数据库的访问.1. 配置环境变量.2. 安装install.liborchoracle六、 DataStage Designer客户端的登录.1. 登陆DataStage Designer客户端.2. 说明.一、安装条件——系统需求Server: Windows Server 2003 Service Pack 2Client: Windows XP Service Pack 2, Windows Vista, Windows Server 2003 Service Pack 2其它安装先决条件请参考:/infocenter/iisinfsv/v8r1/index.jsp?topic=/com.ibm.swg.im.iis.pr oductization.iisinfsv.migrate.doc/topics/switchingclients.html二、安装步骤1. 安装文件说明:服务端安装程序:InfoSvr_v8.1_WinSvr2003.zip客户端安装程序:InfoSvr_Client_v8.1_Win.zipLicense:infos-license.xml2. 安装步骤说明:解压InfoSvr_v8.1_WinSvr2003.zip,执行install.exe。
datastage入门教程

DATASTAGE总结一、安装datastageA、安装服务端安装虚拟机(注册码在文件中)---解压datastage安装包redhat3__Datastage----点击解压文件中Red Hat Enterprise Linux 3---安装---在虚拟机启动---查看虚拟机IP地址,在dos窗口验证是否可以连接---打开secureCRT,连接虚拟机---进入/app/oracle/product/10.2/network/admin/tnsnames.ora中---按E键,再按i 进入编辑状态---将IP地址设为本机Ip地址,数据库实例名自己设置---按ESC、W、Q、:键退出---完成B、安装客户端解压datastage客户端安装包Datastageclient---点击解压文件datastage7.5.3\datastage client---安装---注册码在datastage7.5.1下载地址及license中----完成二、DATASTAGE主键1、transforme r(oracle----transformer---file)数据源oracle设置properties\source\readmethod=auto-generated sqlproperties\source\table=要导入的表名点击connection,出现remote server=数据库实例名,user=Scott,password=tigerColumns下将length设置合适---load---oracleI9--选定导入的表名---ok注意:若不知道导入表的格式Columns下将length设置合适---load---import---plug-in meda data definitions---oracleI9--ok---数据库实例名,用户名、密码---ok--选择Scott用户下---选表--- 导入Transformer设置:将需要显示的字段拖拽过去---ok目标文件file设置:properties下file--填入保存路径first line is columns name=trueFomat下点击record level 添加record delimiter 属性为UNIX newline点击field defaults 添加 null field value 属性为0 Quote=noneColumns下将length设置合适----ok以下主键数据源或目标文件为oracle/file的设置同上transformer的设置方法2、转存(file---transformer---file)Transformer设置:将需要显示的字段拖拽过去---ok3、导入(file---transformer---oracle)Transformer设置:将需要显示的字段拖拽过去---ok4、copy(file--copy--多file):一个输入,多个输出Copy设置:stage当只有一个输入及一个输出时最好将Force设置为TrueOutput下将需要显示的字段拖拽过去---ok5、filter(file--filter---多file):只有一个输入,可以有多个输出Filter设置:stage下properties\where clause=过滤条件--点击whereclause出现output link=slink值(在link orderingzhong看对应值) Output下将需要显示的字段拖拽过去---ok6、join(多oracle---join---file):多表连接Join设置:stage下properties\join keys\key=关联字段,options\join type=连接类型(内、全、左、右连接)Output下将需要显示的字段拖拽过去---ok7、look up(多oracle---look up--file):数据的查询Look up设置:将关联字段连接,再将需要显示的字段拖拽过去8、merge(多file---merge---file):相同数据的合并Merge设置:stage下properties\merge keys\key=字段,sort order=排序Options下unmatched masters mode=保留/删除Output下将需要显示的字段拖拽过去---ok9、funnel(多file---funnel---file):数据的合并Funnel设置:stage下properties\options\funnel type=选择合并方式Output下将需要显示的字段拖拽过去---ok10、aggregator(oracle---aggregator---file):数据的分类、汇总Aggregator设置:stage下properties\grouping keys\group=分组字段点击aggregations\aggregation type出现column for calculation=聚合字段及合方式,可以取最大值,最小值, Sum值,count值等多种聚合方式。
Datastage 安装后启动was失败

按照安装教程安装虚拟机版的datastage 8.7后,使用命令启动was失败[plain]view plain copysrvr:~ # /opt/IBM/WebSphere/AppServer/bin/startServer.sh server12.ADMU0116I: Tool information is being logged in file3. /opt/IBM/WebSphere/AppServer/profiles/InfoSphere/logs/server1/startServer.log4.ADMU0128I: Starting tool with the InfoSphere profile5.ADMU3100I: Reading configuration for server: server16.ADMU3200I: Server launched. Waiting for initialization status.7.ADMU3011E: Server launched but failed initialization. startServer.log,8. SystemOut.log(or job log in zOS) and other log files under9. /opt/IBM/WebSphere/AppServer/profiles/InfoSphere/logs/server1 should10. contain failure information.按照提示查看报错日志:[html]view plain copysrvr:/opt/IBM/WebSphere/AppServer/profiles/InfoSphere/logs/server1 # tail -100 SystemErr.log2. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)3. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)4. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)5. at ng.reflect.Method.invoke(Method.java:611)6. at uncher.Main.invokeFramework(Main.java:340)7. at uncher.Main.basicRun(Main.java:282)8. at uncher.Main.run(Main.java:981)9. at unchEclipse(WSPreLauncher.java:340)10. at com.ibm.wsspi.bootstrap.WSPreLauncher.main(WSPreLauncher.java:110)11.Caused by:.ascential.xmeta.repository.core.CoreRepositoryException: Error initializing persistence manager module13. at com.ascential.xmeta.repository.core.impl.DefaultSandbox.<init>(DefaultSandbox.java:70)14. at ng.J9VMInternals.newInstanceImpl(Native Method)15. at ng.Class.newInstance(Class.java:1345)16. at com.ascential.xmeta.repository.core.CoreRepositoryFactory.createSandbox(CoreRepositoryFactory.java:97)17. at com.ascential.xmeta.service.repository.core.SandboxPojoBusiness.<init>(SandboxPojoBusiness.java:61)18. ... 70 more19.Caused by:.ascential.xmeta.persistence.PersistenceManagerException: com.ascential.xmeta.persistence.PersistenceException: PersistentEObjectPersistenceException initializing persistence.21. at com.ascential.xmeta.persistence.impl.basic.BasicPersistenceManager.initialize(BasicPersistenceManager.java:78)22. at com.ascential.xmeta.repository.core.impl.DefaultSandbox.<init>(DefaultSandbox.java:68)23. ... 74 more24.Caused by:.ascential.xmeta.persistence.PersistenceException: PersistentEObjectPersistenceException initializing persistence.26. at com.ascential.xmeta.persistence.impl.basic.BasicPersistence.initialize(BasicPersistence.java:462)27. at com.ascential.xmeta.persistence.impl.basic.BasicPersistenceManager.initialize(BasicPersistenceManager.java:74)28. ... 75 more29.Caused by:.ascential.xmeta.persistence.orm.PersistentEObjectPersistenceException: org.apache.ojb.broker.PersistenceBrokerException: Can't lookup a connection 31. at com.ascential.xmeta.persistence.orm.impl.ojb.OjbPersistentEObjectPersistenceRegistry.loadPackageCache(OjbPersistentEObjectPersistenceRegistry .java:446)32. at com.ascential.xmeta.persistence.orm.impl.ojb.OjbPersistentEObjectPersistenceRegistry.initialize(OjbPersistentEObjectPersistenceRegistry.java: 134)33. at com.ascential.xmeta.persistence.orm.impl.ojb.OjbPersistentEObjectPersistence.initialize(OjbPersistentEObjectPersistence.java:372)34. at com.ascential.xmeta.persistence.impl.basic.BasicPersistence.initialize(BasicPersistence.java:451)35. ... 76 more36.Caused by:.apache.ojb.broker.PersistenceBrokerException: Can't lookup a connection38. at org.apache.ojb.broker.accesslayer.ConnectionManagerImpl.localBegin(Unknown Source)39. at org.apache.ojb.broker.core.PersistenceBrokerImpl.beginTransaction(Unknown Source)40. at org.apache.ojb.broker.core.DelegatingPersistenceBroker.beginTransaction(Unknown Source)41. at org.apache.ojb.broker.core.DelegatingPersistenceBroker.beginTransaction(Unknown Source)42. at com.ascential.xmeta.persistence.orm.impl.ojb.OjbPersistentEObjectPersistenceRegistry.loadPackageCache(OjbPersistentEObjectPersistenceRegistry .java:437)43. ... 79 more44.Caused by:.apache.ojb.broker.accesslayer.LookupException: Could not borrow connection from pool. Active/Idle instances in pool=0/0. org.apache.ojb.broker.metad ata.JdbcConnectionDescriptor: org.apache.ojb.broker.metadata.JdbcConnection Descriptor@59a959a9[46.jcd-alias=pojo47.default-connection=false48.dbms=Db249.jdbc-level=2.050.driver=com.ibm.db2.jcc.DB2Driver51.protocol=jdbc52.sub-protocol=db253.db-alias=//:50000/xmetaer=xmeta55.password=*****56.eager-release=false57.ConnectionPoolDescriptor={whenExhaustedAction=0, maxIdle=-1, maxActive=21,maxWait=5000, removeAbandoned=false, numTestsPerEvictionRun=10, minEvictabl eIdleTimeMillis=600000, testWhileIdle=false, testOnReturn=false, logAbandone d=false, minIdle=0, fetchSize=0, removeAbandonedTimeout=300, timeBetweenEvic tionRunsMillis=-1, testOnBorrow=true}58.batchMode=trueeAutoCommit=AUTO_COMMIT_SET_FALSE60.ignoreAutoCommitExceptions=false61.sequenceDescriptor=<null>62.]63. at org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl.checkOutJdbcConnection(Unknown Source)64. at org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.lookupConnection(Unknown Source)65. at org.apache.ojb.broker.accesslayer.ConnectionManagerImpl.getConnection(Unknown Source)66. ... 84 more67.Caused by:.apache.ojb.broker.accesslayer.LookupException: Error getting Connectionfrom DriverManager with url (jdbc:db2://:50000/xm eta) and driver (com.ibm.db2.jcc.DB2Driver)69. at org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.newConnectionFromDriverManager(Unknown Source)70. at org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl$ConPoolFactory.makeObject(Unknown Source)71. at mons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:771)72. ... 87 more73.Caused by:.ibm.db2.jcc.am.oo: [jcc][t4][2043][11550][3.58.135] Exception .ConnectException: Error opening socket to server / 127.0.0.2 on port 50,000 with message: Connection refused. ERRORCODE=-4499, SQLSTATE=0800175. at com.ibm.db2.jcc.am.ed.a(ed.java:319)76. at com.ibm.db2.jcc.am.ed.a(ed.java:337)77. at com.ibm.db2.jcc.t4.zb.a(zb.java:400)78. at com.ibm.db2.jcc.t4.zb.<init>(zb.java:78)79. at com.ibm.db2.jcc.t4.a.y(a.java:309)80. at com.ibm.db2.jcc.t4.b.a(b.java:1806)81. at com.ibm.db2.jcc.am.jb.a(jb.java:578)82. at com.ibm.db2.jcc.am.jb.<init>(jb.java:529)83. at com.ibm.db2.jcc.t4.b.<init>(b.java:308)84. at com.ibm.db2.jcc.DB2SimpleDataSource.getConnection(DB2SimpleDataSource.java:214)85. at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:456)86. at java.sql.DriverManager.getConnection(DriverManager.java:322)87. at java.sql.DriverManager.getConnection(DriverManager.java:297)88. ... 90 more89.Caused by:.ConnectException: Connection refused91. at .PlainSocketImpl.socketConnect(Native Method)92. at .PlainSocketImpl.doConnect(PlainSocketImpl.java:383)93. at .PlainSocketImpl.connectToAddress(PlainSocketImpl.java:245)94. at .PlainSocketImpl.connect(PlainSocketImpl.java:232)95. at .SocksSocketImpl.connect(SocksSocketImpl.java:377)96. at .Socket.connect(Socket.java:539)97. at com.ibm.db2.jcc.t4.ab.run(ab.java:34)98. at java.security.AccessController.doPrivileged(AccessController.java:251)99. at com.ibm.db2.jcc.t4.zb.a(zb.java:386)100. ... 100 more----[html]view plain copysrvr:/opt/IBM/WebSphere/AppServer/profiles/InfoSphere/logs/server1 # tail -50 SystemOut.log2. at com.ibm.ws.security.core.SecurityComponentImpl.startSecurity(SecurityComponentImpl.java:109)3. at com.ibm.ws.security.core.ServerSecurityComponentImpl.start(ServerSecurityComponentImpl.java:341)4. ... 33 more5.Caused by: com.ibm.websphere.security.WSSecurityException: Failed to get roles for user [server:infosrvrNode01Cell_infosrvrNode01_server1]: Unable to be gin a transaction: [Error opening repository: []]6. at com.ibm.ws.security.auth.ContextManagerImpl.getServerSubjectInternal(ContextManagerImpl.java:2609)7. at com.ibm.ws.security.auth.ContextManagerImpl.getServerSubjectInternal(ContextManagerImpl.java:2254)8. at com.ibm.ws.security.auth.ContextManagerImpl.initialize(ContextManagerImpl.java:2891)9. ... 39 more10.Caused by: com.ibm.websphere.security.auth.WSLoginFailedException: Failed toget roles for user [server:infosrvrNode01Cell_infosrvrNode01_server1]: Unab le to begin a transaction: [Error opening repository: []]11. at com.ibm.ws.security.auth.JaasLoginHelper.jaas_login(JaasLoginHelper.java:371)12. at com.ibm.ws.security.auth.JaasLoginHelper.jaas_login(JaasLoginHelper.java:395)13. at com.ibm.ws.security.auth.ContextManagerImpl.login(ContextManagerImpl.java:3671)14. at com.ibm.ws.security.auth.ContextManagerImpl.login(ContextManagerImpl.java:3541)15. at com.ibm.ws.security.auth.ContextManagerImpl.getServerSubjectInternal(ContextManagerImpl.java:2558)16. ... 41 more17.Caused by: javax.security.auth.login.FailedLoginException: Failed to get roles for user [server:infosrvrNode01Cell_infosrvrNode01_server1]: Unable to be gin a transaction: [Error opening repository: []]18. at mit(ISFAuthenticationProvider.java:318)19. at mit(WASCustomLoginModule.java:396)20. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)21. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)22. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)23. at ng.reflect.Method.invoke(Method.java:611)24. at javax.security.auth.login.LoginContext.invoke(LoginContext.java:795)25. at javax.security.auth.login.LoginContext.access$000(LoginContext.java:209)26. at javax.security.auth.login.LoginContext$4.run(LoginContext.java:709)27. at java.security.AccessController.doPrivileged(AccessController.java:251)28. at javax.security.auth.login.LoginContext.invokePriv(LoginContext.java:706)29. at javax.security.auth.login.LoginContext.login(LoginContext.java:604)30. at com.ibm.ws.security.auth.JaasLoginHelper.jaas_login(JaasLoginHelper.java:354)31. ... 45 more32.Caused by: com.ascential.acs.security.repository.ASBRepositoryException: Unable to begin a transaction: [Error opening repository: []]33. at com.ascential.acs.security.repository.ASBRepositoryImpl.begin(ASBRepositoryImpl.java:158)34. at com.ascential.acs.security.directory.ASBDirectoryImpl.getRepository(ASBDirectoryImpl.java:88)35. at com.ascential.acs.security.directory.ASBDirectoryImpl.getUserRoles(ASBDirectoryImpl.java:315)36. at com.ascential.acs.security.directory.ASBDirectory.getUserRoles(ASBDirectory.java:146)37. at mit(ISFAuthenticationProvider.java:309)38. ... 57 more39.Caused by: com.ascential.acs.security.repository.ASBRepositoryException: Error opening repository: []40. at com.ascential.acs.security.repository.ASBRepositoryImpl.getSandbox(ASBRepositoryImpl.java:701)41. at com.ascential.acs.security.repository.ASBRepositoryImpl.begin(ASBRepositoryImpl.java:156)42. ... 61 more43.44.[3/4/14 16:22:37:930 CST] 00000000 SchedulerServ I SCHD0040I: The Scheduler Service is stopping.45.[3/4/14 16:22:38:005 CST] 00000000 SchedulerServ I SCHD0002I: The Scheduler Service has stopped.46.[3/4/14 16:22:38:075 CST] 00000000 AppProfileCom I ACIN0009I: The application profiling service is stopping.47.[3/4/14 16:22:38:147 CST] 00000000 ActivitySessi I WACS0049I: The ActivitySession service is stopping.48.[3/4/14 16:22:38:213 CST] 00000000 ObjectPoolSer I OBPL0011I: The Object Pool service is stopping.49.[3/4/14 16:22:38:331 CST] 00000000 distSecurityC I securityServiceStartedis false50.[3/4/14 16:22:38:518 CST] 00000000 CGBridgeSubsc I CWRCB0104I: The core group bridge service has stopped the subscription router.51.[3/4/14 16:22:38:591 CST] 00000000 CGBridgeServi I CWRCB0103I: The core group bridge service has stopped.-----[html]view plain copysrvr:/opt/IBM/WebSphere/AppServer/profiles/InfoSphere/logs/server1 # tail -100 startServer.log2.[5/1/12 9:23:17:120 PDT] 00000000 ManagerAdmin I TRAS0017I: The startup trace state is *=info.3.[5/1/12 9:23:17:718 PDT] 00000000 AdminTool A ADMU0128I: Starting toolwith the InfoSphere profile4.[5/1/12 9:23:17:721 PDT] 00000000 AdminTool A ADMU3100I: Reading configuration for server: server15.[5/1/12 9:23:18:449 PDT] 00000000 AdminTool A ADMU3200I: Server launched. Waiting for initialization status.6.[5/1/12 9:25:03:060 PDT] 00000000 AdminTool A ADMU3000I: Server server1 open for e-business; process id is 76737.************ Start Display Current Environment ************8.Host Operating System is Linux, version 2.6.32.12-0.7-pae9.Java version = JRE 1.6.0 IBM J9 2.4 Linux x86-32 jvmxi3260sr9-20110216_75791(JIT enabled, AOT enabled)10.J9VM - 20110216_07579111.JIT - r9_20101028_17488ifx412.GC - 20101027_AA, Java Compiler = j9jit24, Java VM name = IBM J9 VM13.was.install.root = /opt/IBM/WebSphere/AppServerer.install.root = /opt/IBM/WebSphere/AppServer/profiles/InfoSphere15.Java Home = /opt/IBM/WebSphere/AppServer/java/jre16.ws.ext.dirs = /opt/IBM/WebSphere/AppServer/java/lib:/opt/IBM/WebSphere/AppServer/classes:/opt/IBM/WebSphere/AppServer/lib:/opt/IBM/WebSphere/AppServer/i nstalledChannels:/opt/IBM/WebSphere/AppServer/lib/ext:/opt/IBM/WebSphere/App Server/web/help:/opt/IBM/WebSphere/AppServer/deploytool/itp/plugins/com.ibm.etools.ejbdeploy/runtime17.Classpath = /opt/IBM/WebSphere/AppServer/profiles/InfoSphere/properties:/opt/IBM/WebSphere/AppServer/properties:/opt/IBM/WebSphere/AppServer/lib/startup .jar:/opt/IBM/WebSphere/AppServer/lib/bootstrap.jar:/opt/IBM/WebSphere/AppSe rver/lib/lmproxy.jar:/opt/IBM/WebSphere/AppServer/lib/urlprotocols.jar:/opt/ IBM/WebSphere/AppServer/java/lib/tools.jar18.Java Library path = /opt/IBM/WebSphere/AppServer/java/jre/lib/i386:/opt/IBM/WebSphere/AppServer/bin::/usr/lib19.Current trace specification = *=info20.************* End Display Current Environment *************21.[3/3/14 11:38:55:871 CST] 00000000 ManagerAdmin I TRAS0017I: The startuptrace state is *=info.22.[3/3/14 11:38:56:380 CST] 00000000 AdminTool A ADMU0128I: Starting tool with the InfoSphere profile23.[3/3/14 11:38:56:393 CST] 00000000 AdminTool A ADMU3100I: Reading configuration for server: server124.[3/3/14 11:38:57:579 CST] 00000000 AdminTool A ADMU3200I: Server launched. Waiting for initialization status.25.[3/3/14 11:41:30:374 CST] 00000000 AdminTool A ADMU3000I: Server server1 open for e-business; process id is 657526.************ Start Display Current Environment ************27.Host Operating System is Linux, version 2.6.32.12-0.7-pae28.Java version = JRE 1.6.0 IBM J9 2.4 Linux x86-32 jvmxi3260sr9-20110216_75791(JIT enabled, AOT enabled)29.J9VM - 20110216_07579130.JIT - r9_20101028_17488ifx431.GC - 20101027_AA, Java Compiler = j9jit24, Java VM name = IBM J9 VM32.was.install.root = /opt/IBM/WebSphere/AppServerer.install.root = /opt/IBM/WebSphere/AppServer/profiles/InfoSphere34.Java Home = /opt/IBM/WebSphere/AppServer/java/jre35.ws.ext.dirs = /opt/IBM/WebSphere/AppServer/java/lib:/opt/IBM/WebSphere/AppServer/classes:/opt/IBM/WebSphere/AppServer/lib:/opt/IBM/WebSphere/AppServer/i nstalledChannels:/opt/IBM/WebSphere/AppServer/lib/ext:/opt/IBM/WebSphere/App Server/web/help:/opt/IBM/WebSphere/AppServer/deploytool/itp/plugins/com.ibm.etools.ejbdeploy/runtime36.Classpath = /opt/IBM/WebSphere/AppServer/profiles/InfoSphere/properties:/opt/IBM/WebSphere/AppServer/properties:/opt/IBM/WebSphere/AppServer/lib/startup.jar:/opt/IBM/WebSphere/AppServer/lib/bootstrap.jar:/opt/IBM/WebSphere/AppSe rver/lib/lmproxy.jar:/opt/IBM/WebSphere/AppServer/lib/urlprotocols.jar:/opt/ IBM/WebSphere/AppServer/java/lib/tools.jar37.Java Library path = /opt/IBM/WebSphere/AppServer/java/jre/lib/i386:/opt/IBM/WebSphere/AppServer/bin::/usr/lib38.Current trace specification = *=info39.************* End Display Current Environment *************40.[3/3/14 15:32:11:681 CST] 00000000 ManagerAdmin I TRAS0017I: The startuptrace state is *=info.41.[3/3/14 15:32:12:120 CST] 00000000 AdminTool A ADMU0128I: Starting tool with the InfoSphere profile42.[3/3/14 15:32:12:127 CST] 00000000 AdminTool A ADMU3100I: Reading configuration for server: server143.[3/3/14 15:32:13:601 CST] 00000000 AdminTool A ADMU3200I: Server launched. Waiting for initialization status.44.[3/3/14 15:34:18:689 CST] 00000000 AdminTool A ADMU3011E: Server launched but failed initialization. startServer.log, SystemOut.log(or job log in zOS) and other log files under /opt/IBM/WebSphere/AppServer/profiles/InfoSph ere/logs/server1 should contain failure information.45.************ Start Display Current Environment ************46.Host Operating System is Linux, version 2.6.32.12-0.7-pae47.Java version = JRE 1.6.0 IBM J9 2.4 Linux x86-32 jvmxi3260sr9-20110216_75791(JIT enabled, AOT enabled)48.J9VM - 20110216_07579149.JIT - r9_20101028_17488ifx450.GC - 20101027_AA, Java Compiler = j9jit24, Java VM name = IBM J9 VM51.was.install.root = /opt/IBM/WebSphere/AppServerer.install.root = /opt/IBM/WebSphere/AppServer/profiles/InfoSphere53.Java Home = /opt/IBM/WebSphere/AppServer/java/jre54.ws.ext.dirs = /opt/IBM/WebSphere/AppServer/java/lib:/opt/IBM/WebSphere/AppServer/classes:/opt/IBM/WebSphere/AppServer/lib:/opt/IBM/WebSphere/AppServer/i nstalledChannels:/opt/IBM/WebSphere/AppServer/lib/ext:/opt/IBM/WebSphere/App Server/web/help:/opt/IBM/WebSphere/AppServer/deploytool/itp/plugins/com.ibm.etools.ejbdeploy/runtime55.Classpath = /opt/IBM/WebSphere/AppServer/profiles/InfoSphere/properties:/opt/IBM/WebSphere/AppServer/properties:/opt/IBM/WebSphere/AppServer/lib/startup .jar:/opt/IBM/WebSphere/AppServer/lib/bootstrap.jar:/opt/IBM/WebSphere/AppSe rver/lib/lmproxy.jar:/opt/IBM/WebSphere/AppServer/lib/urlprotocols.jar:/opt/ IBM/WebSphere/AppServer/java/lib/tools.jar56.Java Library path = /opt/IBM/WebSphere/AppServer/java/jre/lib/i386:/opt/IBM/WebSphere/AppServer/bin::/usr/lib57.Current trace specification = *=info58.************* End Display Current Environment *************59.[3/3/14 15:47:09:303 CST] 00000000 ManagerAdmin I TRAS0017I: The startuptrace state is *=info.60.[3/3/14 15:47:09:548 CST] 00000000 AdminTool A ADMU0128I: Starting tool with the InfoSphere profile61.[3/3/14 15:47:09:557 CST] 00000000 AdminTool A ADMU3100I: Reading configuration for server: server162.[3/3/14 15:47:10:234 CST] 00000000 AdminTool A ADMU3200I: Server launched. Waiting for initialization status.63.[3/3/14 15:47:50:008 CST] 00000000 AdminTool A ADMU3011E: Server launched but failed initialization. startServer.log, SystemOut.log(or job log in zOS) and other log files under /opt/IBM/WebSphere/AppServer/profiles/InfoSph ere/logs/server1 should contain failure information.64.************ Start Display Current Environment ************65.Host Operating System is Linux, version 2.6.32.12-0.7-pae66.Java version = JRE 1.6.0 IBM J9 2.4 Linux x86-32 jvmxi3260sr9-20110216_75791(JIT enabled, AOT enabled)67.J9VM - 20110216_07579168.JIT - r9_20101028_17488ifx469.GC - 20101027_AA, Java Compiler = j9jit24, Java VM name = IBM J9 VM70.was.install.root = /opt/IBM/WebSphere/AppServerer.install.root = /opt/IBM/WebSphere/AppServer/profiles/InfoSphere72.Java Home = /opt/IBM/WebSphere/AppServer/java/jre73.ws.ext.dirs = /opt/IBM/WebSphere/AppServer/java/lib:/opt/IBM/WebSphere/AppServer/classes:/opt/IBM/WebSphere/AppServer/lib:/opt/IBM/WebSphere/AppServer/i nstalledChannels:/opt/IBM/WebSphere/AppServer/lib/ext:/opt/IBM/WebSphere/App Server/web/help:/opt/IBM/WebSphere/AppServer/deploytool/itp/plugins/com.ibm.etools.ejbdeploy/runtime74.Classpath = /opt/IBM/WebSphere/AppServer/profiles/InfoSphere/properties:/opt/IBM/WebSphere/AppServer/properties:/opt/IBM/WebSphere/AppServer/lib/startup .jar:/opt/IBM/WebSphere/AppServer/lib/bootstrap.jar:/opt/IBM/WebSphere/AppSe rver/lib/lmproxy.jar:/opt/IBM/WebSphere/AppServer/lib/urlprotocols.jar:/opt/ IBM/WebSphere/AppServer/java/lib/tools.jar75.Java Library path = /opt/IBM/WebSphere/AppServer/java/jre/lib/i386:/opt/IBM/WebSphere/AppServer/bin::/usr/lib76.Current trace specification = *=info77.************* End Display Current Environment *************78.[3/4/14 16:14:38:413 CST] 00000000 ManagerAdmin I TRAS0017I: The startuptrace state is *=info.79.[3/4/14 16:14:38:771 CST] 00000000 AdminTool A ADMU0128I: Starting tool with the InfoSphere profile80.[3/4/14 16:14:38:782 CST] 00000000 AdminTool A ADMU3100I: Reading configuration for server: server181.[3/4/14 16:14:39:593 CST] 00000000 AdminTool A ADMU3200I: Server launched. Waiting for initialization status.82.[3/4/14 16:15:43:331 CST] 00000000 AdminTool A ADMU3011E: Server launched but failed initialization. startServer.log, SystemOut.log(or job log in zOS) and other log files under /opt/IBM/WebSphere/AppServer/profiles/InfoSph ere/logs/server1 should contain failure information.83.************ Start Display Current Environment ************84.Host Operating System is Linux, version 2.6.32.12-0.7-pae85.Java version = JRE 1.6.0 IBM J9 2.4 Linux x86-32 jvmxi3260sr9-20110216_75791(JIT enabled, AOT enabled)86.J9VM - 20110216_07579187.JIT - r9_20101028_17488ifx488.GC - 20101027_AA, Java Compiler = j9jit24, Java VM name = IBM J9 VM89.was.install.root = /opt/IBM/WebSphere/AppServerer.install.root = /opt/IBM/WebSphere/AppServer/profiles/InfoSphere91.Java Home = /opt/IBM/WebSphere/AppServer/java/jre92.ws.ext.dirs = /opt/IBM/WebSphere/AppServer/java/lib:/opt/IBM/WebSphere/AppServer/classes:/opt/IBM/WebSphere/AppServer/lib:/opt/IBM/WebSphere/AppServer/i nstalledChannels:/opt/IBM/WebSphere/AppServer/lib/ext:/opt/IBM/WebSphere/App Server/web/help:/opt/IBM/WebSphere/AppServer/deploytool/itp/plugins/com.ibm.etools.ejbdeploy/runtime93.Classpath = /opt/IBM/WebSphere/AppServer/profiles/InfoSphere/properties:/opt/IBM/WebSphere/AppServer/properties:/opt/IBM/WebSphere/AppServer/lib/startup .jar:/opt/IBM/WebSphere/AppServer/lib/bootstrap.jar:/opt/IBM/WebSphere/AppSe rver/lib/lmproxy.jar:/opt/IBM/WebSphere/AppServer/lib/urlprotocols.jar:/opt/ IBM/WebSphere/AppServer/java/lib/tools.jar94.Java Library path = /opt/IBM/WebSphere/AppServer/java/jre/lib/i386:/opt/IBM/WebSphere/AppServer/bin::/usr/lib95.Current trace specification = *=info96.************* End Display Current Environment *************97.[3/4/14 16:21:47:087 CST] 00000000 ManagerAdmin I TRAS0017I: The startuptrace state is *=info.98.[3/4/14 16:21:47:380 CST] 00000000 AdminTool A ADMU0128I: Starting tool with the InfoSphere profile99.[3/4/14 16:21:47:392 CST] 00000000 AdminTool A ADMU3100I: Reading configuration for server: server1100.[3/4/14 16:21:48:019 CST] 00000000 AdminTool A ADMU3200I: Server laun ched. Waiting for initialization status.101.[3/4/14 16:22:43:337 CST] 00000000 AdminTool A ADMU3011E: Server laun ched but failed initialization. startServer.log, SystemOut.log(or job log in zOS) and other log files under /opt/IBM/WebSphere/AppServer/profiles/InfoSp here/logs/server1 should contain failure information.102.103.以上为三个日志文件的打印。
datastage综合使用参考手册

Ascential DataStage Enterprise Edition 综合使用参考手册目录目录 (I)1. 引言 (1)1.1.编写目的 (1)1.2.帮助使用 (1)2. 产品概述 (2)2.1.A DVANCED D EVELOPMENT AND M AINTENANCE (2)2.2.C OMPLETE D EVELOPMENT E NVIRONMENT (3)2.3.H IGHLY S CALABLE A RCHITECTURE (6)2.4.E ND-TO-E ND E NTERPRISE M ETA D ATA (7)3. 安装 (8)3.1.S ERVER安装 (8)3.1.1. Server安装前准备 (8)3.1.2. Server安装步骤 (9)3.1.3. 验证DataStage的安装 (22)3.1.4. Server启动和停止 (23)3.2.C LIENT安装 (24)4. 常规应用 (24)4.1.常用组件使用方法 (24)4.1.1. Sequential file (24)4.1.2. Annotation (27)4.1.3. Change Capture Stage (29)4.1.4. Copy Stage (31)4.1.5. Filter Stage (32)4.1.6. Funnel Stage (33)4.1.7. Tansformer Stage (34)4.1.8. Sort Stage (35)4.1.9. LookUp Stage (36)4.1.10. Join Stage (36)4.1.11. LookUp Stage 和Join Stage的区别 (38)4.1.12. Merge Stage (38)4.1.13. Modify Stage (39)4.1.14. Data Set Stage (40)4.1.15. File Set Stage (41)4.1.16. Lookup File Set Stage (43)4.1.17. Oracle Enterprise Stage (45)4.1.18. Aggregator Stage (46)4.1.19. Remove Duplicates Stage (48)4.1.20. Compress Stage (49)4.1.21. Expand Stage (50)4.1.22. Difference Stage (51)4.1.23. Compare Stage (53)4.1.24. Switch Stage (54)4.1.25. Column Import Stage (55)4.1.26. Column Export Stage (57)4.2.常用数据库的连接 (59)4.2.1. Informix数据库连接 (59)4.2.2. Oracle数据库连接 (60)5. 高级应用 (62)5.1.D ATA S TAGE BASIC接口 (62)5.2.自定义S TAGE T YPE (62)5.2.1. Wrapped Stage (62)5.2.2. Build Stage (67)5.2.3. Custom Stage (75)5.3.性能调优 (75)5.3.1. 优化策略 (75)5.3.2. 关键问题分析 (79)5.3.3. 并行度 (80)5.3.4. 处理建议 (80)5.3.5. 其它 (80)5.3.6. 机器的对称性 (81)5.3.7. 并行调度测试说明: (81)6. 开发经验技巧汇总 (82)6.1.1. 问题 (82)1.引言1.1.编写目的IBM DataStage作为项目主要使用的ETL开发工具,在项目中得到了比较充分的应用,对IBM DataStage产品方方面面的功能,都有所涉及。
- 1、下载文档前请自行甄别文档内容的完整性,平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益,请联系客服反馈,我们会尽快为您处理(人工客服工作时间:9:00-18:30)。
DataStage 8.7安装文档官方参考:/infocenter/iisinfsv/v8r7/index.jsp?topic=%2Fcom.ibm.swg.im.iis.producti zation.iisinfsv.install.doc%2Ftopics%2Fwsisinst_topinstall.html1.安装前配置操作系统:Redhat Enterprise Linux 6.2 64位注:由于是在Linux下安装DataStage,最好熟悉基本的linux命令的使用。
1、需要安装以下rpm包,32位和64位都需要。
glibc-2.12-1.47libXp-1.0.0-15.1libXau-1.0.5-1libXext-1.1-3libX11-1.3-2libxcb-1.5-1nss-softokn-freebl-3.12.9-11libXmu-1.0.5-1libXtst-1.0.99.2-3libXft-2.1.13-4.1freetype-2.3.11-6fontconfig-2.8.0-3libgcc-4.4.6-3libstdc++-4.4.6-3.compat-libstdc++-33-3.2.3-692、关闭防火墙关闭:service iptables stop查看状态:service iptables status3、禁用selinux编辑/etc/selinux/config文件,修改SELINUX=disabled,修改后需要重启操作系统。
查看状态:sestatus4、创建用户groupadd -g 502 daspgrpgroupadd -g 503 db2fgrpgroupadd -g 504 db2igrpgroupadd -g 505 dstgrpuseradd -d /home/dasusr1 -m -g 502 -u 701 dasusr1useradd -d /home/db2fenc1 -m -g 503 -u 702 db2fenc1useradd -d /home/db2inst1 -m -g 504 -u 703 db2inst1useradd -d /home/dsadm -m -g 505 -u 704 dsadm2.服务器安装安装步骤如下:DataStage 8.7的安装介质为InfoSvr_v8.7_Linux64.tar.gz,解压后得到目录is-suite。
进入此目录,把license 包解压到此目录下,在is-suite下执行./setup,安装程序将启动一个Web服务,URL为http://机器IP:8080/ISInstall在浏览器(IE 或者Fixforx)中打开上述URL,例如,待安装的服务器IP为192.168.5.170,则在浏览器栏输入http://192.168.5.170:8080/ISInstall。
缺省安装界面语言为英文(English),也可以选择中文。
本文档以英文为安装语言。
进入安装界面后,第一个界面选择Next按钮。
第二个界面如下图所示选择接受License协议(I accept the terms in the license agreement),然后下一步(Next)。
第三个界面直接下一步(Next)第四步安装程序将进行第一次系统检查,检查是否符合安装需求。
如果都正常,则下一步(Next),否则根据检查结果对系统进行配置调整。
第五步选择安装目标目录,缺省目录为/opt/IBM/InformationServer,一般使用缺省目录,然后下一步(Next)第六步选择新安装(Net installation),然后下一步(Next)第七步选择安装组件,对于服务器安装,选择Metadata repository, Services, Engine.如下图所示。
然后下一步(Next)。
第八步选择产品的语言,缺省为英文(English),推荐使用缺省语言英文。
然后选择安装的产品– IBM InfoSphere DataStage,根据需要可以多选其他产品。
第九步,选择安装的版本,企业版选择IBM InfoSphere DataStage即可。
然后下一步(Next) 第十步,保留缺省设置直接下一步(Next),如果要做集群配置参考专门文档。
第十一步,安装应用服务器,干净环境使用Install WebSphere Application Server. 不建议在服务器上混装其他WebSphere应用。
然后下一步(Next)第十二步,选择WebSphere Application Server安装目录,缺省为/opt/IBM/Websphere/AppServer. 保留缺省值直接下一步(next).第十三步,保留缺省的WebSphere WAS应用服务器端口设置,直接下一步(Next)。
创建WAS管理员用户口令,例如WAS管理员用户名为:wasadmin,密码按照项目要求设置。
提示端口占用,查看没有占用的进程,重试好。
可以采用以下解决方案:1. 查看正在占用的端口:netstat -a|grep dsrp2. 查看使用端口的进程/usr/sbin/lsof -i | grep 4507(使用端口号)3. 杀掉该进程kill -9 进程号创建Information Server管理员用户口令,例如管理员用户名为:isadmin,密码按照项目要求设置。
选择全新安装DB2企业版作为Information Server的资料库选择DB2的安装目录,缺省为/opt/IBM/db2/V9,保留缺省设置,然后下一步(Next)创建DB2实例用户和口令,例如用户名为:db2inst1,密码按照项目要求设置。
所属组db2iadm1,用户目录为/home/db2inst1,端口50001。
然后下一步(Next)系统提示创建用户成功,点击OK确认进入下一步创建DB2守护用户和口令,例如用户名为:db2fenc1,密码按照项目要求设置。
所属组db2fadm1,用户目录为/home/ db2fenc1。
然后下一步(Next)(Fenced用户:主要负责用户自定义函数(user defined function)和存储过程(stored precedure)。
创建这个用户的好处是,当一个自定义函数发生内存泄漏的问题,至多影响到这些自定义函数和存储过程。
而影响不到整个数据库管理系统。
所以,如果你的系统有很多自定义函数或者存储过程的话,最好创建一个跟实例名不是同名的。
这里创建一个名叫db2fenc1的用户。
)系统提示创建用户成功,点击OK确认进入下一步创建DB2守护用户和口令,例如用户名为:dasusr1,密码按照项目要求设置。
所属组dasadm1,用户目录为/home/ dasusr1。
然后下一步(Next)系统提示创建用户成功,点击OK确认进入下一步创建Information Server资料库数据库用户和口令,例如用户名为:xmeta,密码按照项目要求设置。
数据库名xmeta,数据库所属实例db2inst1,数据库路径/opt/IBM/InformationServer/Repos/xmeta。
然后下一步(Next)系统提示创建用户成功,点击OK确认进入下一步。
创建Information Server STAGE区设置,例如用户名为:xmetasr,密码按照项目要求设置。
数据库名xmeta,数据库所属实例db2inst1,数据库路径/opt/IBM/InformationServer/Repos/xmeta。
然后下一步(Next)系统提示创建用户成功,点击OK确认进入下一步保持缺省agent port设置直接下一步(Next)创建DataStage管理用户和口令,例如用户名为:dsadm,密码按照项目要求设置。
所属组dstage,用户目录为/home/ dsadm。
然后下一步(Next)系统提示创建用户成功,点击OK确认进入下一步。
保持缺省TCP/IP port设置直接下一步(Next)直接下一步(Next)保持缺省设置,直接下一步(Next)保持缺省设置,直接下一步(Next)安装程序进行第一次系统详细检查,大约10分钟左右,如果有不符合要求的,需要修改系统例如安装相应rpm包。
对于警告(warning),勾选Ingore “WARNING” items and continue,然后下一步(Next)保持缺省设置,直接下一步(Next)保持缺省设置,直接下一步(Next)然后正式开始进入安装程序,大约2个小时完成服务器的安装。
安装成功后,在浏览器中打开http://192.168.5.170:9080/ibm/iis/console,进入Information Server管理控制台。
输入Information Server管理员用户口令,例如isadmin 登录到管理界面选择Administration(管理)展开Domain Management(域管理)选择服务器,然后点击Open User Credentials。
在Map User Credentials栏,选择Browse。
选择用户,例如isadmin将Information Server的用户isadmin影射到操作系统的用户,例如dsadm,输入操作系统的用户和密码。
成功后如下图所示。
3.客户端安装DataStage客户端的安装介质为InfoSvr_Client_v8.7_Win,解压后得到目录is-client. 运行is-client目录下的setup,安装程序启动Web服务URL。
在浏览器(IE 或者Firefox)中打开上一步提供的URL,进入安装网页,缺省安装语言为英文,推荐使用缺省英文。
选择Login,进入安装程序。
选择接受条款I accept the terms in the agreement. 然后下一步(Next)然后直接下一步(Next)安装程序进行第一次系统检查,都Passed后选择下一步(Next),否则根据提示对系统进行调整。
选择DataStage客户端安装目录,缺省为C:\IBM\InformationServer,保持缺省或者改为其他目录然后下一步(Next)选择安装类型,全新安装(New Installation),然后下一步(Next)选择安装产品– IBM InfoSphere DataStage,然后下一步(Next)。
安装程序进行第二次系统检查,大约10分钟,都通过后下一步(Next)直接下一步(Next)然后开始正式安装,大约需要半个小时左右。
安装完成后,需要进行客户端配置,在Windows的Hosts文件中添加服务器的机器名和IP 地址,如下所示:然后打开Designer,在Hosts name of the services tier栏输入DataStage的服务器地址和端口(缺省9080),然后在user name和password栏输入在Information Server管理控制台上创建配置好的用户密码,例如isadmin,然后点击Project的下拉框,DataStage的Designer客户端将检索并列出服务器的Project列表,大约一分钟左右,选择目标项目,例如缺省创建的dstage,然后点击Login进入开发界面。