none
DB2 adapter Transaction time out and DUW transaction mode RRS feed

  • Question

  • I ahve a requirement where  I  have to read a DB2 file , process, Debatch and then  delete the read records from Db2 .

    I wanted to use DUW because I want to make sure the records are only deleted after the debatch/publish is success.I ahve a custome pipe line that does   this and it works with RUW ..But with DUW  I get  error like below.I was processign a big file and most probably the transaction time out ..How is the Db2 adapters transaction time out set  ?? I didn't see a property to set it ?

    Error :

    The following stored procedure call failed: " { call [dbo].[bts_InsertMessage]( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)}". SQL Server returned error string: "The Microsoft Distributed Transaction Coordinator (MS DTC) has cancelled the distributed transaction.".

    How is the Db2 adapters transaction time out set  ?? I didn't see a property to set it ?

     

    Monday, January 3, 2011 11:51 PM