By default all the attributes for an attribute group are selected from the table when the query is executed. It is however possible to change the queries SQL SELECT statement by creating a constraint name of SELECT and setting the constraint value to the SELECT statement which you desire.
Note that the value provided in the SELECT constraint is passed directly into the SQL statement which is used against the IBM Tivoli Decision Support for z/OS DB2 database. This means that the attributes referenced in the SELECT constraint value must represent the physical DB2 column names and not the attribute names of the monitoring agent. See Appendix A. Mapping attributes to the Tivoli Decision Support for z/OS DB2 database to view the DB2 table names and column names for all of the monitoring agents corresponding attribute groups and attributes.
Below shows example uses of the SELECT constraint:
For simplicity in your queries, we recommend you use the SELECT constraint only if you cannot achieve the desired query through use of the filters as described at the top of this chapter.
[ Top of Page | Previous Page | Next Page | Contents ]