How do you turn on Self-Tuning Memory Manager (STMM)?
How do you turn on Self-Tuning Memory Manager (STMM)?
What will cause the creation of a column-organized table to fail?
What will cause the creation of a column-organized table to fail?
Which group of memory consumers can be adjusted by the Self-Tuning Memory Manager (STMM)?
Which group of memory consumers can be adjusted by the Self-Tuning Memory Manager (STMM)?
Which statement about expression-based indexes is true?
Which statement about expression-based indexes is true?
Which configuration parameters will allow your Saturday job to run when the scheduler is restarted?
You have a job scheduled to run every Saturday; the scheduler is turned off on Friday and then
restarted on Monday. The job scheduled for Saturday is now a job that is scheduled in the past.
Which configuration parameters will allow your Saturday job to run when the scheduler is restarted?
What are the maximum amount of system resources that the backup utility can use?
You have a UTIL_IMPACT_LIM of 50 and a UTIL_IMPACT_PRIORITY of 60 for the backup utility What
are the maximum amount of system resources that the backup utility can use?
which type of database are column-organized tables supported?
In which type of database are column-organized tables supported?
hown in the exhibit Where can the db2diag.log file be found?
Refer to the Exhibit.
Refer to the GET DB CFG output shown in the exhibit
Where can the db2diag.log file be found?
Which command will create a statistics profile on the EMPLOYEE table?
An expression-based index named EMPJND1 and a statistical view named EMP_IND1_V have
been created for a table named EMPLOYEE.
If the following command is used to set up a statistics profile on the statistical view EMP_IND1_V:
RUNSTATS ON VIEW emp_ind1_v WITH DISTRIBUTION DEFAULT UM_FREQVALUES 50 SET
PROFILE ONLY
Which command will create a statistics profile on the EMPLOYEE table?
Which minute mark will allow the next task to run?
Scheduled tasks are executed by the DB2 autonomic computing daemon (db2acd). Every five
minutes the daemon checks for new or updated tasks. If a task is scheduled to run every five
minutes and for some reason, the task takes seven minutes to complete, the daemon will not
execute another instance of the task at the next 5 minute interval.
Which minute mark will allow the next task to run?