Upgrade Guide for DB2 UDB for z/OS > Basic Database Preparations > 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 Server 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 = 7200

SecQty = 14400

PctFree = 17

FreePage = 0

Compress = No

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 = 7200

SecQty = 14400

PctFree = 17

FreePage = 0

Compress = No

Partitions = 0

Define = 0

Erase = 0

Upgrade Guide for DB2 UDB for z/OS