A database administrator created a new database from an existing full database backup image. If the
original database resided on a 64-bit AIX server and the new database was created on a different 64-
bit AIX server, which two statements are correct? (Choose two.)

Which statement is correct when describing the AUTOCONFIGURE command?

How do you turn on Self-Tuning Memory Manager (STMM)?

Which group of memory consumers can be adjusted by the Self-Tuning Memory Manager (STMM)?

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?

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?

Refer to the Exhibit.

Refer to the GET DB CFG output shown in the exhibit
Where can the db2diag.log file be found?

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?

When using SQU and JDBC applications to connect to the host DB2 database, which software license
must be registered?

You are unable to configure a data source using DB2 Discovery What are three reasons why this is
happening? (Choose three.)