I'm running an old DB2 v7.1 AIX 4.3.
I wrote a script to export some data from couple tables (production environment). Everytime I ran this script, users complain to have dead locks or lock-wait problems. If I check through get snapshot for locks for example I see couple users in Lock-wait...as soon as I cancel the shell (export) script execution all locks are cleared. How come a simple export can cause locks if I'm just doing a select statement? What can I do in order to fix this situation?
Is there any other way to unload (batch) those files without locking everybody out?

Thanks

I can't remember if V7 supports WITH UR clause on a select. Try it and see.

db2 export to employee.ixf of ixf select * from employee with ur

Thanks for the tip, but unfortunately DB2 v7.1 doesn't support such SELECT clasue. Do you know anything else that I could try?