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

[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 know, so I 
> can update my list
> 
> https://sites.google.com/site/pickuniverse/companies-that-use-pick
> 
> Thanks
> 
> 
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] [OT] Interview Questions

[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 
wealth of examples to draw upon…
Kevin: I'd take the month (verifying; gigo), then run it through a case 
statement to determine the number of days in that month (sounds like a handy 
subroutine to have in the toolbox). Then I'd convert to get the day of the 
week, another case statement to get the number of days past Thursday, do the 
math from the last DOM internal date, oconv the result, and grab a cup of dark 
roast. There are probably more efficient ways, but that's how I'd work it 
through my head in an interview.

> Date: Sat, 14 Dec 2013 09:14:36 -0700
> From: ke...@precisonline.com
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] [OT] Interview Questions
> 
> David, I've used many of these questions in the past but where it fell down
> was that it didn't give any real picture of technical ability. The one
> question I've been using lately to assess technical thinking is "how would
> you calculate the last Thursday in a month?" The answers have been
> everywhere from accurate to sheer ridiculous. The unexpected takeaway from
> this question is that it has helped to identify people who simply want to
> answer quickly without thinking - not a good trait unless the answer is
> right and to date that's happened a total of zero times - vs people who
> think first and then give a reasoned response.
> 
> I've just found it too easy for people to stretch the truth when
> explaining their
> technical ability, so I'm asking questions intended to give some evidence.
> 
> On Saturday, December 14, 2013, David Sharp wrote:
> 
> > Here is something I have used:
> > What single project
> > or task would you consider the most significant accomplishment in your
> > career
> > so far?
> >
> >
> >
> >
> > ·
> > Can you give me a detailed overview of the
> > accomplishment?
> >
> > ·
> > Tell me about the company, your title, your
> > position, your role, and the team involved.
> >
> > ·
> > What were the actual results achieved?
> >
> > ·
> > When did it take place and how long did the
> > project take.
> >
> > ·
> > Why you were chosen?
> >
> > ·
> > What were the 3-4 biggest challenges you
> > faced and how did you deal with them?
> >
> > ·
> > Where did you go the extra mile or take the
> > initiative?
> >
> > ·
> > Walk me through the plan, how you managed
> > to it, and if it was successful.
> >
> > ·
> > Describe the environment and resources.
> >
> > ·
> > Describe your manager’s style and whether
> > you liked it or not.
> >
> > ·
> > Describe the technical skills needed to
> > accomplish the objective and how they were used.
> >
> > ·
> > Some of the biggest mistakes you made.
> >
> > ·
> > Aspects of the project you truly enjoyed.
> >
> > ·
> > Aspects you didn’t especially care about
> > and how you handled them.
> >
> > ·
> > How you managed and influenced other, with
> > lots of examples.
> >
> > ·
> > How you changed and grew as a person.
> >
> > ·
> > What you would do differently if you could
> > do it again.
> >
> > ·
> > What type of formal recognition did your
> > receive?
> >
> >
> > Regards,
> > David Sharp
> > > Date: Fri, 13 Dec 2013 12:27:18 -0800
> > > From: i...@keyway.net 
> > > To: u2-users@listserver.u2ug.org 
> > > Subject: Re: [U2] [OT] Interview Questions
> > >
> > > Please email me in regards to your ads. I am currently in between
> > > contracts/assignments/projects and looking for my next assignment.
> > > Multivalue languages I have been programming in:
> > >
> > > * CACHE (language: MV BASIC)
> > > * INFORMATION (language: INFO/BASIC)
> > > * jBASE (language: jBC, jBASE BASIC, jBASIC)
> > > * MENTOR System (language: DATA/BASIC, DATABASIC, DATA BASIC)
> > > * MVENTERPRISE (language: MVENTERPRISE BASIC)
> > > * MVON/ONWARE (language: ONWARE BASIC)
> > > * OPENINSIGHT (language: BASIC+)
> > > * OPENQM, QM (language: QMBASIC)
> > > * PICK, Advanced PICK, D3 (language: PICK BASIC)
> > > * Power95 (language: DATA/BASIC, DATABASIC, DATA BASIC)
> > > * REALITY System (language: DATA/BASIC, DATABASIC, DATA BASIC)
> > > * REVELATION, Advanced REVELATION (language: R/BASIC, REVELATION BASIC)
> > > * UNIDATA (language: UNIBASIC)
> > > * UNIVERSE (language: UNIVERSE BASIC)
> > > * UNIVISION (language: UVBASIC)
> > > * WebSphere DataStage (language: DSBASIC, DataStage BASIC)
> > >
> > > Robert Norman, Multivalue Programmer/Analyst
> > > (951) 541-1668
> > >
> > > On 10/7/2013 7:35 PM, Kevin King wrote:
> > > > This is not specifically a job posting, but I do have ads up on
> > Monster and
> > > > LinkedIn looking for talent.
> > > >
> > > > At the risk of confessing too much, I have historically been far too
> > easy
> > > > in the interview process.  As a result, I have had some
> > less-than-exce

Re: [U2] File type 30 (dynamic)

[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 for this purpose, 
even if you  had to make it distributed to account for size. Since most of what 
you'll do with this file is write to it, I wouldn't worry too much about empty 
groups.
 
> Date: Tue, 9 Jul 2013 09:15:20 -0700
> From: szach...@gardensalive.com
> To: u2-users@listserver.u2ug.org
> Subject: [U2] File type 30 (dynamic)
> 
> I have very little experience with using dynamic (type 30) files and I'm
> looking for some pointers in that regard. I have a file that I am
> considering creating as a dynamic file. The file will be a log file with
> sequential numeric keys. The record size will normally range from about 200
> to 700 bytes, with a probable maximum size of less than 1,000 bytes. We
> expect the file to continually grow without deletions and we will likely
> purge it annually. What are the pro's and con's of creating this file as
> type 30 verses other file types?
> 
> Thanks, 
> 
> Scott Zachary
> UniVerse Developer
> Gardens Alive! Inc
> 
> 
> 
> --
> View this message in context: 
> http://u2-universe-unidata.1073795.n5.nabble.com/File-type-30-dynamic-tp41129.html
> Sent from the U2 - Users mailing list archive at Nabble.com.
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
  
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] SAN?

[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 a great idea to 
increase RAM so that your cache hit rate is very high. With the lrud approach, 
you can get very high %'s.
 
> From: r...@lynden.com
> To: u2-users@listserver.u2ug.org
> Date: Tue, 2 Jul 2013 13:12:06 -0700
> Subject: Re: [U2] SAN?
> 
> Ty,
> 
> We have run 2 good sized Solaris boxes and 1 medium one over paired 1Gb 
> switches for a long time ~ 5-600 users, thousands of files. Bandwidth is not 
> a problem.  We do run a separate network for SAN access from the servers.  As 
> a practical matter, this works.  We are upgrading the switches to 10Gb, but 
> we are by no means saturated.
> 
> Solaris supports an "llock" or local lock option on NFS mounts which 
> circumvents some of the performance issues mentioned in Aaron's message. I 
> think that there is a similar solution for Linux boxes. 
> 
> rw,bg,vers=3,proto=tcp,hard,intr,rsize=32768,wsize=32768,llock
> 
> This may not apply with your SAN.  But if you can move some stuff over and 
> test it, it is definitely worth the effort.  Is NFS slower that a local disk? 
>  Likely so, right up until you have a disk failure, have to restore from tape 
> instead of a snapshot, or fsck 500 Gigs.  Is performance very good anyway? 
> Yes. If a SAN can handle the average Microsoft product & output, U2's text 
> based data cannot be all that difficult. ("hello world" in msword is worth 5 
> groups in UV.) I apologize for the evangelical bent.
> 
> There are doubtlessly architectural solutions other than NFS mounts, and some 
> may be appropriate to your hardware and applications.  NFS can be quite 
> simple and surprisingly robust.
> 
> -Rick
> 
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org 
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ty Haller
> Sent: Tuesday, July 02, 2013 10:50 AM
> To: 'U2 Users List'
> Subject: Re: [U2] SAN?
> 
> Thanks.
> 
> I'm aware of the advantages. I was more concerned with the IO requirements 
> and how that would impact shared storage.
> 
> 
> 
> Ty Haller
> SEFCU
> Lead Administrator - System Services
> thal...@sefcu.com
> 
> > -Original Message-
> > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> > boun...@listserver.u2ug.org] On Behalf Of Rick Nuckolls
> > Sent: Tuesday, July 02, 2013 11:13 AM
> > To: 'u2-users@listserver.u2ug.org'
> > Subject: Re: [U2] SAN?
> > 
> > Ty,
> > 
> > We have used a NetApps SAN for a number of years with Solaris for Universe
> > data.  (For Universe) there is the obvious tweak of allowing direct access 
> > to
> > NFS, and depending on the type of SAN, there are probably some mount options
> > to optimize the throughput.  It also helps to have a fair amount of memory 
> > for
> > file caching, but it works great and provides many important advantages.  A
> > couple of caveats: Do not allow access to snapshots through the same NFS
> > mount as the primary data.  For NetApps, at least, the snapshot has the same
> > inode as the live data file, so the snapshot tree must be mounted as a 
> > separate
> > device to avoid confusing (Universe) with conflicting file headers and 
> > data.  NFS
> > mounts work fine, as long as access to a particular directory tree is 
> > managed
> > by a single data server.
> > 
> > Oracle supports this same configuration, though I do not think that Rocket 
> > has
> > much experience with it.
> > 
> > Although difficult, it is possible to install Universe a SAN, and then run 
> > it on a
> > VM, which means that you can snapshot almost all of the UV environment at
> > once!
> > 
> > Rick Nuckolls
> > Lynden Inc
> > 
> > 
> > 
> > -Original Message-
> > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> > boun...@listserver.u2ug.org] On Behalf Of Ty Haller
> > Sent: Tuesday, July 02, 2013 6:15 AM
> > To: 'u2-users@listserver.u2ug.org'
> > Subject: [U2] SAN?
> > 
> > Morning,
> > 
> > I am curious if anybody has UniData Accounts running off a Shared Enterprise
> > SAN?
> > 
> > We currently have an Enterprise SAN for our VMware Environment and would
> > like to put a handful of UniData Test Accounts on it.
> > 
> > We are using UniData 7.2 on an IBM P6 running AIX 6.1, the SAN would be 4GB
> > Fiber Attached.
> > 
> > 
> > Thoughts?
> > 
> > Ty Haller | Lead Administrator - System Services | SEFCU | thal...@sefcu.com
> > 700 Patroon Creek Blvd. Albany, NY 12206 | Phone: 518-464-5210 | Fax: 518-
> > 464-5209
> > 
> > This message may contain confidential information and is intended for the 
> > sole
> > purpose of communication with the addressee. Dissemination or publication in
> > any format is strictly prohibited. If you have received this communication 
> > in
> > error please notif

Re: [U2] command not found

[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" for root and root's password
> then run the command
> - Original Message - 
> From: "Doug Averch" 
> To: "U2 Users List" 
> Sent: Thursday, February 14, 2013 3:24 PM
> Subject: [U2] command not found
> 
> 
> > One of  our customers running Unix/Linux on Unidata 7.2 is getting this
> > message when the run this command
> > from our UOJ interface within Eclipse:
> > 
> > !guide MY.FILE -o -np
> > 
> > sh: guide: command not found
> > 
> > It works if the run it from ECL which I thought it would fail if it was a
> > path problem.  They are running
> > the command as root and it fails within Eclipse.  The "bang" VOC entry is
> > correct and there is no
> > guide entry in the VOC file either.
> > 
> > Regards,
> > Doug
> > www.u2logic.com
> > BTW: I did a search of the Rocket database and could not find any mention
> > of this.
> > ___
> > U2-Users mailing list
> > U2-Users@listserver.u2ug.org
> > http://listserver.u2ug.org/mailman/listinfo/u2-users
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
  
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] : Evaluating DCOUNT

[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
> Subject: Re: [U2] : Evaluating DCOUNT
> 
> My understanding is that UniVerse keeps track of the location of each 
> attribute the first time is hits an attribute.  U2 support will need to 
> provide a definitive answer.  
> 
> I do know that we have found field marks are measurably faster than value 
> marks, and concatenating strings is measurably faster than using dynamic 
> array functions, anytime we go over about 1,000 values.  Remove definitely 
> helps, but most of our code is old and is still using for/next loops. 
> 
> Tom Whitmore
> RATEX Business Solutions
> 
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org 
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
> Sent: Tuesday, February 12, 2013 3:24 PM
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] : Evaluating DCOUNT
> 
> Yes it keeps track of the position of the current field (only), not each 
> field.
> It's not indexed.  Its just a one value pointer.
> 
>  
> 
>  
> 
>  
> 
> -Original Message-
> From: Wols Lists 
> To: u2-users 
> Sent: Tue, Feb 12, 2013 12:16 pm
> Subject: Re: [U2] : Evaluating DCOUNT
> 
> 
> On 12/02/13 19:04, Wjhonson wrote:
> > Correct me if I'm misunderstanding you Tom, but you said that field 
> > marks are
> indexes so the first scan resolves where each field begins. That is not 
> correct, at least not literally.
> > 
> > Count or Raising or Lowering or Scanning in general will not create an 
> > index
> to the position of any fields.
> > The Remove maintains *A* (singular) pointer to where it's at, right 
> > now, as it
> moves along.
> > It's not a fully indexed string.  There's just a current position pointer.  
> One.
> > 
> The thing here, is Tom said he used for/next, and not remove. Just as remove 
> keeps track of the current position in the string, so does
> *field* access in a dynamic array!
> 
> So the original program had to scan the multi-value variable every single 
> time round the loop. SLOW. The revised program, using RAISE, was scanning a 
> multi-*field* variable, and BASIC's internal optimiser kept track of the 
> current field. Effectively increasing the speed to pretty much the same as 
> using REMOVE.
> 
> Cheers,
> Wol
> > 
> >  
> > 
> >  
> > 
> >  
> > 
> > -Original Message-
> > From: Tom Whitmore 
> > To: U2 Users List 
> > Sent: Tue, Feb 12, 2013 10:43 am
> > Subject: Re: [U2] : Evaluating DCOUNT
> > 
> > 
> > Hi,
> > When you have more than about 1,000 values in a field, changing the 
> > value mark
> 
> > to a field mark, is significant.  I had a program that needed to work 
> > through two fields with over 20,000 values.  Initially, I left the 
> > strings as value delimited, used a for/next loop and assigned the 
> > results to a new field delimited string using <-1>.  The program took 
> > about 15 minutes to perform the
> 
> > tasks needed.  I then raised each string, used remove and concatenated
> @FM:item.  
> > It was done almost immediately, there was no perception of a delay 
> > getting to TCL.  To put it in code snippet, the first took 15 minutes 
> > and the second took
> 
> > maybe a second.
> > 
> > X=20K values
> > Y=20K values
> > Z=''
> > MAX=DCOUNT(X,@VM)
> > FOR C=1 TO MAX
> >I1=X<1,C>
> >I2=Y<1,C>
> >Z=I1*I2
> > NEXT C
> > 
> > 
> > X=RAISE(20Kvalues)
> > Y=RASE(20Kvalues)
> > Z=''
> > LOOP
> >REMOVE I1 FROM X  SETTING XPOS
> >REMOVE I2 FROM Y SETING YPOS
> > UNTIL I1='' AND I2='' AND XPOS=0 AND YPOS=0
> >   IF (Z) 
> >   THEN Z:=@AM:I1*I2
> >   ELSE Z=I1*I2
> > REPEAT
> > 
> > There are several things:
> > 1) REMOVE is faster than extract, especially when you are working with 
> > values
> > 2) Strings are treated different from dynamic arrays even though in 
> > theory you
> 
> > are doing the same thing (appending to the end of the string).
> > 3) COUNT will scan the string, then the extract will scan the string 
> > when it
> is 
> > value delimited.  Field marks are indexes so the first scan resolves 
> > the location where each field begins.
> > 
> > Tom
> > RATEX Business Solutions
> > 
> > -Original Message-
> > From: u2-users-boun...@listserver.u2ug.org 
> > [mailto:u2-users-boun...@listserver.u2ug.org]
> 
> > On Behalf Of Dave Laansma
> > Sent: Tuesday, February 12, 2013 1:21 PM
> > To: 'U2 Users List'
> > Subject: Re: [U2] : Evaluating DCOUNT
> > 
> > Hey Allen,
> > 
> > The REMOVE so fast  that I 
> > suspect
> the 
> > time it takes to interpret the difference between a VM and AM is 
> > negligible. I
> 
> > could be wrong.
> > 
> > And as far as using dimensioned arrays, agreed. They do seem to 
> > improve speed ... but still not in comparison to the REMOVE 

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

[Dan Fitzgerald]

Other users could have been hanging at malloc. With a swappiness of 100 (on 
some kernels) or 100 (on others) or "not 0 or 100"(not sure which behavior you 
get on 2.6.18), pages wouldn't be getting freed up quickly enough duing the 
creation/copying of a large file.
 
Another thing to look at (although I prefer the support route, since you have 
it), is /sys/kernel/mm/transparent_hugepage/defrag. Other people who have had 
this problem alleviated it by setting this to "never".
 
Of course, others fixed it by updating the kernel. My aged eyes read what you 
have as 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/vm/swappiness?
> 
> How will that make any difference? 2.6.18-348 SOUNDS like an ancient (in
> linux terms) kernel. Are you on RedHat support?
> 
> This is a problem with the linux kernel that was addressed recently,
> iirc. Large amounts of io from a single process can swamp the queue, and
> the latest kernels have it fixed.
> 
> If you've got RH support, see if you can find out if that's been
> backported into your kernel.
> 
> Cheers,
> Wol
> >  
> >> 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-
> >> From: u2-users-boun...@listserver.u2ug.org 
> >> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen
> >> Sent: Monday, February 04, 2013 9:23 AM
> >> To: 'U2 Users List'
> >> Subject: Re: [U2] [UV] Large File Operations Kill Linux
> >>
> >>  A few questions - What linux version/distro are you on and what type of
> >> file system, and how much ram do you have
> >>
> >> -Original Message-
> >> From: u2-users-boun...@listserver.u2ug.org
> >> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Perry Taylor
> >> Sent: 04 February 2013 15:57
> >> To: U2-Users List
> >> Subject: [U2] [UV] Large File Operations Kill Linux
> >>
> >> Looking for some ideas on how to keep Linux from becoming largely
> >> unresponsive when creating large files.  What happens is as the new file is
> >> being created the I/O buffer cache quickly fills up with dirty buffers.
> >> Until the kernel can flush these out to disk there is no avail buffers for
> >> I/O operations from other processes.  .  The most troubling manifestation 
> >> of
> >> this is the transaction logging check point daemon gets *way* behind 
> >> putting
> >> us as risk if we were to have a failure of some kind.
> >>
> >> I have tried using ionice and renice to slow the file creation down as much
> >> as possible.  This help a little but is still a big problem.  Any ideas how
> >> to get CREATE.FILE/RESIZE to play nice on Linux?
> >>
> >> Thanks.
> >> Perry
> >> Perry Taylor
> >> Senior MV Architect
> >> ZirMed
> >> 888 West Market Street, Suite 400
> >> Louisville, KY 40202
> >> www.zirmed.com<http://www.zirmed.com/>
> >>
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
  
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[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-
> From: u2-users-boun...@listserver.u2ug.org 
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen
> Sent: Monday, February 04, 2013 9:23 AM
> To: 'U2 Users List'
> Subject: Re: [U2] [UV] Large File Operations Kill Linux
> 
>  A few questions - What linux version/distro are you on and what type of
> file system, and how much ram do you have
> 
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Perry Taylor
> Sent: 04 February 2013 15:57
> To: U2-Users List
> Subject: [U2] [UV] Large File Operations Kill Linux
> 
> Looking for some ideas on how to keep Linux from becoming largely
> unresponsive when creating large files.  What happens is as the new file is
> being created the I/O buffer cache quickly fills up with dirty buffers.
> Until the kernel can flush these out to disk there is no avail buffers for
> I/O operations from other processes.  .  The most troubling manifestation of
> this is the transaction logging check point daemon gets *way* behind putting
> us as risk if we were to have a failure of some kind.
> 
> I have tried using ionice and renice to slow the file creation down as much
> as possible.  This help a little but is still a big problem.  Any ideas how
> to get CREATE.FILE/RESIZE to play nice on Linux?
> 
> Thanks.
> Perry
> Perry Taylor
> Senior MV Architect
> ZirMed
> 888 West Market Street, Suite 400
> Louisville, KY 40202
> www.zirmed.com
> 
> 
> 
> CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is
> for the sole use of the intended recipient(s) and may contain confidential
> and privileged information.  Any unauthorized review, use, disclosure or
> distribution is prohibited. ZirMed, Inc. has strict policies regarding the
> content of e-mail communications, specifically Protected Health Information,
> any communications containing such material will be returned to the
> originating party with such advisement noted. If you are not the intended
> recipient, please contact the sender by reply e-mail and destroy all copies
> of the original message.
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
> -
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 2012.0.2238 / Virus Database: 2639/5579 - Release Date: 02/03/13
> 
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
  
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[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 ODBC
> 
> I believe both Universe and Unidata run ODBC via the standard UniRPC 
> port 31438 unless you are running UniRPC on a different port.
> 
> bradley.sch...@usbank.com wrote:
> > We may need to figure out a way to disable ODBC access to UniData due to 
> > data access concerns. I've set up connections before, but have never 
> > approached ODBC from this perspective. I'm hoping there's a service we can 
> > turn off or a port we can block. One possible constraint is that we still 
> > need to be able to connect to UniData via DataStage. We use the native 
> > unidata connector, so I'm hoping that won't get in the way. Thoughts?
> >
> > UniData 7.1
> > AIX 5.3
> >
> >
> > TIA,
> > Brad.
> > U.S. BANCORP made the following annotations
> > -
> > Electronic Privacy Notice. This e-mail, and any attachments, contains 
> > information that is, or may be, covered by electronic communications 
> > privacy laws, and is also confidential and proprietary in nature. If you 
> > are not the intended recipient, please be advised that you are legally 
> > prohibited from retaining, using, copying, distributing, or otherwise 
> > disclosing this information in any manner. Instead, please reply to the 
> > sender that you have received this communication in error, and then 
> > immediately delete it. Thank you in advance for your cooperation.
> >
> >
> >
> > -
> >
> > ___
> > U2-Users mailing list
> > U2-Users@listserver.u2ug.org
> > http://listserver.u2ug.org/mailman/listinfo/u2-users
> >
> >   
> 
> -- 
> 
> Jeff Schasny - Denver, Co, USA
> jschasny at gmail dot com
> 
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
  
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[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 5.3 Stops Unexpectedly
> 
> Hi Kevin,
> 
> I can't help you with what you're asking for, directly, but as a
> suggestion on something to try, if you make a small script that dumps
> the currently running processes into a date/time stamped text file, new
> for each time it runs, then you could set it up in the system scheduler
> to run every "x" number of minutes.  You could schedule it to start
> running at something like 1:00am.  It might help to isolate exactly what
> processes are running just before the lock-up and give you some more
> information to work with.  I'm guessing that it's a process and not
> something like the /tmp location getting "full" for some reason.
> 
> Good luck.
> BobW
> 
> 
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King
> Sent: Wednesday, January 16, 2013 10:40 AM
> To: U2 Users List
> Subject: [U2] Unidata 6.1.13/AIX 5.3 Stops Unexpectedly
> 
> We have a customer with a box as described in the subject that has
> recently been experiencing something odd.  Overnight, the system will
> just lock up and stop responding.  Normally there isn't anyone doing
> anything at night; the backup runs, that sort of thing, but then some
> days when they come in early in the morning the entire machine is
> unresponsive.  Connecting with telnet there is no login prompt, just a
> blank screen.  It happened last night and I've confirmed from the logs
> that the backup (which is using a split mirror backup strategy) ran
> successfully and finished at 2:02am.
>  Sometime between then and 4am, when there really should not have been
> anything going on, it just locked up.
> 
> Are there any logs that can be enabled on AIX to record some evidence
> for these kinds of failures so we can figure out what's going on with
> this machine?
> 
> -K
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
  
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] UV Job Listing

[Dan Fitzgerald]

Well, it IS an aerospace company, building fighter jet parts and helicopter 
stuff. which is why I steered clear, being a pacifist. But, yeah, you'd have to 
prioritize skulls.

> Date: Sat, 6 Oct 2012 16:06:22 -0400
> From: aeger...@pobox.com
> To: u2-users@listserver.u2ug.org
> 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 ".
> 
> Prioritizing SKULLS:
> That's easy - first on that list is my ex-wife...
> 
> 
> Dan, tell Larry I said "hi".
> 
> 
> -- 
> Allen Egerton; aegerton -at- pobox.com
> 
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
  
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

[U2] UV Job Listing

[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@endecaindex&source=3
Location:Washington, DC Area Code:202 Telecommute:no Travel Required:25% 
Skills:IT Manager VPN systems, Proxy Server-ISA, Firewall, Domain Control, 
Java, PHP, MSSQL, ASP, FLEX, XML, ERP, Pay Rate:Based on Experience Tax 
Term:FULLTIME Length: Date Posted:10-2-2012 Position ID:wspos890801 Dice 
ID:RTX17aefc Company Overview: For the past forty years Alenia Aermacchi North 
America, Inc. has established a renowned presence in the North American 
aerospace industry. A subsidiary of Alenia Aermacchi and part of the 
Finmeccanica Group, Alenia Aermacchi North America's mission is to be the 
partner of choice in the North American aerospace market. Focused on managing 
Alenia Aermacchi*s industrial assets and introducing new products in the U.S. 
and Canada, Alenia Aermacchi North America is dedicated to the further 
expansion of the industrial and commercial presence of the Alenia Aermacchi 
Group in North America. Alenia Aermacchi North America operates throughout 
North America with multiple locations in the United States.We at Alenia 
Aermacchi North America are always looking for bright, qualified people and 
there has never been a more exciting time to join our team. In addition to 
working with some of the industry's most innovative aerospace programs 
currently being developed and produced, we provide an exciting multi-cultural 
environment and one of the richest benefits packages available. To be 
considered for the position please send your resume along with a cover letter 
to employm...@aleniainc.com. Position Summary: Alenia Aermacchi North America, 
Inc. is seeking an IT Manager to oversee its IT needs in terms of 
infrastructure and application requirements. This person will work directly 
with Executive management to develop strategies and implement new technologies 
to streamline business operations and make the company more efficient and 
effective. This will be a great position for someone that loves IT, is 
self-motivated and enjoys collaborating with departments to enhance 
productivity and operations. As the primary IT professional in the company this 
person will be responsible for managing projects, finding vendors and drawing 
upon your knowledge as well as third party resources to implement new 
technology as well as manage existing systems. The IT Manager will oversee IT 
related projects and advise on ways to improve our processes using technology. 
Integrate and maintain multiple different systems, such as our ERP system 
(currently Deltek CostPoint), VoIP phone systems, fax servers, hosted email, 
and other technology. The candidate must have a strong background in IT 
management with specific focus on Infrastructure development and management, 
database administration, ERP systems, and management capabilities. Good 
knowledge of Deltek is desirable and a general understanding of SAP environment 
is a plus. We are looking for a self-motivated, multi-tasker with strong 
organization capabilities and focus. This is a fun and creative job for a 
person with a strong background in pulling data from multiple sources to create 
user friendly systems to provide information to users, as well as source new 
information and resources to complete your tasks and projects in a timely 
fashion and within budget. Duties: ?Manage Company infrastructure for the 
various locations (network, VPN systems, Proxy Server ISA-, Firewall, Domain 
Control, ..), proposing and executing potential improvements ?Collaborates with 
departments in the company to collect internal requirements with the goal to 
improve systems and processes ?Develop tools to enhance data automation, 
cooperating, if necessary, with external providers?Key participant in change 
management process by ensuring all productions changes are fully tested, 
approved, and implemented accurately to maintain database uptime ?Coordinate 
with ERP vendor for maintenance and upgrade issues and coordinate any IT 
development project ?Manage data integrity through database backups and 
disaster recovery plans ?Provide internal users with data and reports to 
improve operations, integrating ERP system data with other possible external 
sources ?System administrator for the ERP and Reporting tools, managing users 
profile ?Perform break/fix and desktop support: Troubleshooting Email, Office 
Productivity Software ?Based on the Company requirements, research IT and 
technology solutions in various areas such as: - ERP Software add on and 
integration with external systems - Access Control and Time & Attendance 
Software - Customer Service solutions for tracking warranties and complaints 
Skills/Qualifications: ?Bachelor's degree in Com

Re: [U2] Mysterious UV Error

[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 to AIX. The output will be a 
little bit large & somewhat cryptic, but I have the rosetta stone on my desk at 
work, so if you paste the output into a doc & send it to me, I'll be happy to 
take a look. It's possible that the issue won't be apparent because it occurs 
entirely inside uv programming (you can execute some lines of code without 
making a system call), but since it only occurs when instantiating uv from the 
aix prompt, there's probably something to see.
 
> Date: Fri, 17 Aug 2012 14:16:25 -0600
> From: j...@fitzlong.com
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] Mysterious UV Error
> 
> Hi Allen,
> 
> Thanks for your thought.  It does look like that, except the same error
> happens with any command - "TIME", "DATE", etc. all produce the verb "60"
> not in your VOC message
> 
> Jeff
> 
> On Fri, Aug 17, 2012 at 2:02 PM, Allen Egerton  wrote:
> 
> > Hi Jeff,
> >
> > Almost sounds like perhaps it's piping the results of the COUNT back
> > into stdin and re-processing it as a command.
> >
> >
> >
> >
> > On 8/17/2012 3:46 PM, Jeff Fitzgerald wrote:
> > > I have a client who's seeing a very odd UniVerse error.  Any thoughts
> > about
> > > it would be most appreciated!
> > >
> > > This is a UNIX server running AIX 5.3 and UniVerse 10.2.7.
> > >
> > > The UniVerse home directory is at /u1/uv - the following command is
> > entered
> > > at the UNIX prompt:
> > >
> > > # /u1/uv/bin/uv "COUNT VOC"
> > >
> > > the response is:
> > >
> > > Verb "60" is not in your VOC.
> > >
> > > Things I've checked:
> > >
> > > *  There is no LOGIN record in the account VOC
> > >
> > > *  There is no UV.LOGIN record in the uv account VOC
> > >
> > > *  Same response when the command is run in various accounts, including
> > uv
> > >
> > > *  /u1/uv/bin/uv is an executable file and not a script
> > >
> > > This one has me scratching my head.  The actual problem is with a C
> > program
> > > that forks a child to execute a UV session - the child dies with the same
> > > error...
> > >
> > > Probably something obvious that I can't see.  Help me out please!
> > >
> > > Jeff Fitzgerald
> > > Fitzgerald & Long, Inc.
> > >
> > > www.fitzlong.com
> > > j...@fitzlong.com
> > > ___
> > > U2-Users mailing list
> > > U2-Users@listserver.u2ug.org
> > > http://listserver.u2ug.org/mailman/listinfo/u2-users
> > >
> >
> > ___
> > U2-Users mailing list
> > U2-Users@listserver.u2ug.org
> > http://listserver.u2ug.org/mailman/listinfo/u2-users
> >
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
  
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] RESIZE - dynamic files

[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 pretty nearly 
twice the data size.
 
The goal can vary according to your situation. I'm personally not all that 
afraid of making the modulus a little too large, as overflow is a pretty bad 
performance hit (overflow means at least two disk reads to retrieve your data, 
"badly" means at least 2 extra disk reads, and I've seen files where that was 
thousands (this file isn't that bad, but 20% of your data is forcing at least 
one extra disk read). Empty groups contribute to overhead on a sequential 
search, so you'd want to consider how often you do a sequential search on a 
file - usually, that's a pretty inefficient way to retrieve data, but, again, 
your mileage may vary. 
 
To me, 20% is too much overflow, and 114 empty groups is trivial; much less 
than 0.2%. I'd be tempted to go to 23 as a minimum Mod, just to see what it 
looks like there. That'll give you an average of 6 records per 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 an acceptable % of overflow for a 
> dynamic file? For example, when I change the SPLIT LOAD to 90% (while using 
> the calculated min modulus)
> I'm still left with ~ 20% of overflow (see below). Is 20% overflow considered 
> acceptable on average or should I keep tinkering with it to reach a lower 
> overflow %?
> 
> Correct me if I'm wrong but it seems the goal here is to REDUCE the overflow 
> % while not creating too many modulus (groups). 
> 
> Chris
> 
> 
> File name ..   GENACCTRN_POSTED
> Pathname ...   GENACCTRN_POSTED
> File type ..   DYNAMIC
> File style and revision    32BIT Revision 12
> Hashing Algorithm ..   GENERAL
> No. of groups (modulus)    105715 current ( minimum 103889, 114 empty,
> 21092 overflowed, 1452 badly )
> Number of records ..   1290469
> Large record size ..   3267 bytes
> Number of large records    180
> Group size .   4096 bytes
> Load factors ...   90% (split), 50% (merge) and 70% (actual)
> Total size .   522260480 bytes
> Total size of record data ..   287400239 bytes
> Total size 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 anything here, since it is more than the 
> > actual load.  What your overflow suggests is that you lower the split.load 
> > value to 70$% or below.  You could go ahead and set the merge.load to an 
> > arbitrarily low number ("1"), and it will probably never do a merge, which 
> > would be the same as specifying a minimum.modulus equal to "as large as it 
> > ever gets".  The exception to this is during file creation & clear.file,  
> > when the minimum.modulus value determines the initial disk allocation.  
> > Short of going to an arbitrarily large minimum.modulus, and a very low 
> > split.load, you are going to have some overflow (unless you have sequential 
> > keys & like sized records).
> > 
> > -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 12:54 PM
> > To: u2-users@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    32BIT Revision 12
> > Hashing Algorithm ..   GENERAL
> > No. of groups (modulus)    103889 current ( minimum 103889, 114 empty,
> > 22249 overflowed, 1764 badly )
> > Number of records ..   1290469
> > Large record size ..   3267 bytes
> > Number of large records    180
> > Group size .   4096 bytes
> > Load factors ...   90% (split), 50% (merge) and 72% (actual)
> > Total size .   519921664 bytes
> > Total size of record data ..   287400591 bytes
> > Total size of record IDs ...   21508497 bytes
> > Unused space ...   211004384 bytes
> > Total space 

Re: [U2] RESIZE - dynamic files

[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 modulus should be a 
prime north of the current modulus, with a padding factor based on growth 
expectations. The sweet spot is where you have enough data in each group to 
avoid merging (I'd argue that 50% is a bit high for the merge; but that's 
because I'm unafraid of unused space, while I'm averse to file maintenance 
overhead), but not so much that you do a lot of splitting. You should do a 
count on the number of records, too. It almost never makes sense to have the 
modulus exceed the number of records by a substantial percentage.
 
So, you should increase minimum modulus to 83267 or higher, unless you double 
the group size to 8K, in which case something around 50K as a modulus sounds 
good. 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.
 
> 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 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 style and revision    32BIT Revision 12
> Hashing Algorithm ..   GENERAL
> No. of groups (modulus)    83261 current ( minimum 31 )
> Large record size ..   3267 bytes
> Group size .   4096 bytes
> Load factors ...   80% (split), 50% (merge) and 80% (actual)
> Total size .   450613248 bytes
> 
> How
>  do you calculate what the modulus and separation should be? I can't use
>  HASH.HELP on a type 30 file to see the recommended settings
> so I was wondering how best you figure out the file RESIZE.
> 
> Thanks,
> 
> Chris   
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
  
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] READU vs READ

[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 chains out 
into West Jibip. The disks/file systems you're writing to aren't more than 85% 
full? Attaching new disk pages to the dynamic file as it grows can be a 
bottleneck in that scenario...
 > Date: Mon, 30 Apr 2012 21:35:47 -0400
> From: dlaan...@hubbardsupply.com
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] READU vs READ
> 
> It's a dynamic file. FILE-STAT shows no overflow.
> 
> Sincerely,
> David Laansma
> IT Manager
> Hubbard Supply Co.
> Direct: 810-342-7143
> Office: 810-234-8681
> Fax: 810-234-6142
> www.hubbardsupply.com
> "Delivering Products, Services and Innovative Solutions"
> 
> 
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Buss, Troy
> (Contractor, Logitek Systems)
> Sent: Monday, April 30, 2012 9:12 PM
> To: U2 Users List
> Subject: Re: [U2] READU vs READ
> 
> Inefficient file sizing and disk I/O are your possible issues with
> slowness.   You might be able to address the first at your desk, the
> latter may require a purchase order. How old is your hardware?
> 
> We recently upgraded to a virtual server and just using more current
> technology hard drives we doubled all of our disk I/O from what we had 5
> or 6 years ago.  CPU speed increased as well, but that was not as
> suprising.
> 
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Laansma
> Sent: Monday, April 30, 2012 6:01 PM
> To: U2 Users List
> Subject: Re: [U2] READU vs READ
> 
> Yes, using SELECT and READNEXT. These are sizable records. The logic is
> very straight forward, just updating several multi-valued fields in each
> record (month end).
> 
> 500,000 have been updated and I'm 2:45:00 into the process.
> 
> 
> 
> _
> Scanned by IBM Email Security Management Services powered by
> MessageLabs. For more information please visit http://www.ers.ibm.com
> 
> This email is intended only for the use of the party to which it is
> addressed and may contain information that is privileged, confidential,
> or protected by law.  If you are not the intended recipient you are
> hereby notified that any dissemination, copying or distribution of the
> email or its contents is strictly prohibited.  If you have received this
> message in error, please notify us immediately, by replying to the
> message and deleting it from your computer.
> 
> WARNING: Internet communications are not assured to be secure or clear
> of inaccuracies as information could be intercepted, corrupted, lost,
> destroyed, arrive late or incomplete, or contain viruses.  Therefore, we
> do not accept responsibility for any errors or omissions that are
> present in this email, or any attachment, that have arisen as a result
> of e-mail transmission.
> 
> _
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
  
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] READU vs READ

[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 a "truss -pdf 
pid" to see every system call made by the process, along with a time stamp 
telling you the time delta between each system call.
  > Date: Mon, 30 Apr 2012 21:01:07 -0400
> From: dlaan...@hubbardsupply.com
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] READU vs READ
> 
> Yes, using SELECT and READNEXT. These are sizable records. The logic is
> very straight forward, just updating several multi-valued fields in each
> record (month end).
> 
> 500,000 have been updated and I'm 2:45:00 into the process.
> 
> Sincerely,
> David Laansma
> IT Manager
> Hubbard Supply Co.
> Direct: 810-342-7143
> Office: 810-234-8681
> Fax: 810-234-6142
> www.hubbardsupply.com
> "Delivering Products, Services and Innovative Solutions"
> 
> 
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Buss, Troy
> (Contractor, Logitek Systems)
> Sent: Monday, April 30, 2012 8:48 PM
> To: U2 Users List
> Subject: Re: [U2] READU vs READ
> 
> Depends on how much  you have...   Seriously, I would
> guess that your bottleneck is disk access.
> 
> Are you using basic SELECT and READNEXT ?   Is your list in sorted order
> (SSELECT) or not (SELECT).
> 
> Processing the updates in group order will minimize the I/O.   I don't
> think the READU overhead on today's machines are anything that would
> slow it down.   I just tested 100,000 records with and without locking
> and I get six seconds both ways.   Because it was cached data, my test
> eliminates disk i/o and measures the lock overhead which seems to be
> negligible on universe 11.1.1.
> 
> 
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Laansma
> Sent: Monday, April 30, 2012 5:33 PM
> To: U2-Users@listserver.u2ug.org
> Subject: [U2] READU vs READ
> 
> If I don't HAVE TO lock a record before modifying it writing it back,
> will a program run significantly faster if I just WRITE it back without
> locking it first? I'm updating about 700,000 records and it's just
> taking TOO long.
> 
>  
> 
> I DO understand the risks of other users changing the record's content
> during so let's not go down that road. I'm interested in the SPEED
> dialog.
> 
>  
> 
> Thank you folks!
> 
>  
> 
> Sincerely,
> 
> David Laansma
> 
> IT Manager
> 
> Hubbard Supply Co.
> 
> Direct: 810-342-7143
> 
> Office: 810-234-8681
> 
> Fax: 810-234-6142
> 
> www.hubbardsupply.com  
> 
> "Delivering Products, Services and Innovative Solutions"
> 
>  
> 
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
> 
> 
> _
> Scanned by IBM Email Security Management Services powered by
> MessageLabs. For more information please visit http://www.ers.ibm.com
> 
> This email is intended only for the use of the party to which it is
> addressed and may contain information that is privileged, confidential,
> or protected by law.  If you are not the intended recipient you are
> hereby notified that any dissemination, copying or distribution of the
> email or its contents is strictly prohibited.  If you have received this
> message in error, please notify us immediately, by replying to the
> message and deleting it from your computer.
> 
> WARNING: Internet communications are not assured to be secure or clear
> of inaccuracies as information could be intercepted, corrupted, lost,
> destroyed, arrive late or incomplete, or contain viruses.  Therefore, we
> do not accept responsibility for any errors or omissions that are
> present in this email, or any attachment, that have arisen as a result
> of e-mail transmission.
> 
> _
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
  
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] READU vs READ

[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 asking about the select 
method; no sense in processing the same data multiple times, so that's the 
first thing to eliminate. The second is file sizing. If you have to follow 
dozens of links to read & write for each record, that consumes a ton of 
resources. You'll see that in the FILE.USAGE report, or you could just look at 
ANALYZE.FILE to see if the file is poorly sized.
 > From: troy.b...@nordsonasymtek.com
> To: u2-users@listserver.u2ug.org
> Date: Mon, 30 Apr 2012 20:47:59 -0400
> Subject: Re: [U2] READU vs READ
> 
> Depends on how much  you have...   Seriously, I would guess 
> that your bottleneck is disk access.
> 
> Are you using basic SELECT and READNEXT ?   Is your list in sorted order 
> (SSELECT) or not (SELECT).
> 
> Processing the updates in group order will minimize the I/O.   I don't think 
> the READU overhead on today's machines are anything that would slow it down.  
>  I just tested 100,000 records with and without locking and I get six seconds 
> both ways.   Because it was cached data, my test eliminates disk i/o and 
> measures the lock overhead which seems to be negligible on universe 11.1.1.
> 
> 
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org 
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Laansma
> Sent: Monday, April 30, 2012 5:33 PM
> To: U2-Users@listserver.u2ug.org
> Subject: [U2] READU vs READ
> 
> If I don't HAVE TO lock a record before modifying it writing it back, will a 
> program run significantly faster if I just WRITE it back without locking it 
> first? I'm updating about 700,000 records and it's just taking TOO long.
> 
>  
> 
> I DO understand the risks of other users changing the record's content during 
> so let's not go down that road. I'm interested in the SPEED dialog.
> 
>  
> 
> Thank you folks!
> 
>  
> 
> Sincerely,
> 
> David Laansma
> 
> IT Manager
> 
> Hubbard Supply Co.
> 
> Direct: 810-342-7143
> 
> Office: 810-234-8681
> 
> Fax: 810-234-6142
> 
> www.hubbardsupply.com  
> 
> "Delivering Products, Services and Innovative Solutions"
> 
>  
> 
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
> 
> _
> Scanned by IBM Email Security Management Services powered by MessageLabs. For 
> more information please visit http://www.ers.ibm.com
> 
> This email is intended only for the use of the party to which it is addressed 
> and may contain information that is privileged, confidential, or protected by 
> law.  If you are not the intended recipient you are hereby notified that any 
> dissemination, copying or distribution of the email or its contents is 
> strictly prohibited.  If you have received this message in error, please 
> notify us immediately, by replying to the message and deleting it from your 
> computer.
> 
> WARNING: Internet communications are not assured to be secure or clear of 
> inaccuracies as information could be intercepted, corrupted, lost, destroyed, 
> arrive late or incomplete, or contain viruses.  Therefore, we do not accept 
> responsibility for any errors or omissions that are present in this email, or 
> any attachment, that have arisen as a result of e-mail transmission.
> _
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
  
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Case Statement with only two cases

[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 I code (or 
review code), I'm not so much looking to wrest out every last system call 
(although I still do it out of habit), I'm just looking to make sure there are 
no egregious errors that will affect performance (or stability, or...), like 
executing a select instead of doing an internal one. Given a minimum of 
self-created bottlenecks, disk IO is still the limiting factor, (usually) not 
CPU cycles, especially if your OS isn't bloatware. In a few short years, we'll 
have solid state disks and a new set of problems. BTW, anyone see IBM's new 
offering, Pure System? In many ways, a 180 degree turn: everything is back in 
one rack: cpu's, storage, networking... 
 > Date: Fri, 20 Apr 2012 08:27:48 -0500
> From: stevenson.c...@gmail.com
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] Case Statement with only two cases
> 
> A respectful correction, Brian.
> 
> On 4/20/2012 4:50 AM, Brian Leach wrote:
> > it's all the same to the compiler.
> > -Original Message-
> > BEGIN CASE
> >CASE A = "TEST"; GOSUB DO.SOMETHING
> >CASE 1; GOSUB DO.SOMETHING.ELSE
> > END CASE
> > versus this
> > IF A = "TEST" THEN GOSUB DO.SOMETHING ELSE GOSUB DO.SOMETHING.ELSE
> -
> 
> Since we seem to be finding every nit in the bottom of this empty 
> barrel, here's one more.
> There are 2 compiler difference as shown by VLIST (UV10.2):
> 
> 1: BEGIN CASE
> 
> 2:CASE A = "TEST"; GOSUB DO.SOMETHING
> 2 0 : 06E eq A "TEST"  => $R0
> 2 8 : 2DE testfw $R0 00020:
> 2 00010 : 0A4 gosub  00060:
> 
> 
> 3:CASE 1; GOSUB DO.SOMETHING.ELSE
> 3 00018 : 0C2 jump   00038:
> 3 00020 : 2DE testfw 1 00038: <-- Extra 
> worthless test
> 3 00028 : 0A4 gosub  00062:
> 
> 4: END CASE
> 4 00030 : 0C2 jump   00038: <-- Extra worthless 
> jump (to next line)
>
> (Source lineup is goofy.  This jump is really part
>  
> of source line 3.   RAID is confusing, too.
> A 
> discussion for a different thread.)
> 
> 5: IF A = "TEST" THEN GOSUB DO.SOMETHING ELSE GOSUB DO.SOMETHING.ELSE
> 5 00038 : 06E eq A "TEST"  => $R0
> 5 00040 : 2DE testfw $R0 00058:
> 5 00048 : 0A4 gosub  00060:
> 5 00050 : 0C2 jump   00060:
> 5 00058 : 0A4 gosub  00062:
> 
> 6: STOP
> 6 00060 : 190 stop
> 
> 
> With the speed of today's machines it would be hard to find a place 
> where that performance makes a difference.
> 
> Rocket could theoretically clean up both (or either independently) if 
> the compiler was smart enough:
> 
> 1. to know that a logical test outcome was predestined at compile time 
> (It already does that sort of thing in other situations.).  Then it 
> could  compile only 1 of the 2 paths the testfw takes.  (e.g. 0020x).  
> Same for IF,  WHILE, or UNTIL constructs.
> 
> 2. To recognize the final CASE before the END CASE never needs to jump 
> (e.g., 0030x).
> 
> I wonder if we've already wasted more electrical & biological energy by 
> me writing this email, dispersing it around the globe, and you reading 
> it, than all the machine cycles wasted executing the 2 worthless tests 
> in all the object scattered around the universe that Rocket could 
> theoretically optimize.
> 
> cds
> 
> 
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
  
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[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 -0600
> Subject: Re: [U2] Extract first and last name from free-form name
> 
> This thread reminded me of a blog posting I ran across a while ago. His 
> basic premise is that most of our assumptions about names are incorrect, 
> which makes coding a computer to handle them properly is really tough if 
> not impossible. Don't skip the comments section, there's some good stuff 
> there.
> 
> http://www.kalzumeus.com/2010/06/17/falsehoods-programmers-believe-about-names
> 
> 
> 
> U.S. BANCORP made the following annotations
> -
> Electronic Privacy Notice. This e-mail, and any attachments, contains 
> information that is, or may be, covered by electronic communications privacy 
> laws, and is also confidential and proprietary in nature. If you are not the 
> intended recipient, please be advised that you are legally prohibited from 
> retaining, using, copying, distributing, or otherwise disclosing this 
> information in any manner. Instead, please reply to the sender that you have 
> received this communication in error, and then immediately delete it. Thank 
> you in advance for your cooperation.
> 
> 
> 
> -
> 
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
  
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] HP UX to IBM AIX questions

[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 files; folks 
are often alarmed to see only a few Mb of RAM free.
 
I hope you're looking at the new Power Blades (JS70x) in the Blade H center 
under PowerVM: sweee---eee---eet.
 
> From: bl...@shaklee.com
> To: u2-users@listserver.u2ug.org
> Date: Fri, 21 Oct 2011 09:52:45 -0700
> Subject: [U2] HP UX to IBM AIX questions
> 
> Hi All,
>  
> We are considering going from our HP 9000 systems to IBM AIX. What has to be
> done to make that happen?   Do we need to recompile our source code? Are
> there any licensing issues? Is the data transportable or do we need to
> massage it? What about the dict items? Any other gotcha's?
>  
> Is this an easy or difficult?
>  
> Thanks,
> Bruce Lunt
>  
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
  
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Universe File Issue

[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 you hit the 
broken part, try to use fixtool to (first) rebuild the forward and/or backward 
link, or (second) truncate the group. One trick that might work is to write a 
basic program that sequentially processes the file, writing a record to a new 
file, then deleting that record from the original (make a backup first). This 
will shrink the file as you go. You'll still have at least one broken 
flink/blink somewhere.
 

> From: tewhitm...@ratex.com
> To: u2-users@listserver.u2ug.org
> Date: Tue, 11 Oct 2011 08:01:56 -0400
> Subject: Re: [U2] Universe File Issue
> 
> Hi John,
> You do have several options, depending on your company's needs.
> 1) purge
> 2) convert the file to 64 bit so it can grow over 2 gigs (modify uvconfig 
> 64BIT_FILES parameter and then resize the file with the "64BIT" option. (see 
> UniVerse User Reference and Administering UniVerse documents from Rocket)
> 3) convert to a multi-part file. This allows you to break up a file based on 
> an i-descriptor, but I couldn't find details during my quick search. It would 
> be the most complicated to implement of the three, if it hasn't been 
> deprecated by Rocket.
> 
> Tom
> 
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org 
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Varney
> Sent: Tuesday, October 11, 2011 7:29 AM
> To: 'U2 Users List'
> Subject: [U2] Universe File Issue
> 
> I inherited a system running UniVerse over windows 2003 Server.
> 
> I have a history file that seems corrupt. It's just over 2 gigs in size (The 
> problem I believe) and fixfile and uvfixfile won't work on it.
> 
> I'm thinking the size of the file needs to shrink a bit before I can do 
> anything with it. Thoughts?
> 
> John Varney
> Integra Life Sciences
> 
> 
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
  
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[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 terribly 
sized static file, which brings us back to the original subject: use a tool 
like FAST, and maintain your files, whether static or dynamic.
 
> From: johnisr...@daytonsuperior.com
> To: u2-users@listserver.u2ug.org
> Date: Tue, 4 Oct 2011 20:52:25 -0400
> Subject: Re: [U2] FAST (File Analysis and Sizing Tool)
> 
> Especially when mass loading a big but empty file!
> 
> John Israel
> 
> Sent from my iPhone
> 
> On Oct 4, 2011, at 8:50 PM, "Allen Egerton"  wrote:
> 
> > MINIMUM.MODULUS can be your friend...
> >
> >
> > On 10/4/2011 7:27 PM, Susan Lynch wrote:
> >> Eric, yes, in my experience, they do need resizing, particularly if they
> >> are very large files, which are the only ones I generally make dynamic.
> >>
> >> We have had issues with small dynamic files getting cleared by one user
> >> and updated by another user, and the resultant modulo being incorrect
> >> (usually off by 2 groups), so  I try very hard not to use dynamic files
> >> for small files that may be cleared.  That does not happen to us with
> >> static files, so I make them static and the problem does not recur.
> >
> 
> 
> 
> 
> John Israel
> Senior ERP Developer
> 
> Dayton Superior Corporation
> 1125 Byers Rd
> Miamisburg, OH 45342
> 
> 937-866-0711 x44380 (O)
> 937-865-9182 (F)
> 
> 
> This message w/attachments (message) is intended solely for the use of the 
> intended recipient(s) and may contain information that is privileged, 
> confidential or proprietary. If you are not an intended recipient, please 
> notify the sender, and then please delete and destroy all copies and 
> attachments, and be advised that any review or dissemination of, or the 
> taking of any action in reliance on, the information contained in or attached 
> to this message is prohibited.
> 
> 
> ___
> > U2-Users mailing list
> > U2-Users@listserver.u2ug.org
> > http://listserver.u2ug.org/mailman/listinfo/u2-users
> >
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
  
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[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
 

> Date: Tue, 4 Oct 2011 09:57:36 -0600
> From: jscha...@gmail.com
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] FAST (File Analysis and Sizing Tool)
> 
> I've been using FAST pretty much since it has existed and I highly 
> recommend it for anyone using U2 databases. Also the folks at Fitzgerald 
> and Long are fantastic people whom I have known since the Prime 
> Information days.
> 
> Eric Armstrong wrote:
> > Would anyone who is using FAST (File Analysis and Sizing Tool) care to 
> > comment about it? Experiences with it, plus and minuses? Does it deliver as 
> > advertised?
> >
> > Thanks in advance,
> >
> > Eric Armstrong
> > Programmer/Analyst
> > Lobel Financial
> >
> >
> > -Original Message-
> > From: u2-users-boun...@listserver.u2ug.org
> > [mailto:u2-users-boun...@listserver.u2ug.org]On Behalf Of
> > u2-users-requ...@listserver.u2ug.org
> > Sent: Monday, October 03, 2011 12:00 PM
> > To: u2-users@listserver.u2ug.org
> > Subject: U2-Users Digest, Vol 30, Issue 2
> >
> >
> > Send U2-Users mailing list submissions to
> > u2-users@listserver.u2ug.org
> >
> > To subscribe or unsubscribe via the World Wide Web, visit
> > http://listserver.u2ug.org/mailman/listinfo/u2-users
> > or, via email, send a message with subject or body 'help' to
> > u2-users-requ...@listserver.u2ug.org
> >
> > You can reach the person managing the list at
> > u2-users-ow...@listserver.u2ug.org
> >
> > When replying, please edit your Subject line so it is more specific
> > than "Re: Contents of U2-Users digest..."
> >
> >
> > Today's Topics:
> >
> > 1. Re: [uv] from uv/linux, execute a remote mysql/sql stmt ?
> > (Tony Gravagno)
> > 2. Re: [uv] from uv/linux, execute a remote mysql/sql stmt ?
> > (Kevin King)
> > 3. Re: [uv] from uv/linux, execute a remote mysql/sql stmt ?
> > (George Gallen)
> > 4. Re: [uv] from uv/linux, execute a remote mysql/sql stmt ?
> > (George Gallen)
> > 5. Re: [uv] from uv/linux, execute a remote mysql/sql stmt ?
> > (Symeon Breen)
> >
> >
> > --
> >
> > Message: 1
> > Date: Sun, 2 Oct 2011 14:51:55 -0700
> > From: "Tony Gravagno" <3xk547...@sneakemail.com>
> > To: u2-users@listserver.u2ug.org
> > Subject: Re: [U2] [uv] from uv/linux, execute a remote mysql/sql stmt
> > ?
> > Message-ID: <4876-1317592318-754...@sneakemail.com>
> > Content-Type: text/plain; charset="us-ascii"
> >
> > The easy answer is to pretend you're doing this from a web page,
> > where the MP in LAMP is MySQL and PHP. From there you have a
> > world full of answers rather than something U2-specific. Note
> > that most shared hosts don't have a MySQL DBMS on the same system
> > as the HTTP servers. They almost Always separate MySQL to a
> > different box for queries, so examples for how to do this are
> > plentiful.
> >
> > So write a small PHP script that does what you need, copy/paste
> > from examples if required. Then invoke the script with a simple
> > "SH" or "!" to execute the script, passing in params. Capture
> > the result with an Execute Capturing clause, or have the script
> > write data to a directory which you reference as a type 1 or type
> > 19.
> >
> > That's it. This one is fairly easy - just think outside of the
> > MV box.
> >
> > HTH
> > T
> >
> > From: Manu Fernandes
> > 
> >> From Universe/linux, I'll execute a mySQL sql phrase.
> >> mySQL is installed on a remote server.
> >>
> >> - What is the mysql-client to be installed beside
> >> Universe ?
> >> - How to execute a sql-phrase from UV/BASIC
> >> ? and capture the result !?
> >> 
> >
> >
> >
> > --
> >
> > Message: 2
> > Date: Sun, 2 Oct 2011 19:32:30 -0600
> > From: Kevin King 
> > To: U2 Users List 
> > Subject: Re: [U2] [uv] from uv/linux, execute a remote mysql/sql stmt
> > ?
> > Message-ID:
> > 
> > Content-Type: text/plain; charset=ISO-8859-1
> >
> >

Re: [U2] Ardent programmers

[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.. (borderline humor)
> 
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org 
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson
> Sent: Friday, September 09, 2011 11:07 AM
> To: U2 Users List
> Subject: Re: [U2] Ardent programmers
> 
> I heard he designed and implemented the original Universe.
> He left a rather hefty manual.
> It was updated after his last visit.
> 
> On 9/9/2011 8:23 AM, Glenn Sallis wrote:
> > I guess he must be freelance.
> >
> > Am 09.09.2011 15:21, schrieb George Gallen:
> >> That JC programmer must work in a lot of placesbecause I hear lot's
> >> Of people calling for him, at all hours of the day!
> >>
> >> -Original Message-
> >> From: Phil Walker
> >> Sent: Thursday, September 08, 2011 9:33 PM
> >>
> >> PVW is me Phil Walker
> >> DSM might be David Meeks
> >> WLC is probably Wendy Cleary
> >> JC Jesus Christ ;-)
> >>
> >> Others cannot remember
> 
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
  
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[Dan Fitzgerald]

Well, I'm gonna start asking my linux questions HERE. Every linux geek I asked 
said it couldn't be done...
 
> Date: Fri, 2 Sep 2011 12:37:28 -0400
> From: jthompson...@gmail.com
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] Red Hat Enterprise Linux 64 bit and Universe 11.1.4 -   
> Experiences?
> 
> Well there ya go.  I stand corrected.  I was probably getting confused with
> "shrinking" vs. "extending".  I think to shrink you have to unmount.
> 
> My mistake.
> 
> On Fri, Sep 2, 2011 at 12:33 PM, Michael Pflugfelder  > wrote:
> 
> > With RedHat 5, LVM & EXT3 filesystems, you can do online resizing.
> >
> > First, you need to increase the size of the logical volume with "lvextend".
> > Then you need to resize the filesystem with "resize2fs".
> >
> > I did it a few weeks ago on a virtual machine without users noticing any
> > difference.
> >
> >
> >
> > -Original Message-
> > From: u2-users-boun...@listserver.u2ug.org [mailto:
> > u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson
> > Sent: Friday, September 02, 2011 9:34 AM
> > To: U2 Users List
> > Subject: Re: [U2] Red Hat Enterprise Linux 64 bit and Universe 11.1.4 -
> > Experiences?
> >
> > I believe with EXT4, JFS, or XFS filesystems you can expand them only -
> > while it is mounted.
> >
> > However if you are running RHEL 5 with EXT3, then you have to unmount the
> > partition before you expand.  JFS is of course what AIX uses.  You can use
> > JFS in Linux, if you set your filesystems up that way originally.
> >
> > I also assume you are using LVM along with a filesystem to manage things...
> >
> > See these notes:
> >
> > http://en.gentoo-wiki.com/wiki/LVM
> > http://tldp.org/HOWTO/LVM-HOWTO/extendlv.html
> >
> > http://docs.redhat.com/docs/en-US/Red_Hat_Enterprise_Linux/6/html/Storage_Administration_Guide/ext4grow.html
> >
> > By the way, I've always thought Gentoo and Ubuntu had great documentation.
> >  Red Hat is getting better...
> >
> > In this case, the filesystem and lvm2 utilities should be 99% the same
> > across all Linux distro's, so you can find out what you need to know on
> > Gentoo or Ubuntu docs, even though its RHEL.  That is not always the case...
> >
> > As far as the cost goes... you are probably right, since, I don't have the
> > guts to not pay for Linux support and just download CentOS.
> > http://www.centos.org/
> >
> > However, for us, its more a matter of flexibility and standardization.  I
> > have Linux machines (mainly Ubuntu) doing critical business functions
> > already, and if I can have one less operating system to worry about, thats
> > less headache for me.
> >
> > Plus its way cheaper for me to set up a development machine on the fly on
> > my workstation using CentOS.  Its nigh impossible to do that with AIX.
> >
> > AIX is great, until you need to use an open source piece of 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 stuck with going through rpm hell.
> >
> > We have a pretty barebones AIX setup with zero LPAR's and local disk on one
> > P550.
> > So yeah I agree, on paper the cost is almost a wash, but, for us its all of
> > the costs that I can't really show on paper very well...
> >
> >
> > On Thu, Sep 1, 2011 at 11:48 PM, Dan Fitzgerald  > >wrote:
> >
> > >
> > > 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 proposed replacing my 2 p570's (4 LPARS each) with a
> > > Blade H center, populated with 2
> > > PS701 Blades, for a little under $75K, including 3-year hardwarew
> > > warranty &
> > > 3 year AIX software 24x7 4Hr onsite maintenance. Additional Power
> > > blades were $14K, but wintel blades could be had for about $7K each,
> > > fitting in the same enclosure. "Membership" for a comparable RH
> > > installation over 3 years was about that same $75K, before you even
> > > buy hardware. 

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

[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 proposed 
replacing my 2 p570's (4 LPARS each) with a Blade H center, populated with 2 
PS701 Blades, for a little under $75K, including 3-year hardwarew warranty & 3 
year AIX software 24x7 4Hr onsite maintenance. Additional Power blades were 
$14K, but wintel blades could be had for about $7K each, fitting in the same 
enclosure. "Membership" for a comparable RH installation over 3 years was about 
that same $75K, before you even buy hardware. Of course, you can go without 
software support on linux, but you'd better be very good at it, especially if 
your implementation is at all non-standard (um, U2).
 
I also note that one of the most common sysadmin procedures I execute is 
expanding file systems as data footprints grow. On AIX, I allocate the storage, 
do a cfgmgr, then issue the appropriate chfs command. In Linux, to expand a 
file system means taking the volume offline: downtime. P.S.: If I'm wrong about 
that, please tell me how to do it, thanks.
 
> Date: Fri, 2 Sep 2011 00:28:57 +0200
> From: u...@glennsallis.de
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] Red Hat Enterprise Linux 64 bit and Universe 11.1.4 -   
> Experiences?
> 
> Hi John,
> 
> I think you will find it to be a positive move, both technically and 
> financially!
> 
> Recently I have done a fair bit of testing for a customer who are going 
> to be migrating to 64 Bit Red Hat from a non-AIX variant of Unix and I 
> cannot say I stumbled across any big issues. I was using previous 
> versions of 11.1 for the tests.
> 
> Do plenty of trials and tests to identify any potential issues, and I am 
> pretty confident you will report back with positive news.
> 
> Regards
> Glenn
> 
> 
> 
> Am 02.09.2011 00:02, schrieb John Thompson:
> > I'm looking to migrate from AIX 5.3 to RHEL.  Basically because IBM is
> > putting the hatchet to "regular" support on AIX 5.3 in May 2012.
> >
> > Has anyone had any experiences/challenges running Universe 11.1.4 on Red Hat
> > Enterprise 6 - 64bit?
> >
> > I'm guessing I may get crickets on this one, since accroding to U2
> > Techconnect, 11.1.4 has only been out about a week...
> >
> > https://u2tc.rocketsoftware.com/buildmatrix.asp
> >
> > Kudos to Rocket for getting it to run on RHEL 6.
> >
> > I'm just scared if I go with RHEL 5, then I'll be in the "obsolescence" boat
> > two years from now.
> >
> 
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
  
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] 5

[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
> 
> Viagra helps men to save their sexuality and give them another 
> chance... http://www.designtap.org/page.com.php?pID=55z0
> 
> 
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
  
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Job won't run

[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's group list, or someone recompiled 
the ud pgm & changed ownership, ...
 
You're sure that it doesn't even get into the ud program? Could it be trying to 
open a file that it can't for some reason (again, a group change would do this) 
near the top of the program (or trying to execute a sub, etc), then exiting the 
program, returning to the script before it clears the old file?
 

 
> To: u2-users@listserver.u2ug.org
> From: charles_shaf...@ntn-bower.com
> Date: Fri, 5 Aug 2011 11:04:08 -0500
> Subject: Re: [U2] Job won't run
> 
> >> George
> >> Since you say it's sending the same file each day, then it's not
> >> just the Unibasic that is not running, the rm isn't working either,
> >> otherwise, you would be sending a blank file over and over.
> 
> The remove and touch affect the log file.  The data file is cleared in the 
> program.  Since the program doesn't execute, the file doesn't change.
> 
> * Clear the output file
> OUTPUT = "/NTN/DATA/CORPORATE/FILES_AS400/BOWER_FPO"
> PCPERFORM "rm ":OUTPUT
> PCPERFORM "touch ":OUTPUT
> 
> >> How are you running this script from the AS400? rsh? If so, has 
> 
> The actual command on the AS400 is:
> RUNRMTCMD  CMD('/NTN/DATA/CORPORATE/PROCESSES/fpo_as400') 
> RMTLOCNAME('xx.xxx.xxx.xx' *IP)   RMTUSER() RMTPWD() 
> I looked into this one time and the AS400 is running an rsh underneath.
> 
> >> has the user that running it on the AS400 changed? 
> They say no and I believe them because it would have affecteed many jobs.
> This is Redhat and the default shell is bsh.  We run lots of ksh scripts 
> on it.  They were ported over from Tru64 many years ago.
> 
> Charles Shaffer
> Senior Analyst
> NTN-Bower Corporation
> 
> 
> 
> 
> George Gallen 
> Sent by: u2-users-boun...@listserver.u2ug.org
> 08/05/2011 10:34 AM
> Please respond to U2 Users List
>  
> To: U2 Users List 
> cc: 
> Subject:Re: [U2] Job won't run
> 
> 
> Since you say it's sending the same file each day, then it's not
> just the Unibasic that is not running, the rm isn't working either,
> otherwise, you would be sending a blank file over and over.
> 
> How are you running this script from the AS400? rsh? If so, has 
> the user that running it on the AS400 changed? Could they be logging
>   in under the C Shell? I don't know if Korn scripts will run under csh,
>   never really tried it.
> 
> George
> 
> > -Original Message-
> > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> > boun...@listserver.u2ug.org] On Behalf Of charles_shaf...@ntn-bower.com
> > Sent: Friday, August 05, 2011 11:27 AM
> > To: U2 Users List
> > Subject: [U2] Job won't run
> > 
> > I have run into something I have never seen before.   We exchange a lot
> > of
> > data with an AS400 in Chicago.  For many years we have taken the
> > approach
> > that the AS400 would submit a job to our UNIX box that would run a
> > script.
> >  Many of the scripts run a Unibasic program and send the resulting file
> > back to the AS400.  This happens several times a day and we have been
> > doing this for many years.
> > 
> > One job has started doing something odd.  It runs the script and
> > transfers
> > the file, but never runs the Unibasic program, so it has been resending
> > an
> > old version of the file.  This seems to have started happening 3 days
> > ago.
> >  I can log in manually using the same credentials as the remote job,
> > and
> > run the script by typing it in at the command line.  It runs perfectly.
> > Unibasic program runs, new file is sent to the AS400.  There is joy.
> > 
> > I have checked permissions.  Nothing has changed at the AS400 end.
> > Nothing
> > has changed here.  (That we know of).  I have rechecked the code of he
> > script and the Unibasic program.  Looks good.  I am stumped.  Here is
> > the
> > script code.
> > 
> > #!/usr/bin/ksh
> > #Sends FILES_AS400/BOWER_FPO to AS400 as BOWER_FPO
> > 
> > LOG="/NTN/DATA/CORPORATE/FILES_LOG/BOWER_FPO.LOG"
> > rm $LOG
> > touch $LOG
> > cd /NTN/DATA/CORPORATE
> > 
> > echo `date` "Extracting Firm Planned Orders to BOWER_FPO" >$LOG
> > $UDTBIN/udt<>$LOG
> > RUN GD-BPGM EXTRACT_FPO -N
> > bye
> > EOD
> > 
> > echo "Sending Firm Planned Orders to AS400 730" >> $LOG
> > /usr/local/rputj.scr CORP BOWER_FPO FILES_AS400/BOWER_FPO BOWER_FPO
> > echo `date` "Finished sending Firm Planned Orders" >>$LOG
> > 
> > This runs perfectly when run from CL, but not when submitted from the
> > AS400.  And ideas?
> > 
> > Charles Shaffer
> > Senior Analyst
> > NTN-Bower Corporation
> > ___
> > U2-Users mailing list
> > U2-Users@listserver.u2ug.org
> > http://listserver.u2ug.org/mailman/lis

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

[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 an external select)(If AMOUNT is indexed, you probably 
have too many indices...;))
 
> Date: Wed, 27 Jul 2011 13:15:40 -0400
> From: jthompson...@gmail.com
> To: u2-users@listserver.u2ug.org
> Subject: [U2] Doing Multiple Selects in BASIC and combining the lists
> 
> This may be an easy one, or a hard one, however, I realized I don't recall
> ever having to do this until today, or I could just be tired...
> 
> How can you do a SELECT from two different files in a BASIC program and then
> combine the lists of ID's so that you can do a READNEXT on it?
> 
> I ask this because I believe by default that Universe does not store the
> select lists as dynamic arrays.
> 
> For example:
> 
> EXECUTE \SELECT FILE1 WITH AMOUNT = "112.50"\ RTNLIST FILE1_LIST
> EXECUTE \SELECT FILE2 WITH AMOUNT = "112.50"\ RTNLIST FILE2_LIST
> 
> ...Code to combine FILE1_LIST and FILE2_LIST into FINAL_LIST...
> 
> REANEXT ID FROM FINAL_LIST THEN
> do something
> NEXT ID
> 
> I am using Universe 10.3.x on AIX 5.3.  I'm in a PICK flavor account.
> 
> -- 
> John Thompson
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
  
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] 2008 server and UNiverse Status command

[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've ever seen U2 (or any Pick for that matter) crash and 
> need a re-install when using it, unless there were serious hardware 
> problems. Clearly, this is an issue for U2 support. Contact your 
> support person at Rocket.
> 
> HTH,
> 
> Bill
> 
> 
> - Original Message -
> *From:* t.sto...@monolith.com
> *To:* u2-users@listserver.u2ug.org
> *Date:* 7/7/2011 9:20 AM
> *Subject:* [U2] 2008 server and UNiverse Status command
> > On two servers when I have entered the STATUS command Universe has crashed
> > requiring a reinstall. Has any one else encountered this. I have seen
> > nothing in the Rocket knowledge base.
> >
> 
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
  
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[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 and we didn't want to upgrade AIX
> 
> 
> 
> So, we thought we'd do the easy thing and go to 10.1.22 (we are
> currently on 10.1.14)
> 
> 
> 
> Installed and licensed fine
> 
> 
> 
> BUT
> 
> 
> 
> When using this command:
> 
> 
> 
> CRT ENTRY$:@(10,(C$PS+1)+(C$PG*WS)):C$PPM 'R#2' :'.
> ':TEMPL$:C$MLT(C$PPM):CLN:
> 
> 
> 
> The line doesn't show on the screen 
> 
> 
> 
> However when using this
> 
> 
> 
> CRT @(10,(C$PS+1)+(C$PG*WS)):C$PPM 'R#2' :'.
> ':TEMPL$:C$MLT(C$PPM):CLN:
> 
> 
> 
> It does !!!
> 
> 
> 
> ENTRY$ is set as a common variable ENTRY$ = @(-14):@(-17)
> 
> 
> 
> Now old people like me will remember that at Release 7, @(-11) changed
> to @(-58) and @(-12) changed to @(-59) could it be we have something
> similar at 10.1.22
> 
> 
> 
> Any thoughts ??
> 
> 
> 
> 
> 
> Bob Witney
> 
> Explore!
> 
> Nelson House
> 
> 55 Victoria Road
> 
> Farnborough
> 
> Hants
> 
> GU14 7PA
> 
> b...@explore.co.uk
> 
> Mob - 07973 451156
> 
> Direct - 01252 279489
> 
> Website - www.explore.co.uk
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> Confidentiality Notice: This e-mail and any attachments are intended solely 
> for the addressee and may contain confidential or privileged information. If 
> you are not the named addressee, or the person responsible for delivering the 
> message to the named addressee, please notify the sender as soon as possible 
> and delete the material from your computer. This message will be protected by 
> copyright. If it has come to you in error, you must not take any action based 
> on its contents nor must you copy or show the message to any person other 
> than the intended recipient. 
> _
> This email has been scanned by the MessageLabs Email Security System.
> For more information please visit http://www.messagelabs.com/email 
> __
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
  
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] File Item Count Limit?

[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,036,854,775,808.
 
...so, when you see your file getting above, say, 9,223,373,036,400,000,000, 
you may want to break it up into dynamic or distributed files.
 
> Date: Fri, 3 Jun 2011 09:45:46 -0400
> From: jthompson...@gmail.com
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] File Item Count Limit?
> 
> Also, If they are 64 bit files in Universe then they can grow quite large on
> the disk.
> 
> You can have a file that probably takes up to 64 GB of disk space.
> Depending on the record size, etc... who knows how many records that could
> be. I don't have the formula's in front of me to figure that out.
> 
> You can change whether a file is 32 or 64 bit in universe by using the
> RESIZE command.
> Its also a configurable paramater for newly created files in the uvconfig
> file. I think you can easily find it in UniAdmin somewhere.
> 
> So even if that file you are referring to is a 32bit one and it exceeds 2 GB
> on the disk, you can resize it (without users on the system), and turn it
> into a 64 GB file and let it keep growing.
> 
> Of course, back it up first as always...
> 
> So I think you will be ok, especially if the records don't have much data in
> them as you say.
> 
> On Thu, Jun 2, 2011 at 6:22 PM, Dan McGrath  wrote:
> 
> > Assuming you're talking about a hash file, I'd hazard a guess that it
> > would be only limited by:
> > 1) File size
> > 2) The ability of the tools to handle the file record list (such as
> > SELECT)
> > 2.1) I.e, memory limitations and
> > 2.2) The count variable (assuming it is a 32bit signed int, that gives
> > you a max 2^31 = 2147483648 records)
> >
> > -Original Message-
> > From: u2-users-boun...@listserver.u2ug.org
> > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
> > Sent: Friday, 3 June 2011 6:38 AM
> > To: U2 Users List
> > Subject: [U2] File Item Count Limit?
> >
> > I'm on UV/Linux
> >
> > Just curious, is there a limit to the number of items you can have in a
> > file? or just limited to overall file size?
> > We have one file that has about 15M items at present. Not much data in
> > each item, just a crap load of them.
> >
> > George
> >
> >
> > George Gallen
> > Senior Programmer/Analyst
> > Accounting/Data Division, EDI Administrator ggal...@wyanokegroup.com
> > ph:856.848.9005 Ext 220
> > The Wyanoke Group
> > http://www.wyanokegroup.com
> >
> >
> >
> > ___
> > U2-Users mailing list
> > U2-Users@listserver.u2ug.org
> > http://listserver.u2ug.org/mailman/listinfo/u2-users
> >
> > __
> > This email has been scanned by the MessageLabs Email Security System.
> > For more information please visit http://www.messagelabs.com/email
> > __
> >
> > ###
> > The information transmitted in this message and attachments (if any) is
> > intended only
> > for the person or entity to which it is addressed. The message may contain
> > confidential
> > and/or privileged material. Any review, retransmission, dissemination or
> > other use of
> > or taking of any action in reliance upon this information by persons or
> > entities other
> > than the intended recipient is prohibited. If you received this in error,
> > please
> > contact the sender and delete the material from any computer.
> >
> > The intended recipient of this e-mail may only use, reproduce, disclose or
> > distribute
> > the information contained in this e-mail and any attached files with the
> > permission of IMB.
> >
> > ###
> > ___
> > U2-Users mailing list
> > U2-Users@listserver.u2ug.org
> > http://listserver.u2ug.org/mailman/listinfo/u2-users
> >
> 
> 
> 
> -- 
> John Thompson
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
  
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Universe PE

