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 theDETAIL
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
andLUN
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.
- For an object type that has a
-
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
orLIST 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 theATTRIBUTES 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 theDETAIL
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.