Retrieving details about accelerated tables in batch mode

You can use batch mode to retrieve details about tables.

Procedure

  1. In the Option field on the DB2 Administration Menu (ADB2) panel, specify Z, and press Enter.
    The System Administration (ADB2Z) panel is displayed.
  2. Specify AT, and press Enter.
    The DB2 Display/Manage Accelerated Tables (ADBPZMAT) panel is displayed.
  3. Specify 1, and press Enter.
    The Display Accelerated Tables (ADBPZAT) panel is displayed.
  4. Find the accelerated table whose details you want to retrieve in the Name field.
  5. Choose one of the following methods:
    • To retrieve details about a single accelerated table, specify BET in the Sel column next to the object, and press Enter.
    • To retrieve details about all the accelerated tables, issue the BET command in the Command line, and press Enter.
    The JCL is generated. For more information, see Figure 1.

    The PARMS section shows parameter usage for accelerated tables, as shown in the following example:

    //PARMS    DD *                                                         
TYPE='AT' QUAL='HLDEFLT' NAME='DEFAULTIF_N_LOAD' ACCELERATOR='IDAAZ01';
TYPE='AT' QUAL='HLDEFLT' NAME='DEFAULT_FIELDS' ACCELERATOR='IDAAZ01'; 
TYPE='AT' QUAL='HLDB0001' NAME='HLDB01T1' ACCELERATOR='IDAAZ01';
TYPE='AT' QUAL='HLDB0008' NAME='HLDB01T3' ACCELERATOR='IDAAZ01'; 
TYPE='AT' QUAL='HLDB0009' NAME='HLDB01T3' ACCELERATOR='IDAAZ01'; 
TYPE='AT' QUAL='HLDISC' NAME='HLDISC8T' ACCELERATOR='IDAAZ01'; 
TYPE='AT' QUAL='HLDEFLT' NAME='NULLABLE_FIELDS' ACCELERATOR='IDAAZ01'; 
TYPE='AT' QUAL='HLDEFLT' NAME='NULLIF_IN_LOAD' ACCELERATOR='IDAAZ01';
TYPE='AT' QUAL='HLDBARCA' NAME='TBARC1' ACCELERATOR='IDAAZ01';
TYPE='AT' QUAL='HLDBARCB' NAME='TBARC1' ACCELERATOR='IDAAZ01';
  6. Submit the job.