EMT Practice Test

1. Question Content...

---

Question1: You wish to enforce a system-wide limit on the maximum number of parallel subtasks for utilities REORG TABLESPACE, REBUILD INDEX. CHECK INDEX. UNLOAD, and LOAD, to 16 parallel subtasks per utility execution.
Which action, if any will enforce this limit?

Question2: What happens in DB2 11 CM once you hit RBA x'FFF800000000' in a non-data sharing environment?

Question3: The ALTER BUFFERPOOL command specifying the AUTOSIZE(YES) option enables DB2 to use WLM services to fine tune the buffer pools.
What is the result of issuing this ALTER?

Question4: Which command can be used to adjust the system checkpoint frequency?

Question5: What will occur if the parameter PAGE PROTECT is set to YES?

Question6: What job will check for changes to DB2 that might impact your migration to Version 11 conversion mode?

Question7: DB2 can use RUNSTATS profiles for autonomic statistics maintenance.
Which catalog table holds the options specified for the profiles?

Question8: If a DB2 subsystem fails during start up in the log initialization phase, which two steps are needed in your corrective actions to minimize impact without completing a cold start?

Question9: You are facing a severe locking problem with a specific application using plan PLANB. To identify what is going on you need to start a detailed locking trace. However, you want to limit the scope of the trace somewhat to reduce the trace overhead and trace volume. (IFCID 21 traces each lock request and is part of performance trace class 7).
Which is the most appropriate command to use ?

Question10: One of your applications is experiencing long elapsed times. You notice from DB2 accounting data that
90% of the class 2 elapsed time consists of class 3 suspension time.
Which statement describes the behavior of the application?

Question11: Which utility can be used to reset the copy-pending status?

Question12: Program Authorization does NOT work in which environment?

Question13: Which statement is true regarding DB2 definitions for SMF collection?

Question14: Which DB2 system table can limit the amount of resources that can be consumed based on client or IP address of the client?

Question15: Which method can be used to set the DB2 client information (workstation name, application name..) from a JDBC application using a type 4 connection?

Question16: Having to deal with data inconsistency during a disaster recovery can significantly impact the length of time needed to recover. One of the actions that could be taken to prevent this from occurring is to not take an image copy of a data set that contains inconsistent data.
Which two options can be used to help prevent taking an image copy of inconsistent data?

Question17: What is the minimum level of authority needed to use the DETAIL keyword on a -DISPLAY THREAD command?

Question18: In an environment with a large amount of dynamic SQL, which subsystem parameter should be adjusted to increase the amount of memory available for caching statements in the global dynamic statement cache?

Question19: In order to guarantee complete security for your DB2 subsystem, which statement is correct?

Question20: Which copy operation CANNOT be performed by DSN1COPY?

Question21: Which statement regarding migration from DB2 10 for z/OS to DB2 11 for z/OS is true?

Question22: The subsystem parameter PKGREL_COMMIT is set to YES. Which statement is true for packages bound with RELEASE(DEALLOCATE)?

Question23: Which information uniquely identifies a distributed thread?

Question24: The use of the work file database for RID list processing is controlled by the value of which subsystem parameter?

Question25: A DDF thread with a token of 56 needs to be cancelled but due to a very tight processing loop in the thread, a regular cancel thread command might not work.
What action(s) would provide the best chance to initially attempt to cancel this thread?

Question26: A member of a DB2 data sharing group (DB2A) has failed and is currently down. After a few minutes the phone starts ringing and people complain that transactions accessing table space TSA (in database DBA) get an SQLCODE -904 because of retained locks held by the member that just abended.
What is the recommended way to resolve this problem?

Question27: Which two features are the motivation behind the conversion to extended RBA/LRSN format?

Question28: Your production DB2 subsystem is up and running, the following message is received:
DSNJ126I - BSDS ERROR FORCED SINGLE BSDS MODE
because one of the BSDS volumes is offline.
After the volume is back online, in order to ensure a securely running system, what is the least disruptive scenario to correct this error?

Question29: How can conditional restarts affect sequence objects?

Question30: A member of a data sharing group is suffering from elongated response times. You suspect that sysplex workload balancing (WLB) is not working properly for the DDF work (not evenly distributing the work among the different members).
What is the simplest way to verify how the DDF threads are distributed amongst the different members?

Question31: Local buffer pool updated pages are queued by data set until they are written out to DASD when which event occurs?

Question32: Given a subsystem parameter of SEPARATE_SECURITY=YES, what level of security has the authority to create and start audit policies?

Question33: A given buffer pool is to be used for sequentially accessed pages only.
Setting which buffer pool attribute to 0 (zero) will disable parallel processing operations in this buffer pool?