Online Access Free C2090-318 Exam Questions

Which of the following allows tracking of database administration tasks performed by system DBADMs?

• A.Use the DIAGNOSE utility with option TRACEID
• B.Define and start an appropriate audit policy in SYSIBM.SYSAUDITPOLICIES
• C.Start the appropriate accounting trace classes and analyze the SMF records
• D.Use the REPORT utility with option TABLESPACESET

To initiate a system checkpoint without modifying the current LOGLOAD value, which of the following should be issued?

• A.-SET LOG BOTH CHKTIME(10) LOGLOAD(500000)
• B.-SET LOG RESUME
• C.-SET LOG BOTH
• D.-SETLOGLOGLOAD(O)

Az/OS system has some storage constraints. The results of-DIS STATS(INDEXMEMORYUSAGE) shows that a huge amount of storage is used for the fast index traversal processes. What can be done to avoid this storage usage?

• A.Set subsystem parameter INDEX_MEMORY_CONTROL to DISABLE
• B.Issue SQL statement ALTER INDEX ixname REGENERATE USING APPLICATION
  COMPATIBILITY V12R1M500 for the listed indexes
• C.Reorganize the listed indexes
• D.Set subsystem parameter INDEX_CLEANUP_THREADS to 0

What resource is used to communicate BSDS and log data set names between DB2 members in a data sharing group?

• A.DB2 directory
• B.DB2log
• C.SCA
• D.Lock structure

When must the IRLM address space be active?

• A.After startup of DB2
• B.At the first lock request
• C.At the first concurrent lock situation
• D.During start of DB2