DB2 Adapter error: Processing was cancelled due to an interrupt. SQLSTATE: 57014, SQLCODE: -952 RRS feed

  • Question

  • Hi,

    we have an error that has started to occur once a query is run against the production database. Before this the query executed a lot quicker may be 20 second or so. Now the underlying query takes about 2.5 minutes to run.

    We are trying to run our query against a DB2 9.5.4 database running on Solaris 10.

    It seems to me that the DB2 adapter is using the default command timeout for the DB2 .NET provider of 30 seconds.

    I cannot find anyway to configure the DB2 adapter to run queries that run longer than 30 seconds.

    Can anyone confirm that this a limitation for th Db2 adapter querying against a DB2 9.5.4 database running on Solaris 10?

    • Edited by mreddienz2 Wednesday, October 3, 2012 8:44 PM
    Wednesday, October 3, 2012 2:51 AM

All replies

  • Hi,

    If you are using BizTalk together with HIS (Host Integration Server) or BAHA (BizTalk Adapters for Host Systems), you can use the ConnectionTimeout Property on the MsDb2Connection Member.

    Best Regards,

    Steve Melan - BCEE My Blog :

    Wednesday, January 9, 2013 5:23 PM