Which z/OS or DB2 component is required for stored procedures that run in a WLM-established address space? A. Call attachment facility B. TSO attachment facility C. Distributed data facility D. Resource recovery services
What utility can benefit from the additional zllP (IBM System z Integrated Information Processor) enablement inDB2 11? A. COPY B. RUNSTATS C. CHECK INDEX D. MODIFY STATISTICS
Which statement about the castout process in data sharing is true? A. The castout process is initiated by the coupling facility. B. The castout process is performed using BPO of the less active member of the group. C. The castout…
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? A. Start DB2 using DEFER ALL. B. Use DSNJU003 with…
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…
Which DB2 system table can limit the amount of resources that can be consumed based on client or IP address of the client? A. SYSIBM.IPLIST B. SYSIBM.IPNAMES C. SYSIBM.DSNRLST01 D. SYSIBM.DSNRLMT01
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? A. The application…
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…
Which DB2 catalog or directory table space CANNOT be reorganized? A. DSNDB01.SCT02 B. DSNDB01.SYSUTILX C. DSNDB06.SYSTSCPY D. DSNDB06.SYSTSPDO
You wish to set the maximum allocation of sort storage to 5000 kilobytes for a query that contains an ORDER BY clause. Which action will accomplish this? A. Set subsystem parameter MAXRBLK to 5000. B. Set subsystem parameter MAXSORTJNJV1EMORY to…