Search found 43 matches
- Wed Dec 07, 2011 8:03 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reject on zero delete from Oracle enterprise stage
- Replies: 0
- Views: 1139
Reject on zero delete from Oracle enterprise stage
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...
- Mon Dec 05, 2011 5:12 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Very slow UPSERT by oracle Enterprise Stage
- Replies: 8
- Views: 4987
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...
- Mon Dec 05, 2011 4:31 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Very slow UPSERT by oracle Enterprise Stage
- Replies: 8
- Views: 4987
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...
- Fri Dec 02, 2011 10:46 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Very slow UPSERT by oracle Enterprise Stage
- Replies: 8
- Views: 4987
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...
- Fri Dec 02, 2011 9:38 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Very slow UPSERT by oracle Enterprise Stage
- Replies: 8
- Views: 4987
Very slow UPSERT by oracle Enterprise Stage
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...
- Mon Sep 05, 2011 8:04 am
- Forum: General
- Topic: Error while compiling job sequence
- Replies: 3
- Views: 3720
- Wed Aug 11, 2010 3:09 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Abort Job immediately after warning
- Replies: 6
- Views: 3333
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....
- Tue Aug 10, 2010 9:54 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Abort Job immediately after warning
- Replies: 6
- Views: 3333
Abort Job immediately after warning
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 ...
- Tue Aug 03, 2010 7:23 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Inactive sessions
- Replies: 3
- Views: 3440
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
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
- Tue Aug 03, 2010 3:24 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Inactive sessions
- Replies: 3
- Views: 3440
Inactive sessions
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...
- Mon Jul 26, 2010 4:09 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Warnings in ODBC Connector Stage when Table Action = APPEND
- Replies: 3
- Views: 3127
Re: Warnings in ODBC Connector Stage when Table Action = APP
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
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
- Tue Apr 13, 2010 9:50 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Disk Space getting filled
- Replies: 7
- Views: 8356
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...
- Tue Apr 13, 2010 8:42 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Disk Space getting filled
- Replies: 7
- Views: 8356
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...
- Tue Apr 13, 2010 7:27 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Disk Space getting filled
- Replies: 7
- Views: 8356
Disk Space getting filled
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...
- Tue Apr 13, 2010 3:13 am
- Forum: IBM QualityStage
- Topic: UK Address Standardization
- Replies: 10
- Views: 8103