Siebel Database Upgrade Guide for DB2 for z/OS > Basic Database Preparations for a Siebel Upgrade > Preparing the Storage Layout of the Schema >

Reviewing the Storage Control File

After you have extracted the storage control file, you must carefully review and edit it to meet your requirements. Your storage control file is located in the directory that you specified when you ran the Database Configuration Wizard to extract the file.

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.

Check the following parameters in the control file and modify them as appropriate for your database. 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.

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

Related Topic

Preparing the Storage Layout of the Schema