Enabling and disabling automatic recreate, reload, or removal of accelerated tables

You can specify whether you want the accelerator to automatically detect changes in Db2 accelerated tables, such as changes to the table definition or dropping data from the Db2 catalog. This feature helps you push Db2 changes to the accelerator automatically and ensures that the table definition and data are synced between Db2 and the accelerator.

Procedure

  1. On the DB2 Administration Menu (ADB2) panel, specify option P, and press Enter.
  2. On the DB2 Admin Options (ADB2P) panel, specify CH, and press Enter.
  3. On the Options for Change Functions (ADB2PCO) panel, specify YES for the following options on this panel to run the described actions:
    Recreate accelerated tables
    Removes and adds Db2 tables to the accelerators when these tables are dropped and recreated on a Db2 subsystem during an object comparison operation. This feature updates Db2 table definition changes on the accelerator, including distribution or organizing key information that was previously specified for the accelerated tables.
    Reload accelerated tables
    Reloads Db2 data into the accelerated table when a Db2 table is dropped and recreated during an object comparison operation. This option works in conjunction with the Recreate accelerated tables option, which updates only the definition changes.
    Remove deleted tables from accelerator
    Removes tables from the accelerator when tables are dropped from Db2 using change management.

    These options operate on existing accelerated tables that are involved in Db2 alter or drop operations.

    Figure 1. Options for Change Functions (ADB2PCO) panel
    Start of change
    ADB2PCO n              Options for Change Functions                     19:13
Command ===> 
                                                         DB2 System: DD1A 


Recreate accelerated tables  . . . . . YES (Yes/No. Default is Yes) 
Restore replication of tables  . . . . YES (Yes/No. Default is Yes) 
Reload accelerated tables  . . . . . . YES (Yes/No. Default is Yes) 
Restore acceleration of tables . . . . YES (Yes/No. Default is Yes) 
Remove deleted accelerated tables  . . YES (Yes/No. Default is Yes)

Load accelerated tables LOCKMODE . . . NONE       (Default is TABLESET)       
Load accelerated tables DETECTCHANGES  DATA       (Default is DATA)  
Unload altered tables  . . . . . . . . NO   (Yes/No/Des. Default is YES)        
Preserve all data  . . . . . . . . . . YES  (Yes/No. Default is YES)          
 
Enable WSL authorization switching . . NO  (Yes/No. Default is No) 
Object processing order  . . . . . . . H   (T - Object type, H - DB hierarchy. 
                                            Default is H) 
Statement validation exit name . . . .          (Name of EXEC used to validate
                                                 statements in WSL Validate) 
Allow PBR2 to PBR changes . . . . . .  NO  (Yes/No. Default is No) 
DB2 release number . . . . . . . . . .     (Use VVRM format)
DB2 function level . . . . . . . . . . 502 (E.g. 100, 500, 501, 5nn) 
GRANT processing order . . . . . . . . C   (C - CREATE prefix for GRANT 
                                            P - POSTUTIL prefix for GRANT 
                                            Default is C )
    End of change