If you use vSphere Replication with a DB2 database, vSphere Replication requires system temporary table space with at least 16K page size and user temporary table space.

You use DB2 Configuration Assistant to create and configure a DB2 database for vSphere Replication.

1

When you create the database instance, specify UTF-8 encoding and 16K page size.

If the database exists already and it is not configured with 16K page size, type the following commands.

CREATE BUFFERPOOL "IBMBP16"
 ALL DBPARTITIONNUMS SIZE 1000
 NUMBLOCKPAGES 0
 PAGESIZE 16 K;

CREATE SYSTEM TEMPORARY TABLESPACE "TEMPSPACE16"
 PAGESIZE 16 K
 MANAGED BY AUTOMATIC STORAGE
 BUFFERPOOL "IBMBP16"
2

Configure the database to allow the creation of user temporary tables.

For example, type the following commands to configure the database for user VR.

CREATE USER TEMPORARY TABLESPACE TEMPSPACE_VR MANAGED BY AUTOMATIC STORAGE
GRANT USE OF TABLESPACE TEMPSPACE_VR TO USER VR
3

Specify the domain account as the database owner.

This is required because DB2 uses authentication by the operating system.