Siebel Database Upgrade Guide for DB2 UDB 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 review it. Your storage control file 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 needs. Once you have a storage layout that you are satisfied with, you are ready to continue with your upgrade.

NOTE:  You must carefully review and edit the storage control file to meet your needs. Every time you modify the file, you must validate it again. 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