How can the administrator achieve this?

A programmer ran a database purge over files in LIB1 and deleted a large number of records.
An administrator now needs to remove the deleted records from files with the greatest number of deleted records.
How can the administrator achieve this?
A. 1) Login as QSECOFR start GO CLEANUP menu
2) Explicitly set reorganization process for library LIB1 and set threshold to 50%.
3) Start cleanup immediately.
B. 1) Start Disk Reorganization for files with 50% of deleted records for LIB1 by submitting the command STRDSKRGZ FILE(LIB1/*ALL) DLTRCD(50).
C. 1) Start Reorganize Physical File Member menu by command GO RGZPFM.
2) Select option 1 Work with Reorganization.
3) Select option 2 Reorganize a library.
4) Start reorganization for library LIB1 and type in 50 in the threshold parameter.
D. 1) Run DSPFD FIL E( LI?1/*ALL) TYPE(*MBR) OUTPUT(*OUTFILE) FILEATR(*PF) OUTFILE (QGPL/DSPFD).
2) Based on the result file, write a query that sorts files with the greatest number of deleted records.
3) Write a CL program to read the query file and submit RGZPFM for the files.

Download Printable PDF. VALID exam to help you PASS.

One thought on “How can the administrator achieve this?

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.