RE: [U2] Reg output of LIST.READU

[Stevenson, Charles]

From: shuchi bhandari

> 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 file 
> by the same process? Can someone explain.

I am assming UV, not UD.

1. Are these READL locks and not READU locks?  There can be multiple
READLs on the same record.   They will show up as either "RL" or "RU"
under the Lmode column.

2. Are the Record IDs too long to fit the screen and they differ only in
the rightmost bytes where you can't see them?

3. Does LIST.READU INTERNAL show the IDs different than the others?

4. I assume the Device column is also the same. (It would be a little
strange that inodes would happen to match on files across 2
file-systems, files that happen to share the same ID scheme.)
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[U2] Universe LIST.READU and change in inode number of file

[Deepak Subhash Jadhav]

Hi,
In continuation with the locking issues I have some more questions as
follows,
The output of LIST.READU is as follows,

Device  Inode  Netnode   Userno  Lmode   Pid
LoginId  Item-ID.,
34485434  99640   50360   107   RU
15176   appsadmGGB101031
34485434 10391   050360   107   RU
15176   appsadmGGB101031

The above two entries are exactly same in nature except for the Inode
number of file on which the lock is obtained. Surprisingly the same
record is locked twice by same process and almost at same point of time
one after another.
Does this mean that universe internally changes the inode number of the
type 30 files and reallocates new inode number to same file?

How to control such LOCKs in universe which is not released because of
change in inode number of file?
Is there any way to preventing such locks which are obtained at system
level?

TIA.

Regards,
Deepak




*** CAUTION - Disclaimer ** This e-mail
contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use
of the addressee(s). If you are not the intended recipient, please notify the
sender by e-mail and delete the original message. Further, you are not to
copy, disclose, or distribute this e-mail or its contents to any other person
and any such actions are unlawful. This e-mail may contain viruses. Infosys
has taken every reasonable precaution to minimize this risk, but is not liable
for any damage you may sustain as a result of any virus in this e-mail. You
should carry out your own virus checks before opening the e-mail or
attachment. Infosys reserves the right to monitor and review the content of
all messages sent to or from this e-mail address. Messages sent to or from
this e-mail address may be stored on the Infosys e-mail system.
***INFOSYS End of Disclaimer INFOSYS***
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[U2] Universe LIST.READU and change in inode number of file

[Deepak Subhash Jadhav]

Hi,
In continuation with the locking issues I have some more questions as
follows,
The output of LIST.READU is as follows,

Device  Inode  Netnode   Userno  Lmode   Pid
LoginId  Item-ID.,
34485434  99640   50360   107   RU
15176   appsadmGGB101031
34485434 10391   050360   107   RU
15176   appsadmGGB101031

The above two entries are exactly same in nature except for the Inode
number of file on which the lock is obtained. Surprisingly the same
record is locked twice by same process and almost at same point of time
one after another.
Does this mean that universe internally changes the inode number of the
type 30 files and reallocates new inode number to same file?

How to control such LOCKs in universe which is not released because of
change in inode number of file?
Is there any way to preventing such locks which are obtained at system
level?

TIA.

Regards,
Deepak




*** CAUTION - Disclaimer ** This e-mail
contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use
of the addressee(s). If you are not the intended recipient, please notify the
sender by e-mail and delete the original message. Further, you are not to
copy, disclose, or distribute this e-mail or its contents to any other person
and any such actions are unlawful. This e-mail may contain viruses. Infosys
has taken every reasonable precaution to minimize this risk, but is not liable
for any damage you may sustain as a result of any virus in this e-mail. You
should carry out your own virus checks before opening the e-mail or
attachment. Infosys reserves the right to monitor and review the content of
all messages sent to or from this e-mail address. Messages sent to or from
this e-mail address may be stored on the Infosys e-mail system.
***INFOSYS End of Disclaimer INFOSYS***
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] Best practice for Sequential IDs using TRANSACTION START & COMMIT/RO...

[Clifton Oliver]

FYI. I took the liberty of forwarding this to the U2UG Enhancements 
Committee.



--

Regards,

Clif


On Jun 15, 2005, at 10:01 PM, Steve Johnson wrote:


This would be a very worthwhile enhancement IMO.

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

Re: [U2] Best practice for Sequential IDs using TRANSACTION START & COMMIT/RO...

[Clifton Oliver]

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 Information Systems 
Auditor.



--

Regards,

Clif

Member ISACA
www.isaca.org

~~~
W. Clifton Oliver, CCP
CLIFTON OLIVER & ASSOCIATES
Tel: +1 619 460 5678Web: www.oliver.com
~~~


On Jun 15, 2005, at 8:47 PM, Stevenson, Charles wrote:


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

That'd make an auditor go spare. "61,62,63,65,66... Hang
on!  Where's
64?  Stop the presses!   Everybody down and look for 64..."

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

Re: [U2] Universe spooler daemon memory and cpu usage

[Clifton Oliver]

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 unusual if you generate many, many hold files. On 
some platforms, the size of the in-memory version of usplog will grow 
to the point to where UniVerse crashes. There is no UniVerse solution 
to this other than smack people about the head and shoulders and insist 
they clear out their old hold files (not to be confused with &HOLD& 
files).


 You can contact me off-list at [EMAIL PROTECTED] for information 
about my spooler product that solves both of the above problems. 



--

Regards,

Clif

~~~
W. Clifton Oliver, CCP
CLIFTON OLIVER & ASSOCIATES
Tel: +1 619 460 5678Web: www.oliver.com
~~~


On Jun 15, 2005, at 9:37 PM, Dan Fitzgerald wrote:

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 legislation, the first thing 
to be bought & sold are the legislators" - P.J. O'Rourke

Dan Fitzgerald





From: "Dan Barrett" <[EMAIL PROTECTED]>
Reply-To: u2-users@listserver.u2ug.org
To: <[EMAIL PROTECTED]>
Subject: [U2] Universe spooler daemon memory and cpu usage
Date: Thu, 16 Jun 2005 11:31:31 +0930

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 chew up an excessive amount of memory and CPU time.
I've reset the spooler daemon but there seems to be no effect, I 
haven't
tried stopping and restarting universe or the spooler daemon yet, as 
this is

now a production banking system.

eg - here's output from "top"  -

load averages:  1.99,  2.07,  1.95   holden
11:21:55
596 processes: 592 sleeping, 1 zombie, 2 stopped, 1 on cpu
CPU states: 64.1% idle, 16.9% user, 16.7% kernel,  2.3% iowait,  0.0% 
swap

Memory: 1024M real, 224M free, 936M swap in use, 1.2G swap free

   PID USERNAME THR PR NCE  SIZE   RES STATE   TIME FLTSCPU 
COMMAND

   391 root   1  0   0 55.0M 38.9M sleep  82.5H0 20.87% usd
  5314 ultracs1 23   0 12.2M 6304K sleep 152:090  2.23% uvsh
  5320 ultracs1  4   0 12.3M 6408K sleep 151:405  2.22% uvsh
 11880 ultracs1 13   0 11.9M 7264K sleep   1:103  2.21% uvsh
  5319 ultracs1 22   0 12.2M 6288K sleep 149:230  2.10% uvsh
  8451 lrestas1 11   0 11.0M 6264K sleep  10:350  1.34% uvsh
  2532 ultracs1 24   0 13.0M 7152K sleep  87:123  1.13% uvsh
 25447 morgan 1 34   0 2720K 1080K sleep  92:440  1.11% top
  2516 ultracs1 33   0 13.1M 7200K sleep  82:310  0.92% uvsh
  2536 ultracs1 34   0 13.8M 7880K sleep  85:040  0.86% uvsh
  2529 ultracs1 35   0 12.9M 7024K sleep  84:530  0.86% uvsh
  2530 ultracs1 33   0 13.8M 7976K sleep  86:350  0.85% uvsh
  2541 ultracs1 36   0 13.1M 7328K sleep  89:140  0.84% uvsh
  2512 ultracs1 46   0 13.0M 7128K sleep  86:070  0.80% uvsh
  2519 ultracs1 34   0 13.1M 7240K sleep  80:170  0.77% uvsh

  5319 ultracs1 33   0 12.3M 6344K sleep 149:200  0.77% uvsh

