Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Inconsist DB2 adapter behavior

Status
Not open for further replies.

NVK

IS-IT--Management
Mar 24, 2010
4
US
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



 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top