DSXchange

HI , Iam looking for some explanation on the behaviour of Oracle enterprise stage . Iam issuing a delete command to the oracle stage and i also have a reject link out from the oracle stage. When there are no delete happening, the oracle returns - No records or zero records deleted. It is not conside...

Thanks every one for Helping. Using a To_Char was the final solution i had to adapt to over come this issue. UPDATE /*+ INDEX ACCOUNTS_TEST.ACC_PRIMEE*/ PBOND.ACCOUNTS_TEST SET ACC_LAST_CHANGE_BY = ORCHESTRATE.ACC_LAST_CHANGE_BY , ACC_LAST_CHANGE_DATE = ORCHESTRATE.ACC_LAST_CHANGE_DATE and so on WHE...

THanks every one for the reply. The problem i have identified was the update statement was issued based on 3 key columns which is part of the INdex as well. I have a column called Account_No which is Varchar but we receive only numeric data to it. When i modify the update statement by adding a to_ch...

Thanks for your reply chulett The DBA have monitored while the job was running.It looks like the index not been used the job.This is because it does a full a table scan and to update 9000 records it hits the table for about 19 million read. Aslo can you please let me know what the 'leading edge on t...

HI , Iam trying to update a Oracle Table. The table was analyzed and statistics computed before issuing update statement. The update statement is something like this. UPDATE /*+ INDEX ACCOUNTS_TEST.ACC_PRIMEE*/ PBOND.ACCOUNTS_TEST SET ACC_LAST_CHANGE_BY = ORCHESTRATE.ACC_LAST_CHANGE_BY , ACC_LAST_CH...

The parameters used in one of the job you are calling might have an empty string or space at the end of the value for the parameter.
Make sure all spaces are trimmed for the parameter values and then recompile your sequence.

HI, Thanks for everybody who replied . I understand the option available through the wrapper script/perl script to issue warn option . But the scripts are developed by third party , so change in script means, a CR to be raised and money to be spent. So client is keen to do it at the Datastage level....

HI , The requirement is to abort the job immediately once it start giving warnings. The job will be run by third party tools like Autosys, so i cannot specify warning limits which you have while running the job. Is anyone aware of any routine in DS or custom built which would scan my logs real time ...

Thanks,

The following viewtopic.php?t=93324&postdays=0&postorder=asc&start=0 helped a lot.
I believe now i can configure the dsdlockd.config file under the engine and kill my locks .
Great tip and help.
Thanks

HI, We are connecting to DS client through agents like citrix client, and after a few minutes of inactive session citrix disconnects and hence my connection to Datastage. This creates a lot of Inactive session in the server and when i use ps -fu dsadm|grep dsapi there are lot of slave or inactive se...

HI,

Did you find a solution to this problem.IAm also facing an similar problem with my jobs.
Can you kinldy post your observations.

Thanks
Kamesh

Thanks very much for the timely information. We have few quality stage Job which is deployed thru WISD to make it available for MDM application. One of the job is aborting , (reason not known since RTLogging was not enabled). Since the job is called by WISD , it tries to run continuously with differ...

The entire Gb space conatains this error. The file keeps growing ; nested exception is: javax.ejb.EJBException: nested exception is: java.sql.SQLException: [IBM][Oracle JDBC Driver][Oracle]ORA-01653: unable to extend table XMETA_OWNER.LOGGING_LOGGINGEVENT1466CB5F by 8192 in tablespace INFOS_XMETA_DA...

HI, i have a 14G space allocated to /opt/IBM folder but this space gets filled by certain log files . I have found certain files under /opt/IBM/InformationServer/ASBNode/bin occupying around 4G of space. The file names are -rw-r--r-- 1 root root 1006275756 Apr 7 13:37 orbtrc.05042010.2211.46.txt -rw...

Chiswick is definitely an Proper Location in London