Re: [U2] RESIZE - dynamic files

Almost. Though the file will look after itself, it may not do so very well. Dynamic files, for best performance, do sometimes need periodic resizing. Having said that it is true that some never resize Dynamic files. If the minimum modulo is much lower than the actual, then this will cause

Re: [U2] Running XLr8 Tools inside U2 DBTools new Eclipse release

Sadly I *do* have to use Eclipse on OSX. It's the best way I've found so far to write fast iOS/Android apps (using Appcelerator Titanium). It's also ugly as sin. Grrr Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On

Re: [U2] Running XLr8 Tools inside U2 DBTools new Eclipse release

One of our Java programmers lives and breaths Mac's. We develop on the Mac and run on the Mac. We have for years many years been running on the Mac. There are many things that have to be tuned for the Mac on Eclipse. Whether it is the the Java libraries that are slightly different or SWT,

Re: [U2] UniVerse LIST statement question [not-secure]

What Brian said, except don't replace LIST! Rather, write your subroutine to be called from an I-descriptors: MARKH 0001 FUNCTION MARKH( INARG ) 0002 COMMON /MARKH/ START.IDT, END.IDT, PREV.ID, VLIST 0003 * 0004 * Assumes common has been initialized properly before this function

[U2] Exiting UniData

Going back to my post about runaway processes: According to our UniData manuals, the official commands to terminate a UniData session are BYE, LO and QUIT. I have since found that LO and OFF (not sure where this came from) simply run the QUIT command. QUIT runs an SB command called SH.OFF

Re: [U2] Exiting UniData

Runs the globally cataloged program _SB_SH.OFF -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Tuesday, July 03, 2012 10:31 AM To: 'U2 Users List' Subject: [U2] Exiting UniData Going back to

Re: [U2] UniVerse LIST statement question [not-secure]

Ed is quite right. 1: I just did it for simplicity in the example. 2: @SENTENCE, without a wrapper: you have do get ReTrieve to ignore part of the sentence. I've never come up with a good way to do that other than via EVAL. Anyone? 3. EVAL: Yes, it is a way to pass run-time

Re: [U2] RESIZE - dynamic files

File name .. GENACCTRN_POSTED Pathname ... GENACCTRN_POSTED File type .. DYNAMIC File style and revision 32BIT Revision 12 Hashing Algorithm .. GENERAL No. of groups (modulus) 92776 current ( minimum 31, 89 empty,

Re: [U2] RESIZE - dynamic files

Yep, I added an extra 2 in the key value. Oh, the perils of cut and paste... ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] RESIZE - dynamic files

No worries Doug. I'm just wondering if the calculation makes sense (if we use the example below): File name .. GENACCTRN_POSTED Pathname ... GENACCTRN_POSTED File type .. DYNAMIC File style and revision 32BIT Revision 12 Hashing

Re: [U2] RESIZE - dynamic files

See comment interspersed... Using the record above, how would I calculate the following? 1) MINIMUM.MODULUS (Is there a formula to use or should I add 20% to the current number)? Should be less the the current size, if you want the file to merge 2) SPLIT - would 90% seem about right?

Re: [U2] RESIZE - dynamic files

(record + id / 4096 or 2048) You need to factor in overhead the split factor: (records + ids) * 1.1 * 1.25 / 4096(for 80%) If you use a 20% merge factor and a 80% split factor, the file will start merging unless you delete 60 percent of your records. If you use 90% split factor, you

Re: [U2] Running XLr8 Tools inside U2 DBTools new Eclipse release

Hi Dan and others: I finished testing all of the Rocket tools. Turns out the only one that really works as a plug-in platform is BDT for U2logic plug-ins. The other products are crippled versions of Eclipse with limited menus by design. Another big problem is that Rocket's Eclipse products do

Re: [U2] RESIZE - dynamic files

So for this example what would be a good SPLIT level and what would be a good MERGE level to use? It was my understanding that I wanted to lower my merge to something below 50% and increase the split to reduce splitting. Chris From: r...@lynden.com To: u2-users@listserver.u2ug.org Date:

