DSXchange

I dint change anything. It was running fine yesterday.

Hi All, I have a job with change capture stage, join etc. The job was running perfectly well. But then now it is getting aborted with the following warnings: joinProdNum.inCpyoraAdtProd2_Sort,1: Cannot access scratch disk " /opt/etl/scratch " : Permission denied joinProdNum.inCpyoraAdtProd...

Yes. The data is same.

I dont know the differences between the 2 servers. Whenever we complete development on 1st server, for testing purpose we move to the 2nd server. (The job is taking more time on 1st server). The problem is that only for this particular job , we have this problem. For remaining jobs, there is no much...

Hi All, We have 2 servers with datastage installed on both. A particular job is showing huge difference in performance (time) from one server to the other one. As both servers are different, it might be normal to have difference in job completion time because of properties but for other jobs there i...

Thanks Ray for that information. I will try to use API functions and will get back if any doubts.

DSguru2B,

I am providing both starting and ending event ids (whose log is to be fetched).

Thanks Chulett.

"dsjob -logsum" is giving correct log belonging to that particular instance . Only "dsjob -logdetail" is giving this problem.

Has anyone else faced same problem with logdetail? If yes, please provide inputs on how this can be solved.

Thanks Ray.

Cant we get this information using some "dsjob" command?
In a routine, we can use "DSGetJobInfo(jobhandle,DSJ.JOBINVOCATONID)" to get the invocation id of the specified job. Likewise, any command that we can use in unix?

Thanks,
ssunda.

Hi, Using a unix script Iam trying to capture logs of job/sequences and storing them to oracle table. I have a sequence "A", which has jobs "a" and "b". "a" is multiple instance job with around 10 instances. And in this particular sequence I am running only 1 ...

Chulett, I am using the appropriate invocation id. The problem is, lets say for job "A", there are 2 instances - "a" and "b". And both instances ran at the same time. The logs for both instances is maintained in "A" in the directory log . Since both the instac...

Hi, We are trying to capture logs of jobs into a table periodically. The logic used is: -dsjob -logsum -type STARTED <proj name> <job name> -compare timestamps and get the required event ids. -Pass them to "dsjob -logdetail" to get the required log. But "logdetail" is fetching lo...

Hi All,

I think using "dssearch" command is much easier if using version 7.x

dssearch -ljobs -uses -r <Project name> <job name>

"-r" recursively loops through the sub sequences also.

Regards,
ssunda.

Hi Ray,

By performance, I meant time improvement.
The job is taking huge time to complete. I want to reduce the job completion time.

Regards,
ssunda.

Hi, The requirement of my job is to load update/insert records into target table. I have a sequential file(file is full extract every time) as input. The target table has 4 columns . 3 columns are taken as key and checked for updation in the fourth column. The input file is having 30 million records...