Load accelerator table options

Edit online

The Db2 Automation Expert load accelerator table utility builds JCL and control cards to reload IBM® Db2 Analytics Accelerator for z/OS® tables that have been triggered through exception processing.

IBM Db2 Analytics Accelerator for z/OS is a combined hardware and software solution that can reduce response times for Db2 for z/OS database queries by using accelerator tables. You can use the Db2 Automation Expert utility to reload the accelerator tables when they need to be reloaded as defined by exception criteria in an exception profile.

To reload IBM Db2 Analytics Accelerator for z/OS-enabled objects, you must have a job profile with the following:

An object profile that contains the IBM Db2 Analytics Accelerator for z/OS-enabled objects.
An exception profile that specifies at least one of the three IBM Db2 Analytics Accelerator for z/OS exception conditions.

Note: The utility starts one or more instances of SYSPROC.DSNUTILU. DSNUTILU must be installed and configured properly on Db2 for z/OS. This includes setup of the WLM application environment for Db2-supplied stored procedures and for IBM Db2 Analytics Accelerator for z/OS. For more information, refer to the information about defining WLM performance goals for IBM Db2 Analytics Accelerator for z/OS stored procedures in the IBM Db2 Analytics Accelerator for z/OS Installation Guide.

Figure 1. Load Accelerator Table Options panel

 AUTOXPRT V1R1 ------ Load Accelerator Table Options ----- 2023/10/20  14:30:43 
 Option   ===>                                                                  
                                                                                
   Creator: TWUSR      Name: UTILITY PROFILE                  User: TWUSR       
                                                                                
   Enter the options to associate with this utility profile                     
                                                                                
    Exception Rule . . . . . . . . A (A - Accepted, R - Rejected, B - Both)     
    Lock Mode  . . . . . . . . . . S (S - tableSet, T - Table, P - Partitions   
                                      N - None, R - Row)                        
                                                                                
   Optional Skeletals          -BEFORE-     -AFTER-                             
    JCL Skeletal . . . . . . .          . .          (8 Character Name)         
    Control Cards Skeletal . .          . .          (8 Character Name)         
    Step End Skeletal  . . . .          . .          (8 Character Name)

The following describes the options that you can set:

Exception Rule

Enter A in this field to have the utility act on all objects that are accepted (included) as a result of exception processing. Enter R to have the utility act on objects that are rejected (excluded) as a result of exception processing. Enter B to have the utility act on all objects, regardless of exception processing results.

Lock Mode

Specify the protection level while the tables that are on an accelerator are being loaded. The protection level ensures a consistent state of the data with respect to the specified entity. Enter one of the following:

S - Protects all tables to be loaded against change during the load operation.
T - Protects only the table that is currently being loaded.
P - Protects the table space partition containing that part of the table that is currently being loaded. With this setting, an non-partitioned table is always completely locked.
N - None or no locking at all. However, only committed data is loaded into the table, because the Db2 data is unloaded with isolation level CS and SKIP LOCKED DATA.
R - Protects only the row or page that is being loaded against updates. Db2 data is unloaded with isolation level CS, but in comparison to lock mode NONE, rows that are locked by an application are not skipped.
Note: Using this lock mode has many implications, especially as related to incrementally updated tables. Contact IBM Software Support before using this setting.

Optional Skeletals

These fields can be used to customize the JCL generated by Db2 Automation Expert. You can add your own skeletons that can be processed before or after the utility JCL. For more information on using these fields, refer to Using the optional skeletons.