Does ODBC query gets killed, when your reset a Job

talk2shaanc · Post by **talk2shaanc** » Sun May 22, 2005 10:02 pm

If a huge SQL query is submitted in the ODBC stage and the job is reset/stopped, is the query killed or does it keep running on the DB. If yes, what is the solution? Recompile the job?

tcj · Post by **tcj** » Sun May 22, 2005 11:36 pm

talk2shaanc wrote:If a huge SQL query is submitted in the ODBC stage and the job is reset/stopped, is the query killed or does it keep running on the DB. If yes, what is the solution? Recompile the job?

I have found that most of the time on an oracle server that yes the query is still running. Contact your DBA to kill the query if it is still running unless you have access to do it yourself.

Prashantoncyber · Post by **Prashantoncyber** » Mon May 23, 2005 12:09 am

Is there any way that we can find it out wether querry is running or not either thro' DS or Orcle DB?

talk2shaanc · Post by **talk2shaanc** » Mon May 23, 2005 12:15 am

Through Oracle front-end Tool(Quest Central or Toad) you can trace session and see which user ? , what query is running ? and how many resources are consumed for running a query?. Well I had tested it in my case it was killed. But wanted to know from people out here on forum, if they came across such instances where it was not killed and what steps they took thereafter.

tcj · Post by **tcj** » Mon May 23, 2005 12:58 am

talk2shaanc wrote:Through Oracle front-end Tool(Quest Central or Toad) you can trace session and see which user ? , what query is running ? and how many resources are consumed for running a query?. Well I had tested it in my case it was killed. But wanted to know from people out here on forum, if they came across such instances where it was not killed and what steps they took thereafter.

Yes there will be instances where it was not killed. I have had weird things happen with datastage jobs in that queries have returned data back to the datastage designer after it has stopped or aborted. Or people that have stopped and started their job a couple of times and there has been multiple threads left on the DB.

talk2shaanc · Post by **talk2shaanc** » Mon May 23, 2005 1:03 am

Sorry for not submitting my last thread in proper format.
Below potion was answer to "Prashantoncyber " question

"Through Oracle front-end Tool(Quest Central or Toad) you can trace session and see which user ? , what query is running ? and how many resources are consumed for running a query?."

and
"Well I had tested it in my case it was killed. But wanted to know from people out here on forum, if they came across such instances where it was not killed and what steps they took thereafter."

was reason for posting this thread.[/list]

ray.wurlod · Post by **ray.wurlod** » Mon May 23, 2005 5:51 am

Usually have the DBA kill the session. No-one else has the privileges necessary.

DSXchange

Does ODBC query gets killed, when your reset a Job

Does ODBC query gets killed, when your reset a Job

Re: Does ODBC query gets killed, when your reset a Job