Re: Transactions
Re: Transactions
This is a topic for an orphaned message.
You cant "retry" a transaction.
Im wondering under what circumstances you would want to retry a transaction. If it failed the first time, isnt it going to fail each time you retry?
An example would be useful.
-----Original Message-----
From: Dimple [SMTP:dimpsdimps@rediffmail.com]
Sent: Friday, May 11, 2001 1:58 PM
To: informix-datastage@oliver.com
Subject: Re: Re: Transactions
Hi,
Thanks for ur reply.
I was also not clear whether we can define the number of times a transaction can be retried.
Regards
Dimple
------------- Original Message --------------
"Allen Spayth - wwc" wrote: To:
From:"Allen Spayth - wwc"
Date:Thu, 10 May 2001 07:13:05 -0700
Subject:Re: Transactions
Dimple,
Imagine a job design which inserts a row into table "A" and Updates a row in
table "B". You can setup transaction control such that if the insert into
table "A" fails it will not Update table "B". Likewise if the "B" transaction fails the "A" transaction will be rolled back. I have seen a modified version of this technique used to accomplish a two phase commit across multiple data bases (tricky design but worked pretty good). Im not aware of any timeout feature but you might want to request this as an
enhancement. I suggest that you play with a small set of data that you can
manipulate. For example a dup key or null value in a not null constrained column so that you can play with the transaction control/failure for a complete understanding.
Regards,
Allen
----- Original Message -----
From: "Dimple"
To:
Sent: Wednesday, May 09, 2001 8:31 PM
Subject: Transactions
> Hi All
> Can anybody put some light on transaction concept
> Can we define the number of retry times for a transaction if a
> transaction
fails
> Also is there any transaction timeout concept
>
> Thanks a lot
> Dimple
>
>
> _____________________________________________________
> Chat with your friends as soon as they come online. Get Rediff Bol at
> http://bol.rediff.com
>
>
>
>
_____________________________________________________
Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.com
*************************************************************************
This e-mail and any files transmitted with it may be confidential and are intended solely for the use of the individual or entity to whom they are addressed. If you have received this e-mail in
error, please notify the sender by return e-mail, and delete this e-mail from your in-box. Do not copy it to anybody else
*************************************************************************
Im wondering under what circumstances you would want to retry a transaction. If it failed the first time, isnt it going to fail each time you retry?
An example would be useful.
-----Original Message-----
From: Dimple [SMTP:dimpsdimps@rediffmail.com]
Sent: Friday, May 11, 2001 1:58 PM
To: informix-datastage@oliver.com
Subject: Re: Re: Transactions
Hi,
Thanks for ur reply.
I was also not clear whether we can define the number of times a transaction can be retried.
Regards
Dimple
------------- Original Message --------------
"Allen Spayth - wwc" wrote: To:
From:"Allen Spayth - wwc"
Date:Thu, 10 May 2001 07:13:05 -0700
Subject:Re: Transactions
Dimple,
Imagine a job design which inserts a row into table "A" and Updates a row in
table "B". You can setup transaction control such that if the insert into
table "A" fails it will not Update table "B". Likewise if the "B" transaction fails the "A" transaction will be rolled back. I have seen a modified version of this technique used to accomplish a two phase commit across multiple data bases (tricky design but worked pretty good). Im not aware of any timeout feature but you might want to request this as an
enhancement. I suggest that you play with a small set of data that you can
manipulate. For example a dup key or null value in a not null constrained column so that you can play with the transaction control/failure for a complete understanding.
Regards,
Allen
----- Original Message -----
From: "Dimple"
To:
Sent: Wednesday, May 09, 2001 8:31 PM
Subject: Transactions
> Hi All
> Can anybody put some light on transaction concept
> Can we define the number of retry times for a transaction if a
> transaction
fails
> Also is there any transaction timeout concept
>
> Thanks a lot
> Dimple
>
>
> _____________________________________________________
> Chat with your friends as soon as they come online. Get Rediff Bol at
> http://bol.rediff.com
>
>
>
>
_____________________________________________________
Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.com
*************************************************************************
This e-mail and any files transmitted with it may be confidential and are intended solely for the use of the individual or entity to whom they are addressed. If you have received this e-mail in
error, please notify the sender by return e-mail, and delete this e-mail from your in-box. Do not copy it to anybody else
*************************************************************************
Hi,
Thanks for ur reply.
I was also not clear whether we can define the number of times a transaction can be retried.
Regards
Dimple
------------- Original Message --------------
"Allen Spayth - wwc" wrote: To:
From:"Allen Spayth - wwc"
Date:Thu, 10 May 2001 07:13:05 -0700
Subject:Re: Transactions
Dimple,
Imagine a job design which inserts a row into table "A" and Updates a row in
table "B". You can setup transaction control such that if the insert into
table "A" fails it will not Update table "B". Likewise if the "B" transaction fails the "A" transaction will be rolled back. I have seen a modified version of this technique used to accomplish a two phase commit across multiple data bases (tricky design but worked pretty good). Im not aware of any timeout feature but you might want to request this as an
enhancement. I suggest that you play with a small set of data that you can
manipulate. For example a dup key or null value in a not null constrained column so that you can play with the transaction control/failure for a complete understanding.
Regards,
Allen
----- Original Message -----
From: "Dimple"
To:
Sent: Wednesday, May 09, 2001 8:31 PM
Subject: Transactions
> Hi All
> Can anybody put some light on transaction concept
> Can we define the number of retry times for a transaction if a
> transaction
fails
> Also is there any transaction timeout concept
>
> Thanks a lot
> Dimple
>
>
> _____________________________________________________
> Chat with your friends as soon as they come online. Get Rediff Bol at
> http://bol.rediff.com
>
>
>
>
_____________________________________________________
Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.com
Thanks for ur reply.
I was also not clear whether we can define the number of times a transaction can be retried.
Regards
Dimple
------------- Original Message --------------
"Allen Spayth - wwc" wrote: To:
From:"Allen Spayth - wwc"
Date:Thu, 10 May 2001 07:13:05 -0700
Subject:Re: Transactions
Dimple,
Imagine a job design which inserts a row into table "A" and Updates a row in
table "B". You can setup transaction control such that if the insert into
table "A" fails it will not Update table "B". Likewise if the "B" transaction fails the "A" transaction will be rolled back. I have seen a modified version of this technique used to accomplish a two phase commit across multiple data bases (tricky design but worked pretty good). Im not aware of any timeout feature but you might want to request this as an
enhancement. I suggest that you play with a small set of data that you can
manipulate. For example a dup key or null value in a not null constrained column so that you can play with the transaction control/failure for a complete understanding.
Regards,
Allen
----- Original Message -----
From: "Dimple"
To:
Sent: Wednesday, May 09, 2001 8:31 PM
Subject: Transactions
> Hi All
> Can anybody put some light on transaction concept
> Can we define the number of retry times for a transaction if a
> transaction
fails
> Also is there any transaction timeout concept
>
> Thanks a lot
> Dimple
>
>
> _____________________________________________________
> Chat with your friends as soon as they come online. Get Rediff Bol at
> http://bol.rediff.com
>
>
>
>
_____________________________________________________
Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.com