Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2008
    Posts
    45

    Unanswered: Locks at OS/390's DB2 REORG

    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.

  2. #2
    Join Date
    Sep 2004
    Location
    Belgium
    Posts
    1,126
    Quote Originally Posted by linakichi
    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
    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.
    --_Peter Vanroose,
    __IBM Certified Database Administrator, DB2 9 for z/OS
    __IBM Certified Application Developer
    __ABIS Training and Consulting
    __http://www.abis.be/

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •