Modes

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

You can choose different modes when running the Groom Table operation.

RECORDS READY: Reclaims and reorganizes records in the tables that were not groomed, as well as those previously groomed but marked for regrooming. This is the default setting for clustered base tables (CBT).
RECORDS ALL: Reclaims and reorganizes all records in a table. This is the default for a non-CBT.
PAGES ALL: Identifies and marks the data pages in the table with no visible record as Empty to free up disk extents.
PAGES START: Identifies and marks the leading data pages in the table with no visible record as Empty. Stops when it finds a non-empty data page.
VERSIONS: Migrates records from previous table versions. Dropped columns do not appear and added columns show default values.