Automatically adding space to log volume

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

About this task

To automatically add space 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 Log area on the Select Action list, select Create Space Trigger.
  3. Specify values for the field for the automatic log 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 log by this amount, and Maximum size fields.
  4. Click OK to create the trigger.

Results

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