[sqr-users] Inserting Large amount of flat file data with SQR in DB2 creating dead locks when run concurrently after file split into chunks

["Arnipalli, Naidu N [LTD]" <appala.a.naidu@mail.sprint.com>]

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