DB2 Server for VSE & VM: Performance Tuning Handbook

Data Line Syntax

Each data line of the storage pool specification file follows the following syntax: 



                                  (1)             (1)
>>-n1----+-----+---+-----------+---------+-----+---------------->
         '--n2-'   +-BLK-------+         +-STR-+
                   |    .-3--. |         '-SEQ-'
                   '-DS-+----+-'
                        '-n--'
 
>------+-----------+-------------------------------------------><
       '---comment-'


Notes:



  1. You must include at least one of these blocks.


n1
Specifies that you want to change the specifications for storage pool n1. Valid values are integers from 1 to 999.

n2
Specifies a range of storage pools from n1 to n2. Valid values are integers from 1 to 999. n2 must be greater than or equal to n1.

BLK
Turns Data Spaces Support off for the storage pools you specify.

DS
Turns Data Spaces Support on for the storage pools you specify. This is the default.

n
Sets the working storage residency priority of the storage pools you specify to n. Valid values are integers from 1 to 5. The default value for n is 3.

STR
Turns on striping for the storage pools you specify. This is the default.

SEQ
Turns off striping for the storage pools you specify. The database system will allocate pages sequentially on DASD.

comment
You can include a comment at the end of the data line. Precede it with two dashes (--).
Note:If you do not include a storage pool in the storage pool specification file, the database system will use all the default settings for that storage pool.

[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]