We are using WTX 8.2 as a map node in WMB to updating a DB2 table, while test we are facing some inconsist behavior because we use same file for updating DB2 some times WTX is connecting to DB2 succuessfully and some times NOT..please some one help us to resolve this issue below is the DB trace..
<1257712-2930>: Validating the adapter command...
<1257712-2930>: Database type is DB2
<1257712-11633>: Connection from pool is being reused.
<1257712-11633>: Interface library version 8.2.0.4(178)_64bit
<1257712-11633>: Map: mapname.mmc, Timestamp: Fri Apr 16 08:35:03 2010.
<1257712-11633>: Data being retrieved for DBQUERY function.
<1257712-11633>: Database adapter: DB2 Version 8.2.0.4(178)_64bit
<1257712-11633>: Starting a database unload...
<1257712-11633>: Query : "sql query"
<1257712-11633>: DBQUERY Function, Transaction scope: Map
<1257712-11633>: TRACE command specified, append mode, file: mapname.dbl
<1257712-11633>: Retrieving 1 rows per fetch.
<1257712-11633>: Error in SQLExecDirect
Message: [IBM][CLI Driver][DB2] SQL30108N A connection failed but has been re-established. The hostname or IP address is "db2_iodb2t0g_test" and the service name or port number
is "14056". Special registers may or may not be re-attempted (Reason code = "1"). SQLSTATE=08506
SQL State: 08506
<1257712-11633>: Returned status: (-1009) Failed_to_execute_the_SQL_statement
<1257712-11633>: Cleaning up and closing the transaction...
<1257712-11633>: Transaction commit succeeded.
<1257712-11633>: Returned status: (0) Success
<1257712-2930>: Validating the adapter command...
<1257712-2930>: Database type is DB2
<1257712-11633>: Connection from pool is being reused.
<1257712-11633>: Interface library version 8.2.0.4(178)_64bit
<1257712-11633>: Map: mapname.mmc, Timestamp: Fri Apr 16 08:35:03 2010.
<1257712-11633>: Data being retrieved for DBQUERY function.
<1257712-11633>: Database adapter: DB2 Version 8.2.0.4(178)_64bit
<1257712-11633>: Starting a database unload...
<1257712-11633>: Query : "sql query"
<1257712-11633>: DBQUERY Function, Transaction scope: Map
<1257712-11633>: TRACE command specified, append mode, file: mapname.dbl
<1257712-11633>: Retrieving 1 rows per fetch.
<1257712-11633>: Error in SQLExecDirect
Message: [IBM][CLI Driver][DB2] SQL30108N A connection failed but has been re-established. The hostname or IP address is "db2_iodb2t0g_test" and the service name or port number
is "14056". Special registers may or may not be re-attempted (Reason code = "1"). SQLSTATE=08506
SQL State: 08506
<1257712-11633>: Returned status: (-1009) Failed_to_execute_the_SQL_statement
<1257712-11633>: Cleaning up and closing the transaction...
<1257712-11633>: Transaction commit succeeded.
<1257712-11633>: Returned status: (0) Success