You can see "usd" tops the list at 20% CPU time, and 55MB memory. 
Memory

usage has been gradually creeping up, about 1 MB a day or so.
Has anyone come across this before? I'm not a universe expert by any 
means

having come from a mostly oracle background, but this seems pretty
excessive.
Printing still works as expected but users tell me the system does 
take a
reasonable time to generate a hold file, ie 3 seconds or so for a 
small
file. On earler version of universe this was basically instantaneous 
on the

same platform.

The app we're running does generate a reasonable number of print jobs 
and
spooler hold files, but the level of spooler daemon cpu and memory 
usage

doesn't drop, even when we're not printing anything.

Any ideas?
Thanks

Dan
---
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/

[U2] Reg output of LIST.READU

[shuchi bhandari]

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 file by the same 
process? Can someone explain.


Thanks in advance

_
Cant have enough of SRK? http://server1.msn.co.in/sp05/iifa/ Help him bag 
the award.

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

RE: [U2] Universe spooler daemon memory and cpu usage

[Jamie Wilbraham]

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 
and see if there are errors against any of the printer queues.

We have an engineering case to do with defunct usd processes consuming 
excessive CPU.

Here's the description:
"... if you have a printer with an error status, a child usd process is 
generated every 2 minutes by usd. This frequency can be changed using the -r 
option of usd command".

This issue has been resolved as of UniVerse 10.0.19 for HP platform. The fix 
stopped the parent usd from stacking defunct child usd processes if the printer 
was in error state.
*

We did find a printer that had droppped it's IP which caused our issue.

My guess is the problem may not have been fully corrected in 10.0.19.

Cheers


Jamie

-Original Message-
From: Dan Barrett [mailto:[EMAIL PROTECTED]
Sent: Thursday, 16 June 2005 10:02
To: [EMAIL PROTECTED]
Subject: [U2] Universe spooler daemon memory and cpu usage


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 chew up an excessive amount of memory and CPU time.
I've reset the spooler daemon but there seems to be no effect, I haven't
tried stopping and restarting universe or the spooler daemon yet, as this is
now a production banking system.

eg - here's output from "top"  -

load averages:  1.99,  2.07,  1.95   holden
11:21:55
596 processes: 592 sleeping, 1 zombie, 2 stopped, 1 on cpu
CPU states: 64.1% idle, 16.9% user, 16.7% kernel,  2.3% iowait,  0.0% swap
Memory: 1024M real, 224M free, 936M swap in use, 1.2G swap free

   PID USERNAME THR PR NCE  SIZE   RES STATE   TIME FLTSCPU COMMAND
   391 root   1  0   0 55.0M 38.9M sleep  82.5H0 20.87% usd
  5314 ultracs1 23   0 12.2M 6304K sleep 152:090  2.23% uvsh
  5320 ultracs1  4   0 12.3M 6408K sleep 151:405  2.22% uvsh
 11880 ultracs1 13   0 11.9M 7264K sleep   1:103  2.21% uvsh
  5319 ultracs1 22   0 12.2M 6288K sleep 149:230  2.10% uvsh
  8451 lrestas1 11   0 11.0M 6264K sleep  10:350  1.34% uvsh
  2532 ultracs1 24   0 13.0M 7152K sleep  87:123  1.13% uvsh
 25447 morgan 1 34   0 2720K 1080K sleep  92:440  1.11% top
  2516 ultracs1 33   0 13.1M 7200K sleep  82:310  0.92% uvsh
  2536 ultracs1 34   0 13.8M 7880K sleep  85:040  0.86% uvsh
  2529 ultracs1 35   0 12.9M 7024K sleep  84:530  0.86% uvsh
  2530 ultracs1 33   0 13.8M 7976K sleep  86:350  0.85% uvsh
  2541 ultracs1 36   0 13.1M 7328K sleep  89:140  0.84% uvsh
  2512 ultracs1 46   0 13.0M 7128K sleep  86:070  0.80% uvsh
  2519 ultracs1 34   0 13.1M 7240K sleep  80:170  0.77% uvsh

  5319 ultracs1 33   0 12.3M 6344K sleep 149:200  0.77% uvsh

You can see "usd" tops the list at 20% CPU time, and 55MB memory. Memory
usage has been gradually creeping up, about 1 MB a day or so. 
Has anyone come across this before? I'm not a universe expert by any means
having come from a mostly oracle background, but this seems pretty
excessive.
Printing still works as expected but users tell me the system does take a
reasonable time to generate a hold file, ie 3 seconds or so for a small
file. On earler version of universe this was basically instantaneous on the
same platform.

The app we're running does generate a reasonable number of print jobs and
spooler hold files, but the level of spooler daemon cpu and memory usage
doesn't drop, even when we're not printing anything.

Any ideas?
Thanks

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

**
This email is intended only for the use of the individual or entity named above 
and may contain information that is confidential and privileged.
If you are not the intended recipient, you are hereby notified that any 
dissemination, distribution or copying of this Email is strictly prohibited.
When addressed to our clients, any opinions or advice contained in this Email 
are subject to the terms and conditions expressed in the governing Keystart 
client engagement letter.
If you have received this Email in error, please notify us immediately by 
return email or telephone +61 8 9338 3100 and destroy the original message.

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

Re: [U2] Best practice for Sequential IDs using TRANSACTION START & COMMIT/RO...

[Steve Johnson]

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 SOX or some other reason.

I'm thinking of an additional keyword for CREATE.FILE like "IDENTITY n" where 
"n"
attribute number in which to place the sequential number, n=0 means the key and
this is the default. There are some implementation wrinkles to work out such as
the syntax of WRITE in basic when the OS will assign the key value; what happens
if a program changes the value of the IDENTITY attribute; and so on.

Steve Johnson
FXA Group Ltd
Bangkok

Original message from Stevenson, Charles on 6/16/2005 10:52 AM:

>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 as far as I know
>
>
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Universe spooler daemon memory and cpu usage

[Dan Fitzgerald]

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 legislation, the first thing to be 
bought & sold are the legislators" - P.J. O'Rourke

Dan Fitzgerald





From: "Dan Barrett" <[EMAIL PROTECTED]>
Reply-To: u2-users@listserver.u2ug.org
To: <[EMAIL PROTECTED]>
Subject: [U2] Universe spooler daemon memory and cpu usage
Date: Thu, 16 Jun 2005 11:31:31 +0930

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 chew up an excessive amount of memory and CPU time.
I've reset the spooler daemon but there seems to be no effect, I haven't
tried stopping and restarting universe or the spooler daemon yet, as this 
is

now a production banking system.

eg - here's output from "top"  -

load averages:  1.99,  2.07,  1.95   holden
11:21:55
596 processes: 592 sleeping, 1 zombie, 2 stopped, 1 on cpu
CPU states: 64.1% idle, 16.9% user, 16.7% kernel,  2.3% iowait,  0.0% swap
Memory: 1024M real, 224M free, 936M swap in use, 1.2G swap free

   PID USERNAME THR PR NCE  SIZE   RES STATE   TIME FLTSCPU COMMAND
   391 root   1  0   0 55.0M 38.9M sleep  82.5H0 20.87% usd
  5314 ultracs1 23   0 12.2M 6304K sleep 152:090  2.23% uvsh
  5320 ultracs1  4   0 12.3M 6408K sleep 151:405  2.22% uvsh
 11880 ultracs1 13   0 11.9M 7264K sleep   1:103  2.21% uvsh
  5319 ultracs1 22   0 12.2M 6288K sleep 149:230  2.10% uvsh
  8451 lrestas1 11   0 11.0M 6264K sleep  10:350  1.34% uvsh
  2532 ultracs1 24   0 13.0M 7152K sleep  87:123  1.13% uvsh
 25447 morgan 1 34   0 2720K 1080K sleep  92:440  1.11% top
  2516 ultracs1 33   0 13.1M 7200K sleep  82:310  0.92% uvsh
  2536 ultracs1 34   0 13.8M 7880K sleep  85:040  0.86% uvsh
  2529 ultracs1 35   0 12.9M 7024K sleep  84:530  0.86% uvsh
  2530 ultracs1 33   0 13.8M 7976K sleep  86:350  0.85% uvsh
  2541 ultracs1 36   0 13.1M 7328K sleep  89:140  0.84% uvsh
  2512 ultracs1 46   0 13.0M 7128K sleep  86:070  0.80% uvsh
  2519 ultracs1 34   0 13.1M 7240K sleep  80:170  0.77% uvsh

  5319 ultracs1 33   0 12.3M 6344K sleep 149:200  0.77% uvsh

You can see "usd" tops the list at 20% CPU time, and 55MB memory. Memory
usage has been gradually creeping up, about 1 MB a day or so.
Has anyone come across this before? I'm not a universe expert by any means
having come from a mostly oracle background, but this seems pretty
excessive.
Printing still works as expected but users tell me the system does take a
reasonable time to generate a hold file, ie 3 seconds or so for a small
file. On earler version of universe this was basically instantaneous on the
same platform.

The app we're running does generate a reasonable number of print jobs and
spooler hold files, but the level of spooler daemon cpu and memory usage
doesn't drop, even when we're not printing anything.

Any ideas?
Thanks

Dan
---
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] Best practice for Sequential IDs using TRANSACTION START & COMMIT/RO...

