Siebel Database Upgrade Guide for DB2 for z/OS > Preparing a Development Environment for a Siebel Upgrade >
Preparing for Intersection Table Maintenance and Deduplication
Upgrades: Release 7.5.3 only. Environments: Development environment only. Perform the following task to create the storage_dedup.ctl file. This file is used for deduplication procedures and intersection table maintenance. To create a storage_dedup.ctl file
- Create a copy of the storage_dedup.ctl file located in the
DB2390 directory under DBSRVR_ROOT .
- Rename the copy of storage_dedup.ctl to preserve it as a backup, for example, save it as ORIGstorage_dedup.ctl.
- Navigate to the
DBSRVR_ROOT\ DB2390 directory and open dbconf.xls.
NOTE: If your midtier is UNIX, then the dbconf.xls and storage_dedup.ctl files must be transferred to Windows using the ftp command. The dbconf.xls file must be transferred in binary mode while the storage_dedup.ctl file must be in ASCII mode. Using these transfer modes prevents file corruption.
- Select the HOME tab page, and click Import.
- When you are prompted to select the storage_dedup file, navigate to the
DBSRVR_ROOT\ DB2390 directory and select storage_dedup.ctl.
The default values screen appears.
- On the default values screen, enter the values for your system:
- Enter your values for the following parameters:
- Table Storage Group for Table
- Index Storage Group for Indexes
- 4-KB Buffer Pool Name
- 16-KB Buffer Pool Name
- Index Buffer Pool Name
- For the Database Name Prefix, replace the placeholder, SIDB, with your database name prefix.
Your database name prefix can be a maximum of four characters. This can be the last four letters of your tableowner ID.
- For the Encoding Scheme, specify your database encoding scheme, either ASCII or EBCDIC.
After entering and verifying all values, click Set.
- Return to the HOME tab page, and click Export.
Save this database configuration as storage_dedup.ctl in the DBSRVR_ROOT\ DB2390 directory.
|