PrepAway - Latest Free Exam Questions & Answers

Which action would relieve this situation?

Your non-data sharing DB2 has a current system parameter DSMAX value of 10,000 and has only
page sets with the CLOSE YES attribute. In DB2 statistics reports, you encounter many openings
and closings of the VSAM data sets. Which action would relieve this situation?

PrepAway - Latest Free Exam Questions & Answers

A.
Alter the page set attributes to CLOSE NO.

B.
Double the system parameter DSMAX value.

C.
Double the JCL parameter DYNAMNBR in DBM1 procedure.

D.
Increase the system parameters values for PCLOSEN and PCLOSET.


Leave a Reply