IBM Support

GROOM should be run on target restore database as well as the source database.

Question & Answer


Question

Why is my restored database much larger than my source database?

Cause

nzbackup and nzrestore capture deleted records from the source and apply them to the target. However, if one GROOMs the source database after backups, the space occupied by the deleted records is cleaned up there, but is not applied to the target automatically.

Answer

If you see a large discrepancy between the sizes of the source and target databases, use a GROOM RECORDS ALL on the target, then re-compare them.

Note: A small discrepancy is normal when using compression, or when the source and target systems are different sizes (ex. 3 SPU system and a 12 SPU system).

[{"Product":{"code":"SSULQD","label":"IBM PureData System"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":null,"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"1.0.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
17 October 2019

UID

swg21620937