Dbload Question

Hi, I am trying to use dbload to load two files into a database simultaneously in two separate sessions. The first load works but it seems that the second one is waiting for the first to finish. I'm sure I got this to work before. The onstat -g sql of the second shows (a lock statement) (Last parsed SQL statement : lock table month in share mode) Any advice? Thanks, Tony

Yes, dbload takes an exclusive lock on the table by defailt. Add the -r flag to prevent the lock. Art S. Kagel ----- Original Message ----- From: Tony Demeis <ids@iiug.org> At: 1/30 13:04 Hi, I am trying to use dbload to load two files into a database simultaneously in two separate sessions. The first load works but it seems that the second one is waiting for the first to finish. I'm sure I got this to work before. The onstat -g sql of the second shows (a lock statement) (Last parsed SQL statement : lock table month in share mode) Any advice? Thanks, Tony ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.