Which registry variable should be used to specify that 20 percent of each index page is to be left as as free
space when building any index in any database?
A.
DB2_INDEX_DEFAULT
B.
DB2_EXTENDED_OPTIMIZATION
C.
DB2_INDEX_PCTFREE_DEFAULT
D.
DB2_ENABLE_AUTOCONFIG_DEFAULT
This registry variable specifies what percentage of each index page to leave as free space when building the index. The setting for DB2_INDEX_PCTFREE_DEFAULT is overridden if you explicitly specify the PCTFREE clause on the CREATE INDEX statement. The registry variable does not affect the LEVEL2 PCTFREE clause on the CREATE INDEX statement.
0
0