[Stevenson, Charles]

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 original post) would be to 
> take it out of the transaction space 

I don't like it, but it's better than your previous idea.
This seems to be an emerging theme:

From: [EMAIL PROTECTED]
> Could you call NEXT.AVAIL.ID before TRANSACTION START, and 
> again after the transaction rollback, assuming you can detect 
> if the transaction was rolled  back? 
> If the transaction committed, then no further action would be 
>  required.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Best practice for Sequential IDs using TRANSACTION START & COMMIT/RO...

[Stevenson, Charles]

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 as far as I know

I don't know why it isn't already there.

> (perhaps you could use a trigger, but ...).

h...

>  so the next best 
> would be simply to move the ID allocation to be the very last 
> step in the transaction.  Process everything under a dummy 
> key,

unless this new foreign key is needed to be stored in another file.

> then when all is ready and complete, do the ID 
> allocation.  If using explicit TRANSACTION boundaries then do 
> this as the last IO inside the transaction and the issue of 
> locks being held until the COMMIT/ROLLBACK should cease to be 
> significant.

unless modular coding (which is generally a good idea) has these buried
in external blackbox subroutines.

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

RE: [U2] Best practice for Sequential IDs using TRANSACTION START & COMMIT/R...

[Stevenson, Charles]

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 mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Best practice for Sequential IDs using TRANSACTION START & COMMIT/RO...

[Stevenson, Charles]

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 for us. We do have loads of control 
> records for generating ID and we never have any missing 
> numbers. 

And for really big 'trasnactions', where there is a lot of other writes
mixed in, having the control record locked for the duration of the
transaction is not a bottleneck for you? That was my main concern.

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

RE: [U2] Best practice for Sequential IDs using TRANSACTION START & COMMIT/RO...

[Stevenson, Charles]

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 again?
> 
> That'd make an auditor go spare. "61,62,63,65,66... Hang 
> on!  Where's 
> 64?  Stop the presses!   Everybody down and look for 64..."
> 
> >This is actually a modification of another suggestion to 
> lock a "block"
> >of numbers, too.

and

> From: Steve Johnson
> But this would not keep those pesky auditors happy. In the 
> following sequence, how could they know that item 1*4 was missing?
> 
> 1*1
> 1*2
> 1*3
> 2*1
> etc.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Best practice for Sequential IDs using TRANSACTION START & COMMIT/ROLLBACK

[Stevenson, Charles]

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

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

RE: [U2] Best practice for Sequential IDs using TRANSACTION START & COMMIT/ROLLBACK

[Stevenson, Charles]

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 2 fmts and concatenation.
But now I'm nitpicking instead of looking at big picture.

It satisfies a generation of meaningless keys.  Sequential numbers are
nicer just because they can hash so well in type-2 files.  God help us
if that matters.

It doesn't satisfy OTHER people's Sarbanes-Oxley concerns about auditors
wanting sequential numbers without unaccounted holes.

Nor can it be retrofitted into existing structures with the control
record like I first described.  On the other hand, retrofitting
TRANSACTIONs into existing systems is suspect to start with.

All in all, a good approach and one we actually use on one of our
sub-systems.  One of our programmer/analysts is partial to it.

cds


From: Ken Wallis
> I'm not really very fond of straight sequential IDs when the DBMS
doesn't provide
> inbuilt  support for them,

yeah, it's the pits.  I don't know why the DBMS doesn't have this
decades ago.

> instead I like to do something like this:
>
>  OPEN "","FILE" TO FILE_VAR THEN
> SEED_HEAD = FMT(DATE(),"5'0'R"):FMT(TIME(),"5'0'R")
> SEED_VAL="000"
> GOT_LOCK = 0
> LOOP
> SEED_KEY = SEED_HEAD:SEED_VAL
>   READVU DUMMY FROM FILE_VAR,SEED_KEY,0 LOCKED
>   NULL ;* need this or READVU will block
> END THEN
>   RELEASE FILE_VAR,SEED_KEY

of course, the release wont happen until after the transaction
completes.  
One could look to see if record exists before attempting to lock it,
but that's extra overhead.  I'll bet my READSEQ/WRITESEQ variation on
Ray Wurlod's idea would be faster than that.
Or just live with this occasional hit on the THEN clause for records
created and already released within the current second.

> END ELSE
> GOT_LOCK = 1
> END
> UNTIL GOT_LOCK
>   SEED_VAL += 1
>   SEED_VAL = FMT(SEED_VAL,"3'0'R")
> REPEAT
>* now do something which uses SEED_KEY - this is yours
exclusively
>  END
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Best practice for Sequential IDs using TRANSACTION START & COMMIT/RO...

[Stevenson, Charles]

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 number and start incrementing sub-numbers
as needed.  Maybe go back & fix the control record after transaction is
ROLLBACKed or otherwise doesn't go as expected.

I like the '*':SUB.KEY idea below.  Ken Wallis had a similar method.

This approach of claiming the sequential-id key (or block of keys)
before the transaction starts assumes one has a fair idea of what will
be needed before TRANSACTION START is executed.  But one may not know
that until deep into processing.  Or - even better! - maybe your code is
modular enough that these kinds of updates are going to happen inside
blackbox external utility subroutines, where the outer process does not
know or care about the kind of updates that might happen inside those
calls.

-Original Message-
From:  Bob Woodward

