Ensurepass.com : Ensure you pass the IT Exams
2018 Jan IBM Official New Released C2090-317
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/C2090-317.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% Ensurepass Free Download!
Download Free Demo:C2090-317 Demo PDF
100% Ensurepass Free Guaranteed!
C2090-317 Dumps

EnsurePass 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

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.