The best long term solution might be to rewrite the program to
replace the dynamic array with a work file. Most dynamic arrays are built
based on using 'locate' to see where to place the data in the array.
Whatever you are using to do the 'locate' with can be the key to a record in
a work file. Once the work file is built, you can order the data using sort
on the work file. We have found three benefits to this approach:
1. We don't blow shared memory and have the process abort.
2. The work file approach (with a correctly sized work file)
runs much faster. We had a program that used the dynamic array method that
would run for a week. We changed it to a work file and it was done in less
than 24 hours.
3. The contents of the work file can be used for multiple
reports by adding additional sort and break totals.
In general, we discourage the use of dynamic arrays. Not
only do huge arrays slow the program that is running down. They also degrade
the whole system and cause interactive users to complain about system
response.
Just my 2 cents. - Rod
-----Original Message-----
From: Mats Carlid [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 29, 2004 1:13 AM
To: [EMAIL PROTECTED]
Subject: Re: [U2] Available Memory Exceeded
Also check the solaris configurable parameters.
For example isn't there a limit on per process memory
( MAXUMEM ? ) . Has it been changed in the upgrade ?
Remember all tunables have a default value that may
change between releases so You're not safe even if You copy
the /etc/System file.
HTH
-- mats
Ang Suan Yong wrote:
>Dear All,
>
> Is true that this program is building a huge string. However we
>didint face in our old system , ie Universe 9.6 on Sun Solaris
>
> We have just migrate to Sunfire 6800 (having 16g of RAM) and the
>Database using Universe 10.0.8 , Sun Solaris 9, the UVCONFIG is using same
>as the old system. /tmp file is ufs file system still 15g available and
>during the program run is no much users access to the system and the server
>is not heavy usage during as well as no much Record Locks at that point
>
> Wondering is the new version of Universe 10 having certain kind of
>control on memory/buffer ?
-------
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
