You can display information about the tables that are associated with an accelerator,
including both accelerator-shadow tables and accelerator-only tables.
Procedure
To display accelerated tables:
On the DB2 Administration Menu (ADB2)
panel, specify option
Z, and press Enter.
On the System Administration (ADB2Z)
panel, specify option AT, and press Enter.
On the DB2 Display/Manage Accelerated Tables
(ADBPZMAT) panel optionally specify any filtering selection criteria. Then specify option
1, and press Enter.
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 .
The Display Accelerated Tables (ADBPZAT)
panel is
displayed:Figure 2. Display Accelerated Tables (ADBPZAT)
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
Line commands:
I - Interpret AC - Accelerator T - Table RTS - RTS info L - Load
AR - Archive EN - Enable DI - Disable DEL - Delete DET - Table details
? - 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.
Use the following commands to display additional information:
DISPINFO
This primary command displays replication status and row count on the panel, as follows: Figure 3. Display Accelerated Tables (ADBPZAT)
panel after DISPINFO command is
issued
ADBPZAT n ----------- DD1A Display Accelerated Tables ------ Row 1 to 11 of 50
Command ===> Scroll ===> PAGE
Commands: RTS ADD LOAD ENABLE DISABLE BET DET DEL DISPOPT DISPREF
Line commands:
I - Interpret AC - Accelerator T - Table RTS - RTS info L - Load
AR - Archive EN - Enable DI - Disable DEL - Delete DET - Table details
? - Show all line commands
Table Table Server Row
Sel Name Schema Name E R A Count Refresh Time
* * * * * * * *
---- ----------------- -------- -------- - - - -------- ---------------------->
TBOC5I03 SYSADM V1 Y N120 2013-08-21-06.28.00.349
To
restore the original display, specify REFRESH or DISPREF.
DET
This line command generates a detail report online for the accelerated table.
BET
This line command generates a batch job that will create a detail report for the accelerated
table.
I
This line command displays details for the accelerated table on the Interpretation of an Object in
SYSACCELERATEDTABLES (ADBPZATI) panel:Figure 4. Interpretation of an Object in
SYSACCELERATEDTABLES (ADBPZATI) panel
ADBPZATI --- DD1A Interpretation of an Object in SYSACCELERATEDTABLES ---- 13:14
Command ===>
Details for accelerated table (label): SYSADM.TBOC5I03
Table name . . . : TBOC5I03
Table schema . . : SYSADM
Server name . . . : V1
Accel status . . : Yes
Archive status . : Blank - Not archived
Remote name . . . : TBOC5I03_ID1
Remote schema . . : SYSADM
Created by . . . : SYSADM
Support level . . : 3 - Version of the DB2 accelerator server
Created TS . . . : 2013-08-21-06.28.00.349477
Altered TS . . . : 2013-08-21-06.28.00.349477
Refresh Time . . : 2013-08-21-06.28.00.349477
Replication status: No
Row count . . . . : 120
DISPINFO