in DB2 UDB version 8, there is a new load option. It is called LOCK WITH FORCE and does just that. Sorry I can't tell if DB2/390 offers something similar.
Are you positive that forcing off the other threads is a good idea? After all their transactions will roll back then.
Another option would be to program retry and restart capabilities into your load job - or doing imports instead, albeit this would be significantly slower.
Originally posted by sureshkarthik
I have a DB2 Table on OS390 which is heavily used.
When I try to load this table, sometimes there are threads using this table and my Load job fails. Is there a way in which I can cancel threads (if any) attached to this tablespace before I start my Load process??
Thanks in Advance.