Starting Your Product › How to Configure Without CA CSM › Configuring Host Encyclopedia and Host Construction › Establish the Environment › Tasks to Define Installation Variables › Assign Storage Group Names

Assign Storage Group Names

Use this option to specify Storage Groups as the data set storage type when setting DB2 variables.

Follow these steps:

1. Select option 7 on the Installation variables management screen and press Enter.

   The Assign Storage Group names screen displays.

   

2. To distribute tablespace and indexspace allocations across Storage Groups, type the names of the Storage Groups in spaces (1) through (6), based on these considerations:
   • You must include at least one distributed storage group.
   • Tablespaces and indexes referencing a blank Distributed Storage Group are distributed to the group specified in (1).
   • Allocating the database over three to six volumes can improve performance.
   • If you specify more than one disk group, complete all the Distributed Storage Group fields. For example, if you only want to assign three groups, complete all the fields by using the same name for (1) and (4), (2) and (5), (3) and (6).
3. Modify the Dis Grp (Distribution Group) to specify individual tablespaces and index distribution.

   For information about how CA Gen assigns high-use tablespaces and indexes, see Sizing an Encyclopedia.

4. To modify a Primary Default storage value for a table or index, type a new value in the Modify Space column.
5. To modify a Secondary Default storage value for a table or index, type a new value in the Modify Space column.

   Note: To calculate the Secondary Default storage space value for a table or index on this screen, multiply the Primary Default storage space value by the Secondary Storage Factor entered on the Set DB2 Variables screen.

6. Press F2 to verify and save the values in a working copy of the user's ISPF profile pool.

   This also creates the member TILTAB50 in the Table library (TLIB). The system uses TILTAB50 to create the storage group space variables in the CREATE TABLESPACE SQL member (CRNEWSP). For more information, see the section TILTAB50 in this guide.

7. When verification is complete, press Enter to exit the Activity Display screen.
8. Press F3 to exit the screen.