Running queries on table spaces without RUNSTATS

Use the performance queries function to view information about and work with table spaces that do not have RUNSTATS information.

Procedure

  1. On the DB2 Administration Menu (ADB2) panel, specify option 3, and press Enter.
    The DB2 Performance Queries panel is displayed.
  2. Locate option 1 - Table spaces without RUNSTATS within n days.
  3. If necessary, change the value of n.
  4. Specify option 1, and press Enter.

    The Table Spaces Without RUNSTATS Information (ADB231) panel is displayed, as shown in the following figure:

    Figure 1. Table Spaces Without RUNSTATS Information (ADB231) panel
     DB2 Admin --- DB2X Table Spaces Without RUNSTATS     ROW 981 TO 1,000 OF 1,000 
 Command ===>                                                  Scroll ===> PAGE 
                                                                                
 The following table spaces do not have RUNSTATS information. Consider running  
 the RUNSTATS utility on them.                                                  
                                                                                
 Commands:       R - Runstats  UT - Utilities                                   
 Line commands:  S - Select     R - Runstats                                    
                                                                                
 Select Name     Schema   DB Name  BP   L E S I C Ntable    N Active       Space
        *        *        *        *    * * * * *      *           *           *
 ------ -------- -------- -------- ---- - - - - - ------ ----------- -----------
        RGESI24S RGET     RGED001  BP0  P N A N N      1           0           0
        RGESI26S RGET     RGED001  BP0  P N A N N      1           0           0
        RGESMDAS RGET     RGED001  BP0  P N A N N      1           0           0
        RGESM01S RGET     RGED001  BP0  P N A N N      1           0           0
        RGESM02S RGET     RGED001  BP0  P N A N N      1           0           0
        RGESOEGS RGET     RGED001  BP0  P N A N N      1           0           0
        RGESOEIS RGET     RGED001  BP0  P N A N N      1           0           0
        RGESOE0S RGET     RGED001  BP0  P N A N N      1           0           0
        RGESOR1S RGET     RGED001  BP0  P N A N N      1           0           0
        RGESOS1S RGET     RGED001  BP0  P N A N N      1           0           0

    The following columns are on this panel:

    Select
    Selects a table space when you use the S line command.
    Name
    The name of the table space.
    Schema
    The name of the schema.
    DB name
    The name of the database.
    BP
    The name of the buffer pool used for the table space.
    L
    The locking size, which is one of the following values:
    A
    Any.
    P
    Page.
    S
    Table space.
    E
    The erase rule, which is one of the following values:
    Y
    Erase.
    N
    No erase.
    S
    The status of the table space, which is one of the following values:
    A
    Available.
    N
    Not available.
    I
    The indicator of whether the table space was created implicitly, which is one of the following values:
    Y
    Yes.
    N
    No.
    C
    The close rule, which is one of the following values:
    Y
    Yes.
    N
    No.
    NTable
    The number of tables defined in the table space.
    N Active
    The number of active pages in the table space. If the RUNSTATS utility was not run, the value is 0.
    Space
    Number of kilobytes (KB) of storage that is allocated to the table space. If the STOSPACE utility was not run, the value is 0.
  5. Optional: Work with the table spaces by using the primary commands and line commands.
    Tip: For table spaces that do not have RUNSTATS information, run the RUNSTATS utility on them.

    The R line command enables you to quickly move to the Batch Job Utility Parameters (ADB2UPA) panel. Entering the R line command is equivalent to entering S, UT, and R commands in succession.