Controlling log size for utilities
The REORG and LOAD LOG(YES) utilities cause all reorganized or loaded data to be logged.
About this task
For example, if a table space contains 200 million rows of data, this data, along with control information, is logged when this table space is the object of a REORG utility job. If you use REORG with the DELETE option to eliminate old data in a table and run CHECK DATA to delete rows that are no longer valid in dependent tables, you can use LOG(NO) to control log volume.
Procedure
To reduce the log size: