1
  • How to find indicator and relative record number fields in DB2/400

    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...

    BibinGeorge130 pointsBadges:
  • 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 to check...

    6r1,590 pointsBadges:
  • 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...

    bogeybetsy560 pointsBadges:
  • 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...

    AS400DBA15 pointsBadges:
  • 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...

    LSwanKayla20 pointsBadges:
  • Necessity of RGZPFM after RMVPFM

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

    Monishjadhav5 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following