Hi all,

I'm doing study in OS/390's DB2 REORG process. Since I don't have the OS/390, I'm doing research by reading manuals only. And it occurs to me that there aren't any information concerning the locks held when :

SHRLEVEL NONE : sort, build,srtbld processes
SHRLEVEL REFERENCE : reload, sort, build, srtbld, and switch processes
SHRLEVEL CHANGE : reload, sort, build, srtbld, switch and log processes

If anyone have any clue about it, I'll appreciate it very much.

This is my understanding of it. Please correct me if I'm wrong:

SHRLEVEL NONE: after the unload phase, no access possible, so essentially the tablespace is "exclusively locked".
SHRLEVEL REFERENCE & CHANGE:
with the FASTSWITCH option on, at (almost) all times access is possible, be it to the old version of the data. During the switch phase, no access allowed, i.e., essentially an "exclusive lock".
For SHRLEVEL CHANGE, during the last iteration of the LOG phase, no writes possible, so essentially a "read lock". And no "massive delete" possible during the unload phase.

(Actually, the used locking mechanism is known as "claim and drain"; in some phases only the writers are drained, in some other phases also the readers are drained.)

Separate claims & drains happen for the indexes; general no index access is allowed during any of the phases, exceptions being the partitioned or partitioning indexes.

For details, see pages 471-473 of the v8 Utility Guide; for version 9, this is pages 491-493.