The Netezza Community: Unable to query from a particular table

Skip navigation

Netezza.comThinking.Netezza.comBookmark This Site

Up to Discussions in TwinFin Talk

12063 Views 4 Replies Latest reply: Mar 18, 2010 10:31 AM by renjish

renjish

3 posts since
Mar 18, 2010

Currently Being Moderated

Mar 18, 2010 9:01 AM

Unable to query from a particular table

I am new to Netezza DB.

Now I am not able to query from a particular table say "load_tab". Actually the table was accessing by different session and its running for long time, and in my current session i am not able to query anything from this table.

I want to know like can we able to kill the session which still running? if possible how? I know in oracle we can use "alter system kill session " command, is anything available in netezza?

thanks

renjish

Like (0)

David Birmingham
426 posts since
Sep 24, 2007

Currently Being Moderated

1. Mar 18, 2010 9:21 AM (in response to renjish)
Re: Unable to query from a particular table

Check your admin guide, you have lots of options to abort a transaction. You have to be the transaction's owner and your admins must enable this capability for you. If you have an admin, it might be worth shooting an email to them with the session id etc to have them abort it.

When you say you are unable to query, is this a permission denied or the data is not visible because the insert has not yet completed?

Report Abuse

Like (0)
renjish
3 posts since
Mar 18, 2010

Currently Being Moderated

2. Mar 18, 2010 9:28 AM (in response to David Birmingham)
Re: Unable to query from a particular table

Thanks for your immediate response David.
I am the owner say:df2pusr, of the trasaction which still runs in the background. I dont have admin rights in the system. But i want to know how to abort the transaction. Could you get me the command for this?.
I have all rights like insert, delete, truncate etc on the table, but when i query from the table its hanging? So i though if i abort the session which still runs, i could be able to access the same table.

Could you help me?

thanks
renjish

Report Abuse

Like (0)
Superuser
90 posts since
Sep 19, 2008

Currently Being Moderated

3. Mar 18, 2010 10:25 AM (in response to renjish)
Re: Unable to query from a particular table

http://netezzaforum.com/appliance-usage/how-to-kill-a-query-in-netezza-t40.html

Report Abuse

Like (0)
renjish
3 posts since
Mar 18, 2010

Currently Being Moderated

4. Mar 18, 2010 10:31 AM (in response to Superuser)
Re: Unable to query from a particular table

Thanks a lot...

renjish

Report Abuse

Like (0)

Go to original post

Mar 18, 2010 9:01 AM

Unable to query from a particular table

Actions

More Like This

Bookmarked By (0)