[Free] 2017(Oct) CollectDumps Dumpsleader IBM C2090-317 V13 Dumps with VCE and PDF Download 21-30

CollectDumps 2017 Oct IBM Official New Released C2090-317 V13
100% Free Download! 100% Pass Guaranteed!
http://www.CollectDumps.com/C2090-317 V13.html

DB2 11 System Administrator for z/OS

Question No: 21

Which statement is true regarding DB2 definitions for SMF collection?

  1. SMF collection is not required for DB2.

  2. At the minimum, DB2 statistics class 1 trace is required.

  3. At the minimum. DB2 accounting classes 1.2.3 are required.

  4. The SMF subsystem does not have to be active for DB2 to write SMF trace records.

Answer: B

Reference:http://www- 01.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/com.ibm.db2z10.doc.inst/src/tpc/db 2z_recorddb2data2smfdsenable.dita(See the table, second row)

Question No: 22

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?

  1. Set subsystem parameter MAXRBLK to 5000.

  2. Set subsystem parameter MAXSORTJNJV1EMORY to 5000.

  3. Issue command-ALTER BUFFERPOOL(BP7) VPSIZE(5000).

  4. DB2 does not allow for user control of this maximum allocation.

Answer: B

Reference:http://www- 01.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/com.ibm.db2z11.doc.inst/src/tpc/db 2z_ipf_maxsortinmemory.dita

Question No: 23

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?

  1. The immediate write threshold can be increased by 25%.

  2. A pool size can be increased by up to 25% over original pool size.

  3. The pool size can be increased in 25% increments base on sequential read hit ratio.

  4. Depending on the type of I/O performed, pool size can be increased or decreased.

Answer: B

Reference:http://www- 01.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/com.ibm.db2z11.doc.perf/src/tpc/db 2z_enableautobpsize.dita

Question No: 24

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 ?

  1. -STA TRA(P) CLASS(7) DEST(GTF) PLAN(PLANB)

  2. -STA TRA(P) CLASS(7) IFCID(21) DEST(GTF) PLAN(PLANB)

  3. -STATRA(P)CLASS(30) IFCID(21) DEST(GTF) PLAN(PLANB)

  4. -STA TRA(P) CLASS(7) IFCID(21) DEST(GTF) XPLAN(PLANB#39;)

Answer: B

Question No: 25

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

  1. DSNTIJIC

  2. DSNTIJXA

  3. DSNTIJTC

  4. DSNTIJPM

Answer: C Reference:https://dhrmf.hr.state.or.us/public/pdfs/IBM/DB2/V9_Installation_Guide_dsnigk1 5.pdf(page 322)

Question No: 26

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?

  1. EDMPOOL

  2. EDMDBDC

  3. MAXKEEPD

  4. EDMSTMTC

Answer: C

Question No: 27

A z/OS Workload Manager (WLM) application environment must be created to enable which functionality in DB2?

  1. Global dynamic SQL caching in the EDM pool

  2. Service class assignments for dispatchable work in DB2

  3. zllP redirect processing for enclave SRB workloads which are zllP redirect eligible

  4. DB2 supplied routine SYSPROC.ADMIN_INFO_SYSPARM. which lists the settings of subsystem parameters

Answer: A

Question No: 28

How can you create a dynamic location alias?

  1. Use the CREATE ALIAS statement.

  2. Issue the -MODIFY DDF ALIAS ADD command.

  3. INSERT a dynamic alias row into SYSIBM.LOCATIONS.

  4. Execute the DSNJU003 utility with a DDF ALIAS statement.

Answer: D

Reference:http://www- 01.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/com.ibm.db2z10.doc.comref/src/tpc

/db2z_cmd_modifyddf.dita

Question No: 29

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

  1. REPAIR

  2. DSNJU003

  3. DSN1COPY

  4. COPYTOCOPY

Answer: A

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

Question No: 30

Which statement about the castout process in data sharing is true?

  1. The castout process is initiated by the coupling facility.

  2. The castout process is performed using BPO of the less active member of the group.

  3. The castout process is performed by the first member to express write interest in the data set.

  4. The castout process is performed using a private buffer pool in the first member to join the group.

Answer: C

100% Free Download!
Download Free Demo:C2090-317 V13 Demo PDF
100% Pass Guaranteed!
Download 2017 CollectDumps C2090-317 V13 Full Exam PDF and VCE

CollectDumps ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

2017 CollectDumps IT Certification PDF and VCE