Viewing accelerated table details

You can create reports that show details for each accelerated table, including change and archive information for the entire table or in the case of partitioned tables, for each partition.

About this task

As an alternative to this procedure, you can view accelerated table information by using the commands on Display Accelerated Tables (ADBPZAT) panel. See Displaying accelerator tables.

Procedure

  1. On the DB2 Administration Menu (ADB2) panel, specify option Z, and press Enter.
  2. On the System Administration (ADB2Z) panel, specify option AC, and press Enter.
  3. On the DB2 Accelerators (ADBPZAC) panel, specify the DET command, and press Enter.

    The Accelerated Table Details (ADBPD) panel is displayed. The following example panel is for a partitioned table.

    Figure 1. Accelerated Table Details (ADBPD) panel
    ADBPD  ----------------- DB2X Accelerated Table Details -------------- 05:39
Command ===>                                                                   
     
Commands: SAVE  ZOOM                                                                          
_ Details for accelerated table (label): SCADI901.SALES          
                                                               
  Part info type . . . : BY_RANGE
  Column name  . . . . : COL1

_ Part no : 2
   Logical no  . . . . : 1
   Limit key value . . : 2011-10-31
  
   Change information  :
     Category  . . . . : RELOAD_RECOMMENDED
     Last load TS  . . : 2012-01-09T11:53:27.997141Z
     Type  . . . . . . : DataUpdated
     Shared tablespace : No
     Data size . . . . : 105 MB

   Archive information :
     Timestamp . . . . : 2012-01-09T11:53:27.997141Z
     Data size . . . . : 105 MB
     Backup image  . . : ARCHIVE.DA11.DB000022.CUSTOMER.P0003
 
_ Part no : 3
   Logical no  . . . . : 2
   Limit key value . . : 2011-11-31
   
   Change information  :
     Category  . . . . : RELOAD_REQUIRED
     Last load TS  . . : 2012-01-09T11:53:27.997141Z
     Type  . . . . . . : PartitionAddedOrRotated
     Shared tablespace : No
     Data size . . . . : 105 MB

_ Part no : 4
   Logical no  . . . . : 3
   Limit key value . . : 2011-12-31
  
   Change information  :
     Category  . . . . : UNKNOWN
     Last load TS  . . : 2012-01-09T11:53:27.997141Z
     Type  . . . . . . : DataUpdated
     Shared tablespace : Yes
 
_ Part no : 5
   Logical no  . . . . : 4
   Limit key value . . : 2012-01-31
   
   Change information  :
     Category  . . . . : NONE
     Last load TS  . . : 2012-01-09T11:53:27.997141Z
     Type  . . . . . . : NoChangeDetected
     Shared tablespace : Yes
.
.
.
    Figure 2. Accelerated Table Details (ADBPD) panel

    For non-partitioned tables, information is displayed for the entire table instead of the individual partitions, as shown in the following figure:

    ADBPD  ----------------- DB2X Accelerated Table Details -------------- 05:39
Command ===>                                                                   
                                                                               
_ Details for accelerated table (label): SCADI901.SALES          
                                                               
   Change information  :
     Category  . . . . : RELOAD_RECOMMENDED
     Last load TS  . . : 2012-01-09T11:53:27.997141Z
     Type  . . . . . . : DataUpdated
     Shared tablespace : No
     Data size . . . . : 105 MB

   Archive information :
     Timestamp . . . . : 2012-01-09T11:53:27.997141Z
     Data size . . . . : 105 MB
     Backup image  . . : ARCHIVE.DA11.DB000022.CUSTOMER.P0003