← Back to exam page

C2090-318 – DB2 12 System Administrator for z/OS

Loading demo links...

Showing 1–3 of 7 questions

Question 1

Which of the following are TRUE regarding the DSN1PRNT utility? (Choose two)

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
Question 2

What are the appropriate actions that can be taken to reduce false contention in a data sharing environment? (Choose two)

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
Question 3

Considering the following command:

-CANCEL THREAD {*) FORCE

In which of the following situations can it be used?

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