Portal与db2数据库迁移过程 | 您所在的位置:网站首页 › logsecond › Portal与db2数据库迁移过程 |
DB2安装: 1. DB2安装准备: 1).DB2安装介质的准备:把DB2放到指定的位置。如图1: 2).基本的网络设置。如图2: 图2 3).查看机器文件限制,使用ulimit –n查看(默认是1024,要修改成65536),如图3: 图3 2. 启动安装:2.切换到/root/db2install/ese目录下,执行以下的命令./db2setup ,如图4 图4 3. Install new a Product >>Install 如图5: 图5 4. 点击Next,如图6: 图6
5. 同意安装协议,点击Next如图7: 图7 6. 选择Typical 900-1090M,点击Next,如图8: 图8 7. 点击Next,如图9: 图9 8. 选择DB2安装路径,默认的安装路径是/opt/ibm/db2/V9.7/,点击Next,如图10: 图10
9. 选择Do Not install SA MP,点击Next,如图11: 图11 10. 设置数据库DAS用户密码:db2123,点击Next,如图12: 图12 11. 点击Create a DB2 instance,点击Next,如图13: 图13 12. 点击Next,如图14: 图14 13.设置数据库实例的密码:db2123,点击Next,如图15: 图15 13. 设置db2fenc1用户密码:db2123,点击Next,如图16: 图16
14. 选择Prepare DB2 the tool catalog,点击Next,如图17: 图17 15. 选择Do not set up DB2 server,点击Next,如图18: 图18 16. 点击Finish,如图19: 图19 17. 安装成功后测试, su db2inst2 db2 如图20: 图20 能正常使用db2数据库的命令管理器,并且查看数据库信息,说明数据库安装成功! DB2数据库创建: 18. 创建数据库的脚本: ----reldb-------------------------------------------------------------- db2'CREATE DB reldb using codeset UTF-8 territory us PAGESIZE 8192'; db2'UPDATE DB CFG FOR reldb USING applheapsz 4096'; db2'UPDATE DB CFG FOR reldb USING app_ctl_heap_sz 1024'; db2'UPDATE DB CFG FOR reldb USING stmtheap 32768'; db2'UPDATE DB CFG FOR reldb USING dbheap 2400'; db2'UPDATE DB CFG FOR reldb USING locklist 1000'; db2'UPDATE DB CFG FOR reldb USING logfilsiz 4000'; db2'UPDATE DB CFG FOR reldb USING logprimary 12'; db2'UPDATE DB CFG FOR reldb USING logsecond 20'; db2'UPDATE DB CFG FOR reldb USING logbufsz 32'; db2'UPDATE DB CFG FOR reldb USING avg_appls 5'; db2'UPDATE DB CFG FOR reldb USING locktimeout 30'; db2'UPDATE DB CFG FOR reldb using AUTO_MAINT off';
--------------------------comdb--------------------------------------------------------- db2'CREATE DB comdb using codeset UTF-8 territory us PAGESIZE 8192'; db2'UPDATE DB CFG FOR comdb USING applheapsz 4096'; db2'UPDATE DB CFG FOR comdb USING app_ctl_heap_sz 1024'; db2'UPDATE DB CFG FOR comdb USING stmtheap 32768'; db2'UPDATE DB CFG FOR comdb USING dbheap 2400'; db2'UPDATE DB CFG FOR comdb USING locklist 1000'; db2'UPDATE DB CFG FOR comdb USING logfilsiz 4000'; db2'UPDATE DB CFG FOR comdb USING logprimary 12'; db2'UPDATE DB CFG FOR comdb USING logsecond 20'; db2'UPDATE DB CFG FOR comdb USING logbufsz 32'; db2'UPDATE DB CFG FOR comdb USING avg_appls 5'; db2'UPDATE DB CFG FOR comdb USING locktimeout 30'; db2'UPDATE DB CFG FOR comdb using AUTO_MAINT off';
-------------------------cusdb db2'CREATE DB cusdb using codeset UTF-8 territory us PAGESIZE 8192'; db2'UPDATE DB CFG FOR cusdb USING applheapsz 4096'; db2'UPDATE DB CFG FOR cusdb USING app_ctl_heap_sz 1024'; db2'UPDATE DB CFG FOR cusdb USING stmtheap 32768'; db2'UPDATE DB CFG FOR cusdb USING dbheap 2400'; db2'UPDATE DB CFG FOR cusdb USING locklist 1000'; db2'UPDATE DB CFG FOR cusdb USING logfilsiz 4000'; db2'UPDATE DB CFG FOR cusdb USING logprimary 12'; db2'UPDATE DB CFG FOR cusdb USING logsecond 20'; db2'UPDATE DB CFG FOR cusdb USING logbufsz 32'; db2'UPDATE DB CFG FOR cusdb USING avg_appls 5'; db2'UPDATE DB CFG FOR cusdb USING locktimeout 30'; db2'UPDATE DB CFG FOR cusdb using AUTO_MAINT off';
------------------------jcrdb db2 'CREATEDB jcrdb using codeset UTF-8 territory us PAGESIZE 8192'; db2'UPDATE DB CFG FOR jcrdb USING applheapsz 4096'; db2'UPDATE DB CFG FOR jcrdb USING app_ctl_heap_sz 1024'; db2'UPDATE DB CFG FOR jcrdb USING stmtheap 32768'; db2'UPDATE DB CFG FOR jcrdb USING dbheap 2400'; db2'UPDATE DB CFG FOR jcrdb USING locklist 1000'; db2'UPDATE DB CFG FOR jcrdb USING logfilsiz 4000'; db2'UPDATE DB CFG FOR jcrdb USING logprimary 12'; db2'UPDATE DB CFG FOR jcrdb USING logsecond 20'; db2'UPDATE DB CFG FOR jcrdb USING logbufsz 32'; db2'UPDATE DB CFG FOR jcrdb USING avg_appls 5'; db2'UPDATE DB CFG FOR jcrdb USING locktimeout 30'; db2'UPDATE DB CFG FOR jcrdb using AUTO_MAINT off';
-------------------------lmdb db2'CREATE DB lmdb using codeset UTF-8 territory us PAGESIZE 8192'; db2'UPDATE DB CFG FOR lmdb USING applheapsz 4096'; db2'UPDATE DB CFG FOR lmdb USING app_ctl_heap_sz 1024'; db2'UPDATE DB CFG FOR lmdb USING stmtheap 32768'; db2'UPDATE DB CFG FOR lmdb USING dbheap 2400'; db2'UPDATE DB CFG FOR lmdb USING locklist 1000'; db2'UPDATE DB CFG FOR lmdb USING logfilsiz 4000'; db2'UPDATE DB CFG FOR lmdb USING logprimary 12'; db2'UPDATE DB CFG FOR lmdb USING logsecond 20'; db2'UPDATE DB CFG FOR lmdb USING logbufsz 32'; db2'UPDATE DB CFG FOR lmdb USING avg_appls 5'; db2'UPDATE DB CFG FOR lmdb USING locktimeout 30'; db2'UPDATE DB CFG FOR lmdb using AUTO_MAINT off';
--------------------------fdbkdb db2'CREATE DB fdbkdb using codeset UTF-8 territory us PAGESIZE 8192'; db2'UPDATE DB CFG FOR fdbkdb USING applheapsz 4096'; db2'UPDATE DB CFG FOR fdbkdb USING app_ctl_heap_sz 1024'; db2'UPDATE DB CFG FOR fdbkdb USING stmtheap 32768'; db2'UPDATE DB CFG FOR fdbkdb USING dbheap 2400'; db2'UPDATE DB CFG FOR fdbkdb USING locklist 1000'; db2'UPDATE DB CFG FOR fdbkdb USING logfilsiz 4000'; db2'UPDATE DB CFG FOR fdbkdb USING logprimary 12'; db2'UPDATE DB CFG FOR fdbkdb USING logsecond 20'; db2'UPDATE DB CFG FOR fdbkdb USING logbufsz 32'; db2'UPDATE DB CFG FOR fdbkdb USING avg_appls 5'; db2'UPDATE DB CFG FOR fdbkdb USING locktimeout 30'; db2'UPDATE DB CFG FOR fdbkdb using AUTO_MAINT off';
---------------jcrdb db2'CONNECT TO jcrdb USER db2inst2 USING db2123'; db2'CREATE BUFFERPOOL ICMLSFREQBP4 SIZE 1000 PAGESIZE 4 K'; db2'CREATE BUFFERPOOL ICMLSVOLATILEBP4 SIZE 8000 PAGESIZE 4 K'; db2'CREATE BUFFERPOOL ICMLSMAINBP32 SIZE 8000 PAGESIZE 32 K'; db2'CREATE BUFFERPOOL CMBMAIN4 SIZE 1000 PAGESIZE 4 K'; db2'CREATE REGULAR TABLESPACE ICMLFQ32 PAGESIZE 32 K MANAGED BY SYSTEMUSING('ICMLFQ32') BUFFERPOOL ICMLSMAINBP32'; db2'CREATE REGULAR TABLESPACE ICMLNF32 PAGESIZE 32 K MANAGED BY SYSTEM USING('ICMLNF32') BUFFERPOOL ICMLSMAINBP32'; db2'CREATE REGULAR TABLESPACE ICMVFQ04 PAGESIZE 4 K MANAGED BY SYSTEM USING('ICMVFQ04') BUFFERPOOL ICMLSVOLATILEBP4'; db2'CREATE REGULAR TABLESPACE ICMSFQ04 PAGESIZE 4 K MANAGED BY SYSTEM USING('ICMSFQ04') BUFFERPOOL ICMLSFREQBP4'; db2'CREATE REGULAR TABLESPACE CMBINV04 PAGESIZE 4 K MANAGED BY SYSTEM USING('CMBINV04') BUFFERPOOL CMBMAIN4'; db2'CREATE SYSTEM TEMPORARY TABLESPACE ICMLSSYSTSPACE32 PAGESIZE 32 K MANAGED BYSYSTEM USING ('icmlssystspace32') BUFFERPOOL ICMLSMAINBP32'; db2'CREATE SYSTEM TEMPORARY TABLESPACE ICMLSSYSTSPACE4 PAGESIZE 4 K MANAGED BYSYSTEM USING ('icmlssystspace4') BUFFERPOOL ICMLSVOLATILEBP4'; db2'DISCONNECT jcrdb'; db2'TERMINATE'; =======END COPY 19. reldb数据库的创建和参数的设置,如图21: 图21
20. lmdb数据库的创建和参数的设置,如图22: 图22 21. cusdb数据库的创建和参数的设置,如图23: 图23 22. fdbkdb数据库的创建和参数的设置,如图24: 图24
23. jcrdb库的创建和参数的设置,如图25 图25 24. comdb库的创建和参数的设置,如图26: 图26 25. 在/opt/ibm/db2/V9.7/java/目录下复制db2_jcc4.jar和db2_jcc_license_cu.jar到一个临时的目录db2,如图27: 图27 26. 在Portal机器上找到/opt/IBM/WebSphere/PortalServer目录下创建一个临时目录jdbc,并且把db2_jcc4.jar和db2_jcc_license_cu.jar两个文件放入到这个目录下面,如图28: 图28 27. 在Portal机器上找到/opt/IBM/WebSphere/wp_profile/ConfigEngine/properties目录,复制以下的三个文件wkplc.properties,wkplc_dbdomain.properties和wkplc_dbtype.properties,并且做以下的修改,如图29: 在wkplc.properties文件中做以下的修改: PortalAdminPwd=123456 Waspassword=123456
wkplc_dbdomain.properties文件中: feedback.DbType=db2 feedback.DbName=fdbkdb feedback.DbSchema=FEEDBACK feedback.DataSourceName=wpdbDS_feedback feedback.DbUrl=jdbc:db2://mydbserver.ibm.com:50000/fdbkdb:returnAlias=0; feedback.DbUser=db2inst1 feedback.DbPassword=password feedback.DbRuntimeUser=db2inst1 feedback.DbRuntimePassword=password
likeminds.DbType=db2 likeminds.DbName=lmdb likeminds.DbSchema=likeminds likeminds.DataSourceName=wpdbDS_likeminds likeminds.DbUrl=jdbc:db2://mydbserver.ibm.com:50000/lmdb:returnAlias=0; likeminds.DbUser=db2inst1 likeminds.DbPassword=password likeminds.DbRuntimeUser=db2inst1 likeminds.DbRuntimePassword=password release.DbType=db2 release.DbName=reldb release.DbSchema=release release.DataSourceName=wpdbDS_release release.DbUrl=jdbc:db2://mydbserver.ibm.com:50000/reldb:returnAlias=0; release.DbUser=db2inst1 release.DbPassword=password release.DbRuntimeUser=db2inst1 release.DbRuntimePassword=password community.DbType=db2 community.DbName=comdb community.DbSchema=community community.DataSourceName=wpdbDS_community community.DbUrl=jdbc:db2://mydbserver.ibm.com:50000/comdb:returnAlias=0; community.DbUser=db2inst1 community.DbPassword=password community.DbRuntimeUser=db2inst1 community.DbRuntimePassword=password customization.DbType=db2 customization.DbName=cusdb customization.DbSchema=customization customization.DataSourceName=wpdbDS_customization customization.DbUrl=jdbc:db2://mydbserver.ibm.com:50000/cusdb:returnAlias=0; customization.DbUser=db2inst1 customization.DbPassword=password customization.DbRuntimeUser=db2inst1 customization.DbRuntimePassword=password jcr.DbType=db2 jcr.DbName=jcrdb jcr.DbSchema=jcr jcr.DataSourceName=wpdbDS_jcr jcr.DbUrl=jdbc:db2://mydbserver.ibm.com:50000/jcrdb:returnAlias=0; jcr.DbUser=db2inst1 jcr.DbPassword=password jcr.DbRuntimeUser=db2inst1 jcr.DbRuntimePassword=password
wkplc_dbtype.properties文件做以下配置,并且保存: DB2.DbLibrary=/opt/IBM/WebSphere/PortalServer/jdbc/db2/db2jcc4.jar: /opt/IBM/WebSphere/PortalServer/jdbc/db2/db2jcc_licernet_cu.jar 图29 28. 修改这个三个文件之后,就把原来的文件替换掉,如图30: 图30 29. 然后找到Portal的以下目录/opt/IBM/WebSphere/wp_profile/PortalServer/jcr/config/的registerCollationUDFTemplate.sql文件复制一份到一个临时目录,如图31: 图31 30. 然后找到Portal的以下目录/opt/IBM/WebSphere/PortalServer/jcr/wp.content.repository.install/lib 的wp.content.repository.install.jar文件复制一份到一个临时目录,如图32: 图32 31. 把registerCollationUDFTemplate.sql文件成以下的内容,如图33: 图33 32.修改完成之后把wp.content.repository.install.jar和registerCollationUDFTemplate.sql两个文件放到db2实例的以下的目录/home/db2inst1/sqllib/function目录下面,如图34: 图34 32. 在/home/db2inst2/sqllib/java/jdk64/bin目录下面,执行以下命令: ./jar –xvf /home/db2inst2/sqllib/function/wp.content.repository.install.jaricm/CollationUDF.class,如图35: 图35
33. 切换db2inst2用户,在/home/db2inst2/sqllib/function执行以下的命令: Su db2inst2 Db2 connect to jcrdb db2 –tvf/home/db2inst2/sqllib/function/registerCollationUDFTemplate.sql, 如图36: 图36 34. 在portal的目录/opt/IBM/WebSphere/wp_profile/ConfigEngine,执行以下的命令,测试数据库,如图37: ./ConfigEngine.sh setup-database -DWasPassword=123456 ./ConfigEngine.sh validate-database-driver –DwasPassword=123456 ./ConfigEngine.sh validate-database-connection–DwasPassword=123456
图37 35. 以上的三个命令执行成功之后,执行数据库迁移命令,如图38: 图38 36. 把Portal服务器重启,如图39: 图39 37. Portal启动完成,在浏览器上: http://localhost:10039/wps/portal 如图40: 图40 38.说明DB2数据库迁移配置成功! 0 0 Portal与db2数据库迁移过程 DB2数据库数据迁移 db2 存储过程迁移方法 SharePoint Portal Server 2003数据库迁移指南 db2数据库跨平台迁移 Oracle数据库迁移至DB2数据库 mysql数据库迁移到db2数据库 跨平台的DB2数据库的迁移 db2 迁移数据库数据 、导出导入 、 备份 db2数据库迁移到mssql记录 db2数据库迁移到mssql记录之一 异构数据库迁移 db2---oracle Linux系统中DB2数据库的迁移 数据库迁移.从DB2到Oracle oracle数据迁移到db2数据库 跨平台的DB2数据库的迁移 数据库迁移(二):存储过程迁移 DB2的数据复制与迁移方法 javaweb之自定义标签——简单标签库 Hadoop权限管理(转) C++ 模板设计 policy和traits 8086 CPU 寄存器简介 Java中堆和栈的区别 Portal与db2数据库迁移过程 泛型编程与STL学习-iterators Android之开发性能优化简介 linux - yum 安装配置mysql可以远程连接 IAR C语言获取变量地址 android之Touch事件处理机制 重装系统后电脑数据恢复办法 最新u-boot-2014.01版移植手册 java 反射判断类值 |
CopyRight 2018-2019 实验室设备网 版权所有 |