Hi,

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.
Best Regards,
Suresh Karthik.

Hi,

I haven't worked on OS/390 but what I can suggest is that you can quesice the tablespace and then do the load.

Please read on the quesice command for more details.

cheers

Nitin

Hi Suresh,

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.

Johann

Quiesce the tablespace using the QUIESCE utility. Then stop the tablespace (using the STOP DATABASE command with the SPACENAM option). You can use the FORCE option if necessary.

Then start the tablespace in utility (UT) mode (using the START DATABASE command with the SPACENAM option). Be sure to start the tablespace in RW mode after the load.

At this level of operation, DB2 for OS/390 does not have much in common with other DB2 platforms.

Hi

And if you are at DB2 V7 you can choose the SHRLEVEL CHANGE option. Then there is no need to cancel any threads. The following restrictions hold for this option: LOG YES and RESUME YES.

Before doing anything, you have to check what are those threads and which application is accessing the data.
There is a tool called OMEGAMON using which you can monitor the threads and if the application is just holding the threads for a long time without any action, you can kill the threads.

If you are using BMC, you can view the threads by just doing a
DIS LOCKS or DIS CLAIMERS on the tablespace..