[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 
> fill out the registration form, but then nothing downloads, I just get an 
> email saying someone will contact me
> 
> What's up?
> 
> Will Johnson
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
  
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

[U2] serial #

[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
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[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 UniVerse File
> 
> I'm trying to determine the various error and warning messages that
> might be presented by uvbackup. I think I have determined most of them
> but I don't know what uvbackup would say when it encounters a broken
> file. Is there an easy way to "break" a file in a way that would be
> interpreted as such by uvbackup?
> 
> Thanks.
> Perry Taylor
> Senior MV Architect
> ZirMed
> 888 West Market Street, Suite 400
> Louisville, KY 40202
> www.zirmed.com  
> 
> 
> 
> 
> 
> CONFIDENTIALITY NOTICE: This e-mail message, including any 
> attachments, is for the sole use of the intended recipient(s) 
> and may contain confidential and privileged information. Any
> unauthorized review, use, disclosure or distribution is 
> prohibited. ZirMed, Inc. has strict policies regarding the 
> content of e-mail communications, specifically Protected Health 
> Information, any communications containing such material will 
> be returned to the originating party with such advisement 
> noted. If you are not the intended recipient, please contact 
> the sender by reply e-mail and destroy all copies of the 
> original message.
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
  
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Hello ?

[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
> ???
> 
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of u2ug
> Sent: Monday, May 02, 2011 9:39 PM
> To: U2 Users List
> Subject: [U2] Hello ?
> 
> The list has gone silent for me for the past week - is there anybody out
> there ? Just yell if you can hear me ...
> 
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
> 
> 
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
  
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] UniData memory errors

[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 Rocket, but if I were you, I'd 
get Tim Snyder to look at it. Configuring UniData shared memory is a skill. 
They probably won't let Wally come to you, so ask for Tim.
 
Steve O'Neil - over to you...
 
> Date: Sun, 17 Apr 2011 21:28:31 -0700
> From: wphask...@advantos.net
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] UniData memory errors
> 
> Yes. All the accounts exist and they've been accessed via telnet for 
> quite a while. This somehow seems like a Windows 7 error because I can 
> replicate it using a Windows 7 machine loggin in via AccuTerm 7, from 
> one machine, using the wireless network card. The other ones came from 
> an unknown Windows machine over http using DesignBais.
> 
> Here's the log entry:
> 
> ==pid:848 calling reportIpcState() == Current time=Thu Apr 14 15:39:15 2011
> 
> funcname:U_shmem_alloc(B), errno:0.
> 
> T ID SIZE CPID
> m UDShmem-Named-1119883584-1-11-0-69 3470336 2008 ->smm (ctl)
> m UDShmem-Private--1392509951-2-11-0-16383-1 354224 2008 ->smm (msg)
> m UDShmem-Private--1392509950-2-11-0-16383-2 8388608 2008 ->smm 
> (shmbuf)
> m UDShmem-Private--1392509949-2-11-0-16383-3 8388608 2008 ->smm 
> (shmbuf)
> m UDShmem-Private--140927-2-11-0-6-1 344320 2668 ->udt 
> (private)
> m UDShmem-Private--1409279993-2-11-0-6-7 344288 2668 ->udt 
> (private)
> m UDShmem-Private--1409279996-2-11-0-6-4 344320 2668 ->udt 
> (private)
> m UDShmem-Private--1392509952-2-11-0-16383-0 4194304 2008 ->smm (glm)
> m UDShmem-Private--1392510976-2-11-0-16382-0 ->sbcs
> m UDShmem-Private--1392510975-2-11-0-16382-1 ->sbcs
> - Process Info (10) -
> 848 -1 -1 -1 -1
> -1 -1 -1 -1 -1
> 
> - User Info 
> UserId UserName UserType TTY LogonTime
> 197619 AsiDbUser udt udcs 15:39:13 Apr 14 2011
> 
> -- Connection Info -
> Connections Family Domain
> 0
> 
>  Counters (8) ---
> min_temp min_basic tb(G) tb(S) bb(G) bb(S) b_compact b_merge
> 64 256 1 0 2 0 5 0
> 
>  Memory Info (64) -
> No. ... pid_idx type head ci_error gno/shmid pno/size (size)
> 0 0 B-G 255 0 0 2 (256K)
> 1 0 T-G 0 0 0 3 (256K)
> 
> - Control Info (100) (LastUsed/NextAvail = 3/4) ---
> No. ... offset size left right shm_idx pid_idx
> 0 0 1 255 1 1 0
> 1 1 4 0 2 1 0
> 2 5 5 1 3 1 0
> 3 10 54 2 255 1 255
> #
> # Unidata Configuration Parameters
> .
> .
> --- LCTs Statistics ---
> 
> Total LCTs (Process Groups allowed): 128
> 
> LCTs Used (Active Process Groups): 6 (5% of 128) Total Ps: 6
> 
> Total Global Pages Used: 13 (3328K bytes)
> Total Self-created.: 3 (1008.7K bytes)
> Total memory used..: 4336.7K bytes
> 
>  End of LCTs Statistics ---
> 
> HTH,
> 
> Bill
> 
> 
> - Original Message -
> *From:* precisonl...@gmail.com
> *To:* U2 Users List 
> *Date:* 4/17/2011 2:13 PM
> *Subject:* Re: [U2] UniData memory errors
> > Have you looked at any of the log files that it's naming?
> > ___
> > U2-Users mailing list
> > U2-Users@listserver.u2ug.org
> > http://listserver.u2ug.org/mailman/listinfo/u2-users
> 
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
  
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Who is Ed Clark?

[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 classic example of the issue that came up a few days ago about
> people being open about who they are.
> 
> Ed Clark posts from u...@edclark.net, there is also an Ed Clark who posts
> about Cache in other places from an aol address, but then there is also an
> Ed Clark who has an Intersystems.com address.
> 
> So come on Ed, who are you? Are you an Intersystems employee? If so why
> are you not open about it and say so?
> 
> I make it quite clear that I sell U2, I make my bias obvious so people can
> judge my comments accordingly. If you are an Intersystems employee or
> otherwise connected to Intersystems then say so and let people judge your
> comments in that context.
> 
> George Land
> APT Solutions Ltd
> U2 UK Distributor
> 
> 
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
  
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Game changer for U2 editors

[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
> revolutionized the U2 tools market. All of our changes until today have
> really been evolutionary. We are announcing a revolutionary change for the
> U2 market which we call it Continuous Compile.
> 
> 
> Continuous compile means that when you stop typing, for let say 500
> milliseconds, we will verify your entire program with the UniBasic compiler.
> We show you the information that we get back from Universe or Unidata
> compilers with whatever compile options you specify.
> 
> 
> This is no parlor trick nor have we added a parser to Eclipse to do what the
> compiler does. We call the Unidata or Universe compiler to verify your code
> just when you stop typing. We have setup preferences to allow you to
> control if the function is on or off and how many milliseconds before it
> verifies your code. You will see the real error messages and any unassigned
> variables. Your code, however, never gets updated on the server until you
> specifically save and compile it.
> 
> 
> Say goodbye to EMACS, VIM, VI, Edit Plus, BDT, AE, ED, or whatever you use.
> Move up to the industry leader in Eclipse based tools for Universe and
> Unidata. The XLr8Editor can be yours for $49.00 per year.
> 
> 
> 
> U2logic Team,
> 
> www.u2logic.com/tools.html
> 
> [/ad]
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
  
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] File Corruption

[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-
> From: u2-users-boun...@listserver.u2ug.org
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wally Terhune
> Sent: 08 March 2011 13:23
> To: U2 Users List
> Subject: Re: [U2] File Corruption
> 
> UniData? UniVerse?
> OS vendor/version?
> U2 version?
> 
> Wally Terhune
> U2 Support Architect
> Rocket Software
> 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA
> Tel: +1.720.475.8055
> Email: wterh...@rs.com
> Web: www.rocketsoftware.com/u2
> 
> 
> 
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bob Witney
> Sent: Tuesday, March 08, 2011 6:08 AM
> To: u2-users@listserver.u2ug.org
> Subject: [U2] File Corruption
> 
> Hiya:
> 
> 
> 
> I have 3 fairly large files that have been corrupted.
> 
> 
> 
> This is how the file should look (more in unix)
> 
> 
> 
> ,-^A^L^M^C ^AMv
> 
> Mu^EM-^X^B@^BLL^L^C1668780*O.AFSC*15911*1 ***Air Fuel & Tax
> Surcharge***4176
> 
> *^B 4@^B@^B@^B@^B@^B@^B@^VTT^L^C1668803*E.BROL*15910*1
> *15773*NEW*Early Book
> 
> ing Offer**1*2-197.00*^B^W,@^B@^ZHH^L^C1664139*H.DEAL*15808*1
> ***Deal of the
> 
> Week**1*1-100.00*^A^[8@^B@^B@^B@^B@^B@^B@^B@^B@^B@^B@^B@2D^C1667687*
> VICRDT
> 
> *15805*1 ***Visa
> surcharge*1*1*122.88*3<@^B@6LL^L^C1654895*E.BROL*15847*1 **
> 
> *Early Booking
> Offer**1*2-89.10*^C74@^B@^B@^B@^B@^B@^B@^B@^B@^B@^B@^B@^B@^B@
> 
> ^B@^B@^B@^B@^B@^B@^B@^B@^B@^B@^B@^B@^B@^B@^B@^B@^B@tH^C1635693*K.EXDS*15
> 705*1 *
> 
> **Ex-Gratia
> Discounts***1-311.1*u8@^B@^B@^B@^B@^B@^B@^B@^B@^B@^B@^B@^B@^B@MP
> 
> HH^L^C1631707*ACCRDT*15808*1 ***Access
> surcharge*1*1*128.36*^BM-^PM-^PM-^PH5
> 
> 5097*ACCRDT*15808*1 ***Access
> surcharge*1*1*256.51*^BM-^PXM-^P^L^C1658725*AT
> 
> *15808*1 ***Access
> surcharge*1*1*135.92*^BM-^Q8@M-^RDD^L^C1659338*H.DEAM*151
> 
> ***Deal of the Week***1-100*^AM-^S<@^B@^B@^B@^B
> 
> 
> 
> This is how it looks after the overwrite
> 
> 
> 
> ^FP0^C001060 Xon/Xoff = %s, %s, %s*^FP`^FP0^L^C001341 Output NEXT
> hold f
> 
> ile : %n*^B^FPM-^@^FP^P^L^C001622 Got:  ^B^FP0^FP^C001903 "%s"
> spoole
> 
> d to the printer.*^FP ^FP8^L^C010052 Invalid token "%s" on command
> line.*QD
> 
> ^FP+^L^C010614 You can not modify Part File "%n" because it is marked
> for replic
> 
> ation!*Qx^FP\^L^C015110 CreateDC failed with error %l.*^B^FQ@^FQ^C020168
> S
> 
> AVING clause not valid with LIST command. Ignored.*^FQ|^FQ@^L^C030003
> DELETE at
> 
> tempt on read-locked item.*R^\^FQ EX7~^DPP^LC0659741*ACCRDT*11632*1
> *11579*N
> 
> EW*Access surcharge*1*1*232.72*^B^DM-^\^DL^L^C0975311*AXCRDT*12820*1
> *12791E
> 
> W*Amex surcharge*1*1*16.71*|^L^C1370920*A.DTAX*14176*1
> *14176*NEW*Airp
> 
> ort Dep Tax Refunded***1-134.3*^C^ED^D^C0534432*F.RGTV*11097*1
> *11097*NEW*P
> 
> lus 4 Discount***01*0*0*0*-28.00*^EM-^P^D8^L^C0484503*L.SARE*11238*1
> *11238*NEWa
> 
> les Reduction**1*-130*^B^EX^E^C1366350*F.RGTV*14125*1 *14106*NEW*5%
> Discou
> 
> 
> 
> Has anyone seen anything like this before or has any idea of the cause
> 
> 
> 
> Bob Witney
> 
> Explore!
> 
> Nelson House
> 
> 55 Victoria Road
> 
> Farnborough
> 
> Hants
> 
> GU14 7PA
> 
> b...@explore.co.uk
> 
> Mob - 07973 451156
> 
> Direct - 01252 279489
> 
> Website - www.explore.co.uk
> 
> 
> 
> 
> 
> 
> Confidentiality Notice: This e-mail and any attachments are intended
> solely for the addressee and may contain confidential or privileged
> information. If you are not the named addressee, or the person
> responsible for delivering the message to the named addressee, please
> notify the sender as soon as possible and delete the material from your
> computer. This message will be protected by copyright. If it has come
> to you in error, you must not take any action based on its contents nor
> must you copy or show the message to any person other than the intended
> recipient. 
> _
> This email has been scanned by the MessageLabs Email Security System.
> For more information please visit http://www.messagelabs.com/email
> __
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
> 
> __
> This email has been scanned by the MessageLabs Email Security System.
> For more information please visit http://www.mes

Re: [U2] Purging and Indexing

[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, I'd say turn them 
off for this process (actually, I'd select for the date criteria, save the list 
for use & then do a get-list instead of basic select, then turn off indexing), 
then re-index. Since you don't have them yet, creating it first would give you 
a lot of overhead.
 
> From: gglorfi...@vertisinc.com
> To: u2-users@listserver.u2ug.org
> Date: Wed, 16 Feb 2011 10:07:44 -0500
> Subject: [U2] Purging and Indexing
> 
> Good Morning,
> 
> Looking for opinions and experiences here. We are trying to do some system 
> cleanups. We found that our PO file has over 10 million records dating back 
> some 7 years. We've decided that 2 years of PO history is plenty to keep on 
> file.
> 
> Currently there are no indices on this file. Our question is would it be 
> quicker to do a select and delete of the older records before building an 
> index on invoice date or would it be quicker to build the index first to use 
> in the select for the purge? This index has been identified as being needed 
> for some reporting.
> 
> My thinking is that while the select for the purge may go quicker, if the 
> index is in place prior to the purge then the delete process not only has to 
> delete the selected records it also has to update the index on the fly.
> 
> TIA,
> Gordon
> 
> Gordon J Glorfield | Software Application Developer | Vertis Communications
> 250 W. Pratt Street, Suite 1800 | Baltimore, MD, 21201
> T 410-361-8664 | M 443-280-7093
> gglorfi...@vertisinc.com | http://www.vertisinc.com
> 
> Vertis Communications is a results-driven marketing communications company 
> that delivers inventive advertising, direct marketing and interactive 
> solutions to prominent brands across North America. Our deep industry 
> knowledge and extensive range of offerings-including integrated data 
> solutions, digital program management systems, creative services, world-class 
> print and mail production, logistics, out-of-home and business process 
> outsourcing-are used to deliver superior program performance that drives 
> bottom line results for our clients. With 100 strategically positioned 
> locations and more than 5,000 dedicated professionals, we deliver impeccable 
> quality and fast turn-around to any market.
> 
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
  
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[Dan Fitzgerald]

I don't think it's a lock problem for your record. Much more likely is a data 
problem. Also a possibility is file corruption. Third thing that pops to mind 
is the program that does the update encountering a weird condition that sends 
it into a rarely used set of instructions.
 
I'd also look for a null (or weird, or incorrect) value in a foreign key. I 
once worked at an HMO where somebody somehow created a null vendor record. So, 
every doctor who didn't have a vendor record had a null in that field, and this 
little 4-doc practice, the null vendor, was getting checks for $2-5M every 
month. You'd think they'd be happy, but they actually were a bit freaked out 
about it.
 
What generates the order number? Are there conditions where that logic can fail?
 
This sounds like an excellent opportunity to use the debugger. Set a break 
point in the program, and step through, examining the variables as you go. Pay 
special attention to whatever generates/assembles the order #.
 
> From: micha...@plumbersstock.com
> Date: Wed, 2 Feb 2011 17:35:48 -0700
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] How to find and fix a broken lock?
> 
> I don't see it listed. Here is what it did return. I'm looking for entity
> 40936.
> 
> 
> >list.readu every
> 
> Active Group Locks: Record Group Group
> Group
> Device Inode Netnode Userno Lmode G-Address. Locks ...RD ...SH
> ...EX
> 2686979 462014 0 53135 5 IN 10D000 1 0 0
> 0
> 2686979 7005 0 53135 24 IN 4800 1 0 0
> 0
> 655364 4098 0 57139 26 IN 1 1 0 0
> 0
> 2686979 462014 0 53135 31 IN 23A000 1 0 0
> 0
> 2686979 154 0 40639 42 IN 600 2 0 0
> 0
> 2686979 7039 0 40789 59 RD 5AAE000 0 1 0
> 0
> 2686979 154 0 44775 64 IN 1600 1 0 0
> 0
> 2686979 154 0 53135 80 IN 1000 1 0 0
> 0
> 2686979 462014 0 53135 81 IN 521000 1 0 0
> 0
> 2686979 462014 0 53135 81 IN 5E3000 1 0 0
> 0
> 
> Active Record Locks:
> Device Inode Netnode Userno Lmode Pid Login Id
> Item-ID.
> 2686979 462014 0 61405 5 RU 528386 eclipseB
> %WEB.PH.SESSION.MONITOR
> 2686979 7005 0 57139 24 RU 368822 eclipseB
> FAX.FEEDBACK3
> 655364 4098 0 57139 26 RU 368822 eclipseB fax_feed3
> 2686979 462014 0 52985 31 RU 471274 eclipseB
> WIDGET.PHANTOM
> 2686979 154 0 40639 42 RU 1302770 eclipseB
> JOB.SCHEDULER
> 2686979 154 0 65263 42 RU 1179848 eclipseB
> TC.TIMESHEET.PH.SERVER
> 2686979 154 0 44775 64 RU 512250 eclipseB
> SOCKET.PH.SERVER
> Press any key to continue...
> 2686979 154 0 53135 80 RU 1683466 eclipseB
> SYSTEM.ADMIN
> 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:
> >
> > 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 Universe but I have a background in
> >> programming and Unix so I hope I can figure this problem out. I have
> >> access to AIX and DataVu Query.
> >>
> >> We use Activant Eclipse which seems to be built on Universe and their
> >> support is completely useless. Their technical support keeps blaming
> >> our problem on a network issue which doesn't even make sense and their
> >> networking department has already proven isn't the issue. We've been
> >> working with them on the issue for more than a month without progress
> >> so I need to find another way to fix the issue.
> >>
> >> We have a process that takes a customer id and some order parameters
> >> and pushes an order into the system and returns the resulting order
> >> number or an error. Our problem is that for a certain customer that we
> >> use a lot is that it allows the order to be pushed in, without
> >> failing, but does not return an order number or an error. Orders from
> >> other customers work as expected. Originally the problem started when
> >> we were pulling a report for that customer with their order history -
> >> which failed. To me this suggests that someplace there is a lock in
> >> place for that customer that hasn't been removed or something of that
> >> nature. Any ideas how I could look for this or fix it?
> >>
>

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

[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 Universe but I have a background in
> programming and Unix so I hope I can figure this problem out. I have
> access to AIX and DataVu Query.
> 
> We use Activant Eclipse which seems to be built on Universe and their
> support is completely useless. Their technical support keeps blaming
> our problem on a network issue which doesn't even make sense and their
> networking department has already proven isn't the issue. We've been
> working with them on the issue for more than a month without progress
> so I need to find another way to fix the issue.
> 
> We have a process that takes a customer id and some order parameters
> and pushes an order into the system and returns the resulting order
> number or an error. Our problem is that for a certain customer that we
> use a lot is that it allows the order to be pushed in, without
> failing, but does not return an order number or an error. Orders from
> other customers work as expected. Originally the problem started when
> we were pulling a report for that customer with their order history -
> which failed. To me this suggests that someplace there is a lock in
> place for that customer that hasn't been removed or something of that
> nature. Any ideas how I could look for this or fix it?
> 
> 
> Thanks,
> Michael McGlothlin
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
  
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[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, etc., 
changes.
 
One useful thing to look at is vmstat -v | grep block. If you see the values 
there changing over time, you'll need to do some tweaking. This is part of the 
nmon output, so you can track it over time easily, if you use nmon. Manually, 
try it an hour apart. if no changes, try 24 hours. keep the output around, and 
when you're experiencing a heavy load, look again. It resets to zero at boot, 
so big numbers mean something has happened in the past (or you haven't rebooted 
in far too long).
 
I have Mark's Hitchhiker's guide series (backed up in 6 or 7 places), but I'd 
need his permission to send 'em. Mark? I know that when U2 was IBM, whether or 
not Mark got to publish such over-the-top useful articles depended on how many 
people downloaded them. Reading and understanding even a few sentences any of 
Mark's articles makes you an instant SME, and guarantees that your capability 
to add value is enhanced. If you come across them, download them, and ask 
Rocket for more. More. MORE! With the exception of Clif Oliver and possibly one 
or two others, Mark is like Hank Williams in Leonard Cohen's "Tower of Song" - 
a hundred floors above us.
 
Two other authors I've found useful you may want to search on are Ken Milberg & 
Jaqui Lynch; both deal with AIX tuning. Be sure to be looking at AIX 5.3; there 
were some major changes to AIX tuning between 5.1 & 5.3, and some of those 
changes are a 180 degree change (for example, maxperm, maxclient, and 
lru_file_repage).
 
You can find a lot of the new settings in /etc/tunables/lastboot.
 
I've found the truss command to be amazingly helpful, but you have to have some 
understanding of system calls & error messages in order to interpret it. It 
captures all of the system calls made by a process (the -f option follows all 
of the forks, as well). Even without knowing what each system call does, you 
can see if it's hanging, looping, waiting, etc.
 
svmon is a good tool; svmon -U will tell you more than you want to know about 
each user's memory map.
 
FILE.USAGE is a very powerful tool in UV. It has some impact on performance if 
you run it for a lot of files.
 
Having specialized in tuning U2 on AIX for a while, I have a few docs (How to 
look at topas, tuning with ioo, vmo) that I need to update & cleanup, and 
perhaps submit to Spectrum.
 
Obviously, FAST (no relation) is an excellent tool. 
 
 I occasionally moonlight remotely, and as I mentioned, tuning UV on AIX 
is my specialty niche. I bring a program that exports ANALYSE.FILE data & runs 
some analytics into an .xls file, from which we can target your most poorly 
sized hashed files, in addition to 20 years in U2 & 15+ years in AIX. Usually, 
with the tools and knowledge transfer I leave behind, you won't feel the need 
for outside help again.
 
> From: stuart.boyd...@spotless.com.au
> To: u2-users@listserver.u2ug.org
> Date: Thu, 20 Jan 2011 16:03:36 -0800
> Subject: [U2] [UV][AIX] System Management and Performance Tools
> 
> Hi,
> Just wondering if anyone has any recommendations for systems 
> monitoring/management tools for aix5.3/uv10.2.4. I've seen occasional 
> discussions on the topic here over the years.
> Ideally, what we would like to do is be able to track down those end of month 
> type processes which bog the system down with CPU & IO bottlenecks during 
> peak load periods.
> I suppose this could be done with something like topas, truss and PORT.STATUS 
> but just wondering what is available.
> There was a tool called "DPMonitor" that looked like it could be suitable - 
> does this exist in any form?
> Also, does anyone know if the "Travels with Mark: A Hitchhiker's Guide to the 
> UniVerse"
>  series on performance tuning is available anywhere. It was on the IBM 
> developerworks site but, no more.
> 
> All suggestions gratefully received.
> Thanks in advance,
> Stuart Boydell
> 
> 
> 
> 
> 
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
  
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[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 wieder verfügbar und werde sobald wie möglich an diesem Tag 
auf Ihre Email reagieren.
 
Mit freundlichen Grüßen
--
Hello,
 
I am currently on vacation and am unable to respond to your Email. I will be 
back at work on 4th January 2011 and will respond to your Email as soon as 
possible on this date.
 
Kind regards
 
Glenn Sallis
 
Glenn Sallis Softwareentwicklung und Beratung
47608 Geldern · Deutschland
Tel: + 49 2831 9104220 Mob: +49 151 55714743 ·
Email: gl...@glennsallis.de 
Web: www.glennsallis.de
 
Ihr "Zuhause" für unabhängige MultiValue Beratung in Deutschland und Benelux


--Forwarded Message Attachment--
From: dangf...@hotmail.com
To: u2-users@listserver.u2ug.org
Date: Thu, 30 Dec 2010 13:22:30 -0500
Subject: Re: [U2] [UV] PORT.STATUS questions.

 
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 Time, 
> donr_w...@yahoo.com writes:
> 
> 
> > I use PORT.STATUS for several function within programs by capturing the 
> > output 
> > and parsing it. I have a couple of problems with this.
> > 
> > First, only one user at a time can run the command and this causes random 
> > failure of the programs.
> > Second, the output can vary depending on options and success or failure of 
> > the 
> > command.
> > 
> > So, is there a callable routine to get the same info in a cleaner way?
> > 
> 
> Yes. If you have a budget.
> The solution is rather elegant, but also proprietary... to me.
> You have to buy a license. I stopped giving away free software when real 
> estate went South :)
> 
> Will Johnson
> Fast Forward Technologies
> 831 477 7125
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
  
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
  
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[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 Time, 
> donr_w...@yahoo.com writes:
> 
> 
> > I use PORT.STATUS for several function within programs by capturing the 
> > output 
> > and parsing it. I have a couple of problems with this.
> > 
> > First, only one user at a time can run the command and this causes random 
> > failure of the programs.
> > Second, the output can vary depending on options and success or failure of 
> > the 
> > command.
> > 
> > So, is there a callable routine to get the same info in a cleaner way?
> > 
> 
> Yes. If you have a budget.
> The solution is rather elegant, but also proprietary... to me.
> You have to buy a license. I stopped giving away free software when real 
> estate went South :)
> 
> Will Johnson
> Fast Forward Technologies
> 831 477 7125
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
  
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Migration

[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 
> relationships.  The lack of constraints is both a curse and a blessing in the 
> MV 
> world.  However, I don't accept that you wouldn't want a product category 
> file 
> that holds all the product information in MV fields or order and invoice data 
> as 
> MV fields in a customer file.  A single read sounds intriguing in a web 
> app?!?!?!?
>  'We act as though comfort and luxury were the chief requirements of life, 
> when 
> all that we need to make us happy is something to be enthusiastic about.' 
> 
> 
> 
> 
> - Original Message 
> From: Mecki Foerthmann 
> To: U2 Users List 
> Sent: Wed, December 22, 2010 2:47:22 PM
> Subject: Re: [U2] Migration
> 
> Even though you are right that there can be distinct advantages MV vs.
> Relational.
> But you surely wouldn't want a Product Category file that holds all the
> product information in multi-valued fields.
> Or Order and invoice data as multivalued fields in the customer file.
> There is obviously a little bit more to mv database design than just
> parent-child relationships.
> 
> On 22/12/2010 19:49, Shawn Hayes wrote:
> > Why would it need to be application specific?  I was just thinking that 
> > architecturally (sometimes) there are advantages to using a non first 
> > normal 
> > form databases.  If you can read the schema of a fully relational database, 
> > couldn't you "easily" enough re-create the files embedding child elements 
> > into 
> 
> > MV tables?
> >
> > This would be a great migration path to utilizing some advantages on MV 
> > applications?
> >
> >  'We act as though comfort and luxury were the chief requirements of life, 
> > when 
> >
> > all that we need to make us happy is something to be enthusiastic about.' 
> >
> >
> >
> >
> > - Original Message 
> > From: Kevin King 
> > To: U2 Users List 
> > Sent: Wed, December 22, 2010 1:34:40 PM
> > Subject: Re: [U2] Migration
> >
> > I would think the migration would be application specific.  That said, it
> > certainly wouldn't be a difficult thing to write.
> > ___
> > U2-Users mailing list
> > U2-Users@listserver.u2ug.org
> > http://listserver.u2ug.org/mailman/listinfo/u2-users
> >
> > ___
> > U2-Users mailing list
> > U2-Users@listserver.u2ug.org
> > http://listserver.u2ug.org/mailman/listinfo/u2-users
> >
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
> 
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
  
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Universe in the cloud??

[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 may 
want to look at the JS43) AIX blades (at $17K apiece - list for the base JS43), 
I could get as much power on 4 blades (maybe 3) as my 2 p570's (12 cpu's each). 

http://www-03.ibm.com/systems/bladecenter/hardware/servers/js2343/index.html
 
 
> Date: Mon, 20 Dec 2010 11:20:01 -0800
> From: eric.rosenzw...@petco.com
> To: u2-users@listserver.u2ug.org
> Subject: [U2] Universe in the cloud??
> 
> Does anyone know of a large implementation of Universe in the cloud? We're 
> currently on an IBM P570 with 16cpu and 32gb of RAM. We're looking to upgrade 
> to a 48 processer box with 192gb of ram. Instead of buying a new box we're 
> thinking about running it in the cloud. We've got 2TB of data on an EMC 
> DMX4500. This box does primarily batch processing with about 500 concurrent 
> users.
> 
> Additionally, I know most cloud providers don't support proprietary Unix like 
> AIX, but prefer Linux. If anyone knows of a similarly sized Linux 
> implementation, cloud or not, I'd like to get some info on that as well.
> 
> Thanks in advance.
> 
> 
> Eric Rosenzweig
> Vice President, Information Systems
> Application Development and System Administration
> Petco Animal Supplies, Inc.
> 9125 Rehco Rd.
> San Diego, CA 92121
> (858) 453-7845 x3125
> (858) 638-2120 fax
> mailto:eric.rosenzw...@petco.com
>  Think before you print
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
  
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] File Copy CowBoy - uvfixfile

[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 another file...
> 
> --Bill
> 
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org 
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of andy baum
> Sent: Wednesday, December 08, 2010 3:40 PM
> To: U2 Users List
> Subject: Re: [U2] File Copy CowBoy - uvfixfile
> 
> Bill,
> 
> 
> uvfixfile has not been developed for some time now and the preferred tool is 
> fixtool
> 
> Options are :-
> 
> -level # - Diagnosic level between 1 and 10 (default 2)
> -fix - Fix the file
> -dumppath x - Where x is the path for the dumpping files -nodump - Do not 
> dump errored records as default
> -file x - Where x is the file to use
> -filepath x - Where x is the path for the file
> -help - Display this help message
> -logging - Turns logging on
> -logpath x - Where x is the path for the logging files -start # - Start 
> diagnosic group, default is 0 -stop # - Stop diagnosic group, default is end 
> of file
> 
> 
> Cheers,
> 
> Andy
> 
> 
> 
> - Original Message 
> From: Bill Brutzman 
> To: U2 Users List 
> Sent: Wed, 8 December, 2010 20:29:27
> Subject: Re: [U2] File Copy CowBoy - uvfixfile
> 
> What is the command-line syntax for uvfixfile?
> 
> # ./bin/uvfixfile /u2/SANDBOX/IPL.X
> No filename specified.
> # ./bin/uvfixfile "/u2/SANDBOX/IPL.X"
> No filename specified.
> 
> --Bill
> 
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman
> Sent: Wednesday, December 08, 2010 2:21 PM
> To: U2 Users List
> Subject: Re: [U2] File Copy CowBoy
> 
> With FileZilla I am doing a Binary Transfer type.
> 
> --Bill
> 
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman
> Sent: Wednesday, December 08, 2010 2:18 PM
> To: U2 Users List
> Subject: Re: [U2] File Copy CowBoy
> 
> >FORMAT.CONV IPL.X
> Processing 'IPL.X'.
> Fatal error processing file IPL.X, file has been damaged
> >
> 
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman
> Sent: Wednesday, December 08, 2010 2:08 PM
> To: U2 Users List
> Subject: [U2] File Copy CowBoy
> 
> I am trying to compare this month with last month's inventory. Copying files 
> back from Windows to HP-Ux yields the following error message.
> 
> Help would be appreciated.
> 
> --Bill
> 
> >LIST IPL.X
> WARNING: Internal file corruption detected during file open!
> File must be repaired, possible truncation.
> hsize: 2048
> bsize: 2048
> fsize: 2019911
> WARNING: Internal file corruption detected during file open!
> File must be repaired, possible truncation.
> hsize: 2048
> bsize: 2048
> fsize: 2019911
> Unable to open "IPL.X" file.
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
> 
> 
> 
> 
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
  
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[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 run 
ANALYZE.FILE against the file in question? Or, better yet, fixtool? (does 
10.1.3 have fixtool, or is it uvfixfile on that platform?).
 
> Date: Thu, 18 Nov 2010 11:35:02 -0800
> From: go_mnviki...@yahoo.com
> To: u2-users@listserver.u2ug.org
> Subject: [U2] Dropping my UniVerse Session - Why?
> 
> I get this error everyonce in in a while...
> 
> This time, I wrote a simple "bash" program to update records.  It is a single 
> program with 5 file opens, a couple of reads, no calls to other programs, 
> (You 
> get the point - it is basic).  Anyways, I am running this and keep getting 
> kicked out of Universe (completely drops my session).  So I go to the 
> Computer 
> Management console on the server and look at the Application Error logs.  I 
> have 
> run it 3 times and here are the 3 errors...
> 
> "UniVerse error: Unhandled Exception raised at address 0x10083DFA : Access 
> violation.  Attempted to write to address 0x.  Binary data is 
> processor 
> CONTEXT structure.."
> 
> "UniVerse error: Unhandled Exception raised at address 0x7C82CAC2 : Access 
> violation.  Attempted to read from address 0x54524150.  Binary data is 
> processor 
> CONTEXT structure.."
> 
> "UniVerse error: Unhandled Exception raised at address 0x7C82A774 : Access 
> violation.  Attempted to read from address 0x.  Binary data is 
> processor 
> CONTEXT structure.."
> 
> We run Universe 10.1.3 on a Windows 2003 server SP2.  Any thoughts?
>  'We act as though comfort and luxury were the chief requirements of life, 
> when 
> all that we need to make us happy is something to be enthusiastic about.' 
> 
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
  
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[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 example 2596 x 8.333 = 21,632.468
> 
> How would you round that in UniVerse to 21,632.47?
> 
> Thanks!
> 
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
  
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[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 - Hardware sizing for 550 telnet users
> 
> We use our ramdisk for special jobs that require some crunching of sales 
> numbers.
> 
> We basically copy our monthly sales files (which are distributed by month) 
> into the ramdisk, run the jobs and recreate the partfiles for the month, 
> re-index etc then copy the partfiles and indexes back.
> 
> We took a weekly job that was taking about 16 hours down to less than 3 hours 
> by doing the work on the ramdisk.
> 
> btw our SAN is really fast, but the ramdisk is much faster.
> 
> 
> 
> From: u2-users-boun...@listserver.u2ug.org 
> [u2-users-boun...@listserver.u2ug.org] On Behalf Of Augusto Alonso 
> [aalo...@quiter.com]
> Sent: Friday, September 03, 2010 10:23 AM
> To: U2 Users List
> Subject: Re: [U2] Unidata - Hardware sizing for 550 telnet users
> 
> Hi Neil.
> May I ask you: how do you use the Ramdisk?
> As a temp directory?
> I'm very interested in improving performance this way...
> Thanks
> --
> Augusto Alonso
> IT Manager
> QUITER SERVICIOS CENTRALES
> Zoco Gran Santander, 1ª planta - 39011 Santander - España
> Telf: +34 902233323 - Fax: +34 902234280
> 
> AVISO LEGAL: Este mensaje contiene información destinada exclusivamente al
> usuario de destino, pudiendo contener información confidencial o protegida
> legalmente. Si, por un error de envío o transmisión, ha recibido este
> mensaje y usted no es el destinatario del mismo, por favor, notifique de
> este hecho al remitente y no use, informe, distribuya, imprima, copie o
> difunda este mensaje bajo ningún medio . Cualquier opinión en él contenida,
> es exclusiva de su autor y no representa necesariamente la opinión de Quiter
> Servicios Centrales.
> 
> LEGAL WARNING: This e-mail and any attachment, contain information intended
> solely for the addressee and may contain confidential information or legally
> protected data. If you are not the intended recipient, please notify the
> sender and do not use, disclose, distribute, copy, print or rely on this
> e-mail under any circumstances. The views and opinions expressed are the
> author´s own and do not necessarily reflect those of Quiter Servicios
> Centrales.
> 
> 
> 
> 2010/9/3 Neil Richards >
> 
> > Manu,
> >
> > we have a similar system running Universe on AIX.
> >
> > I carved out the following LPAR from one our P560 frames.
> >
> > Ram 64GB, (48GB and 16GB Ramdisk)
> > CPU 8 dual core cpus
> > Disk 1TB (600GB in use)
> >
> > performance is stellar compared to our Oracle ERP systems which run on even
> > more hardware.
> >
> > Neil
> >
> > 
> > From: 
> > u2-users-boun...@listserver.u2ug.org
> >  [
> > u2-users-boun...@listserver.u2ug.org]
> >  On Behalf Of Manu Fernandes [
> > e...@infodata.lu]
> > Sent: Friday, September 03, 2010 3:06 AM
> > To: U2 Users List
> > Subject: [U2] Unidata - Hardware sizing for 550 telnet users
> >
> > Hi group,
> >
> > This post to ask your opinion about the hardware sizing to serve this
> > type of usage, within a IBM / AIX system :
> >
> > - Unidata unix
> > - 550 telnet users
> > - 100gb datafiles
> >
> > Any advise is welcome.
> > Manu
> >
> > ___
> > U2-Users mailing list
> > U2-Users@listserver.u2ug.org
> > http://listserver.u2ug.org/mailman/listinfo/u2-users
> > 
> > ___
> > U2-Users mailing list
> > U2-Users@listserver.u2ug.org
> > http://listserver.u2ug.org/mailman/listinfo/u2-users
> >
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
> 
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
  
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[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.u2ug.org
> Date: Fri, 3 Sep 2010 10:10:06 -0700
> Subject: Re: [U2] Unidata - Hardware sizing for 550 telnet users
> 
> Manu,
> 
> we have a similar system running Universe on AIX.
> 
> I carved out the following LPAR from one our P560 frames.
> 
> Ram 64GB, (48GB and 16GB Ramdisk)
> CPU 8 dual core cpus
> Disk 1TB (600GB in use)
> 
> performance is stellar compared to our Oracle ERP systems which run on even 
> more hardware.
> 
> Neil
> 
> 
> From: u2-users-boun...@listserver.u2ug.org 
> [u2-users-boun...@listserver.u2ug.org] On Behalf Of Manu Fernandes 
> [...@infodata.lu]
> Sent: Friday, September 03, 2010 3:06 AM
> To: U2 Users List
> Subject: [U2] Unidata - Hardware sizing for 550 telnet users
> 
> Hi group,
> 
> This post to ask your opinion about the hardware sizing to serve this
> type of usage, within a IBM / AIX system :
> 
> - Unidata unix
> - 550 telnet users
> - 100gb datafiles
> 
> Any advise is welcome.
> Manu
> 
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
> 
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
  
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[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.
 
> From: aalo...@quiter.com
> To: u2-users@listserver.u2ug.org
> Date: Wed, 4 Aug 2010 12:26:51 +0200
> Subject: Re: [U2] Impossible to handle big files (over 2 Gb) with Universe 
> onPowerPC
> 
> It is not a matter of the OS nor the File System.
> It is a UV limitation.
> I know the distributed files option, but this is not possible because of the 
> app.
> Regards
> --
> AA
> -mensaje original-
> Asunto: Re: [U2] Impossible to handle big files (over 2 Gb) with Universe 
> onPowerPC
> De: "Morawa, Hans" 
> Fecha: 04/08/2010 10:44
> 
> Augusto,
> 
> To check if your system handles large file support you need to use the 
> getconf program, syntax something like getconf FILESIZEBITS /path on most 
> systems.
> 
> Regards,
> Hans Morawa
> 
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org 
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Augusto Alonso
> Sent: Wednesday, 4 August 2010 4:39 PM
> To: U2 Users List
> Subject: [U2] Impossible to handle big files (over 2 Gb) with Universe 
> onPowerPC
> 
> Hi.
> I have a big problem.
> In Universe 10.1.21 on RedHat PowerPC I need to handle big files, but it is 
> impossible.
> 
> I have tested it and I have this ERROR:
> 
> >CREATE.FILE TEST 2 2
> Creating file "TEST" as Type 2, Modulo 2, Separation 4.
> Creating file "D_TEST" as Type 3, Modulo 1, Separation 2.
> Added "@ID", the default record for RetrieVe, to "D_TEST".
> >
> >RESIZE TEST 18 1 1 64BIT
> RESIZE: Invalid file name, sizing parameter, or option on command line.
> >
> 
> Even trying to create it:
> 
> >CREATE.FILE NEWFILE 2 2 2 64BIT
> Enhanced files (64bit) are not currently supported on this platform.
> >
> 
> I'm very surprised that I am the first customer with this issue, but the tech 
> people from Rocket said that there is no plans to solve it.
> 
> Does anyone knows any workaround?
> Regards
> --
> Augusto Alonso Alonso
> IT manager
> QUITER SERVICIOS CENTRALES
> Zoco Gran Santander, 1ª planta - 39011 Santander - España
> Telf: +34 902233323 - Fax: +34 902234280 
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
> 
> --
> This email and any files transmitted with it are confidential to the intended
> recipient and may be privileged. If you have received this email inadvertently
> or you are not the intended recipient, you may not disseminate, distribute,
> copy or in any way rely on it. Further, you should notify the sender
> immediately and delete the email from your computer.
> 
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
> 
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
  
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[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.uk/about/Profiles/h_bishop.html
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
  
_
Hotmail has tools for the New Busy. Search, chat and e-mail from your inbox.
http://www.windowslive.com/campaign/thenewbusy?ocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_1
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] RFS error question

[Dan Fitzgerald]

Perfect, thanks!
 
> From: dgo...@interlinebrands.com
> To: u2-users@listserver.u2ug.org
> Date: Thu, 17 Jun 2010 08:35:58 -0400
> Subject: Re: [U2] RFS error question
> 
> Dan,
> 
> You may want to look here. 
> https://u2tcint.rocketsoftware.com/developerzone/techarticles/wterhune0512/ 
> Below is extract from it.
> 
> 
> Listing 23. Runtime warnings, message 14
> 
> Invalid tm_afid,tm:1, U_tm_close, Sat Jul 7 14:45:33 2004, tm_afid:8,
> U_tm_aft_n:90. 
> 
> 
> When a udt process opens a data file, its tm buddy sends back a file 
> descriptor called TM AFID to the udt process. This TM AFID is verified by the 
> tm process whenever udt asks the tm to perform any operations on the file. 
> This message indicates that 1 is not currently a valid TM AFID. This problem 
> is most likely caused by the udt process double-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...@listserver.u2ug.org] On Behalf Of Dan Fitzgerald
> Sent: Wednesday, June 16, 2010 11:46 PM
> To: u2-users@listserver.u2ug.org
> Subject: [U2] RFS error question
> 
> 
> 
> 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?
> 
> 
> 
> _
> The New Busy is not the too busy. Combine all your e-mail accounts with 
> Hotmail.
> http://www.windowslive.com/campaign/thenewbusy?tile=multiaccount&ocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_4
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
  
_
The New Busy think 9 to 5 is a cute idea. Combine multiple calendars with 
Hotmail. 
http://www.windowslive.com/campaign/thenewbusy?tile=multicalendar&ocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_5
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

[U2] RFS error question

[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?


  
_
The New Busy is not the too busy. Combine all your e-mail accounts with Hotmail.
http://www.windowslive.com/campaign/thenewbusy?tile=multiaccount&ocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_4
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Filesystem options cio for AIX 5.3

[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
> 
> I am working with an AIX 5.3 system using Unidata 7.1.10 We are having some 
> performance issues that are directly related to I/O. The files have been 
> resized and brought down some of the I/O problems. In the past with some 
> Oracle system I have had to administer ( I still prefer the mv world ), we 
> used the cio options for mounting filesystems which allows for concurrent 
> reads and writes. Has anyone tried this with Unidata or know of any pitfalls 
> to doing so.
> 
> Thanks in advance
> 
> -Dan
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
  
_
Hotmail is redefining busy with tools for the New Busy. Get more from your 
inbox.
http://www.windowslive.com/campaign/thenewbusy?ocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_2
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[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 the REBUILD 25 hours ago, and have not 
> seen the timestamps for the file or any of its dat or over files since 
> an hour and a half into the rebuild.
> 
> The process is still taking 20% of processor time and I am under the 
> assumption that it is still working on rebuilding.
> 
> Is that a good assumption?
> 
> Any suggestions to check to see if progress is being made still?
> 
> Thanks in advance!
> 
> J
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
  
_
Hotmail is redefining busy with tools for the New Busy. Get more from your 
inbox.
http://www.windowslive.com/campaign/thenewbusy?ocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_2
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Universe and stripped drives

[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 check into that. Guess I could always add a second drive
> array for the third mirror later on (the drives are cheaper, not cheap
> enough yet - we are using SAS drives for the data drives, and SATA for
> the system drives - diffenent controllers).
> 
> > -Original Message-
> > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> > boun...@listserver.u2ug.org] On Behalf Of Dave Laansma
> > Sent: Wednesday, April 28, 2010 1:16 PM
> > To: U2 Users List
> > Subject: Re: [U2] Universe and stripped drives
> > 
> > My opinion is to stripe all your data over as many drives as possible.
> > 
> > Regarding mirroring, I would suggest a third mirror.
> > 
> > The third mirror can be broken anytime during the day and used for
> > backup, then 're-sync'd.'
> > 
> > This configuration provides for minimum data loss due to (the number
> > one
> > cause of data loss) disk failure.
> > 
> > Drives are cheap. Mirror up!
> > 
> > Sincerely,
> > David Laansma
> > IT Manager
> > Hubbard Supply Co.
> > Direct: 810-342-7143
> > Office: 810-234-8681
> > Fax: 810-234-6142
> > www.hubbardsupply.com
> > "Delivering Products, Services and Innovative Solutions"
> > 
> > 
> > -Original Message-
> > From: u2-users-boun...@listserver.u2ug.org
> > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George
> > Gallen
> > Sent: Wednesday, April 28, 2010 12:47 PM
> > To: U2 Users List
> > Subject: [U2] Universe and stripped drives
> > 
> > We are in the process of upgrading our system.
> > 
> > When we setup our current system, it was suggested we strip our data
> > drives (5) into one,
> > instead of having 5 separate drives, so it could pull more data at
> > once.
> > 
> > The new system will have 6 drives available for striping
> > 
> > We were going to have 6 drives striped into one, which would be
> > partitioned into our data areas
> > the thought being it would be faster disk access if it's pulling from
> > all 6 drives at once.
> > BUT...all of the partitions are on that one striped drive.
> > 
> > Would it be better to have (2) sets of 3 drives striped into one, and
> > setup the two most used
> > accounts on each of those drives, so now it's only pulling data from 3
> > drives, but there could
> > be less competition between the two accounts, since they are pulling
> > from separate drives?
> > 
> > Anyone played with this at all?
> > 
> > FYI, each drive is mirrored as well, so if there is a drive failure,
> > data loss is protected,
> > if there was a drive failure on both the main and mirror (same drive)
> > then with the
> > 6 drive strip, we stand to potentially lose more data, than if there
> > were 2 sets of 3 striped.
> > But...since we have full daily backups, and potentially, considering a
> > second backup during
> > the day, the amount of data loss would be minimalso I'm putting
> > that
> > off the table for
> > now in determining whether to go with a 3 or 6 stripe.
> > 
> > 
> > George Gallen
> > Senior Programmer/Analyst
> > Accounting/Data Division, EDI Administrator
> > ggal...@wyanokegroup.com
> > ph:856.848.9005 Ext 220
> > The Wyanoke Group
> > http://www.wyanokegroup.com
> > 
> > 
> > 
> > ___
> > U2-Users mailing list
> > U2-Users@listserver.u2ug.org
> > http://listserver.u2ug.org/mailman/listinfo/u2-users
> > ___
> > U2-Users mailing list
> > U2-Users@listserver.u2ug.org
> > http://listserver.u2ug.org/mailman/listinfo/u2-users
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
  
_
The New Busy is not the too busy. Combine all your e-mail accounts with Hotmail.
http://www.windowslive.com/campaign/thenewbusy?tile=multiaccount&ocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_4
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Universe and stripped drives

[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 caveat is that 
I'm assuming that these disks are all dedicated to UniVerse; if you're sharing 
them with, say, MS Outlook (some SANS do this, and the storage guys will tell 
you it doesn't matter. They are incorrect.), ouch.
 
> From: ggal...@wyanokegroup.com
> To: u2-users@listserver.u2ug.org
> Date: Wed, 28 Apr 2010 11:46:47 -0500
> Subject: [U2] Universe and stripped drives
> 
> We are in the process of upgrading our system.
> 
> When we setup our current system, it was suggested we strip our data drives 
> (5) into one,
> instead of having 5 separate drives, so it could pull more data at once.
> 
> The new system will have 6 drives available for striping
> 
> We were going to have 6 drives striped into one, which would be partitioned 
> into our data areas
> the thought being it would be faster disk access if it's pulling from all 6 
> drives at once.
> BUT...all of the partitions are on that one striped drive.
> 
> Would it be better to have (2) sets of 3 drives striped into one, and setup 
> the two most used
> accounts on each of those drives, so now it's only pulling data from 3 
> drives, but there could
> be less competition between the two accounts, since they are pulling from 
> separate drives?
> 
> Anyone played with this at all?
> 
> FYI, each drive is mirrored as well, so if there is a drive failure, data 
> loss is protected,
> if there was a drive failure on both the main and mirror (same drive) then 
> with the
> 6 drive strip, we stand to potentially lose more data, than if there were 2 
> sets of 3 striped.
> But...since we have full daily backups, and potentially, considering a second 
> backup during
> the day, the amount of data loss would be minimalso I'm putting that off 
> the table for
> now in determining whether to go with a 3 or 6 stripe.
> 
> 
> George Gallen
> Senior Programmer/Analyst
> Accounting/Data Division, EDI Administrator
> ggal...@wyanokegroup.com
> ph:856.848.9005 Ext 220
> The Wyanoke Group
> http://www.wyanokegroup.com
> 
> 
> 
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
  
_
The New Busy is not the too busy. Combine all your e-mail accounts with Hotmail.
http://www.windowslive.com/campaign/thenewbusy?tile=multiaccount&ocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_4
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Not Consistent Failure

[Dan Fitzgerald]

truss -pdf  will return a listing of every system call the process makes 
at the AIX kernel level, as well as any processes forked by the process (the 
'f' option). It's hard to read without a reference like W. Richard Stevens' 
"Advanced Programming in the Unix Environment", but if you see it bomb out 
right after it fails to open a file, for instance, that's a good clue. 
 
> Date: Tue, 23 Mar 2010 16:34:35 -0600
> From: ka...@ourldsfamily.com
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] Not Consistent Failure
> 
> I've not 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
> > 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:26:16 -0600
> >> From: ka...@ourldsfamily.com
> >> To: u2-users@listserver.u2ug.org
> >> Subject: [U2] Not Consistent Failure
> >>
> >> When ever I see someone post something that can't be replicated because
> >> it's inconsistent, I wonder what the answer is going to be.
> >>
> >> So, here goes:
> >>
> >> I have a client that has started experiencing a login anomaly. First,
> >> the
> >> use telnet, and second, they don't have passwords at the Unix level.
> >>
> >> They are on AIX 5.2.0.0 with Universe 10.2.12
> >>
> >> The things I've seen are:
> >>
> >> - the session doesn't make it into UV for their password prompt but
> >> drops
> >> straight to Unix.
> >>
> >> - I've checked permissions at various locations and at various levels.
> >>
> >> - I've commented out various parts of both /etc/profile and
> >> /u1/ACCT/.profile with no consistent noticeable change.
> >>
> >> - I've checked UV.LOGIN and ACCT > LOGIN as well and nothing has changed
> >> in either place, and they are performing minimal tasks.
> >>
> >> - I've added a sleep just before exec /u1/uv/bin/uv plus changed uv to
> >> uvsh to see if that mattered. It didn't change the failures.
> >>
> >> - Failures are either on the 2nd login, 4th login, 3rd and 4th, 6th and
> >> 7th, 2nd and 3rd and 5th or whenever the pattern can't be matched...
> >>
> >> In other words, there's no rhyme or reason that can be applied to this
> >> failure.
> >>
> >> This is a real head-scratcher for me and I'm hoping someone has seen
> >> this
> >> or has something to offer.
> >>
> >> TIA
> >>
> >> ---
> >> Karl Pearson
> >> ka...@ourldsfamily.com
> >> Owner/Administrator of the sites at
> >> http://ourldsfamily.com
> >> ---
> >> "To mess up your Linux PC, you have to really work at it;
> >> to mess up a microsoft PC you just have to work on it."
> >> ---
> >> Democracy is two wolves and a lamb voting on what to have
> >> for lunch. Liberty is a well-armed lamb contesting the vote.
> >> --Benjamin Franklin
> >> ---
> >> Children seldom misquote you. In fact, they usually
> >> repeat word for word what you shouldn't have said.
> >> ---
> >>
> >> ___
> >> U2-Users mailing list
> >> U2-Users@listserver.u2ug.org
> >> http://listserver.u2ug.org/mailman/listinfo/u2-users
> >
> > _
> > Hotmail: Trusted email with powerful SPAM protection.
> > http://clk.atdmt.com/GBL/go/210850553/direct/01/
> > ___
> > U2-Users mailing list
> > U2-Users@listserver.u2ug.org
> > http://listserver.u2ug.org/mailman/listinfo/u2-users
> >
> 
> 
> ---
> Karl Pearson
> ka...@ourldsfamily.com
> Owner/Administrator of the sites at
> http://ourldsfamily.com
> ---
> "To mess up your Linux PC, you have to really work at it;
> to mess up a microsoft PC you just have to work on it."
> ---
> Democracy is two wolves and a lamb voting on what to have
> for lunch. Liberty is a well-armed lamb contesting the vote.
> --Benjamin Franklin
> ---
> Children seldom misquote you. In fact, they usually
> repeat word for word what you shouldn't have said.
> ---
> 
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
  
_
Hotmail is redefining busy with tools for the New Busy. Get more from your 
inbox.
http://www.windowslive.com/campaign/thenewbusy?ocid=PID27925::T:WLMTAGL:ON:WL:en-US:WM_HMP:032010_2
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Not Consistent Failure

[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:26:16 -0600
> From: ka...@ourldsfamily.com
> To: u2-users@listserver.u2ug.org
> Subject: [U2] Not Consistent Failure
> 
> When ever I see someone post something that can't be replicated because
> it's inconsistent, I wonder what the answer is going to be.
> 
> So, here goes:
> 
> I have a client that has started experiencing a login anomaly. First, the
> use telnet, and second, they don't have passwords at the Unix level.
> 
> They are on AIX 5.2.0.0 with Universe 10.2.12
> 
> The things I've seen are:
> 
> - the session doesn't make it into UV for their password prompt but drops
> straight to Unix.
> 
> - I've checked permissions at various locations and at various levels.
> 
> - I've commented out various parts of both /etc/profile and
> /u1/ACCT/.profile with no consistent noticeable change.
> 
> - I've checked UV.LOGIN and ACCT > LOGIN as well and nothing has changed
> in either place, and they are performing minimal tasks.
> 
> - I've added a sleep just before exec /u1/uv/bin/uv plus changed uv to
> uvsh to see if that mattered. It didn't change the failures.
> 
> - Failures are either on the 2nd login, 4th login, 3rd and 4th, 6th and
> 7th, 2nd and 3rd and 5th or whenever the pattern can't be matched...
> 
> In other words, there's no rhyme or reason that can be applied to this
> failure.
> 
> This is a real head-scratcher for me and I'm hoping someone has seen this
> or has something to offer.
> 
> TIA
> 
> ---
> Karl Pearson
> ka...@ourldsfamily.com
> Owner/Administrator of the sites at
> http://ourldsfamily.com
> ---
> "To mess up your Linux PC, you have to really work at it;
> to mess up a microsoft PC you just have to work on it."
> ---
> Democracy is two wolves and a lamb voting on what to have
> for lunch. Liberty is a well-armed lamb contesting the vote.
> --Benjamin Franklin
> ---
> Children seldom misquote you. In fact, they usually
> repeat word for word what you shouldn't have said.
> ---
> 
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
  
_
Hotmail: Trusted email with powerful SPAM protection.
http://clk.atdmt.com/GBL/go/210850553/direct/01/
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] U2’s Latest Tour

[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] U2’s Latest Tour


U2’s latest tour dubbed"360 Degrees” has made it possess the biggest music
pay check. Billboard’s 2010 Money Makers list is lead by the veteran act
which has earned more than 108 (US Dollars)million in the year 2009.Bruce
Springsteen is on the second with 57(US Dollars) million and Madonna follows
the list with 47(US Dollars)  million earned in 2009. AC/DC is at the fourth
with 43 (US Dollars) million while Britney Spears makes it to the fifth
position with 38(US Dollars)  million. Pink’s career year with 36.3(US
Dollars) million ranked her 6th while the Jonas Brothers made 33.5 (US
Dollars)  million. Coldplay, Kenny Chesney and Metallica made it to Top 10
as well .Billboard piles up the list from excise collected through CD sales,
digital sales, tours, mechanical royalties (from radio and other sources)
and merchandise sales. Following the money, Billboard magazine determined
that U2 hauled in 108,601,283(US Dollars)  in 2009 which is not bad at all
if we consider that the quartet’s song “No Line on the Horizon” was only
able to sell about 1 million copies in U.S and was out of the Billboard
album chart in the month of November.

If you wish of owning a piece of U2 then this is the news for you. All the
fans of Bono and his boys can get their hands on a number of exclusive items
be it a pair of used shoes, backstage passes or candid Polaroid shots of the
rock legends, in an online auction which is expected to raise up-to £36,000.
Being auctioned on the New York website gottahave-rockandroll.com, these
items cost a fortune. Lola Cashman who is the Former U2 stylist has put up a
collection of 16 items for auction in the US that include Bono's rosary
beads and a Bible belonging to Larry Mullen, priced together for £6,300. The
former stylist was once involved in a court case for selling items belonging
to the rock legends which she collected  on their Joshua Tree tour from the
year 1987 onwards. After the judge’s decision that she could not sell the
items as they were not hers, she is now auctioning off those band items that
did belong to her. All the items in the auction are from the band's early
days which are expected to make up to £3,500. 
Singer and actor Jared Leto has expressed his pleasure to work with U2 while
saying that he would love to collaborate with U2. Speaking to RTE.ie
reporter, the front man of 30 Seconds to Mars said, "Yeah, I'd love to do
something with U2." Adding, “To do a song with Bono would be great.". Get
your  http://www.onlineticketspot.com/concerts/U2.php Cheap U2 Tickets 
before they sold out.
-- 
View this message in context:
http://old.nabble.com/U2%E2%80%99s-Latest-Tour-tp27887358p27887358.html
Sent from the U2 - Users mailing list archive at Nabble.com.

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] UniVerse Slow - Fixed

[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 
conscientiousness. If you haven't checked your file sizes in the past quarter, 
you're neglecting an important maintenance job. 

 

Periodic health checks are vital; U2 can run rings around everything else, but 
not if you have bottlenecks all over the system. Lock table sizing, file 
sizing, sync settings, select buffer settings, and, of course, programming 
techniques (I'm astonished at how many times I find files getting opened inside 
of loops, or how many times I see the same piece of data read a dozen times in 
a program, for example).
 
> Date: Thu, 11 Mar 2010 16:04:43 -0500
> From: bi...@hkmetalcraft.com
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] UniVerse Slow - Fixed
> 
> Dave:
> 
> Thanks for pointing this out. It happened to me because I have a habit of 
> grabbing the first example out of the UniVerse Reference Manual. I just 
> marked up my copy.
> 
> Upon seeing this post, perhaps Wally or someone at Rocket will take an action 
> item to tweak the next release of the UniVerse (and UniData) User Reference 
> manual changing it from say 2 1 1 to 2 11 1.
> 
> --Bill
> 
> 
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org 
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David A Barrett
> Sent: Thursday, March 11, 2010 3:02 PM
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] UniVerse Slow - Fixed
> 
> Bill,
> 
> >File MESSAGES Type= 2 Modulo= 1 Sep= 1
> 
> Coming across one of these in a system I'm working on always steams me. It 
> has to be one of silliest and most easily avoidable time-bombs people can set 
> in a system. The difference between a modulo 11 and a modulo 1 file on 
> performance is astronomical, and the disc cost of just making sure that every 
> file - even one you're absolutely positive will never have more that a couple 
> of records in - has at least an 11 or a 101 modulo is totally negligible. 
> 
> 
> 
> Dave Barrett
> Project Manager,
> Lawyers' Professional Indemnity Company (LAWPRO®)
> 250 Yonge Street, Suite 3101, P.O. Box 3 Toronto, Ontario M5B 2L7
> Tel: 416-598-5872
> Fax: 416-599-8341
> 
> This e-mail may be privileged and/or confidential, and the sender does not 
> waive any related rights and obligations. Any distribution, use or copying of 
> this e-mail or the information it contains by other than an intended 
> recipient is unauthorized. If you received this e-mail in error, please 
> delete it and advise me (by return e-mail or otherwise) immediately. 
> 
> Ce courrier électronique est confidentiel et protégé. L'expéditeur ne renonce 
> pas aux droits et obligations qui s'y rapportent. Toute diffusion, 
> utilisation ou copie de ce message ou des renseignements qu'il contient par 
> une personne autre que le (les) destinataire(s) désigné(s) est interdite. Si 
> vous recevez ce courrier électronique par erreur, veuillez le supprimer et 
> m'en aviser immédiatement, par retour de courrier électronique ou par un 
> autre moyen.
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
  
_
Hotmail: Trusted email with powerful SPAM protection.
http://clk.atdmt.com/GBL/go/201469227/direct/01/
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] TOP/LIMIT Equivalent?

[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 take
your item id, extract a numeric equivalent from it (i.e., a238rs45 becomes
23845), then divides by the modulo (a simplification, but reasonably
illustrative for our purposes). It takes the resulting remainder (if your
modulus was 101, this will be 9), adds 1 (because you can have a remainder
of 0), and puts that record into group #10. Unless you know your precise
hashing algorithm (which was proprietary, last time I checked), you simply
don't know where the record will land. (OK, if you have sequential numeric
id's, and you use group.stat.detail to analyze the file, you might be able
to predict it, but whatever algorithm you cook up goes out the window if you
resize or change the file type, and that's a lot of unnecessary work,
anyway). If you want a random sample, use SAMPLE. If you need a logically
related group (the last 100 records added, for example), then you should
apply selection criteria (SSELECT FILE WITH TIMESTAMP GE  BY-DSND
TIMESTAMP). The logic is in the data.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Adrian Halid
Sent: Thursday, February 18, 2010 8:06 PM
To: U2 Users List
Subject: Re: [U2] TOP/LIMIT Equivalent?

But how would you get the 2nd 100 (101 - 200) and the 3rd 100 (301 to 400)
without writing a subroutine to do it?


Regards

Adrian Halid
Senior Analyst/Programmer
 
IT Vision Australia Pty Ltd (ABN: 34 309 336 904)
PO Box 881, Canning Bridge WA 6153
Level 3, Kirin Centre, 15 Ogilvie Road, Applecross, WA, 6153
P:  (08) 9315 7000  F:  (08) 9315 7088
E:  adrian.ha...@itvision.com.au    W: http://www.itvision.com.au
    
___  
  
NOTICE : This e-mail and any attachments are intended for the addressee(s)
only and may
contain confidential or privileged material. Any unauthorised review, use,
alteration,
disclosure or distribution of this e-mail (including any attachments) by an
unintended recipient
is prohibited. If you are not the intended recipient please contact the
sender as soon as
possible by return e-mail and then delete both messages.
___



-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of fft2...@aol.com
Sent: Friday, 19 February 2010 4:55 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] TOP/LIMIT Equivalent?

In a message dated 2/18/2010 10:27:46 AM Pacific Standard Time, 
cla...@hme.com writes:


> You can sort first and then SAMPLE, too.>>

Caryl has the idea here if you really want the "Last" 100.
You can Sort BY-DSND which means "by descending" so if you want the last 
alphabetically or the last by ID or the last by some other field you can
sort 
on that and then Sample 100 ?  I've NEVER tried this.  Does it work?

If that doesn't work you can EXECUTE a sort by dsnd and then simply write a 
brief BASIC routine to pull off the "first" 100 of that list and output it!

Will "Where There's a Way there's a Will... or something" Johnson
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] TOP/LIMIT Equivalent?

[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-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Andrew E.
Tegenkamp
Sent: Thursday, February 18, 2010 12:50 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] TOP/LIMIT Equivalent?

In UniVerse, I can't seem to find the syntax like MSSQL's SELECT TOP 100 or
MySQL's LIMIT 100 clause.

Does UniVerse have this syntax somewhere I'm not seeing in the
documentation? I'm just trying to pull out the last 100 records of a table
and export them out as a sample.

Thanks,
Andrew

...
Andrew E. Tegenkamp
Director, Systems Integration
G3 Systems, Inc.
P:540.951.4300
F:540.951.4311
http://www.g3.com


___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[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. 
> Senior  Programmer/Analyst 
> (973)  515 - 9700  ext 5327 
> bro...@pny.com 
> - 
> We are continually faced with great opportunities 
> brilliantly disguised as insoluble problems. 
>  John W Gardner 
>  
>  Before printing please think about your environmental responsibility 
> 
> 
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org 
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kathleene M Hunter
> Sent: Tuesday, February 02, 2010 9:35 AM
> To: 'U2 Users List'
> Subject: Re: [U2] HP Unix "who am i"
> 
> Found the problem to be with the peek shell running on the new hp 3600
> b.111.31 ia64. It works only under the korn shell. So changed the users to
> start in the korn shell and then exec the peek shell and everything works.
> 
> Thanks for the information everyone.
> 
> 
> 
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kathleene M
> Hunter
> Sent: Wednesday, January 27, 2010 9:46 PM
> To: 'U2 Users List'
> Subject: Re: [U2] HP Unix "who am i"
> 
> Did this and it still does not work
> 
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Rubeor
> Sent: Tuesday, January 26, 2010 9:04 AM
> To: 'U2 Users List'
> Subject: Re: [U2] HP Unix "who am i"
> 
> Another long shot, but this was in the hp knowledge base. I had to cut and
> paste the article, so please forgive any formatting issues.
> 
> ---
> 
> 
> 
> Title: HP-UX 11.23 ssh: who(1) -m option fails to display as expected
> Document ID: emr_na-c00996974-3
> Submitted Date: 2007-04-17 20:01:19.0
> Last Modified Date: 2008-06-30 17:49:48.0
> 
> You may provide feedback (
> http://www11.itrc.hp.com/service/help/askQuestion.do ) on this document 
> HP-UX 11.23 ssh: who(1) -m option fails to display as expected
> PROBLEM
> With HPUX 11.23 a "who -Rm" added to .profile fails 
> to display as expected. For example, from the debug: 
> 
> + + who -Rm 
> + cut -d: -f1 
> + sed -n s/^.*(\(.*\))$/\1/p 
> DISPLAY=:0.0 
> 
> 
> CONFIGURATION
> Operating System - HP-UX 
> Version - 11.23 
> Subsystem - ssh A.03.x 
> 
> RESOLUTION
> This problem has been identified as a timing issue in 
> multiple versions of ssh A.03.x on HP-UX 11.23 and has 
> been isolated to the -m option. Other versions of HP-UX 
> appear to be unaffected. A fix is planned. 
> 
> The addition of a sleep(1) command has been found to 
> work around this issue. For example: 
> 
> sleep 6 
> who -Rm 
> 
> 
> ALT KEYWORDS
> ssh 
> "who -Rm" 
> "who -m" 
> 
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
> 
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
> 
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
  
_
Your E-mail and More On-the-Go. Get Windows Live Hotmail Free.
http://clk.atdmt.com/GBL/go/201469229/direct/01/
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Resize Question

[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.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 system to a Windows install of
Personal Edition. Not ideal but not sure if it's a deal-breaker as yet so
I'm moving on...

Then, I did fnuxi VOC and fnuxi ZIP. VOC was fine but on ZIP I got a warning
the secondary indices are defined in a unix location and if necessary, use
SET.INDEX to update file header to correct locations.  I am not sure how to
use SET.INDEX so I have not done anything with that.

Now I go to UniVerse and get "Your VOC is out of date. Update to current
release (Y/N)? If I select Yes, I get an error about &TEMP& being in my VOC
file but unable to create it. I believe this is because I do not have all
the data copied over from the live UniVerse server, so I select No and get
"Unable to open the operating system file "OC.O/LOGON.TESTER" where TESTER
is the account name logging on. That gives me a prompt so I can do
ANALYZE.FILE ZIP and I see the file type is 18, modulo is 4507 and
separation is 1. There are 44,098 records.

Then I try a "SELECT ST FROM ZIP" to get the states and I get an error
saying "File "D_ZIP" has modulo 16777216 which is > 10007. Please resize it
to modulo <= 10007 in order to use it in Personal Edition."

I have tried running RESIZE of various file types, modulo, and separation,
but I still get the error on D_ZIP every time. I have no idea how to get
D_ZIP down to <= 10007 or if it is even possible, or if the records being
44k+ means I cannot view it in personal edition or what exactly is going on
with this.

Can anyone help me past this or tell me why I can't get past it?

Thanks for any tips for a newbie,
Andrew

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Predicting application performance

[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 to be sure that the SBCS shared memory segment is
large enough. As in Highlander, there can be only one. Well, there _should_
be only one, anyway. If you ever have more than one, it's too small. Perhaps
run for a day or so with a cron job that counts those every minute or so. If
you're right on the cusp, where you shmget another, then fall under the
threshold, releasing it, then rise gain to need another, you'll see the
system crawling to the point where you'll be typing in a field, and it won't
even echo until 15 seconds later, when all of a sudden dozens of characters
will appear.

You may also want to capture user counts throughout the day; that would be a
strong hint about memory configuration. I forget: at 7.1, can you run in
64-bit? In 32-bit UD, there's some memory addressing constraints, as I
recall.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of
bradley.sch...@usbank.com
Sent: Wednesday, January 27, 2010 2:46 PM
To: U2 Users List
Subject: [U2] Predicting application performance

I haven't found anything in the archives and I don't remember seeing this 
specific question addressed by the group. Please forgive if this has 
already been discussed.

This is a mystery upon which I'm hoping this list can shed some light. 
I'll sit and watch nmon display CPU stats and see *tons* of waits but the 
end users experience no slowdowns. At other times nmon may show waits more 
in the 30% - 40% range and users start complaining about bad response 
times. We've tried watching I/O and memory/paging space also and don't see 
any discernible patterns.

Does anyone have thoughts on how to predict UD app performance based on 
CPU, I/O or other system stats? 

UD 7.1
AIX 5.3
Disk: SAN (EMC)
U.S. BANCORP made the following annotations
-
Electronic Privacy Notice. This e-mail, and any attachments, contains
information that is, or may be, covered by electronic communications privacy
laws, and is also confidential and proprietary in nature. If you are not the
intended recipient, please be advised that you are legally prohibited from
retaining, using, copying, distributing, or otherwise disclosing this
information in any manner. Instead, please reply to the sender that you have
received this communication in error, and then immediately delete it. Thank
you in advance for your cooperation.



-

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[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, maybe in a
proc. Sounds like you have options...

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Evan Carroll
Sent: Wednesday, January 20, 2010 7:05 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] UniVerse RetreiVe how do I query a file for all of its
column's values?

This is a repost from a stackoverflow question I asked:
http://stackoverflow.com/questions/2068026/universe-retreive-how-do-i-query-
a-file-for-all-of-its-columns-values


=== START REPOST ===
In UniVerse you can't query a file for all of its columns unless the @
phrase in your file's dictionary is set to all of the tables columns.
If it isn't how do you query a table for all of its column's values?
So I can get the total column listing (column name & display name)
using:

LIST DICT file NAME

This will return a listing of all columns and their display names. How
do I then query the table for all of the columns it has?

LIST file

Will only query it for LIST file @id (@id is the only thing in @).

=== END REPOST ===

I'd like to follow up with a request to see if anyone has a copy of a
BASIC program that does this, I imagine it is something every heavy
universe must keep in arms reach.

Thanks a ton,

-- 
Evan Carroll
System Lord of the Internets
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[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...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Beckwith
Sent: Monday, November 16, 2009 6:01 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] David Beckwith/WA/QBE/Insurance is out of the office.


I will be out of the office starting  16/11/2009 and will not return until
20/11/2009.

I will respond to your message when I return.

- 
IMPORTANT NOTICE : The information in this email is confidential and may
also be privileged. If you are not the intended recipient, any use or
dissemination of the information and any disclosure or copying of this email
is unauthorised and strictly prohibited. If you have received this email in
error, please promptly inform us by reply email or telephone. You should
also delete this email and destroy any hard copies produced.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[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: Wednesday, October 21, 2009 2:46 AM
To: 'U2 Users List'
Subject: Re: [U2] Distributed file on Unidata Unix (DEFINE.DF)

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.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Manu Fernandes
Sent: Wednesday, October 21, 2009 1:56 AM
To: U2 Users List
Subject: [U2] Distributed file on Unidata Unix (DEFINE.DF)

Hello,

I'm looking for a solution to distribute a Unidata/Unix Hashed file like
Universe does with the DEFINE.DF verb and PartKey algorythm.

Is there someone with any idea ?

With kind regards.
Manu

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[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.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Manu Fernandes
Sent: Wednesday, October 21, 2009 1:56 AM
To: U2 Users List
Subject: [U2] Distributed file on Unidata Unix (DEFINE.DF)

Hello,

I'm looking for a solution to distribute a Unidata/Unix Hashed file like
Universe does with the DEFINE.DF verb and PartKey algorythm.

Is there someone with any idea ?

With kind regards.
Manu

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] GOOD NEWS From Susie

[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), I'm 
still astonished that U2 never took off. Of course, I'm also astonished that 
the best selling beers are swill, people still vote for Democrats and 
Republicans, Windows is the dominant OS, and Peter O'toole never won an 
Oscar(TM).

 

On the other hand, I started developing a data center inventory app in UV PE 3 
weeks ago, so maybe I'm not so prescient as I'd like. I mean, you need 4 
dimensions to do it. Physical location on the floor, where it is in the rack, 
what it is, what it's running, when maintenance/upgrades are due, contracts & 
expiration dates, power consumption, BTU's, who "owns" it, etc.
 
> Date: Wed, 16 Sep 2009 21:41:34 +0100
> From: mec...@gmx.net
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] GOOD NEWS From Susie
> 
> I hope you are right.
> 
> But what if they are not even interested in selling new seats and are 
> quite happy to collect licence and support fees without doing any new 
> development?
> After all this is corporate America and acquisitions are not necessarily 
> made to drive a product forward.
> IBM can show some positive figures for the next quarter, share prices 
> might go up and managers can expect nice bonuses and sell some stock 
> options.
> And for Rocket it may just be another legacy system they acquire and 
> keep supported as it is their business plan.
> Since Universe and Unidata are so stable, they should be able to do that 
> with very little staff.
> And a little asset-stripping may more than recover the purchase costs.
> So everybody wins as far as the investors are concerned.
> Who cares about the members of the U2 team, VARs and their staff or us 
> MV-professionals who work for U2 end users?
> 
> I prefer to be a pessimist - at least that way you never get 
> disappointed; and if you happen to be wrong it is always to the better ;-).
> 
> 
> George Land wrote:
> > Personally I view it as a very good sign that they are taking a back seat
> > and letting the U2 people get their message out to their customers. Sure a
> > message from the new owners is needed soon but not doing it up front is a
> > sign that they are interested letting the team get on with the business
> > without getting too much in the way
> >
> > George
> >
> >
> > On 16/09/2009 19:33, "Charles Stevenson"  wrote:
> >
> > 
> >> Chuck,
> >> Impress upon Rocket the need for THEM to make a public statement.
> >> It's nice to hear news from you & from Susie, and I look forward to
> >> reading whatever you post, but, come on, Rocket! the new owners need to
> >> say something.
> >> Chuck
> >>
> >> 
> >>> All,
> >>> I've been speaking to an executive at Rocket and more calls are
> >>> being scheduled. What I've heard so far is vague (legal reasons) but
> >>> very upbeat. The next call should contain some genuine news. As I get
> >>> it, you will get it and it will be posted on U2UG.org.
> >>>
> >>> - Charles "Staying On The Hunt for Details" Barouch
> >>> 
> >> ___
> >> U2-Users mailing list
> >> U2-Users@listserver.u2ug.org
> >> http://listserver.u2ug.org/mailman/listinfo/u2-users
> >> 
> >
> > ___
> > U2-Users mailing list
> > U2-Users@listserver.u2ug.org
> > http://listserver.u2ug.org/mailman/listinfo/u2-users
> >
> > 
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users

_
Your E-mail and More On-the-Go. Get Windows Live Hotmail Free.
http://clk.atdmt.com/GBL/go/171222985/direct/01/
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Indexing

[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 or 6 indices on a file. Also, compound selects are
often less efficient than actually doing multiple selects.

Building indices means exclusive locks on the file, i.e., downtime. The
good news is that the builds are usually very quick.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bessel, Karen
Sent: Wednesday, September 09, 2009 5:24 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Indexing

I am not a UV newbie by any means, but I've never used indexing, and I
need to know where to start, with reading to gain some knowledge on the
documentation.

 

Any particular area of the IBM technical documentation that might be
particularly helpful to this noob to the wide world of indexing?

 

Thanks!

 

 



Karen Bessel
Software Developer

Tyler Technologies, Inc.
6500 International Parkway, Suite 2000
Plano, TX 75093
Phone: 972.713.3770 ext:6227
Fax: 972.713.3780 
Email: karen.bes...@tylertech.com
Web: http://www.tylertech.com


 
Tyler is proud to be the Platinum Sponsor of 
The Court Technology Conference 2009
Sept. 22-24, 2009 | Denver, CO
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

[U2] UD equivalent of UV FILE.USAGE?

[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

[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 requirement to Connect to and Update the Universe Database from
an external system.
We will also need to Connect to and Update an external system (possibly SQL
Server 2005) from the Universe System.

We are currently using Universe 9.6...  .

What are the best methods/technologies that I should consider and those that
I should avoid.


Thanks in Advance for any feedback on this subject.

John Castilletti
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] [UV] Hang

[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:u2-users-boun...@listserver.u2ug.org] On Behalf Of Barry Rogen
Sent: Monday, July 27, 2009 10:42 AM
To: U2 Users List
Subject: [U2] [UV] Hang


We have an HPUX  11.23 system using UniVerse 10.1.24.  We are
having issues with users logging into UniVerse where the process just
hang. The hang point is...

(c)Copyright 1989-1993  The Open Software Foundation, Inc.
(c)Copyright 1990 Motorola, Inc.
(c)Copyright 1990, 1991, 1992 Cornell University
(c)Copyright 1989-1991 The University of Maryland
(c)Copyright 1988 Carnegie Mellon University
(c)Copyright 1991-2003 Mentat Inc.
(c)Copyright 1996 Morning Star Technologies, Inc.
(c)Copyright 1996 Progressive Systems, Inc.


  RESTRICTED RIGHTS LEGEND
Use, duplication, or disclosure by the U.S. Government is subject to
restrictions as set forth in sub-paragraph (c)(1)(ii) of the Rights in
Technical Data and Computer Software clause in DFARS 252.227-7013.


  Hewlett-Packard Company
  3000 Hanover Street
  Palo Alto, CA 94304 U.S.A.

Rights for non-DOD U.S. Government Departments and Agencies are as set
forth in FAR 52.227-19(c)(1,2).



The process never continues or "comes back".   If you kill the
wIntegrate session, and start a new one, you can log on fine. Sometimes
take 2-3 attempts.

Ideas ? 

Barry  Rogen
PNY Technologies, Inc.
Senior  Programmer/Analyst
(973)  515 - 9700  ext 5327
bro...@pny.com

-
We are continually faced with great opportunities
brilliantly disguised as insoluble problems.
 John W
Gardner

P Before printing please think about your environmental responsibility



27/7/2009NOT INTENDED AS A SUBSTITUTE FOR A WRITING 

NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A PART, OR
IN ANY ATTACHMENTS THERETO, SHALL CONSTITUTE A BINDING CONTRACT, OR ANY
CONTRACTUAL OBLIGATION BY PNY, OR ANY INTENT TO ENTER INTO ANY BINDING
OBLIGATIONS, NOTWITHSTANDING ANY ENACTMENT OF THE UNIFORM ELECTRONIC
TRANSACTIONS ACT, THE FEDERAL E-SIGN ACT, OR ANY OTHER STATE OR FEDERAL LAW
OF SIMILAR SUBSTANCE OR EFFECT.  THIS EMAIL MESSAGE, ITS CONTENTS AND
ATTACHMENTS ARE NOT INTENDED TO REPRESENT AN OFFER OR ACCEPTANCE OF AN OFFER
TO ENTER INTO A CONTRACT.  NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF
WHICH IT MAY BE A PART, OR IN ANY ATTACHMENTS THERETO SHALL ALTER THIS
DISCLAIMER.  

This e-mail message from PNY Technologies, Inc. is for the sole use of the
intended recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or distribution is
prohibited. If you are not the intended recipient, please contact the sender
by reply e-mail and destroy all copies of the original message. 


___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] "WR" Group Lock

[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.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach
Sent: Monday, July 27, 2009 4:30 AM
To: 'U2 Users List'
Subject: Re: [U2] "WR" Group Lock

David

Martin is right. Sorry. He usually is.

A WR lock is a transient lock, it is held only during the time a process is
attempting to write to / restructure a group. For whatever reason, a process
(possibly the previous write) has crashed or the write has entered a loop
(screwed pointers) or hit a semaphore/memory issue when trying to extend.
Whichever, there is a good chance that file is now stuffed. Fortunately
these things are very, very rare. Unfortunately, you've been hit. As for the
cause: often it is something outside of UniVerse, hardware/bus error or some
external process affecting the file.

Since you're unlikely to reproduce the same circumstances, the only real
options are to monitor, watch and check your backups. And hope it doesn't
happen again..

Bad luck.

BTW if it's a small file with a single item, why is it dynamic? That's
pointless overhead.

Brian

> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org 
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of 
> Norman, David (Health)
> Sent: 27 July 2009 06:18
> To: 'u2-users@listserver.u2ug.org'
> Subject: [U2] "WR" Group Lock
> 
> In what situations can a WR lock be held on a group and not 
> released ? (UV10.0.16 HP-UX 11i) We've had this situation in 
> one of our test (fortunately) accounts and can't explain it.
> All users got stuck waiting for the group lock to be released 
> - we couldn't even LIST or COUNT the file.
> 
> Active Group Locks:Record 
> Group Group Group
> Device Inode  Netnode Userno  Lmode G-Address.  Locks 
> ...RD ...SH ...EX
> 1073807361 900210 31   7 IN  1  5 
> 0 0 0
> 1073807361 104830 73  19 IN800  2 
> 0 0 0
> 1073807361 529850 73  24 WR  0  0 
> 0 0 0
> 
> I would also have thought that there would have been a number 
> in the Group EX column.
> We had to log out the user with a kill -9 and unlock their 
> locks as a kill -15 had no effect.
> The file in question is dynamic, with a modulus of 1 and only 
> had 1 record in it (mildly overflowed).
> I have read Martin Phillips' explanation of group locks, and 
> favour his technical suggestion that in this situation "your 
> system is stuffed".
> The notes for the Internals course don't help either.
> 
> Any comments would be appreciated !
> 
> David Norman
> Senior Software Engineer - SA Ambulance Service
> 
> ICT Services
> SA Health
> Government of South Australia
> 
> Box 3, GPO
> Adelaide, South Australia 5001
> *+61 8 8274 0384
> * fax +61 8 8271 4844
> * 
> norman.da...@saambulance.com.au e.com.au>
> 
> 
> This e-mail may contain confidential information, which also 
> may be legally privileged. Only the intended recipient(s) may 
> access, use, distribute or copy this e-mail. If this e-mail 
> is received in error, please inform the sender by return 
> e-mail and delete the original. If there are doubts about the 
> validity of this message, please contact the sender by 
> telephone. It is the recipient's responsibility to check the 
> e-mail and any attached files for viruses.
> 
> 
> 
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
> 

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

___
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.

[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 like mixed case for readability, plus it makes the code look less
Cretacious. The downside is that unless all of the legacy code has been
rewritten, in order to - for example - find all of the write commands, I
have to do multiple searches & account for typos (Write vs write, in
addition to WRITE). Not much of a downside. I use camelHump in my own stuff
(great name, thanks to whoever threw it in here!).

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson
Sent: Monday, June 29, 2009 2:43 PM
To: U2 Users List
Subject: Re: [U2] Mixed Case UV Basic Programming Standards.

I started this thread and I thank those who have helped me think about 
it.  Some good ideas there.

But, hey guys, one of the thread's rules was:

   "2. NOT about GOTO.  Take it outside."

So if you don't stop, I will have to come down on this with my full 
authority.  (My full authority consists of a polite request to change 
the subject line & abandon this thread.  Can't think of anything else.)

I think all that can be said about GOTO has been said; everyone already 
knows every arguments on every side.  If you have a standard in that 
regard & I'm programming for you, I promise to abide by it & make it work.

cds
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

[U2] Web DE 4.4.2 release

[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.

[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 like the way I use mixed case, so it tends to evolve.  Not good, 
because consistency in programming style throughout an application makes 
for easier maintenance, & maintainability is the god of software quality.

So I am wondering how others use mixed case.
Do you capitalize/lower/mix case for  commands? Operators? Variables? 
Equates? etc.
How do you use/not use special characters in variable names?

For example:
   readu OrderMaster from ORDER.MASTER, OrderMasterId locked ...
   readU OE_rec from OE_f, OE_id  locked ...
   ReadVU OE_Date From ORDER.MASTER, OE$Id,  OE$Date Locked ...
   READU order.master.rec( oe$date ) FROM order.master.file, 
order.master.id LOCKED ...
That sort of thing.

I hesitate to even ask this for fear of starting a war. So ground rules 
for this thread:

1. NOT about MERITS of Uppercase only vs. Mixed Case programming.
 I am only interested in answers from people who actually use mixed 
case.
2. NOT about GOTO.  Take it outside.
3. This is about PREFERENCE, NOT SUBSTANCE.
 By "substantive" I mean rules like:
- Only open a file once.
   - Readu should always have a locked clause.
 By "preference" I mean stuff like my example.  They are all 
functionally equivalent.
4. NO ARGUMENTS about whether someone's style is good or bad, or yours 
is better.
   Explaining why you do it a certain way is helpful, though.
   Just remember, when it comes to preferences, no two programmers 
will agree,
   yet consistent style, whate'er it be, increases maintainability.

Thanks,
Chuck Stevenson
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

RE: [U2] UV resize error

[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
> just Universe processes - can cause the error. If the file is opened by any
> other process, that would be sufficient for the exclusive use check to
fail.
> So things to look out for extend beyond just Universe. This could include
> scheduled tasks/daemon processes, replication, including possibly built-in
> disk replication type accesses, backups, etc.
>
> Laure Hansen,
> City of Redwood City - Information Technology
> 1017 Middlefield Road - Redwood City, CA 94063
> Office 650-780-7087 - Cell 650-207-3235 - Fax 650-556-9204
> lhan...@redwoodcity.org
>
> o
 Please think green before printing this e-mail
>
> Subscribe to receive Redwood City E-News, news releases,
> or other documents via email: Click here to register/subscribe
>
>
> -Original Message-
> From: owner-u2-us...@listserver.u2ug.org
> [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of John Jenkins
> Sent: Tuesday, May 05, 2009 9:57 AM
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] UV resize error
>
> Sometimes problems like this can arise if you run UniVerse foreground
shells
> from root crontab on AIX (ans: donbt do it).
>
> "crontab -l" as root will give you the list of jobs - take a look (maybe).
> This can leave a footprint behind if it's historic - compare the number of
> attaches on the UniVerse shared memory segment with the number of attached
> processes that exist. The main shared memory segment attaches to itself, so
> the count of all "ace" segments should equal the attach count. "ps
-efl"grep
> ace|wc -l".
>
> Another useful indicator (over time - a spot check doesn't help) is to look
> for dead processes accruing:
>
> "ps -efl"grep 0x"
>
> Lastly - is AIX paging? - the resolution process can result in random Unix
> processes being shot dead on the spot.
>
> Let us know if anything turns up.
>
> Regards
>
> JJ
>
> -Original Message-
> From: owner-u2-us...@listserver.u2ug.org
> [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Eric Rosenzweig
> Sent: 05 May 2009 01:24
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] UV resize error
>
> We've had similar issues with little luck. We've unlocked the inode of the
> over and data sections as well as all the index inodes and have had limited
> success. Sometimes it works, sometimes it doesn't.
>
> My suspicion is that there's a dead process that universe is not showing in
> LIST.READU EVERY or PORT.STATUS. When we've had only a few users on the
> system, we were once able to use
>
> ipcs -mop | grep ace
>
> to look for universe sessions(hex address for universe sessions start with
> ace) and found a pid in memory that wasn't actually showing up in ps. Once
we
> removed that memory segment with:
>
> iprm -m , where  is the shared memory id returned in the above
> command, we were able to resize the file.
>
> If you have a lot of users on at any one time this will be tough to
reconcile.
> I suppose you could write a utility to compare pids returned in ipcs with
pids
> returned with ps for universe sessions to see if one was missing.
>
> Lastly, if youbre accessing the database via rpc there could be an rpc
> connection that isn't letting go, but you'd see these in the ipcs results.
>
> I know this isn't a fix, but it may be helpful.
>
> P.S. Were on an AIX box running Universe 10.2.4.
>
> 
> Eric Rosenzweig
> Vice President, Information Systems
> Application Development and System Administration
> Petco Animal Supplies, Inc.
> 9125 Rehco Rd.
> San Diego, CA 92121
> (858) 453-7845 x3125
> (858) 638-2120 fax
> mailto:eri...@petco.com
> o
 Think before you print
>
>
> -Original Message-
> From: owner-u2-us...@listserver.u2ug.org
> [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of
iggch...@comcast.net
> Sent: Monday, May 04, 2009 2:56 PM
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] UV resize error
>
> Not that this is any help but I had the same issue this weekend on uv10.2.7
> on
> HPUX 11.11.
>
>
>
> No other users...
>
> /etc/fuser showed on processes...
>
>
>
> I assumed that our backup process had it but haven't had time to confirm.
>
>
>
>
>
>
> - Original Message -
> From: "John Hester" 
> To: u2-users@listserver.u2ug.org
> Sent: Monday, May 4, 2009 4:01:39 PM GMT -06:00 US/Canada Central
> Subject: [U2] UV resize error
>
> I got an error message I've never seen before when attempting to resize
> a couple of dynamic files to static hashed files over the weekend:
>
> ---
> RESIZE error! Unable to gain exclusive use necessary to continue.
> File is currently in use by other processes. B Please try again
> at a later time when the file is no

RE: [U2] UV 10.1.22; Dynamic File question

[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
Subject: Re: [U2] UV 10.1.22; Dynamic File question

Allen Egerton wrote:
> The situation is that I'm potentially adding a million records to a
> dynamic file.  That's not hypothetical, it's a real life scenario.  And
> I don't want to wait while the file splits multiple times over the
> course of the add.  I don't have that large a window.  I want to force
> the file to expand the weekend before so that when I add the records the
> file isn't rebuilding.
>
> The file's already dynamic, so setting Minimum.Modulus doesn't seem to
> do me much good unless I can figure out how to force it to split to that
> minium.modulos.  And there's the crux of my question.  How can I force
> it to split?
Allen,
Only doing CONFIGURE.FILE . . . MINIMUM.MODULUS  does not make the file 
grow.  It just tells UV that if & when the file ever grows that big, 
don't let it shrink smaller. You need to be sneakier.
Here are 2 ways reserving space on DATA.30,  & one for OVER.30.

1.  Do it this way if you can't have any downtime,  but can sneak 
writing one bogus little record.

Tinker with MERGE.LOAD & SPLIT.LOAD then repeatedly write a fake record, 
so that each write triggers a split until you get to the size you want.
Let's say you want min mod of 10,000 and your current mod is 1,000
CONFIGURE.FILE YOURFILE   MINIMUM.MODULUS 1   MERGE.LOAD 1  
SPLIT.LOAD 2
run this:
   open "YOURFILE" to F else stop
   for i  = 1000 to 1  ;* you need 9000 =10,000-1,000 splits
  write '' F, 'dummy'
  delete F, 'dummy'
   next i

Now set MERGE.LOAD & SPLIT.LOAD TO where you want them (usually 50 & 80).
Until you load your real data you may be well below MERGE percentage,  
but merges will not happen because of minimum.modulus parameter..


2. Use resize if you can get exclusive use of the file.  (I don't think 
"CONCURRENT" works with dynamic files.  but I'm wary with static too.)
RESIZE will allow you to set the minimum modulus, but maybe not using 
the syntax as documented. 
And syntax differs according to acct flavour and OS (and UV rel?)
If RESIZE does nOt recognize MINIMUM.MODULUS on the command line,  then 
specify the mod explicitly, like you would a static hashed file.  That 
will become the minimum.modulus and the file will be sized accordingly.

  RESIZE YOURFILE 30 1 4  [SEQ.NUM]  (syntax different in Pick 
flavour)

will resize the file,  type 30, setting MINIMUM.MODULUS TO 1  and 
reserve the disk space in DATA.30, setting the current modulus to 1 too.
(Of course, if the file is already larger than that, the current modulus 
will be larger than 1.)

3. Neither of the above will reserve room in OVER.30.   If you know what 
your data will be like, then you know how much overload you'll need.
If you have the luxury of being able to create bogus data, you could 
write many large records so that OVER.30 grows.  Then delete all the 
bogus large records.
Other han that,  I don't know a way to make OVER.30 grow.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Record Size Limit in UV

[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
open for a month; the mv field holding the transaction remote key was
growing to 1-2Mb, and they weren't using raise() & lower() to maintain the
pointer, so every transaction had to start reading at the first byte... 

Anyway, they put a forced limit of 100 transactions per batch into the code,
and then with some resizing went to 1400 tpm. Further resizing & hardware
upgrades & app tuning got 'em above 3k tpm.

-Original Message-
From: owner-u2-us...@listserver.u2ug.org
[mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Charles Stevenson
Sent: Thursday, April 23, 2009 1:12 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Record Size Limit in UV

I've seen records at least an order of magnitude larger than that.  Unix 
& Windows. Megabytes.  I want to say much larger than that, but I can't 
verify that and when numbers get that big, my brain can't get around 
them.  ( e.g.,  $1,000,000,000,000: www.pagetutor.com/trillion/index.html  )

I don't know of absolute limits,  but performance takes a dive, of 
course: lock contention, frequent updates, inappropriate indexes, 
selections w/o indexing poorly sized files (they should be type 30, if 
they must exist.  The large records get isolated in their own 
overflow).  In general, U2 responds well to size abuse. Performance 
degradation is fairly linear & responds well to throwing more hardware 
at it.  But at some point degradation curve becomes geometric.

I'm curious about whether your scenario matches the usual: i.e., an 
application that has outgrown its original design, with a multi-valued 
association in that gets updated frequently through the lfe of the record.
The original design intended a few mv entires, until the business 
operation it represents gets closed.   At some point someone decided to 
use the association for some additional purpose.   Some records remain 
small, some grow, resulting in a very lumpy file.  Many times it's the 
users trying to respond quickly to a changing business need,  w/o 
waiting for IT to do the enhancement (they invent new status codes, 
etc.).  Sometimes it's programmers enamored by the siren call of mv nesting.

Adam Taylor wrote:
> Hey all,
>
> Can anyone tell me what (if any) the current record size limit is in UV
10.2?
> We've currently found ourselves in a situation where certain fields in a
data
> file will contain 100K+ characters and we would like to be proactive about
any
> potential problems if they exist.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] UniVerse and Transaction Logging

[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 have this condition. When you use uvrolf (the rollforward program) to
restore the tlogs on the DR box, when uvrolf sees the start of a
transaction, but doesn't see the next log, it assumes that this is a failed
transaction and drops it. Then, when the next log comes along, it sees the
end of that dropped transaction as a failed transaction as well, and
proceeds to restore the next transaction. The effect is random (you don't
know which transaction will be the last one), and only shows up if you're
looking for a transaction that dropped. Given 5Mb tlogs, and an average
group size of 2K, you'd have a 99.95% chance of dropping the last
transaction in each log, thereby losing 1 out of every 2500 updates.

I've thought about fixes, and it would probably work if you rolled forward
each log twice, once when it comes over, and once when the next one comes
over. You'd want to flip the flag back to have it show as not rolled forward
so that you could do it the second time. You'd actually want to be sure to
copy the original to another directory before running uvrolf against it,
then copy it in again when the next log arrives. I think uvrolf keeps track
of which log it expects next, and you'd have to decrement that (in more than
one place, IIRC). It's a bit ugly, but it could work. I'm reminded of the
Bugs Bunny where he gets stuck in Australia, and hitches a lift back in a
kangaroo's pouch with the baby kangaroo. He's wearing a captain's hat, and
starts barking orders: "Hoist the mizzenmast! Trim the sails! Batten down
the hatches!". The baby kangaroo says, "But I already battened down the
hatches". Bugs: "Batten 'em down again! We'll show them hatches!".





-Original Message-
From: owner-u2-us...@listserver.u2ug.org
[mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of David Senecky
Sent: Monday, March 30, 2009 6:06 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] UniVerse and Transaction Logging

Are there any known problems/issues/obstacles with UniVerse 10.2 & 10.3 and
Transaction Logging on AIX 5.3?

I am looking for a DR solution using the above, are you using this? any tips
/
traps?

David


Disclaimer Notice

This message contains privileged and confidential information intended only
for the use of the addressee named above. If you are not the intended
recipient of this message you are hereby notified that you must not
disseminate, copy or take any action or place any reliance on it. If you
have
received this message in error please notify Ultradata immediately on +61 3
9291 1600. Any views expressed in this message are those of the individual
sender, except where the sender specifically states them to be the views of
Ultradata Australia Pty. Ltd.

To unsubscribe from receiving commercial electronic messages from Ultradata
Australia please email unsubscr...@ultradata.com.au with the subject heading
"Unsubscribe".
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

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

[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-users@listserver.u2ug.org
Subject: RE: [U2] Does anybody have a hot backup server?

We have several customers, running UniVerse on Linux and Windows
platforms, that use UV transaction logging to keep a backup server
nearly current with their main server.  We have scripted the copying of
full log files to the backup server where another script rolls them into
a copy of the main database (account).  On pre 10.2 UniVerse, the backup
server is within one full log (10 mb worth of transactions) with the
main server (about 15-30 minutes).  On a UniVerse 10.2 server, running
on Windows, we have set the logs to "time out" after two minutes, so
that the backup server is within two minutes of being current with the
main server.  

The solution is well behaved and we have had it in place for the past
few years.

Kevin M. Sproule
Sr. Technical Consultant
AFS Technologies, Inc.
2141 E. Highland Ave, Ste. 100
Phoenix, AZ 85016
Care Center: (602) 522-8181
Main: (602) 522-8282
e-mail: kev...@afsi.com

 
- -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 together a backup strategy that involves keeping a 
standby server within two data hours of the primary. The idea is to be 
able to have users log into the backup server and keep the business 
running in the event of a crash.

I'd like to hear what solutions others have found for this.

I've been trying to contact IBM for the last 6 months but they haven't 
answered and my ERP vendor doesn't know how to do this.

Any ideas are appreciated.

TIA


- ---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

--

End of U2 Users Digest V1 #2581
***


u2-users-digest mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

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

[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 (and it effectively
always does), when you go to roll forward, if you don't have the next log,
that last update is seen as a failed transaction, and is dropped. 

You can do a workaround, but if you're just shipping tlogs across & using
uvrolf to update, you're 99.% sure to be losing one transaction per
tlog. When you do the fail over, unless you can recover that in-process tlog
to the DR box, you'll lose whatever's in there, as well.

-Original Message-
From: owner-u2-us...@listserver.u2ug.org
[mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Manu Fernandes
Sent: Wednesday, March 18, 2009 5:39 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Does anybody have a hot backup server?

Hi,

Under Universe/Linux we use Data Replication Block Device.  www.drbd.com
(open source linux product)
A low level software called between logical partition and hdd partition.
Cluster over LAN.

We define it on partitions where Universe db is installed (including
universe himself).

On the hot-standby server, the same partition is created and not mounted
(universe is not started ~ for this raison, we don't need IBM's license)
On fail-over, we switch the ip adress to the hot-standby server, we mount
the partition, we boot uv and users can work ... 2 minutes.

One restriction, we don't use DYNAMIC files because the headers are not
permanently flushed when write occurs files.

Coupled with Universe Transaction Logger set on strategic files to ensure
"record update integrity".   

My two pence.
Manu

> -Message d'origine-
> De : owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-
> us...@listserver.u2ug.org] De la part de Jeff Powell
> Envoyi : mercredi 18 mars 2009 20:07
> @ : u2-users@listserver.u2ug.org
> Objet : [U2] Does anybody have a hot backup server?
> 
> I am trying to put together a backup strategy that involves keeping a
> standby server within two data hours of the primary. The idea is to be
> able to have users log into the backup server and keep the business
> running in the event of a crash.
> 
> I'd like to hear what solutions others have found for this.
> 
> I've been trying to contact IBM for the last 6 months but they haven't
> answered and my ERP vendor doesn't know how to do this.
> 
> Any ideas are appreciated.
> 
> TIA
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

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

[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 this condition. You can minimize this risk by minimizing overflow,
but it's probably impossible to eliminate it.

Outside of uv replication, I don't think that there's a working solution to
this "in-flight transaction" problem. With Unidata, RFS handles it nicely.

---
We use LifeKeeper from Steeleye Technologies to replicate linux
partitions at the OS level for UV redundancy.  The servers are right
next to each other and replication is done over 3 gigabit NICs - 1 for
each of 2 partitions, and an extra for redundancy.  There are crossover
cat5 cables running directly between the NICs.  The users connect to a
virtual IP address that points to a 4th NIC on whichever node is
currently active.  In the event of a failover, LifeKeeper handles moving
the virtual IP address, mounting the filesystems, and the startup of
applications.  We have yet to experience a failover on the current
hardware, but I found during pre-installation testing that UV was
running on the backup box within a minute or so of failing over.  YMMV.
LifeKeeper allows an application dependency hierarchy to be created so
you can define the order in which applications start.  In our case, UV
depends on access to Active Directory (samba/winbind) as well as having
the underlying filesystem mounted.

LifeKeeper is built on top of linux software RAID, so /proc/mdstat on
the active node has the following contents:

Personalities : [raid1]
md1 : active raid1 nbd9[1](W) sdb2[0]
  24065370 blocks super non-persistent [2/2] [UU]
  bitmap: 2/184 pages [8KB], 64KB chunk, file:
/opt/LifeKeeper/bitmap_ntdata

md0 : active raid1 nbd1[1](W) sdb1[0]
  80381196 blocks super non-persistent [2/2] [UU]
  bitmap: 28/614 pages [112KB], 64KB chunk, file:
/opt/LifeKeeper/bitmap_uvdata

while the backup node shows no mounted RAID filesystems.  If the primary
were to crash, the backup server would mount its local copy of the
filesystems and the primary server's replicated filesystems would be
marked as dirty.  The primary would have its unmounted filesystems
synced to the backup when it came back online. 

As others have pointed out, if you have a cold-spare scenario like this,
there is no add'l licensing charge from IBM.  You do have to obtain a
2nd license in order to install UV on the 2nd server, but you won't be
charged.

-John
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

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

[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 together a backup strategy that involves keeping a 
standby server within two data hours of the primary. The idea is to be 
able to have users log into the backup server and keep the business 
running in the event of a crash.

I'd like to hear what solutions others have found for this.

I've been trying to contact IBM for the last 6 months but they haven't 
answered and my ERP vendor doesn't know how to do this.

Any ideas are appreciated.

TIA
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Performance monitoring

[Dan Fitzgerald]

Get a count of the number of read locks at a busy time. If it's more than
RLTABSZ times GSEMNUM, you'll want to increase gsemnum. I would avoid
increasing GLTABSZ and RLTABSZ by much; the lock table is a hashed table,
and just like uv files, "broad and shallow" yields better performance/less
contention.

Also look at MFILES; in the uv account, do a PORT.STATUS with the MFILE.HIST
option to see how things are going. Closing & reopening files is very
expensive. I've asked a few people if there's an upper limit, and while
nobody will commit to an answer (feel free, anyone), there appears to be no
penalty to making it too big.

I don't recall what the scratch buffer pool does, and the documentation is
sparse.

SELBUF is interesting, if you're doing a lot of selects. The default is 4,
in units of 1K. So, if you do a select, it starts accumulating a list of
id's in RAM until the size of that list reaches 4K. At that point, it
creates a file in UVTEMP, and you're going to disk. I can't see much reason
not to increase this to 1024, so select lists up to 1Mb are created in RAM.

These may help some, but unless MFILES is massively underconfigured and
you're using some absurd amount of cpu to just close & re-open files, I'm
inclined to think that the symptoms you mention indicate that AIX VMM tuning
will give you more bang for the buck. I'd be especially looking at how VMM
is treating computational vs file cache; with the amount of data you churn
through in a night, you'll want to be sure to heavily favor computational
memory pages.

How much RAM do you have?


-Original Message-
From: owner-u2-us...@listserver.u2ug.org
[mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of ericro
Sent: Wednesday, March 04, 2009 7:31 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Performance monitoring

Sounds like a good start.  I'm also wondering how the Universe config is
playing into things.  

There are some parameters we've never changed, i.e. the scratch buffer
stuff, and others 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 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, it's wasted with (and unusable to) UV.
> 
> Further, there are three AIX commands that will display environment
> variables (as of 5.2) are vmo, ioo, and schedo. Vmo -l, for example, will
> give you virtual memory settings. These are stored in
> /etc/tunables/lastboot, but - similar to looking at uvconfig rather than
> analyze.shm - what's in lastboot may not be the current values.
> 
> Now, one of the first things to look at is in vmstat -v. This is output in
> nmon, if you're running that daily (recommended); if not, you can run it
> at
> the command line. Look for these lines:
> 
> vmstat -v 0 pending disk I/Os blocked with no pbuf
> vmstat -v 0 paging space I/Os blocked with no psbuf
> vmstat -v  9877 filesystem I/Os blocked with no fsbuf
> vmstat -v 0 client filesystem I/Os blocked with no fsbuf
> vmstat -v 0 external pager filesystem I/Os blocked with no
> fsbuf 
> 
> If, over time, these are growing, you'll need to increase the number of
> the
> various file buffers. If you see growth over, say, an hour, you'll want to
> increase significantly.
> 
> 
> 
> 
> 
> -Original Message-
> From: owner-u2-us...@listserver.u2ug.org
> [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of ericro
> Sent: Wednesday, March 04, 2009 1:59 PM
> To: u2-users@listserver.u2ug.org
> Subject: [U2] Performance monitoring
> 
> We run an IBM P570 with 12 processors running Universe 10.2.4, average of
> 400
> users against at EMC DMX4500 disk array.  20 file systems with each about
> 45gb, 60-80% utilized striped across 94 disks.  
> 
> We do tons of batch processing at night and our rate of data change is
> about
> 175GB an hour at night.  We're running into some performance issues, jobs
> taking much longer, keyboard response slow, editing single records taking
> a
> long time, etc. and want to really dive in to see what's going on.  We've
> looked at file sizing and have done a fair amount of resizing, but to
> little
> avail.  
> 
> Does anyone have any tools, or know of any tools, similar to Oracle, that
> can really give me insight into what's happening with

RE: [U2] Performance monitoring

[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, 2009 3:37 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Performance monitoring

We use topas, but do you have any techniques for analyzing individual user
sessions to understand what's going on within Universe/the OS/the disk?

Thanks.

Drew Henderson-2 wrote:
> 
> If you haven't already, you might want to take a look at the "topas"
> command.  It'll give you an overall view of what's going on with the
> system, including per/processor utilization, per/process information, and
> disk utilization information.  The "h" key while in the program provides a
> bit more useful information on toggling between screens and what it'll do
> than does the man page.
> 
> HTH
> Drew
> 
> -Original Message-
> From: owner-u2-us...@listserver.u2ug.org
> [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of ericro
> Sent: Wednesday, March 04, 2009 1:59 PM
> To: u2-users@listserver.u2ug.org
> Subject: [U2] Performance monitoring
> 
> We run an IBM P570 with 12 processors running Universe 10.2.4, average of
> 400
> users against at EMC DMX4500 disk array.  20 file systems with each about
> 45gb, 60-80% utilized striped across 94 disks.
> 
> We do tons of batch processing at night and our rate of data change is
> about
> 175GB an hour at night.  We're running into some performance issues, jobs
> taking much longer, keyboard response slow, editing single records taking
> a
> long time, etc. and want to really dive in to see what's going on.  We've
> looked at file sizing and have done a fair amount of resizing, but to
> little
> avail.
> 
> Does anyone have any tools, or know of any tools, similar to Oracle, that
> can really give me insight into what's happening with a given user session
> at any time?  I know I can do port.status and find the address in the code
> and see what's being executed at that time, but I want something more that
> will show memory utilization and other stats like that.
> 
> Any help would be appreciated.
> --
> View this message in context:
> http://www.nabble.com/Performance-monitoring-tp22336819p22336819.html
> Sent from the U2 - Users mailing list archive at Nabble.com.
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
> 
> 

-- 
View this message in context:
http://www.nabble.com/Performance-monitoring-tp22336819p22338770.html
Sent from the U2 - Users mailing list archive at Nabble.com.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Performance monitoring

[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, it's wasted with (and unusable to) UV.

Further, there are three AIX commands that will display environment
variables (as of 5.2) are vmo, ioo, and schedo. Vmo -l, for example, will
give you virtual memory settings. These are stored in
/etc/tunables/lastboot, but - similar to looking at uvconfig rather than
analyze.shm - what's in lastboot may not be the current values.

Now, one of the first things to look at is in vmstat -v. This is output in
nmon, if you're running that daily (recommended); if not, you can run it at
the command line. Look for these lines:

vmstat -v   0 pending disk I/Os blocked with no pbuf
vmstat -v   0 paging space I/Os blocked with no psbuf
vmstat -v9877 filesystem I/Os blocked with no fsbuf
vmstat -v   0 client filesystem I/Os blocked with no fsbuf
vmstat -v   0 external pager filesystem I/Os blocked with no
fsbuf 

If, over time, these are growing, you'll need to increase the number of the
various file buffers. If you see growth over, say, an hour, you'll want to
increase significantly.





-Original Message-
From: owner-u2-us...@listserver.u2ug.org
[mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of ericro
Sent: Wednesday, March 04, 2009 1:59 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Performance monitoring

We run an IBM P570 with 12 processors running Universe 10.2.4, average of
400
users against at EMC DMX4500 disk array.  20 file systems with each about
45gb, 60-80% utilized striped across 94 disks.  

We do tons of batch processing at night and our rate of data change is about
175GB an hour at night.  We're running into some performance issues, jobs
taking much longer, keyboard response slow, editing single records taking a
long time, etc. and want to really dive in to see what's going on.  We've
looked at file sizing and have done a fair amount of resizing, but to little
avail.  

Does anyone have any tools, or know of any tools, similar to Oracle, that
can really give me insight into what's happening with a given user session
at any time?  I know I can do port.status and find the address in the code
and see what's being executed at that time, but I want something more that
will show memory utilization and other stats like that.

Any help would be appreciated.
-- 
View this message in context:
http://www.nabble.com/Performance-monitoring-tp22336819p22336819.html
Sent from the U2 - Users mailing list archive at Nabble.com.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Strange happening...

[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 remember who told me about it - Mark Baldridge. 

Who, btw, also wrote a series on programming & tuning for performance
(which includes setting up benchmarks) in UniVerse, available for
downloading on the IBM developerworks site.

First installment here:

http://www.ibm.com/developerworks/edu/dm-dw-dm-0512baldridge-i.html




-Original Message-
From: owner-u2-us...@listserver.u2ug.org
[mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Monday, March 02, 2009 1:02 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Strange happening...

It shouldn't, at least not to a empty ID because the
condition test is on the READNEXT, not the ID.

However, it will pass an empty ID to the coding, which
could be worse, if there aren't constraint checks on
the ID.

George

> -Original Message-
> From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-
> us...@listserver.u2ug.org] On Behalf Of Eric Armstrong
> Sent: Monday, March 02, 2009 11:28 AM
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] Strange happening...
>
> Allen,
> Regarding your loop structure below. What happens if the ID is empty
> string?
> Won't it bail out before all the ids are read!
>
> Eric Armstrong
> Lobel Financial
> IT Dept
>
>
> -Original Message-
> From: Allen Egerton [mailto:aeger...@pobox.com]
> Sent: Friday, February 27, 2009 8:37 AM
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] Strange happening...
>
> As for the loop structure, I tend to like this:
> SELECT FILENAME
> LOOP WHILE READNEXT ID
>   CODE
>   CODE
>   CODE with GOSUB
>   CODE
>   CODE
> REPEAT
>
> It's clean, it's concise, it's easy to read...  And I wish I could
> remember who taught me that you could combine the LOOP and READNEXT in
> that manner...
>
> --
> Allen Egerton
> aegerton at pobox dot com
> PGP Key ID 0x8EA57261
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

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

[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] Maybe not the list to ask on, but SB+ generated documentation.

Am on a unidata system on a unix box. How do I generate the SB+ manuals so
that I can drag them into windows?



Vaguely remember doing it many moons ago on a universe system via a hold
print queue.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Errors with RPC

[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: [U2]
Errors with RPC> Date: Mon, 12 Jan 2009 13:19:56 -0500> From:
henry.mar...@wearguard-crest.com> To: u2-users@listserver.u2ug.org> > Hello
all,> > > > I am looking for some assistance on where to start with this.
We've stared> using UniObjects for Java in Late Dec and we've been getting> >
Quite a few RPC failed messages. Has anyone seen this type of message and how>
to trouble shoot it?> > > > The developers are telling me there is something
wrong with Universe, but I> don't know where to look.> > > > 12/24/2008
00:07:44:814 Error: [IBM U2][UniObjects for Java][UniSession>
Exception][ErrorCode: 81009]The RPC failed> > 12/24/2008 12:07:50:971 Error:
[IBM U2][UniObjects for Java][UniSession> Exception][ErrorCode: 81009]The RPC
failed> > 12/24/2008 12:07:7:921 Error: [IBM U2][UniObjects for
Java][UniSession> Exception][ErrorCode: 81009]The RPC failed> > 12/25/2008
00:08:02:408 Error: [IBM U2][UniObjects for Java][UniSession>
Exception][ErrorCode: 81009]The RPC failed> > 12/25/2008 12:07:31:562 Error:
[IBM U2][UniObjects for Java][UniSession> Exception][ErrorCode: 81009]The RPC
failed> > 12/25/2008 12:08:16:861 Error: [IBM U2][UniObjects for
Java][UniSession> Exception][ErrorCode: 81009]The RPC failed> > 12/26/2008
00:07:37:906 Error: [IBM U2][UniObjects for Java][UniSession>
Exception][ErrorCode: 81009]The RPC failed> > 12/26/2008 00:08:23:361 Error:
[IBM U2][UniObjects for Java][UniSession> Exception][ErrorCode: 81009]The RPC
failed> > 12/27/2008 12:07:28:781 Error: [IBM U2][UniObjects for
Java][UniSession> Exception][ErrorCode: 81009]The RPC failed> > 12/27/2008
12:07:30:46 Error: [IBM U2][UniObjects for Java][UniSession>
Exception][ErrorCode: 81009]The RPC failed> > 12/27/2008 12:08:10:924 Error:
[IBM U2][UniObjects for Java][UniSession> Exception][ErrorCode: 81009]The RPC
failed> > 12/27/2008 12:08:12:658 Error: [IBM U2][UniObjects for
Java][UniSession> Exception][ErrorCode: 81009]The RPC failed> > 12/27/2008
2:09:29:0 Error: [IBM U2][UniObjects for Java][UniSubroutine>
Exception][ErrorCode: 81009]The RPC failed> > 12/28/2008 00:58:00:843 Error:
[IBM U2][UniObjects for Java][UniSession> Exception][ErrorCode: 81002]No RPC
Connection active.> > 12/28/2008 00:58:01:31 Error: [IBM U2][UniObjects for
Java][UniSession> Exception][ErrorCode: 81002]No RPC Connection active.> >
12/28/2008 00:58:42:33 Error: [IBM U2][UniObjects for Java][UniSession>
Exception][ErrorCode: 81002]No RPC Connection active.> > 12/28/2008
00:58:44:768 Error: [IBM U2][UniObjects for Java][UniSession>
Exception][ErrorCode: 81002]No RPC Connection active.> > 12/28/2008
00:59:02:33 Error: [IBM U2][UniObjects for Java][UniSession>
Exception][ErrorCode: 81002]No RPC Connection active.> > 12/28/2008
00:07:35:406 Error: [IBM U2][UniObjects for Java][UniSession>
Exception][ErrorCode: 81009]The RPC failed> > 12/28/2008 00:07:35:640 Error:
[IBM U2][UniObjects for Java][UniSession> Exception][ErrorCode: 81009]The RPC
failed> > 12/28/2008 00:08:21:627 Error: [IBM U2][UniObjects for
Java][UniSession> Exception][ErrorCode: 81009]The RPC failed> > 12/28/2008
00:08:24:299 Error: [IBM U2][UniObjects for Java][UniSession>
Exception][ErrorCode: 81009]The RPC failed> > 12/28/2008 12:07:51:125 Error:
[IBM U2][UniObjects for Java][UniSession> Exception][ErrorCode: 81009]The RPC
failed> > 12/28/2008 12:07:51:250 Error: [IBM U2][UniObjects for
Java][UniSession> Exception][ErrorCode: 81009]The RPC failed> > > > Thanks,> >
Henry Martel> > henry.mar...@wearguard-crest.com> ---> u2-users mailing
list> u2-users@listserver.u2ug.org> To unsubscribe please visit
http://listserver.u2ug.org/
_
Windows Live Hotmail.: Chat. Store. Share. Do more with mail.
http://windowslive.com/howitworks?ocid=TXT_TAGLM_WL_t1_hm_justgotbetter_howit
works_012009
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] UniVerse and/or AIX caching

[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 if this were
the problem.

AIX caching can be roughly controlled, but I'd be surprised if this was the
problem, either.

Let's see the following at AIX:

vmstat -v

ioo -a | grep maxpgahead

maxpgahead should be at 128, especially if you're sequentially processing
large files. This is yet another reason to minimize overflow; contiguous is
faster.

How are you copying? i.e., basic read from file a, write to file b, universe
select & copy, aix cp...?

vmstat -v should be taken at two points in time, say an hour apart at a busy
time. During a copy would be ideal. If any of the "I/O blocked with no xbuf",
values are increasing, that would indicate a problem.

Do you have nmon running? It would be interesting to see if your load is
spread among all disks, or are you hammering on just a few? Maybe there's a
sysadmin around who could verify that your disks are actually striped.

What is the path you're copying the file(s) across? Fibre? 10 Base T?
> Subject: RE: [U2] UniVerse and/or AIX caching> Date: Fri, 24 Oct 2008
10:43:36 +1100> From: [EMAIL PROTECTED]> To: u2-users@listserver.u2ug.org> >
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 empty> space/groups?> > Regards> David> > > -Original
Message-> From: [EMAIL PROTECTED]>
[mailto:[EMAIL PROTECTED] On Behalf Of Louie Bergsagel>
Sent: Friday, 24 October 2008 9:38 AM> To: u2-users@listserver.u2ug.org>
Subject: Re: [U2] UniVerse and/or AIX caching> > 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 )> Large record size
.. 1619 bytes> Group size . 2048 bytes> Load factors
... 80% (split), 50% (merge) and 80% (actual)> Total size
. 1,379,911,680 bytes> > ANALYZE.FILE BETA (reads & writes)>
File name .. BETA> Pathname ... BETA> File
type .. DYNAMIC> Hashing Algorithm .. GENERAL> No. of
groups (modulus)  233098 current ( minimum 1607 )> Large record size
.. 3257 bytes> Group size . 4096 bytes> Load factors
... 80% (split), 50% (merge) and 80% (actual)> Total size
. 1,197,477,888 bytes> > >file.stat DELTA (reads only)> File
name = DELTA> File type = 18> Number of groups in file (modulo) = 99013>
Separation = 4> Number of records = 460434> Number of physical bytes =
240564224> Number of data bytes = 171851992> > Average number of records per
group = 4.6502> Average number of bytes per group = 1735.6508> Minimum number
of records in a group = 2> Maximum number of records in a group = 6> > Average
number of bytes per record = 373.2391> Minimum number of bytes in a record =
176> Maximum number of bytes in a record = 2304> > Average number of fields
per record = 109.8444> Minimum number of fields per record = 108> Maximum
number of fields per record = 231> > Groups 25% 50% 75% 100% 125% 150% 175%
200%> full> 0 1948 28741 49890 17083 1315 33 3> > >FILE.STAT ECHO (reads
only)> File name = ECHO> File type = 18> Number of groups in file (modulo) =
16453> Separation = 4> Number of records = 55176> Number of physical bytes =
42856448> Number of data bytes = 28404000> > Average number of records per
group = 3.3536> Average number of bytes per group = 1726.3721> Minimum number
of records in a group = 1> Maximum number of records in a group = 5> > Average
number of bytes per record = 514.7890> Minimum number of bytes in a record =
80> Maximum number of bytes in a record = 6400> > Average number of fields per
record = 155.9890> Minimum number of fields per record = 47> Maximum number of
fields per record = 366> > Groups 25% 50% 75% 100% 125% 150% 175% 200%> full>
95 1617 4452 5861 3406 861 145 16> > On Thu, Oct 23, 2008 at 2:05 PM, Hona,
David S <[EMAIL PROTECTED]>> wrote:> > > What are the file stats for this UV
file? Just curious.> ---> u2-users mailing list>
u2-users@listserver.u2ug.org> To unsubscribe please visit
http://listserver.u2ug.org/> ---> u2-users mailing list>
u2-users@listserver.u2ug.org> To unsubscribe please visit
http://listserver.u2ug.org/
_
See how Windows connects the people, information, and fun that are part of
your life.
http://clk.atdmt

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

[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 you try to load it into the editor.

You might try explicitly writing an end of item mark at the end, and you also
may try making sure that no control characters are in the data; you may want
to strip out everything above an ascii 126 & below a 250, unless you need them
for some reason.

You can work around this by copying at the unix level.> Subject: [U2] uniVerse
COPY command and the UVTEMP directory> Date: Wed, 17 Sep 2008 14:14:58 -0400>
From: [EMAIL PROTECTED]> To: u2-users@listserver.u2ug.org> > Does the
uniVerse COPY command use the UVTEMP directory for workspace?> > > > I have a
program that is creating a >200MB XML file in the &HOLD& file.> It then
transfers (or attempts to transfer) that file to another file> using "COPY
FROM &HOLD& TO OTHERFILE TMP41904 OVERWRITING". When this> command is issued,
I get:> > > > Program "COPYI": pc = 19F8,> > Available memory exceeded. Unable
to continue processing record.> > Record "TMP41904" not found in file
"&HOLD&".> > > > In investigating, I first went after swap space (BTW...this
is on a> HP-UX system) but I found that there is almost 2GB available on that>
file system. In looking at available RAM, top is showing me about 35K>
free...but I would expect the available swap space would make up for> that.> >
> > The last thing I am lookg at is the fact that the file system where>
UVTEMP resides has only about 60MB available...far less than the XML> file is
going to need.> > > > I was just looking for confirmation that this could be
the problem> before I go shutting things down and moving UVTEMP just to find
out it> was something else.> > > > Thanks,> > John B.> > > > -> > > > > > This
message and all attachments are intended for the use of the individual or>
entity to whom or which it is addressed and may contain information that is>
privileged, confidential, and exempt from disclosure. If the reader of this>
message is not the intended recipient or the agent responsible for delivering>
the message to the intended recipient, you are hereby notified that any>
dissemination, distribution, or copying of this communication is strictly>
prohibited. If you have received this e-mail in error, please notify me>
immediately at the number listed above.> > U.S. export law as contained in the
International Traffic In Arms Regulations> (ITAR) and the Export
Administration Regulations (EAR) may be applicable to> any technical
information submitted with this communication. This technical> information is
not to be placed in the public domain, exported from the U.S.,> or given to
any foreign person in the U.S., without the prior, specific> written
authorization of TeligentEMS LLC and the U.S. Department of State or> the U.S.
Department of Commerce as applicable.> ---> u2-users mailing list>
u2-users@listserver.u2ug.org> To unsubscribe please visit
http://listserver.u2ug.org/
_
See how Windows connects the people, information, and fun that are part of
your life.
http://clk.atdmt.com/MRT/go/msnnkwxp1020093175mrt/direct/01/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/