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.

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 DSN8C10.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.