Long connection delay w/ IDS 11.50.FC2 on Solaris
After upgrading to IDS 11.50.FC2 on Solaris 10, users reported very slow database connections over both TLI and shared memory (one poster saw ~1 second, another saw delays of 10-30 minutes once a database was selected; plain 'dbaccess - -' connected instantly). Suggestions included a known dropped-connection bug fixed in 11.10.UC2W4/FC3, DNS reverse-lookup problems, and testing different NETTYPEs/IP vs hostname; IBM support said no matching open defect existed for 11.50. One poster largely fixed his case (0.9s down to 0.16s) by rebuilding sysmaster with $INFORMIXDIR/etc/buildsmi, suspecting connections during migration corrupted it. The original poster's multi-minute delays are left unresolved in the thread.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
We have recently upgraded from IDS 11.10 to 11.50.FC2 on Solaris 10 and are now experiencing long delays connecting to the database on both TLI and SHM connectors.... Has anyone experienced this with a straight upgrade ?
I just yesterday opened a case with IBM regarding this very same issue!!!. My times are around 1 second. We are waiting for their answer. Fortunately it is happening in a not critical instance. Walter Milan DBA -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Lello, Nick Sent: Tuesday, March 17, 2009 8:03 AM To: ids@iiug.org Subject: Long connection delay w/ IDS 11.50.FC2 on Solaris [15194] We have recently upgraded from IDS 11.10 to 11.50.FC2 on Solaris 10 and are now experiencing long delays connecting to the database on both TLI and SHM connectors.... Has anyone experienced this with a straight upgrade ? ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.
Just a caveat we migrated from 10.00.FC8 to 11.50.FC2 Walter Milan DBA -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Walter Milan Sent: Tuesday, March 17, 2009 10:45 AM To: ids@iiug.org Subject: RE: Long connection delay w/ IDS 11.50.FC2 on .... [15197] I just yesterday opened a case with IBM regarding this very same issue!!!. My times are around 1 second. We are waiting for their answer. Fortunately it is happening in a not critical instance. Walter Milan DBA -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Lello, Nick Sent: Tuesday, March 17, 2009 8:03 AM To: ids@iiug.org Subject: Long connection delay w/ IDS 11.50.FC2 on Solaris [15194] We have recently upgraded from IDS 11.10 to 11.50.FC2 on Solaris 10 and are now experiencing long delays connecting to the database on both TLI and SHM connectors.... Has anyone experienced this with a straight upgrade ? ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.
I suspect something we've both missed in the release notes --- I've
scoured them with no clues.
I did wonder about the new security setting but disabling this and
restarting the engine didn't work.
My connections seem to take about 10 minutes; dbaccess - - connects
instantly but doing something that selects a database hangs.
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Walter Milan
Sent: 17 March 2009 16:05
To: ids@iiug.org
Subject: RE: Long connection delay w/ IDS 11.50.FC2 on .... [15198]
Just a caveat we migrated from 10.00.FC8 to 11.50.FC2
Walter Milan
DBA
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Walter
Milan
Sent: Tuesday, March 17, 2009 10:45 AM
To: ids@iiug.org
Subject: RE: Long connection delay w/ IDS 11.50.FC2 on .... [15197]
I just yesterday opened a case with IBM regarding this very same
issue!!!. My
times are around 1 second.
We are waiting for their answer. Fortunately it is happening in a not
critical
instance.
Walter Milan
DBA
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Lello,
Nick
Sent: Tuesday, March 17, 2009 8:03 AM
To: ids@iiug.org
Subject: Long connection delay w/ IDS 11.50.FC2 on Solaris [15194]
We have recently upgraded from IDS 11.10 to 11.50.FC2 on Solaris 10 and
are now experiencing long delays connecting to the database on both TLI
and SHM connectors.... Has anyone experienced this with a straight
upgrade ?
************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.
************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.
************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.
Hmm, 10 minutes seems an eternity for me. But I was only testing connection
times, no select was involved.
$ timex dbaccess sysmaster <<!^J;^J!
Database selected.
Database closed.
real 0.92
user 0.01
sys 0.01
on other instances on same box(on 10.FC8), same test it takes only .06 of real
time. I also get .06 connecting to a new 11.50.UC3 on another box's instance.
It just occurred to me to upgrade to C3 now that is available, and lets see
how it goes.
Walter Milan
DBA
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Lello,
Nick
Sent: Tuesday, March 17, 2009 11:33 AM
To: ids@iiug.org
Subject: RE: Long connection delay w/ IDS 11.50.FC2 on .... [15199]
I suspect something we've both missed in the release notes --- I've
scoured them with no clues.
I did wonder about the new security setting but disabling this and
restarting the engine didn't work.
My connections seem to take about 10 minutes; dbaccess - - connects
instantly but doing something that selects a database hangs.
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Walter Milan
Sent: 17 March 2009 16:05
To: ids@iiug.org
Subject: RE: Long connection delay w/ IDS 11.50.FC2 on .... [15198]
Just a caveat we migrated from 10.00.FC8 to 11.50.FC2
Walter Milan
DBA
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Walter
Milan
Sent: Tuesday, March 17, 2009 10:45 AM
To: ids@iiug.org
Subject: RE: Long connection delay w/ IDS 11.50.FC2 on .... [15197]
I just yesterday opened a case with IBM regarding this very same
issue!!!. My
times are around 1 second.
We are waiting for their answer. Fortunately it is happening in a not
critical
instance.
Walter Milan
DBA
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Lello,
Nick
Sent: Tuesday, March 17, 2009 8:03 AM
To: ids@iiug.org
Subject: Long connection delay w/ IDS 11.50.FC2 on Solaris [15194]
We have recently upgraded from IDS 11.10 to 11.50.FC2 on Solaris 10 and
are now experiencing long delays connecting to the database on both TLI
and SHM connectors.... Has anyone experienced this with a straight
upgrade ?
************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.
************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.
************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
Hi Nike Did your server have some "dropped connections" before experiencing long wait time? There was a bug related to "dropped connectons causing long wait". This bug has been fixed in 11.50UC2W4. Please let me know if you saw slow connections against a fresh server. Regards, -Ping --- On Tue, 3/17/09, Lello, Nick <Nick.Lello@nielsen.com> wrote: > From: Lello, Nick <Nick.Lello@nielsen.com> > Subject: Long connection delay w/ IDS 11.50.FC2 on Solaris [15194] > To: ids@iiug.org > Date: Tuesday, March 17, 2009, 8:03 AM > We have recently upgraded from IDS > 11.10 to 11.50.FC2 on Solaris 10 and > are now experiencing long delays connecting to the database > on both TLI > and SHM connectors.... Has anyone experienced this with a > straight > upgrade ? > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the > discussion forum. > >
Sorry, this "dropped connections" bug was fixed in 11.10.UC2W4 so it was not in 11.50.FC2. --- On Tue, 3/17/09, PING TANG <ptang83@yahoo.com> wrote: > From: PING TANG <ptang83@yahoo.com> > Subject: Re: Long connection delay w/ IDS 11.50.FC2 on .... [15206] > To: ids@iiug.org > Date: Tuesday, March 17, 2009, 5:19 PM > Hi Nike > > Did your server have some "dropped connections" before > experiencing long wait > time? > > There was a bug related to "dropped connectons causing long > wait". This bug > has been fixed in 11.50UC2W4. > > Please let me know if you saw slow connections against a > fresh server. > > Regards, > > -Ping > > --- On Tue, 3/17/09, Lello, Nick <Nick.Lello@nielsen.com> > wrote: > > > From: Lello, Nick <Nick.Lello@nielsen.com> > > > Subject: Long connection delay w/ IDS 11.50.FC2 on > Solaris [15194] > > To: ids@iiug.org > > Date: Tuesday, March 17, 2009, 8:03 AM > > We have recently upgraded from IDS > > 11.10 to 11.50.FC2 on Solaris 10 and > > are now experiencing long delays connecting to the > database > > on both TLI > > and SHM connectors.... Has anyone experienced this > with a > > straight > > upgrade ? > > > > > > > ******************************************************************************* > > > > > Forum Note: Use "Reply" to post a response in the > > discussion forum. > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the > discussion forum. > >
Just tested with a single statement echoed through dbaccess --- 30
minutes !!
IBM are being as helpful as usual (English humour).
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Walter Milan
Sent: 17 March 2009 17:03
To: ids@iiug.org
Subject: RE: Long connection delay w/ IDS 11.50.FC2 on .... [15202]
Hmm, 10 minutes seems an eternity for me. But I was only testing
connection
times, no select was involved.
$ timex dbaccess sysmaster <<!^J;^J!
Database selected.
Database closed.
real 0.92
user 0.01
sys 0.01
on other instances on same box(on 10.FC8), same test it takes only .06
of real
time. I also get .06 connecting to a new 11.50.UC3 on another box's
instance.
It just occurred to me to upgrade to C3 now that is available, and lets
see
how it goes.
Walter Milan
DBA
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Lello,
Nick
Sent: Tuesday, March 17, 2009 11:33 AM
To: ids@iiug.org
Subject: RE: Long connection delay w/ IDS 11.50.FC2 on .... [15199]
I suspect something we've both missed in the release notes --- I've
scoured them with no clues.
I did wonder about the new security setting but disabling this and
restarting the engine didn't work.
My connections seem to take about 10 minutes; dbaccess - - connects
instantly but doing something that selects a database hangs.
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Walter Milan
Sent: 17 March 2009 16:05
To: ids@iiug.org
Subject: RE: Long connection delay w/ IDS 11.50.FC2 on .... [15198]
Just a caveat we migrated from 10.00.FC8 to 11.50.FC2
Walter Milan
DBA
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Walter
Milan
Sent: Tuesday, March 17, 2009 10:45 AM
To: ids@iiug.org
Subject: RE: Long connection delay w/ IDS 11.50.FC2 on .... [15197]
I just yesterday opened a case with IBM regarding this very same
issue!!!. My
times are around 1 second.
We are waiting for their answer. Fortunately it is happening in a not
critical
instance.
Walter Milan
DBA
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Lello,
Nick
Sent: Tuesday, March 17, 2009 8:03 AM
To: ids@iiug.org
Subject: Long connection delay w/ IDS 11.50.FC2 on Solaris [15194]
We have recently upgraded from IDS 11.10 to 11.50.FC2 on Solaris 10 and
are now experiencing long delays connecting to the database on both TLI
and SHM connectors.... Has anyone experienced this with a straight
upgrade ?
************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.
************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.
************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.
************************************************************************
*******
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 saw the same behavior in 11.10.FC2W4. At least .8 seconds to open a
connection with dbaccess. Also happened with dbschema. Got a patch
that fixed this in 11.10.FC3. Maybe the bug is back in 11.50.FC2?
Sierra
On Tue, 17 Mar 2009, Lello, Nick wrote:
> Just tested with a single statement echoed through dbaccess --- 30
> minutes !!
>
> IBM are being as helpful as usual (English humour).
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> Walter Milan
> Sent: 17 March 2009 17:03
> To: ids@iiug.org
> Subject: RE: Long connection delay w/ IDS 11.50.FC2 on .... [15202]
>
> Hmm, 10 minutes seems an eternity for me. But I was only testing
> connection
> times, no select was involved.
> $ timex dbaccess sysmaster <<!^J;^J!>
> Database selected.
> Database closed.
> real 0.92
> user 0.01
> sys 0.01
>
> on other instances on same box(on 10.FC8), same test it takes only .06
> of real
> time. I also get .06 connecting to a new 11.50.UC3 on another box's
> instance.
> It just occurred to me to upgrade to C3 now that is available, and lets
> see
> how it goes.
>
> Walter Milan
> DBA
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> Lello,
> Nick
> Sent: Tuesday, March 17, 2009 11:33 AM
> To: ids@iiug.org
> Subject: RE: Long connection delay w/ IDS 11.50.FC2 on .... [15199]
>
> I suspect something we've both missed in the release notes --- I've
> scoured them with no clues.
>
> I did wonder about the new security setting but disabling this and
> restarting the engine didn't work.
>
> My connections seem to take about 10 minutes; dbaccess - - connects
> instantly but doing something that selects a database hangs.
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> Walter Milan
> Sent: 17 March 2009 16:05
> To: ids@iiug.org
> Subject: RE: Long connection delay w/ IDS 11.50.FC2 on .... [15198]
>
> Just a caveat we migrated from 10.00.FC8 to 11.50.FC2
>
> Walter Milan
> DBA
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> Walter
> Milan
> Sent: Tuesday, March 17, 2009 10:45 AM
> To: ids@iiug.org
> Subject: RE: Long connection delay w/ IDS 11.50.FC2 on .... [15197]
>
> I just yesterday opened a case with IBM regarding this very same
> issue!!!. My
> times are around 1 second.
> We are waiting for their answer. Fortunately it is happening in a not
> critical
> instance.
>
> Walter Milan
> DBA
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> Lello,
> Nick
> Sent: Tuesday, March 17, 2009 8:03 AM
> To: ids@iiug.org
> Subject: Long connection delay w/ IDS 11.50.FC2 on Solaris [15194]
>
> We have recently upgraded from IDS 11.10 to 11.50.FC2 on Solaris 10 and
> are now experiencing long delays connecting to the database on both TLI
> and SHM connectors.... Has anyone experienced this with a straight
> upgrade ?
>
> ************************************************************************
>
> *******
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
> ************************************************************************
>
> *******
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
> ************************************************************************
>
> *******
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
> ************************************************************************
> *******
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
> ************************************************************************
> *******
> 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 ran into a similar issue in a much older version - IDS 7.31. Our issue
turned out being that the application was coming through Citrix servers which
were in a subnet that had reverse lookups disabled. This even affected
connections to dbaccess from the command line on the database server. Once
connected, performance was great - mostly because the majority of users were
not connected and working. As soon as reverse lookups were enabled on the
subnet, the problem immediately went away. Of course it took several days to
determine the cause.
This is certainly not the same upgrade scenario you are discussing, but if
other seemingly unrelated DNS changes have been made recently, this could be
the issue.
Rob Schmitz
Embarq Data Management
rob.b.schmitz@embarq.com
www.embarq.com
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Sierra
Moxon
Sent: Tuesday, March 17, 2009 6:10 PM
To: ids@iiug.org
Subject: RE: Long connection delay w/ IDS 11.50.FC2 on .... [15209]
We saw the same behavior in 11.10.FC2W4. At least .8 seconds to open a
connection with dbaccess. Also happened with dbschema. Got a patch
that fixed this in 11.10.FC3. Maybe the bug is back in 11.50.FC2?
Sierra
On Tue, 17 Mar 2009, Lello, Nick wrote:
> Just tested with a single statement echoed through dbaccess --- 30
> minutes !!
>
> IBM are being as helpful as usual (English humour).
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> Walter Milan
> Sent: 17 March 2009 17:03
> To: ids@iiug.org
> Subject: RE: Long connection delay w/ IDS 11.50.FC2 on .... [15202]
>
> Hmm, 10 minutes seems an eternity for me. But I was only testing
> connection
> times, no select was involved.
> $ timex dbaccess sysmaster <<!^J;^J!>
> Database selected.
> Database closed.
> real 0.92
> user 0.01
> sys 0.01
>
> on other instances on same box(on 10.FC8), same test it takes only .06
> of real
> time. I also get .06 connecting to a new 11.50.UC3 on another box's
> instance.
> It just occurred to me to upgrade to C3 now that is available, and lets
> see
> how it goes.
>
> Walter Milan
> DBA
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> Lello,
> Nick
> Sent: Tuesday, March 17, 2009 11:33 AM
> To: ids@iiug.org
> Subject: RE: Long connection delay w/ IDS 11.50.FC2 on .... [15199]
>
> I suspect something we've both missed in the release notes --- I've
> scoured them with no clues.
>
> I did wonder about the new security setting but disabling this and
> restarting the engine didn't work.
>
> My connections seem to take about 10 minutes; dbaccess - - connects
> instantly but doing something that selects a database hangs.
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> Walter Milan
> Sent: 17 March 2009 16:05
> To: ids@iiug.org
> Subject: RE: Long connection delay w/ IDS 11.50.FC2 on .... [15198]
>
> Just a caveat we migrated from 10.00.FC8 to 11.50.FC2
>
> Walter Milan
> DBA
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> Walter
> Milan
> Sent: Tuesday, March 17, 2009 10:45 AM
> To: ids@iiug.org
> Subject: RE: Long connection delay w/ IDS 11.50.FC2 on .... [15197]
>
> I just yesterday opened a case with IBM regarding this very same
> issue!!!. My
> times are around 1 second.
> We are waiting for their answer. Fortunately it is happening in a not
> critical
> instance.
>
> Walter Milan
> DBA
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> Lello,
> Nick
> Sent: Tuesday, March 17, 2009 8:03 AM
> To: ids@iiug.org
> Subject: Long connection delay w/ IDS 11.50.FC2 on Solaris [15194]
>
> We have recently upgraded from IDS 11.10 to 11.50.FC2 on Solaris 10 and
> are now experiencing long delays connecting to the database on both TLI
> and SHM connectors.... Has anyone experienced this with a straight
> upgrade ?
>
> ************************************************************************
>
> *******
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
> ************************************************************************
>
> *******
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
> ************************************************************************
>
> *******
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
> ************************************************************************
> *******
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
> ************************************************************************
> *******
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
There is no open or closed bug regarding connection slow against ids 11.50 or
above at this time. I tested latest server and I couldn't reproduce the issue.
Please try some more scenarios to identify the issue. (Such as using different
NETTYPES, using IP address instead of host name, using port number instead of
service name, using local loop, etc...)
--- On Wed, 3/18/09, Schmitz, Rob B[EQ] <Rob.B.Schmitz@Embarq.com> wrote:
> From: Schmitz, Rob B[EQ] <Rob.B.Schmitz@Embarq.com>
> Subject: RE: Long connection delay w/ IDS 11.50.FC2 on .... [15219]
> To: ids@iiug.org
> Date: Wednesday, March 18, 2009, 2:59 PM
> We ran into a similar issue in a much
> older version - IDS 7.31. Our issue
> turned out being that the application was coming through
> Citrix servers which
> were in a subnet that had reverse lookups disabled. This
> even affected
> connections to dbaccess from the command line on the
> database server. Once
> connected, performance was great - mostly because the
> majority of users were
> not connected and working. As soon as reverse lookups were
> enabled on the
> subnet, the problem immediately went away. Of course it
> took several days to
> determine the cause.
>
> This is certainly not the same upgrade scenario you are
> discussing, but if
> other seemingly unrelated DNS changes have been made
> recently, this could be
> the issue.
>
> Rob Schmitz
> Embarq Data Management
> rob.b.schmitz@embarq.com
>
> www.embarq.com
>
> -----Original Message-----
> From: ids-bounces@iiug.org
> [mailto:ids-bounces@iiug.org]
> On Behalf Of Sierra
> Moxon
> Sent: Tuesday, March 17, 2009 6:10 PM
> To: ids@iiug.org
> Subject: RE: Long connection delay w/ IDS 11.50.FC2 on ....
> [15209]
>
> We saw the same behavior in 11.10.FC2W4. At least .8
> seconds to open a
> connection with dbaccess. Also happened with dbschema. Got
> a patch
> that fixed this in 11.10.FC3. Maybe the bug is back in
> 11.50.FC2?
>
> Sierra
>
> On Tue, 17 Mar 2009, Lello, Nick wrote:
>
> > Just tested with a single statement echoed through
> dbaccess --- 30
> > minutes !!
> >
> > IBM are being as helpful as usual (English humour).
> >
> > -----Original Message-----
> > From: ids-bounces@iiug.org
> [mailto:ids-bounces@iiug.org]
> On Behalf Of
> > Walter Milan
> > Sent: 17 March 2009 17:03
> > To: ids@iiug.org
> > Subject: RE: Long connection delay w/ IDS 11.50.FC2 on
> .... [15202]
> >
> > Hmm, 10 minutes seems an eternity for me. But I was
> only testing
> > connection
> > times, no select was involved.
> > $ timex dbaccess sysmaster <<!^J;^J!> >
> > Database selected.
> > Database closed.
> > real 0.92
> > user 0.01
> > sys 0.01
> >
> > on other instances on same box(on 10.FC8), same test
> it takes only .06
> > of real
> > time. I also get .06 connecting to a new 11.50.UC3 on
> another box's
> > instance.
> > It just occurred to me to upgrade to C3 now that is
> available, and lets
> > see
> > how it goes.
> >
> > Walter Milan
> > DBA
> >
> > -----Original Message-----
> > From: ids-bounces@iiug.org
> [mailto:ids-bounces@iiug.org]
> On Behalf Of
> > Lello,
> > Nick
> > Sent: Tuesday, March 17, 2009 11:33 AM
> > To: ids@iiug.org
> > Subject: RE: Long connection delay w/ IDS 11.50.FC2 on
> .... [15199]
> >
> > I suspect something we've both missed in the release
> notes --- I've
> > scoured them with no clues.
> >
> > I did wonder about the new security setting but
> disabling this and
> > restarting the engine didn't work.
> >
> > My connections seem to take about 10 minutes; dbaccess
> - - connects
> > instantly but doing something that selects a database
> hangs.
> >
> > -----Original Message-----
> > From: ids-bounces@iiug.org
> [mailto:ids-bounces@iiug.org]
> On Behalf Of
> > Walter Milan
> > Sent: 17 March 2009 16:05
> > To: ids@iiug.org
> > Subject: RE: Long connection delay w/ IDS 11.50.FC2 on
> .... [15198]
> >
> > Just a caveat we migrated from 10.00.FC8 to 11.50.FC2
>
> >
> > Walter Milan
> > DBA
> >
> > -----Original Message-----
> > From: ids-bounces@iiug.org
> [mailto:ids-bounces@iiug.org]
> On Behalf Of
> > Walter
> > Milan
> > Sent: Tuesday, March 17, 2009 10:45 AM
> > To: ids@iiug.org
> > Subject: RE: Long connection delay w/ IDS 11.50.FC2 on
> .... [15197]
> >
> > I just yesterday opened a case with IBM regarding this
> very same
> > issue!!!. My
> > times are around 1 second.
> > We are waiting for their answer. Fortunately it is
> happening in a not
> > critical
> > instance.
> >
> > Walter Milan
> > DBA
> >
> > -----Original Message-----
> > From: ids-bounces@iiug.org
> [mailto:ids-bounces@iiug.org]
> On Behalf Of
> > Lello,
> > Nick
> > Sent: Tuesday, March 17, 2009 8:03 AM
> > To: ids@iiug.org
> > Subject: Long connection delay w/ IDS 11.50.FC2 on
> Solaris [15194]
> >
> > We have recently upgraded from IDS 11.10 to 11.50.FC2
> on Solaris 10 and
> > are now experiencing long delays connecting to the
> database on both TLI
> > and SHM connectors.... Has anyone experienced this
> with a straight
> > upgrade ?
> >
> >
> ************************************************************************
>
> >
> > *******
> > Forum Note: Use "Reply" to post a response in the
> discussion forum.
> >
> >
> ************************************************************************
>
> >
> > *******
> > Forum Note: Use "Reply" to post a response in the
> discussion forum.
> >
> >
> ************************************************************************
>
> >
> > *******
> > Forum Note: Use "Reply" to post a response in the
> discussion forum.
> >
> >
> ************************************************************************
>
> > *******
> > Forum Note: Use "Reply" to post a response in the
> discussion forum.
> >
> >
> ************************************************************************
>
> > *******
> > Forum Note: Use "Reply" to post a response in the
> discussion forum.
> >
> >
> >
>
>
*******************************************************************************
>
> > Forum Note: Use "Reply" to post a response in the
> discussion forum.
> >
>
>
>
*******************************************************************************
>
> Forum Note: Use "Reply" to post a response in the
> discussion forum.
>
>
>
*******************************************************************************
>
> Forum Note: Use "Reply" to post a response in the
> discussion forum.
>
>
Still is pending the upgrade to FC3 But a big breakthrough came when sysmaster
was recreated using $INFORMIXDIR/etc/buildsmi. Reading it, (it is a shell
script) I could see it was extremely important that no one must try to connect
to the database during migration, or the creation of the sysmaster database. I
think this is what happened to us, some cron job we did not disabled back in
that time.
Now my connection times are .16 instead of high .9s.
Still is slower that .06 I am having on other IDS 10 instances on same box.
Walter Milan
DBA
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Sierra
Moxon
Sent: Tuesday, March 17, 2009 6:10 PM
To: ids@iiug.org
Subject: RE: Long connection delay w/ IDS 11.50.FC2 on .... [15209]
We saw the same behavior in 11.10.FC2W4. At least .8 seconds to open a
connection with dbaccess. Also happened with dbschema. Got a patch
that fixed this in 11.10.FC3. Maybe the bug is back in 11.50.FC2?
Sierra
On Tue, 17 Mar 2009, Lello, Nick wrote:
> Just tested with a single statement echoed through dbaccess --- 30
> minutes !!
>
> IBM are being as helpful as usual (English humour).
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> Walter Milan
> Sent: 17 March 2009 17:03
> To: ids@iiug.org
> Subject: RE: Long connection delay w/ IDS 11.50.FC2 on .... [15202]
>
> Hmm, 10 minutes seems an eternity for me. But I was only testing
> connection
> times, no select was involved.
> $ timex dbaccess sysmaster <<!^J;^J!>
> Database selected.
> Database closed.
> real 0.92
> user 0.01
> sys 0.01
>
> on other instances on same box(on 10.FC8), same test it takes only .06
> of real
> time. I also get .06 connecting to a new 11.50.UC3 on another box's
> instance.
> It just occurred to me to upgrade to C3 now that is available, and lets
> see
> how it goes.
>
> Walter Milan
> DBA
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> Lello,
> Nick
> Sent: Tuesday, March 17, 2009 11:33 AM
> To: ids@iiug.org
> Subject: RE: Long connection delay w/ IDS 11.50.FC2 on .... [15199]
>
> I suspect something we've both missed in the release notes --- I've
> scoured them with no clues.
>
> I did wonder about the new security setting but disabling this and
> restarting the engine didn't work.
>
> My connections seem to take about 10 minutes; dbaccess - - connects
> instantly but doing something that selects a database hangs.
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> Walter Milan
> Sent: 17 March 2009 16:05
> To: ids@iiug.org
> Subject: RE: Long connection delay w/ IDS 11.50.FC2 on .... [15198]
>
> Just a caveat we migrated from 10.00.FC8 to 11.50.FC2
>
> Walter Milan
> DBA
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> Walter
> Milan
> Sent: Tuesday, March 17, 2009 10:45 AM
> To: ids@iiug.org
> Subject: RE: Long connection delay w/ IDS 11.50.FC2 on .... [15197]
>
> I just yesterday opened a case with IBM regarding this very same
> issue!!!. My
> times are around 1 second.
> We are waiting for their answer. Fortunately it is happening in a not
> critical
> instance.
>
> Walter Milan
> DBA
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> Lello,
> Nick
> Sent: Tuesday, March 17, 2009 8:03 AM
> To: ids@iiug.org
> Subject: Long connection delay w/ IDS 11.50.FC2 on Solaris [15194]
>
> We have recently upgraded from IDS 11.10 to 11.50.FC2 on Solaris 10 and
> are now experiencing long delays connecting to the database on both TLI
> and SHM connectors.... Has anyone experienced this with a straight
> upgrade ?
>
> ************************************************************************
>
> *******
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
> ************************************************************************
>
> *******
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
> ************************************************************************
>
> *******
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
> ************************************************************************
> *******
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
> ************************************************************************
> *******
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.