RE: [sqr-users] Inserting Large amount of flat file data with SQR inDB2 creating dead locks when run concurrently after file splitinto chunks

["Tritt, Merrill" <MerrillTritt@spherion.com>]

Naiu, you wish to run concurrent jobs all attempting to insert rows into the 
same table?


-----Original Message-----
From: Arnipalli, Naidu N [LTD] [mailto:appala.a.naidu@mail.sprint.com]
Sent: Saturday, February 28, 2004 7:14 PM
To: sqr-users@sqrug.org
Subject: [sqr-users] Inserting Large amount of flat file data with SQR
in DB2 creating dead locks when run concurrently after file split into
chunks


All,

        I need to insert and update large amount of data from flat files to a 
set of tables.
        For performance reasons, the files are split into multiple chunks and 
each chunk is
        used as input for loading at the same time. Once the row is inserted, 
the next row is
        incremented and the rowid is running into either duplicate or dead lock 
issue when 
        all the sessions are running.

        Has anyone implemented with SQR in DB2? 

Thanks in advance.
Naiu
        

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users