PADIX—Pad new indexes

Use the Modify Pad New Indexes panel or the PADIX command to specify whether indexes are padded that have at least one varying-length column will be padded. If an index is padded, performance is improved because the data can be access from the indexes instead of the data page.

Modify Pad New Indexes panel

DDTJ DHB4 Modify Pad New Indexes
Command ===> _________________________________________________________________

 Command: CURRENT
Description . . . . . . . . : PAD NEW INDEXES

Type the new Pad New Indexes Indicator you wish to change to. Then Press Enter

Enable Padding of New Indexes
Enable Index Padding . . . . Y (Y, N)

Command syntax and parameters

image2018-12-24_12-37-37.png

Value

Description

DB2ssid

Db2 subsystem ID or the name of the Db2 data sharing group to which the command applies.

opertuneID

OPERTUNE system profile name (if OPERTUNE is running as a started task) or the batch job name (if OPERTUNE is running as a batch job).

Y

Index padding is enabled. The data that is retrieved from the index is padded with blanks to the maximum width of the column.

N

Index padding is not enabled. Db2 must retrieve data from the data page. Use this value if any of the following conditions apply:

  • Your application is sensitive to padding blanks
  • You want the index to use less space
  • You want to allow index-only retrieval with variable characters
  • You do not want the maximum possible column width to be retrieved

NORESET

The changes you request remain in effect until the Db2 subsystem is cycled.

Db2 parameter values

Field

Installation panel

CLIST parameter

ZPARM macro

ZPARM parameter

Pad indexes by default

DSNTIPE

None

DSN6SPRM

PADIX

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*