Hi,

I am using db2 Load utility to load data to a table. But whenever i get db2 exception i need to check the status of a table whether the table is in Load pending state or is in Load In progress state. accordingly i should terminate or unset the Load attribute of a table. For this I am using db2LoadQuery() method to fetch the table status info. This works when there is one or two threads accessing same table, but fails if multiple threads accessing same table. I could not reset the table state to normal when there is db2 exception..... Can anyone tell me how use this db2LoadQuery method? Is this method a thread safe?

Thanks in advance,

Suresh
Bangalore

there are 2 commands
db2 load query table xxx.yy
db2 list utilities show detail