Re: [U2] [JOB] in Garden Grove, CA

2014-03-15 Thread Dan Fitzgerald
Is this a list you're going to share, or are you looking for one-way communication? > On Mar 13, 2014, at 1:17 PM, "Wjhonson" wrote: > > > https://www.ziprecruiter.com/job/PICK-Programmer/2a00262a/?source=cpc-simplyhired > > If anyone finds out who this company is, could you please let me kno

Re: [U2] [OT] Interview Questions

2013-12-14 Thread Dan Fitzgerald
First, agreeing with Kevin. I've been amazed over the years at how many folks represent that they have technical skills that they don't. But, I got a good non-technical question recently: Describe a situation where you argued strongly for a position and ended up changing your mind. I had a weal

Re: [U2] File type 30 (dynamic)

2013-07-09 Thread Dan Fitzgerald
Once you start splitting groups, there's overhead on every write where that occurs, possibly creating a bottleneck. Dynamic files are good for files with non-consistent item sizes, and also for files with oversized items, but that's not the case here. I'd go with a "wide & shallow" static file f

Re: [U2] SAN?

2013-07-02 Thread Dan Fitzgerald
Universe tends to make it's IO requests in 4K blocks, so you may want to make sure you're not sharing spindles with things like sharepoint, where a typical disk read request is more like 500K. You could end up with a 4K read waiting on something 100 times larger as a regular thing. In AIX, it's

Re: [U2] command not found

2013-02-14 Thread Dan Fitzgerald
Or use the entire path to guide instead of just "guide". > From: rfrai...@utahmed.com > To: u2-users@listserver.u2ug.org > Date: Thu, 14 Feb 2013 15:48:09 -0700 > Subject: Re: [U2] command not found > > login to ecl sets path variables, root may not. > Have them login and go to ecl > issue a "su"

Re: [U2] : Evaluating DCOUNT

2013-02-12 Thread Dan Fitzgerald
I don't know if the old list archives are available, but iirc, either Glen Herbert or Mark Baldridge posted a pretty detailed description of how it works, focusing on the RAISE function. > From: tewhitm...@ratex.com > To: u2-users@listserver.u2ug.org > Date: Tue, 12 Feb 2013 16:46:20 -0500 > S

Re: [U2] [UV] Large File Operations Kill Linux

2013-02-04 Thread Dan Fitzgerald
2.6.8.1... > Date: Mon, 4 Feb 2013 21:15:25 + > From: antli...@youngman.org.uk > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] [UV] Large File Operations Kill Linux > > On 04/02/13 21:05, Dan Fitzgerald wrote: > > > > What's the value in /proc/sys/v

Re: [U2] [UV] Large File Operations Kill Linux

2013-02-04 Thread Dan Fitzgerald
What's the value in /proc/sys/vm/swappiness? > From: perry.tay...@zirmed.com > To: u2-users@listserver.u2ug.org > Date: Mon, 4 Feb 2013 20:53:13 + > Subject: Re: [U2] [UV] Large File Operations Kill Linux > > We're on RHEL5 (2.6.18-348.el5), ext3 and 132GB ram. > > -Original Message---

Re: [U2] [UD] Disabling/blocking ODBC

2013-01-25 Thread Dan Fitzgerald
You could take out the path(s) to the Unidata accounts in the UCI file; I don't know if that would affect datastage, but it might be worth checking. > Date: Fri, 25 Jan 2013 11:40:42 -0700 > From: jscha...@gmail.com > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] [UD] Disabling/blocking

Re: [U2] Unidata 6.1.13/AIX 5.3 Stops Unexpectedly

2013-01-16 Thread Dan Fitzgerald
I'd download nmon & have it running in 5 minute increments, then look at it in the morning. I'd also look at errpt to see if it's logging any errors. > Date: Wed, 16 Jan 2013 11:09:19 -0800 > From: bob_woodw...@k2sports.com > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] Unidata 6.1.13/AIX

Re: [U2] UV Job Listing

2012-10-06 Thread Dan Fitzgerald
Subject: Re: [U2] UV Job Listing > > On 10/6/2012 12:33 PM, Dan Fitzgerald wrote: > > > > I spotted this one on Dice.com, for an IT Manager at a UniVerse shop, > > > And embedded within it was "Project management, organizations and > prioritizing skulls "

[U2] UV Job Listing

2012-10-06 Thread Dan Fitzgerald
I spotted this one on Dice.com, for an IT Manager at a UniVerse shop, thought I'd share. If you get it, feel free to express your gratitude by bringing me in to do a Health Check; I'm local. http://seeker.dice.com/jobsearch/servlet/JobSearch?op=302&dockey=xml/4/6/46fcd37446205e56fb6fa84d44ce4763

Re: [U2] Mysterious UV Error

2012-08-17 Thread Dan Fitzgerald
I'd use the truss command as root from AIX. Open a new window as root (sudo is fine), then determine the pid of the sh at the other window (ps will give you that). issue a truss -pf from the root window (the "f" will follow all of the forks), and watch as truss reports every system call made

Re: [U2] RESIZE - dynamic files

2012-07-03 Thread Dan Fitzgerald
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

Re: [U2] RESIZE - dynamic files

2012-07-02 Thread Dan Fitzgerald
Group size appears adequate (although anytime anything hashes into the group(s) with the largest record [3267b], you'll split: 3267 is 79.8% of 4096, so if you have a lot of records up in the 3K range, you may want to increase group size and decrease min modulus accordingly), but the minimum mo

Re: [U2] READU vs READ

2012-04-30 Thread Dan Fitzgerald
Well, that'll affect performance somewhat. If you're splitting on a high percentage of writes, that's a lot of expensive overhead. You also (unless someone changed it in the past couple of years) have to lock the header of the file when you do a split. But at least you're not following overflow

Re: [U2] READU vs READ

2012-04-30 Thread Dan Fitzgerald
By "Sizable", are you talking 10k, 50k, 100k, larger? The Seperation would become a huge factor, then. Mark Baldridge wrote some great stuff about Sep in "The Hitchhiker's Guide to the UniVerse" series a few years back. You wouldn't happen to be on AIX, would you? If so, as root, you could do

Re: [U2] READU vs READ

2012-04-30 Thread Dan Fitzgerald
It'd be interesting to do a FILE.UGAGE ON, run the program, look at the stats, then do FILE.USAGE OFF. Another thing to look at is LIST.READU EVERY while the program is running. If there appears to be an issue there, increase the lock table sizing parameters in uvconfig. Troy is correct in ask

Re: [U2] Case Statement with only two cases

2012-04-20 Thread Dan Fitzgerald
Yeah, it's an interesting adjustment. For those of us who began coding on things like 8-bit 64Mhz 16Mb boxes, optimizing code was absolutely essential. Now, my desktop is a 4-core 2.8Ghz (you can get an 8 core I7 laptop for under $700), 8Gb of RAM 64 bit machine, and it's nearly obsolete. When

Re: [U2] Extract first and last name from free-form name

2011-12-14 Thread Dan Fitzgerald
That's pretty good. A few years back, Multnomah County (Portland), Oregon, added "Klingon" to the official list of interpreter services it would offer in the Mental Health department. > To: u2-users@listserver.u2ug.org > From: bradley.sch...@usbank.com > Date: Wed, 14 Dec 2011 02:57:28 -0

Re: [U2] HP UX to IBM AIX questions

2011-10-21 Thread Dan Fitzgerald
AIX handles memory in a very different manner than HP/UX. While you'll have less to deal with, the parameters you do need to tune are different, and in a few crucial instances, the default is a bad choice for a U2 installation. You'll also see that AIX uses ALL of its available memory to cache

Re: [U2] Universe File Issue

2011-10-11 Thread Dan Fitzgerald
Actually, the distributed file option is a good one, if you can't go to 64 bits. You create a few files (say, 3), then build the file using DEFINE.DF. But in terms of recovering this file, not without losing some records, unless you get very lucky. You can use UV to copy the file, and when yo

Re: [U2] FAST (File Analysis and Sizing Tool)

2011-10-04 Thread Dan Fitzgerald
My issue with dynamic files is that once they start splitting, the overhead increases dramatically. This is why they do need to be maintained. If the argument for them is "we don't have to maintain them", you're mistaken. Granted, a terribly sized dynamic file will perform better than a terribl

Re: [U2] FAST (File Analysis and Sizing Tool)

2011-10-04 Thread Dan Fitzgerald
I absolutely recommend it (Oh - no relation, either familial or professional). Every time I do a UV health check, I recommend that the customer buy it and implement it. It does a great job, and - this is important - it gets you looking at file sizing & maintenance. Dan Fitzgerald &g

Re: [U2] Ardent programmers

2011-09-09 Thread Dan Fitzgerald
If he used a GOTO, he got off easy... > From: ggal...@wyanokegroup.com > To: u2-users@listserver.u2ug.org > Date: Fri, 9 Sep 2011 10:09:44 -0500 > Subject: Re: [U2] Ardent programmers > > He must have used a GOTO in his design however, and the punishment > Was quite severe at the time.. (b

Re: [U2] Red Hat Enterprise Linux 64 bit and Universe 11.1.4 - Experiences?

2011-09-02 Thread Dan Fitzgerald
software, then > > things get tricky. > > > > The best answer I found to that problem was this: > > > > http://pware.hvcc.edu/ > > > > But its maintained by a fellow at a college university, and if he ever gets > > sick of doing that... then I'm stu

Re: [U2] Red Hat Enterprise Linux 64 bit and Universe 11.1.4 - Experiences?

2011-09-01 Thread Dan Fitzgerald
I work with both RHEL & AIX, and I'm not sure that you save a whole bunch of money by going Linux anymore. I won't p0ut [AD/} in here, because I'm not a vendor, nor do I have a business relationship with one (anymore). But I was recently investigating making this same move, and my IBM vendor pr

Re: [U2] 5

2011-08-21 Thread Dan Fitzgerald
Hey, will - wanna take care of that? > To: tpelliti...@centuryequip.com; transfe...@yahoo.com; > u2-commun...@listserver.u2ug.org; u2servi...@rs.com; > u2-users@listserver.u2ug.org; u2-us...@oliver.com > From: fft2...@aol.com > Date: Sun, 21 Aug 2011 14:27:23 -0400 > Subject: Re: [U2] 5 > > V

Re: [U2] Job won't run

2011-08-05 Thread Dan Fitzgerald
And it _does_ get past the udt program; i.e., it actually sends the file, and updates the log? I'd look at lsuser for the id running the ud program, and the permissions on the program executable. I'd take a direct look at the user and program groups; maybe an admin somewhere changed the user'

Re: [U2] Doing Multiple Selects in BASIC and combining the lists

2011-07-27 Thread Dan Fitzgerald
I'm not sure I'd combine them; handle the data once. I'd readext through file1_list, then readnext through file2_list. ...and I'd probably use the basic select, making AMOUNT="112.50" my first filter. Again, then you only read the data once. (Exception: if the field is indexed, I'd go with a

Re: [U2] 2008 server and UNiverse Status command

2011-07-07 Thread Dan Fitzgerald
I agree with Bill; call it in. I couldn't resist noting that at least it gave you a definitive answer... . > Date: Thu, 7 Jul 2011 09:32:08 -0700 > From: wphask...@advantos.net > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] 2008 server and UNiverse Status command > > I don't think I'

Re: [U2] Universe 10.1.22 on AIX 5.3 ML 4

2011-06-20 Thread Dan Fitzgerald
OK, now I'm curious as to why you don't want to update AIX? > Date: Mon, 20 Jun 2011 08:26:01 +0100 > From: b...@explore.co.uk > To: u2-users@listserver.u2ug.org > Subject: [U2] Universe 10.1.22 on AIX 5.3 ML 4 > > I gave up trying to go to Universe 11 because its needs ML8 and we are > on ML4

Re: [U2] File Item Count Limit?

2011-06-03 Thread Dan Fitzgerald
Actually, at 64b, the limit is slightly over 9 petabytes. I think that so far this is theoretical; I'm guessing that nobody yet has put together a disk array of 9 petabytes and created one large file... 2 raised to the (32-1) power is 2,147,483,648 2 raised to the (64-1) power is 9,223,373,

Re: [U2] Universe PE

2011-05-25 Thread Dan Fitzgerald
To clarify, it appears that this happens for the Linux PE. The Windoze PE downloads. > From: fft2...@aol.com > Date: Wed, 25 May 2011 13:56:34 -0400 > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] Universe PE > > I tried to again go to the download link for the Universe PE. It lets me

[U2] serial #

2011-05-07 Thread Dan Fitzgerald
Someone asked me the other day how they could determine their uv serial number. I didn't know, and can't find it when I RTFM on uvlictool. Anyone know? ___ U2-Users mailing list U2-Users@listserver.u2ug.org ht

Re: [U2] [UV] Purposefully Breaking a UniVerse File

2011-05-05 Thread Dan Fitzgerald
Edit it at the OS level, or start a copy & then break it (i.e., kill the process), then create a VOC item to point to the unfinished copy. > Date: Thu, 5 May 2011 11:52:28 -0400 > From: perry.tay...@zirmed.com > To: u2-users@listserver.u2ug.org > Subject: [U2] [UV] Purposefully Breaking a UniVe

Re: [U2] Hello ?

2011-05-02 Thread Dan Fitzgerald
I hear you. > Date: Mon, 2 May 2011 21:43:08 -0400 > From: simpson-u...@gerzio.ca > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] Hello ? > > Well - it looks like I can talk to myself - lots or practice there. > > Actually what is this " u2-users-boun...@listserver.u2ug.org" : bounces >

Re: [U2] UniData memory errors

2011-04-17 Thread Dan Fitzgerald
It looks like you need some of the Docs Wally Terhune has written on UD shared memory. Coming out the gate, your sbcs shared memory segment is underconfigured. That may not be the primary issue here, but it's an indication that work needs to be done in this area. I have no relationship with

Re: [U2] Who is Ed Clark?

2011-04-11 Thread Dan Fitzgerald
Oh, that's easy. Ed Clark was the 1980 U.S. Libertarian Party Presidential nominee. He got just under 1 million votes in the general. > Date: Mon, 11 Apr 2011 18:45:22 +0100 > From: george.l...@aptsolutions.net > To: u2-users@listserver.u2ug.org > Subject: [U2] Who is Ed Clark? > > This is a c

Re: [U2] Game changer for U2 editors

2011-04-04 Thread Dan Fitzgerald
Lovely, but traditionally the [ad] tag goes in the subject. > Date: Mon, 4 Apr 2011 13:24:44 -0600 > From: dave...@gmail.com > To: u2-users@listserver.u2ug.org > Subject: [U2] Game changer for U2 editors > > [ad] > > When U2logic introduced the first U2 editor based on Eclipse IDE in 2004, we

Re: [U2] File Corruption

2011-03-08 Thread Dan Fitzgerald
Are you kicking off any uv jobs from cron? More than one? (Clif, wipe that grin off your face...) > Date: Tue, 8 Mar 2011 13:50:57 + > From: b...@explore.co.uk > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] File Corruption > > Universe 10 > > Aix 5.3 > > -Original Message

Re: [U2] Purging and Indexing

2011-02-16 Thread Dan Fitzgerald
Is it a distributed file? If so, I'd write a basic program to loop through each of the parts sequentially (i.e., a basic select), read each record, evaluate & archive or not, readnext. Then, I'd run a few iterations to run in parallel. You're right about the index overhead. If you had indices,

Re: [U2] How to find and fix a broken lock?

2011-02-02 Thread Dan Fitzgerald
DMIN > 2686979 462014 0 65461 81 RU 557096 eclipseB > THREAD.MANAGER > 2686979 462014 0 52973 81 RU 1061074 eclipseB > MSG.PH.SERVER > > > > Thanks, > Michael McGlothlin > > > > On Wed, Feb 2, 2011 at 5:18 PM, Dan Fitzgerald wrote: > > > >

Re: [U2] How to find and fix a broken lock?

2011-02-02 Thread Dan Fitzgerald
What does the TCL command LIST.READU EVERY return? Do you see that customer # or order # in there? > From: micha...@plumbersstock.com > Date: Wed, 2 Feb 2011 16:26:18 -0700 > To: u2-users@listserver.u2ug.org > Subject: [U2] How to find and fix a broken lock? > > I'm not greatly familiar with

Re: [U2] [UV][AIX] System Management and Performance Tools

2011-01-20 Thread Dan Fitzgerald
Look at nmon; I run it from cron, then email it to myself after midnight. I also have bunches of scripts that run - some every 5 seconds, to notify me if, say, paging space usage on any system exceeds 30%, file systems exceed 85% full, passwords change, sudo is invoked, hosts, hosts.equiv, cron

[U2] [OT]FW: [Autoreply] Re: [UV] PORT.STATUS questions.

2010-12-30 Thread Dan Fitzgerald
Haydon Bishop, eat your heart out. From: gl...@glennsallis.de To: dangf...@hotmail.com Subject: [Autoreply] Re: [U2] [UV] PORT.STATUS questions. Date: Thu, 30 Dec 2010 19:22:49 +0100 Guten Tag, ich bin zur Zeit in den Ferien und kann Ihre Email nicht beantworten. Am 4. Januar 2011 bin ich wi

Re: [U2] [UV] PORT.STATUS questions.

2010-12-30 Thread Dan Fitzgerald
Did real estate prices also cause you to stop putting [ad] in your advertisements? > From: fft2...@aol.com > Date: Thu, 30 Dec 2010 13:19:17 -0500 > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] [UV] PORT.STATUS questions. > > In a message dated 12/30/2010 8:46:12 AM Pacific Standard Ti

Re: [U2] Migration

2010-12-22 Thread Dan Fitzgerald
Yeah, if you can design data objects that you can get in one read, Mazeltov! > Date: Wed, 22 Dec 2010 13:04:32 -0800 > From: go_mnviki...@yahoo.com > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] Migration > > I realize there is a bit more to MV database design then just parent-child >

Re: [U2] Universe in the cloud??

2010-12-20 Thread Dan Fitzgerald
I like the new IBM Blade Center H's. You can mix some scarily powerful AIX blades in the same enclosure as linux & windoze blades, and it's all dynamically virtual, running under PowerVM. I was going to replace a pair of p570's with the new p750 express's, but with even the lower end (JS23; you

Re: [U2] File Copy CowBoy - uvfixfile

2010-12-08 Thread Dan Fitzgerald
Did you fnuxi the file? > From: bi...@hkmetalcraft.com > To: u2-users@listserver.u2ug.org > Date: Wed, 8 Dec 2010 16:47:49 -0500 > Subject: Re: [U2] File Copy CowBoy - uvfixfile > > Andy... > > Thanks... I tried it... unfortunately uvfixfile did not fix the file. > > I suppose that I will try

Re: [U2] Dropping my UniVerse Session - Why?

2010-11-18 Thread Dan Fitzgerald
Attempting to write to an invalid memory address can come from a few issues. I've seen it come from having control characters in an item id, but with windows 2003, it's likely to come from a 32-bit limitiation, or perhaps a physical RAM problem. An other possibility is a corrupted file. Can you

Re: [U2] how to round to 2 decimals?

2010-10-13 Thread Dan Fitzgerald
X=2596 x 8.333 OCONV(X,"MR2") > From: cjausti...@hotmail.com > To: u2-users@listserver.u2ug.org > Date: Wed, 13 Oct 2010 16:22:04 -0500 > Subject: [U2] how to round to 2 decimals? > > > I'm trying to figure out how to round to 2 decimal places with a floating > point in UniVerse > > For exam

Re: [U2] Unidata - Hardware sizing for 550 telnet users

2010-09-03 Thread Dan Fitzgerald
Ramdisk IS good for temp files; it's also very good for resizing. Specify the ramdisk filesystem as the place where you want the resize file built, and it flies. > From: n...@switp.com > To: u2-users@listserver.u2ug.org > Date: Fri, 3 Sep 2010 11:10:11 -0700 > Subject: Re: [U2] Unidata - Hardw

Re: [U2] Unidata - Hardware sizing for 550 telnet users

2010-09-03 Thread Dan Fitzgerald
And even that is a lot of hardware for a U2 system. Look at the new p750 express boxes. They're at a pretty good price point (once you get those discounts from the vendor), and not a lot of hardware goes a long way with the new p7 chips. > From: n...@switp.com > To: u2-users@listserver.u

Re: [U2] Impossible to handle big files (over 2 Gb) with Universe onPowerPC

2010-08-04 Thread Dan Fitzgerald
I'm curious as to why the app won't allow distributed files. Is the 64BIT parameter in uvconfig set to 1? If so, then it's probably either the Redhat PowerPC is a 32-bit version, or it's very old 32-bit hardware. If either of these are the case, you'll want to upgrade to 64-bit versions. >

Re: [U2] Very much OT - AUTO: Haydon Bishop is out of the office (again)

2010-07-01 Thread Dan Fitzgerald
He might be keeping fit. > From: fft2...@aol.com > Date: Thu, 1 Jul 2010 17:13:31 -0400 > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] Very much OT - AUTO: Haydon Bishop is out of the office > (again) > > He is apparently either playing football or fishing. > > http://www.adserve.co.u

Re: [U2] RFS error question

2010-06-17 Thread Dan Fitzgerald
closing a TM AFID, but has > not been isolated and reproduced. There does not seem to be any consequence > to the running application. > > > -Dan G. > > -Original Message- > From: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserve

[U2] RFS error question

2010-06-16 Thread Dan Fitzgerald
If you were running RFS & looked in your sm.log & saw this error message: Invalid tm_afid,tm:42, U_tm_close, Tue Jun 15 10:45:14 2010, tm_afid:6, U_tm_aft_n:1010. ...what do you think this would indicate?

Re: [U2] Filesystem options cio for AIX 5.3

2010-06-03 Thread Dan Fitzgerald
Don't know about cio, but if you do a vmstat -v | grep buf today, and then another one in 24 hours, are you seeing the numbers climb? > From: dgo...@interlinebrands.com > To: u2-users@listserver.u2ug.org > Date: Thu, 3 Jun 2010 16:51:19 -0400 > Subject: [U2] Filesystem options cio for AIX 5.3 >

Re: [U2] questions about the REBUILD.FILE utility

2010-05-02 Thread Dan Fitzgerald
Look in uvtemp. > From: jharbesto...@gmail.com > To: u2-users@listserver.u2ug.org > Date: Sun, 2 May 2010 17:03:27 -0400 > Subject: [U2] questions about the REBUILD.FILE utility > > Greetings, > > I am using the REBUILD.FILE utility on a data file that is around > 4,000,000 records. I started

Re: [U2] Universe and stripped drives

2010-04-28 Thread Dan Fitzgerald
In most unixes, you can do it at the OS level. > From: ggal...@wyanokegroup.com > To: u2-users@listserver.u2ug.org > Date: Wed, 28 Apr 2010 12:27:34 -0500 > Subject: Re: [U2] Universe and stripped drives > > interesting idea. Wonder if our RAID controller can do a 3 way mirror? > I'll have to c

Re: [U2] Universe and stripped drives

2010-04-28 Thread Dan Fitzgerald
If you create 2 stripes, will you have 2 disk controllers? If not, I don't see much difference between the two. I'd be more concerned with file sizing, and using indices rather than sequential searches, and other tuning techniques (read-ahead parameters, file caching, fs buffering, etc.). One c

Re: [U2] Not Consistent Failure

2010-03-23 Thread Dan Fitzgerald
ot uses the truss command. Pointers? > > They drop to the Unix directory specified in the passwd file. > > Karl > > > On Tue, March 23, 2010 3:53 pm, Dan Fitzgerald wrote: > > > > One thing you could do is to make that sleep like 30 seconds, find that >

Re: [U2] Not Consistent Failure

2010-03-23 Thread Dan Fitzgerald
One thing you could do is to make that sleep like 30 seconds, find that pid, then use the AIX truss command against it while it's sleeping, and see what bombs. When they drop to AIX, are they in the directory specified in /etc/passwd, or somewhere else? > Date: Tue, 23 Mar 2010 15:2

Re: [U2] U2’s Latest Tour

2010-03-13 Thread Dan Fitzgerald
That's funny. I wonder if it was a 'bot or a person who subscribed? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of onlineticketspot Sent: Saturday, March 13, 2010 7:18 AM To: u2-users@listserver.u2ug.org Subject: [U2

Re: [U2] UniVerse Slow - Fixed

2010-03-11 Thread Dan Fitzgerald
Well... first off, there's almost no reason to have a sep of 1. You should write a program to change all of those 1's to 4's. Second, 11, while not as bad as 1, is still wholly inadequate for all but very small files. THe answer isn't so much a different default as at least a little consci

Re: [U2] TOP/LIMIT Equivalent?

2010-02-18 Thread Dan Fitzgerald
You could save the list, and edit it. But, really, there will be no logical relationship between these records. The 1st hundred is just as random as the 2nd or 3rd hundred, unless your modulus is an extremely ill-advised one. Again, they are hashed records. What we mean by this is that UV will ta

Re: [U2] TOP/LIMIT Equivalent?

2010-02-18 Thread Dan Fitzgerald
Well... kind of the reverse. The SAMPLE keyword with SELECT will give you the first n records. But remember that UV stores records using a hashing algorithm, so the first n records won't be meaningfully different from the last n records. SELECT file SAMPLE 100 -Original Message- From: u2

Re: [U2] HP Unix "who am i"

2010-02-02 Thread Dan Fitzgerald
One place I worked, the users called that "whammy". > Date: Tue, 2 Feb 2010 09:41:40 -0500 > From: bro...@pny.com > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] HP Unix "who am i" > > > Congrats on finding the solution to that tough problem > > Barry Rogen > PNY Technologies, Inc.

Re: [U2] Resize Question

2010-02-01 Thread Dan Fitzgerald
Did you fnuxi the dictionary? It is, after all, a separate file at the OS level. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Andrew E. Tegenkamp Sent: Monday, February 01, 2010 11:15 AM To: u2-users@listserver.u

Re: [U2] Predicting application performance

2010-01-31 Thread Dan Fitzgerald
Looking at runqueue in topas is often a good predictor. Are you running nmon? I recommend that you do. On thing to look at there is vmstat -v, and watch to see if the I/O's blocked because of various buffers being unavailable increases day to day (or even hour-to-hour). The other thing in UD is

Re: [U2] UniVerse RetreiVe how do I query a file for all of its column's values?

2010-01-20 Thread Dan Fitzgerald
So, the choices are to edit the @ item in the dict & add all of the columns, or write a basic program that reads Rec, then outputs Rec<1>, Rec<2>, etc. A third solution would be to copy the F1 dictionary item to F2, F3, F4, etc., change the attribute (column) field to match, then list 'em all, mayb

[U2] [OT]:RE: David Beckwith/WA/QBE/Insurance is out of the office.

2009-11-16 Thread Dan Fitzgerald
I am in the dining room, enjoying a glass of Oregon Pinot Noir. I will return to work sometime in the late morning on Tuesday, November 17. This information is neither privileged nor confidential. You clearly received this email in error. -Original Message- From: u2-users-boun...@listser

Re: [U2] Distributed file on Unidata Unix (DEFINE.DF)

2009-10-21 Thread Dan Fitzgerald
In a related question, is there a maximum minimum.modulo for a dynamic file in unidata? Could I, for example, use a minimum.modulo of 5,000,011? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan Fitzgerald Sent

Re: [U2] Distributed file on Unidata Unix (DEFINE.DF)

2009-10-20 Thread Dan Fitzgerald
Create a dynamic file; it's the analogue. You can move parts to different directories/file systems. The number of parts is controlled by the modulus you pick, in concert with the udtconfig parameter MAX_FLENGTH. You can't control the hashing algorithm as much, but you have a few options. -Orig

Re: [U2] GOOD NEWS From Susie

