It is more faster and easier to pass the IBM C2090-317 exam by using Validated IBM DB2 11 System Administrator for z/OS questuins and answers. Immediate access to the Up to the minute C2090-317 Exam and find the same core area C2090-317 questions with professionally verified answers, then PASS your exam with a high score now.


♥♥ 2021 NEW RECOMMEND ♥♥

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

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

Free Instant Download NEW C2090-317 Exam Dumps (PDF & VCE):
Available on: http://www.surepassexam.com/C2090-317-exam-dumps.html

Q31. What will occur if the parameter PAGE PROTECT is set to YES? 

A. MSTR log buffers (OUTBUFF) will be placed in page-protected storage. 

B. IRLM is to load its common storage modules into page-protected storage. 

C. DIST buffers related to TCPIP connectivity are loaded into page-protected storage. 

D. DBM1 pages belonging to a buffer pool defined with PGFIX(YES) will be placed in page-protected 

Answer: D 


Q32. In complex DB2 recovery scenarios, it is important to understand the scope of which objects require recovery. 

Which DB2 utility provides a list of the names of all table spaces in the table space set that is specified and a list of all the tables in those table spaces? 

A. CHECK 

B. REPORT 

C. QUIESCE 

D. RECOVER 

Answer: D 

Explanation:Reference:http://www-01.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/com.ibm.db2z10.doc.ugref/src/tpc/d b2z_reportsyntax.dita 


Q33. 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 the ENDRBA option. 

C. Use DSNJU003 with the STARTRBA option. 

D. Start DB2 using DEFER on catalog and directory. 

E. Recover the subsystem to the last known system checkpoint in BSDS. 

Answer: D,E 


Q34. Which copy operation CANNOT be performed by DSN1COPY? 

A. DB2 concurrent copies to DB2 VSAM data sets. 

B. DB2 image copy data sets to DB2 VSAM data sets. 

C. DB2 VSAM data sets to other DB2 VSAM data sets. 

D. DSN1COPY sequential data sets to other sequential data sets. 

Answer: A 

Explanation:Reference:http://www-01.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/com.ibm.db2z11.doc.ugref/src/tpc/d b2z_utl_dsn1copy.dita 


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

A. Using the java.sql.Connection.setClientlnfo method 

B. Using the SET_CLIENT_ID option during RRS SIGNON 

C. Using the SQL SET statement (eg. SET CURRENT CLIENT J/VRKSTNNAME = 'MYWS*) 

D. Setting up a profile using the SPECIAL_REGISTER attribute in SYSIBM.DSNPROFILE ATTRIBUTES table 

Answer: C 


Q36. You wish to set the threshold at which data in the class castout queue is cast out to disk for group buffer pool GBP10. You want the threshold to be 1000 pages. 

Which parameter setting in the command -ALTER GBPOOL(GBP10) will accomplish this? 

A. GBPOOLT(10) 

B. CLASST(0.1000) 

C. CLASST(10.1000) 

D. GBPCHKPT(1000) 

Answer: A