Page 1 of 1

DB2: A connection failed but has been re-established

Posted: Wed Jul 10, 2013 3:20 pm
by kurapatisrk
Hello guru's,

I am back with a issue elaborated below...


I have a job below...

dataset ------> DB2 Connector

Job runs and after sometime aborts with the below error..

A connection failed but has been re-established. The hostname or IP address is "XXXXXX" and the service name or port number is "XXXX". Special register settings might have been replayed. (Reason code = "1"). SQLSTATE=08506

Can anyone help me with this ?

Posted: Wed Jul 10, 2013 3:59 pm
by ray.wurlod
The first thing I'd do would be an internet search for SQLSTATE=08506

Posted: Fri Jul 12, 2013 3:57 am
by siauchun84
Information limited.

1. DS Server has DB2 installed?
2. What is the result of client connectivity from DS server to DB2 (without through DS)?