> But his comments have generated a modification idea to my earlier
suggestion.
> If, before the TRANSACTION START command, you get a "next available
ID" then
> use that as a "root" value, you can then create a sequential number
with an
> internal sequential number.  IE:
>
>ROOT.KEY=''
>LOOP UNTIL ROOT.KEY
>  RELEASE  ;* make sure all locks are released
>  READU ROOT.KEY FROM CF, "NEXT.ROOT.KEY" THEN
>READ JUNK FROM OUTFILE, ROOT.KEY:"*1" THEN
>  WRITE ROOT.KEY+1 ON CF, "NEXT.ROOT.KEY"
>  ROOT.KEY=''
>END
>  END
>REPEAT
>WRITE ROOT.KEY+1 ON CF, "NEXT.ROOT.KEY"
>TRANSACTION START
>  SUB.KEY = 1
>  EXIT.FLAG=''
>  LOOP
>OUTRCD = ''
>[do whatever builds OUTRCD]
>WRITE OUTRCD ON OUTFILE, ROOT.KEY:"*":SUB.KEY
>SUB.KEY += 1
>[whatever to determine if time to exit]
>  UNTIL EXIT.FLAG REPEAT
>TRANSACTION COMMIT   ;* or whatever logic to rollback.
>
>
>This is actually a modification of another suggestion to lock a "block"
of numbers, too.  Difference is a block of numbers would be a maximum
number of records that >could be created, like 123400 to 123499 if
blocking to a factor of 100.  With a multi-part >key, using the
asterisk, you no longer have the maximum number block.  It could go 10,
100, or> even 10,000 if need be.  You could even use something like
ROOT.KEY:"*0"
if you like as a sort of "header" record to keep track of how many
records there should be for the ROOT.KEY family.  This should keep the
auditors happy, "Transactions" sequential, and cross-transaction locking
to an extremely short interval.  

Also, by using READU without the LOCKED clause, the program will wait
that short interval until the record is available.

As a side comment, this method will also make it easy to keep records in
a sorted, associated order.  You could even get a count of process runs
by selecting @ID = "[*1" or SUB.KEY = "0" if you set the dict record.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[U2] Universe spooler daemon memory and cpu usage

[Dan Barrett]

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 chew up an excessive amount of memory and CPU time. 
I've reset the spooler daemon but there seems to be no effect, I haven't
tried stopping and restarting universe or the spooler daemon yet, as this is
now a production banking system. 
 
eg - here's output from "top"  - 
 
load averages:  1.99,  2.07,  1.95   holden
11:21:55
596 processes: 592 sleeping, 1 zombie, 2 stopped, 1 on cpu
CPU states: 64.1% idle, 16.9% user, 16.7% kernel,  2.3% iowait,  0.0% swap
Memory: 1024M real, 224M free, 936M swap in use, 1.2G swap free
 
   PID USERNAME THR PR NCE  SIZE   RES STATE   TIME FLTSCPU COMMAND
   391 root   1  0   0 55.0M 38.9M sleep  82.5H0 20.87% usd
  5314 ultracs1 23   0 12.2M 6304K sleep 152:090  2.23% uvsh
  5320 ultracs1  4   0 12.3M 6408K sleep 151:405  2.22% uvsh
 11880 ultracs1 13   0 11.9M 7264K sleep   1:103  2.21% uvsh
  5319 ultracs1 22   0 12.2M 6288K sleep 149:230  2.10% uvsh
  8451 lrestas1 11   0 11.0M 6264K sleep  10:350  1.34% uvsh
  2532 ultracs1 24   0 13.0M 7152K sleep  87:123  1.13% uvsh
 25447 morgan 1 34   0 2720K 1080K sleep  92:440  1.11% top
  2516 ultracs1 33   0 13.1M 7200K sleep  82:310  0.92% uvsh
  2536 ultracs1 34   0 13.8M 7880K sleep  85:040  0.86% uvsh
  2529 ultracs1 35   0 12.9M 7024K sleep  84:530  0.86% uvsh
  2530 ultracs1 33   0 13.8M 7976K sleep  86:350  0.85% uvsh
  2541 ultracs1 36   0 13.1M 7328K sleep  89:140  0.84% uvsh
  2512 ultracs1 46   0 13.0M 7128K sleep  86:070  0.80% uvsh
  2519 ultracs1 34   0 13.1M 7240K sleep  80:170  0.77% uvsh

  5319 ultracs1 33   0 12.3M 6344K sleep 149:200  0.77% uvsh

You can see "usd" tops the list at 20% CPU time, and 55MB memory. Memory
usage has been gradually creeping up, about 1 MB a day or so.  
Has anyone come across this before? I'm not a universe expert by any means
having come from a mostly oracle background, but this seems pretty
excessive. 
Printing still works as expected but users tell me the system does take a
reasonable time to generate a hold file, ie 3 seconds or so for a small
file. On earler version of universe this was basically instantaneous on the
same platform. 

The app we're running does generate a reasonable number of print jobs and
spooler hold files, but the level of spooler daemon cpu and memory usage
doesn't drop, even when we're not printing anything. 

Any ideas?
Thanks

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

Re: [U2] Need consultant with performance tuning experince for UD6 on Solaris

[FFT2001]

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 udtconf recommended params and suspect we may be able to squeeze  
 more out of the hardware we have. If you have experience tuning Unidata 
 on Solaris, and are interested in consulting on a project like this, 
 please contact me at [EMAIL PROTECTED]
 
 Dan Eichholz
 Internet Production, Inc. >>
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] [AD] DesignBAIS

[Dave Bryant]

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 and as we want to work with the
application developer/VAR/ISV to make sure that our pricing model fits their
business model. We have 4 standard methods and that is without things like
application transaction based pricing. If we tried to put all the details on
the Web everyone would be very confused. 

We're all on limited budgets these days.

Dave Bryant
+1 617 965 2564
+1 617 331 2863 (Cell)
[EMAIL PROTECTED] 
 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Allen E. Elwood
Sent: Wednesday, June 15, 2005 6:19 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] [AD] DesignBAIS

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 PROTECTED] Behalf Of Dave Bryant
Sent: Wednesday, June 15, 2005 2:13 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] [AD] DesignBAIS


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: u2-users@listserver.u2ug.org
Subject: Re: [U2] [AD] DesignBAIS

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 our web site. The evaluation version for Universe is already there. >>

And more interesting.  Why wouldn't Dave Bryant be a member of the U2 list.
Will Johnson
---
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/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[U2] Need consultant with performance tuning experince for UD6 on Solaris

[Dan Eichholz]

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 you have experience tuning Unidata 
on Solaris, and are interested in consulting on a project like this, 
please contact me at [EMAIL PROTECTED]


Dan Eichholz
Internet Production, Inc.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Conversion Code - M

[Brutzman, Bill]

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] Conversion Code - M


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

 BILL
0001 M = "R#7"
0002   Qty.Rcvd = '2.0'
0003   crt quote( Qty.Rcvd M )
0004   crt quote( Qty.Rcvd 'R#8' )
0005   crt quote( Qty.Rcvd )
0006 
0007   Qty.Rcvd = -Qty.Rcvd
0008 
0009   crt quote( Qty.Rcvd M )
0010   crt quote( Qty.Rcvd 'R#8' )
0011   crt quote( Qty.Rcvd )
>RUN CDS.BP BILL
"2.0"
" 2.0"
"2.0"
" -2"
"  -2"
"-2"
---
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] Conversion Code - M

[u2]

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: 'u2-users@listserver.u2ug.org'
Subject: [U2] Conversion Code - M


In UniVerse with Dynamic Connect, some legacy UniBasic seems to apply a
conversion thing such that...

  crt @(31,19) : Qty.Rcvd M
  crt @(31,20) : Qty.Rcvd 'R#8'
  crt @(31,21) : Qty.Rcvd 

  Qty.Rcvd = -Qty.Rcvd

  crt @(51,19) : Qty.Rcvd M
  crt @(51,20) : Qty.Rcvd 'R#8'
  crt @(51,21) : Qty.Rcvd 

yields...

 |   2.0  -2
 |  2.0  -2
 | 2.0 -2

Thus, I am writing to inquire about the meaning of "M".  Suggestions
would be appreciated.

--Bill
---
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] Conversion Code - M

[Stevenson, Charles]

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

 BILL
0001   M = "R#9"
0002   Qty.Rcvd = '2.0'
0003   crt quote( Qty.Rcvd M )
0004   crt quote( Qty.Rcvd 'R#8' )
0005   crt quote( Qty.Rcvd )
0006 
0007   Qty.Rcvd = -Qty.Rcvd
0008 
0009   crt quote( Qty.Rcvd M )
0010   crt quote( Qty.Rcvd 'R#8' )
0011   crt quote( Qty.Rcvd )
>RUN CDS.BP BILL
"  2.0"
" 2.0"
"2.0"
"   -2"
"  -2"
"-2"
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Conversion Code - M

