Exam Code: C2090-317 (Practice Exam Latest Test Questions VCE PDF)
Exam Name: DB2 11 System Administrator for z/OS
Certification Provider: IBM
Free Today! Guaranteed Training- Pass C2090-317 Exam.
2021 May C2090-317 Study Guide Questions:
Q31. 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
Q32. A member of a DB2 data sharing group (DB2A) has failed and is currently down. After a few minutes the phone starts ringing and people complain that transactions accessing table space TSA (in database DBA) get an SQLCODE -904 because of retained locks held by the member that just abended.
What is the recommended way to resolve this problem?
A. -START DB(DBA) SP(TSA) ACCESS(FORCE)
B. Restart the failed DB2 member with the LIGHT(YES) option.
C. Delete all the failed persistent connections to the lock structure with the SETXCFFORCE,CONNECTION,STRNAME=lock_strname.CONNAME=ALL command and force the deallocation of the lock structure by issuing SETXCFFORCE,STRUCTURE.STRNAME=lock_strname
D. Issue the MODIFY irlmproc.PURGE. DB2A command from an IRLM that is used by a DB2 member that is still running.}
Answer: C
Q33. One of your applications is experiencing long elapsed times. You notice from DB2 accounting data that 90% of the class 2 elapsed time consists of class 3 suspension time.
Which statement describes the behavior of the application?
A. The application is the victim of excessive performance tracing.
B. The application spends the majority of its time waiting on the network.
C. The application contains complex SQL statements that are CPU intensive.
D. The application spends the majority of its time waiting for buffer pool I/O and log I/O.
Answer: C
Avant-garde C2090-317 test question:
Q34. You wish to enforce a system-wide limit on the maximum number of parallel subtasks for utilities REORG TABLESPACE, REBUILD INDEX. CHECK INDEX. UNLOAD, and LOAD, to 16 parallel subtasks per utility execution.
Which action, if anywill enforce this limit?
A. Set subsystem parameter PARAMDEG to 16.
B. Set subsystem parameter PARAMDEGJJTIL to 16.
C. Set subsystem parameter INDEX_IO_PARALLELISM to 16.
D. DB2 does not allow for a system level limit for parallel subtasks in these utilities. The limit can only be specified with the utility keyword PARALLEL n.
Answer: A
Q35. Program Authorization does NOT work in which environment?
A. IMS
B. CICS
C. DSN command processor
D. Programs that run in stored procedure address spaces
Answer: C
Q36. The use of the work file database for RID list processing is controlled by the value of which
subsystem parameter?
A. MAXRBLK
B. WFDBSEP
C. MAXTEMPS
D. MAXTEMPSRID
Answer: A
Pinpoint C2090-317 dumps:
Q37. What happens in DB2 11 CM once you hit RBA x'FFF800000000' in a non-data sharing environment?
A. No updates are allowed.
B. DB2 terminates and can only be restarted in maintenance mode.
C. DB2 does not allow any activity except REORG SHRLEVEL CHANGE or REFERENCE.
D. No updates are allowed unless you migrated the BSDS to 10-byte RBA/LRSN format.
Answer: D
Q38. What utility can benefit from the additional zllP (IBM System z Integrated Information Processor) enablement inDB2 11?
A. COPY
B. RUNSTATS
C. CHECK INDEX
D. MODIFY STATISTICS
Answer: B
Q39. Given a subsystem parameter of SEPARATE_SECURITY=YES, what level of security has the authority to create and start audit policies?
A. SYSOPR
B. SYSADM
C. SECADM
D. SQLADM
Answer: C
Explanation:Reference:http://editorial.mcpressonline.com/web/mcpdf.nsf/wdocs/5127/$FILE/5127_EXP. pdf(page 9)
Q40. You received the following error message:
DSNI012I -DB2A PAGE LOGICALLY BROKEN TYPE 00000302 NAME DBXX.TSYYY.X'00045065' DBID01B5 OBID0020 PAGE RBA OR LRSN CCA7C9FF11C4 LOG RECORD RBA OR LRSN CCA7C9FF1B78
MODNAME DSNIOLIN ERQUAL 0000
Which utility be used to obtain more information about what may be triggering this message?
A. DSN1CHKR
B. CHECK DATA
C. DSN1COPY, PARM='CHECK'
D. DIAGNOSE DISPLAY ODB DBXXTSYYY ALL
Answer: D