Anybody else out there running IDS 11.50.FC6 on AI
Having an issue on 3 of our newest installations, all running IDS 11.50.FC6,
all were upgrades from IDS 11.50.FC4X4. After successful upgrade and
subsequent drop all distributions and complete update stats (dostats) on all
databases, all three of them will ceremoniously defecate on command to the
statement, which is part of a script to gather table info.
Database is sysmaster ...
select ti_nextns,ti_pagesize,ti_nptotal,ti_npused,ti_nrows from systabnames
t,systabinfo i where t.partnum = ? and t.partnum=i.ti_partnum
This does not crash IDS 10.00.FC8, IDS 11.50.FC4X4, or IDS 11.50.FC5 ...
I have opened a PMR to IBM for another query that crashes FC6 on command, but
they have had it for 7 days, only to tell me:
Action Taken : Ran test on Solaris machine but problem did not
reproduce. Installing 11.50.FC6 on AIX machine to continue testing.
Hi,
This is a known defect idsdb00197055.
Workaround is to run buildsmi (to drop and recreate the sysmaster).
Thanks,
Kamini
"Plugge, Joe R." <JRPlugge@west.com>
Sent by: ids-bounces@iiug.org
01/20/2010 08:48 AM
Please respond to
ids@iiug.org
To
ids@iiug.org
cc
Subject
Anybody else out there running IDS 11.50.FC6 o.... [18725]
Having an issue on 3 of our newest installations, all running IDS
11.50.FC6,
all were upgrades from IDS 11.50.FC4X4. After successful upgrade and
subsequent drop all distributions and complete update stats (dostats) on
all
databases, all three of them will ceremoniously defecate on command to the
statement, which is part of a script to gather table info.
Database is sysmaster ...
select ti_nextns,ti_pagesize,ti_nptotal,ti_npused,ti_nrows fromsystabnames
t,systabinfo i where t.partnum = ? and t.partnum=i.ti_partnum
This does not crash IDS 10.00.FC8, IDS 11.50.FC4X4, or IDS 11.50.FC5 ...
I have opened a PMR to IBM for another query that crashes FC6 on command,
but
they have had it for 7 days, only to tell me:
Action Taken : Ran test on Solaris machine but problem did not
reproduce. Installing 11.50.FC6 on AIX machine to continue testing.
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
Hello Mr. Kamini,
Where can we search for this description of defect, and maybe its
correction ???
Is it the IC number??? I looked for it and couldn´t find it, please
could you send us some link ???
Regards!
Alexandre Marini
Tecnologia da Informação - DBA
SEFAZ-MS / SGI-UIMP / Sistemas IBM-Informix
See you at the 2010 IIUG Informix Conference
April 25-28, 2010
Overland Park (Kansas City), KS
www.iiug.org/conf
<http://www.iiug.org>;
Kamini Jagtiani escreveu:
> Hi,
> This is a known defect idsdb00197055.
> Workaround is to run buildsmi (to drop and recreate the sysmaster).
>
> Thanks,
> Kamini
>
> "Plugge, Joe R." <JRPlugge@west.com>
> Sent by: ids-bounces@iiug.org
> 01/20/2010 08:48 AM
> Please respond to
> ids@iiug.org
>
> To
> ids@iiug.org
> cc
>
> Subject
> Anybody else out there running IDS 11.50.FC6 o.... [18725]
>
> Having an issue on 3 of our newest installations, all running IDS
> 11.50.FC6,
> all were upgrades from IDS 11.50.FC4X4. After successful upgrade and
> subsequent drop all distributions and complete update stats (dostats) on
> all
> databases, all three of them will ceremoniously defecate on command to the
>
> statement, which is part of a script to gather table info.
>
> Database is sysmaster ...
>
> select ti_nextns,ti_pagesize,ti_nptotal,ti_npused,ti_nrows from> systabnames
> t,systabinfo i where t.partnum = ? and t.partnum=i.ti_partnum
>
> This does not crash IDS 10.00.FC8, IDS 11.50.FC4X4, or IDS 11.50.FC5 ...
>
> I have opened a PMR to IBM for another query that crashes FC6 on command,
> but
> they have had it for 7 days, only to tell me:
>
> Action Taken : Ran test on Solaris machine but problem did not
> reproduce. Installing 11.50.FC6 on AIX machine to continue testing.
>
>
>
*******************************************************************************
>
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
>
We tried to run it on HP-UX but the swap memory utilization problems they
fixed in FC5 appear to have resurfaced in FC6. We went back to FC5.
--- On Wed, 1/20/10, Plugge, Joe R. <JRPlugge@west.com> wrote:
> From: Plugge, Joe R. <JRPlugge@west.com>
> Subject: Anybody else out there running IDS 11.50.FC6 o.... [18725]
> To: ids@iiug.org
> Date: Wednesday, January 20, 2010, 10:48 AM
> Having an issue on 3 of our newest
> installations, all running IDS 11.50.FC6,
> all were upgrades from IDS 11.50.FC4X4. After successful
> upgrade and
> subsequent drop all distributions and complete update stats
> (dostats) on all
> databases, all three of them will ceremoniously defecate on
> command to the
> statement, which is part of a script to gather table info.
>
>
> Database is sysmaster ...
>
> select ti_nextns,ti_pagesize,ti_nptotal,ti_npused,ti_nrows
> from systabnames
> t,systabinfo i where t.partnum = ? and> t.partnum=i.ti_partnum
>
> This does not crash IDS 10.00.FC8, IDS 11.50.FC4X4, or IDS
> 11.50.FC5 ...
>
> I have opened a PMR to IBM for another query that crashes
> FC6 on command, but
> they have had it for 7 days, only to tell me:
>
> Action Taken : Ran test on Solaris machine but problem did
> not
> reproduce. Installing 11.50.FC6 on AIX machine to continue
> testing.
>
>
>
*******************************************************************************
>
> Forum Note: Use "Reply" to post a response in the
> discussion forum.
>
>