INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!

Talk With Other Members
Be Notified Of Responses
To Your Posts
Keyword Search
One-Click Access To Your
Favorite Forums
Automated Signatures
On Your Posts
Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Tek-Tips LinkedIn^® Group

Join our
LinkedIn^® Group!

Hook up with past and present colleagues and classmates quickly.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site

(Download This Button Today!)

Feedback

"...I've gotten solutions within a day - it saved a lot of time and actually got me one ATTABOY from my boss..."

More...

Geography

Where in the world do Tek-Tips members come from?

Click Here To Find Out!

Tek-Tips Shirts!

Get your
Tek-Tips Forums
SWAG here!

Home > Forums > Programmers > EAI Distributed/Component Programming > Mercator Software: Mercator solutions Forum

Inconsist DB2 adapter behavior

Read More Threads Like This One

NVK (IS/IT--Management)

20 Apr 10 2:03

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

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Back To Forum

Back To Mercator Software: Mercator solutions