IBM Support

Is it possible to run ‘groom records all’ when the databases are in ‘locked mode’ in Netezza (PDA)?

Technote (FAQ)


Question

Is it possible to run ‘groom records all’ when the databases are in ‘locked mode’ in the Netezza (PDA) appliance?

Answer

A database is typically in 'locked mode' due to it being restored and incremental backups being applied. Netezza will allow a user to run groom on tables which are inside locked database. This can be run in between the incremental restores and the next incremental restore will work fine after the groom.

Document information

More support for: PureData System for Analytics
Administration

Software version: 1.0.0

Operating system(s): Platform Independent

Reference #: 1990464

Modified date: 06 October 2016