Loosing connection after break
Posted in 2010
Topics: Installation, Setup & Upgrades, Server Administration
Does anybody know why in IDS 11.50.xC6 (or xC7) on Linux, when I break some
SQL statement, after that, I loose connection to database? I getting error
349: Database not selected yet
This is not happening with 11.50XC5 or some older version of Informix
Example:
From dbaccess, run SELECT * FROM table_name, then I press CRTL-C, and I must
reconnect to database when I want to run this (or other query) again?
I try to change some parameters in onconfig but with no result.
This is happening after I upgrade IDS from 11.50.xC5 to 11.50.xC6 - with same
onconfig file.
Sounds like a bug. Call IBM and report it. It may already be fixed in .xC7
or one of the .xC7 patch releases.
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
IIUG Board of Directors (art@iiug.org)
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Advanced DataTools, the IIUG, nor any other
organization with which I am associated either explicitly, implicitly, or by
inference. Neither do those opinions reflect those of other individuals
affiliated with any entity with which I am affiliated nor those of the
entities themselves.
On Thu, Aug 12, 2010 at 5:55 AM, IVAN ZAVIS <ivan.zavis@mi-system.co.rs>wrote:
> Does anybody know why in IDS 11.50.xC6 (or xC7) on Linux, when I break some
> SQL statement, after that, I loose connection to database? I getting error
> 349: Database not selected yet>
> This is not happening with 11.50XC5 or some older version of Informix
>
> Example:
>
> >From dbaccess, run SELECT * FROM table_name, then I press CRTL-C, and I
> must
> reconnect to database when I want to run this (or other query) again?
>
> I try to change some parameters in onconfig but with no result.
>
> This is happening after I upgrade IDS from 11.50.xC5 to 11.50.xC6 - with
> same
> onconfig file.
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--0016361e7f5e17fbba048d9fe586
My update: seems to version 11.50.xC5 had problem with break to. I was
upgraded IDS from 11.50.xC4, and that version is OK.
On 12.08.2010 14:56, Art Kagel wrote:
> Sounds like a bug. Call IBM and report it. It may already be fixed in .xC7
> or one of the .xC7 patch releases.
>
> Art
>
> Art S. Kagel
> Advanced DataTools (www.advancedatatools.com)
> IIUG Board of Directors (art@iiug.org)
>
> Disclaimer: Please keep in mind that my own opinions are my own opinions and
> do not reflect on my employer, Advanced DataTools, the IIUG, nor any other
> organization with which I am associated either explicitly, implicitly, or by
> inference. Neither do those opinions reflect those of other individuals
> affiliated with any entity with which I am affiliated nor those of the
> entities themselves.
>
> On Thu, Aug 12, 2010 at 5:55 AM, IVAN ZAVIS<ivan.zavis@mi-system.co.rs>wrote:
>
>
>> Does anybody know why in IDS 11.50.xC6 (or xC7) on Linux, when I break some
>> SQL statement, after that, I loose connection to database? I getting error
>> 349: Database not selected yet>>
>> This is not happening with 11.50XC5 or some older version of Informix
>>
>> Example:
>>
>> > From dbaccess, run SELECT * FROM table_name, then I press CRTL-C, and I
>> must
>> reconnect to database when I want to run this (or other query) again?
>>
>> I try to change some parameters in onconfig but with no result.
>>
>> This is happening after I upgrade IDS from 11.50.xC5 to 11.50.xC6 - with
>> same
>> onconfig file.
>>
>>
>>
>>
>>
>
*******************************************************************************
>
>> Forum Note: Use "Reply" to post a response in the discussion forum.
>>
>>
>>
> --0016361e7f5e17fbba048d9fe586
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--
Ivan Zaviç
System& DB Administrator
Mobile:+381-64-846-99-08
mail: ivan.zavis@mi-system.co.rs
_________________________________________________________
M&I SYSTEMS CO.
Cirila i Metodija 13/a, 21000 Novi Sad, Serbia
Tel/Fax: +381-(0)21-68-98-600
Mail: info@mi-system.co.rs, URL: http://www.mi-system.co.rs