DSXchange

Hello everyone, As suggested by chulett, I asked DBA the trace log. I found a deadlock between two different rows due to a "deadlock" on the same unique index. On both the rows, the same field was updated; this field is part of the primary key. Hence the deadlock. The suggestion of our DBA...

Ohh, Ok.
I will ask to my DBA for trace file.....
Do you think it is some problem related to the table?
What should I expect, in your opinion?

Thanks

Hello everyone, I am writing to ask for your help. I have a job structured as follows: DS -> RD -> CONNECTOR (ONLY UPDATE) This job updates more than 30,000,000 records on target table. Key of update is a subset of primary key, hence the presence of Remove Duplicate to which I added a HASH / SORT fo...

Hello to all, I think I have discovered the cause of the problem. After studying various links on the IBM support: https://www-304.ibm.com/support/docview.wss?uid=swg21509567 http://www-01.ibm.com/support/docview.wss?uid=swg21447204 https://www-304.ibm.com/support/docview.wss?uid=swg21452589 and rea...

Thank you for link.
I'm trying to change some settings....
I'll let you know.
Sandro

Hi all, thanks a lot for your help and suggestions. Unfortunately, there is NO error on logs!!!! Log4j in file DSODBTuning.cfg are set to INFO: log4j.logger.com.ibm.datastage=INFO log4j.logger.com.ibm.datastage.runtime.common=INFO log4j.logger.com.ibm.datastage.runtime.engmonapp=INFO log4j.logger.co...

Hi Ray,
no I can't. Server Configuration doesn't permitte this kind of test.

Being a java application, do you know if there is some way to view more application log?

Thanks a lot
Sandro

DB password doesn't expire. DBAs are able to connect to DSODB via sqlplus.
DSODB ( Oracle installation ) is in same local instance of XMETA.
Configuration of server of my customer is all-in-one: engine+repository+AppServ.

Result of ipcs -rs | wc -l is under 500.

Nothing happens.
We restart console more time, and every time DSAppWatcher -status and -test tells us all services are OK.




Thanks,
Sandro

HI gurus, we installed in test env operation console. After installation, it worked fine for some time. Later, for unexplained reasons, it stopped to work fine. I explain my assertion. On server, dsAppwatcher -status and -test tell us that : /opt/IBM/InformationServer/Server/DSODB/bin/DSAppWatcher.s...

Hi gurus,
thanks for your replies.
I tried unix diff command on .dsx: yes, madness!!!!
Ok, I think I'll search for UltraCompare or some similar.
Sandro

Hi all,
is there a tool in Datastage or in Information Server to compare all the jobs of two project?
If not, is there some workaround or good practice to achieve the same result?
Thanks in advance,
Sandro

Thanks,
Cheers

Thank you for your response.
So, the use of one or the other doesn't change the result loaded in target oracle table?

But, exists some best practices?

Thanks,
Cheers

Hi all, I ask for a clarification about data type when use Oracle Connector Stage both for selecting and inserting data. What is best practice about mapping Oracle data type DATE ? Is it better to map DATE Oracle to Timestamp or Date Datastage? What is the difference? The same question applies for d...