Is there anything in Unidata that would report the line of code that set a
particular record lock?
-Kevin
http://www.PrecisOnline.com
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Once you know the pid of the program with the lock, you can use PORT.STATUS to
determine this. You just need to use the CALL.STACK option. IIRC (It's been a
few months) it would be like:
PORT.STATUS PID the progs pid here CALL.STACK
Regards,
Dan
-Original Message-
From:
I don't see anything in the LIST.QUEUE output, but I can see how that would be
useful.
If you have control of the source code for all of the file i/o operations you
could write your own wrapper routines for the commands that set record locks,
get the information from SYSTEM(49) (the program
That's useful for determining where that port is, but we have a process
leaving rogue locks lying around. Anything that tells what updated the lock
table?
On Thu, Sep 8, 2011 at 9:10 AM, Daniel McGrath
dmcgr...@rocketsoftware.comwrote:
Once you know the pid of the program with the lock, you
Dave: Two Words: Vendor App. Good idea, but not possible in this case.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
This is probably no help...
In Universe there is a LIST.READU EVERY.
That will show every lock in the system. Maybe if Unidata has an
equivalent, you can get some useful info there...
On Thu, Sep 8, 2011 at 11:15 AM, Kevin King precisonl...@gmail.com wrote:
That's useful for determining
Unfortunately, no love there either John. I even went to the GETREADU( .. )
function in BASIC.. nothing there.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Over the last weekend, I noticed that the pickwiki.com (the common mv code
website) does not have any games programmes.
I can remember playing the star-trek and adventure games on a Ultimate (or
Altos I think), many years ago.
Does anyone have any remnant or complete code that they can
LIST.READU will tell you what program owns the lock (as long as the program is
still running). The UNO column is the UniData Number, which will relate to a
user/process in the PORT.STATUS (no options) command's list.
Aside from that, I don't know if you can catch the actual line number unless
It's a shame there isn't a file trigger operation on locking reads, just
updates and deletes. That way you could just add it to the file in question.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King
On Thu, Sep 8, 2011 at 11:23 AM, Daniel McGrath
dmcgr...@rocketsoftware.com wrote:
LIST.READU will tell you what program owns the lock (as long as the program
is still running). The UNO column is the UniData Number, which will relate to
a user/process in the PORT.STATUS (no options) command's
Kudos for the novel ideas Dan! However, in this case we're trying to track
down a program that left a lock. And being an SB+ application, a lot of
stuff runs under the same PID.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
On Thu, Sep 8, 2011 at 11:26 AM, Dave Davis dda...@harriscomputer.com wrote:
It's a shame there isn't a file trigger operation on locking reads, just
updates and deletes. That way you could just add it to the file in question.
The update trigger might be useful. Most ppl would lock the
Yes, Steve, but being an SB+ application... the program never stops
completely until the person logs off. Meanwhile, they end up dragging
mines..
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Yes, they should be.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Romanow
Sent: Thursday, September 08, 2011 9:27 AM
To: U2 Users List
Subject: Re: [U2] Lock Status
On Thu, Sep 8, 2011 at 11:23 AM, Daniel
It would be useful, except that the problem is the locker causing the problem
probably hasn't updated the record yet, which most likely would release the
lock (this being an SB+ application) and end the problem. Retaining the lock
after an update is something that would likely be coded in
We do suspect it is from a custom BASIC subroutine, recently installed. So
knowing the file we're looking back through any code that was compiled
within the past 2 weeks and manually searching for READU's that don't WRITE,
DELETE, or RELEASE. Sure would be nice if the lock table would report the
Kevin,
I think that the closest you are going to be able to get is the program
in question using LIST.READU to determine the PID and PORT.STATUS to
then find the program. I don't know of any way to dynamically get to the
program line number from there. You could, of course, just look through
On Thu, Sep 8, 2011 at 11:34 AM, Kevin King precisonl...@gmail.com wrote:
We do suspect it is from a custom BASIC subroutine, recently installed. So
knowing the file we're looking back through any code that was compiled
within the past 2 weeks and manually searching for READU's that don't
Yeah PORT.STATUS on Universe will tell you the last command run by the
floating user number of the user...
So if you were able to get the UserNo from LIST.READU EVERY output, and then
cross reference that with the PORT.STATUS output, perhaps you could at least
narrow it down.
Of course that
All,
If anyone does have code samples (other than games!) of how to achieve
specific tasks that they would like to share, please do so at the U2UG
website: www.u2ug.org by following the wiki link.
This is your resource provided to you by the U2UG Board for everything
U2 related. Please use
If only the lock table was an actual hashed file that you could place an update
trigger on.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King
Sent: Thursday, September 08, 2011 11:15 AM
To: U2 Users List
I have a need to add an additional value to a multi-valued field on a bunch of
records. I was hoping I could do this using SQL UPDATE but it appears you have
to explicitly list all the muli-values...
UPDATE FILE SET MVFIELD = 'FIRST', 'SECOND', 'THIRD', 'THE.NEW.VALUE';
Anyone know of way to
Just don't do what one of my old bosses did (he was having trouble with SB+
holding locks) - he found one of our main processes and put in RELEASE.
Our system relied heavily on pessimistic locking so this caused quite a bit
of data loss. Of course, I was the one that had to clean it all up (he
Kevin sorry but no.
There is no function that will tell you the line of code or even the program
which set a lock.
You could however, as others have suggested determine the PID which set it, AND
(not OR) write a routine which wakes up every five minutes and copies the
current lock table into
I think I worked for him once! ;^)
Charlie Noah
On 09-08-2011 11:11 AM, Colin Alfke wrote:
Just don't do what one of my old bosses did (he was having trouble with SB+
holding locks) - he found one of our main processes and put in RELEASE.
Our system relied heavily on pessimistic locking so
This won't work unless the program is halted-waiting.
Most likely it's moved on to do a hundred other things since the lock in
question, but left it hanging because the pid is still living.
If the pid dies it would release the lock, but for example, even on non-SB
systems, phantoms which run
Fix... the... URL!
http://109.104.64.69/cms/cmshome.wsp
Ugly ugly ugh
-Original Message-
From: Glenn Sallis u...@glennsallis.de
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Thu, Sep 8, 2011 8:46 am
Subject: Re: [U2] Free Software for DataBasic
All,
If anyone does have
Obviously your install team did not include a 55 year old school teacher and an
8 year old boy!
-Original Message-
From: David Jordan da...@dacono.com.au
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Wed, Sep 7, 2011 7:45 pm
Subject: Re: [U2] DataVu Query [ad]
Hi Steve
here
I believe that if the program ended the lock would be released, so by
finding the PID via LIST.READU and then determining the program name
associated with the PID via PORT.STATUS you are identifying the program
which currently holds the lock unless the program ends between the
LIST.READU and
That's not the case.
PORT.STATUS shows you what that PID is currently doing when you run it.
Not what it was doing an hour ago for example.
Not what it was doing when it set the lock.
Just what it's doing now.
In Unix/Universe world.
If you are so lucky to know about the lock *right when* it's
Not exactly trivial. Would require a new structure to be added to the table and
changes to all associated routines that access and maintain this shared memory
table.
Also - UniData record locks are tied to a file variable. So even if the
'program ends', if the file variable is in COMMON and
Like to know if I can move the data from Windows 2003 UniVerse 11.1.1 32 bit
to a Windows 2008 11.1.1 64 bit. What needs to be done or user. Plus can I
go back.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
I disagree.
If I run LIST.READU and note the PID of a process holding a lock on an
item then run PORT.STATUS on that PID the only way that the program
shown by PORT.STATUS as currently running is not the process holding the
lock would be if the program ended (thus dropping the lock) before I
Port.status shows what is currently running on that PID
Not what was running when the lock was set.
The process is not the program. You are using the words interchangebly
when they are not.
A process can run a long stack up and down adding and pruning. The call stack
only shows the current
Even if the program ended that locked the item, the lock could still be
maintained if the file variable was passed.
I know this is after the fact but, one option going forward would be to write a
wrapper program for READU's and call it LOCK.RECORD. I use this approach
extensively.
CALL
This still would not be accurate for the reasons already stated.
The call stack only shows you what routine is on the stack. If the lock had
been set for hours, who knows what routine was there previously?
As you yourself stated, locks can persist, after the routine which created them
has gone
Thank you goes out to everyone for the input. We were able to identify (and
as of this moment it would appear correct) a couple of suspects by looking
at the code that had been compiled within the last 2 weeks and evaluating
each routine separately. I still think it'd be cool to be able to see
I dare to disagree.
If you ALWAYS use a subroutine that records the pid, the file, item Id
and program on a logfile when you want to read and lock a record and
ALWAYS use a subroutine that removes the info from the logfile to write
or release this could work.
Otherwise it won't.
On
You might be able to implement this capability from within the programs
themselves without a huge amount of effort. We have a small program
tracking subroutine and a companion utility that automatically installs
a call to it from every program. The original purpose was to determine
which code
If you rewrote your system to whip eggs, then it would whip eggs.
But this doesn't fix the underlying issue that there are many systems already
out there, which cannot whip eggs.
And which you do not have the luxury to rewrite, but have to live with them the
way they are.
There IS a way to get
I just realized there also needs to be a 3rd step in the process below
that removes any logging of locks that have since been released. In the
following sequence of events:
Program A locks record R
Program A calls subroutine B
Program A calls subroutine C
Program A releases record R
Subroutines
Now that's a program I'd like to see.
I've been trying to write one that makes cups of coffee, but so far no
luck.:-D
I always tell my clients when they ask me for things that can't be done
without rewriting the whole system, that I will do the impossible
straight away, but miracles may take a
Hi Kathleene:
We do this all of the time you should not have a problem.
Regards,
Doug
www.u2logic.com
On Thu, Sep 8, 2011 at 12:16 PM, Kathleené M Hunter
kmhun...@resolutionprovider.com wrote:
Like to know if I can move the data from Windows 2003 UniVerse 11.1.1 32
bit
to a Windows 2008
Should be straightforward using uvbackup and uvrestore to go either way.
Stuart.
-Original Message-
From: Kathleené M Hunter
Sent: Friday, 9 September 2011 4:21
To: 'U2 Users List'
Subject: [U2] Move UniVerse Data from 32 bit server to 64 bit server
Like to know if I can move the data
We have a customer on Unidata 7.1.22 running the Prelude application. They
have an index on a field in a file that looks like this:
Top of SHOP.CODE in DICT WO, 9 lines, 82 characters.
*--: P
001: V
002: EXTRACT(@RECORD,110,2,0)
003:
004: Shop Code
005: 2L
006: S
007:
008:
Doug,
What method are you using to move the data? Uvback and uvrestore?
Something else?
The servers are networked together.
Kathleené
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug Averch
With respect to UniData, we moved from Windows 2003 Server to Windows
2008 R2. I had to upgrade to UniData v7.2.7 and they fixed a
permissions problem in STARTPTR (I think). Other than that, everything
worked as it had previously.
I suspect UV is the same thing. Contact Rocket to find out
Not enough information.
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
Oh, the one gotcha I've encountered using uvbackup/restore between 32 and 64,
but which shouldn't apply in your case, was moving from RISC to x86 when the
trigger bit in the header of a file with triggers needs to be manually reset.
This was UV10.1 and may be fixed by now.
Cheers Stuart
In my copy of Acct.Stat.B the following programmer initials dating from 1992 to
2000
PVW, WLC, AGM, JC, DJD, PEJ, SAP, DSM, LKS
anyone have long names ?
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
PVW is me Phil Walker
DSM might be David Meeks
WLC is probably Wendy Cleary
JC Jesus Christ ;-)
Others cannot remember
-Original Message-
From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Friday, 9 September 2011
What can I get you Wally? We did a CREATE.INDEX WO SHOP.CODE NO.NULLS
followed by BUILD.INDEX WO SHOP.CODE. The index seems to work fine
immediately after. If the shop code in the record changes, however, the
index does not seem to reflect the change. This is evidenced by:
DISABLE INDEX WO
Hi Kathleene:
I'm not to thrilled using any of the uvtools since they are kind of slow and
if I remember they were built using cpio which is not a favorite binary of
mine. If I'm transferring less then a 100mb, I use our copy and paste
option in our XLr8Editor tool. We copy about 5 to10mb per
54 matches
Mail list logo
