DSNTIP71: SQL OBJECT DEFAULTS PANEL 2
The first entry on the DSNTIP71 panel provides a general default setting for creating table spaces. The remaining fields define default values for the system-required objects that Db2 creates automatically. Db2 uses these options for any indexes or table spaces that it implicitly creates.
DSNTIP71 INSTALL DB2 - SQL OBJECT DEFAULTS PANEL 2
===>
Enter general options for table spaces and indexes below (continued):
1 DEFAULT PARTITION SEGSIZE===> 32 For explicitly-created table spaces
(0, 4, 8, 12, ..., 56, 60, or 64)
2 PERCENT FREE FOR UPDATE ===> 0 Percent of space per page reserved
for update (AUTO or 0 - 99)
3 PAGE SET PAGE NUMBERING ===> RELATIVE For created range-partitioned
table spaces (ABSOLUTE or RELATIVE)
4 RETRY STOPPED OBJECTS ===> NO Up to IRLM timeout limit (NO or YES)
5 PAD INDEXES BY DEFAULT ===> NO Pad new indexes by default
6 INDEX MEMORY CONTROL ===> AUTO MB of space for fast index traversal
(AUTO, DISABLE, or 10 - 200000)
6a FOR SELECTED INDEXES ONLY==> NO When INDEX MEMORY CONTROL is 10 -
200000 or AUTO only (NO or YES)
7 FTB NON UNIQUE INDEX ===> YES Fast index traversal for non-unique
index (NO or YES)
8 DDL MATERIALIZATION ===> 1 1 = ALWAYS_IMMEDIATE
2 = ALWAYS_PENDING
9 DEFAULT INSERT ALGORITHM ===> 1 0=ALWAYS BASIC 1=BASIC 2=Algorithm 2
PRESS: ENTER to continue RETURN to exit HELP for more information
