9.7.7 LIST

Purpose

The LIST command displays attributes for database server objects. Objects displayed are identified by name or by filters. The attributes displayed for each object are determined by the specified attribute list.

Syntax

LIST object_type  [ name |  attribute_filters] [attribute_list] 
[DETAIL] [ORDER BY order_by_attribute_list] [LIMIT integer]

Usage Notes

  • object_type can be the following:

    • ALERTDEFINITION
    • ALERTHISTORY
    • DBSERVER
    • IBPORT (not available in user domain (domU) environments)
    • LUN (not available in user domain (domU) environments)
    • METRICCURRRENT
    • METRICDEFINITION
    • METRICHISTORY
    • PHYSICALDISK (not available in user domain (domU) environments)
    • ROLE
    • THRESHOLD
    • USER

  • Using LIST with only an object_type (without the DETAIL option or an attribute list) displays the names of the existing objects of this type and a default list of attributes.

    • For an object type that has a status attribute, the object name and the status are displayed.
    • For the METRICHISTORY object type, the collection time, the object name, and value are displayed.
    • For the PHYSICALDISK and LUN object types, the ID attribute is displayed.
    • For the ALERTHISTORY object type, the time and alert message are displayed.
    • For the KEY object type, the key value is displayed.

  • The attributes displayed for each object are determined by the specified attribute list. Attribute values that are strings with embedded blank spaces or tabs must be enclosed in quotation marks.

  • Attribute filters determine the specific objects that are displayed. Because of the amount of metrics, you should use filters when using the LIST METRICCURRENT or LIST METRICHISTORY commands to narrow the output of the command.

  • In the default format without the DETAIL option, each object is displayed on a separate line, with successive attribute values separated by tabs in the order of the specified list of attributes.

  • In the DETAIL format, each attribute of a specific object is displayed on a separate line, with an attribute name followed by its value. If no attribute list is provided, then all attributes that have values are displayed. Blank lines separate each object in the display. DETAIL is similar to the ATTRIBUTES ALL option, only the format is different.

  • Attributes that are not set are not listed with the DETAIL option. However, attributes that are set to an empty value are listed with the DETAIL option.

  • ORDER BY orders the objects by attributes in ascending or descending order. The default is ascending.

  • LIMIT sets a limit on the number of objects to display.

Related Topics

Parent topic: DBMCLI Command Reference