Hi All,
I am facing a strange problem with the locks. When I executed LIST.LOCKS
at universe prompt, no locks were shown but when I executed LIST.READU,
7 records were displayed as locked.
I tried to CLEAR all the locks but was not able to do that. Can someone
tell me how to release the locks
I dont believe LIST.LOCKS shows READ locks. Use LIST.READU EVERY to see
all READU locks. Two commands for two different things. I dont know of
any commands to release READU locks. The MASTER LOCKS command will release
the synchronization locks, but not READU.
One thing you could do is to
Have a look at the UNLOCK command. This allows the system administrator in the
UV account to unlock any lock set by a READU.
Before you go round unlocking records make sure you know why the locks are
there. Has someone just walked away from their screen for a while? Unlocking
records can lead
Hi Pankaj,
Try:
UNLOCK ALL
to remove all locks.
Try:
HELP UNLOCK
to learn about the UNLOCK command.
Brian Grayson
Pankaj Gupta04 wrote:
Hi All,
I am facing a strange problem with the locks. When I executed LIST.LOCKS
at universe prompt, no locks were shown but when I executed LIST.READU,
Hi,
The LIST.LOCKS command lists tasks synchronization locks.
The LIST.READU command lists record and group locks.
To release record and group locks you need the UNLOCK command. This is
(normally) only available in the uv account, and has various options for
unlocking different sets of
Hi,
This is two different things LIST.LOCKS shows file locks and can only be
released by the session or user that locked that file.
To see record locks use LIST.READU EVERY this shows all locks set by a
user
Active Group Locks, Active Record locks and Active Semaphore locks as
well. To
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
You can go to the UV account and do an UNLOCK.
UNLOCK
Use UNLOCK to clear file, group, and update record locks. You must be a
UniVerse Administrator logged in to the UV account to execute UNLOCK.
Syntax
UNLOCK [NODE node] [USER user.number]
[FILE pathname | [DEVICE device.number] [INODE
Try:
UNLOCK ALL
to remove all locks.
No! No! No!
This command should never have been allowed. As another response said, this
clears all locks (record, file, group, etc) for all users.
It is highly likely to result in data integrity problems as processes find
themselves updating the same
One might think there was no useful info in the attached post, but then
one notices that the From address tells us that Glenn Herbert now has
an IBM address.
If one assumes Glenn still has some association with DataStage, one may
deduce that there may have been some truth to the rumour that
REPOSTED FOR NON-MEMBER
From: Dave Bryant [EMAIL PROTECTED]
Subject: DesignBais Eval for Unidata and Universe available
We have just made the evaluation version for Unidata on Windows available from
our web site. The evaluation version for Universe is already there.
DesignBais is a Web
Dear all,
Thanks for responses.
I start to use mkdbfile and I post this CREATE.REMOTEFILE filename type
modulo separator.
Regards.
Manu
-boundary ---
* CREATE A FILE IN OTHER DIRECTORY
* SYNTAX : CREATE.REMOTEFILE FILENAME TYPE MODULO SEPRATOR
Hi Martin,
I agree. Personally, I always use UNLOCK USER [userno] [option].
The poster stated:
I tried to CLEAR all the locks but was not able to do that.
The poster seemed to state that he wished to clear all locks.
Brian Grayson
Martin Phillips wrote:
Try:
UNLOCK ALL
to remove all
From the Ascential web site...
Ascential Software is joining the Information Management division within
IBM Software group and will be part of the Information Integration
Solutions unit. This acquisition extends information integration
capabilities to enable the flexibility and insight critical
I should already know the answer to this but...
for UniVerse, TRANS() ( aka XLATE() ) will cache a record behind the
scenes so that a 2nd I-descriptor that TRANS()s to the same record
(maybe different field) will not have to do the disk access again.
Is T-correlative smart enough to do the
Charles,
No rumor. IBM bought Ascential.
- Chuck Another Chuck Barouch
Stevenson, Charles wrote:
One might think there was no useful info in the attached post, but then
one notices that the From address tells us that Glenn Herbert now has
an IBM address.
If one assumes Glenn still has
I'm in the preliminary stages of looking at exposing our UniVerse database to
the .NET framework.
Initially for some read only type web-based inquiries and MS Reporting
services, but I think .NET would position us well for other applications as
well.
It seems to me that there are at least
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
Hello Mark -
We have a .Net initiative here at our company. I have tried all three of
the solutions you've mentioned. Here are my findings:
UniObjects works well. You can accomplish everything you need using this
product. It does require you to write your own code for data provision,
data
Apparently, my post on all the intricacies and details of using mkdbfile
got lost and all anyone saw was my signature. I too received just an
empty message and tried all manner of ways to view the text I actually
sent; I have learned that printing out the b apparentlyb empty message and
I think something's got Glenn's tongue (or fingers in this case...) :-)
Colin Alfke
Calgary, AB
-Original Message-
From: Glenn Herbert
---
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
Dear Glenn,
Thank you very much for theses details.
One question : Where can we found detailed documentation about OS level
universe's commands ?
I found nothing in the whole UV docs I have.
With kind regards.
Manu Fernandes
- Original Message -
From: Glenn Herbert [EMAIL
yep. my typing is fine. something within notes is discombobulating
things. oh for the days of eudora.
_
I reject your reality and substitute my own - Adam Savage
Glenn M. Herbert - Connectivity Development Engineer
Information
450 Lynx formatting failed: open3: exec of lynx --stdin --dump --force_html
--hiddenlinks=ignore --localhost --image_links --nolist --noredir --noreferer
--realm failed at /etc/smrsh/demime line 1519
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit
I was wondering what happened with that merger.
- Original Message -
From: Glenn Herbert [EMAIL PROTECTED]
And yes, I am now in the employ of IBM, which acquired Ascential and
DataStage.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit
In a message dated 6/15/05 7:36:52 AM Pacific Daylight Time, [EMAIL PROTECTED]
writes:
REPOSTED FOR NON-MEMBER
From: Dave Bryant [EMAIL PROTECTED]
Subject: DesignBais Eval for Unidata and Universe available
We have just made the evaluation version for Unidata on Windows available
from
He is but he tried to post it under a different email address by mistake.
Dave Bryant
+1 617 965 2564
+1 617 331 2863 (Cell)
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
Sent: Wednesday, June 15, 2005 4:18 PM
To:
for UniVerse, TRANS() ( aka XLATE() ) will cache a record behind the
scenes so that a 2nd I-descriptor that TRANS()s to the same record
Please excuse me for butting in. That is very interesting, as I just did
some testing that indicates that when TRANS() is used in a basic program,
performance
Well it sure looks slick. I noticed there were no prices posted. What's a
guy with a limited budget supposed to infer from that absence?
i.e. does the old adage, if you have to ask you can't afford it apply
here?
Allen
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL
In a message dated 6/15/05 3:21:54 PM Pacific Daylight Time,
[EMAIL PROTECTED] writes:
crt @(51,19) : Qty.Rcvd M
crt @(51,20) : Qty.Rcvd 'R#8'
crt @(51,21) : Qty.Rcvd
M looks like a variable in this case.
Note the lacks of quotes around it.
Will Johnson
---
u2-users
Goo'day,
At 10:44 15/06/05 -0400, you wrote:
Hi Martin,
I agree. Personally, I always use UNLOCK USER [userno] [option].
The poster stated:
I tried to CLEAR all the locks but was not able to do that.
The poster seemed to state that he wished to clear all locks.
He might've stated that he
From: Brutzman, Bill
[snip]
crt @(31,19) : Qty.Rcvd M
[snip]
I am writing to inquire about the meaning of M. Suggestions would be
appreciated.
Looks like M is a variable, so it would depend on what it contained.
I'm going to guess that M = R#9
ct CDS.BP BILL
From: Brutzman, Bill
[snip]
crt @(31,19) : Qty.Rcvd M
[snip]
I am writing to inquire about the meaning of M. Suggestions would be
appreciated.
Looks like M is a variable, so it would depend on what it contained.
I'm going to guess that M = R#9
ct CDS.BP BILL
In your code snippit, M isn't quoted, so it's probably a variable
assigned elsewhere with a more familiar conversion code.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill
Sent: Wednesday, June 15, 2005 6:21 PM
To:
Yes... M is a variable... as in...
M = R,#9
Thanks to those who responded.
--Bill
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Stevenson,
Charles
Sent: Wednesday, June 15, 2005 6:53 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2]
Experienced Unidata Internals Consultants,
We have half a dozen servers now running Unidata 6.0 on Solaris 8. We
normally run with a configuration pretty close to 'out of the box' using
the udtconf recommended params and suspect we may be able to squeeze
more out of the hardware we have. If
Allen,
I would have taken this off list but you don't give an email address.
You'll be surprised how inexpensive it is. Give me a call or drop me an
email and I'll let you know.
The problem with internet/intranet/web based apps is that there are many
different ways of pricing the application
Where ?
In a message dated 6/15/05 5:09:45 PM Pacific Daylight Time,
[EMAIL PROTECTED] writes:
Experienced Unidata Internals Consultants,
We have half a dozen servers now running Unidata 6.0 on Solaris 8. We
normally run with a configuration pretty close to 'out of the box' using
the
Hi everyone,
I recently installed UniVerse 10.0.20 onto a Solaris 8 box (Enterprise 450,
2 x 400Mhz Processors, 1GB memory.) along with Redback, to run a hybrid
Pick/ASPX/Uniobjects based banking application.
Everything seems to work Ok, however the universe spooler daemon process
usd seems to
I'm reading through all these responses and probably won't respond to
each individually.
But I do thank you all for your input.
There are several suggestions like the one below that involve
incrementing the control record BEFORE the transaction starts. Either
grab a block, or grab a master
This is a pretty good idea, Ken.
Getting current date time is probably cheaper than reading and
incrementing a control record. If time is in milliseconds, uniqueness
is even more likely so likelihood of locking a new record with SEED_VAL=
000 is good.
date()*1 + time() might be faster than
From: Anthony Dzikiewicz
So, what if you change the READVU to a READVL ?
I don't understand what READL buys me. (Not arguing, just looking to
understand.)
I thought you need a READU in order to do the write within the
transaction.
By the way, I've only been working with ISOMODE 1, if that
Missing sequential numbers isn't important to me, but it's a good point
for general discussion.
cds
From: Bruce Nichol
This is all well and good if the commit goes ahead, but if
rollback is the action, don't you lose a supposedly
sequential root key into the vapours?
Never to be seen
Ah-HA! Some real world transaction experience!
Just what I wanted, Les.
From: Les Hewkin
Start trasnactions
Readu control record then
record.ID = control record
write record
control record += 1
write control record
end
end transaction
This seems to work
From: Bill Haskett
I wonder if the same issue (transactions don't release record
locks until they're committed) applies to the LOCK/UNLOCK statement?
No, those are independent of transactions.
So could they be leveraged for the question posed here?
. . . I don't see it.
cds
---
u2-users
Would this be a worthwhile enhancement request through U2UG?
Are Ken and I the only ones whining about this:
From: [EMAIL PROTECTED]
Ideally of course, the ID would be allocated by the DBMS
transparently when the record is inserted into the file, but
neither U2 product supports that concept
From: Brian Leach
...Windows service app) in Delphi... Mutex wrapper... thread safe.
... Socket API or SOAP API...
smart aleck.
Seriously, if you are going to use transactions I would guess
the only way to avoid maintaining the key for the duration of
the transaction (to go back to the
transposing from aix other unices, what's lpstat say? Look for a problem
communicating with a printer.
Our greatest duty in this life is to help others. And please, if you can't
help them, could you at least not hurt them? - H.H. the Dalai Lama
When buying selling are controlled by
This would be a very worthwhile enhancement IMO.
SQL Server calls this an IDENTITY column, and, IIRC, it can be any column (aka
attribute), not only the primary key. That is also a useful feature when the
record key contains useful data but you still need to have sequentially assigned
numbers for
We have had a similar issue with one of our HP machines, and when we requested
support this is what we got back
* support text *
The child usd processes typically occur when a printer is in an error state or
improperly defined. The customer will be able to tell by running SPOOL -LIST
i had another query reagrding the output of LIST.READU command.
On running the command, we got multiple lines of records that were exactly
similar i.e. all the parameters inncluding the inode number; process id and
Item id were the same.
Is this a case of multiple locking of the same databse
Also check the size of the usplog reflection in the UVSPOOL directory
(CONFIG ALL to get the installed pathname). In addition to Dan's
suggestion, you could also be chewing up a lot of CPU scanning a huge
memory based spooler queue (usplog is a disk copy of the in-memory
queue). This is not
I just can't keep quiet any more.
Any auditor who depends on a non-information content, sequentially
assigned, record counters as an audit trail ought to be flogged and
sent back to Auditing For Dummies. If your auditor demands that, I'd
suspect they are a paper-based bean counter, not an
53 matches
Mail list logo
