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=5F=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.