DSXchange

Hi,

we run here SQLs on DB2 through ODBC stage. usually it works fine, but in some cases the query gets stuck after a while. so far we got stuck trying to select from 2 tables: first query 2 columns and got stuck after 3812 and the second got 65 columns and got stuck after 300 records.

we think that once the first buffer is getting full it stops reading data from the DB. the jobs keep on running for hours (until we stop them) but without doing anything.

does anyone know what might cause it?

Keren

Welcome aboard! :D

Does the same thing occur when you execute the same SELECT statements using the diagnostic command DS_CONNECT?

Can you successfully perform the query from a different client on the DataStage server machine?

hi again,

we run the same query through Bosonova emulator, which sits on the same client and it is working ok.

how do I run it through DS.connect?

Keren

You can use the Administrator client command window or a telnet session to the DataStage server before invoking dssh there while attached to a project directory.

DS_CONNECT is invoked as a command. It takes the DSN as its command line argument. It prompts for user name and password. You then enter SQL till you're finished. Exit from DS_CONNECT back to dssh using the .Q command.

Hello...

after 10 minutes the DS.CONNECT still does not give any feedback. dince I have no group by or order by, I asume it is stuck as well....

Keren

Hi (my welcome aboard was sent via private message ),
For other people lets make it clear your talking about the DS_CONNECT command.

Try having your DB2 poeple debug the connection and perhaps enable server side trace in the DS side.

Your first objective is to figure out what is blocking the flow?

Is it that the DB isn't supplying rows?
Or
the DS process isn't asking for more rows?

I know your working on a remote location,
So try getting Uri to do it.

IHTH,

Hi All,
AFAIK from onsite report:
A new downloded DataDirect driver seems to have resolved this problem.

All's well that ends well