Testing global lock serialization

Use the SQL statements in member DSNTESD to verify that locks are acquired and released correctly across multiple data sharing members.

Procedure

To test global lock serialization:

  1. Run SPUFI, using member DSNTESD as input, on member 1.
    Specify AUTOCOMMIT=NO.

    Because you have inserted data into DSN8D10.PARTS but have not committed, member 1 holds global locks.

  2. Run SPUFI, using member DSNTESD as input, on member 2.
    Specify AUTOCOMMIT=NO.

    Because member 1 holds global locks, member 2 must wait to perform the insert.

  3. In less than one minute, commit on member 1.
    (If you wait too long to commit, member 2 will experience a lock timeout.)

    The global locks should be released, and member 2 should be able to proceed. Verify that ITEM_COUNT has increased by five.