nerdexam
IBM

C2090-312 · Question #38

The threads initiated by the distributed transactions are no longer active in DB2, however this situation has caused -904 resource unavailable condition for the other executing threads in DB2. Which…

The correct answer is B. -DIS THD(*) TYPE(INDOUBT) LOCATION(*) DETAIL. See the full explanation below for the reasoning.

Question

The threads initiated by the distributed transactions are no longer active in DB2, however this situation has caused -904 resource unavailable condition for the other executing threads in DB2. Which command could assist in identifying the remote locations from where such threads were triggered?

Options

  • A-DISPLAY LOCATION(*) DETAIL
  • B-DIS THD() TYPE(INDOUBT) LOCATION() DETAIL
  • C-DIS THD() TYPE(INACTIVE) LOCATION() DETAIL
  • D-DIS THD() TYPE(POSTPONED) LOCATION() DETAIL

How the community answered

(68 responses)
  • A
    6% (4)
  • B
    76% (52)
  • C
    15% (10)
  • D
    3% (2)

Community Discussion

No community discussion yet for this question.

Full C2090-312 Practice