Installation Guide for IBM DB2 with Red Hat JBoss

10.3 HotFix 3

Back Next

Create Tablespaces

You need to create tablespaces that the MDM Hub schemas require.

Create the tablespaces in the following sequence:

CMX_DATA

CMX_INDX

CMX_REPOS

CMX_TEMP

CMX_USER_TEMP

CMX_SYS_TEMP

Use the following statements to create tablespaces for the MDM Hub schemas:

CREATE TABLESPACE CMX_DATA PAGESIZE 32 K 
	MANAGED BY DATABASE USING ( FILE 'c:\dbhub9x\CMX_DATA\cmx_data01.dat' 500 M ) 
	EXTENTSIZE 16 
	AUTORESIZE YES 
	OVERHEAD 10.5 
	PREFETCHSIZE 16
	BUFFERPOOL CMX_POOL 
	
CREATE TABLESPACE CMX_INDX PAGESIZE 32 K 
	MANAGED BY DATABASE USING ( FILE 'c:\dbhub9x\CMX_INDX\cmx_indx01.dat' 500 M ) 
	EXTENTSIZE 16 
	AUTORESIZE YES 
	OVERHEAD 10.5 
	PREFETCHSIZE 16
	BUFFERPOOL CMX_POOL 
	
CREATE TABLESPACE CMX_REPOS PAGESIZE 32 K 
	MANAGED BY DATABASE USING ( FILE 'c:\dbhub9x\CMX_REPOS\cmx_repos01.dat' 500 M )
	EXTENTSIZE 16 
	AUTORESIZE YES 
	OVERHEAD 10.5 
	PREFETCHSIZE 16 
	BUFFERPOOL REPOS_POOL 
	
CREATE TABLESPACE CMX_TEMP PAGESIZE 32 K 
	MANAGED BY DATABASE USING ( FILE 'c:\dbhub9x\CMX_TEMP\cmx_temp01.dat' 500 M ) 
	EXTENTSIZE 16 
	AUTORESIZE YES 
	OVERHEAD 10.5 
	PREFETCHSIZE 16
	BUFFERPOOL CMX_POOL 
	
CREATE USER TEMPORARY TABLESPACE CMX_USER_TEMP PAGESIZE 32 K 
	MANAGED BY DATABASE USING ( FILE 'c:\dbhub9x\USER_TEMP\cmx_user_temp01.dat' 500 M ) 
	EXTENTSIZE 16 
	AUTORESIZE YES 
	OVERHEAD 10.5
	PREFETCHSIZE 16 
	BUFFERPOOL CMX_POOL

CREATE SYSTEM TEMPORARY TABLESPACE CMX_SYS_TEMP PAGESIZE 32 K
	MANAGED BY DATABASE USING ( FILE 'c:\dbhub9x\SYSTEM_TEMP\cmx_sys_temp01.dat' 500 M ) 
	EXTENTSIZE 16 
	AUTORESIZE YES 
	OVERHEAD 10.5 
	PREFETCHSIZE 16 
	BUFFERPOOL CMX_POOL

Optionally, to create tablespaces with the dropped table recovery feature enabled, add the following clause to the

CREATE TABLESPACE

statement:

DROPPED TABLE RECOVERY ON

Rename Saved Search

Table of Contents

Installation Guide for IBM DB2 with Red Hat JBoss

Installation Guide for IBM DB2 with Red Hat JBoss

Create Tablespaces

Create Tablespaces