Oracle table space settings

These table spaces must be created in the IBM® Product Master database.

If you want to prepare DB2® to store, retrieve and process data, you must create table spaces. Because of the large size of the tables in the Product Master, you must use a page size of 16 KB when you create the table spaces.

For more details on custom table space implementation with the product, see Custom table space names.

Required table spaces

Only the USERS, INDX, BLOB_TBL_DATA, TEMP_USER, and TEMP_SYSTEM table spaces are required for a default development environment. The table spaces ITA_DATA, ITA_IX, ITD_DATA, ITD_IX, ITM_DATA, ITM_IX, LCK_DATA are LCK_IX are required for Product Master production instances. You should use table space-mapping file that is described in the section Running schema creation scripts to use these table spaces.

Table 1. Required table spaces
Table space	Definition	Recommended size
ICM_DATA	This table space is used to store TCTG_ICM_ITEM_CATEGORY_MAP table data.	A minimum size of 1 GB space with auto-resize.
ICM_IX	This table space is used to store TCTG_ICM_ITEM_CATEGORY_MAP index data.	A minimum size of 1 GB space with auto-resize.
ITM_DATA	This table space is used to store TCTG_ITM_ITEM table data.	A minimum size of 1 GB space with auto-resize.
ITM_IX	This table space is used to store TCTG_ITM_ITEM index data.	A minimum size of 1 GB space with auto-resize.
ITD_DATA	This table space is used to store TCTG_ITD_ITEM_DETAIL table data.	A minimum size of 5 GB space with auto-resize.
ITD_IX	This table space is used to store TCTG_ITD_ITEM_DETAIL index data.	A minimum size of 5 GB space with auto-resize.
ITA_DATA	This table space is used to store TCTG_ITA_ITEM_ATTRIBUTES table data.	A minimum size of 10 GB space with auto-resize.
ITA_IX	This table space is used to store TCTG_ITA_ITEM_ATTRIBUTES index data.	A minimum size of 10 GB space with auto-resize.
LCK_DATA	This table space is used to store TUTL_LCK_LOCK table data.	A minimum size of 1 GB space with auto-resize.
LCK_IX	This table space is used to store TUTL_LCK_LOCK index data.	A minimum size of 1 GB space with auto-resize.
SYSTEM	This is the default table space that is created automatically in the Oracle Database. System table space is used to store the data dictionary and the objects that are created by system user. This is a permanent table space.	A minimum size of 300 MB for the system table space with auto resize.
USERS	This table space is used to store all the Product Master database tables except tables that are used to store large objects (LOBs). This is a permanent locally managed table space.	A minimum size of 15 GB for the users table space with auto resize.
INDX	This table space is used to store all the Product Master database indexes. This is a permanent locally managed table space.	A minimum size of 30 GB for the indx table space with auto resize.
BLOB_TBL_DATA	This table space is used to store Product Master database tables that contain large objects like Catalogs, Images. This is a permanent locally managed table space.	A minimum size of 1 GB for the blob_tbl_data table space with auto resize.
XML_DATA	This table space is used to store Product Master database tables that contain XML documents. This is a permanent locally managed table space.	A minimum size of 1 GB space for the XML_DATA table space with auto resize.
XML_INDEX	This table space is used to store Product Master database indexes on XML documents. This is a permanent locally managed table space.	A minimum size of 1 GB space for the XML_INDEX table space with auto resize.
UNDOTBS1	This is the undo table space.	A minimum size of 15 GB for the undotbs1 table space with auto resize.
TEMP	This table space is used to store objects temporarily for database operations like sorting and grouping. This is a temporary table space.	A minimum size of 6 GB for the temp table space with auto resize.

Oracle table space information

Table 2. Oracle table space information
Table space	Minimum Size	Recommended storage parameters
SYSTEM	400 MB	Default
USERS	5 GB	EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO
INDX	20 GB	EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO
BLOB_TBL_DATA	1 GB	EXTENT MANAGEMENT LOCAL LOCAL SEGMENT SPACE MANAGEMENT AUTO
XML_DATA	1 GB	EXTENT MANAGEMENT LOCAL LOCAL SEGMENT SPACE MANAGEMENT AUTO
XML_INDEX	1 GB	EXTENT MANAGEMENT LOCAL LOCAL SEGMENT SPACE MANAGEMENT AUTO
UNDOTBS1	10 GB	UNDO TABLE SPACE LEAVE DEFAULT VALUES
TEMP	5 GB	TEMPORARY TABLE SPACE LEAVE DEFAULT VALUES

