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

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: 31

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?

  1. CHECK

  2. REPORT

  3. QUIESCE

  4. RECOVER

Answer: D

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

Question No: 32

You execute the following SQL against the CDB (Communications Database) of your DB2 subsystem:

INSERT INTO SYSIBM.IPNAMES

(UNKNAME.SECURITY_OUT.USERNAMES,IBMREQD.IPADDR) VALUES (#39;REMOTEDB#39;. #39;P\ #39;O#39;. #39;N#39;, *123.34.45.56#39;);

INSERT INTO SYSIBM.IPLIST (LINKNAMEJPADDRJBMREQD) VALUES (#39;REMOTEDB#39;, #39;123.34.45.56#39;, *N#39;);

INSERT INTO SYSIBM.IPLIST (LINKNAMEJPADDRJBMREQD) VALUES C REMOTEDB#39;, #39;123.34.45.57#39;, #39;N#39;);

INSERT INTO SYSIBM.USERNAMES (TYPE,AUTHID.LINKNAME,NEWAUTHID.PASSWORD,IBMREQD) VALUES (T, #39;USER1#39;. #39;USER2\ quot;, ,PWD2,1 *N#39;);

INSERT INTO SYSIBM.USERNAMES (TYPE,AUTHID.LINKNAME,NEWAUTHID.PASSWORDJBMREQD) VALUES (#39;O#39;, #39;USER1#39;. #39;USER3#39;, *#39;, #39;PWD3#39;, #39;N#39;);

There is no trusted connection to REMOTEDB. USER1 issues a query addressing remote data source REMOTEDB on your DB2 subsystem.

Which authorization id will be used on the remote data source REMOTEDB?

  1. USER1

  2. USER2

  3. USER3

  4. USER4

Answer: A

Question No: 33

You use utility DSN1PRNT to print the header page of table space DB1TS1. Where do you find information about the various header page fields?

  1. DB2 Messages

  2. DB2 Utility guide

  3. DB2 Diagnosis guide

  4. DB2 Administration guide

Answer: A

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

Question No: 34

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

  1. SYSOPR

  2. SYSADM

  3. SECADM

  4. SQLADM

Answer: C Reference:http://editorial.mcpressonline.com/web/mcpdf.nsf/wdocs/5127/$FILE/5127_EXP. pdf(page 9)

Question No: 35

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

  1. SYSIBM.SYSAUTOALERTS

  2. SYSIBM.SYSSTATFEEDBACK

  3. SYSIBM.SYSTABLES_PROFILES

  4. SYSIBM.SYSTABLESPACESTATS

Answer: D

Question No: 36

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

  1. DBADM

  2. SYSADM

  3. SYSOPR

  4. SYSCTRL

Answer: A

Question No: 37

How can conditional restarts affect sequence objects?

  1. Gaps may exist.

  2. Duplicate entries will be deleted.

  3. All values will be reset beginning from 1.

  4. All values will be reset beginning from 0.

Answer: A

Question No: 38

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

  1. -SET LOG

  2. -SET ARCHIVE

  3. -ARCHIVE LOG

  4. -RECOVER BSDS

Answer: A

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

/db2z_cmd_setlog.dita

Question No: 39

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

  1. A persistent thread will release an active package at every COMMIT or ROLLBACK.

  2. A persistent thread will not release an active package at COMMIT or ROLLBACK.

  3. A persistent thread will release an active package at COMMIT if there is a REBIND PACKAGE request on that package.

  4. A persistent thread will not release an active package at ROLLBACK if there is a REBIND PACKAGE request on that package.

Answer: A

Question No: 40

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?

  1. -CANCEL THREAD(56)

  2. -CANCEL DDF THREAD(56) FORCE

  3. -CANCEL THREAD(56)NOBACKOUT

  4. -CANCEL DDF THREAD(56)

Answer: B

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

/db2z_cmd_stopddf.dita

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