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数据库迁移配置成功!