Kbase P49314: How to re-use deleted records when DB2/400 file becomes very large?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
9/3/2004 |
|
Status: Verified
GOAL:
How to re-use deleted records when DB2/400 file becomes very large?
FACT(s) (Environment):
IBM AS/400 (RISC)
FIX:
It is advisable to turn on the REUSEDLT option of the physical file if it is often accessed sequentially. Otherwise, the only option would be running RGZPFM (reorganize physical file member) periodically.
It will have a positive impact on the performance in the long run.