$ db2 connect to resdb

$ db2set DB2_COMPATIBILITY_VECTOR=ORA

$ db2set -all |grep 'DB2_COMPATIBILITY_VECTOR'

重启数据库

$ db2stop force

$ db2start

11.创建数据库对象

$ db2 "create bufferpool BP_DAT_32K size 16000 ?pagesize ?32k"

$ db2 "create bufferpool BP_IDX_32K size 16000 ?pagesize ?32k"

$ db2 "create bufferpool BP_TMP_32K size 16000 ?pagesize ?32k"

$ db2 "CREATE LARGE TABLESPACE TBS_DAT_32k PAGESIZE 32K MANAGED BY AUTOMATIC STORAGE ?EXTENTSIZE 4 PREFETCHSIZE AUTOMATIC BUFFERPOOL BP_DAT_32K AUTORESIZE YES INCREASESIZE 1G ?NO FILE SYSTEM CACHING"

$ db2 "CREATE LARGE TABLESPACE TBS_IDX_32k PAGESIZE 32K MANAGED BY AUTOMATIC STORAGE ?EXTENTSIZE 4 PREFETCHSIZE AUTOMATIC BUFFERPOOL BP_IDX_32K AUTORESIZE YES ?INCREASESIZE 1G ?NO FILE SYSTEM CACHING"

$ db2 "CREATE system TEMPORARY TABLESPACE TBS_SYSTMP_32K PAGESIZE 32K MANAGED BY AUTOMATIC STORAGE ?BUFFERPOOL BP_TMP_32K ?NO FILE SYSTEM CACHING"

12.数据库恢复

创建所需目录：

$ mkdir -p /oradata4/db2

首先对备份文件进行分析：

$ ls -al | grep -i RESLT4

-rw-r--r-- 1 db2inst1 db2iadm1 13223706624 Jan 19 12:42 RESLT4.0.db2inst1.DBPART000.20170118202238.001

生成restore.clp文件

$ db2 restore db RESLT4 taken at 20170118202238 redirect generate script restore.clp

DB20000I ?The RESTORE DATABASE command completed successfully.

修改restore.clp文件：

RESTORE DATABASE RESLT4

-- USER ?

-- USING ''

FROM '/oradata4/db2'

TAKEN AT 20170118202238

-- ON '/oradata4/db2'

-- DBPATH ON ''

INTO RESDB

-- NEWLOGPATH '/oradata4/db2/db2inst1/NODE0000/SQL00004/LOGSTREAM0000/'

-- WITH BUFFERS

-- BUFFER

-- REPLACE HISTORY FILE

-- REPLACE EXISTING

REDIRECT

-- PARALLELISM

WITHOUT ROLLING FORWARD

-- WITHOUT PROMPTING

;

-- SET STOGROUP PATHS FOR IBMSTOGROUP

-- ON '/oradata4/db2'

-- ;

RESTORE DATABASE RESLT4 CONTINUE;

批注：远端备份的数据库名为RESLT4，远端备份路径为/oradata4/db2,本地数据库名为RESDB，本地需要先创建/oradata4/db2路径。

执行恢复操作：

$ db2 -tvf restore.clp

UPDATE COMMAND OPTIONS USING S ON Z ON RESLT4_NODE0000.out V ON

DB20000I ?The UPDATE COMMAND OPTIONS command completed successfully.

SET CLIENT ATTACH_MEMBER ?0

DB20000I ?The SET CLIENT command completed successfully.

SET CLIENT CONNECT_MEMBER 0

DB20000I ?The SET CLIENT command completed successfully.

RESTORE DATABASE RESLT4 FROM '/oradata4/db2' TAKEN AT 20170118202238 INTO RESDB REDIRECT WITHOUT ROLLING FORWARD

SQL2529W ?Warning! ?Restoring to an existing database that is different from

the backup image database, and the alias name "RESDB" of the existing database

does not match the alias name "RESLT4" of the backup image, and the database

name "RESDB" of the existing database does not match the database name

"RESLT4" of the backup image. The target database will be overwritten by the

backup version. The Roll-forward recovery logs associated with the target

database will be deleted.

Do you want to continue ? (y/n)y

SQL1277W ?A redirected restore operation is being performed. During a table

space restore, only table spaces being restored can have their paths

reconfigured. During a database restore, storage group storage paths and DMS

table space containers can be reconfigured.

DB20000I ?The RESTORE DATABASE command completed successfully.

RESTORE DATABASE RESLT4 CONTINUE

DB20000I ?The RESTORE DATABASE command completed successfully.

?

应用环境部署

13.WAS应用部署连接DB2数据库

之前部署的WAS环境连接的都是Oracle库，连接DB2的库数据源配置还是第一次，找了些资料，将与配置Oracle不同的地方记录如下：

13.1配置DB2环境变量 ? --本次WAS部署采用的是单机环境

控制台界面中选择Environment-->WebSphere-->variables-->作用域（选择server1）

点击"new"创建DB2UNIVERSAL_JDBC_DRIVER_PATH变量值为："/was/DB2lib"