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
co
OSX? - that's handy - appealing to the masses there ;)
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath
Sent: 02 July 2012 18:20
To: U2 Users List
Subject: Re: [U2] Running XLr8 Tools inside U2 DBTools
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 Beh
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,
there
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
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 (whic
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 my
Doug,
When I do the math I come up with a different # (see below):
File name .. TEST_FILE
Pathname ... TEST_FILE
File type .. DYNAMIC
File style and revision 32BIT Revision 12
Hashing Algorithm .. GENERAL
No. of groups (modul
There are 3 ways I can think of offhand to tell the subroutine what date range
to use. I like #3 the best:
1: use common variables, which is what the example function MARKH does. The
downside is that you have to assign the common variables before you run the
query.
2: You could use @SENTENCE i
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 parameters
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,
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
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 Algori
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?
>
(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
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 n
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:
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 ab
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 .. GENERA
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 t
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
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 everyth
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 ti
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
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 pret
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
___
U2-Users
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 .. DY
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 Austi
You can do just about anything by calling a subroutine from an I-type
dictionary item.
On 3 July 2012 05:41, Mecki Foerthmann 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
> loop. How
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
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 t
Disks get "bigger" much faster than the rate they get "faster".
So the overflow is the thing to minimize.
-Original Message-
From: Chris Austin
To: u2-users
Sent: Tue, Jul 3, 2012 2:38 pm
Subject: Re: [U2] RESIZE - dynamic files
his is why I'm confused.. Is the goal here to reduce
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. Bu
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
ne
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 split.l
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 "'/'...
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 w
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 w
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 i
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,
Br
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
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+
Reg
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
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
44 matches
Mail list logo