dbaccess problem 11.10.uc2 or 11.10.fc2
A user on AIX 5.3 found that dbaccess in IDS 11.10.UC2/FC2 fails to clear the screen before showing query results, so leftover SQL text is mixed into the output; Ctrl-R didn't redraw it correctly and IBM support initially couldn't reproduce it. Another poster saw the same thing on Red Hat ES 4. Suggestions to check TERM/TERMCAP/INFORMIXTERM (switching from terminfo to termcap) didn't help, and the poster showed the older UC1/FC1 dbaccess binary worked fine against the same engine. Resolution: it was confirmed as a dbaccess bug, fixed in version X3, with a patch expected shortly.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hello,
If there is someone out there using either the uc2 or fc2 release of IDS
on an aix 5.3 system ... can you tell me if you are having any issues with
dbaccess...here is what is happening: If you enter the following sql:
select
count(*)
from
systables
where
tabid > 1;
The result would be:
count(*)
220
systables
where tabid > 1;
As you can see the screen isn't clearing off prior to showing the results.
I have opened up a case to IBM...but they haven't been able to reproduce
it. Nothing strange going on with termcap and such...using a vt100 value
for TERM.
Thanks in advance for any help.
Does Control-R re-draw it correctly?
Paul Watson
Tel: +1 913-400-2620
Mob: +1 913-387-7529
Web: www.oninit.com
Failure is not as frightening as regret.
If you want to improve, be content to be thought foolish and stupid.
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> Peter_Logan@spartanstores.com
> Sent: 16 January 2008 12:25
> To: ids@iiug.org
> Subject: dbaccess problem 11.10.uc2 or 11.10.fc2 [10947]
>
> Hello,
>
> If there is someone out there using either the uc2 or fc2 release of
> IDS
> on an aix 5.3 system ... can you tell me if you are having any issues
> with
> dbaccess...here is what is happening: If you enter the following sql:
>
> select
> count(*)
> from
> systables
> where
> tabid > 1;
>
> The result would be:
>
> count(*)
>
> 220
> systables
> where tabid > 1;
>
> As you can see the screen isn't clearing off prior to showing the
> results.
> I have opened up a case to IBM...but they haven't been able to
> reproduce
> it. Nothing strange going on with termcap and such...using a vt100
> value
> for TERM.
>
> Thanks in advance for any help.
>
>
> ***********************************************************************
> ********
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
> See you at the IIUG Informix 2008 Conference
> The Power Conference for Informix Professionals
> April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas
> http://www.iiug.org/conf
> Registration Now Open!!
>
> =======================================================================
> ====================
> Please access the attached hyperlink for an important electronic
> communications disclaimer:
>
> http://www.oninit.com/home/disclaimer.php
>
> =======================================================================
> ====================
================================================================================
===========
Please access the attached hyperlink for an important electronic
communications disclaimer:
http://www.oninit.com/home/disclaimer.php
================================================================================
===========
No .. same thing gets redisplayed.
I see the same thing happening with those versions on a Redhat Linux ES 4
Update 5 machine.
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Peter_Logan@spartanstores.com
Sent: Wednesday, January 16, 2008 12:25 PM
To: ids@iiug.org
Subject: dbaccess problem 11.10.uc2 or 11.10.fc2 [10947]
Hello,
If there is someone out there using either the uc2 or fc2 release of IDS
on an aix 5.3 system ... can you tell me if you are having any issues with
dbaccess...here is what is happening: If you enter the following sql:
select
count(*)
from
systables
where
tabid > 1;
The result would be:
count(*)
220
systables
where tabid > 1;
As you can see the screen isn't clearing off prior to showing the results.
I have opened up a case to IBM...but they haven't been able to reproduce
it. Nothing strange going on with termcap and such...using a vt100 value
for TERM.
Thanks in advance for any help.
****************************************************************************
***
Forum Note: Use "Reply" to post a response in the discussion forum.
See you at the IIUG Informix 2008 Conference
The Power Conference for Informix Professionals
April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas
http://www.iiug.org/conf
Registration Now Open!!
Peter_Logan@spartanstores.com wrote:
> Hello,
>
> If there is someone out there using either the uc2 or fc2 release of IDS
> on an aix 5.3 system ... can you tell me if you are having any issues with
> dbaccess...here is what is happening: If you enter the following sql:
>
> select
> count(*)
> from
> systables
> where
> tabid > 1;
>
> The result would be:
>
> count(*)
>
> 220
> systables
> where tabid > 1;
>
> As you can see the screen isn't clearing off prior to showing the results.
> I have opened up a case to IBM...but they haven't been able to reproduce
> it. Nothing strange going on with termcap and such...using a vt100 value
> for TERM.
>
> Thanks in advance for any help.
>
What are you using for TERMCAP and what is INFORMIXTERM set to?
Art S. Kagel
Oninit
================================================================================
===========
Please access the attached hyperlink for an important electronic
communications disclaimer:
http://www.oninit.com/home/disclaimer.php
================================================================================
===========
Hello,
Which terminal emulator are you using? Does it have vt100 capabilities?
Hrvoje
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Peter_Logan@spartanstores.com
Sent: Wednesday, January 16, 2008 7:25 PM
To: ids@iiug.org
Subject: dbaccess problem 11.10.uc2 or 11.10.fc2 [10947]
Hello,
If there is someone out there using either the uc2 or fc2 release of IDS on
an aix 5.3 system ... can you tell me if you are having any issues with
dbaccess...here is what is happening: If you enter the following sql:
select
count(*)
from
systables
where
tabid > 1;
The result would be:
count(*)
220
systables
where tabid > 1;
As you can see the screen isn't clearing off prior to showing the results.
I have opened up a case to IBM...but they haven't been able to reproduce it.
Nothing strange going on with termcap and such...using a vt100 value for
TERM.
Thanks in advance for any help.
****************************************************************************
***
Forum Note: Use "Reply" to post a response in the discussion forum.
See you at the IIUG Informix 2008 Conference The Power Conference for
Informix Professionals April 27 - 30, 2008 Marriott Overland Park (Kansas
City), Kansas http://www.iiug.org/conf Registration Now Open!!
Nothing set for TERMCAP ... INFORMIXTERM set to terminfo
"Art S. Kagel (Oninit LLC)" <art@oninit.com>
Sent by: ids-bounces@iiug.org
01/16/2008 02:10 PM
Please respond to
ids@iiug.org
To
ids@iiug.org
cc
Subject
Re: dbaccess problem 11.10.uc2 or 11.10.fc2 [10951]
Peter_Logan@spartanstores.com wrote:
> Hello,
>
> If there is someone out there using either the uc2 or fc2 release of IDS
> on an aix 5.3 system ... can you tell me if you are having any issues
with
> dbaccess...here is what is happening: If you enter the following sql:
>
> select
> count(*)
> from
> systables
> where
> tabid > 1;
>
> The result would be:
>
> count(*)
>
> 220
> systables
> where tabid > 1;
>
> As you can see the screen isn't clearing off prior to showing the
results.
> I have opened up a case to IBM...but they haven't been able to reproduce
> it. Nothing strange going on with termcap and such...using a vt100 value
> for TERM.
>
> Thanks in advance for any help.
>
What are you using for TERMCAP and what is INFORMIXTERM set to?
Art S. Kagel
Oninit
================================================================================
===========
Please access the attached hyperlink for an important electronic
communications disclaimer:
http://www.oninit.com/home/disclaimer.php
================================================================================
===========
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
See you at the IIUG Informix 2008 Conference
The Power Conference for Informix Professionals
April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas
http://www.iiug.org/conf
Registration Now Open!!
Peter_Logan@spartanstores.com wrote:
> Nothing set for TERMCAP ... INFORMIXTERM set to terminfo
>
Try setting INFORMIXTERM to termcap and use the termcap file in
$INFORMIXDIR/etc and see what happens.
Art S. Kagel
Oninit
> "Art S. Kagel (Oninit LLC)" <art@oninit.com>
> Sent by: ids-bounces@iiug.org
> 01/16/2008 02:10 PM
> Please respond to
> ids@iiug.org
>
> To
> ids@iiug.org
> cc
>
> Subject
> Re: dbaccess problem 11.10.uc2 or 11.10.fc2 [10951]
>
> Peter_Logan@spartanstores.com wrote:
>
>> Hello,
>>
>> If there is someone out there using either the uc2 or fc2 release of IDS
>>
>
>
>> on an aix 5.3 system ... can you tell me if you are having any issues
>>
> with
>
>> dbaccess...here is what is happening: If you enter the following sql:
>>
>> select
>> count(*)
>> from
>> systables
>> where
>> tabid > 1;
>>
>> The result would be:
>>
>> count(*)
>>
>> 220
>> systables
>> where tabid > 1;
>>
>> As you can see the screen isn't clearing off prior to showing the
>>
> results.
>
>> I have opened up a case to IBM...but they haven't been able to reproduce
>>
>
>
>> it. Nothing strange going on with termcap and such...using a vt100 value
>>
>
>
>> for TERM.
>>
>> Thanks in advance for any help.
>>
>>
>
> What are you using for TERMCAP and what is INFORMIXTERM set to?
>
> Art S. Kagel
> Oninit
>
>
================================================================================
===========
Please access the attached hyperlink for an important electronic
communications disclaimer:
http://www.oninit.com/home/disclaimer.php
================================================================================
===========
yes .. that is what I'm using ... sorry about forgetting that ...
I have loaded the 4 different levels of the software on the same system
... with no environment changes at any place ...
I've also copied the dbaccess job from the working fc1 or uc1 version and
that works with the fc2 or uc2 engine ... I'm quite sure the problem is
actually with the dbaccess binary ...
"Hrvoje Zokovic" <hzokovic.iiug@gmail.com>
Sent by: ids-bounces@iiug.org
01/16/2008 02:16 PM
Please respond to
ids@iiug.org
To
ids@iiug.org
cc
Subject
RE: dbaccess problem 11.10.uc2 or 11.10.fc2 [10952]
Hello,
Which terminal emulator are you using? Does it have vt100 capabilities?
Hrvoje
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Peter_Logan@spartanstores.com
Sent: Wednesday, January 16, 2008 7:25 PM
To: ids@iiug.org
Subject: dbaccess problem 11.10.uc2 or 11.10.fc2 [10947]
Hello,
If there is someone out there using either the uc2 or fc2 release of IDS
on
an aix 5.3 system ... can you tell me if you are having any issues with
dbaccess...here is what is happening: If you enter the following sql:
select
count(*)
from
systables
where
tabid > 1;
The result would be:
count(*)
220
systables
where tabid > 1;
As you can see the screen isn't clearing off prior to showing the results.
I have opened up a case to IBM...but they haven't been able to reproduce
it.
Nothing strange going on with termcap and such...using a vt100 value for
TERM.
Thanks in advance for any help.
****************************************************************************
***
Forum Note: Use "Reply" to post a response in the discussion forum.
See you at the IIUG Informix 2008 Conference The Power Conference for
Informix Professionals April 27 - 30, 2008 Marriott Overland Park (Kansas
City), Kansas http://www.iiug.org/conf Registration Now Open!!
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
See you at the IIUG Informix 2008 Conference
The Power Conference for Informix Professionals
April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas
http://www.iiug.org/conf
Registration Now Open!!
Type of your terminal unknown ... I must be messing up something ...
"Art S. Kagel (Oninit LLC)" <art@oninit.com>
Sent by: ids-bounces@iiug.org
01/16/2008 02:28 PM
Please respond to
ids@iiug.org
To
ids@iiug.org
cc
Subject
Re: dbaccess problem 11.10.uc2 or 11.10.fc2 [10954]
Peter_Logan@spartanstores.com wrote:
> Nothing set for TERMCAP ... INFORMIXTERM set to terminfo
>
Try setting INFORMIXTERM to termcap and use the termcap file in
$INFORMIXDIR/etc and see what happens.
Art S. Kagel
Oninit
> "Art S. Kagel (Oninit LLC)" <art@oninit.com>
> Sent by: ids-bounces@iiug.org
> 01/16/2008 02:10 PM
> Please respond to
> ids@iiug.org
>
> To
> ids@iiug.org
> cc
>
> Subject
> Re: dbaccess problem 11.10.uc2 or 11.10.fc2 [10951]
>
> Peter_Logan@spartanstores.com wrote:
>
>> Hello,
>>
>> If there is someone out there using either the uc2 or fc2 release of
IDS
>>
>
>
>> on an aix 5.3 system ... can you tell me if you are having any issues
>>
> with
>
>> dbaccess...here is what is happening: If you enter the following sql:
>>
>> select
>> count(*)
>> from
>> systables
>> where
>> tabid > 1;
>>
>> The result would be:
>>
>> count(*)
>>
>> 220
>> systables
>> where tabid > 1;
>>
>> As you can see the screen isn't clearing off prior to showing the
>>
> results.
>
>> I have opened up a case to IBM...but they haven't been able to
reproduce
>>
>
>
>> it. Nothing strange going on with termcap and such...using a vt100
value
>>
>
>
>> for TERM.
>>
>> Thanks in advance for any help.
>>
>>
>
> What are you using for TERMCAP and what is INFORMIXTERM set to?
>
> Art S. Kagel
> Oninit
>
>
================================================================================
===========
Please access the attached hyperlink for an important electronic
communications disclaimer:
http://www.oninit.com/home/disclaimer.php
================================================================================
===========
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
See you at the IIUG Informix 2008 Conference
The Power Conference for Informix Professionals
April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas
http://www.iiug.org/conf
Registration Now Open!!
Just an FYI ... There is a bug on this ... it's fixed in X3 ... and a
patch might be available later this month.
"Jamie Gedye" <jgedyedba@teleformix.com>
Sent by: ids-bounces@iiug.org
01/16/2008 02:04 PM
Please respond to
ids@iiug.org
To
ids@iiug.org
cc
Subject
RE: dbaccess problem 11.10.uc2 or 11.10.fc2 [10950]
I see the same thing happening with those versions on a Redhat Linux ES 4
Update 5 machine.
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Peter_Logan@spartanstores.com
Sent: Wednesday, January 16, 2008 12:25 PM
To: ids@iiug.org
Subject: dbaccess problem 11.10.uc2 or 11.10.fc2 [10947]
Hello,
If there is someone out there using either the uc2 or fc2 release of IDS
on an aix 5.3 system ... can you tell me if you are having any issues with
dbaccess...here is what is happening: If you enter the following sql:
select
count(*)
from
systables
where
tabid > 1;
The result would be:
count(*)
220
systables
where tabid > 1;
As you can see the screen isn't clearing off prior to showing the results.
I have opened up a case to IBM...but they haven't been able to reproduce
it. Nothing strange going on with termcap and such...using a vt100 value
for TERM.
Thanks in advance for any help.
****************************************************************************
***
Forum Note: Use "Reply" to post a response in the discussion forum.
See you at the IIUG Informix 2008 Conference
The Power Conference for Informix Professionals
April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas
http://www.iiug.org/conf
Registration Now Open!!
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
See you at the IIUG Informix 2008 Conference
The Power Conference for Informix Professionals
April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas
http://www.iiug.org/conf
Registration Now Open!!