I wrote an article for Spectrum magazine (2002?) on this topic that extolled the simplicity of a WORK-PORT# file for allowing multiple users to run the same reports simultaneously without littering your MD (VOC) with dozens of RPT-PORT# specific files.
Should anyone wish a copy of it, email off-line. thanks. ----- Original Message ----- From: "Baakkonen, Rodney" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, June 29, 2004 8:46 AM Subject: RE: [U2] Available Memory Exceeded > 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/ ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
