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

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

Program Authorization does NOT work in which environment?

  1. IMS

  2. CICS

  3. DSN command processor

  4. Programs that run in stored procedure address spaces

Answer: C

Question No: 2

Having to deal with data inconsistency during a disaster recovery can significantly impact the length of time needed to recover. One of the actions that could be taken to prevent this from occurring is to not take an image copy of a data set that contains inconsistent data.

Which two options can be used to help prevent taking an image copy of inconsistent data?

  1. Run the DIAGNOSE utility before making an image copy.

  2. Run the CHECK DATA utility before making an image copy.

  3. Use the CHECKPAGE option when running the COPY utility.

  4. Prior to making an image copy, run DSN1 COPY with the CHECK option.

  5. At install time, use the DSNTIJIC install job to take a full image copy of the DB2 catalog and directory.

Answer: C,D

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

Question No: 3

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

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

  2. Using the SET_CLIENT_ID option during RRS SIGNON

  3. Using the SQL SET statement (eg. SET CURRENT CLIENT J/VRKSTNNAME = #39;MYWS*)

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

Answer: C

Question No: 4

Local buffer pool updated pages are queued by data set until they are written out to DASD when which event occurs?

  1. A page is added.

  2. A COMMIT is executed.

  3. When VPSEQT is reached.

  4. A system checkpoint is taken.g

Answer: B

Question No: 5

Which copy operation CANNOT be performed by DSN1COPY?

  1. DB2 concurrent copies to DB2 VSAM data sets.

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

  3. DB2 VSAM data sets to other DB2 VSAM data sets.

  4. DSN1COPY sequential data sets to other sequential data sets.

Answer: A

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

Question No: 6

Which subsystem parameter is used to enable the RECOVER utility to use system-level backups as a recovery base?

  1. RESTORE_TAPEUNITS

  2. SYSTEM_LEVEL_BACKUPS

  3. UTILS_DUMP_CLASS_NAME

  4. RESTORE _RECOVER_FROMDUMP

Answer: D

Question No: 7

Which DB2 system table can limit the amount of resources that can be consumed based on client or IP address of the client?

  1. SYSIBM.IPLIST

  2. SYSIBM.IPNAMES

  3. SYSIBM.DSNRLST01

  4. SYSIBM.DSNRLMT01

Answer: D

Question No: 8

The -ALTER UTILITY command changes the values of certain parameters of a utility. Which two utilities can this command be issued against?

  1. COPY

  2. REORG

  3. MODIFY

  4. REBUILD

  5. RECOVER

Answer: B,D

Reference:http://www- 01.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/com.ibm.db2z11.doc.admin/src/tpc/ db2z_monitronlineutilities.dita

Question No: 9

Which DB2 catalog or directory table space CANNOT be reorganized?

  1. DSNDB01.SCT02

  2. DSNDB01.SYSUTILX

  3. DSNDB06.SYSTSCPY

  4. DSNDB06.SYSTSPDO

Answer: D

Question No: 10

When might image copies be needed in a data mirroring environment during disaster recovery?

  1. To resolve outstanding units of recovery.

  2. If the RBAinthe BSDS is higher than the RBA in the active log.

  3. Image copies would never be needed when using data mirroring.

  4. If a LOAD or RECOVER utility was active at the time of the disaster.

Answer: A

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