DB2 Server for VSE & VM: Performance Tuning Handbook

Specification File Example

Consider a database where you want to:

• Turn on striping for storage pools 1 to 10
• Turn off striping for storage pools 11 to 20
• Only use Data Spaces Support for storage pools 2, 5, 10, 11, and 15 to 20
• Set the working storage residency priority to 2 for storage pools 10, 11, and 15 to 19
• Use the default residency priority (3) for pools 2, 5, and 20.

Your storage pool specification file should look like this:

-- Storage Pool Specification File 1 BLK STR 2 DS STR 3-4 BLK STR 5 DS STR 6-9 BLK STR 10 DS2 STR 11 DS2 SEQ 12-14 BLK SEQ 15-19 DS2 SEQ 20 DS SEQ

While you could have also coded your file like the following example, you may find it difficult to interpret:

-- Storage Pool Specification File 11-20 SEQ 1 BLK 3-4 BLK 6-9 BLK 12-14 BLK 10-11 DS2 15-19 DS2