IBM PureData System for Analytics, Version 7.1

Setting an automatic refresh interval

About this task

You can manually refresh the current (System or Database) view by clicking the refresh icon on the toolbar, or by choosing Refresh from a menu. In addition, you can specify that both views are to be periodically automatically refreshed, and the refresh interval. To do this:

Procedure

In the main menu, click Tools > Options
In the Preferences tab, enable automatic refresh and specify a refresh interval.

Results

The refresh interval you specify remains in effect until you change it.

To reduce communication with the server, the NzAdmin tool refreshes data based on the item you select in the left pane. The following table lists the items and corresponding data that is retrieved on refresh.

Table 1. Automatic refresh
Selected item	Data retrieved
Server (system view): SPA Units SPA ID n SPU units	All topology and hardware state information.
Event rules	Event rules.
Individual statistic such as DBMS Group	Specific statistic information.
Server (database view)	All databases and their associated objects, users, groups, and session information.
Databases	All database information and associated objects.
Database <name>	Specific database, table, and view information.
Schemas	All schemas within a database (for systems that support multiple schemas).
Schema <name>	Specific schema, table, and view information.
Tables	Table information.
Views	View information.
Sequences	Sequences information.
Synonyms	Synonyms information.
Functions	User-defined functions information.
Aggregates	User-defined aggregates information.
Procedures	Stored procedure information.
Users	User information.
Groups	Group information.
Sessions	Session information.

If the NzAdmin tool is busy communicating with the server (for example, if it is processing a user command or doing a manual refresh), it does not perform an automatic refresh.