Issue with UPDATE QUERY using EXISTS clause causing slow Tablespace scans in DB2

Issue with UPDATE QUERY using EXISTS clause causing slow Tablespace scans
in DB2

References

Reference NO 1

http://stackoverflow.com/questions/15192549/issue-with-update-query-using-exists-clause-causing-slow-tablespace-scans-in-db2

Reference NO 2

http://stackoverflow.com/questions/17164003/db2-how-to-ensure-the-tablespace-is-clean-to-drop

Reference NO 3

http://stackoverflow.com/questions/14254637/perform-update-based-on-a-join-in-db2

Reference NO 4

http://stackoverflow.com/questions/7673496/efficient-way-to-update-db2-database-rows

Reference NO 5

http://stackoverflow.com/questions/7243026/how-do-i-remove-check-pending-state-from-a-db2-tablespace-on-z-os

Reference NO 6

#EANF#

Reference NO 7

#EANF#

Reference NO 8

#EANF#