September 21, 2015 at 2:34 pm
Hi
I have an issue with Sql Server 2012 and Datastage which extracts the table(just select * from table) and loads into one file without any transformation in between. Source table has around 45million rows. Datastage Process extracts upto 22million rows and then it stalls forever(running state). I had investigated into the Database and i could see the transaction runs on database for some time(runnable and suspended state) for sometime and it disappears suddenly. I am surprised to see Datastage Process still shows rows are being extracted even after transaction is disappears and Datastage process up to 22million rows and then do nothing.
Can someone advise what could be the problem and where to look for as i am new to DB admin activities.
Thanks
September 21, 2015 at 2:48 pm
I am at a loss, what is DataStage?
September 21, 2015 at 2:56 pm
IBM's version (for want of a better word) of SSIS.
September 22, 2015 at 4:28 am
Sounds like it might be hitting a timeout on the DataStage side of things. I don't know how to adjust that in DataStage. But the description is how a client-side timeout would show itself. It'd be running a while, then it would go away.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply