DB2: A connection failed but has been re-established

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
kurapatisrk
Premium Member
Premium Member
Posts: 15
Joined: Wed Feb 24, 2010 6:37 pm
Location: United States

DB2: A connection failed but has been re-established

Post 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 ?
Thanks
Ksrk
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

The first thing I'd do would be an internet search for SQLSTATE=08506
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
siauchun84
Participant
Posts: 63
Joined: Mon Oct 20, 2008 12:01 am
Location: Malaysia

Post 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)?
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”