Administration settings

On the Administration page, you can manage the following items:

  • Time travel
  • Add policies and view existing policies
  • Monitoring profile
  • Database maintenance
  • Scheduler rules
  • Destinations
  • Infrastructure monitoring
  • Advanced monitoring

Time travel

Here you can set system default data version retention time.

Network policies

On the Network policies page, you can add policies and view existing policies.

Network policies and Private link tabs are applicable only for Azure.

To add network policies, you must belong to the ADMINISTRATORS group.

For more information about network policies and examples, see Network policies.

Domain standards

For more information about domain standards, see Defining network policies with Classless Inter-Domain Routing (CIDR).

Adding network policies

  1. Go to Administration > Network policies.
  2. In the Add policy section, type your Classless Inter-Domain Routing (CIDR) or hostname. The IP address must conform to the domain standards.
  3. Select whether the policy is Allowed or Blocked.
  4. Click Save.

Viewing network policies

To view existing policies, go to Administration > Network policies > Existing policies.

Deleting network policies

  1. Go to Administration > Network policies > Existing policies.
  2. Select the policy that you want to delete.
  3. Click Delete.

You can select multiple policies to delete.

Monitoring profile

On the Monitoring profile page, you can do the following:

  • Monitor the performance of your system over time.
  • Collect data for historical and real time data.

To access the Monitoring profile page, go to Administration > Monitoring profile.

Maintenance

On the Maintenance page, you can perform on-demand maintenance operations and schedule recurring database maintenance. The page provides the following operations:

  • Manual vacuum — a data catalog operation that performs deep maintenance on system catalogs.

  • Schedule database maintenance — schedule recurring Grooms and Genstats maintenance windows.

Manual vacuum

Manual vacuum is a data catalog operation that physically reclaims disk space from deleted records and recreates system indexes.

System downtime is required to run a manual vacuum. All active database connections are terminated, and the system is unavailable to users and queries until the process completes and the system is restarted.

The operation typically takes 15–45 minutes, but can exceed 2 hours for heavily bloated catalogs. A catalog backup is automatically performed before the vacuum begins.

To run a manual vacuum:

  1. Go to Administration > Maintenance.
  2. In the Manual vacuum section, click Run vacuum.

Scheduling database maintenance

You can schedule recurring maintenance windows for Grooms and Genstats. Each can be configured independently with its own schedule, days, and duration.

To schedule a database maintenance window:

  1. Go to Administration > Maintenance.
  2. Under the Schedule database maintenance section, click Enable for Grooms, Genstats, or both.
  3. Set the time and timezone for each enabled operation.
  4. Select the days of the week on which the maintenance should run.
  5. Set the Duration (minutes) to specify how long the maintenance process is allowed to run.
  6. Click Save.

Scheduler rules

On the Scheduler rules page, you can view the list of scheduler rules, create a scheduler rule, activate or deactivate the rule, assign owner, rename, and remove the rule.

Creating scheduler rules

  1. Go to Administration > Scheduler rules.

  2. Click Create scheduler rule.

  3. Type a name for the scheduler rule.

    The name must be unique across all global object names. For example, database names and user group names. The name of the rule determines when the rule is evaluated in relation to other active rules.

  4. Select the type of your scheduler rule.

    The scheduler rule can be Standard or Advanced.

  5. Add conditions.

    For any rule to be triggered, all of the conditions must be met. If you do not set any conditions, the rule applies to all plans. The action is taken as a result of the rule.

  6. Add actions.

    You can add only one action for a scheduler rule.

  7. If you want the rule to control administrative jobs, tick Apply to admin jobs.

  8. Tick Active to activate the rule.

  9. Click Create.

You can select View definition, Activate, Assign owner, Rename and Remove options from the overflow menu.

Destinations

On the Destinations page, you can manage storage destinations used by Netezza for backup and restore operations and other data movement tasks.

To access the Destinations page, go to Administration > Destinations.

Infrastructure

On the Infrastructure page, you can monitor system health, SPU resources, and data slice storage utilization.

To access the Infrastructure page, go to Administration > Infrastructure.

Advanced monitoring

On the Advanced monitoring page, you can analyse additional performance metrics for workload monitoring.

To enable or disable Advanced monitoring, go to Administration > Advanced monitoring and toggle the switch.