Guaranteed of C2090-617 free download materials and braindumps for IBM certification for IT specialist, Real Success Guaranteed with Updated C2090-617 pdf dumps vce Materials. 100% PASS DB2 10 System Administrator for z/OS (C2090-617) exam Today!
2021 May C2090-617 Study Guide Questions:
Q81. What does the command -ALTER GROUPBUFFERPOOL(GBP1) RATIO(5.6) do?
A. Changes the ratio of directory entries to the local cache entries (LCE).
B. Changes the desired ratio of the number of lock entries to the number of data pages in the group buffer pool.
C. Changes the desired ratio of the number of directory entries to the number of data pages in the group buffer pool.
D. Changes the desired number of the data pages cast out to those that remain in the group buffer pool when the group buffer pool checkpoint occurs.
Answer: C
Q82. The ABIND subsystem parameter determines whether plans or packages are to be automatically rebound (or autobound) at run time in certain situations. The possible values are YES, NO and COEXIST. COEXIST is useful only in which situation?
A. DB2 in a data sharing environment.
B. DB2 migrated from 8 NFM to 10 CM.
C. DB2 migrated from 9 NFM to 10 CM.
D. DB2 migrated from 8 NFM or 9 NFM to 10 NFM.
Answer: A
Improve C2090-617 brain dumps:
Q83. In DB2 9, you have observed an increase in buffer pool latch contention which has been attributed to the increased speed and number of CPUs available for use. Which DB2 10 enhancement helps minimize this type of contention?
A. DB2 acquires the maximum amount of buffer pool storage at the time of allocation.
B. Users can issue the -ALTER BUFFERPOOL PGFIX(YES) AUTOSIZE(YES) command.
C. Users can include the MAXPARTITIONS MEMBER CLUSTER clause on the CREATE TABLESPACE statement.
D. Objects can be pre-loaded into memory at the time the object is physically opened and will remain there until the object is closed.
Answer: D
Q84. What is NOT required for recovery of the DB2 catalog at a disaster recovery site?
A. All catalog table spaces.
B. IBM defined indexes on the catalog.
C. XML objects for the catalog table spaces.
D. LOB objects for the catalog table spaces.
Answer: C
Breathing C2090-617 cram:
Q85. When migrating from DB2 V8 to DB2 10 which of the following is NOT required in order to migrate to DB2 10?
A. Eliminate simple table spaces.
B. Eliminate DB2 managed stored procedures.
C. Eliminate DB2 plans using DB2 private protocol.
D. Eliminate DB2 plans into which DBRMs have been directly bound.
Answer: A
Q86. Given that: MAXTEMPS_RID = 20000 and MAXTEMPS = 2G what happens when RID pool CANNOT contain all the RIDs?
A. DB2 will immediately revert to relational scan.
B. DB2 will use work file to hold all the extra RIDs.
C. DB2 will revert to relational scan based on other RID pool usage.
D. DB2 will use work file up to a certain limit and then revert to relational scan.
Answer: C
Q87. Poorly tuned buffer pools can affect application performance, such as having sequential prefetch turned off. Which metric should you monitor from the statistics report to be sure this is not occurring?
A. PREF.DISABLED-NO BUFFER
B. PREF.DISABLED-NO READ ENG
C. PAGES WRITTEN PER WRITE I/O
D. BUFF.UPDATES/PAGES WRITTEN
Answer: A
Q88. The standard audit trace has limitations. Which statement is true?
A. You can audit the catalog tables.
B. You can audit every access to a table.
C. You can audit all utilities including DSN1.... ones.
D. You can start a specific audit trace at DB2 startup.
Answer: D