![Crying or Very sad :cry:](./images/smilies/icon_cry.gif)
Process/query still running after job aborted
Moderators: chulett, rschirm, roy
Process/query still running after job aborted
We ran into an issue where a query was still running (for awhile) even though the job had been stopped (through the Director), query modified, and the job compiled and re-run. Any advice on how to avoid this in the future? There was an issue with this query - long running and so testing it outside of datastage would have helped, but besides that...does anyone have any advice to offer on it? Doesn't happen a lot but it did cause issues because it ran for awhile and database team didn't pick up on it until too late ![Crying or Very sad :cry:](./images/smilies/icon_cry.gif)
![Crying or Very sad :cry:](./images/smilies/icon_cry.gif)
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Database queries are asynchronous; they are submitted to the database server and results are awaited. There is nothing in DataStage that allows you manually to stop what the database server is doing (though its internal error handling can achieve this if a job aborts). You need to have a DBA terminate the client session.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.