[Stevenson, Charles]

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

 BILL
0001 M = "R#7"
0002   Qty.Rcvd = '2.0'
0003   crt quote( Qty.Rcvd M )
0004   crt quote( Qty.Rcvd 'R#8' )
0005   crt quote( Qty.Rcvd )
0006 
0007   Qty.Rcvd = -Qty.Rcvd
0008 
0009   crt quote( Qty.Rcvd M )
0010   crt quote( Qty.Rcvd 'R#8' )
0011   crt quote( Qty.Rcvd )
>RUN CDS.BP BILL
"2.0"
" 2.0"
"2.0"
" -2"
"  -2"
"-2"
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] How to release locks (LIST.READU)

[Bruce Nichol]

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 wished to "clear all locks", but the very nature 
of his original question showed he appeared to have minimal knowldge of the 
various locking mechanisms, and therefore IMHO any and all "whoa!" and 
lesser cautionary messages, are indeed, more than apt!


How many times have we all heard "But, he said to do ..." just after a 
catastrophe?





--
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.7.5/18 - Release Date: 15/06/05


Regards,

Bruce Nichol
Talon Computer Services
ALBURYNSW 2640
Australia

http://www.taloncs.com.au

Tel: +61 (0)411149636
Fax: +61 (0)260232119

If it ain't broke, fix it till it is! 



--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.7.5/18 - Release Date: 15/06/05
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] Conversion Code - M

[FFT2001]

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 mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] [AD] DesignBAIS

[Allen E. Elwood]

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 PROTECTED] Behalf Of Dave Bryant
Sent: Wednesday, June 15, 2005 2:13 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] [AD] DesignBAIS


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: u2-users@listserver.u2ug.org
Subject: Re: [U2] [AD] DesignBAIS

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 our web site. The evaluation version for Universe is already there. >>

And more interesting.  Why wouldn't Dave Bryant be a member of the U2 list.
Will Johnson
---
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/

[U2] Conversion Code - M

[Brutzman, Bill]

In UniVerse with Dynamic Connect, some legacy UniBasic seems to apply a
conversion thing such that...

  crt @(31,19) : Qty.Rcvd M
  crt @(31,20) : Qty.Rcvd 'R#8'
  crt @(31,21) : Qty.Rcvd 

  Qty.Rcvd = -Qty.Rcvd

  crt @(51,19) : Qty.Rcvd M
  crt @(51,20) : Qty.Rcvd 'R#8'
  crt @(51,21) : Qty.Rcvd 

yields...

 |   2.0  -2
 |  2.0  -2
 | 2.0 -2

Thus, I am writing to inquire about the meaning of "M".  Suggestions would
be appreciated.

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

[U2] AD: UniVerse Analyst/Programmer Required - Wellington, New Zealan d

[Sara Burns]

To allow us to deliver a number of projects we require an experienced
Analyst/Programmer for a 2 year contract.  
 
The projects will be developed mainly in a GUI environment using the ExiTerm
toolset.  Some maintenance work will also be required using our TN4 program
generator.  Good UniBasic skills are essential.  Training in ExiTerm and TN4
will be provided.
 
Public Trust IS department supports developments in diverse areas some of
which are:- UniVerse, Vantive, Oracle Warehousing, SQLServer, Websphere, VB,
VBA, Java, Chameleon.  As we are a small team of Business Analysts and
Analyst/Programmers we provide staff with a high degree of variety and job
satisfaction.
 
Please address any enquiries to Warwick Annear, Applications Development
Manager.  [EMAIL PROTECTED]
  
 
Sara Burns
 
Sara Burns (SEB) 


Integration Manager

Public Trust 
Phone: +64 (04) 474-3841 (DDI) 

Mobile: 027 457 5974
<  mailto:[EMAIL PROTECTED]>

Information contained in this communication is confidential. If you are not
the intended recipient the information should not be used, disclosed, copied
or commercialised. The information is not necessarily the views nor the
official communication of Public Trust. No guarantee or representation is
made that the communication is free of errors, virus or interference.

 

Ask us how you can protect your children's future with a family trust from 
Public Trust.
Call 0800 505 405 to request your free copy of our family trust guide.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] [UV] TRANS vs T-correlative: caching last record

[Barry Brevik]

>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 (when compared to READing the record) is degraded when a second
field in the same record is TRANS'd. This is on UV 9.6.1.3 on W2K.

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

RE: [U2] [AD] DesignBAIS

[Dave Bryant]

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: u2-users@listserver.u2ug.org
Subject: Re: [U2] [AD] DesignBAIS

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 our web site. The evaluation version for Universe is already there. >>

And more interesting.  Why wouldn't Dave Bryant be a member of the U2 list.
Will Johnson
---
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] [AD] DesignBAIS

[FFT2001]

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 our web site. The evaluation version for Universe is already there. >>

And more interesting.  Why wouldn't Dave Bryant be a member of the U2 list.
Will Johnson
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] [uv]CREATE.FILE syntax for remote directories

[Jerry Banker]

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 http://listserver.u2ug.org/

RE: [U2] [uv]CREATE.FILE syntax for remote directories

[Glenn Herbert]

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 http://listserver.u2ug.org/

RE: [U2] [uv]CREATE.FILE syntax for remote directories

[Glenn Herbert]

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 Integration Solutions, IBM Software Group
50 Washington Street Westboro, MA 01581
 508-599-7281 direct 



<[EMAIL PROTECTED]> 
Sent by: [EMAIL PROTECTED]
06/15/2005 12:29 PM
Please respond to
u2-users


To

cc

Subject
RE: [U2] [uv]CREATE.FILE syntax for remote directories






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/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] [uv]CREATE.FILE syntax for remote directories

[Manu Fernandes]

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 PROTECTED]>

To: 
Sent: Wednesday, June 15, 2005 6:19 PM
Subject: [U2] [uv]CREATE.FILE syntax for remote directories



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 bapparentlyb empty message 
and

holding a candle behind the page does in fact not only NOT reveal any
words, it actually causes the page to be consumed rather rapidly in
flames!!

Ok.  So now that I got past the humorous part J, here is the re-created
reply which I sent:

You can create a dynamic file using mkdbfile as follows:

mkdbfile  filename 30  
-u uid bg gid bm mode

where

 is the MINIMUM.MODULUS value

 is either 4 or 8 (for GROUP.SIZE 1 or 2 respectively)

 is either 20 (GENERAL) or 21 (SEQ.NUM)

 is the MERGE.LOAD value as a percentage

 is the SPLIT.LOAD value as a percentage

 is the LARGE.REC value as a percentage or decimal

-u uid is an optional value specifying ownership (must be root to change
from current user)

-g gid is an optional value specifying group ownership (must be root to
change from current group)

-m mode is an option decimal value specifying file permissions



For example:

mkdbfile MYFILE 30 10 4 20 50 80 1638 bm 438


would create a dynamic file named MYFILE with a minimum modulus value of
10, with a group separation of 4 (mapping to GROUP.SIZE 1), using an
internal hashing of GENERAL, where merging is performed once the file
falls below 50%, where splitting occurs once the file is over 80% full,
and large records (kept in the OVER.30 file) consist of 1638 character or
more.  Additionally, the bm 438 option is used to set file permissions to
brw-rw-rw- (octal 666 converted from decimal 438).

And yes, I am now in the employ of IBM, which acquired Ascential and
DataStage.






From:[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Key Ally
<[EMAIL PROTECTED]>
Sent: Wednesday, June 15, 2005 11:08 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] [uv]CREATE.FILE syntax for remote directories



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 some association with DataStage, one may
deduce that there may have been some truth to the rumour that DataStage
now has some association with IBM. And it looks like things have
progressed beyond the idea stage.
--- 
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] [uv]CREATE.FILE syntax for remote directories

[colin.alfke]

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/

