Have you been able to do any os level tools to see what the utilisation of
resources is. E.g. on linux, vmstat, top, iostat will show you if it is a
diskio or cpu bottleneck. If it is diskio (i.e. high wait on io times) then
you may need to upgrade the disks or add more ram so you have more data
Hi,
The question of READU vs READ when you are doing updates is moot. If you do a
READ then a WRITE, UniVerse/UniData will perform the record lock. The only
difference is with READ you are gambling that no one else is updating the
record before you perform your WRITE.
Performance, as others
Thanks for all of the responses! It looks like LIST.READU -INTERNAL
will do it.
-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 7:05 PM
To: U2
In Unidata you could use the LOCKED clause followed by GETUSERNAME(STATUS()).
Richard Sammartino
- Original Message -
From: Andy Krause akra...@rammutual.com
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Tuesday, May 1, 2012 8:55:03 AM
Subject: Re: [U2] User ID of a LOCKED record
It does on my system - uv 10.2.7
LIST.READU
Active Record Locks:
Device Inode Netnode Userno LmodePid Login Id
Item-ID
.
6553741067810 15 29 RU 499890 dianne TEST
On 4/30/2012 7:28 PM, Wjhonson wrote:
LIST.READU -INTERNAL
you
Dave;
A couple more things:
- do you have any other processes running at the same time? I found (long
ago) that a couple of our big processes ran 5X faster consecutively than
they did concurrently.
- subroutine calls with file opens. I inherited a process that was running
for 3 days and was 65%
Thank you Colin. I wouldn't post these types of 'issues' if I were
thin-skinned and didn't appreciate input.
There are certainly some efficiencies in the updating of the
multi-values. Unfortunately I cannot reorganize the data in the records,
only the code that updates said data.
I'll consider
Universe 10.2.3
LIST.READU
Active Record Locks:
Device Inode. Netnode Userno LmodePid Item-ID
...
566926395 1210555995 0 27368 RU 2736 16193-12-25
291123247 403366260 0 5436 30 RU 5436 181424343
252535158 1093183945 0
I think the difference is probably not the release version number, but rather
the operating system.
This is Universe on WINDOWS, you are probably on Unix.
-Original Message-
From: Wjhonson wjhon...@aol.com
To: u2-users u2-users@listserver.u2ug.org
Sent: Tue, May 1, 2012 10:06 am
Yes, this is on unix.
On 5/1/2012 1:08 PM, Wjhonson wrote:
I think the difference is probably not the release version number, but rather
the operating system.
This is Universe on WINDOWS, you are probably on Unix.
-Original Message-
From: Wjhonsonwjhon...@aol.com
To:
I didn't read over Troy's comments earlier, but he's right. The user
name portion of the LIST.READU -INTERNAL does not work. In my case when
I run it the result shows me holding every single lock.
I ended up using LISTME rather than LIST.READU -INTERNAL to pull the
username.
We are currently
No guarantees as to how it works with SB, but UV has an AUTOLOGOUT {idle
minutes} command that might be of use.
-Rick Nuckolls
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lunt, Bruce
Sent: Tuesday, May 01,
LISTME only lists *you*
It doesn't list every user on the system who might be holding a lock.
Only your processes
-Original Message-
From: Andy Krause akra...@rammutual.com
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Tue, May 1, 2012 11:55 am
Subject: Re: [U2] User ID of a
HELP AUTOLOGOUT
-Original Message-
From: Lunt, Bruce bl...@shaklee.com
To: u2-users u2-users@listserver.u2ug.org
Sent: Tue, May 1, 2012 11:59 am
Subject: [U2] User timeout question
Hi All,
e are having a problem with a particular user who is opening up a
aintenance screen and then
We wrote a process that monitors all locks on a system based on how long they
have been locked with a parameter you start the program with.
e.g. LOCK.MONITOR 5
The code uses the GETREADU() function and it parses the results and puts it
into an array.
Then displays it on a screen with details
Updating 700,000 records.
If you want speed on the reads and writes the best way to accomplish it is to
MATREADU the record equate the attributes you are going to update or all of
them in case you ever want to add and then MATWRITE. It takes more coding, but
it is well worth it.
It takes a
I tried HELP AUTOLOGOUT but it was not there. Is this a recent command? We
are running version 7.1 of Unidata.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Tuesday, May 01, 2012 12:18 PM
To:
Maybe. There is the additional overhead of populating the DIM array on the
MATREAD and the reverse on the MATWRITE. The more your program accesses the
fields, esp. the more fields you have, then I agree, this can be MUCH faster.
However, it you have big records and all you are doing is
Well maybe it's the way our system is setup but here is a portion of my
LISTME:
uid Pid User Name Terminal No Login Time
0 3520 RAMMUTUAL\ddowningtelnet:3520 May 1 07:01
0 6108 RAMMUTUAL\debel telnet:6108 May 1 07:04
I don't know I'm on Universe
-Original Message-
From: Lunt, Bruce bl...@shaklee.com
To: 'U2 Users List' u2-users@listserver.u2ug.org
Sent: Tue, May 1, 2012 12:49 pm
Subject: Re: [U2] User timeout question
I tried HELP AUTOLOGOUT but it was not there. Is this a recent command? We
re
I gather that in Unidata, the command is TIMEOUT. Note that the parameter is
seconds. TIMEOUT 0 might reset it, but it does not say anything in this
document. (From Unidata Commands reference)
-Rick
TIMEOUT nn
Description
The ECL TIMEOUT command automatically logs a user out of a UniData
On Unidata use TIMEOUT.This will logoff the session when inactive keyboard
exceeds the desired time period.
Marc Rutherford
Principal Programmer Analyst
Advanced Bionics LLC
661) 362 1754
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
I don't have it either. HPUX, UniData 7.2.
John
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lunt, Bruce
Sent: Tuesday, May 01, 2012 3:48 PM
To: 'U2 Users List'
Subject: Re: [U2] User timeout question
I tried
Evidently another of those places where Unix and Windows differ.
LISTME
These are the UniVerse processes running under your user id.
uid Pid User Name Terminal No Login Time
*198387 1568 RWCUNIVERSE1\W.Johns telnet:7140 May 1 13:59
198387
If the multivalues have many many values, and you are adding to the end, then a
speed up may be possible.
MATREAD in the data, RAISE those array elements you are changing. Before the
MATWRITE, LOWER all array elements you raised.
As I understand it, Universe keeps internal track on
I think you complicating things ... Troy has it right:
Sure files could be resized, and code re-engineered, and all these good
thing do help, but I reduced a process scanning 20 million records from 12
days to 2 days just taking out the CRT to screen informing the user of
progress (or lack of
Computers keep getting faster, and databases keep getting larger. So as a
refinement you could say, display something if a second or more has passed,
and don't display anything if it hasn't.
We used to use MOD 100, which was fine 20 years ago. Now it spins by so fast
you cant read it.
Now for the $64 dollar question: Where do I put the timeout command to be
sure that it is enabled when this user logs onto the system?
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Rutherford, Marc
Sent: Tuesday,
LOGIN
-Original Message-
From: Lunt, Bruce bl...@shaklee.com
To: 'U2 Users List' u2-users@listserver.u2ug.org
Sent: Tue, May 1, 2012 3:52 pm
Subject: Re: [U2] User timeout question
Now for the $64 dollar question: Where do I put the timeout command to be
ure that it is enabled when
Thanks!
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Tuesday, May 01, 2012 4:01 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] User timeout question
LOGIN
-Original Message-
Just an interesting piece of history that folks might find amusing. Back in
the day, Ultimate had a development project to speed up the basic compiler.
Everyone was really anticipating the performance improvements.
However, when the new compiler was timed and tested, it didn't produce the
Good story, Laura!
We are figuring out where we need animated gifs in a web app to indicate
something is happening. They seem mostly unnecessary (with test data,
which, granted, might be the reason they seem unnecessary at this point),
so we are erring on the side of keeping them out, rather than
Hi Laura and Dawn,
This reminds me of a program I wrote about 20 years ago for a multilevel
marketing company. Its job was to audit a seller's downline, which in
many cases ran into thousands or tens of thousands of transactions. For
some larger sellers it ran for several minutes. The users
It's better for peace of mind to know that the computer thinks it's doing
something
Rather than wondering Is it DOING something
-Original Message-
From: Dawn Wolthuis dw...@tincat-group.com
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Tue, May 1, 2012 5:30 pm
Subject: Re:
It's been a long time since I've posted about this, but our company wrote
and has sold a product called LOGMON for many years (15? I don't even
remember). This software works at the Unix level to monitor usage of the
users on a system, actually monitoring cpu usage, not keystrokes. And so
if a
35 matches
Mail list logo