You can limit the number of items returned in the queryresults on the map and list portlets of IBM? Work Optimization for Water Utilities. By defaulta maximum of 500 items can be displayed on the map or in the list.The limit is stored in the IW_CORE.PROPS table ofthe WATERDB database. To change the limit youneed to submit a database command on the IBM Intelligent Operations Center database server toupdate the required setting.

1. Log on to the IBM Intelligent Operations Center database server serveras the DB2? databaseadministrator.
2. Connect to the IBM Work Optimization for Water Utilities database byusing the following DB2 shellcommand:

   db2 connect to WATERDB

3. Update the existing map and list result limit by enteringthe following DB2 shellcommand:

   db2 "update iw_core.props set prop_val='x' where comp_id='water' and prop_id='max_list_size'"

   Where x isthe limit you would like to set. The maximum limit is 500 which isalso the default limit.

   For example to set the limit to 100items use the following DB2 shell command:

   db2 "update iw_core.props set prop_val='100' where comp_id='water' and prop_id='max_list_size'"

4. To disconnect enter the following DB2 shell command:

   db2 disconnect all

5. Restart the IBM Intelligent Operations Center application and integration server.