Memory Leakage

oacvb · Post by **oacvb** » Mon Jun 05, 2006 11:01 pm

Hi,

If a job aborts, Does the memory allocated to process the job will be released?If so, when it will be released. Do i need to reset the job. Our jobs are taking more memory after every abort. Please help us.

Regards,
Venkatesh Babu Obla

sb_akarmarkar · Post by **sb_akarmarkar** » Mon Jun 05, 2006 11:13 pm

Job type you have mention is parallel and posted query in server forum...

Thanks,
Anupam

ArndW · Post by **ArndW** » Tue Jun 06, 2006 1:33 am

Memory allocation and resource management is part of the underlying operating system, not DataStage. How are you measuring your memory usage? If it is using different amounts of storage on subsequent runs then it is your data (either source or interim) that is causing that change, not something within DataStage.

oacvb · Post by **oacvb** » Tue Jun 06, 2006 2:17 am

Hi,

Agree with your view. We took the performance statistics before and after abort. CPU Utilization is around 95% and Memory (Not used to store the data) to allocate the execution of jobs were increased by 20%. We restarted datastage server and it came back to original values. We thought the memory for aborted jobs were not released.

Regards,
O.A.C.Venkatesh Babu