Number of columns in queries

You can reduce user demand on system resources by restricting the number of columns that custom queries return.

When you use predefined queries, data is returned for all of the columns that belong to the attribute group. An attribute group can contain 50 columns. You can create custom queries to target the specific columns that contain the information that you require. For example, the OMEGAMON® for Storage Cache CU table has 28 columns. You should create a workspace that reports on storage for a large system. In particular, view information about de staging and staging rates. Create a custom query that selects the columns that contain this information and you exclude the other 26 columns from the query. In this way, you reduce the processor and memory requirements for IBM® Enterprise Portal Server and client.