Exam Code: C2090-617 (Practice Exam Latest Test Questions VCE PDF)
Exam Name: DB2 10 System Administrator for z/OS (C2090-617)
Certification Provider: IBM
Free Today! Guaranteed Training- Pass C2090-617 Exam.
2021 May C2090-617 Study Guide Questions:
Q51. Which of the utilities CANNOT handle a table space containing a hash table?
A. REPAIR LEVELID
B. REORG AUTOESTSPACE
C. DSN1CHKR PARM=HASH
D. DSN1COPY PARM=OBIDXLAT
Answer: C
Q52. Which of the following statements is NOT correct regarding the dynamic statement cache?
A. The dynamic statement cache resides in an above-the-bar pool.
B. Performance problems can occur if the dynamic statement cache is too small.
C. The REOPT(VARS) bind option is necessary in order to store the access path for a dynamic SQL statement in the dynamic statement cache.
D. When updating statistics for an object manually, you need to invalidate statements in the dynamic statement cache that refer to this object using RUNSTATS REPORT NO UPDATE NONE against the object.
Answer: C
Q53. The DB2 command -SET SYSPARM lets you change subsystem parameters while DB2 is up. What is the correct syntax for loading a different DSNZPARM load module?
A. -SET SYSPARM LOAD
B. -SET SYSPARM RELOAD
C. -SET SYSPARM(dsnzparm name)
D. -SET SYSPARM LOAD(dsnzparm name)
Answer: D
Renovate C2090-617 dumps:
Q54. What is the upper limit of the sum of the CTHREAD and MAXDBAT values in DSNZPARM?
A. 2,000
B. 10,000
C. 20,000
D. 50,000
Answer: C
Q55. When diagnosing problems using DB2 traces, where would you find the information about the IFCIDs?
A. In the PLAN_TABLE.
B. In the Statistics Report.
C. In the DSNWMSGS member of SDSNIVPD.
D. In the output of a DISPLAY TRACE command.
Answer: C
Q56. You have just defined the profile monitoring tables and related indexes using the DSNTIJSG job in the SDSNSAMP library. In order to monitor the number of remote threads and connections you must insert rows into the SYSIBM.DSN_PROFILE_TABLE and SYSIBM.DSN_PROFILE_ATTRIBUTES tables to specify the monitoring functions to be used. What is the next step in this process?
A. Issue the -START PROFILE command.
B. Issue the -DISPLAY THREAD command.
C. Issue the -START TRACE (MONITOR) command.
D. No further steps are needed. DB2 will automatically begin monitoring those DB2 threads identified in the monitoring profile.
Answer: A
Pinpoint C2090-617 :
Q57. DB2 10 migration mode names take into account skip level migration. What are the possible mode names in the migration process from DB2 V8 to DB2 10?
A. CM9, CM9*, ENFM9, ENFM9*, NFM
B. CM8, CM8*, ENFM8, ENFM8*, NFM
C. CM8, CM9, CM9*, ENFM9, ENFM9*, NFM
D. CM8, CM8*, CM9, CM9*, ENFM8, ENMF8*, ENFM9, ENFM9*, NFM
Answer: B
Q58. A DB2 monitor shows that a transaction invoking a stored procedure has a high not-accounted-for time. (not-accounted-for time = class 2 elapsed time - class 2 CPU time - class 3 wait time.) What could be the reason for the high not-accounted-for time?
A. The buffer pool is too small and we are constantly waiting for a page.
B. The EDM pool is to small so the package need to be brought into the pool again
C. The stored procedure is delayed, waiting for a WLM managed address space to start.
D. The transactions runs in a service class with a low priority and the machine is at a high utilization rate.
Answer: D
Q59. What process does the RESTORE SYSTEM utility NOT perform?
A. Restores logs from the log copy pool.
B. Applies logs to the data to a point in time.
C. Restores data from the database copy pool.
D. Applies only logs to the data if LOGONLY is specified.
Answer: A
Q60. Which command allows DB2 to retain all tablespace/indexspace pages assigned to BP1 in memory?
A. ALTER BUFFERPOOL(BP1) PGFIX(YES)
B. ALTER BUFFERPOOL(BP1) AUTOSIZE(YES)
C. ALTER BUFFERPOOL(BP1) VPXPSEQT(100)
D. ALTER BUFFERPOOL(BP1) PGSTEAL(NONE)
Answer: D