Table of Contents

Search

  1. Preface
  2. Installation Overview
  3. Pre-Installation Tasks
  4. Hub Store Installation
  5. Hub Server Installation
  6. Hub Server Post-Installation Tasks
  7. Process Server Installation
  8. Process Server Post-Installation Tasks
  9. ActiveVOS Post-Installation Tasks for the Application Server
  10. ActiveVOS Post-Installation Tasks for the Business Entity Adapter
  11. Resource Kit Installation
  12. Resource Kit Post-Installation Tasks
  13. Troubleshooting the MDM Hub
  14. Uninstallation

Installation Guide for IBM DB2 with Red Hat JBoss

Installation Guide for IBM DB2 with Red Hat JBoss

Create Tablespaces

Create Tablespaces

You need to create tablespaces that the MDM Hub schemas require.
Create the tablespaces in the following sequence:
  1. CMX_DATA
  2. CMX_INDX
  3. CMX_REPOS
  4. CMX_TEMP
  5. CMX_USER_TEMP
  6. 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

0 COMMENTS

We’d like to hear from you!