DB2 Load Utility DSNUPROC

Nagendran · New User Joined: 24 Jan 2007 Posts: 89 Location: USA

Hi,
I am running a DB2 load utiliy (DSNUPROC), since the utility is holding exclusive lock on the table all the online screens which is accessing the table are abending.(Resource is Not availabe, SQL code -904).

Is there any way to avoid this exclusive lock. I want my online screens to access the DB2 table when the Utility is running. Is there any way to do this.....

Will unload utility also put exclusive lock on the table?

Thanks,
Nagendran.R

enrico-sorichetti · Posted: Wed Nov 12, 2008 5:27 pm

I suspect a poor planning.....

how in &HEAVEN can You expect to do other useful processing while loading ?
what about data consistency

NO

YES

P.S.
review all the activities that have to be done when loading a table

Nagendran · New User Joined: 24 Jan 2007 Posts: 89 Location: USA

Hi,

thanks for ur response..

Will unload job also put exclusive lock on the table?

thanks,
Nagu

Arun Raj · Posted: Wed Nov 12, 2008 8:39 pm

dick scherrer · Posted: Wed Nov 12, 2008 9:46 pm

Hello,

What use is an unload if the data being unloaded is being changed while the unload is running?

If the goal is to get some "real" test data, this might be ok, but i would not want such a file to be used for production reporting or providing data to some other system.

As Enrico mentioned - poor planning. . .