Reading all pfs in production lib. using cl pgm
Dear all, I want to write a cl program under following scenario. 1. Use the command DSPFD to build a list of files existing in LIBA.(which is Prod Lib.) 2. Read the file. 3. Use Command RGZPFM to reorganize Every File that has more than 1000 deleted records Run the job and then DSPFD again [...]

Answer Question   |  March 31, 2012  3:13 AM
CL programs, CL/400, DSPFD, RGZPFM

RGZPFM with ALWCANCEL(*YES)
We want to reorg our files to reclaim deleted record space. Since for High Availability, all our files our journaled, we run RGZPFM with ALWCANCEL(*YES) to minimize planned downtime reorgs. If journal receivers take up more space than the amount of storage we save from reclaiming deleted record space, then there really is no point [...]

Answer Question   |  May 5, 2011  8:04 PM
IBM i, Journaling, RGZPFM, V7R1

DB2/400
Hello Guys, In DB2/400 even after we delete record from file, the record exists until we are done with RGZPFM. The deleted record can be identified by a indication field with value “Y” or “N”. How to see this indicator field? How to see the DB2/400 RRN (Relative record number)field? I tried with RUNQRY command, [...]

Answer Question   |  July 22, 2009  11:37 AM
DB2, DB2/400, DB2/400 RRN, Relative Record Number, Reorganize Physical File Member, RGZPFM, RRN, RUNQRY

RGZPFM vs Reusing Deleted Records
Does anyone have an opinion on using one over the other? I am familiar with RGZPFM and it’s benefits but am not familiar with the PF option of reusing deleted records…I would think it would be better to reorganize the file rather than reusing deleted records becuase you could have a lot of deleted records [...]

Answer Question   |  October 27, 2008  5:27 PM
DASD, REUSEDLT, RGZPFM, Space allocation

Necessity of RGZPFM after RMVPFM
Need to know After RMVPFM on PF is it necessary to do RGZPFM

Answer Question   |  July 31, 2008  11:42 AM
RGZPFM, RMVPFM

Cannot end RGZPFM on V5R4 (Journaled file)
Batch job RGZPFM on V5R4 not complete after 3 days. I issued an ENDJOB, and job is not completely ended 1.5 days later. The file is journaled and is very large. SBMJOB CMD(RGZPFM FILE(MYLIB/MYFILE) KEYFILE(*NONE) ALWCANCEL(*YES) LOCK(*SHRUPD)) How can I end this job? If MYFILE is damaged, I can delete it and restore it from [...]

Answer Question   |  March 8, 2010  8:22 PM
AS/400, AS/400 performance, DB2 Universal Database, ENDJOB, Journaling (Exchange), Recovery, REUSEDLT, RGZPFM, RPG, V5R4