RE: [sqr-users] Inserting Large amount of flat file datawithSQRinDB2 creating dead locks when run c

["George Jansen" <GJANSEN@aflcio.org>]

The more powerful (and expensive) databases commonly use row-level
locking. What you are describing is certainly doable with Oracle, and
documented in the manuals. Given DB2's Big Blue origins, I'd be
surprised to hear that it doesn't have row-level locking,  but I don't
know how you'd accomplish it. 

Really this is a question for an experienced DB2 database
administrator. The underlying logic should be the same for any tool, be
it SQR, Perl, or the native load tool.




>>> MerrillTritt@spherion.com 03/01/04 02:10PM >>>
To my knowledge, you can't do this.  One process will lock the table
with uncommitted transactions and prevent the other processes from
accessing that table.  Unless anyone else has any additional info, my
best suggestion would be to rethink your load process.

-----Original Message-----
From: Arnipalli, Naidu N [LTD] [mailto:appala.a.naidu@mail.sprint.com]

Sent: Monday, March 01, 2004 1:15 PM
To: This list is for discussion about the SQR database reporting
languagefrom Hyperion Solutions.
Subject: RE: [sqr-users] Inserting Large amount of flat file data with
SQRinDB2 creating dead locks when run concurrently after filesplitinto
chunks


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 


_______________________________________________
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