0 - 1 of 1 tags for transaction abort
Transaction Deadlock issue in BTEQ - Failure 3510 Too many END TRANSACTION statements

I have 2 BTEQs having following type of Statements. Both are submitted at the same time and both are trying to insert in the same table.

BTEQ1
---------------------------------
BT;
INSERT INTO T1 SEL * FROM GTT;
.IF ERRORCODE <> 0 THEN .GOTO LABELS
ET;
.IF ERRORCODE <> 0 THEN .GOTO LABELS
.QUIT
.LABEL LABELS
.QUIT ERRORCODE

BTEQ2
---------------------------------
BT;
INSERT INTO T1 SEL * FROM GTT;
.IF ERRORCODE <> 0 THEN .GOTO LABELS
ET;
.IF ERRORCODE <> 0 THEN .GOTO LABELS
.QUIT
.LABEL LABELS
.QUIT ERRORCODE

-----------------------------

By Animesh_Dutta, 17 Jun 2010 | Tagged: bteq deadlock transaction abort end transaction 2631 3510 | 1 comment