Multiple choice technology databases

To prevent time outs or deadlocks when you use REORG with SHRLEVEL CHANGE option, run the REORG with the

  1. DRAIN WRITERS

  2. DRAIN ALL

  3. DRAIN CLAIMERS

  4. DRAIN *
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

When using REORG with SHRLEVEL CHANGE, DRAIN ALL prevents timeouts and deadlocks by ensuring all claimers and writers are drained before starting. DRAIN WRITERS only drains writers, leaving claimers that could cause contention. DRAIN * is not a valid option - the correct syntax is DRAIN ALL.

Keep practicing — related questions