Oninit cdi / Archive
Talk to an expert →

dbaccess, dbschema, onmonitor all slow in 11.10.FC

Posted in 2008

Topics: Performance & Tuning, Installation, Setup & Upgrades, Connectivity: ESQL/C, 4GL & Embedded SQL, Server Administration, Platform-Specific Issues

Sierra Moxon — — source: IIUG Forums & Mailing Lists

Hi Gurus- We recently upgraded our Solaris 9 box with IDS 11.10.FC2W4. Immediately after, we noticed a slow-down in opening connections to databases with tools like dbaccess, dbschema and onmonitor. I've truss'd the dbaccess process and on average, opening a connection with dbaccess from the command line is .7 seconds slower with the 11.10.FC2W4. With 11.10.FC2 our connections with dbaccess took an average of .15 seconds. Once dbaccess is open, we haven't noticed any performance problems running queries. We use dbaccess and dbschema fairly heavily to create development sandboxes; we saw an increase of 10 minutes to deploy a development site with 11.10.FC2W4 over 11.10.FC2. We don't use 4GL or iSQL. We do have web datablade installed. Has anyone else seen this problem? Thanks for your time, Sierra

↪ replying to Sierra Moxon
PING TANG — — source: IIUG Forums & Mailing Lists

Hi Sierra This is an issue in 11.10.FC2W4 and it has been fixed in 11.10.FC2W5. Please upgrade to W5 or contact IBM support for a patch. Thanks! -Ping --- On Thu, 11/20/08, Sierra Moxon <staylor@cs.uoregon.edu> wrote: > From: Sierra Moxon <staylor@cs.uoregon.edu> > Subject: dbaccess, dbschema, onmonitor all slow in 11.1.... [14075] > To: ids@iiug.org > Date: Thursday, November 20, 2008, 1:43 PM > Hi Gurus- > > We recently upgraded our Solaris 9 box with IDS > 11.10.FC2W4. Immediately > after, we noticed a slow-down in opening connections to > databases with > tools like dbaccess, dbschema and onmonitor. > > I've truss'd the dbaccess process and on average, > opening a connection > with dbaccess from the command line is .7 seconds slower > with the > 11.10.FC2W4. With 11.10.FC2 our connections with dbaccess > took an > average of .15 seconds. Once dbaccess is open, we > haven't noticed any > performance problems running queries. > > We use dbaccess and dbschema fairly heavily to create > development > sandboxes; we saw an increase of 10 minutes to deploy a > development > site with 11.10.FC2W4 over 11.10.FC2. > > We don't use 4GL or iSQL. We do have web datablade > installed. > > Has anyone else seen this problem? > > Thanks for your time, > Sierra > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in > the discussion forum.

Glossary