• Description: DB2 9 Database Administrator for Linux UNIX and Windows Upgrade
• Passing Score: 0%
• Practice Test - Number of questions: 53 questions
• Simulation Test - Number of questions: 53 questions
• Simulation Test Duration: 120 minutes
• Has explanations: No

The instance impact policy (UTIL_IMPACT_LIM Database Manager configuration parameter) for a instance named DB2INST1 is 70. Which two options will set the impact of a RUNSTATS utility to 50 percent? (Choose two.)

Answer(s)

1. RUNSTATS ON TABLE db2samp.sales;
2. RUNSTATS ON TABLE db2samp.sales UTIL_IMPACT_PRIORITY 50;
3. RUNSTATS ON TABLE db2samp.sales UTIL_IMPACT_PRIORITY;
4. RUNSTATS ON TABLE db2samp.sales UTIL_IMPACT_LIM 50;
5. RUNSTATS ON TABLE db2samp.sales UTIL_IMPACT_LIM;

RUNSTATS ON TABLE db2samp.sales UTIL_IMPACT_PRIORITY 50;

RUNSTATS ON TABLE db2samp.sales UTIL_IMPACT_PRIORITY;