Loading accelerated tables

You can load Db2 table data into the accelerator after its definition has been copied to the accelerator.

To load accelerated tables:

1. On the DB2 Administration Menu (ADB2) panel, specify option Z, and press Enter.
2. On the System Administration (ADB2Z) panel, specify option AT, and press Enter.
3. On the DB2 Display/Manage Accelerated Tables (ADBPZMAT) panel, specify any filters for the tables you want to display by entering selection criteria:

   ADBPZMAT ----------- DD1A Display/Manage Accelerated Tables ------------ 16:13
   Option ===>  1                                                                 
                                                                                  
                                                                                  
   1 - Display accelerated tables                           DB2 System: DD1A      
                                                            DB2 SQL ID: ADM001   
                                                                                  
   Enter display selection criteria.  Settings: LIKE operator;  Criteria not saved
   Name . . . . . . .                               > Created by  . .           > 
   Schema . . . . . .           >                     Accelerator . .           >  
   Enabled  . . . . .                                 Archived  . . .             
   Created within . .
   Altered within . .       
   Refreshed within .                     
    

4. Specify option 1, and press Enter.
5. On the Display Accelerated Tables (ADBPZAT) panel, specify the L line command to load the data of a selected table.
   The LOAD primary command loads the data of all of the selected tables.

   Note: You can load the table data to the accelerator in batch to reduce wait time. To run batch, specify YES for Run Accelerator functions in batch on the Admin Defaults (ADB2P2) panel.

   ADBPZAT n ----------- DD1A Display Accelerated Tables -------- Row 1 to 1 of 1 
    Command ===>                                                  Scroll ===> PAGE 
                                                                                   
    Commands: RTS  ADD  LOAD  ENABLE  DISABLE  BET  DET  DEL  DISPOPT  DISPINFO
              RTSO   RT   
    Line commands:                                                    
      I - Interpret  AC - Accelerator  T - Table  RTS - RTS info  L - Load         
     AR - Archive  EN - Enable  DI - Disable  DEL - Delete  DET - Table details     
     RT - Invoke RUNSTATS  ? - Show all line commands     
                                                  
         Table             Table    Server       Remote   Remote                   
    Sel  Name              Schema   Name     E A Name     Schema   Refresh Time    
         *                 *        *        * * *        *        *               
    ---- ----------------- -------- -------- - - -------> -------- --------------->
         TBOC5I03          SYSADM   V1       Y   TBOC5I03 SYSADM   2013-08-21-06.28.