Automatically adding space to database volume

Deployment options: Netezza Performance Server for Cloud Pak for Data System

About this task

To add space automatically with a space trigger, complete the following steps.

Procedure

  1. Repeat steps 1 through 5 of the previous procedure to display the Database and Log area.
  2. In the Database area on the Select Action list, select Create Space Trigger.
  3. Specify values for the field for the automatic database expansion trigger.
    Use the online help to obtain details about the operation of each field and setting. The key fields to set for your environment are the Begin expansion at this percentage of capacity, Expand the database by this amount, and Maximum size fields.
  4. Click OK to create the trigger.

Results

You can also create a database space trigger by using the define spacetrigger db command. For example, the following command creates a trigger that increases the size of database by 25% when it hits 85% of its capacity with no limit on maximum size:
define spacetrigger db fullpct=85 spaceexpansion=25 maximumsize=0