Create Table Space: Define Partitions panel

Panel and field definitions

  Process   Options   Utilities   Help
                                                                                
 FM/Db2 (DFG2)       Create Table Space: Define Partitions      Row 1 to 1 of 1

 New Table Space:
    Name  . . . . . . .
    Database  . . . . .

                                                             Use   Group
     Pt.   VCAT   STOGROUP Primary  Secndry Erase Free  %    Data   BP     Track
 Cmd No.   Name   Name   +  Space    Space  Data  Pages Free Cmpr? Caching Mod
     1                                                                        


 ******************************* Bottom of data ********************************





 Command ===>                                                       Scroll PAGE
  F1=Help      F2=Split     F3=Exit      F4=Expand    F7=Backward  F8=Forward
  F9=Swap     F10=Left     F11=Right    F12=Cancel

Cmd

Use the following line commands to manipulate the panel rows containing partition information:

I

Insert one new row.

In

Insert n new rows.

R

Repeat the current row.

Rn

Repeat the current row n times.

D

Delete one row.

Dn

Delete n rows.

Pt. No.

Partition number

VCAT Name

This is used to specify user-defined data sets. It is mutually exclusive with a STOGROUP name.

STOGROUP Name

This is used to specify a (Db2®) storage group name. Specifying a storage group name means that Db2® creates the data sets for the partition. It is mutually exclusive with a VCAT name.

Primary Space

This is used to specify the primary space allocation for the partition (in kilobytes).

Secondary Space

This is used to specify the secondary space allocation for the partition (in kilobytes).

Erase Data

This corresponds to the ERASE YES/NO clause in the 'USING' block. ERASE YES means that the data sets associated with the partition are overwritten with binary zeros when the partition is deleted (dropped).

Free Pages

Free pages results in Db2® leaving an empty page every n pages (n is what is specified).

% Free

The value specified here results in Db2® leaving n% (n is what is specified) of each page free.

Use Data Cmpr?

This corresponds to the COMPRESS NO/YES clause. YES means the data is stored in compressed format.

Group BP Caching

This corresponds to the GBPCACHE clause of the create statement (for each partition). This option only applies in a data sharing environment.

TRACK MOD

Specifies whether Db2® tracks modified pages in the space map pages of the table space or partition. Do not specify TRACKMOD for a LOB table space. For a table space in a TEMP database, Db2® uses TRACKMOD NO regardless of the value specified.