Verified of C2090-612 exam prep materials and answers for IBM certification for IT engineers, Real Success Guaranteed with Updated C2090-612 pdf dumps vce Materials. 100% PASS DB2 10 DBA for z/OS exam Today!
♥♥ 2021 NEW RECOMMEND ♥♥
Free VCE & PDF File for IBM C2090-612 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Free Instant Download NEW C2090-612 Exam Dumps (PDF & VCE):
Available on:
http://www.surepassexam.com/C2090-612-exam-dumps.html
Q21. The performance of BP5 is being evaluated. The Page residency time is being used to see if VPSIZE should be changed. The statistics that are available are VPSIZE of 90,000 and VPSEQT of 15 %. There are 4458 synch I/O per second and 1696 async I/O per second. 6154 total pages read. The system page residency time is 14.6 seconds. Based on a system page residency time of
14.6 seconds, what should be done to increase page residency time?
A. Increase DWQT to 10.
B. Decrease VPSIZE by 45,000 pages.
C. Increase VPSIZE to 180,000 pages.
D. Change the buffer pool to use PGFIX(YES).
Answer: C
Explanation:
Q22. The billing application has a DB2 referential integrity set of three tables. TABA, TABB and TABC. Daily, Full Image copies are done for the three table spaces related to the three tables. There is a requirement to recover the three table spaces to noon time, which is about 8 hours after the full image copies were run. Which one of the following statements is true about this recovery situation?
A. Recovery will need to be done on the children table first.
B. No recovery is allowed since the tables have been updated.
C. No recovery is allowed, a QUIESCE utility is missing to create a point of consistency.
D. BSDS contains information useful to find an appropriate RBA to use for the TORBA value.
Answer: D
Explanation:
Q23. Which ALTER TABLE statement will generate a new table space version?
A. ALTER TABLE ... ADD PARTITION ...
B. ALTER TABLE ... ADD COLUMN COL2 ...
C. ALTER TABLE ... DATA CAPTURE CHANGES ...
D. Altering an already existing VARCHAR column on the table to shorten its maximum length.
Answer: B
Explanation:
Q24. Your current backup strategy is to run COPY SHRLEVEL CHANGE for all your table spaces each night. You create FULL image copies once a week and INCREMENTAL copies during the rest of the days. After migrating to DB2 10, you plan to create the FULL image copies using FLASHCOPY YES and COPYDDN, that is you create a flash copy image copy (FCIC) and additionally a sequential copy. What happens to the incremental copies that you continue to create on all other days?
A. If DSNZPARM FLASHCOPY_COPY is set to YES, the incremental copies will automatically be incremental FLASHCOPY copies.
B. Nothing special. The only difference is that the FULL copy, which is the basis for the subsequent incremental copies has now been generated from the FCIC.
C. The COPY utilities with FULL NO option will not run. If there are entries in SYSIBM.SYSCOPY that indicate that FCICs exist for a give page set, INCREMENTAL copies cannot be taken anymore.
D. The first image copy utility execution after the FULL FCIC and sequential copy created from the
FCIC will end up as FULL copy although you specify the FULL NO statement on the COPY utility control statement.
Answer: D
Explanation:
Q25. DB2 does not take system checkpoints in which circumstance?
A. During an application rollback.
B. At the end of a successful restart.
C. When switching from one active log data set to another.
D. When a specified number of log records are created or after a specified number of minutes, whichever occurs first.
Answer: A
Explanation:
Q26. A table space is in AREO*. What does this status mean?
A. A full image copy of the table space must be taken.
B. The table space should be reorganized for optimal performance.
C. A START command must be issued to remove it from the pending status.
D. The table space must be reorganized to materialize all pending changes.
Answer: B
Explanation:
Q27. Which two parameters would reduce the impact of availability from a REORG with SHRLEVEL CHANGE for a partitioned table space with 16 parts? (Choose two.)
A. LOG NO
B. SORTKEYS 16
C. FASTSWITCH YES
D. AUTOESTSPACE YES
E. DRAIN_WAIT & RETRY
Answer: C,E
Explanation:
Q28. Which DB2 trace is utilized to capture overall subsystem virtual memory consumption?
A. The DB2 audit trace.
B. The DB2 statistics trace.
C. The DB2 connection trace.
D. The DB2 accounting trace.
Answer: B
Explanation:
Q29. Unnecessary REORGs of indexes may be avoided by which of the following?
A. Use the SYSIBM.SYSINDEXSPACESTATS table.
B. Use the REPORT utility to determine the degree of organization.
C. Use the CHANGELIMIT keyword when creating an image copy of the index.
D. Use the CHECK INDEX utility to find out if the index needs to be reorganized.
Answer: A
Explanation:
Q30. What is the maximum levels of backup that DB2 plan stability can support?
A. 1
B. 2
C. 3
D. 4 Answer: C
Explanation: