What about your Global Catalog, udtconfig, part table for dynamic
files, DICT.DICT if you have revised? Also if you copy your global catalog
from 6 to 6.1, you might want to copy your CTLGTB file into 6.1. Also the
INSTALLUDT might need to be run if you copy the GLOBAL catalog.
Thos are a
Over the weekend, I rebuild the indexes for our largest file for claim
details. This file has about 41 million records in it. The directory for the
dynamic file says it uses 35 gig of space. So it is a pretty good sized
file.
Prior to rebuilding the indexes, they were contained in 8 separate
We looked at a product called WIN.FAST. But it only got us about 90% where
we needed to be. They scan each row looking for specific characters to tell
them where headings begin and end, where input fields begin and end. So if
you have very consistent screen content and format, this might work for
Will there ever be a similar offering for Unidata? I struggle with
performance issues every day and would look forward any advice possible.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Clifton Oliver
Sent: Tuesday, December 27, 2005 11:45 PM
To:
Thanks for the link Wally. I will look through it.
Well, I have recently published another article that may be of interest to
you (Rod regarding RFS and deciphering sm.log messages. There is a link to
it on the U2 home page within developerWorks:
Is it a permissions problem?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Jeff Powell
Sent: Wednesday, January 04, 2006 8:31 AM
To: u2 users group
Subject: [U2] openseq question
Happy New Year.
I am having trouble with the openseq function in UniData.
We only DB Pause the system long enough to sync up a parallel copy of the
database on our SAN. The parallel copy then gets unmounted off the
production server. It is mounted on the backup up server and a tape backup
is done. You need enough disk for another copy of your production files. We
mount
We have had a similar circumstance and not gotten the space back until we
kicked all the users off.
I am on Solaris, not AIX.
I have a little UNIX script that I try and run before doing an 'rm' on a
file:
#!/bin/ksh
#getting names on fuser command
filename=$1
if [ $filename = ];then
Sure, you can use full paths in attribute 2 or 3 of Unidata VOCS. We make
extensive use of @UDTHOME on our dev box. We have a development env, Systems
and Acceptance, End To End and a training environment on the same server. We
have a UNIX shell script that prompts a logged in user which
Sorry late night. I did not see you want to do a LIST using the full path.
You do need a VOC pointer in Unidata. Even ecltype u says a direct reference
is not a file name
list /mccdata/mcc13/CLM.DETAIL
Not a filename :
/mccdata/mcc13/CLM.DETAIL
Sure, you can use full paths in attribute 2 or 3
Research @UDTHOME. We have 6 separate instances of Unidata environments on
one box. After a user logs in, a shell script asks them what environment
they want to go to. Then the shell script sets $UDTHOME at a UNIX level
before executing udt. The VOC pointers in each environment are identical
using
Do have one record that is humongous? We accidentally got a record out in a
file that was 9 meg and we blew shared memory trying to manipulate it.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of
[EMAIL PROTECTED]
Sent: Thursday, January 19, 2006 9:11 PM
To:
Macs have been Available on the Intel platform for about two weeks.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Claus Derlien
Sent: Monday, January 23, 2006 3:37 AM
To: u2-users@listserver.u2ug.org
Subject: SV: [U2] U2 and MAC
mac os x is based on bsd,
I would recommend keeping your files static right up to the point that they
hit 2 gig. A well sized static file will run faster and have less overhead
in my opinion. Also, if you do go the dynamic route, I would recommend
resizing them once a year as well.
-Original Message-
From: [EMAIL
Here is one we get when some one does not correctly code a program running
as a Phantom:
at line 528 illegal terminal input request for background job
PHANTOM process 27830 has completed.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Horn, John
Sent:
We would run out of disk space if we did not clean this stuff up. We have a
UNIX file system just for SAVEDLISTS, _PH_ and _HOLD_ items. That way if the
file system does fill up, it will not cause file corruption on Unidata
files. We run a UNIX 'find /mccdata/spool -mtime +15 -exec rm {}\;'. So we
How about the SETENV verb.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Ron Sharcott
Sent: Thursday, March 30, 2006 3:33 PM
To: 'Stewart Leicester'; 'U2Users'
Subject: RE: [U2] Shell Escape
To answer point #1
This is true except if the script is
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Baakkonen,
Rodney A (Rod) 46K
Sent: Friday, 31 March 2006 9:01 AM
To: 'Ron Sharcott'; 'Stewart Leicester'; 'U2Users'
Subject: RE: [U2] Shell Escape
How about the SETENV verb.
---
u2-users mailing list
u2
Did you get this via ftp? Are you sure the ftp was in binary mode?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Glen Batchelor
Sent: Thursday, April 20, 2006 9:09 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] gunzip
Looks like a corrupted file.
How about some other hashing algorithms like Universe has. I have some files
that have compound keys, where the separator is a '#' and the hashing is
awful. This is what GROUP.STAT looks like:
File = AUTHORIZATION modulo=529314 hash type=0 blocksize=16384
Split/Merge type = KEYDATA
Grp# Bytes
data into the other
groups? From the sample, it looks as if your groups with data are
not overflowing and consequently, the file may be oversized.
Of course I am not looking at the entire stats so I could be off base.
At 09:07 AM 5/11/2006, Baakkonen, Rodney A (Rod) 46K wrote:
How about
to poor hashing, but I would recommend the first step to be
resizing, and resetting the minimum.modulo to the same size as the resize
modulo.
HTH
---
Regards,
Robert
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Baakkonen, Rodney A
(Rod) 46K
Sent
If you are on UNIX, you could PCPERFORM who -u and grep for the login of who
ever you are searching for.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Craig Peterson
Sent: Tuesday, June 06, 2006 1:43 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] client
What does sar say about your wait i/o? On Solaris, I use sar -u.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of
[EMAIL PROTECTED]
Sent: Wednesday, June 07, 2006 3:07 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] UniData performance problems
We have
cut -d/ -f7
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Stevenson,
Charles
Sent: Friday, July 14, 2006 3:07 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] unix equivalent of FNAME = FIELD( PATH, '/', DCOUNT(PATH,
'/' )
A Quick Friday afternoon
I am not sure if I agree with the term 'dumped'. The former owners bought
the company back and it flourished again in my opinion. But as former
employee, you can take that for what it is worth.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Debster
Sent:
Try using NO.INDEX and see if you get the results you are looking for. If
that is the case, you need to rebuild the index. Have you had any system
crashes lately?
select ORDERS NO.INDEX WITH CUST.NO = '12345' AND WITH INV.DATE =
'12/14/05'
-Original Message-
From: [EMAIL PROTECTED]
We run both our production and our development off Sun Sparc Boxes. It is
the 32 bit implementation of the OS:
SunOS 5.9 Generic_118558-09 sun4u sparc SUNW,Sun-Fire-880
We have been on Solaris for about 4 years and currently are on Unidata
7.1.0.
-Original Message-
From: [EMAIL
When running in Visual mode, what is the last program statement you see
before the blowup?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Brenda Price
Sent: Thursday, September 14, 2006 12:13 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Debugging a
I have had some good experiences with KEYDATA. But I think KEYDATA will use
slightly more disk space.
The only time I had problems with KEYDATA was when the keys to the file did not
hash well (meaningful keys with a '#' separator followed by a 2 digit number).
If you have sequential keys, this
Where do you have TMP pointing to? There is a default for TMP in udtconfig. In
UNIX the default can be overridden by setting the environment variable TMP.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of David Wolverton
Sent: Monday, October 23, 2006 3:06
I wrote a 'cron' that running a Unibasic program that wakes up every 5 minutes
and does a 'sbcsprogs' The program parses up the 'sbcsprogs' output updates a
Unidata file to keep track of program usage. But if something runs really fast,
I have a chance of never catching it in the shared basic
You could do a ping server and see if it is alive.
We also do a post ftp process after we 'put' a file on another server. We go
back to the other server via ftp and do a 'dir' on the directory looking for
the file so we can capture the size to make sure the whole thing made it. That
all gets
We have taken to using work files on Unidata rather than dynamic arrays.
Whatever you are doing the locate on to build the array becomes the key to the
work file. We cut processing time on some of our large programs from days to
hours switching from dynamic arrays to well sized work files.
On Unidata, I saw a Unibasic tips write up from long ago. It said concatenation
was faster than using a -1 to build an array. The speed came from the fact
that Unidata knew where the end of a variable was. So using concatenate, the
process could jump to the end of the variable to add an element
Just to add one more possible complication to your scenario. Depending on the
software or the UNIX admin people, you may need to worry about symbolic links
at a UNIX level.
For example, lets say you are in Unidata in the directory /usr/ud/ROD. In the
VOC for this directory is a file called
Don't forget to use the -r option so that it builds a database of your guide
statistics. Then you can run uniquery reports off the stats.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Susan Joslyn
Sent: Tuesday, March 13, 2007 1:25 PM
To:
You could put an IF @LOGNAME = and fix it in the LOGIN Paragraph for yourself.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Arnold Bosch
Sent: Thursday, March 15, 2007 4:56 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Upper Case and Editors
If you were going to cover all the possible bases, you would need to do the:
1. VOC
2. OPEN 'CTLG' and read that. This covers 'LOCAL' catalogs
3. CREATE a temporary VOC entry where
att1 is 'DIR'
att2 is @UDTHOME/sys/CTLG/(first letter of program name)
OPEN this file and read using program
Can you tell me where the UOLOGIN documentation is? I search the Unidata
manuals for 7.1 and can't find any reference. - Thanks Rod
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of
[EMAIL PROTECTED]
Sent: Wednesday, April 11, 2007 4:51 AM
To:
MERGE.LIST has a UNION option.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Burwell, Ed
Sent: Wednesday, May 16, 2007 9:09 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] [UD] Union Query
Has anyone developed or know of a way to do the equivalent of a
I did get Crtl-C to work. But it took some experimenting. So I am not sure that
I know all the steps that I did to get it working. I gave someone else the
settings that I had and they say it still does not work. The setting that
finally allowed me to use Crtl-C was to go into Setup, Keyboard
Maybe some UNIX guru has a more elegant way than this. I do a lot of shell
scripting. So the easiest way to do this was with a script. I am using korn
shell for this. Most U2 people I know avoid shell scripts.
I wrote a quick somewhat generic script to do it called rod.test. You give it
the
We have a dynamic file that is 65 gig. I would recommend that you invest some
time experimenting with split/merge params and even possibly KEYDATA to see
what works best with your file.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Jonathan Leckie
Sent:
KEYONLY would not work for us for the most part. We have File Keys that
were 10-15 characters. Our record sizes would be 300-800. So we would never get
enough Keys in a group to cause splitting. KEYDATA works fine in 90% of our
files. But we have files that have meaningful keys that do
I think you can use INDEX or FIELD or EXTRACT. I don't know that I have ever
seen LOCATE.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Doug Farmer
Sent: Thursday, August 09, 2007 1:44 PM
To: u2-users@listserver.u2ug.org
Cc: Vicki Gabler
Subject: [U2]
Does this work for Unidata also? Does it have the same name? - Rod
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Sara Burns
Sent: Tuesday, August 21, 2007 4:26 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Sacred Licence Seat - A Challenge
4) To
I usually us the 'find' command with the '-mtime' to pare down the list of
files in the directory that I am dealing with. For Instance, if I wanted to
look at all files over 30 days, I would:
(I am assuming that I have do a 'cd' to the directory. Otherwise the '.' in the
command needs to be a
Why don't you just put in a 'DIR' type file, or a number of DIR types if there
will be a lot of files in there?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Dave Davis
Sent: Tuesday, August 21, 2007 12:59 PM
To: u2-users@listserver.u2ug.org
Subject: RE:
We have also seen this situation where the machine almost goes into a panic
when the NFS mounts don't respond. I think we made the problem less severe with
a Solaris mount option. These are the options I currently see when I look at
our NFS mount on our production box. The 'soft' option may be
I am glad to hear someone using replication and having a success story. Is
anybody using it on UNIX?
The only site I know of that tried it on UNIX did not have enough horsepower on
subscribing side and had stop using it.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL
We have a UNIX script that does a 'wall' warning people that they will be
logged off in
6 minutes
and 2 minutes
If they are not off:
/usr/ud/bin/listuser | egrep 'udt|phantom|unijdbc' | awk '{print deleteuser
$2 }' | ksh
and they usually are gone. Sometimes on Solaris, the UNIX Pid will
We are on UNIX, but this gives you an idea of what we do. We
have a 'cron' that looks at the date/time stamp on files at a Unix level
(UNIX 'find' command using -mtime -1). If the file was updated in the
last 24 hours, then we have a Unidata program go through and figure out
if the file is
That is why we discourage developers from using dynamic arrays in
programs. Once they get to a certain size, performance goes out the
window. We have them store all intermediate program data in work files
that sort quickly when well sized.
-Original Message-
From: [EMAIL PROTECTED]
I guess my point was a little off topic, as I was really calling
attention to performance issues with dynamic arrays in general and not
about sorting keys. When dynamic arrays can out perform work files, we
will use them.
We have seen processes that used dynamic arrays run for a week. Even
with
If you have UNIX accounting on the machine, the 'last' command may
provide some help. Otherwise I think it will have to come from something
written into you Unidata applications.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Lunt, Bruce
Sent:
I am still at 7.1.0. When I have had this GET.LIST problem, I think I
was able to get the list using QSELECT SAVEDLISTS. I have never had the
SAVE.LIST fail, just the GET.LIST.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Wally Terhune
Sent: Tuesday,
Is this Unidata or Universe? In Unidata, when using the Unidata ECL, I
could use SAVING SWITCHIT
-Original Message-
From: owner-u2-us...@listserver.u2ug.org
[mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Wednesday, April 01, 2009 4:21 PM
To:
We have been pulling data nightly from Unidata using Datastage and
moving it over to Oracle for at least 10 years.
-Original Message-
From: owner-u2-us...@listserver.u2ug.org
[mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Dawn Wolthuis
Sent: Tuesday, April 14, 2009 8:17 AM
To:
they migrate it to something else? --dawn
On Tue, Apr 14, 2009 at 9:24 AM, Baakkonen, Rodney A (Rod) 46K
rodney.baakko...@cigna.com wrote:
We have been pulling data nightly from Unidata using Datastage and
moving it over to Oracle for at least 10 years.
-Original Message-
From: owner-u2
There should be a rszx (where xx is some temp file unique
Unidata name) file in whatever directory you have defined for TMP (if
this is UNIX, do !echo $TMP) that should be the file after it was
resized. I am guessing that the memresize got interrupted right at the
point where Unidata was
We just had one of these where a Dim array was getting filled with data
and that caused shared memory to blow. IT was stuffing an entire record
in the array and doing it for the same key over and over. As a quick
fix, we put a LOCATE in to see if the record was already in the array
and that fixed
We too do not use memresize to rebuild dynamic files. We have a process
that select the original file, breaks the subsequent list up into parts
and have phantom simultaneously copy records into the new file based on
the portion of the original list that that an individual phantom is
given. We have
Do you have truss or a trace command at UNIX that can track what the
PID is doing. It is pretty low level stuff, but if it is doing any file
IO, you can see that and maybe see what is going on.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
When you have a file with 50 million records, it does not matter how
you build the or parse the dynamic array. A well sized work file will
run circles around the dynamic array.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org]
and then create the report / do the processing all within the same loop?
Ed
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Baakkonen,
Rodney A (Rod) 46K
Sent: 08 July 2009 12:30
To: U2 Users List
Subject: Re: [U2] General
We used to us the DIM approach as well. But having the process blow up
a couple of years later because the DIM array was not large enough to
accommodate the data caused us to go the work file method. The DIM array
was fast, but needed to much upkeep. And after Sarbanes-Oxley, making
changes to
I think Oracle's indexing scheme is much more complicated that
Unidata's, so I don't think you can compare the two. I do rebuild some
of the dynamic files on occasion to get some space back. Other than
that, I leave them alone and haven't had problems. - Rod
-Original Message-
From:
I usually do a TERM 132,999
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of
bradley.sch...@usbank.com
Sent: Thursday, July 16, 2009 3:19 PM
To: U2 Users List
Subject: Re: [U2] More questions on indexing
Thanks,
with 10 indexes and you want to rebuild it. -Rod
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Baakkonen,
Rodney A (Rod) 46K
Sent: Thursday, July 16, 2009 3:25 PM
To: U2 Users List
Subject: Re: [U2] More questions
Try SWAP instead of CONVERT.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Hester
Sent: Wednesday, September 16, 2009 6:28 PM
To: U2 Users List
Subject: [U2] Null character causes odd UV behaviour
I'm just
2009
Subject: Re: [U2] Null character causes odd UV behaviour
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Baakkonen,
Rodney A (Rod) 46K
Sent: Wednesday, September 16, 2009 5:16 PM
To: U2 Users List
Subject
If you are on UNIX, you could use a UNIX shell script to 'cd' to the
account before doing the 'udt PHANTOM'
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King
Sent: Tuesday, September 22, 2009 10:08 AM
To:
We have successfully used this approach several times to find out what
program was causing the problem. We used the call stack and also some
info in our named commons to write to a debug file that we created for
this process. We used to use dummy indexes to debug this type of
problem. But
I would tar up the files, zip them and ftp them
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Barber,
Bonnie
Sent: Friday, November 20, 2009 10:37 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] uucp
Hi
Do you do a dbpause at all during this snapshot process?
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Porter
Sent: Wednesday, April 28, 2010 1:09 PM
To: U2 Users List
Subject: Re: [U2] Universe and
Is AIX ebcdic? I use dd to convert files from ebcdic to ascii. Are they
sending you packed data? I used to have to read the records using
OSBREAD and then do an OCONV to unpack them.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
Try /usr/bin/strings
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Roy Beard
Sent: Tuesday, November 09, 2010 4:23 PM
To: 'U2 Users List'
Subject: Re: [U2] Reading a Unix file from another machine.
NO joy!
# cd
Check the size of the program when compiled with the -D. You may be blowing
some Shared Basic Code parameter in udtconfig.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R.
Sent: Monday, July 11,
DO the resize at Unix with the memresize command and you can specify where the
TMP space is. So you can use space from another file system during the resize.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Rainer
Are you looking for the profile in /etc that everyone is routed through on
Solaris. Or a specific user, which should be found by doing
grep userid /etc/passwd
And look in the 5th or 6th field separated by colons.
If it isn't either of those two, I'm not sure what you are looking for. - Rod
on Solaris and ManFact
I'm looking for the profile everyone is routed through.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Baakkonen, Rodney
A (Rod) 46K
Sent: Saturday, April 07, 2012 1:40 PM
To: 'U2 Users List
I resize most of my Dynamic files this way. I don't like having a small
overxxx segment for every datxxx segment that memresize creates.. By creating
the new file my self, I don't have a lot of these small overxxx segments that
are never used.
I also wrote a process to Select the old file and
-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Baakkonen,
Rodney A (Rod) 46K
Sent: Wednesday, April 25, 2012 12:29
To: 'Jonathan Leckie'; 'U2 Users List'
Subject: Re: [U2] Huge Dynamic Unidata file
I resize most of my Dynamic files this way
file
Out of interest, how big is this file and how many records ?
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Baakkonen, Rodney
A (Rod) 46K
Sent: 25 April 2012 21:30
To: 'U2 Users List'; jonathan.lec
Can't remember if this came from Wally or not a long time ago. But I use it to
figure out Split/Merge. I have a development box that has a copy of production
that I can play with. So I do a lot of playing with mod and sep and depend on
GROUP.STAT to give me some idea of how groups are being
Sorry I don't have time to really dive into this. A lot of the documentation
are things that work most of the time. But sizing dynamic files is more art
than science some times.
But just looking at your stats, KEYDATA might be an option as well. You have a
pretty high ratio of bytes per
Are you on Unix or Windows?
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of bpa...@serta.com
Sent: Friday, July 27, 2012 10:42 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Running a command in a different
It is taking some work to make it function in Unidata. But thanks for the
framework. -Rod
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Tuesday, September 04, 2012 1:06 PM
To:
Are you on UNIX by chance? The first couple of lines of listuser tell you:
# listuser | head
Licensed(UDT+CP)/Effective Udt Sql iPhtm Pooled Total
( 875 + 0 ) / 875 511 45 2 0 558
-Original Message-
From:
Have you used the Concurrent index build? The downside I have seen with that
is the speed. I have some files that are large and the concurrent index build
is very slow. So I only use the concurrent index build when I have small files.
I would guess you would see similar performance with the
We have some very large dynamic files. Some are over 100 gigabytes in size.
Too me it is weird that you have one dat portion and 45 overflow portions of
the file. My 100 gig file has 43 Dat portions and 1 overflow, which is what I
try to maintain. I want as few overflow portions of the file as
There are a lot of Universe features I Would like to see in Unidata.
Distributed files and all the hashing algorithms would be a nice start.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Friday,
Something is radically wrong here. You only have 44K records in the file with
3277 groups.
See if you can run a guide with the -d3 option and also show us the first page
of the GROUP.STAT command.
From ECL, do a GROUP.STAT UI.LOG.INFO and do a !guide -d3 UI.LOG.INFO.
The guide will build 3
What we did was have a cron run every 10 minutes that executed a Unidata
program. The Unidata program did a PCPERFORM sbcsprogs to capture everything
that was running out of the global catalog. It parses up the output of
sbcsprogs and builds a Unidata file. This file has the program name as
We create a lot of delimited flat files at a Unix level. Then we ftp them to
the windows side of the network. The ftp process generates an email to the user
with a link to the file we just put on the LAN. The users can then open it up
using the email link in Excel and do what they want.
What ECl type are you using. If you are using 'P' instead of 'U', use the
lowercase verb and it should work
select FILE1 TO 1
select FILE2 TO 2
MERGE.LIST 1 INTERSECT 2 TO 3
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org]
97 matches
Mail list logo
