IBM Exam C9010-030 Topic 3 Question 3 Discussion

Actual exam question for IBM's C9010-030 exam

Question #: 3
Topic #: 3

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?

A1) Login as QSECOFR start GO CLEANUP menu
2) Explicitly set reorganization process for library LIB1 and set threshold to 50%.
3) Start cleanup immediately.

B1) Start Disk Reorganization for files with 50% of deleted records for LIB1 by submitting the command STRDSKRGZ FILE(LIB1/'ALL) DLTRCD(50).

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

D1) Run DSPFD FIL E( LIB1/'ALL) TYPE(*MBR) OUTPUT('OUTFILE) FILEATRCPF) 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.

Show Suggested Answer

Suggested Answer: C

by Sharika at Dec 23, 2022, 08:47 AM

Limited Time Offer

25%

Off

Get Premium C9010-030 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!