Exit C2090-617 DB2 10 System Administrator for z/OS
Question 3 of 5
0% complete
Q3 Single choice

You have implemented hash access on a production table. In order to optimize hash access performance you need to monitor the storage space utilized by hash access.

How would you accomplish this?

  • A

    View real time statistics for the table.

  • B

    Run RUNSTATS with the UPDATE SPACE option.

  • C

    Issue the -DISPLAY DATABASE(*) SPACENAM(*) USE command.

  • D

    Utilize a monitoring profile using the -DISPLAY PROFILE command.