Create Table Space: Type panel

Panel and field definitions

  Process   Options   Utilities   Help
                                                                                
 FM/Db2 (DFG2)              Create Table Space: Type

   Table Space Type Option
    1  1. Normal      (default)
       2. Large       (not valid if a partition size is specified)
       3. LOB         (large object table space)

 Select either non-partitioned or partitioned below

 Non-Partitioned Table Space:
    Segment size . . . . .         KB (4,8,..,64 for segmented table space)

 Partitioned Table Space:
    No. of partitions . . .        (1-254 for partitioned table space)
    Max. partition size . .        GB (blank,1,2,4,8,16,32,64)




 Command ===>                                                                  
  F1=Help      F2=Split     F3=Exit      F4=CRetriev  F7=Backward  F8=Forward
  F9=Swap     F10=Actions  F12=Cancel

Table Space Type Option

Specify the type option:

1. Normal

Identifies the table space is a normal (non-LOB) table space.

2. Large

Identifies that each partition of a partitioned table space has a maximum partition size of 4 GB. This relates to a deprecated SQL option, therefore it is preferable to use Max. Partition Size. If Large is specified, then No. of partitions must also be specified.

3. LOB (large object)

Identifies the table space as LOB table space. If LOB is specified, neither Segment size or No. of partitions can be specified.

LOB means Large Object. A LOB table space is used to store data that does not fit within a single table space page. Examples of LOBs might include such things as photographs, video files, or sound files.

Segment size

Indicates that the table space is separated and specifies how many pages are in each segment. This cannot be specified with Large, LOB or either of the partitioned table space options.

No. of partitions

Indicates that the table space is partitioned and specifies the number of partitions. This is required if Large is specified or if Max. partition size is specified with LOB or segment size.

Max. partition size

Indicates that the maximum size of each partition or for LOB table spaces, the maximum size of each data set. This requires the specification of LOB or No. of partitions. This cannot be specified with Large or Segment size.