Sample statements for creating Oracle table spaces

You must change the datafile path from <database_folder> to the appropriate path in your file system. You can also modify the maxsize parameter to a set limit.

Note: A single gigabyte (1G) of space is enough to maintain around 3 million records. Ensure that you verify your space requirement according to your capacity.

CREATE TABLESPACE "USERS"
	LOGGING
	DATAFILE '<database_folder>/users1.dbf' SIZE 1G REUSE
  AUTOEXTEND ON NEXT 1G MAXSIZE UNLIMITED;

CREATE TABLESPACE "INDX"
	LOGGING
	DATAFILE '<database_folder>/indx1.dbf' SIZE 1G REUSE
	AUTOEXTEND ON NEXT 1G MAXSIZE UNLIMITED;

CREATE TABLESPACE "BLOB_TBL_DATA"
	LOGGING
	DATAFILE '<database_folder>/blob1.dbf' SIZE 1G REUSE
	AUTOEXTEND ON NEXT 1G MAXSIZE UNLIMITED;

CREATE TABLESPACE "ICM_DATA"
	LOGGING
	DATAFILE '<database_folder>/icm_data1.dbf' SIZE 1G REUSE
	AUTOEXTEND ON NEXT 1G MAXSIZE UNLIMITED;

CREATE TABLESPACE "ICM_IX"
	LOGGING
	DATAFILE '<database_folder>/icm_ix1.dbf' SIZE 1G REUSE
	AUTOEXTEND ON NEXT 1G MAXSIZE UNLIMITED;

CREATE TABLESPACE "XML_DATA"
	LOGGING
	DATAFILE '<database_folder>/xml_data1.dbf' SIZE 1G REUSE
	AUTOEXTEND ON NEXT 1G MAXSIZE UNLIMITED;

CREATE TABLESPACE "XML_INDEX"
	LOGGING
	DATAFILE '<database_folder>/xml_index1.dbf' SIZE 1G REUSE
	AUTOEXTEND ON NEXT 1G MAXSIZE UNLIMITED;

CREATE TABLESPACE "XML_LARGE_DATA"
	LOGGING
	DATAFILE '<database_folder>/xml_lrgdata1.dbf' SIZE 1G REUSE
	AUTOEXTEND ON NEXT 1G MAXSIZE UNLIMITED;

CREATE TABLESPACE "ITM_DATA"
	LOGGING
	DATAFILE '<database_folder>/itm_data1.dbf' SIZE 1G REUSE
	AUTOEXTEND ON NEXT 1G MAXSIZE UNLIMITED;

CREATE TABLESPACE "ITM_IX"
	LOGGING
	DATAFILE '<database_folder>/itm_ix1.dbf' SIZE 1G REUSE
	AUTOEXTEND ON NEXT 1G MAXSIZE UNLIMITED;

CREATE TABLESPACE "ITD_DATA"
	LOGGING
	DATAFILE '<database_folder>/itd_data1.dbf' SIZE 1G REUSE
	AUTOEXTEND ON NEXT 1G MAXSIZE UNLIMITED;

CREATE TABLESPACE "ITD_IX"
	LOGGING
	DATAFILE '<database_folder>/itd_ix1.dbf' SIZE 1G REUSE
	AUTOEXTEND ON NEXT 1G MAXSIZE UNLIMITED;

CREATE TABLESPACE "ITA_DATA"
	LOGGING
	DATAFILE '<database_folder>/ita_data1.dbf' SIZE 1G REUSE
	AUTOEXTEND ON NEXT 1G MAXSIZE UNLIMITED;

CREATE TABLESPACE "ITA_IX"
	LOGGING
	DATAFILE '<database_folder>/ita_ix1.dbf' SIZE 1G REUSE
	AUTOEXTEND ON NEXT 1G MAXSIZE UNLIMITED;

CREATE TABLESPACE "LCK_DATA"
	LOGGING
	DATAFILE '<database_folder>/lck_data1.dbf' SIZE 1G REUSE
	AUTOEXTEND ON NEXT 1G MAXSIZE UNLIMITED;

CREATE TABLESPACE "LCK_IX"
	LOGGING
	DATAFILE '<database_folder>/lck_ix1.dbf' SIZE 1G REUSE
	AUTOEXTEND ON NEXT 1G MAXSIZE UNLIMITED;