DSXchange

Working :D. Thanks ArndW!!

Thanks ArndW!! I have tried what you suggested. But no luck. Please find below: First Point : (No output after executing the command . ./dsenv) $ cd `cat /.dshome` $ pwd $ /opt/IBM/InformationServer/Server/DSEngine $ . ./dsenv $ Second Point : (I did not find "{your install directory}/Server/DS...

Hi Everyone, I want to list out the datastage projects in a unix server and the jobs in each project. So I am using the below command: Listing Out the Projects = "dsjob -lprojects" Listing Out the jobs = "dsjob -ljobs project" But, I got the error like "dsjob: command not fo...

Hi,

Thanks for all.

Hi,

Thanks for all. I got the solution by applying Multiple Instance.

Answers to Queries :

Oracle Table Columns = 266
Business Requirements = Job has to run on one node
Job has to finish with in 1 hr
Loading Data = Insert Mode

Hi,

We have 3 jobs and in all 3 jobs target table is same. After successfully finished of each job, one record will insert in target table. Means total 3 records. But 3 jobs are different. Is there any possibility of locking the table while inserting 3 records at a time from 3 jobs.

please suggest!

Hi, Job Design : Sequential File --> Transformer --> Oracle Connector Description : Source File is around 7 GB which is having 9 million records. These records has to be insert in target table. Issue Description : Job run time is around 4 hrs which shouldn't according to business. Hint : Job is runn...

@priyadarshikunal : In SQL Developer, until 5 hrs the query is run status and the count is 3.4 million. In DS Job, record count is increasing while checking performance statistics but after reaching 3.2 million that's it. The same status showed by job in 22 hr. Then I killed the process. Note : Inte...

Hi DS Mates, I am running one job which is having 2 stages, oracle connector and dataset. Fetching the data and placing in dataset. Instead of either finishing or aborting it was still running. When I run that query using SQL Developer, it was taking 5 hrs to get the o/p. But in DS Job why this happ...

Hi Chulett, 1) I am not sure whether the fatal error is coming from O/S or Oracle. Please tell me by the seeing the below error : ' main_program: ORCHESTRATE step execution terminating due to SIGINT ' 2) Please check the below Log Image : [Edit: non-functional image removed, see Craig's post below -...

Dear DS Mates, Job Design : Oracle Connector => Oracle Connector Description : Data is fetching from Source table and updating the Target table based on key column. Cause : After running 7 to 8 hrs, suddenly we are getting SIGINT Error. Example : We have 100 records from source after updating 75 rec...

Hi DS Mates, I am running a job on 4-node configuration file which is having Oracle connector stage as a source. The query is retrieving values from ' Multiple Tables '. I set the option ' Enable Partition Reads ' to ' YES '. I have chosen ' ROWID Round Robin ' partition method. And I am getting con...

Dear All (ArndW, chandra.shekhar@tcs.com, priyadarshikunal, abhinavagarwal) I had tried what you suggested but still it is taking time. I replaced join stage instead of lookup and applied hash partitioning. What i found from the log file, to fetch records from the oracle connector stage it is taking...

Hi, I have one job which is taking more than 7 hours in production. Client wants to reduce the run time as it is effecting the business. Job Design : Source - Oracle Connector Stage--> Lookup Reference - Oralce Connector Stage --> Lookup (Sparse) Lookup o/p --> Filter Source - Filter --> Lookup Refe...

Dear ArndW,

The option which you mentioned 'Right Click' on the stage is not working, When i do this it will display like unable to open the file. Please suggest something else.