DSXchange

Hi All, I have a Stored Procedure which gives the Output as set of records (20 Columns) as Table type. I have to execute this Stored Procedure through STP Stage in DS Job. Can I take the O/P of this Procedure through the STP Stage which is a 'Table Type' and insert the records of this table Type in ...

I want to insert the end_time irrespective of the job is a success or is aborted.

Actually I have a Job which is currently executing and immediately once it finishes I want to get its start time and End time and insert it in a table....The start time i can get but the end time will be given only after the job is finished. I am not able to get this end time...

Hi All, My requirement is to find the Start time, End time of a job and then insert it in an oracle table. Please can any one help me to know the different options i can try on because even if i take the start time through a Basic function how will i pass that value to insert it in a Database? Also ...

When the execution of job started the CPU/Memory utilization in that time frame was 70%. May be as stated by Craig, the new jobs waiting to start might be requiring more resources then what ever is free and hence getting timed out even though the utilization is not 100%.

Thanks.

Hi Craig,

Yes, the time out is 60 Seconds but still I am not getting that if the CPU and Memory is free what are the other possible reasons which would stop the DS Server from executing a DS Job and throwing the Error (-14) and the timeout error.

Thanks.

Hi Ray,

Actually we monitored the time frame for almost 2 hours to see if at any moment the utilization is 100% but no where it went up to the 100 mark so we just wondered if there are any other reasons also due to which this error is shown.

Thanks.

Hi All, we have been receiving this error "Job control fatal error (-14)" for last 2-3 days. I searched this forum and found out that this error generally comes when the CPU and Memory is overloaded. But we checked our CPU and Memory utilization which was normal and not overloaded but stil...

Thanks Craig....

Actually I searched and found that routines were custom built ....so i was trying to find what will be the solution for Buit-in routines but couldn't and entered this post...

Thanks again...

Hi All, I have written a Job Routine in which I am using the function 'DSAttachJob' to attach the job and then to execute that job using 'DSRunJob' function. But when I compiled my code I got the following error mesages Array 'DSAttachJob' never dimensioned. Array 'DSRunJob' never dimensioned. I fee...

Yess....The Same thing ....we also have different user ids for each Project....I want to measure system memory usage by userid at runtime..........Thanks.

Yess....The Same thing ....we also have different user ids for each Project....I want to measure system memory usage by userid at runtime..........Thanks.

But if I want to know what is the memory utilization of each project on DS Server then is their any method to know it?
Thanks.

Hi All, On my DataStage Server there are various Projects handled by different users. From Last One week Suddenly the execution time taken by DataStage jobs in my project has increased and the throughput has reduced from 400 rows/sec to 30 rows/sec. I want to check how much is the load on the DataSt...

Hi All, I have a Job which Inserts around 5 Million records in a table. This job have been executed fine several times and takes around 1 Hour but suddenly during our last execution this job was executing for almost 3 Days but still didnt finished. Finally we stoped this job and re-run it after whic...