Pre-migration planning from a DB2 V8 for z/OS system to DB2 9 for z/OS system requires two
sub-system tasks to be performed or the migration process for DB2 9 you start will be terminated
immediately. Which pre-migration task must be performed?

An external stored procedure, assigned to application environment AE1, should run in parallel to a
maximum of 10 concurrent procedures. Which action will achieve this?

Which statement about migrating a DB2 data sharing system to a new DB2 version is correct?

DSNZPARM parameter URLGWTH (UR LOG WRITE CHECK) is set to a very high value. Based
on the warning messages caused by this setting, it is determined that a local thread that normally
runs in a very short period of time has been completing changes for an excessively long period of
time without a commit. The thread needs to be removed from the system with minimal log access.
Which action should be taken to resolve the issue?

Your accounting report shows that a large component of class 3 wait time for an application is
service task switch time. For which type of contention should you be looking?

Which single DB2 system parameter must be enabled to allow system level backups to be used
for object level recovery?

Which online or stand-alone utility can be used to reset a page set level-id?

A system is running low on active logs and you need to add active logs to provide some relief.
What would be the appropriate action to achieve this?

DB2 commands in data sharing can have a scope of group or a scope of member. Which
three commands have a scope of member? (Choose three.)

You want to audit activity against a table named owner.TABLEX. Which two actions are required?
(Choose two.)