ecap平台安装手册
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/
- 后台启动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 日志文件