-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson
Sent: 28 September 2012 21:53
To: U2 Users List
Subject: Re: [U2] RESIZE error - Replication?
In the UV account UV_UDRPUB has 6 items.
UV_UDRSUB and UV_UDRSYS are empty.
On Fri, Sep 28, 2012 at 4:52 PM, John Thompson
jthompson
hi,
on 10.3, we talk about UVReplication vs. U2Replication available o r11.
UVRep is set file by file using UniAdmin, the gui tool delivered on UVClient CD.
Before RESIZE; you must unset the replication flag from the file header.
Use UniAdin to achieve it. see Replication branch.
After
Yes - the tool is part of the client software. U2 replication is quite a
different architecture, and the replication tool is part of XAdmin, or you can
use the command line.
Manu summed it quite nicely.
Regards , JayJay
Sent from my iPad
On 28 Sep 2012, at 01:45, John Thompson
Ok. I believe I see what you guys are talking about.
So the story goes, they tried to use old style UV replication and it did
not work for what they wanted to do... SO
they abandoned it.
Right now, UDRMODE is set to 0
and the output of smat -t says UDRMODE is 0
In Uniadmin, do I unpublish the
In the UV account UV_UDRPUB has 6 items.
UV_UDRSUB and UV_UDRSYS are empty.
On Fri, Sep 28, 2012 at 4:52 PM, John Thompson jthompson...@gmail.comwrote:
Ok. I believe I see what you guys are talking about.
So the story goes, they tried to use old style UV replication and it did
not work for
Has anyone ever seen this error while trying to resize a file.
RESIZE CUSTOMER
RESIZE attempt on a replicated file.
I've never seen it and I was trying to do a bit of maintenance.
--
John Thompson
___
U2-Users mailing list
The file has been marked for replication. Depending on your UniVerse version
this is either old style replication, or the newer U2 replication. If it
should not be replicated then use the Replication configuration tool or XAdmin
to turn this off for the file. You may also want to check your
Its Universe 10.3.1 on Red Hat 5, so I'm guessing its the old style?
Is the replication tool a part of the UVClient windows software?
On Thu, Sep 27, 2012 at 8:43 PM, John Jenkins u2g...@btinternet.com wrote:
The file has been marked for replication. Depending on your UniVerse
version this is
it take to
initially populate the file.
John
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson
Sent: Thursday, July 05, 2012 5:41 PM
To: U2 Users List
Subject: Re: [U2] RESIZE - dynamic files
Chris
On 05/07/12 23:58, Rick Nuckolls wrote:
Oops, I would of thought that if a file had, say 100,000 bytes, @ 70 percent
full, there would be 30,000 bytes empty or dead. Are you suggesting the
there would be 70,000 bytes of data and 42,000 bytes of dead space?
Do you mean 100,000 bytes of disk
you gain anything by reducing overflow?
Chris
To: u2-users@listserver.u2ug.org
From: wjhon...@aol.com
Date: Thu, 5 Jul 2012 20:12:21 -0400
Subject: Re: [U2] RESIZE - dynamic files
A BASIC SELECT cannot use criteria at all.
It is going to walk through every record in the file, in order
-users@listserver.u2ug.org
Sent: Fri, Jul 6, 2012 10:23 am
Subject: Re: [U2] RESIZE - dynamic files
o is there a performance increase in BASIC SELECTS by reducing overflow? Some
eople are saying to reduce disk space to speed up the BASIC SELECT
hile others say to reduce overflow.. I'm a bit
ignore the bs and use the defaults. :)
-Rick
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin
Sent: Friday, July 06, 2012 9:56 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] RESIZE - dynamic files
-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin
Sent: 07/06/2012 12:56 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] RESIZE - dynamic files
So is there a performance increase in BASIC SELECTS by reducing overflow?
Some
Subject: Re: [U2] RESIZE - dynamic files
Logically, the graphed solution to varying the split.load value with an
-axis=modulus, y-axis=time_to_select__read_the_whole_file is going to be
arabolic, having very slow performance at modulus=1 and modulus = # of records.
If you actually want to find
, I think
this is all starting to make sense.
Chris
From: ro...@stamina.com.au
To: u2-users@listserver.u2ug.org
Date: Wed, 4 Jul 2012 01:36:26 +
Subject: Re: [U2] RESIZE - dynamic files
I would suggest that then actual goal is to achieve maximum performance for
your system, so knowing
...@datacom.co.nz
To: u2-users@listserver.u2ug.org
Date: Wed, 4 Jul 2012 14:05:02 +1200
Subject: 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
] On Behalf Of Chris Austin
Sent: 05 July 2012 15:19
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] RESIZE - dynamic files
I was able to drop from 30% overflow to 12% by making 2 changes:
1) changed the split from 80% to 70% (that alone reduce 10% overflow)
2) changed the MINIMUM.MODULUS
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin
Sent: 05 July 2012 15:19
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] RESIZE - dynamic files
I was able to drop from 30% overflow to 12% by making 2 changes:
1) changed the split from 80% to 70% (that alone
the performance I need to write a ton of records and then capture the
output and compare the output using timestamps.
Chris
From: r...@lynden.com
To: u2-users@listserver.u2ug.org
Date: Thu, 5 Jul 2012 09:22:02 -0700
Subject: Re: [U2] RESIZE - dynamic files
Chis,
I still am wondering what
, July 05, 2012 11:21 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] RESIZE - dynamic files
Rick,
You are correct, I should be using the smaller size (I just haven't changed it
yet). Based on the reading I have done you should
only use the larger group size when the average record size
...@lynden.com
To: 'U2 Users List' u2-users@listserver.u2ug.org
Sent: Thu, Jul 5, 2012 2:29 pm
Subject: Re: [U2] RESIZE - dynamic files
Chris,
For the type of use that you described earlier; BASIC selects and reads,
educing overflow will have negligible performance benefit, especially compared
o
Chris,
I can appreciate what you are doing as an academic exercise.
You seem happy how it looks at this moment, where, because you set
MINIMUM.MODULUS 118681, you ended up with a current load of 63%.
But think about it: as you add records, the load will reach 70%, per
SPLIT.LOAD 70, then
On 05/07/12 16:12, Martin Phillips wrote:
A file without overflow is not necessarily the best solution. Winding the
split load down to 70% means that at least 30% of the file
is dead space. The implication of this is that the file is larger and will
take more disk reads to process
On 05/07/12 14:49, Chris Austin wrote:
Disk space is not a factor, as we are a smaller shop and disk space comes
cheap. However, one thing I did notice is when I increased the modulus to a
very large
number which then increased my disk space to about 3-4x of my record data, my
SELECT
-
From: Rick Nuckolls r...@lynden.com
To: 'U2 Users List' u2-users@listserver.u2ug.org
Sent: Thu, Jul 5, 2012 2:29 pm
Subject: Re: [U2] RESIZE - dynamic files
Chris,
For the type of use that you described earlier; BASIC selects and reads,
educing overflow will have negligible performance benefit
: Thu, Jul 5, 2012 4:43 pm
Subject: Re: [U2] RESIZE - dynamic files
Most disks and disk systems cache huge amounts of information these days, and,
epending on 20 factors or so, one solution will be better than another for a
iven file.
For the wholesale, SELECT F WITH, The fewest disk records
...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Thursday, July 05, 2012 5:12 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] RESIZE - dynamic files
A BASIC SELECT cannot use criteria at all.
It is going to walk through every record in the file, in order.
And that's the sticky wicket. That whole
.
Chris
To: u2-users@listserver.u2ug.org
From: wjhon...@aol.com
Date: Thu, 5 Jul 2012 20:12:21 -0400
Subject: Re: [U2] RESIZE - dynamic files
A BASIC SELECT cannot use criteria at all.
It is going to walk through every record in the file, in order.
And that's the sticky wicket. That whole
All the other groups effectively get 1 added to their number
Not exactly.
Sorry to those who already know this, but maybe it's time to go over linear
hashing in theory ..
Linear hashing was a system devised by Litwin and originally only for
in-memory lists. In fact there's some good
Good explanation, Brian!
To anyone who skipped it because it looked long: read it anyway.
cds
On 7/4/2012 5:26 AM, Brian Leach wrote:
Sorry to those who already know this, but maybe it's time to go over linear
hashing in theory ..
Linear hashing was a system devised by Litwin and originally
This makes it sound as if you might need to search two groups for a record,
which is not correct. If the initial hash is based on the larger modulo, and
the group exists, then the key will be in the higher number group. If the
result of the first hash is larger than the modulus of the of the
SMAT -d (or ANALYZE.SHM -d) see uv/bin/smat[.exe]
uv/bin/analyze.shm[.exe]
Dynamic Files:
Slot # Inode Device Ref Count Htype Split Merge Curmod Basemod
Largerec Filesp Selects Nextsplit
0 1285128087 209307792516208050 4001
2048 3267 2782736
On 04/07/12 11:26, Brian Leach wrote:
All the other groups effectively get 1 added to their number
Not exactly.
Sorry to those who already know this, but maybe it's time to go over linear
hashing in theory ..
Linear hashing was a system devised by Litwin and originally only for
in-memory
I believe PiOpen used a directory with two files in it ‘$0’ and ‘$1’
corresponding to DATA.30 and OVER.30. If the numbers went up from there, I
think that they corresponded to alternate keys, ie ‘$2’ and ‘$3’ represented
DATA.30 and OVER.30 for the first alternate key.
I do not think that
On 04/07/12 19:59, Rick Nuckolls wrote:
I believe PiOpen used a directory with two files in it ‘$0’ and ‘$1’
corresponding to DATA.30 and OVER.30. If the numbers went up from there, I
think that they corresponded to alternate keys, ie ‘$2’ and ‘$3’
represented DATA.30 and OVER.30 for the
On 04/07/12 17:44, Charles Stevenson wrote:
SMAT -d (or ANALYZE.SHM -d) see uv/bin/smat[.exe]
uv/bin/analyze.shm[.exe]
Dynamic Files:
Slot # Inode Device Ref Count Htype Split Merge Curmod Basemod
Largerec Filesp Selects Nextsplit
0 1285128087 209307792516
NN4 6DB, England
+44 (0)1604-709200
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin
Sent: 02 July 2012 20:22
To: u2-users@listserver.u2ug.org
Subject: [U2] RESIZE - dynamic files
I
above I'm just trying to get an idea of what these should be
set at.
Thanks,
Chris
From: cjausti...@hotmail.com
To: u2-users@listserver.u2ug.org
Date: Tue, 3 Jul 2012 10:28:17 -0500
Subject: Re: [U2] RESIZE - dynamic files
Doug,
When I do the math I come up with a different # (see
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
to be bigger than the number of groups (92,776
in this case)?
Chris
Date: Tue, 3 Jul 2012 11:04:53 -0600
From: dave...@gmail.com
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] RESIZE - dynamic files
Yep, I added an extra 2 in the key value. Oh, the perils of cut and
paste
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?
(~ 13 vs ~ 7 ), and a little slower keyed access.
-Rick
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin
Sent: Tuesday, July 03, 2012 9:48 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] RESIZE
: Tue, 3 Jul 2012 10:21:16 -0700
Subject: 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
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
records.
Chris
From: r...@lynden.com
To: u2-users@listserver.u2ug.org
Date: Tue, 3 Jul 2012 10:21:16 -0700
Subject: 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
.
Chris
From: r...@lynden.com
To: u2-users@listserver.u2ug.org
Date: Tue, 3 Jul 2012 10:21:16 -0700
Subject: 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
@listserver.u2ug.org
Subject: 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
of record IDs ... 21508521 bytes
Unused space ... 213343528 bytes
Total space for records 522252288 bytes
From: r...@lynden.com
To: u2-users@listserver.u2ug.org
Date: Tue, 3 Jul 2012 13:10:43 -0700
Subject: Re: [U2] RESIZE - dynamic files
The split load is not affecting
: r...@lynden.com
To: u2-users@listserver.u2ug.org
Date: Tue, 3 Jul 2012 13:10:43 -0700
Subject: 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
group, not
unreasonably shallow, and it's likely to be a while before you have to resize
again.
From: cjausti...@hotmail.com
To: u2-users@listserver.u2ug.org
Date: Tue, 3 Jul 2012 15:23:23 -0500
Subject: Re: [U2] RESIZE - dynamic files
I guess what I need to know is what's
...@hotmail.com
To: u2-users@listserver.u2ug.org
Date: Tue, 3 Jul 2012 16:57:34 -0400
Subject: 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
Austin
Sent: Tuesday, July 03, 2012 2:15 PM
To: u2-users@listserver.u2ug.org
Subject: 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
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
Austin
Sent: Tuesday, July 03, 2012 2:15 PM
To: u2-users@listserver.u2ug.org
Subject: 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
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
, 2012 2:38 PM
To: u2-users@listserver.u2ug.org
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
, Inc.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin
Sent: 07/03/2012 5:38 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] RESIZE - dynamic files
This is why I'm confused.. Is the goal here to reduce
the split.load? What should my SPLIT.LOAD be around,
and how do you come up with that %?
Chris
From: r...@lynden.com
To: u2-users@listserver.u2ug.org
Date: Tue, 3 Jul 2012 14:45:28 -0700
Subject: Re: [U2] RESIZE - dynamic files
37% is a very low load. Reading disk records takes much longer than
To: u2-users@listserver.u2ug.org
Subject: 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
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
: [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
Better by Design!
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin
Sent: Wednesday, 4 July 2012 7:38 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] RESIZE - dynamic files
This is why I'm
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.
I was wondering if anyone had instructions on RESIZE with a dynamic file? For
example I have a file called 'TEST_FILE'
with the following:
01 ANALYZE.FILE TEST_FILE
File name .. TEST_FILE
Pathname ... TEST_FILE
File type .. DYNAMIC
File
I was wondering if anyone had instructions on RESIZE with a dynamic file? For
example I have a file called 'TEST_FILE'
with the following:
01 ANALYZE.FILE TEST_FILE
File name .. TEST_FILE
Pathname ... TEST_FILE
File type .. DYNAMIC
File
: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin
Sent: 02 July 2012 20:22
To: u2-users@listserver.u2ug.org
Subject: [U2] RESIZE - dynamic files
I was wondering if anyone had instructions on RESIZE with a dynamic file? For
example I
of record IDs ... 19283300 bytes
Unused space ... 171626404 bytes
Total space for records 449597440 bytes
Thanks,
Chris
From: cjausti...@hotmail.com
To: u2-users@listserver.u2ug.org
Date: Mon, 2 Jul 2012 14:55:21 -0500
Subject: [U2] RESIZE - dynamic files
I
@listserver.u2ug.org
Date: Mon, 2 Jul 2012 14:55:21 -0500
Subject: [U2] RESIZE - dynamic files
I was wondering if anyone had instructions on RESIZE with a dynamic file? For
example I have a file called 'TEST_FILE'
with the following:
01 ANALYZE.FILE TEST_FILE
File name
tuning a dynamic file?
Chris
From: martinphill...@ladybridge.com
To: u2-users@listserver.u2ug.org
Date: Mon, 2 Jul 2012 20:56:40 +0100
Subject: Re: [U2] RESIZE - dynamic files
Hi Chris,
The whole point of dynamic files is that you don't do RESIZE. The file will
look after itself
Hi Chris:
You cannot get away with not resizing dynamic files in my experience. The
files do not split and merge like we are led to believe. The separator is
not used on dynamic files. Your Universe file is badly sized. The math
below will get you reasonably file size.
Let's do the math:
...@listserver.u2ug.org] On Behalf Of Chris Austin
Sent: Monday, July 02, 2012 2:07 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] RESIZE - dynamic files
The dynamic file I'm working with is below. What do 'overflowed' and 'badly'
refer to under MODULUS? Is the goal of the RESIZE to eliminate
In message 000501caa516$38b303c0$aa190b...@com, Andrew E. Tegenkamp
and...@g3.com writes
Thanks again for taking the time to help me out. I have been researching
this all day as I did not want to bother the list anymore. I am still
looking up and reading commands to try to find the right
of dictionaries used.
Jerry Banker
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach
Sent: Wednesday, February 03, 2010 2:57 AM
To: 'U2 Users List'
Subject: Re: [U2] Resize Question
Hi Andrew
Because UniVerse
We have a process that works strictly with I D type dictionary items.
The fewer I-types we have the better.
One scenario where we can drop I-types in favour of D-Types is :
DATA.VALUE
D multi part '*' delimited : date / time
2
...
DATA.VALUE.DATE
Before you go too far down that path, make sure your sorting selecting
works like you want.
Are you more familiar with Pick-style A- S-items? If so, you realize
how, if you put a correlative or a conversion into the wrong spot, your
sorts and selection criteria are goofy. The same will
,
www.brianleach.co.uk.
[/AD]
Regards
Brian
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Andrew E.
Tegenkamp
Sent: 02 February 2010 4:17 PM
To: 'U2 Users List'
Subject: Re: [U2] Resize Question
Thank you very much! That has
Sent: Wednesday, February 03, 2010 3:57 AM
To: 'U2 Users List'
Subject: Re: [U2] Resize Question
Hi Andrew
Because UniVerse dictionaries contain not only solid column definitions, but
also synonyms and virtual fields, you have to choose which of these will be
exposed for ODBC or similar relational
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Andrew E.
Tegenkamp
Sent: Wednesday, February 03, 2010 4:17 PM
To: 'U2 Users List'
Subject: Re: [U2] Resize Question
Thanks again for taking the time to help me out. I have been researching
this all day as I did not want to bother the list
...@listserver.u2ug.org] On Behalf Of Brian Leach
Sent: Monday, February 01, 2010 11:55 AM
To: 'U2 Users List'
Subject: Re: [U2] Resize Question
Okay, a few things here...
First the index issue. When UniVerse creates an index on a file, it puts the
absolute pathname to the index into the file header. You
I'd like to preface this by saying I am a UniVerse newbie.
Ideally, I am trying to import some data into a personal edition UniVerse
database but I am having some trouble. One example is a ZIP code lookup
called ZIP.
First, I copied the files in from a UNIX system to a Windows install of
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Andrew E.
Tegenkamp
Sent: 01 February 2010 4:15 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Resize Question
I'd like to preface this by saying I am a UniVerse
@listserver.u2ug.org
Subject: [U2] Resize Question
I'd like to preface this by saying I am a UniVerse newbie.
Ideally, I am trying to import some data into a personal edition UniVerse
database but I am having some trouble. One example is a ZIP code lookup
called ZIP.
First, I copied the files in from a UNIX
Hi All
I am trying to resize a large dynamic Unidata file for a customer but am
struggling to determine the best modulo/seperation figures to use. I
was under the impression that I should try and minimise the amount of
overflow files but my latest attempt just seems to have made the file
worse.
Try the HASH.HELP command (and related commands)
--B
-Original Message-
From: owner-u2-us...@listserver.u2ug.org
[mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Andrew Nicholls
Sent: Thursday, May 28, 2009 6:17 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Resize of large
Subject: [U2] Resize of large dynamic file
Hi All
I am trying to resize a large dynamic Unidata file for a customer but am
struggling to determine the best modulo/seperation figures to use. I
was under the impression that I should try and minimise the amount of
overflow files but my latest
Hi all,
UV 10 on HPUX
Can someone tell me how to resize the VOC?
Also, where do I go to search the archives?
Thanks and have a great weekend.
Scott
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Friday, May 04, 2007 11:38 AM
To: u2-Users
Subject: [U2] Resize VOC
Hi all,
UV 10 on HPUX
Can someone tell me how to resize the VOC?
I've never needed to do
with Universe.
Ron Sharcott (3635)
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: Friday, May 04, 2007 2:18 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Resize VOC
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf
,
Jeff Fitzgerald
Fitzgerald Long, Inc.
AD
Or you could use FAST! ;-)
/AD
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Friday, May 04, 2007 12:38 PM
To: u2-Users
Subject: [U2] Resize VOC
Hi all,
UV 10 on HPUX
Can someone tell
Of Ron Sharcott
Sent: 04 May 2007 22:31
To: 'u2-users@listserver.u2ug.org'
Subject: RE: [U2] Resize VOC
If I remember correctly the best way is to resize the VOC from a UNIX script
(assuming UNIX). When the script exits you should be able to start up
Unidata with no problem. If you are in UniData
I'm trying to RESIZE a file, but I'm getting a RESIZE error.
RESIZE: Error on [filename]. File not resized.
As a follow-up, an attempt was made to copy the content to a temporary
file, delete the old one, re-create it, and copy the content back, but the
system refuses to delete the old one due
@listserver.u2ug.org
Sent: Tuesday, April 24, 2007 11:56 AM
Subject: Spam:[U2] RESIZE Error
I'm trying to RESIZE a file, but I'm getting a RESIZE error.
RESIZE: Error on [filename]. File not resized.
As a follow-up, an attempt was made to copy the content to a temporary
file, delete the old one, re-create
Windows or Unix?
Universe or Unidata?
NFS mounted file system?
On Apr 24, 2007, at 9:56 AM, Baruch Salamander wrote:
I'm trying to RESIZE a file, but I'm getting a RESIZE error.
RESIZE: Error on [filename]. File not resized.
As a follow-up, an attempt was made to copy the content to a
There's a resize bit you can reset with filepeek.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jerry
Sent: Tuesday, April 24, 2007 1:31 PM
To: u2-users@listserver.u2ug.org
Subject: Re: Spam:[U2] RESIZE Error
If you were able to copy all of the records
Universe on Windows 2000
u2-users@listserver.u2ug.org writes:
Windows or Unix?
Universe or Unidata?
NFS mounted file system?
On Apr 24, 2007, at 9:56 AM, Baruch Salamander wrote:
I'm trying to RESIZE a file, but I'm getting a RESIZE error.
RESIZE: Error on [filename]. File not resized.
As
:[EMAIL PROTECTED] On Behalf Of Baruch Salamander
Sent: Tuesday, April 24, 2007 11:17 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] RESIZE Error
I'm trying to RESIZE a file, but I'm getting a RESIZE error.
RESIZE: Error on [filename]. File not resized.
As a follow-up, an attempt was made
Does anyone have any tech tips on how to select parameters when resizing
dynamic files ?
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
---
u2-users mailing list
To: u2-users@listserver.u2ug.org
Subject: [U2] RESIZE DYNAMIC FILES
Does anyone have any tech tips on how to select parameters when resizing
dynamic files ?
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http
[EMAIL PROTECTED] wrote on 06/12/2006 10:24:51 AM:
Does anyone have any tech tips on how to select parameters when
resizing dynamic files ?
The following is from a published tech tip. It provides guidelines, but
of course the nature of MV files makes it difficult to predict optimal
sizing.
1 - 100 of 108 matches
Mail list logo