[U2] [uv]CREATE.FILE syntax for remote directories

[Glenn Herbert]

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 bapparentlyb empty message and 
holding a candle behind the page does in fact not only NOT reveal any 
words, it actually causes the page to be consumed rather rapidly in 
flames!!

Ok.  So now that I got past the humorous part J, here is the re-created 
reply which I sent:

You can create a dynamic file using mkdbfile as follows:

mkdbfile  filename 30   
-u uid bg gid bm mode

 where

 is the MINIMUM.MODULUS value

 is either 4 or 8 (for GROUP.SIZE 1 or 2 respectively)

 is either 20 (GENERAL) or 21 (SEQ.NUM)

 is the MERGE.LOAD value as a percentage

 is the SPLIT.LOAD value as a percentage

 is the LARGE.REC value as a percentage or decimal 

-u uid is an optional value specifying ownership (must be root to change 
from current user)

-g gid is an optional value specifying group ownership (must be root to 
change from current group)

-m mode is an option decimal value specifying file permissions

 

For example:

mkdbfile MYFILE 30 10 4 20 50 80 1638 bm 438

 
would create a dynamic file named MYFILE with a minimum modulus value of 
10, with a group separation of 4 (mapping to GROUP.SIZE 1), using an 
internal hashing of GENERAL, where merging is performed once the file 
falls below 50%, where splitting occurs once the file is over 80% full, 
and large records (kept in the OVER.30 file) consist of 1638 character or 
more.  Additionally, the bm 438 option is used to set file permissions to 
brw-rw-rw- (octal 666 converted from decimal 438).

 And yes, I am now in the employ of IBM, which acquired Ascential and 
DataStage.

 




From:[EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED] On Behalf Of Key Ally 
<[EMAIL PROTECTED]>
Sent: Wednesday, June 15, 2005 11:08 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] [uv]CREATE.FILE syntax for remote directories

 

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 some association with DataStage, one may 
>deduce that there may have been some truth to the rumour that DataStage 
>now has some association with IBM. And it looks like things have 
>progressed beyond the idea stage. 
--- 
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] U2 and .NET

[David Cason]

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 binding, and ADO.Net.

I was never successful at getting mv.Net to work. Mind you at the time I
tried it, it was pre-release. I didn't have much luck with the
installation and not much luck with support. I believe the support (at
the time) came out of the U.K. from a company called "BlueFinity" but
don't hold me to that. The product itself looked to have a lot of
potential. Based solely on observation, it appeared to have more
features for managing UniBasic code from within the .Net environment and
the Microsoft Visual Studio IDE than the Raining Data product had but
again, I was never successful at getting it to work.

I had much success with the Raining Data product. Good support. Easy to
use. Good tool for constructing Query's. Good tool for data provision.
Good tool for ADO.Net and data binding. There are however, some
proprietary controls that come with the product that help to seamlessly
integrate it with the .Net platform. The only issue that I can think of
where this might cause a problem is if you should change DB's and move
from an MV environment. In that case you would have to modify your code
wherever you used the proprietary controls. The support folks with
Raining Data seemed to believe that there was much more to come with
this product.

You might contact both Jbase and Raining Data to get eval copies. Hope
this all helps!!!


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Hennessey, Mark
F.
Sent: Wednesday, June 15, 2005 10:47 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] U2 and .NET

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 three choices: UniObjects for
.NET, Bluefinity's mv.NET and RainingData's data provider for .NET.  And
naturally I'm clueless about which choice would be better.

I'd be intersted in the thoughts/experiences of list members who have
used any or all of the above products.






Mark Hennessey
State of Connecticut
DSS/MIS Child Support Systems
Voice: 860-424-5261
Fax: 860-424-4956
---
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] [uv]CREATE.FILE syntax for remote directories

[Glenn Herbert]

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

[U2] U2 and .NET

[Hennessey, Mark F.]

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 three choices: UniObjects for .NET, 
Bluefinity's mv.NET and RainingData's data provider for .NET.  And naturally 
I'm clueless about which choice would be better.

I'd be intersted in the thoughts/experiences of list members who have used any 
or all of the above products.






Mark Hennessey
State of Connecticut
DSS/MIS Child Support Systems
Voice: 860-424-5261
Fax: 860-424-4956
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] [uv]CREATE.FILE syntax for remote directories

[Key Ally]

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 some association with DataStage, one may
deduce that there may have been some truth to the rumour that DataStage
now has some association with IBM.  And it looks like things have
progressed beyond the idea stage.

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

[U2] [UV] TRANS vs T-correlative: caching last record

[Stevenson, Charles]

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

Related questions:
- The caching is only 1 record & 1 file deep,
  just one single file&record combo gets cached,  right?
- Does T-correlative use the same underlying code as TRANS()?
 I would guess T-corrs resolve to TRANS() under the covers.
- Compare UD to UV: Does UD's TRANS() cache a record, too?

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

Ascential acquisition, was --> [U2] [uv]CREATE.FILE syntax for remote directories

[John_Appleyard]

>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 to becoming an
on demand business.

John Appleyard
Arthur J. Gallagher (UK) Limited




   
  "Stevenson, Charles"  
   
  <[EMAIL PROTECTED] To:  
  
  onics.com>  cc:  (bcc: John 
Appleyard/BSDUK/AJG) 
  Sent by:Subject: RE: [U2] 
[uv]CREATE.FILE syntax for remote directories  
  [EMAIL PROTECTED] 
 
  er.u2ug.org   
   

   

   
  15/06/2005 15:22  
   
  Please respond to 
   
  u2-users  
   

   

   




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 DataStage
now has some association with IBM.  And it looks like things have
progressed beyond the idea stage.

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Glenn Herbert
[EMAIL PROTECTED]
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] How to release locks (LIST.READU)

[Brian Grayson]

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 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 record simultaneously and, far worse, releasing
> group locks can cause file corruption.
>
> Whenever I come across a user who has had a backward link error, my first
> question is "do you use UNLOCK ALL". If they say yes, they are on their own!
>
> Always use the opions of UNLOCK to identify the exact lock you want to
> clear. Even then, you need to think about the application level impact of
> releasing a lock.
>
> Martin Phillips
> Ladybridge Systems
> 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB
> +44-(0)1604-709200
> ---
> 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] [uv]CREATE.FILE syntax for remote directories

[Manu Fernandes]

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
PRINT @SENTENCE

FILENAME = FIELD(TRIM(@SENTENCE),' ',2)
IF FILENAME = '' THEN GOTO SYNTAX

TYPE = FIELD(TRIM(@SENTENCE),' ',3)
IF NOT(NUM(TYPE)) OR TYPE < 2 OR  TYPE > 18 THEN TYPE = 18

MODULO   = FIELD(TRIM(@SENTENCE),' ',4)
IF NOT(NUM(MODULO)) OR MODULO <1 THEN MODULO = 53

SEPARATOR= FIELD(TRIM(@SENTENCE),' ',5)
IF NOT(NUM(SEPARATOR)) OR SEPARATOR < 1 THEN SEPARATOR = 4

OPEN 'VOC' TO F.VOC ELSE STOP 201,'VOC'
READ BUF FROM F.VOC,FILENAME THEN  STOP FILENAME:' exist in VOC ! Process 
Abort'


PATH = '' ; FILE = '';  STATUS = ''
CALL !GET.PATHNAME(FILENAME,PATH,FILE,STATUS)
IF STATUS # 0 THEN STOP "Error ON GET.PATH [":STATUS:']'

FILE = UPCASE(FILE)

OPENPATH PATH TO F.PATH ELSE STOP 201,PATH
FILENAME = PATH:'/':FILE
DICTFILENAME = PATH:'/D_':FILE
MKDBFILE = SYSTEM(32):'/bin/mkdbfile'
EXECUTE 'SH -c "':MKDBFILE:' ':FILENAME:' ':TYPE:' ':MODULO:' 
':SEPARATOR:'"'

