Create Table Space: Data Storage Options panel

Panel and field definitions

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

 Data Storage Options:
     Enter '/' to select option
        Use data compression
     /  Close when not in use
        Erase data on delete
     /  Define dataset now
        INSERT uses clustering index
     /  Track modified pages
     /  Log changes to LOB columns

 Encoding Method:
     Data Encoding
        1. EBCDIC
        2. ASCII


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

Use data compression

This corresponds to the COMPRESS YES/NO clause. COMPRESS YES means that Db2® stores the data in compressed format.

Close when not in use

This corresponds to the CLOSE YES/NO clause. It relates to how Db2® handles open data sets when the limit for the maximum number of open data sets is reached.

Erase data on delete

This corresponds to the ERASE YES/NO clause of the 'USING' block (see DB2 for z/OS SQL Reference). ERASE YES means that Db2® data sets are overwritten with binary zeros when they are dropped (deleted).

Define dataset now

This corresponds to the DEFINE YES/NO clause. DEFINE YES means that Db2® defines the data sets for the table space when the create statement is executed. DEFINE NO means creation is delayed until data is placed in the table space.

INSERT uses clustering index

This corresponds to the MEMBER CLUSTER clause.

Track modified pages

This corresponds to the TRACKMOD YES/NO clause. It relates to a feature where changes to data pages are recorded in the table space map pages. The default setting is TRACKMOD YES. There are restrictions on this clause when LOB is specified.

Log changes to LOB columns

This corresponds to the LOG YES/NO clause. LOG YES can only be specified for a LOB table space.

Data encoding

Covers the encoding method option. For OS/390® systems, the default format is EBCDIC .

EBCDIC

Specifies the encoding scheme.

ASCII

Specifies the encoding scheme.

UNICODE

Specifies the encoding scheme.