ITeye博客

ecap平台安装手册

microjava · 2012-03-21 12:20 · ECAP相关 · Web前端 · Markdown

1,ecapudb用户设置环境变量

if ; then . /home/db2inst1/sqllib/db2profile fi

生效:. .profile

2,从江门UAT取出建库脚本 db2look -d ecapudb -e -u ecapudb -o create_ecapudb.sql

3,ecapudb建库 db2 create db ecapudb on /home/db2inst1 alias ecapudb using codeset GBK territory zh_cn

4,ecapudb目录下建data目录 mkdir data chmod 777 data (确保上级目录有权限)

//db2 grant dbadm on database to user ecapudb

5,建表空间 db2 connect to ecapudb db2 create BUFFERPOOL IBMIFCSBP1 size 400000 db2 create BUFFERPOOL IBMIFCSBP2 size 400000 pagesize 8k db2 "CREATE TABLESPACE ECAP3_DATA MANAGED BY DATABASE using (FILE '/home/ecapudb/data/ecap3_data' 1000m) BUFFERPOOL IBMIFCSBP1" db2 "CREATE TABLESPACE ECAP3_INDEX MANAGED BY DATABASE using (FILE '/home/ecapudb/data/ecap3_index' 1000m) BUFFERPOOL IBMIFCSBP1" db2 "CREATE TABLESPACE ECAP4_DATA PAGESIZE 8k MANAGED BY DATABASE using (FILE '/home/ecapudb/data/ecap4_data' 6400m) BUFFERPOOL IBMIFCSBP2" db2 "CREATE TABLESPACE ECAP4_INDEX PAGESIZE 8k MANAGED BY DATABASE using (FILE '/home/ecapudb/data/ecap4_index' 1000m) BUFFERPOOL IBMIFCSBP2"

6,建表 db2 -tvf create_ecapudb.sql

7,导数据 从江门的/home/ecapudb/temp/data取回初始数据 db2 -tvf import.sql

-----以下ecapuat用户----- 8,修改ecapuat用户的.profile 从江门把.profile拷回(可以先拷成另一个文件名再传回) myprofile.txt

9,把bin目录与lib目录打包取回并解压(可取惠州的) tar cvf bin.tar bin tar cvf lib.tar lib ftp tar xvf bin.tar tar xvf lib.tar

10,运行ln.sh(修改后的)

----以下进入控制台处理,各地市控制台端口稍有不同,用户都是wasadmin----- 11,建J2C认证数据 ecapudb

安全性--全局安全性--Java认证和授权服务--J2C认证数据

ECAPDS ecapudb ecapudb

12,JDBC提供程序配置

资源--jdbc--jdbc提供程序 删除原有的

新建

作用域: cells:qygmdevCell02:nodes:qygmdevNode02:servers:server1 数据库类型: db2 提供程序类型: DB2 Universal JDBC Driver Provider 实现类型: 连接池数据源

下一步 -- 完成

13,数据源配置

资源--jdbc--数据源 新建

作用域:cells:qygmdevCell02:nodes:qygmdevNode02:servers:server1
数据源名:ECAPDS jndi名称:ECAPDS 选择现有的jdbc提供程序:DB2 Universal JDBC Driver Provider 驱动类型:4 数据库名:ecapudb 服务器名称:96.0.42.32 (清远) 端口号:50000

选择 组件管理的认证别名

测试连接(目前还没有驱动)

14,websphere变量设置

环境--websphere变量

DB2UNIVERSAL_JDBC_DRIVER_PATH : /home/ecapuat/lib

DB2_JDBC_DRIVER_PATH : /home/ecapuat/lib

15,共享类库设置

环境--共享库

DB2Driver: /home/ecapuat/lib/db2jcc.jar /home/ecapuat/lib/db2jcc_license_cu.jar

ECAPLIB:

