Online index REORG options that can be set for indexes include share level options, retries and timeouts, switch times, and deadlines.
About this task
To set online REORG options, enter Y in both the Online ReorgInclude and Update fields and press Enter. The Online Reorg Index Options panel is displayed, as shown in the following figure:Figure 1. Online Reorg Index Options panel
AUTOXPRT V1R1 -------- Online Reorg Index Options ------- 2023/10/20 13:16:34
Option ===>
Creator: TWUSR Name: DB2 V13 User: TWUSRA
Db2 Subsystem: SS01
Enter the options to associate with this utility profile
Sharelevel . . . . . . . . . . C (R - Reference, C - Change, N - None)
Drain Wait . . . . . . . . . . (blank, 0-1800 seconds)
Retry . . . . . . . . . . . . (blank, 0-255)
Retry Delay . . . . . . . . . (blank, 1-1800 seconds)
Force . . . . . . . . . . . . N (A - All, R - Readers, N - None)
Timeout . . . . . . . . . . . T (A - Abend, T - Term, N - No)
Include Update
Deadline Options . . . . . . . N (Yes/No) . . . . . . . N (Yes/No)
Switchtime Options . . . . . . Y (Yes/No) . . . . . . . N (Yes/No)
Shrlevel Change Options . . . Y (Yes/No) . . . . . . . N (Yes/No)
Procedure
Specify the level of access that you want to have to your data during reorganization in the Sharelevel field.
Valid values are C for change (applications can read and write data during the REORG); R for reference (applications can read but not write data during the REORG); or N for none (applications can neither read or write data during the REORG).
If you entered C or R in the Sharelevel field, enter Y in the Include/Update Deadline Options fields and press Enter.
On the Online Reorg Index options panel, specify other fields as required. Refer to the help panel for detailed information about the fields on this panel.