It's probably AIX that's doing the caching. If it's like linux, there's no way
to tell it - it will just aggressively cache everything until it runs out of
spare RAM.
Question is, why do you want these files in RAM? UV is very fast at retrieving
from disk so what's the reason?
And it sounds
I think you are referring to the Memory files in Information. We experimented
with them, briefly, and them returned to using good old disk files.
From: [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Date: Thu, 23 Oct 2008 09:21:40 +0100
Subject: RE: [U2] UniVerse and/or AIX caching
We have just run into a problem with D3. It is 32bit and can only access
files 2gig and smaller.
Now I understand that this is a very large file BUT ... sometimes you have
to do what you have to do.
In looking at the Universe site it looks as if it too is only 32bit.
1) is
We have some data transfer processes that take about 9 hours, loading data
from our production computer to UniVerse databases used for data analysis.
We'd like to speed that up, and have used ramdisk for some improvements,
but not enough.
Also the time taken to display huge sets of data takes too
I am not sure what you mean when you say ...D3 can only access files 2gig
and smaller?
Certainly, there is no 2gb limit on D3 files themselves (I have many
instances of D3 files with modulos in excess of 1 million). Are you saying
that you can't read native OS files from inside D3 when those
You might want to look at the solid state drives (aka MFT) from Doug
Dumitru at EasyCo (easyco.com).
/Scott Ballinger
Pareto Corporation
Edmonds WA USA
206 713 6006
On Thu, Oct 23, 2008 at 10:57 AM, Louie Bergsagel
[EMAIL PROTECTED]wrote:
We have some data transfer processes that take about 9
Is there a way to do PHP with UniVerse?
I just found out that there is a way to do Adobe Flex with PHP. Thus,
perhaps it is possible to do Flex - PHP - UV.
Suggestions would be appreciated.
--Bill
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit
I believe someone has a php library that uses the intercall libraries, it
has been discussed on here, and there is actually a white paper on it on the
ibm web site.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill
Sent: 23 October 2008 21:03
There are several ways to do this. Check out PickWiki:
http://www.pickwiki.com/cgi-bin/wiki.pl?Accessing_U2_From_PHP
Brutzman, Bill wrote:
Is there a way to do PHP with UniVerse?
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit
Well... I rolled my own some years back (still in use today to give MD's and
RN's on the floor access to specimen collection information).
It wasn't easy, but it works well. Basically the use of pipes, a phantom on
the UV side, and I built a collection of PHP routines to deal with
multi-valued
There is a series articles written by IBM U2 Engineers in the IBM U2
DeveloperWorks website on that topic.
Google it or find it via the mainpage:
http://www.ibm.com/developerworks/db2/products/u2/
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Hi David,
I'm not quite sure why I would want to read/write a sequential file over 2Gb
but, given that this originated as a D3 comment and has found its way on to
the U2 site, let me just add that QM can handle sequential files over 2Gb.
The argument used by UV is that because integer values
But ... a quick google...
http://www.ibm.com/developerworks/db2/library/techarticle/dm-0701xia/index.html
U2 PDO Driver, Part 2: Write PHP applications to access U2 data
Brutzman, Bill [EMAIL PROTECTED] 10/23/2008 3:03 PM
Is there a way to do PHP with UniVerse?
I just found out that there
If I have a NFS mounted directory (on a third non-UV system) which houses a UV
format file.
I have (2) linux system that have that directory mounted, which each have UV
that have a VOC pointer to that file. 1F , 2 /mnt/directory/filename ,
3 /mnt/directory/D_filename
Both UV systems can
What are the file stats for this UV file? Just curious.
I guess of you want a high-end SSD then you need to look at a device
supported on AIX and you probably fibre-channel I/O too. Check out this
webpage: http://www.storagesearch.com/ssd-fc.html
Note the comments made on this page:
quote
We run on Unidata 7.x on both Windows, HP/UX and AIX
We use FX pointers and NFA to read and write to files on two physically
separate systems.
Nicholas M Gettino | Director of Development | EnRoute Emergency
Systems, an Infor company | office: 813-207-6998 | fax: 678-393-5389
[EMAIL PROTECTED] |
As I mentioned in CDP, this has nothing to do with D3 but it's
always fun to blame D3 for whatever ails ya. David is using the
%functions from BASIC which are wrappers around raw C functions.
The limitations of these functions are that of the OS, not the
DBMS wrappers. A quick Google for fopen
Several files, but these are representative:
ANALYZE.FILE ALPHA (reads writes)
File name .. ALPHA
Pathname ... ALPHA
File type .. DYNAMIC
Hashing Algorithm .. GENERAL
No. of groups (modulus) 545607 current ( minimum 337 )
Thanks Louis
It would probably take hours, but STATS option would be good... Do
they really need to be dynamic files? Is the data largely static? Does
it grow often? Can you separate non-current data and utilise distributed
files perhaps?
I'm guessing that the large dynamic files are largely
Actually, if you look at the minimum mod of the dynamic files, you'll see that
they've grown from, for example, 337 groups to 545,607, so it's likely that
they're not empty at all. Splits are a very expensive operation. You can speed
these files up a little by oversizing them, but I'd be surprised
20 matches
Mail list logo
