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

Free demo downloads

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