Practical of C2090-737 simulations materials and study guides for IBM certification for IT learners, Real Success Guaranteed with Updated C2090-737 pdf dumps vce Materials. 100% PASS DB2 9 System Administrator for z/OS Exam exam Today!
2021 May C2090-737 Study Guide Questions:
Q61. Which two parameters are used for buffer pool page management? (Choose two.)
A. PGFIX
B. PGSTEAL
C. PGOPTION
D. PGSAVE
E. PGIO
Answer: A,B
Q62. It is possible that the DBD in the directory is out of sync with the DBD information in the catalog for database DSN8D91
Which action should be performed to determine if this is the case?
A. Run DSN1CHKR.
B. Run DSN1COPY with the CHECK option.
C. Run REPAIR DBD TEST.
D. Run CHECK DATA.
Answer: C
Q63. Which two statements regarding system parameters are true? (Choose two.)
A. Indexes can now be mapped to 8K and 16K buffer pools assigned by default using the systemparameter IDXBPOOL.
B. Implicit table space data sets are always defined at create time without a system parameter tooverride this behavior.
C. Indexes can be compressed for an entire subsystem by setting the IDXCOMP system parameter to YES.
D. The default for BIND option DBPROTOCOL can no longer be specified using the systemparameter DBPROTCL.
E. The amount of work file storage used by any one agent cannot be controlled via systemparameters.
Answer: A,D
Regenerate C2090-737 exam answers:
Q64. An accounting report shows high class 3 times. Which three could contribute to the class 3 times?
(Choose three.)
A. elapsed time
B. not accounted time
C. page latch
D. service task switch
E. synchronous I/O
Answer: C,D,E
Q65. Which online or stand-alone utility can be used to reset a page set level-id?
A. DSN1SDMP
B. REORG
C. REPAIR
D. MODIFY RECOVERY
Answer: C
Q66. DB2 traces have their own associated performance overhead. Which type of trace may require up to 100% CPU overhead?
A. statistics
B. accounting
C. audit
D. performance
Answer: D
Free C2090-737 free demo:
Q67. A DB2 subsystem is set up to take a checkpoint every two minutes. Applications that use this DB2 subsystem are supposed to adhere to an IT standard where a commit should be issued by the application at least every 200 SQL changes (INSERTs, UPDATES, or DELETEs). Which system parameter would be used to help implement the IT standard?
A. URLGWTH
B. CHKFREQ
C. MAXDBAT
D. LRDRTHLD
Answer: A
Q68. A DB2 subsystem is being migrated/converted from DB2 Version 8 to DB2 9. The subsystem currently has these characteristics: new DB2 9 functions are not available; no DB2 9 objects can exist; the subsystem cannot fall-back to CM (conversion mode); the subsystem cannot fall-back to Version 8; the subsystem cannot coexist with any Version 8 systems in a data sharing group.
Which mode describes the DB2 subsystem?
A. CM* (conversion mode*)
B. ENFM (enabling-new-function mode)
C. ENFM* (enabling-new-function mode*)
D. NFM (new-function mode)
Answer: B
Q69. Non-partitioned table space TS1 lives in database DB1. Which command removes the intersystem read/write interest against this table space?
A. -START DB(DB1) SPACE(TS1) ACCESS(FORCE)
B. -ALTER BUFFERPOOL(*) DBNAME(DB1) SPACE(TS1) MODE(NOISRW)
C. -START DB(DB1) SPACE(TS1) ACCESS(RW)
D. -ACCESS DB(DB1) SPACE(TS1) MODE(NGBPDEP)
Answer: D
Q70. A customer is planning on using the BACKUP SYSTEM utility. The DB2 systems programmer works with the storage administrator to establish the correct SMS definitions. Which configuration is correct for use of the BACKUP SYSTEM utility?
A. SMS copy pool 1 that contains the catalog and directory SMS copy pool 2 that contains theBSDS and active logs SMS copy pool 3 that contains the user data
B. SMS copy pool 1 that contains the catalog, directory, BSDS and active logs SMS copy pool 2that contains the user data
C. SMS copy pool 1 that contains the catalog and directory SMS copy pool 2 that contains theuser data
D. SMS copy pool 1 that contains the catalog, directory and user data SMS copy pool 2 thatcontains the BSDS and active logs
Answer: D