How big should a file be to use REORG or OLREORG?
search cancel

How big should a file be to use REORG or OLREORG?

book

Article ID: 93304

calendar_today

Updated On:

Products

Datacom DATACOM - AD Datacom/AD Datacom/DB Datacom/Server

Issue/Introduction

What is the minimum number of records a file should have that would make it worthwhile to perform an OLREORG  or REORG instead of DBUTLTY BACKUP and LOAD? I have an almost static file with only 10,00 records. Is it worth to use OLREORG?

Environment

Datacom

Resolution

For small areas we do not recommend to use the OLREORG or REORG utilities.
Use DBUTLTY BACKUP and LOAD instead.
An area with10,000 records would be considered to be small.

When to Use REORG