DSXchange

Hi All,

I have a datastage job which completes successfully in less than 5 minutes.

Can anyone please let me know how do I find out the memory usage and CPU consumption of an etl job during the run time.

Thanks
Mark

Thanks Ray and James for clarifying.

Thank You. The total CPU is : 163.23 This mean the total CPU usage is more than 100%? How so I bring the usuage down to less than 100%

Thanks
Mark

Hi All, Can someone please let me what these numbers mean? job design: Fileset ---> transformer --> seq stage Tfm,1: Operator completed. status: APT_StatusOk elapsed: 1885.14 user: 158.51 sys: 4.72 (total CPU: 163.23) tfm,0: Operator completed. status: APT_StatusOk elapsed: 1885.22 user: 157.80 sys:...

I saved the job to another name, recompiled and it ran successfully.

can anyone please tell me what this error message mean, main_program: Internal Error: (nP==nC): sc/sc.C: 4050 Traceback: assert.APT_FatalPath::pureAssertion(const char*,const char*,int)() at 0x90000000208b0d8 APT_SC::IPC_DataSet::computeStraightThroughOptimization()() at 0x9000000017630a4 APT_IR::Sc...

I have incoming data as 8772794193.
The expected output is 877-279-4193

can anyone please suggest me how can I accomplish this.

Regards
Mark

Hi all, I am seeing this error message at a transformer stage in my parallel job. Can anyone please suggest me what might be the issue here, The current soft limit on the data segment (heap) size (1610612736) is less than the hard limit (9223372036854775807), consider increasing the heap size limit ...

actually we havne't saved the meta data for this particular table. There are round 500 datastage jobs in the project. So trying to find out if there is any way I can use sql to query and find out list of all datastage jobs using a particular oracle table.

Can anyone please suggest me how do I find out the list of all datastage jobs using a particular oracle table say "employee".

Thanks
Mark

Hi All,

I find these warnings in my job log from datastage director. Can somoene please tell me how can I fix these warnings. And what is causing these warnings.

Failed to initialize job monitoring. Monitor information will not be generated.
Failed to connect to JobMonApp on port 13401

Thanks
Mark

I received output as pe

desired output: sony xxxxxx europe (after eliminating comma and extra spaces)

Thanks
Mark

input: , sony xxxxxx europe

desired output: sony xxxxxx europe (after eliminating comma and extra spaces)

I have input data as , sony xxxxxx europe

desired output: sony xxxxxx europe

Can anyone please suggest me to accomplish this.

Thanks
Mark

can I create column "dummy" using sequential stage and assign value as 'z' (or something else)

In sequential stage i was able to create a column but I could not assign value to that column.

thanks
Mark