Siebel Database Upgrade Guide for DB2 for z/OS > Basic Database Preparations for a Siebel Upgrade > Process of Preparing the Storage Layout of the Schema >
Reviewing the Extracted Storage Control File
After you have extracted the storage control file, you must carefully review and edit it to meet your requirements. NOTE: If you extracted the storage control file on a Siebel Server that is on a UNIX operating system platform, and you would like to amend the file using the Siebel Database Storage Configurator utility (dbconf.xls), transfer the storage control file to a Microsoft Windows computer which has Microsoft Excel installed using a BINARY FTP file transfer mode. Using BINARY FTP transfer ensures that carriage returns in the storage control file are maintained and transferred correctly.
This task is a step in Process of Preparing the Storage Layout of the Schema. To review the storage control file
- Navigate to the storage control file which is located in the directory that you specified when you ran the Database Configuration Wizard to extract the file.
- Check the following parameters in the control file and modify them as appropriate for your database.
NOTE: Do not change the defaults for the following parameters in [Object 1] in the storage control file: IndexStogroup, IndexBp, PriQty, SecQty.
[Object 1]
Type = Defaults
Name = Defaults
Database = $DbnamePrefix0000
Tablespace = SIEBTS00
Stogroup = $StogroupTables
IndexStogroup = $StogroupIndexes
IndexBp = $IndexBufferPool
Bufferpool = $4KBufferPool
Locksize = Page
SegSize = 32
LockMax = 0
PriQty = 48
SecQty = 1440
PctFree = 17
FreePage = 0
Compress = Yes
Define = No
Erase = No
CCSID = $DbType
[Object 2]
Type = Database
Name = $DbnamePrefix0000
LockSize = Page
[Object 3]
Type = Tablespace
Name = SIEBTS00
Database = $DbnamePrefix0000
Bufferpool = $4KBufferPool
Stogroup = $StogroupTables
LockSize = PAGE
LockMax = 0
SegSize = 32
PriQty = 48
SecQty = 1440
PctFree = 17
FreePage = 0
Compress = No
Partitions = 0
Define = 0
Erase = 0
- Once you have a storage layout that you are satisfied with, you are ready to continue with your upgrade.
Every time you modify the storage control file, you must validate it again. For additional information, see Validating the Extracted Storage Control File
Related Topic
Process of Preparing the Storage Layout of the Schema
|