The dataset storage type options are ‘S’ for Storage Group and ‘V’ for VSAM. The initial database size options are ‘S’ for Small (approximately 329 tracks of 3390 DASD) or ‘M’ for Medium (approximately 2303 tracks of 3390 DASD). The default primary and secondary number of records is derived from the selection of the database size (Small/Medium) for each table of the z/OS Implementation Toolset (IT). The secondary storage factor is used to increase the default primary and secondary sizes by a factor that is input by the customer on the Set DB2 Variables panel. Use the secondary storage factor to fine tune your database size requirements by a factor of .01 to 9.9. For example, if the secondary storage factor is 4.5, the primary size will increase by a factor of 4 (4 times the primary amount), and the secondary size will increase by a factor of 5 (5 times the secondary amount).
Fine tuning the size parameters reduces storage resources that may be over-allocated for the database and ultimately would reduce the associated system costs.
|
Copyright © 2014 CA Technologies.
All rights reserved.
|
|