/home/ecapuat/wasECAP/WEB-INF/classes/ /home/ecapuat/lib/ejb/commons-logging.jar /home/ecapuat/lib/ejb/concurrent.jar /home/ecapuat/lib/ejb/ejb3-persistence.jar /home/ecapuat/lib/ejb/hibernate-annotations.jar /home/ecapuat/lib/ejb/hibernate-client.jar /home/ecapuat/lib/ejb/javassist.jar /home/ecapuat/lib/ejb/jboss-annotations-ejb3.jar /home/ecapuat/lib/ejb/jboss-aop-jdk50-client.jar /home/ecapuat/lib/ejb/jboss-aspect-jdk50-client.jar /home/ecapuat/lib/ejb/jboss-client.jar /home/ecapuat/lib/ejb/jboss-common-client.jar /home/ecapuat/lib/ejb/jboss-ejb3-client.jar /home/ecapuat/lib/ejb/jboss-ejb3x.jar /home/ecapuat/lib/ejb/jboss-j2ee.jar /home/ecapuat/lib/ejb/jboss-jaxws.jar /home/ecapuat/lib/ejb/jboss-remoting.jar /home/ecapuat/lib/ejb/jbosssx-client.jar /home/ecapuat/lib/ejb/jboss-transaction-client.jar /home/ecapuat/lib/ejb/jbossws-client.jar /home/ecapuat/lib/ejb/jnp-client.jar /home/ecapuat/lib/ejb/trove.jar /home/ecapuat/lib/ejb/xmlsec.jar /home/ecapuat/lib/struts/commons-beanutils.jar /home/ecapuat/lib/struts/commons-collections.jar /home/ecapuat/lib/struts/commons-digester.jar /home/ecapuat/lib/struts/commons-fileupload.jar /home/ecapuat/lib/struts/commons-lang.jar /home/ecapuat/lib/struts/commons-logging.jar /home/ecapuat/lib/struts/commons-platform.jar /home/ecapuat/lib/struts/commons-validator.jar /home/ecapuat/lib/struts/struts.jar /home/ecapuat/lib/xml/dom4j.jar /home/ecapuat/lib/xml/jdom.jar /home/ecapuat/lib/xml/jaxen-1.1-beta-6.jar /home/ecapuat/lib/chart/jcommon-1.0.13.jar /home/ecapuat/lib/chart/jfreechart-1.0.10.jar /home/ecapuat/lib/jboss/scheduler-plugin.jar /home/ecapuat/lib/log/log4j-1.2.15.jar /home/ecapuat/lib/servlet/servlet-api.jar /home/ecapuat/lib/bsh/bsh.jar /home/ecapuat/lib/ftp/FTPTransfer.jar /home/ecapuat/lib/ecap.jar /home/ecapuat/lib/tranlog.jar /home/ecapuat/lib/jxl/jxl.jar /home/ecapuat/lib/commons-httpclient.jar

respool:

/home/ecapuat/lib/respool.jar

16,建立成员服务器(惠州此步不用,其他地市看情况)

17,修改JVM堆栈参数 企业应用程序 > 进程定义 > Java 虚拟机 修改类路径及初始堆大小、最大堆大小、通用 JVM 参数

应用程序服务器 > mem1 > java和进程管理 -- 进程定义 > Java 虚拟机

类路径 /home/ecapuat/lib/jdk_enc.jar:/home/ecapuat/lib/unionapi.jar:/home/ecapuat/lib/xml/dom4j.jar:/home/ecapuat/lib/xml/jdom.jar:/home/ecapuat/lib/xml/jaxen-1.1-beta-6.jar

初始堆大小 2048 最大堆大小 4096

调试参数 -agentlib:jdwp=transport=dt_socket,server=y,suspend=n,address=7777

通用的jvm参数 -Xgcpolicy:gencon

18,部署应用 先卸载DefaultApplication

安装 wasECAP.war 应用程序--WebSphere企业应用程序

删除缺省的程序

19,ecapuat目录下建temp目录,从江门拷入此目录内容 按步骤安装应用

20,设置共享库引用

21,文件链接 ln -s /usr/IBM/WebSphere/AppServer/profiles/AppSrv02/installedApps/ssgmdev1Cell02/wasECAP_war.ear/wasECAP.war /home/ecapuat/wasECAP/ ln -s /usr/IBM/WebSphere/AppServer/profiles/AppSrv02/logs /home/ecapuat/waslog/

ln s /home/ecapuat/report /home/ecapuat/wasECAP/report

复制 cp -r /home/ecap/ecapworkdir/etc/ /home/ecapuat/ecapworkdir/etc/

  1. 后台启动FServer 在$ECAPWORKDIR下面创建 print目录 在主目录中/home/ecap/bin 下面有启动FServer的shell命令 fsvr.sh 命令为 : nohup fsvr.sh &

22,配置部署 a)把生产环境的20W配置及模板文件拷入

注意数据库的IIOP端口

23,导入UAT柜员与机构

24,补充t_menu表及t_child_busi_tran表信息

export to teller.txt.0313 of del select * from t_teller import from teller.txt.0313 of del insert into t_teller

export to t_brhm.txt.0316 of del select * from t_brhm import from t_brhm.txt.0316 of del insert into t_brhm

export to t_menu.txt.0313 of del select * from t_menu import from t_menu.txt.0313 of del insert into t_menu

export to t_child_busi_tran.txt.0315 of del select * from t_child_busi_tran import from t_child_busi_tran.txt.0315 of del insert into t_child_busi_tran

export to t_teller_busi.txt.0316 of del select * from t_teller_busi import from t_teller_busi.txt.0316 of del insert into t_teller_busi

delete from t_child_busi_tran delete from t_teller_busi delete from t_brhm

select * from t_teller_busi

describe table t_child_busi_tran select TELLER_BUSI_NO from t_child_busi_tran order by TELLER_BUSI_NO

stop.sh start.sh

tail -f 日志文件

评论(0)

暂无评论。

评论功能维护中,当前仅展示历史评论。