Re: [U2] RESIZE - dynamic files

Doug, The data is growing over time with this file. Does that mean I should ignore the formula? Or should I still use a lower MINIMUM.MODULO than the actual modulo #.. Is the idea to reduce overflow by lowering the split? What is this 'overflow' referring to? 2) SPLIT - would 90% seem

Re: [U2] RESIZE - dynamic files

Using the formula below, and changing the split to 90% I get the following: File name .. GENACCTRN_POSTED Pathname ... GENACCTRN_POSTED File type .. DYNAMIC File style and revision 32BIT Revision 12 Hashing Algorithm ..

Re: [U2] RESIZE - dynamic files

I would recommend that if you intend to do resizing on a regular basis an you want to improve the performance of the file you might consider resizing the file to a static file type so that you can have more control over the hashing algorithm, separation and modulo. Chris Austin wrote: Using

Re: [U2] RESIZE - dynamic files

The split load is not affecting anything here, since it is more than the actual load. What your overflow suggests is that you lower the split.load value to 70$% or below. You could go ahead and set the merge.load to an arbitrarily low number (1), and it will probably never do a merge, which

Re: [U2] UniVerse LIST statement question [not-secure]

There have been more than a few times when I wished that MV query was a little more extensible. On a couple of occasions I have created throwaway connectives as a means to pass flags to an i-type or a B correlative, but it would be nice if there were a keyword that flagged to just ignore

Re: [U2] RESIZE - dynamic files

I guess what I need to know is what's an acceptable % of overflow for a dynamic file? For example, when I change the SPLIT LOAD to 90% (while using the calculated min modulus) I'm still left with ~ 20% of overflow (see below). Is 20% overflow considered acceptable on average or should I keep

Re: [U2] RESIZE - dynamic files

The actual load is 70% on your file. The split.load of 90 was set after the file was loaded. If you leave it at that value, and add another 100,000 records, your modulus will not grow, but the number of overflowed groups will. Perhaps you need to look at is as 80% not overflowed. Despite the

Re: [U2] RESIZE - dynamic files

One rule of thumb is to make sure that you have an average of 10 or less items in each group. Going by that, you'd want a minimum mod of 130k or more. I've also noticed that files approach the sweet spot for minimizing overflow without having excessive empty groups when the total size is

Re: [U2] Is there any way to tell if I am in an EXECUTE level and CAPTURING is turned on?

I just noticed this in the help for QM's SYSTEM() 1000 Returns 1 if EXECUTE CAPTURING is in effect, 0 otherwise Checked if this was an undocumented feature that Martin had reproduced; but no, it doesn't work in Universe. Regards, Keith ___

Re: [U2] RESIZE - dynamic files

Dan, I changed the MINIMUM.MODULUS to the value of 23 as you suggested and my Actual Load has really gone down (as well as overflow). See below for the results: File name .. GENACCTRN_POSTED Pathname ... GENACCTRN_POSTED File type ..

Re: [U2] RESIZE - dynamic files

But the total size of your file is up 60%. Reading in 60% more records in a full select of the file is going to be much slower than a few more overflows. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris

Re: [U2] *** GMX Spamverdacht *** UniVerse LIST statement question [not-secure]

You can do just about anything by calling a subroutine from an I-type dictionary item. On 3 July 2012 05:41, Mecki Foerthmann mec...@gmx.net wrote: Since we don't have outer joins I would build a work file starting with selecting all employees, then select the calls and merge them together in a

Re: [U2] RESIZE - dynamic files

I should have said 60% more disk records, to be clear. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Rick Nuckolls Sent: Tuesday, July 03, 2012 2:24 PM To: 'U2 Users List' Subject: Re: [U2] RESIZE - dynamic files

Re: [U2] RESIZE - dynamic files

This is why I'm confused.. Is the goal here to reduce 'overflow' or to keep the 'Total size' of the disk down? If the goal is to keep the total disk size down then it would appear you would want your actual load % a lot higher than 37%.. and then ignore 'some' of the overflow.. Chris But

