[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

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

Subject: RE: [sqr-users] Inserting Large amount of flat file data with SQRinDB2 creating dead locks when run concurrently after filesplitinto chunks
From: "Arnipalli, Naidu N [LTD]" <appala.a.naidu@mail.sprint.com>
Date: Mon, 1 Mar 2004 12:14:56 -0600
Delivery-date: Mon, 01 Mar 2004 13:16:03 -0500
List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
Thread-index: AcP8dXN1fwqRk+9XQPSeZ+ebuEEutgB4dBrAAFbPthAAAaF8IA==
Thread-topic: [sqr-users] SQR run in DB2 with commits in the code

Yes Merrill.

Thanks
A.A.Naidu
Sprint North Supply
Ph:(913) 791 7000 X 8629
Email: appala.a.naidu@mail.sprint.com


-----Original Message-----
From: sqr-users-bounces+appala.a.naidu=mail.sprint.com@sqrug.org
[mailto:sqr-users-bounces+appala.a.naidu=mail.sprint.com@sqrug.org]On
Behalf Of Tritt, Merrill
Sent: Monday, March 01, 2004 11:29 AM
To: sqr-users@sqrug.org
Subject: RE: [sqr-users] Inserting Large amount of flat file data with
SQR inDB2 creating dead locks when run concurrently after file splitinto
chunks


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
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users