ecap平台安装手册

1,ecapudb用户设置环境变量

if [ -f /home/db2inst1/sqllib/db2profile ]; 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/


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


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

注意数据库的IIOP端口

<DBCon Name="ECAPDS"
Desc="ecapudb"
DefaultCon="Yes"
ConnType="DataSource"
DBType="DB2"
DBUser="ecapudb"
DBPasswd="41474554514046"
DriverName="ecapudb"
URL="iiop://127.0.0.1:2813">
   </DBCon>
</DBConTab>



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 日志文件