DSXchange

I have redesigned the job to use OCI8 stage instead of OCI stage. Performance is slightly better (140 rows / sec), but not matching the speed of 9i database.

I have checked with the Network team and they couldn't find any network bottle neck.

-Nagesh

Hi ! We have recently moved our source database from oracle 9i to oracle 10g. One of the datastage server job is designed to read from the source (using custom sql query in OCI stage) and write to a file (no constraints / transformations). This job runs fine when pointed to 9i source (3200 rows/sec)...

My Understanding is that querying on ds_jobs or doing DSGetProjectInfo(DSJ.JOBLIST) would only list the Jobs in the current Project to which you are logged on.

Is there a way to get the list of Jobs across all the projects.

Hi ! I am looking to get list of all Jobs in all Projects on the datastage server. My approach to this is to write a UNIX script, which will connect to each of the datastage projects, execute the command to get the job list, append to a file and move on the next project. Is there a way I can achieve...

publish the job as RTI service and invoke it from web code

try update else insert

Does the query run fine when executed directly at the database.

Can you graphically outline the second job. Try to move the Hashedfile 4 lookup into the First job and check the performance. Move one transformation after the other from Job 2 into Job 1 and at one point you will notice a deterioration in performance of Job 1. This is the bottleneck that you are lo...

Does the user "xxx" exist in the Domain ?

Just as a test, try to split the job into two. You can write to a text file, from Link collector stage in Job 1. Use the text file as source and process rest of the stages in Job 2. By doing this, you can identify the area where the problem originates. I believe that this has more to do than the way...

Just as a test, try to split the job into two. You can write to a text file, from Link collector stage in Job 1. Use the text file as source and process rest of the stages in Job 2. By doing this, you can identify the area where the problem originates. I believe that this has more to do than the way...

Any entry in the log file ?

write a script to Do a wc-l to count the number of lines, FTP the file if file exists and number of lines is greater than zero.

Just when I thought Datastage was perfect

Thanks for the clarification Craig.

Suggests that this is a Oracle Database issue. Probably some kind of lock on the Table.