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
|