Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see DASD MANAGER PLUS for DB2 13.1.

DB2 column statistics

The Column Selection panel lists the columns in the specified table. The panel appears when you choose to view column statistics from the table statistics browse panels or a column selection list. You select the column for which to display statistics.

 

ASUCTCSE ------------------- Column Selection -------------- Row 1 to 13 of 21
COMMAND ===>                                                  SCROLL ===> PAGE
                                                                             
Type S and press Enter to select object.                                       
                                                                              
Table Name : QZU.QZUT01_DA1S01                                                 
                                                                             
Act Column Name                                 Card  High2key    Low2key     
-------------------------------------------------------------------------------
    COLUMN_1                                    2036     Ø.ó       Ø.7     
    COLUMN_10                                   1952     Ø.?î       Ø IÍ     
    COLUMN_11                                      1     Ø          Ø        
    COLUMN_12                                      1 Ø          Ø            
    COLUMN_13                                      1     ....       ....   
    COLUMN_14                                      2       ..         ..   
    COLUMN_15                                   2036 .... ...   .... ..î

To display the DB2 catalog statistics for a column

  1. Type S in the Act field beside the column name and press Enter.The Column Statistics Browse panel appears:

     

     DEBA ------------------------ Column Statistics Browse ------------------------
     COMMAND ===>
                                                                                   
     Column Name: CITYSTATE
     Table Name :  ZZU. ZZUT12_D34S01
                                                                                   
     -------------------------------------------------------------
     |               DB2 Catalog     |  BMCSTATS                 |
     | Cardinality  :        91      |        91                 |
     |                               |                           |
     | High2key . . :  WEST ORA      |  WEST ORA                 |
     |                 ECEE4DDC      |  ECEE4DDC                 |
     |                 65230691      |  65230691                 |
     |                               |                           |
     | Low2key  . . :  ALLENTOW      |  ALLENTOW                 |
     |                 CDDCDEDE      |  CDDCDEDE                 |
     |                 13355366      |  13355366                 |
     -------------------------------------------------------------

    The product obtains the DB2 catalog values from the SYSIBM.SYSCOLUMNS catalog table. The BMCSTATS values come from the corresponding statistics table in the DASD MANAGER PLUS database and are the values from the last run.

    Note

    Note the following additional considerations about the High2key and Low2key columns:

    • The product obtains the values for High2key and Low2key from the SYSIBM.SYSCOLUMNS table and the corresponding table in the DASD MANAGER PLUS database, and displays the decimal and hexadecimal values. If the column has a noncharacter data type, you might not be able to print the data.
    • The online display of the High2key and Low2key columns is truncated to 8 characters.
  2. Press END to return to the previous panel.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*