Option XCU. Index Cleanup

The Index Cleanup (ADBP1XCU) panel displays information from the Db2® catalog about index cleanup activities. To display this panel, select option XCU on the System Catalog (ADB21) panel.

The following figure shows an example of this panel:

Figure 1. Index Cleanup (ADBP1XCU) panel

  ADBP1XCU  -------------- DD1A Index Cleanup ------------------ Row 1 to 5 of 5
                                                                               
 Commands: EDIT                                                                
 Line commands:                                                                
  I - Interpret                                                                
                                                                               
              Index    E M       Start    End                                  
 Sel Database Space    D W  M  D Time     Time                                 
     *        *        * *  *  * *        *                                    
 --- -------- -------- - - -- -- -------- --------                             
     JRD      ?        D M  1  1 12.01.00 12.30.00                             
     JRD%     ?        D M  2  2 12.01.00 12.30.00                             
     JRDTEMP  ?        D M  1  1 12.01.00 12.30.00                             
     JRDZZZ   NULL     D M  1  1 12.00.01 12.00.06                             
     JRDZZZ   NULL     D M  ?  ? ?        ?

Columns

This panel displays the following columns:

Sel: Input field where you can enter one of the line commands listed on the panel. Enter a question mark (?) on a row to view all valid line commands.

Database

Name of the database that contains the index.

Index Space

Name of the index space.

ED

Enable or disable. It specifies whether the row enables or disables cleanup for the specified index space.

MW

Month and week. It indicates how the value of the DAY is interpreted:

M: The value of the DAY column is interpreted as a day of the month.
W: The value of the DAY column is interpreted as a day of the week.

M

Indicates the month in which the time window applies. If this column contains NULL, the time window applies to all months.

D

Indicates the day of the month or the week. Indicates the day of the month, if M is specified in the MW column. Indicates day of the week if W is specified in the MW column, or if the MW column is null. When this column represents the day of the week, 1 is for Monday and 7 is Sunday. If this column contains NULL, the time window applies to every day of the month or to every day of the week.

Start Time

The time of the day at which the row starts to apply cleanup. If this column contains a null value, the row applies cleanup at all times on the specified day.

End Time

The time of the day at which the row ends to apply cleanup. If this column contains a null value, the row applies cleanup at all times on the specified day.

Primary commands

The following primary command is valid on this panel:

EDIT: Enables edit of the index cleanup entries. You can delete, insert, or modify entries without having to use Db2 data manipulation language (DML).