If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Sybase > Sybase IQ connection not killed

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old
Registered User
 
Join Date: Nov 2012
Posts: 2
Sybase IQ connection not killed

We have a process running for more than 3 days now and we can not do a 'drop connection <process id>' on it.

I tried to do sp_iqcontext <process id> to find out what it is running and its doing a table load.. and I have checked that the input file is gone.

This should be something a 'drop connection' should be able to handle but it looks like it is running into a black hole -- except we have to recycle IQ (which will be not acceptable to other users). Sad thing is its hogging almost 300 Gb of version on objects its using.

its always been like this. we are running IQ 12.7 on ESD5 running on Solaris 10, 64bit.
Reply With Quote
Reply

Tags
sybase iq 12.7

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On