Jerry,

Observe: In the example below, you will note that CONFIGURE.FILE has no effect on the physical size of the ALPHA file, and the size is defined by the current modulus.

The modulus can be computed from the size of a dynamic file using modulus = (totalbytes - 2048)/2048, which will yield "23" for the BETA file size.

To double check that there was not some sort of sparse creation algorithm involved, I added 3 small records to the "modulus 23" ALPHA file, and found that they all appeared in the same group. ANALYZE.FILE will give you the true modulus (see below).

In the case of ALPHA, deleting records will not contract the file unless the current modulus is greater than 23.

These examples are on a Solaris system. There is a chance that Windows behaves differently.

-Rick



:CREATE.FILE ALPHA DYNAMIC
Creating file "ALPHA" as Type 30.
Creating file "D_ALPHA" as Type 3, Modulo 1, Separation 2.
Added "@ID", the default record for RetrieVe, to "D_ALPHA".
:! ls -l ALPHA
total 16
-rw-rw-r--   1 rick     piadm       4096 Mar  9 13:53 DATA.30
-rw-rw-r--   1 rick     piadm       2048 Mar  9 13:53 OVER.30
:CONFIGURE.FILE ALPHA MINIMUM.MODULUS 23
File name                               = ALPHA
Changing Minimum Modulus from 1 to 23.
File name                               = ALPHA configured.
:.X2
02 ! ls -l ALPHA
total 16
-rw-rw-r--   1 rick     piadm       4096 Mar  9 13:53 DATA.30
-rw-rw-r--   1 rick     piadm       2048 Mar  9 13:53 OVER.30


:CREATE.FILE BETA DYNAMIC MINIMUM.MODULUS 23
Creating file "BETA" as Type 30.
Creating file "D_BETA" as Type 3, Modulo 1, Separation 2.
Added "@ID", the default record for RetrieVe, to "D_BETA".
:! ls -l BETA
total 112
-rw-rw-r--   1 rick     piadm      49152 Mar  9 13:54 DATA.30
-rw-rw-r--   1 rick     piadm       2048 Mar  9 13:54 OVER.30
:

:ANALYZE.FILE ALPHA
File name ..................   ALPHA
Pathname ...................   ALPHA
File type ..................   DYNAMIC
Hashing Algorithm ..........   GENERAL
No. of groups (modulus) ....   1 current ( minimum 23 )
Large record size ..........   1628 bytes
Group size .................   2048 bytes
Load factors ...............   80% (split), 50% (merge) and 2% (actual)
Total size .................   6144 bytes



On Mar 9, 2007, at 1:14 PM, Jerry wrote:

Did you mean that UniVerse doesn't have the CONFIGURE.FILE or what? Because UniVerse has the CONFIGURE.FILE command, the keyword MINIMUM.MODULUS, and it works immediate without using the IMMEDIATE key word.

----- Original Message ----- From: "Richard Nuckolls" <[EMAIL PROTECTED]>
To: <u2-users@listserver.u2ug.org>
Sent: Friday, March 09, 2007 2:35 PM
Subject: Spam:Re: [U2] Dynamic files, big transactions


CONFIGURE.FILE MINIMUM.MODULUS ... (in the Prime/PI Open version) would accept a keyword of IMMEDIATE to force the splitting of groups. Universe lacks this option, so you should specify MINIMUM.MODULUS at the time that you create the part file.
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Reply via email to