Option XCU. Index Cleanup

Use the Index Cleanup panel to display information about index cleanup activities in the Db2 catalog.

Select option XCU on the System Catalog panel to display the Index Cleanup panel, as shown in the following figure.

Figure 1. Index Cleanup panel (ADBP1XCU)

  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  ?  ? ?        ?

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).

The following line command is valid on this panel:

I: Provides information about the state object and timestamp information about the object cleanup.

The following columns are on this panel:

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.