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

1. 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.
2. 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

3. 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