Jun 2016 updated: mcsa 70-687 cert guide

♥♥ 2017 NEW RECOMMEND ♥♥

Free VCE & PDF File for IBM C2090-617 Real Exam (Full Version!)

★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions

Free Instant Download NEW C2090-617 Exam Dumps (PDF & VCE):
Available on: https://www.certleader.com/C2090-617-dumps.html

C2090-617 Product Description:
Exam Number/Code: C2090-617 vce
Exam name: DB2 10 System Administrator for z/OS (C2090-617)
n questions with full explanations
Certification: IBM Certification
Last updated on Global synchronizing

Instant Access to Free VCE Files: IBM C2090-617 DB2 10 System Administrator for z/OS (C2090-617)

C2090-617 examcollection

Exam Code: C2090-617 (Practice Exam Latest Test Questions VCE PDF)
Exam Name: DB2 10 System Administrator for z/OS (C2090-617)
Certification Provider: IBM
Free Today! Guaranteed Training- Pass C2090-617 Exam.

2016 Jun C2090-617 Study Guide Questions:

Q81. A cursor in a batch application that is issuing many static and dynamic SQL statements seems to be using a lot of CPU. What performance trace data/options are required to obtain this information? 

A. The CPU times are always present in all DB2 trace records, so no special action is required. 

B. If the dynamic statement cache is active (CACHEDYN=YES) you can extract this information using EXPLAIN STMTCACHE ALL. 

C. Statement level information about the CPU usage is always provided when performance trace class(3) (SQL activity) is active. 

D. To obtain information about the CPU time used by a cursor, you must specify the TDATA(CPU) keyword on the -START TRACE command. 

Answer: C 

Q82. The parameter EDMSTMTC provides the sizing for global dynamic SQL cache. Monitoring and proper sizing of this storage area should have which benefit? 

A. Reduce the volume of REORGs needed. 

B. Reduce the volume of FULL PREPARES. 

C. Reduce the volume of statements required. 

D. Reduce the volume of DML SELECT activity. 

Answer: B 

C2090-617  exam question

Replace cbt nuggets 70-687 download:

Q83. Given that: MAXTEMPS_RID = 20000 and MAXTEMPS = 2G what happens when RID pool CANNOT contain all the RIDs? 

A. DB2 will immediately revert to relational scan. 

B. DB2 will use work file to hold all the extra RIDs. 

C. DB2 will revert to relational scan based on other RID pool usage. 

D. DB2 will use work file up to a certain limit and then revert to relational scan. 

Answer: C 

Q84. When migrating from DB2 V8 NFM to DB2 10 CM8 mode, you might have to IPL z/OS under which two of the following circumstances? (Choose two.) 

A. An IPL is never required. 

B. DB2 early (ERLY) code is not at the correct level to support DB2 10. 

C. CSA or ECSA storage allocation needs to be increased. 

D. Update the DB2 startup parameters (DSNZPARMS) 

E. Establish WLM environments for DB2 supplied stored procedures 

Answer: B,C 


Guaranteed mcsa 70-687 pdf:

Q85. Assume DB2 has two BSDSs and one is corrupted. Which statement is true? 

A. If DB2 is up, DB2 abends. 

B. If DB2 is down, DB2 automatically resynchronizes the BSDS during restart. 

C. If DB2 is down, you must allocate a new BSDS and copy the current to the new allocated. 

D. If DB2 is up, you must shut down DB2, allocate a new BSDS, start DB2 and do command RECOVER BSDS. 

Answer: B 

Q86. When restoring a subsystem during disaster recovery, and the ICF user catalog for the DB2 page sets has been imported from a backup and user data sets have not been restored, what step should be executed before recovery of the DB2 page sets can begin? 

A. Run installation job DSNTIJIN to define the DB2 system datasets. 

B. Use IDCAMS CATALOG command to properly catalog all the data sets. 

C. Nothing, DB2 requires the user page set ICF catalog definitions during execution of the RECOVER utility. 

D. Use IDCAMS DELETE NOSCRATCH to remove the ICF catalog entries for the DB2 page sets that do not exist on DASD. 

Answer: D 

Q87. Assume that you have implemented identity propagation and that the distributed user name is 'MARY'. You have mapped this user name to the RACF user ID 'DB2USER1'. Which statement is true? 

A. 'MARY' is authenticated by RACF. 

B. 'DB2USER1' must be defined on the remote system. 

C. Remote requests execute with the authority of 'MARY'. 

D. Audit records for this transaction contains both RACF user ID 'DB2USER1' and the distributed user 'MARY'. 

Answer: D 

Q88. You are required to include documentation and instructions for all possible fallback routes in your plan for migrating your DB2 subsystem from V9 NFM to V10 NFM. Which fallback route should you include? 

A. V10 CM9 to V9 NFM 

B. V10 NFM to V9 NFM 

C. V10 ENFM to V10 CM 

D. V10 NFM to V10 ENFM 

Answer: A 

see more DB2 10 System Administrator for z/OS (C2090-617)