EXECUTE 'SH -c "':MKDBFILE:' ':DICTFILENAME:' 18 37 1"'

VOCENTRY = ''
VOCENTRY<1> = 'F'
VOCENTRY<2> = FILENAME
VOCENTRY<3> = DICTFILENAME

WRITE VOCENTRY ON F.VOC,FILE
OPEN FILE TO F.FILE ELSE STOP 201,FILE
OPEN 'DICT',FILE TO FD.FILE ELSE STOP 201,'DICT ':FILE
READ ID FROM F.VOC,'@ID' THEN  WRITE ID ON FD.FILE,'@ID'
STOP

SYNTAX:
PRINT 'SYNTAX :CREATE.REMOTEFILE filename type modulo separator'
STOP
END
-boundary ---

- Original Message - 
From: "Martin Phillips" <[EMAIL PROTECTED]>

To: 
Sent: Monday, June 13, 2005 11:51 AM
Subject: Re: [U2] [uv]CREATE.FILE syntax for remote directories



Question : Is there a way to specify a full path+filename  instead a
filename in the CREATE.FILE command ?


No but the underlying operating system level program that does the
CREATE.FILE can do this.

 /usr/uv/bin/mkdbfile pathname type modulo separation
(with the appropriate path on the mkdbfile program)

It is relatively easy to wrap a bit of Basic around this and build your 
own

CREATE.PATH verb.


Martin Phillips
Ladybridge Systems
17b Coldstream Lane, Hardingstone, Northampton NN4 6DB
+44-(0)1604-709200
---
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] [AD] DesignBAIS

[Moderator]

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 development environment that uses only Basic to provide the 
business logic behind the screens - no Java, no .NET, no ASP - just Basic. Have 
a look, you'll like it.

Go to http://www.designbais.com and choose the "test drive" option on the left. 
You fill in the form, download the software, and then we send you a key, so make sure the 
email address is the correct one.

Dave Bryant
DesignBais International
[EMAIL PROTECTED]
+1 617 965 2564 (office)
+1 877 DES BAIS (337-2247)
+1 617 331 2863 (cell)
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] [uv]CREATE.FILE syntax for remote directories

[Stevenson, Charles]

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 DataStage
now has some association with IBM.  And it looks like things have
progressed beyond the idea stage.

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Glenn Herbert
[EMAIL PROTECTED]
Sent: Wednesday, June 15, 2005 6:27 AM
To: [EMAIL PROTECTED]; u2-users@listserver.u2ug.org
Subject: RE: [U2] [uv]CREATE.FILE syntax for remote directories

---
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] [uv]CREATE.FILE syntax for remote directories

[Glenn Herbert]

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

Re: [U2] How to release locks (LIST.READU)

[Martin Phillips]

> 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 record simultaneously and, far worse, releasing
group locks can cause file corruption.

Whenever I come across a user who has had a backward link error, my first
question is "do you use UNLOCK ALL". If they say yes, they are on their own!

Always use the opions of UNLOCK to identify the exact lock you want to
clear. Even then, you need to think about the application level impact of
releasing a lock.


Martin Phillips
Ladybridge Systems
17b Coldstream Lane, Hardingstone, Northampton NN4 6DB
+44-(0)1604-709200
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] How to release locks (LIST.READU)

[Nick Cipollina]

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 i.node.number]]

[GROUP group.address] [RECORD record.ID]

{FILELOCK | GROUPLOCK | READULOCK | READLLOCK | ALL}

Parameters

The following table describes each parameter of the syntax.

Parameter Description

NODE node Restricts lock removal to the specified node.

UNIX. This must be the network node number, which is

the last part of the TCP/IP host number specified in the

/etc/hosts file.

Windows NT. If valid for Windows NT, the path of the

hosts file is /Windows/System32/Drivers/etc/hosts where

Windows is the Windows NT installation directory. On

Windows NT systems, you can also use the LAN Manager

node name.

USER user.number Restricts lock removal to locks owned by the specified

user. You can get the user number from the output of

LIST.READU.

FILE pathname Restricts lock removal to a file or device specified by
the

pathname. You cannot specify DEVICE or INODE clauses

in an UNLOCK statement that uses the FILE clause.

DEVICE

device.number

Restricts lock removal to a file or a device specified by the

device number.

UNLOCK Parameters

1-604 UniVerse User Reference

/productinfo/alldoc/UNIVERSE10/userref/Ch1

1/8/02

Specify the lock type as one of the following:

Description

You can specify ID numbers (that is, the node number, device number, or

record ID) in either decimal or hexadecimal format. Precede the number
with

0x to specify it as hexadecimal.

INODE i.node.number Restricts lock removal to a file or a device
specified by the

i-node number.

GROUP group.address Restricts lock removal to the group specified by

group.address. The group address appears in hexadecimal

format on the LIST.READU report.

RECORD record.ID Restricts lock removal to the record specified by the

record ID.

Lock Type Description

FILELOCK Removes only file locks.

GROUPLOCK Removes only group locks and update record locks

associated with the group.

READULOCK Removes only update record locks.

READLLOCK Removes only shared record locks.

ALL Removes all locks.

UNLOCK Lock Types

Parameter Description

UNLOCK Parameters (Continued)



Thanks,



Nick Cipollina



-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Anthony
Dzikiewicz
Sent: Wednesday, June 15, 2005 7:01 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] How to release locks (LIST.READU)



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 MASTER OFF the user.  This is not always
the

best thing.  You could walk over to their terminal and back them out of
what

they are doing.  You could also make use of TANDEM to take control of
the

terminal and do the same thing (if you dont like walking).



If it is a deadlock, shown by LIST.READU EVERY, I always use the admin
menu,

deadlock administration to take care of it.



Anthony



-Original Message-

From: [EMAIL PROTECTED]

[mailto:[EMAIL PROTECTED] On Behalf Of Pankaj Gupta04

Sent: Wednesday, June 15, 2005 5:21 AM

To: u2-users@listserver.u2ug.org

Subject: [U2] How to release locks (LIST.READU)





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 which are displayed in LIST.READU output?



Thanks in advance.



Regards,



Pankaj Gupta



*** CAUTION - Disclaimer ** This e-mail

contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the
use

of the addressee(s). If you are not the intended recipient, please
notify

the sender by e-mail and delete the original message. Further, you are
not

to copy, disclose, or distribute this e-mail or its contents to any
other

person and any such actions are unlawful. This e-mail may contain
viruses.

Infosys has taken every reasonable precaution to minimize this risk, but
is

not liable for any damage you may sustain as a result of any virus in
this

e-mail. You should carry out your own virus checks before opening the
e-mail

or attachment. Infosys reserves the right to monitor and review the
content

of all messages sent to or from this e-mail address. Messages sent to or

from this e-mail address may be stored on the Infosys e-mail system.

***INFOSYS End of Disclaimer INFOSYS***

---

u2-users mailing list

u2-users@listserver.u2ug.org

To unsubs

Re: [U2] How to release locks (LIST.READU)

[Lembit Pirn]

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

RE: [U2] How to release locks (LIST.READU)

[Sunny Matharoo]

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 release a lock you can use UniAdmin or from the UV account but
you will need 'root' permissions to unlock the user, use UNLOCK command
to release the locks.
Type at TCL if in the UV account 'UNLOCK RECORD record.id ALL' this will
release the locks held by that record, but note it will also release
other locks like the semaphore and groups locks as well.

Hope this helps

R,

Sunny

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Pankaj Gupta04
Sent: 15 June 2005 10:21
To: u2-users@listserver.u2ug.org
Subject: [U2] How to release locks (LIST.READU)

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 which are displayed in LIST.READU
output?

Thanks in advance.

Regards,

Pankaj Gupta

*** CAUTION - Disclaimer ** This e-mail
contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the
use of the addressee(s). If you are not the intended recipient, please
notify the sender by e-mail and delete the original message. Further,
you are not to copy, disclose, or distribute this e-mail or its contents
to any other person and any such actions are unlawful. This e-mail may
contain viruses. Infosys has taken every reasonable precaution to
minimize this risk, but is not liable for any damage you may sustain as
a result of any virus in this e-mail. You should carry out your own
virus checks before opening the e-mail or attachment. Infosys reserves
the right to monitor and review the content of all messages sent to or
from this e-mail address. Messages sent to or from this e-mail address
may be stored on the Infosys e-mail system.
***INFOSYS End of Disclaimer INFOSYS***
---
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] How to release locks (LIST.READU)

