Hi

I have 5 files which inserts data into exception table using Load utility.when i execute all 5 file concurrently table gets into loaad pending state.

So i used load terminate.

But is it possible to check if the table is being accesed by some other process then continue the load.

you can either take Snapshot for the entire application or take a snapshot for Locks during the time you start your LOAD utility.

Is there any RI between these tables or any relationship among them?

All 5 files use same exception table
How shld I tk snapshot of locks

Ok. Look when you start the Load utility on a single table, the utility holds a X (exclusive Lock) on that table. So you should n't try to load all the files to the same table at the same. You can write a shell script which will pick the files one by one and process them with the LOAD command. Or you can try that manually. You can just type "GET SNAPSHOT" in the IBM Manual for V8 or V9. It will give you example with commands on how to take Snapshot on Locks.