2009-09-16 Thread Dan Fitzgerald
Fortunately, I've become a unix admin over the past couple of years, specializing in tuning with or without a U2 database. I also increased my gold holdings last year, so I'm feeling pretty prescient at the moment. Having worked with most of the indexed spreadsheets (Oracle, Sysbase, DB2, MySQL

Re: [U2] Indexing

2009-09-09 Thread Dan Fitzgerald
System Description, chapter 4, starting on page 22. Be sure to "get" what NO.NULLS does; if you have a lot of fields with null values, it makes your index lopsided and much less effective. Also, note that each index on a file increases your writes by 1. We see a significant throughput hit after 5

[U2] UD equivalent of UV FILE.USAGE?

2009-09-03 Thread Dan Fitzgerald
Anyone know if there is a Unidata equivalent to the UniVerse "FILE.USAGE" set of commands? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Connecting to a Universe Database

2009-08-17 Thread Dan Fitzgerald
I'd look at sockets. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Castilletti Sent: Monday, August 17, 2009 9:47 AM To: U2-Users@listserver.u2ug.org Subject: [U2] Connecting to a Universe Database New project

Re: [U2] [UV] Hang

2009-07-27 Thread Dan Fitzgerald
Are you updating anything on login, either unix or uv? Are the .profiles doing any serious processing? It's hard to tell how far it got just from the display. Does the process show up in PORT.STATUS before you kill it? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:

Re: [U2] "WR" Group Lock

2009-07-27 Thread Dan Fitzgerald
...and I'd recommend trying kill -4 3-4 times before kill -9. Universe interprets this as "the system is crashing", and attempts to clean up everything it can before exiting. Kill -9 means sudden death, no getting your affairs in order. -Original Message- From: u2-users-boun...@listserver.

Re: [U2] Mixed Case UV Basic Programming Standards.

2009-06-29 Thread Dan Fitzgerald
My standard is to coat anyone using a goto with salty duck fat & drop them from 15 feet up into the play yard at the Atlanta Humane Society during Pit Bull Play Hour. To make my standard work, you'll have to learn to fly a helicopter... Given the subject, I feel compelled to add: I'm kidding. I

[U2] Web DE 4.4.2 release

2009-06-26 Thread Dan Fitzgerald
The online U2 product matrix shows WebDE 4.4.2 for HP PA RISC was released this week. Any word on the itanium version? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Mixed Case UV Basic Programming Standards.

2009-06-24 Thread Dan Fitzgerald
Oh, you didNot say GOTO... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson Sent: Wednesday, June 24, 2009 2:39 PM To: U2 Users List Subject: [U2] Mixed Case UV Basic Programming Standards. I don't

RE: [U2] UV resize error

2009-05-05 Thread Dan Fitzgerald
Also check to see if the resize bit is already set by a prior attempt. > From: lhan...@redwoodcity.org > To: u2-users@listserver.u2ug.org > Date: Tue, 5 May 2009 10:50:58 -0700 > Subject: RE: [U2] UV resize error > > In my experience, anything that is accessing the file(s) in question - and not >

RE: [U2] UV 10.1.22; Dynamic File question

2009-04-24 Thread Dan Fitzgerald
... and at this point I'd be thinking "static file". Distributed, if necessary. -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Charles Stevenson Sent: Friday, April 24, 2009 12:19 AM To: u2-users@listserver.u2ug.org Sub

RE: [U2] Record Size Limit in UV

2009-04-23 Thread Dan Fitzgerald
Add to this the fact that, given the usual page size of 4k, you're going to do 25 physical disk reads to retrieve each item. I'd consider a redesign. One place I tuned was doing 11 transactions per minute ("you mean, per second?, I asked). It turns out that they were opening batches & leaving the

RE: [U2] UniVerse and Transaction Logging

2009-03-30 Thread Dan Fitzgerald
You may want to look at UV Replication using publisher/subscriber instead. If you have a transaction (update) that crosses the boundaries of one transaction log into the next, you will lose that transaction on the DR side. It is VERY likely - bordering on certain - that each transaction log will h

RE: [U2] Does anybody have a hot backup server?

2009-03-26 Thread Dan Fitzgerald
If your scripts do not somehow take account of transactions that span across 2 logs, this will drop transactions. -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Kevin Sproule Sent: Thursday, March 26, 2009 5:02 PM To: u2

RE: [U2] Does anybody have a hot backup server?

2009-03-19 Thread Dan Fitzgerald
Ah, the transaction logger. Here's the problem (unless it got fixed somehow) with that: When you're running uvrolf to roll forward the logs on the DR box, you have the "last transaction" problem. The last update in the transaction log can span over to the next transaction log. If this happens (an

RE: [U2] Does anybody have a hot backup server?

2009-03-18 Thread Dan Fitzgerald
I'd be worried about a particular vulnerability in this scenario. If the system goes down while you are updating overflow or oversized data frames, you could get file corruption. A single U2 logical write can take multiple os writes, and at any given moment on a busy system, you probably will have

RE: [U2] Does anybody have a hot backup server?

2009-03-18 Thread Dan Fitzgerald
UV or UD? -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Jeff Powell Sent: Wednesday, March 18, 2009 3:07 PM To: u2-users@listserver.u2ug.org Subject: [U2] Does anybody have a hot backup server? I am trying to put tog

RE: [U2] Performance monitoring

2009-03-05 Thread Dan Fitzgerald
thers we have such as the lock parameters. We haven't changed any of these in some time, but I'm wondering if we're hitting some thresholds. How would I know? Dan Fitzgerald wrote: > > Of course, there are a lot of things to look at. > > I think what you're lo

RE: [U2] Performance monitoring

2009-03-04 Thread Dan Fitzgerald
Oh; you can also get a huge amount of nearly real-time info using truss -p , but you need to speak "systemCallese" to understand it all. -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of ericro Sent: Wednesday, March 04, 20

RE: [U2] Performance monitoring

2009-03-04 Thread Dan Fitzgerald
Of course, there are a lot of things to look at. I think what you're looking for is svmon -U username. This will show you the user's memory map. Svmon with no arguments shows you overall stats; one thing to look for there is that there should be no pinned memory for UV; Oracle needs pinned memory,

RE: [U2] Strange happening...

2009-03-02 Thread Dan Fitzgerald
Right. The readnext id is against the open file - you're not reading the actual item (that's in the "CODE"). If you're not doing it this way, compare a benchmark for this with whatever you're using. I think you'll see that this construct uses many fewer system calls, reads, and cpu cycles. I remem

RE: [U2] Maybe not the list to ask on, but SB+ generated documentation.

2009-02-26 Thread Dan Fitzgerald
Download here: http://www-01.ibm.com/software/data/u2/pubs/library/ -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Jeff Ritchie Sent: Thursday, February 26, 2009 8:08 PM To: u2-users@listserver.u2ug.org Subject: [U2] Ma

RE: [U2] Errors with RPC

2009-01-12 Thread Dan Fitzgerald
Is uvrpc running? I know that, at least on linux, when you try to start the rpc daemon, it tells you it's already runnung, because a ps piped to a grep returns itself, so the program thinks there's an instance running already... you'll have to look for the actual process at the os level.> Subject:

RE: [U2] UniVerse and/or AIX caching

2008-10-23 Thread Dan Fitzgerald
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

RE: [U2] uniVerse COPY command and the UVTEMP directory

2008-09-17 Thread Dan Fitzgerald
It's something else. you've probably exceeded the available memory (RAM) for that user. Now, the question is "why"? 200Mb isn't all that much, so I'd look to see if there was a problem with that record's structure, insofar as UV is concerned. Of course, you'll probably get the same error when yo

  1   2   3   >