Page 2 of 2
Posted: Mon Oct 06, 2008 4:20 am
by Ultramundane
keshav0307 wrote:Does DRS stage use ODBC?? or the native client connection??
That's exactly what's weird. The DRS stage for connecting to SQL server from Unix, always uses ODBC. It does not fail. Also, other projects ODBC stages do not fail when this occurs. That is, this problem when it occurs does not span the Datastage server. It only occurs for a project at a time.
Posted: Tue Oct 07, 2008 1:59 pm
by MTA
Can you do a quick test to isolate the issue when the job is hanging ( for what ever reason). 1. Identify the processess associated with the job 2. Capture the memory usage and disc usage stats for untill the job stops and a minute after that. 3. Check the number of semophores opened. Gather this information this will help isolate the issue.
Posted: Tue Oct 07, 2008 2:24 pm
by Ultramundane
MTA wrote:Can you do a quick test to isolate the issue when the job is hanging ( for what ever reason). 1. Identify the processess associated with the job 2. Capture the memory usage and disc usage stats for untill the job stops and a minute after that. 3. Check the number of semophores opened. Gather this information this will help isolate the issue.
The jobs abort immediately once this starts.
Posted: Wed Oct 08, 2008 8:10 am
by Ultramundane
MTA wrote:Can you do a quick test to isolate the issue when the job is hanging ( for what ever reason). 1. Identify the processess associated with the job 2. Capture the memory usage and disc usage stats for untill the job stops and a minute after that. 3. Check the number of semophores opened. Gather this information this will help isolate the issue.
The jobs abort immediately once this starts.