Creating a Db2 object list

Use this procedure to create a list of one or more Db2 objects on which to perform a variety of statistical functions.

From a Db2 object list, you can display BMC Software statistics, estimate space requirements, list the data sets that a database uses, and list exceptions. When you select the statistics function from the main menu, DASD MANAGER PLUS guides you through creating a Db2 object list.

To create a Db2 object list

1. On the DASD MANAGER PLUS Main Menu, select Statistics and press Enter.The Collect and Manage Statistics panel is displayed.
2. On the Collect and Manage Statistics panel, select List BMC and DB2 Statistics and press Enter.The Display Db2 Object List panel is displayed. (For an example of the panel, see Accessing-the-statistics-display-features.)

3. To specify the Db2 objects for which to perform a statistics function, type the qualified object names or a wildcard pattern in the appropriate fields and press Enter.Except for storage groups and volumes, you can list all lower-level entries that are associated with a higher-level object by specifying the database name and typing an asterisk (*) or percent sign (%) in the lower-level object fields.

   The Display Db2 Object List panel (below) lists the objects that match the information that you specified on the Db2 Object Selection panel. When you specify more than one type of object for the list, the display indents the object types according to level, with database (DB) at the highest level, table space (TS) next, and so on.

   Display DB2 Object List panel

   DEBA ------------------ Display DB2 Object List ------------ Row 1 to 13 of 22
   COMMAND ===>                                                  SCROLL ===> PAGE
   
   Please select one or more options and press Enter.
   D = Display BMC Stats    S = Space Est           I = Dataset Info by Database
   E = Display Excepts      B = Browse DB2 Stats    U = Update DB2 Stats
   Z = Zoom Full Object Name
   
   Act Source  Status Object-Type   Object Name
   -----------------------------------------------------------------------------
                      DB . . . . QZUD44
                        TS . . .   QZUD44  .QZUS0144
                          TB . .     QZU      .QZUT01_D44S01
                            IXC      QZU      .QZUX01_D44S01T01
                            IX       QZU      .QZUX02_D44S01T01
                        TS . . . QZUD44    .QZUS0244
                          TB . .     QZU      .QZUT01_D44S02
                            IXC      QZU      .QZUX01_D44S02T01
                            IX       QZU      .QZUX02_D44S02T01

   For each object, you need to know what statistics are available and whether the object still exists. The Source column provides this information, as the following table shows.

   Source column

   Value	Description
   Blank	The object exists in the Db2 catalog and has BMCSTATS statistics. For this object, BMCSTATS and Db2 catalog statistics are available.
   B	The object does not exist in the Db2 catalog (because it has been dropped), but it has BMCSTATS statistics. For this object, only BMCSTATS are available.
   C	The object exists in the Db2 catalog but does not have BMCSTATS statistics (You have not run BMCSTATS against it.) For this object, only Db2 catalog statistics are available.

   The following table shows possible values in the Status field:

   Status field

   Value	Description
   Blank	You have not entered a command against this object.
   *D	You have entered a command against this object. (See Step 4, below.)

4. In the Act field, specify a statistics operation for an object.The following table shows valid commands.

   DB2 Object list commands

   Command	Description
   D	Display BMC Software statistics.
   B	Display (browse) Db2 catalog statistics.
   U	Update Db2 catalog statistics.
   E	Display BMCTRIG exceptions.
   S	Estimate space requirements.
   I	Display a list of data sets for a database.
   Z	Zoom the contents of a long object name.