Re: [U2] RESIZE - dynamic files

Disks get bigger much faster than the rate they get faster. So the overflow is the thing to minimize. -Original Message- From: Chris Austin cjausti...@hotmail.com To: u2-users u2-users@listserver.u2ug.org Sent: Tue, Jul 3, 2012 2:38 pm Subject: Re: [U2] RESIZE - dynamic files his is

Re: [U2] RESIZE - dynamic files

37% is a very low load. Reading disk records takes much longer than parsing the records out of a disk record. With variable record size and moderately poor hashing, overflow is inevitable. So, do you want 80,000 extra groups, or 20,000 overflow buffers? I would go with the smaller number.

Re: [U2] RESIZE - dynamic files

Chris, This is why file-sizing is something that requires careful thought. As some of the other responders have indicated, sometimes you want to keep overflow to a minimum (because accessing individual records that are in overflow takes extra disk reads, which slow down your system, and adding

Re: [U2] RESIZE - dynamic files

I set the split load based on what Dan suggested: I'd take the merge down a little, to maybe 30% or even less, and maybe knock the split up a bit - say, 90% - to cut down on the splitting. I thought this would cut down on splitting. Is there a certain formula, or way to calculate the

[U2] Account.File.Stats ALL

When you execute the Account.File.Stats command in Universe, with the ALL directive, the code executes the following command to make it's selection SSELECT VOC WITH TYPE = F AND F2 NOT.MATCHING 'I_'... AND F2 NOT.MATCHING '../'... AND F2 NOT.MATCHING '..\'... AND F2 NOT.MATCHING '/'... AND F2

Re: [U2] RESIZE - dynamic files

Unless the minimum modulus is configured high enough to artificially lower the actual load, the actual load will rise to the designated split.load as the file grows. The split.load indicates nothing about the specific load of any given group; so if it is set to 90%, then on average, each group

Re: [U2] RESIZE - dynamic files

Chris, Let's back way up. I take it your original question is a general one, not specific to one poorly performing problematic file. Is that right? If so, generally speaking, you just don't get a lot out of fine-tuning dynamic files. Tweaking the default parameters doesn't usually make a

Re: [U2] RESIZE - dynamic files

From the System Description manual: Important Considerations Dynamic files are meant to make file management easier for users. The default parameters are set so that most dynamic files work efficiently. If you decide to change the parameters of a dynamic file, keep the following considerations

Re: [U2] Running XLr8 Tools inside U2 DBTools new Eclipse release

I don't have BDT or other Rocket tools installed to confirm, but would specifying the same -data workspacepath in the arguments for each achieve what you're after ? (via: http://help.eclipse.org/indigo/index.jsp?topic=%2Forg.eclipse.platform.doc.user%2Ftasks%2Frunning_eclipse.htm) Regards,

Re: [U2] Running XLr8 Tools inside U2 DBTools new Eclipse release

I think my point go lost in all of the words. Rocket is delivering Eclipse plug-ins that are not first class. BDT has the menu item File-Switch Workspace, but the others Eclipse products have been stripped of features. Sure I can change the u2admin.ini to reference another work space. Did I

[U2] Exiting UniData

Hi John, I'm on an SB+ site on Universe which is completely unrelated to Epicor. Our QUIT is an exact copy of SH.OFF, which is a local catalogue pointer to the program code. I believe SH.OFF tidies up various SB+ stuff and then chains to OFF, and that this is the standard behaviour of SB+

Re: [U2] RESIZE - dynamic files

I would suggest that then actual goal is to achieve maximum performance for your system, so knowing HOW the file is used on a daily basis can also influence decisions. Disk is a cheap commodity, so having some wastage in file utilization shouldn't factor. Ross Ferris Stamina Software Visage

Re: [U2] RESIZE - dynamic files

Doug may have had a key bounce in his input Let's do the math: 258687736 (Record Size) 192283300 (Key Size) The key size is actually 19283300 in Chris' figures Regarding 68,063 being less than the current modulus of 82,850. I think the answer may lie in the splitting process.