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