Originally posted by karthiven
I knew from the article in DB2Mag that shrlevel change does claims and not drains. I was wondering if I could have contentions with CICS trans doing updates to the same table against which a load with shrleve change was running.
Yes, you could indeed have contentions! Basically LOAD SHRLEVEL CHANGE is doing a mass insert, and you must understand all pros and cons. But in REAL LIFE, if table is very seldomly updated, go ahead. Even if you'll wrote a CICS-transaction, problem still exists.