IDS Forum

Re: Slow table update on new server 11.50.FC9

Posted By: LARRY SORENSEN
Date: Tuesday, 24 January 2017, at 8:30 p.m.

In Response To: RE: Slow table update on new server 11.50.FC9 (Everett Mills)

And there is tons of extra disk space.

Larry

________________________________
From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Everett Mills <Everett.Mills@nationalbeef.com>
Sent: Tuesday, January 24, 2017 2:46 PM
To: ids@iiug.org
Subject: RE: Slow table update on new server 11.50.FC9 [38551]

Is the disk space on the new server set up optimally for databases? RAID 10,
not RAID 5, no journaling, etc.?

> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> LARRY SORENSEN
> Sent: Tuesday, January 24, 2017 15:23 PM
> To: ids@iiug.org
> Subject: Slow table update on new server 11.50.FC9 [38550]
>
> I sent this in yesterday, but I never saw it posted; nor did I receive
> any responses.
>
> As of this moment, one of the queries mentioned below has been running
> for about 18 hours now and it is still processing.
>
> Larry
>
> ________________________________
> From: LARRY SORENSEN
> Sent: Monday, January 23, 2017 1:04 PM
> To: ids@iiug.org
> Subject: Slow table update on new server 11.50.FC9
>
> Solaris 10
>
> IDS 11.50.FC9 WorkGroup Edition
>
> I have a new server that I am testing out. I copied all the
> configurations from the previous server, and I loaded this server from
> an archive of the previous server. I seems to be running slowly even
> though there is nothing else running. Also, it has a lot more of all
> resources available than the previous server (memory, cpu, disk space,
> etc.)
>
> For example, I am doing the following on 2 large tables. The server is
> 99%-100% idle and the queries are taking hours. The tables are
> approximately
> 25-30 GB each.
>
> UPDATE table_name SET column2 = column2 WHERE 1=1;
>
> During some other testing, we have a program that usually processes 120
> records per hour. On this server it processed about 30 records per hour
> when tested.
>
> What are some things that I can look at to speed this server up?
>
> Both servers have the same configurations in the $ONCONFIG.
>
> Both servers are running the same versions of Informix and Solaris.
>
> The new, slower server, is beefier in every way; but it seems to
> process slower.
>
> Larry
>
> ________________________________
> From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Andreas
> Legner <andreas.legner@de.ibm.com>
> Sent: Monday, January 23, 2017 12:30 PM
> To: ids@iiug.org
> Subject: Re: Upgrading from 11.50.FC5 to 11.50.FC9 [38541]
>
> For the first question:
>
> 32MB SHMADD looking a little small compared to 2GB SHMVIRTSIZE - you
> might =
>
> want to increase SHMVIRTSIZE to e.g. 3GB up front (to avoid any
> dynamic=20
> addition) plus increasing SHMADD to e.g. 0.5 or 1 GB. Depending on
> what=20 you can afford on your machine in terms of available memory.
>
> The sample you gave happens to be a *message* segment - I'm guessing=20
> what you referring to are a number of *virtual* segments?
>
> As for the i4gl I'd not see why this needed to change, as long as the
> used =
>
> functionality wouldn't change, but maybe someone has to add
> something=20 here.
>
> Regards,
> Andreas
>
> From: "LARRY SORENSEN" <LSORENSEN25@msn.com>
> To: ids@iiug.org
> Date: 23.01.2017 19:44
> Subject: Re: Upgrading from 11.50.FC5 to 11.50.FC9 [38540] Sent by:
> ids-bounces@iiug.org
>
> No help out there on this?=20
>
> =5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5
> F=5F=
> =5F=5F=5F=5F=5F=5F=5F=20
> From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of LARRY=20
> SORENSEN=20
> <LSORENSEN25@msn.com>=20
> Sent: Sunday, January 22, 2017 1:30 PM=20
> To: ids@iiug.org=20
> Subject: Upgrading from 11.50.FC5 to 11.50.FC9 [38534]=20
>
> Solaris 10 Sparc=20
>
> IDS Growth Edition 11.50.FC5 -> 11.50.FC9=20
>
> i4gl 7.32.FC3=20
>
> I have a few questions concerning the upgrade. I have I4GL installed
> as=20
> well.=20
> I copied over everything from the 11.50.FC5 directory, which had
> I4GL=20
> already=20
> installed, and I installed 11.50.FC9 on top of it and ran
> ids=5Finstall.=20
>
> First, the database came up fine, but there were several informative=20
> segments=20
> in the online.log that said it was requesting more shared memory. What
> do=20
> I=20
> need to change in the $ONCONFIG file to get everything I need at
> startup=20 without requesting more shared memory?=20
>
> SHMBASE 0x10A000000L=20
>
> SHMVIRTIZE 2457600=20
>
> SHMADD 32768=20
>
> EXTSHMADD 8192=20
>
> SHMTOTAL 0=20
>
> (repeated several times; 5-6 times)=20
>
> Requested shared memory segment size rounded from 4280KB to 5120KB=20
>
> Dynamically allocated new message shared memory segment (size 5120K)=20
>
> Memory sizes: resident:2143232 KB, virtual:2483200 KB,
> SHMTOTAL:16777216=20
> KB=20
>
> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=20
>
> Second question, I thought that someone mentioned that if I went
> from=20
> 11.50.FC5 to 11.50.FC9, I would also have to upgrade my I4GL. Is that
> the=20 case, and which version do I need to go to?=20
>
> Larry=20
>
> ***********************************************************************
> ****=
> ****=20
>
> Forum Note: Use "Reply" to post a response in the discussion forum.=20
>
> ***********************************************************************
> ****=
> ****=20
>
> Forum Note: Use "Reply" to post a response in the discussion forum.=20
>
>
> ***********************************************************************
> ********
> 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.

Messages In This Thread

• Slow table update on new server 11.50.FC9
  LARRY SORENSEN -- Tuesday, 24 January 2017, at 4:23 p.m.
  • RE: Slow table update on new server 11.50.FC9
    Everett Mills -- Tuesday, 24 January 2017, at 4:46 p.m.
    • Re: Slow table update on new server 11.50.FC9
      LARRY SORENSEN -- Tuesday, 24 January 2017, at 5:09 p.m.
    • Re: Slow table update on new server 11.50.FC9
      LARRY SORENSEN -- Tuesday, 24 January 2017, at 8:30 p.m.
      • Re: Slow table update on new server 11.50.FC9
        Madison Pruet -- Tuesday, 24 January 2017, at 8:51 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.