The SQL compilation problem scenario is simulated by a java programlocking.java
available in "[tutorial-base-directory]/extras"
directory.
This program is listed on the right pane.
This program invokes five threads. One thread acquires a lock on a row of INVENTORY
table. To acquire lock on the same row, the remaining threads wait for the lock to be released from the first thread hence introducing lockwait in system.
set PATH=<DB2 install path>java\jdk\bin;%PATH%
export PATH=<DB2 install path>/java/jdk/bin:$PATH
"[TE-directory]/tutorials/Workshops/MonitoringWorkshop/LockWaitProblem/extras"
directoryjavac locking.java
java locking <userid> <password> <hostname> <DB2_port_number>