Free C2090-318 – DB2 12 System Administrator for z/OS Practice Test Question

Select all that apply, then click Submit answer.

• ○

  It does not decrypt any encrypted data
  

• ○

  The input can be a list of concatenated DB2 VSAM data sets
  

• ○

  lt can be executed when the DB2 subsystem is not operational
  

• ○

  lt can be executed on both image copies and concurrent copies
  

• ○

  Compressed records cannot be printed in decompressed format
  
  
  

Select all that apply, then click Submit answer.

• ○

  Increase the size of the lock structure
  

• ○

  Use LOCKSIZE PAGE and MAXROWS 1
  

• ○

  Increase the proportional size of the lock table
  

• ○

  Increase workload with inter-DB2 read/write interest
  

• ○

  Reduce the IRLMRWT subsystem parameter value
  
  
  

Select an option, then click Submit answer.

• ○

  On local threads that are not in DB2
  

• ○

  On application threads that update NOT LOGGED table spaces
  

• ○

  If you are terminating a distributed thread that is part of a global transaction
  

• ○

  If the CANCEL THREAD command without the FORCE option does not terminate the thread
  
  
  

Select an option, then click Submit answer.

• ○

  Parallelism for DPSI is disabled
  

• ○

  The DB2 optimizer will not consider DPSI for access path selection
  

• ○

  DB2 creates multiple child tasks but works on one task at a time when DPSI is used to drive parallelism
  

• ○

  DB2 will use the value specified for the PARAMDEG subsystem parameter to control the degree of parallelism when DPSI is used
  
  
  

Select an option, then click Submit answer.

• ○

  -SET LOG BOTH
  

• ○

  -SET LOG RESUME
  

• ○

  -SETLOGLOGLOAD(O)
  

• ○

  -SET LOG BOTH CHKTIME(10) LOGLOAD(500000)
  
  
  

Select an option, then click Submit answer.

• ○

  DWQT
  

• ○

  VDWQT
  

• ○

  VPSEQT
  

• ○

  VPPSEQT
  
  
  

Select an option, then click Submit answer.

• ○

  Audit

• ○

  Monitor
  

• ○

  Statistics
  

• ○

  Accounting