Help Reqd: Unable to load data into the target table

Formally known as "Mercator Inside Integrator 6.7", DataStage TX enables high-volume, complex transactions without the need for additional coding.

Moderators: chulett, rschirm

Post Reply
kiranredz
Premium Member
Premium Member
Posts: 21
Joined: Wed Aug 06, 2008 8:34 am
Location: United States

Help Reqd: Unable to load data into the target table

Post by kiranredz »

Hi,

I am able to connect to my remote database server using ODBC.
I am successfully able to create type trees with this connection definition.

When I run my maps to load a flat file into the database, the map loads data into the tables for the first couple of times.

From the next run, I get a message saying target not available

What would be the possible issue?
I am wondering how I can debug this issue. Please help me.

Thanks in advance
Kiran
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Have you checked that the diagnosis is accurate - that is, the database server itself is actually unavailable, or has too many connections?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
kiranredz
Premium Member
Premium Member
Posts: 21
Joined: Wed Aug 06, 2008 8:34 am
Location: United States

Post by kiranredz »

ray.wurlod wrote:Have you checked that the diagnosis is accurate - that is, the database server itself is actually unavailable, or has too many connections? ...
Yes sir. The database server is available.
As you said, may be there are too many connections to the remote machine.

I get the same error at times when I run my maps in my local machine too. Now, the database server is installed in my local machine; am trying to access the table in my local DB.

Thanks.
Kiran
Kiran
jvmerc
Participant
Posts: 94
Joined: Tue Dec 02, 2003 12:57 pm

Post by jvmerc »

The standard map log will be insufficient when dealing with DB errors. You'll want to follow Rep's advice and turn on the db trace '-t'. run the map and look for a dile extention of 'dbl' unless you override the trace file name.
Post Reply