Changing options for change functions

You can specify certain settings that are common to change functions in Db2® Admin Tool, such as ALT and Compare. For example, you can specify whether to recreate accelerated tables, whether to unload tables during the analyze step, and the order in which objects are processed. These settings and more are listed on the Options for Change Functions (ADB2PCO) panel.

Procedure

To change these options:

On the DB2 Administration Menu (ADB2) panel, specify option P, and press Enter.
On the DB2 Admin Options (ADB2P) panel, specify option CH, and press Enter.

On the Options for Change Functions (ADB2PCO) panel, change the values as needed. For detailed information about each field, see the help (PF1).

Figure 1. Options for Change Functions (ADB2PCO) panel

ADB2PCO n                   Options for Change Functions                  14:19
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 PBR RPN to PBR changes . . . . . NO   (Yes/No. Default is No) 
DB2 release number . . . . . . . . . . 1215 (Use VVRM format)                  
DB2 function level . . . . . . . . . . 504  (E.g. 100, 500, 501, 5nn)    
GRANT processing order . . . . . . . . C    (C - CREATE prefix for GRANT       
                                             P - POSTUTIL prefix for GRANT     
                                             Default is C )                    
Auto view regenerate . . . . . . . . . NO   (Yes/No. Default is No) 
Ignore source column order . . . . . . NO   (Yes/No. Default is No)
Generate hidden ROWID columns  . . . . NO   (Always, Only, No. Default is No)