[Brian Leach]

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 locks,e.g.

UNLOCK USER usernumber ALL

Brian
 

> -Original Message-
> From: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED] On Behalf Of 
> Pankaj Gupta04
> Sent: 15 June 2005 10:21
> To: u2-users@listserver.u2ug.org
> Subject: [U2] How to release locks (LIST.READU)
> 
> 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 which are 
> displayed in LIST.READU output?
> 
> Thanks in advance.
> 
> Regards,
> 
> Pankaj Gupta
> 
> *** CAUTION - Disclaimer ** 
> This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION 
> intended solely for the use of the addressee(s). If you are 
> not the intended recipient, please notify the sender by 
> e-mail and delete the original message. Further, you are not 
> to copy, disclose, or distribute this e-mail or its contents 
> to any other person and any such actions are unlawful. This 
> e-mail may contain viruses. Infosys has taken every 
> reasonable precaution to minimize this risk, but is not 
> liable for any damage you may sustain as a result of any 
> virus in this e-mail. You should carry out your own virus 
> checks before opening the e-mail or attachment. Infosys 
> reserves the right to monitor and review the content of all 
> messages sent to or from this e-mail address. Messages sent 
> to or from this e-mail address may be stored on the Infosys 
> e-mail system.
> ***INFOSYS End of Disclaimer INFOSYS***
> ---
> 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] How to release locks (LIST.READU)

[Brian Grayson]

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,
> 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 which are displayed in LIST.READU
> output?
>
> Thanks in advance.
>
> Regards,
>
> Pankaj Gupta
>
> *** CAUTION - Disclaimer ** This e-mail 
> contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use 
> of the addressee(s). If you are not the intended recipient, please notify the 
> sender by e-mail and delete the original message. Further, you are not to 
> copy, disclose, or distribute this e-mail or its contents to any other person 
> and any such actions are unlawful. This e-mail may contain viruses. Infosys 
> has taken every reasonable precaution to minimize this risk, but is not 
> liable for any damage you may sustain as a result of any virus in this 
> e-mail. You should carry out your own virus checks before opening the e-mail 
> or attachment. Infosys reserves the right to monitor and review the content 
> of all messages sent to or from this e-mail address. Messages sent to or from 
> this e-mail address may be stored on the Infosys e-mail system.
> ***INFOSYS End of Disclaimer INFOSYS***
> ---
> 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] How to release locks (LIST.READU)

[Les Hewkin]

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 to problems later on.

Les

-Original Message-
From: Anthony Dzikiewicz [mailto:[EMAIL PROTECTED]
Sent: 15 June 2005 12:01
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] How to release locks (LIST.READU)


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 MASTER OFF the user.  This is not always the
best thing.  You could walk over to their terminal and back them out of what
they are doing.  You could also make use of TANDEM to take control of the
terminal and do the same thing (if you dont like walking).

If it is a deadlock, shown by LIST.READU EVERY, I always use the admin menu,
deadlock administration to take care of it.

Anthony

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Pankaj Gupta04
Sent: Wednesday, June 15, 2005 5:21 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] How to release locks (LIST.READU)


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 which are displayed in LIST.READU output?

Thanks in advance.

Regards,

Pankaj Gupta

*** CAUTION - Disclaimer ** This e-mail
contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use
of the addressee(s). If you are not the intended recipient, please notify
the sender by e-mail and delete the original message. Further, you are not
to copy, disclose, or distribute this e-mail or its contents to any other
person and any such actions are unlawful. This e-mail may contain viruses.
Infosys has taken every reasonable precaution to minimize this risk, but is
not liable for any damage you may sustain as a result of any virus in this
e-mail. You should carry out your own virus checks before opening the e-mail
or attachment. Infosys reserves the right to monitor and review the content
of all messages sent to or from this e-mail address. Messages sent to or
from this e-mail address may be stored on the Infosys e-mail system.
***INFOSYS End of Disclaimer INFOSYS***
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

-- 
Internal Virus Database is out-of-date.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.6.6 - Release Date: 6/8/2005
 

-- 
Internal Virus Database is out-of-date.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.6.6 - Release Date: 6/8/2005
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

This message has been comprehensively scanned for viruses,
please visit http://virus.e2e-filter.com/ for details.

This e-mail and any attachments are confidential and intended solely for the 
use of the addressee only. If you have received this message in error, you must 
not copy, distribute or disclose the contents; please notify the sender 
immediately and delete the message.
This message is attributed to the sender and may not necessarily reflect the 
view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements 
binding Travis Perkins may not be concluded by means of e-mail communication.
E-mail transmissions are not secure and Travis Perkins accepts no 
responsibility for changes made to this message after it was sent. Whilst steps 
have been taken to ensure that this message is virus free, Travis Perkins 
accepts no liability for infection and recommends that you scan this e-mail and 
any attachments.
Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, 
Harlestone Road, Northampton, NN5 7UG.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] How to release locks (LIST.READU)

[Anthony Dzikiewicz]

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 MASTER OFF the user.  This is not always the
best thing.  You could walk over to their terminal and back them out of what
they are doing.  You could also make use of TANDEM to take control of the
terminal and do the same thing (if you dont like walking).

If it is a deadlock, shown by LIST.READU EVERY, I always use the admin menu,
deadlock administration to take care of it.

Anthony

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Pankaj Gupta04
Sent: Wednesday, June 15, 2005 5:21 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] How to release locks (LIST.READU)


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 which are displayed in LIST.READU output?

Thanks in advance.

Regards,

Pankaj Gupta

*** CAUTION - Disclaimer ** This e-mail
contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use
of the addressee(s). If you are not the intended recipient, please notify
the sender by e-mail and delete the original message. Further, you are not
to copy, disclose, or distribute this e-mail or its contents to any other
person and any such actions are unlawful. This e-mail may contain viruses.
Infosys has taken every reasonable precaution to minimize this risk, but is
not liable for any damage you may sustain as a result of any virus in this
e-mail. You should carry out your own virus checks before opening the e-mail
or attachment. Infosys reserves the right to monitor and review the content
of all messages sent to or from this e-mail address. Messages sent to or
from this e-mail address may be stored on the Infosys e-mail system.
***INFOSYS End of Disclaimer INFOSYS***
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

-- 
Internal Virus Database is out-of-date.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.6.6 - Release Date: 6/8/2005
 

-- 
Internal Virus Database is out-of-date.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.6.6 - Release Date: 6/8/2005
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[U2] How to release locks (LIST.READU)

[Pankaj Gupta04]

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 which are displayed in LIST.READU
output?

Thanks in advance.

Regards,

Pankaj Gupta

*** CAUTION - Disclaimer ** This e-mail 
contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of 
the addressee(s). If you are not the intended recipient, please notify the 
sender by e-mail and delete the original message. Further, you are not to copy, 
disclose, or distribute this e-mail or its contents to any other person and any 
such actions are unlawful. This e-mail may contain viruses. Infosys has taken 
every reasonable precaution to minimize this risk, but is not liable for any 
damage you may sustain as a result of any virus in this e-mail. You should 
carry out your own virus checks before opening the e-mail or attachment. 
Infosys reserves the right to monitor and review the content of all messages 
sent to or from this e-mail address. Messages sent to or from this e-mail 
address may be stored on the Infosys e-mail system.
***INFOSYS End of Disclaimer INFOSYS***
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/