PrepAway - Latest Free Exam Questions & Answers

What is the appropriate method for identifying the most randomly accessed logical and physical files?

An IBM i 7.1 partition has a system ASP that has a combination of Solid State Drive (SSD) units
and Hard Disk Drive (HDD) units. The system administrator needs to permanently migrate the
logical files that are randomly accessed by the application jobs to the SSDs.
What is the appropriate method for identifying the most randomly accessed logical and physical
files?

PrepAway - Latest Free Exam Questions & Answers

A.
Query the table QSYS2/SYSIXSTAT for files with logical reads greater than U and sequence in
descending order.

B.
Use WRKACTJOB command to identify the application jobs.
For each job, select option 5=Work with, then 14.
Display open files, if active, than press Fl 1.

C.
From Performance Tools, generate a system report to an output file.
Query the output file for logical files with random reads greater than U and sort in descending
order.

D.
Trace the accessed file data using the TRCASPBAL SET(*ON) ASP(l) command.
Print the report with the command PRTTRCRPTTYPE (*FILE) QRDER(*DESC), and look for
Random Reads/sec.


Leave a Reply