Re: [U2] READU vs READ
Have you been able to do any os level tools to see what the utilisation of resources is. E.g. on linux, vmstat, top, iostat will show you if it is a diskio or cpu bottleneck. If it is diskio (i.e. high wait on io times) then you may need to upgrade the disks or add more ram so you have more data in cache. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Laansma Sent: 01 May 2012 02:58 To: U2 Users List Subject: Re: [U2] READU vs READ Oh ... you're good ... I ALMOST pasted it ... I know better that to put even FICTITIOUS code on this board ... unless I'm just trying to rile things up about the OS. |-) I do appreciate all of the input. Thank y'all for the info. I'll see what I can do. Sincerely, David Laansma IT Manager Hubbard Supply Co. Direct: 810-342-7143 Office: 810-234-8681 Fax: 810-234-6142 www.hubbardsupply.com Delivering Products, Services and Innovative Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Monday, April 30, 2012 9:47 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] READU vs READ why not post the relevant code you are using to do the field updates perhaps we can see some inefficiency in the way you're grabbing and updating fields you said the records were sizeable and that raises my eyebrow (just one) -Original Message- From: Dave Laansma dlaan...@hubbardsupply.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Mon, Apr 30, 2012 6:38 pm Subject: Re: [U2] READU vs READ No indexes and no triggers. Sincerely, David Laansma IT Manager Hubbard Supply Co. Direct: 810-342-7143 Office: 810-234-8681 Fax: 810-234-6142 www.hubbardsupply.com Delivering Products, Services and Innovative Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Gregor Scott Sent: Monday, April 30, 2012 9:22 PM To: U2 Users List Subject: Re: [U2] READU vs READ Add to the mix indexes and triggers. They can both add to the time needed to update just one record. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Buss, Troy (Contractor, Logitek Systems) Sent: Tuesday, 1 May 2012 11:12 AM To: U2 Users List Subject: Re: [U2] READU vs READ Inefficient file sizing and disk I/O are your possible issues with slowness. You might be able to address the first at your desk, the latter may require a purchase order. How old is your hardware? We recently upgraded to a virtual server and just using more current technology hard drives we doubled all of our disk I/O from what we had 5 or 6 years ago. CPU speed increased as well, but that was not as suprising. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Laansma Sent: Monday, April 30, 2012 6:01 PM To: U2 Users List Subject: Re: [U2] READU vs READ Yes, using SELECT and READNEXT. These are sizable records. The logic is very straight forward, just updating several multi-valued fields in each record (month end). 500,000 have been updated and I'm 2:45:00 into the process. _ Scanned by IBM Email Security Management Services powered by MessageLabs. For more information please visit http://www.ers.ibm.com This email is intended only for the use of the party to which it is addressed and may contain information that is privileged, confidential, or protected by law. If you are not the intended recipient you are hereby notified that any dissemination, copying or distribution of the email or its contents is strictly prohibited. If you have received this message in error, please notify us immediately, by replying to the message and deleting it from your computer. WARNING: Internet communications are not assured to be secure or clear of inaccuracies as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. Therefore, we do not accept responsibility for any errors or omissions that are present in this email, or any attachment, that have arisen as a result of e-mail transmission. _ ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Message protected by DealerGuard: e-mail anti-virus, anti-spam and content filtering. http://www.pentanasolutions.com Click here to report this message as spam: https://login.mailguard.com.au/report/1EE0zigg55/70gcZxRJUITQXy3UHcVFYT/ 0.002 This email and any attachments to it are confidential. You must not use, disclose or act on the email if you are not the intended
Re: [U2] READU vs READ
Hi, The question of READU vs READ when you are doing updates is moot. If you do a READ then a WRITE, UniVerse/UniData will perform the record lock. The only difference is with READ you are gambling that no one else is updating the record before you perform your WRITE. Performance, as others suggested, there are several things to do: Tune your files. If you are using dynamic files, make sure you have the MINIMUM.MODULUS set to reduce the shrink and merging If the records are lumpy redesign them so you have a header file and a detail file, with detail files being individual records for the associated values. Use LIST.INDEX with the STATISTICS option to see if you have huge index value, you may need to refine the index. Check your hardware, you may have a bottleneck due to slow disk, I/O pipe. Minimize the number of times you go through the associated values. Use READU with the LOCKED clause, if the record is locked, add logic to queue it up and try the records again once everything else is processed (WRITEs will hang on a lock if you don't have the LOCKED clause, just like a READU without the LOCKED clause. Good luck! Tom RATEX Business Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Tuesday, May 01, 2012 4:44 AM To: 'U2 Users List' Subject: Re: [U2] READU vs READ Have you been able to do any os level tools to see what the utilisation of resources is. E.g. on linux, vmstat, top, iostat will show you if it is a diskio or cpu bottleneck. If it is diskio (i.e. high wait on io times) then you may need to upgrade the disks or add more ram so you have more data in cache. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Laansma Sent: 01 May 2012 02:58 To: U2 Users List Subject: Re: [U2] READU vs READ Oh ... you're good ... I ALMOST pasted it ... I know better that to put even FICTITIOUS code on this board ... unless I'm just trying to rile things up about the OS. |-) I do appreciate all of the input. Thank y'all for the info. I'll see what I can do. Sincerely, David Laansma IT Manager Hubbard Supply Co. Direct: 810-342-7143 Office: 810-234-8681 Fax: 810-234-6142 www.hubbardsupply.com Delivering Products, Services and Innovative Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Monday, April 30, 2012 9:47 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] READU vs READ why not post the relevant code you are using to do the field updates perhaps we can see some inefficiency in the way you're grabbing and updating fields you said the records were sizeable and that raises my eyebrow (just one) -Original Message- From: Dave Laansma dlaan...@hubbardsupply.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Mon, Apr 30, 2012 6:38 pm Subject: Re: [U2] READU vs READ No indexes and no triggers. Sincerely, David Laansma IT Manager Hubbard Supply Co. Direct: 810-342-7143 Office: 810-234-8681 Fax: 810-234-6142 www.hubbardsupply.com Delivering Products, Services and Innovative Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Gregor Scott Sent: Monday, April 30, 2012 9:22 PM To: U2 Users List Subject: Re: [U2] READU vs READ Add to the mix indexes and triggers. They can both add to the time needed to update just one record. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Buss, Troy (Contractor, Logitek Systems) Sent: Tuesday, 1 May 2012 11:12 AM To: U2 Users List Subject: Re: [U2] READU vs READ Inefficient file sizing and disk I/O are your possible issues with slowness. You might be able to address the first at your desk, the latter may require a purchase order. How old is your hardware? We recently upgraded to a virtual server and just using more current technology hard drives we doubled all of our disk I/O from what we had 5 or 6 years ago. CPU speed increased as well, but that was not as suprising. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Laansma Sent: Monday, April 30, 2012 6:01 PM To: U2 Users List Subject: Re: [U2] READU vs READ Yes, using SELECT and READNEXT. These are sizable records. The logic is very straight forward, just updating several multi-valued fields in each record (month end). 500,000 have been updated and I'm 2:45:00 into the process. _ Scanned by IBM Email Security Management Services powered by MessageLabs. For more information please visit
Re: [U2] User ID of a LOCKED record
Thanks for all of the responses! It looks like LIST.READU -INTERNAL will do it. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Buss, Troy (Contractor, Logitek Systems) Sent: Monday, April 30, 2012 7:05 PM To: U2 Users List Subject: Re: [U2] User ID of a LOCKED record Also, on UV 11.1.1 the user name portion is broken. We had to work around it (by reading our own PID to USER table), but I understand a subsequent release addressed the issue. LIST.READU -INTERNAL Broken output: 11009371^677913942^0^2000^1^RU^ ^ ^333719*1^ 1606438775^34480532^0^5224^15^RU^ ^ ^270784^ 1718299426^1218558262^0^3692^15^RU^ ^ ^30742^ Original output: 814621824^1688564731^0^6896^82^RU^6896^DOMAIN\Joe.User^ZLIST.READUEX^ What they meant to say is that the USERNAME is not reported. Pid is there on 11.1.1. - - - - - - - - - - - - Problems Fixed in UniVerse Release 11.1.5 (Build 5757) UNV-5010UniVerse -- Beginning at UniVerse 11.1.1, the pid number of the UniVerse process holding a lock was no longer displayed in the LIST.READU output. This problem as been fixed. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Monday, April 30, 2012 4:28 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] User ID of a LOCKED record LIST.READU -INTERNAL you don't need the EVERY to see record locks but how wild that -INTERNAL gives you the USER NAME ! And the regular LIST.READU does not (even though the documentation says it will) _ Scanned by IBM Email Security Management Services powered by MessageLabs. For more information please visit http://www.ers.ibm.com This email is intended only for the use of the party to which it is addressed and may contain information that is privileged, confidential, or protected by law. If you are not the intended recipient you are hereby notified that any dissemination, copying or distribution of the email or its contents is strictly prohibited. If you have received this message in error, please notify us immediately, by replying to the message and deleting it from your computer. WARNING: Internet communications are not assured to be secure or clear of inaccuracies as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. Therefore, we do not accept responsibility for any errors or omissions that are present in this email, or any attachment, that have arisen as a result of e-mail transmission. _ ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] User ID of a LOCKED record
In Unidata you could use the LOCKED clause followed by GETUSERNAME(STATUS()). Richard Sammartino - Original Message - From: Andy Krause akra...@rammutual.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Tuesday, May 1, 2012 8:55:03 AM Subject: Re: [U2] User ID of a LOCKED record Thanks for all of the responses! It looks like LIST.READU -INTERNAL will do it. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Buss, Troy (Contractor, Logitek Systems) Sent: Monday, April 30, 2012 7:05 PM To: U2 Users List Subject: Re: [U2] User ID of a LOCKED record Also, on UV 11.1.1 the user name portion is broken. We had to work around it (by reading our own PID to USER table), but I understand a subsequent release addressed the issue. LIST.READU -INTERNAL Broken output: 11009371^677913942^0^2000^1^RU^ ^ ^333719*1^ 1606438775^34480532^0^5224^15^RU^ ^ ^270784^ 1718299426^1218558262^0^3692^15^RU^ ^ ^30742^ Original output: 814621824^1688564731^0^6896^82^RU^6896^DOMAIN\Joe.User^ZLIST.READUEX^ What they meant to say is that the USERNAME is not reported. Pid is there on 11.1.1. - - - - - - - - - - - - Problems Fixed in UniVerse Release 11.1.5 (Build 5757) UNV-5010UniVerse -- Beginning at UniVerse 11.1.1, the pid number of the UniVerse process holding a lock was no longer displayed in the LIST.READU output. This problem as been fixed. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Monday, April 30, 2012 4:28 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] User ID of a LOCKED record LIST.READU -INTERNAL you don't need the EVERY to see record locks but how wild that -INTERNAL gives you the USER NAME ! And the regular LIST.READU does not (even though the documentation says it will) _ Scanned by IBM Email Security Management Services powered by MessageLabs. For more information please visit http://www.ers.ibm.com This email is intended only for the use of the party to which it is addressed and may contain information that is privileged, confidential, or protected by law. If you are not the intended recipient you are hereby notified that any dissemination, copying or distribution of the email or its contents is strictly prohibited. If you have received this message in error, please notify us immediately, by replying to the message and deleting it from your computer. WARNING: Internet communications are not assured to be secure or clear of inaccuracies as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. Therefore, we do not accept responsibility for any errors or omissions that are present in this email, or any attachment, that have arisen as a result of e-mail transmission. _ ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] User ID of a LOCKED record
It does on my system - uv 10.2.7 LIST.READU Active Record Locks: Device Inode Netnode Userno LmodePid Login Id Item-ID . 6553741067810 15 29 RU 499890 dianne TEST On 4/30/2012 7:28 PM, Wjhonson wrote: LIST.READU -INTERNAL you don't need the EVERY to see record locks but how wild that -INTERNAL gives you the USER NAME ! And the regular LIST.READU does not (even though the documentation says it will) -Original Message- From: Buss, Troy (Contractor, Logitek Systems) (Contractor, Logitek Systems)troy.b...@nordsonasymtek.com To: U2 Users Listu2-users@listserver.u2ug.org Sent: Mon, Apr 30, 2012 4:23 pm Subject: Re: [U2] User ID of a LOCKED record On Universe: LIST.READU -EVERY - INTERNAL Gives details without truncation for capturing in basic. _ canned by IBM Email Security Management Services powered by MessageLabs. For ore information please visit http://www.ers.ibm.com This email is intended only for the use of the party to which it is addressed nd may contain information that is privileged, confidential, or protected by aw. If you are not the intended recipient you are hereby notified that any issemination, copying or distribution of the email or its contents is strictly rohibited. If you have received this message in error, please notify us mmediately, by replying to the message and deleting it from your computer. WARNING: Internet communications are not assured to be secure or clear of naccuracies as information could be intercepted, corrupted, lost, destroyed, rrive late or incomplete, or contain viruses. Therefore, we do not accept esponsibility for any errors or omissions that are present in this email, or ny attachment, that have arisen as a result of e-mail transmission. __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] READU vs READ
Dave; A couple more things: - do you have any other processes running at the same time? I found (long ago) that a couple of our big processes ran 5X faster consecutively than they did concurrently. - subroutine calls with file opens. I inherited a process that was running for 3 days and was 65% done. I put all of the file opens in common (well, the file variables) and re-ran in hours. You may want to re-think posting some of the code. There can be some efficiencies found in processing large dynamic arrays. You said it wasn't code you wrote - so try to take the criticism as constructive :) hth Colin -Original Message- From: Tom Whitmore Sent: May 1, 2012 5:50 AM To: U2 Users List Subject: Re: [U2] READU vs READ Hi, The question of READU vs READ when you are doing updates is moot. If you do a READ then a WRITE, UniVerse/UniData will perform the record lock. The only difference is with READ you are gambling that no one else is updating the record before you perform your WRITE. Performance, as others suggested, there are several things to do: Tune your files. If you are using dynamic files, make sure you have the MINIMUM.MODULUS set to reduce the shrink and merging If the records are lumpy redesign them so you have a header file and a detail file, with detail files being individual records for the associated values. Use LIST.INDEX with the STATISTICS option to see if you have huge index value, you may need to refine the index. Check your hardware, you may have a bottleneck due to slow disk, I/O pipe. Minimize the number of times you go through the associated values. Use READU with the LOCKED clause, if the record is locked, add logic to queue it up and try the records again once everything else is processed (WRITEs will hang on a lock if you don't have the LOCKED clause, just like a READU without the LOCKED clause. Good luck! Tom RATEX Business Solutions -Original Message- From: Symeon Breen Have you been able to do any os level tools to see what the utilisation of resources is. E.g. on linux, vmstat, top, iostat will show you if it is a diskio or cpu bottleneck. If it is diskio (i.e. high wait on io times) then you may need to upgrade the disks or add more ram so you have more data in cache. -Original Message- From: Dave Laansma Oh ... you're good ... I ALMOST pasted it ... I know better that to put even FICTITIOUS code on this board ... unless I'm just trying to rile things up about the OS. |-) I do appreciate all of the input. Thank y'all for the info. I'll see what I can do. Sincerely, David Laansma ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] READU vs READ
Thank you Colin. I wouldn't post these types of 'issues' if I were thin-skinned and didn't appreciate input. There are certainly some efficiencies in the updating of the multi-values. Unfortunately I cannot reorganize the data in the records, only the code that updates said data. I'll consider posting it. Names will have to be changed to protect 'the innocent' copyright. Sincerely, David Laansma IT Manager Hubbard Supply Co. Direct: 810-342-7143 Office: 810-234-8681 Fax: 810-234-6142 www.hubbardsupply.com Delivering Products, Services and Innovative Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Colin Alfke Sent: Tuesday, May 01, 2012 10:05 AM To: 'U2 Users List' Subject: Re: [U2] READU vs READ Dave; A couple more things: - do you have any other processes running at the same time? I found (long ago) that a couple of our big processes ran 5X faster consecutively than they did concurrently. - subroutine calls with file opens. I inherited a process that was running for 3 days and was 65% done. I put all of the file opens in common (well, the file variables) and re-ran in hours. You may want to re-think posting some of the code. There can be some efficiencies found in processing large dynamic arrays. You said it wasn't code you wrote - so try to take the criticism as constructive :) hth Colin -Original Message- From: Tom Whitmore Sent: May 1, 2012 5:50 AM To: U2 Users List Subject: Re: [U2] READU vs READ Hi, The question of READU vs READ when you are doing updates is moot. If you do a READ then a WRITE, UniVerse/UniData will perform the record lock. The only difference is with READ you are gambling that no one else is updating the record before you perform your WRITE. Performance, as others suggested, there are several things to do: Tune your files. If you are using dynamic files, make sure you have the MINIMUM.MODULUS set to reduce the shrink and merging If the records are lumpy redesign them so you have a header file and a detail file, with detail files being individual records for the associated values. Use LIST.INDEX with the STATISTICS option to see if you have huge index value, you may need to refine the index. Check your hardware, you may have a bottleneck due to slow disk, I/O pipe. Minimize the number of times you go through the associated values. Use READU with the LOCKED clause, if the record is locked, add logic to queue it up and try the records again once everything else is processed (WRITEs will hang on a lock if you don't have the LOCKED clause, just like a READU without the LOCKED clause. Good luck! Tom RATEX Business Solutions -Original Message- From: Symeon Breen Have you been able to do any os level tools to see what the utilisation of resources is. E.g. on linux, vmstat, top, iostat will show you if it is a diskio or cpu bottleneck. If it is diskio (i.e. high wait on io times) then you may need to upgrade the disks or add more ram so you have more data in cache. -Original Message- From: Dave Laansma Oh ... you're good ... I ALMOST pasted it ... I know better that to put even FICTITIOUS code on this board ... unless I'm just trying to rile things up about the OS. |-) I do appreciate all of the input. Thank y'all for the info. I'll see what I can do. Sincerely, David Laansma ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] User ID of a LOCKED record
Universe 10.2.3 LIST.READU Active Record Locks: Device Inode. Netnode Userno LmodePid Item-ID ... 566926395 1210555995 0 27368 RU 2736 16193-12-25 291123247 403366260 0 5436 30 RU 5436 181424343 252535158 1093183945 0 5436 39 RU 5436 181424343 1119682271 15147876 0 2804 42 RU 2804 44050 1998816505 1380435731 0 2804 45 RU 2804 44050 759630365 344848829 0 6008 58 RU 6008 B18561 290469198 999414438 0 6008 64 RU 6008 B18561 1016887084 1213711733 0 4144 67 RU 4144 C8671402037 759630365 344848829 0 7644 69 RU 7644 863535 290469198 999414438 0 7644 75 RU 7644 863535 1469823969 1880557134 0 5660 95 RU 5660 RETRO.PAYROLL -Original Message- From: Dianne Ackerman dia...@aptron.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Tue, May 1, 2012 6:23 am Subject: Re: [U2] User ID of a LOCKED record It does on my system - uv 10.2.7 LIST.READU Active Record Locks: evice Inode Netnode Userno LmodePid Login Id tem-ID 6553741067810 15 29 RU 499890 dianne TEST On 4/30/2012 7:28 PM, Wjhonson wrote: LIST.READU -INTERNAL you don't need the EVERY to see record locks but how wild that -INTERNAL gives you the USER NAME ! And the regular LIST.READU does not (even though the documentation says it ill) -Original Message- From: Buss, Troy (Contractor, Logitek Systems) (Contractor, Logitek ystems)troy.b...@nordsonasymtek.com To: U2 Users Listu2-users@listserver.u2ug.org Sent: Mon, Apr 30, 2012 4:23 pm Subject: Re: [U2] User ID of a LOCKED record On Universe: LIST.READU -EVERY - INTERNAL Gives details without truncation for capturing in basic. _ canned by IBM Email Security Management Services powered by MessageLabs. For ore information please visit http://www.ers.ibm.com This email is intended only for the use of the party to which it is addressed nd may contain information that is privileged, confidential, or protected by aw. If you are not the intended recipient you are hereby notified that any issemination, copying or distribution of the email or its contents is strictly rohibited. If you have received this message in error, please notify us mmediately, by replying to the message and deleting it from your computer. WARNING: Internet communications are not assured to be secure or clear of naccuracies as information could be intercepted, corrupted, lost, destroyed, rrive late or incomplete, or contain viruses. Therefore, we do not accept esponsibility for any errors or omissions that are present in this email, or ny attachment, that have arisen as a result of e-mail transmission. __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ ___ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] User ID of a LOCKED record
I think the difference is probably not the release version number, but rather the operating system. This is Universe on WINDOWS, you are probably on Unix. -Original Message- From: Wjhonson wjhon...@aol.com To: u2-users u2-users@listserver.u2ug.org Sent: Tue, May 1, 2012 10:06 am Subject: Re: [U2] User ID of a LOCKED record niverse 10.2.3 LIST.READU ctive Record Locks: evice Inode. Netnode Userno LmodePid Item-ID .. 566926395 1210555995 0 27368 RU 2736 16193-12-25 291123247 403366260 0 5436 30 RU 5436 181424343 252535158 1093183945 0 5436 39 RU 5436 181424343 119682271 15147876 0 2804 42 RU 2804 44050 998816505 1380435731 0 2804 45 RU 2804 44050 759630365 344848829 0 6008 58 RU 6008 B18561 290469198 999414438 0 6008 64 RU 6008 B18561 016887084 1213711733 0 4144 67 RU 4144 C8671402037 759630365 344848829 0 7644 69 RU 7644 863535 290469198 999414438 0 7644 75 RU 7644 863535 469823969 1880557134 0 5660 95 RU 5660 RETRO.PAYROLL Original Message- rom: Dianne Ackerman dia...@aptron.com o: U2 Users List u2-users@listserver.u2ug.org ent: Tue, May 1, 2012 6:23 am ubject: Re: [U2] User ID of a LOCKED record t does on my system - uv 10.2.7 LIST.READU ctive Record Locks: vice Inode Netnode Userno LmodePid Login Id em-ID ... 6553741067810 15 29 RU 499890 dianne TEST On 4/30/2012 7:28 PM, Wjhonson wrote: LIST.READU -INTERNAL you don't need the EVERY to see record locks but how wild that -INTERNAL gives you the USER NAME ! And the regular LIST.READU does not (even though the documentation says it ll) -Original Message- From: Buss, Troy (Contractor, Logitek Systems) (Contractor, Logitek stems)troy.b...@nordsonasymtek.com To: U2 Users Listu2-users@listserver.u2ug.org Sent: Mon, Apr 30, 2012 4:23 pm Subject: Re: [U2] User ID of a LOCKED record On Universe: LIST.READU -EVERY - INTERNAL Gives details without truncation for capturing in basic. _ canned by IBM Email Security Management Services powered by MessageLabs. For ore information please visit http://www.ers.ibm.com This email is intended only for the use of the party to which it is addressed nd may contain information that is privileged, confidential, or protected by aw. If you are not the intended recipient you are hereby notified that any issemination, copying or distribution of the email or its contents is strictly rohibited. If you have received this message in error, please notify us mmediately, by replying to the message and deleting it from your computer. WARNING: Internet communications are not assured to be secure or clear of naccuracies as information could be intercepted, corrupted, lost, destroyed, rrive late or incomplete, or contain viruses. Therefore, we do not accept esponsibility for any errors or omissions that are present in this email, or ny attachment, that have arisen as a result of e-mail transmission. __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ __ -Users mailing list -us...@listserver.u2ug.org tp://listserver.u2ug.org/mailman/listinfo/u2-users ___ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] User ID of a LOCKED record
Yes, this is on unix. On 5/1/2012 1:08 PM, Wjhonson wrote: I think the difference is probably not the release version number, but rather the operating system. This is Universe on WINDOWS, you are probably on Unix. -Original Message- From: Wjhonsonwjhon...@aol.com To: u2-usersu2-users@listserver.u2ug.org Sent: Tue, May 1, 2012 10:06 am Subject: Re: [U2] User ID of a LOCKED record niverse 10.2.3 LIST.READU ctive Record Locks: evice Inode. Netnode Userno LmodePid Item-ID .. 566926395 1210555995 0 27368 RU 2736 16193-12-25 291123247 403366260 0 5436 30 RU 5436 181424343 252535158 1093183945 0 5436 39 RU 5436 181424343 119682271 15147876 0 2804 42 RU 2804 44050 998816505 1380435731 0 2804 45 RU 2804 44050 759630365 344848829 0 6008 58 RU 6008 B18561 290469198 999414438 0 6008 64 RU 6008 B18561 016887084 1213711733 0 4144 67 RU 4144 C8671402037 759630365 344848829 0 7644 69 RU 7644 863535 290469198 999414438 0 7644 75 RU 7644 863535 469823969 1880557134 0 5660 95 RU 5660 RETRO.PAYROLL Original Message- rom: Dianne Ackermandia...@aptron.com o: U2 Users Listu2-users@listserver.u2ug.org ent: Tue, May 1, 2012 6:23 am ubject: Re: [U2] User ID of a LOCKED record t does on my system - uv 10.2.7 LIST.READU ctive Record Locks: vice Inode Netnode Userno LmodePid Login Id em-ID ... 6553741067810 15 29 RU 499890 dianne TEST On 4/30/2012 7:28 PM, Wjhonson wrote: LIST.READU -INTERNAL you don't need the EVERY to see record locks but how wild that -INTERNAL gives you the USER NAME ! And the regular LIST.READU does not (even though the documentation says it ll) -Original Message- From: Buss, Troy (Contractor, Logitek Systems) (Contractor, Logitek stems)troy.b...@nordsonasymtek.com To: U2 Users Listu2-users@listserver.u2ug.org Sent: Mon, Apr 30, 2012 4:23 pm Subject: Re: [U2] User ID of a LOCKED record On Universe: LIST.READU -EVERY - INTERNAL Gives details without truncation for capturing in basic. _ canned by IBM Email Security Management Services powered by MessageLabs. For ore information please visit http://www.ers.ibm.com This email is intended only for the use of the party to which it is addressed nd may contain information that is privileged, confidential, or protected by aw. If you are not the intended recipient you are hereby notified that any issemination, copying or distribution of the email or its contents is strictly rohibited. If you have received this message in error, please notify us mmediately, by replying to the message and deleting it from your computer. WARNING: Internet communications are not assured to be secure or clear of naccuracies as information could be intercepted, corrupted, lost, destroyed, rrive late or incomplete, or contain viruses. Therefore, we do not accept esponsibility for any errors or omissions that are present in this email, or ny attachment, that have arisen as a result of e-mail transmission. __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ __ -Users mailing list -us...@listserver.u2ug.org tp://listserver.u2ug.org/mailman/listinfo/u2-users ___ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Dianne Ackerman Director, Application Development Support Aptron Corporation www.aptron.com P: 973/822-0700, ext. 105 F: 973/822-3234 dia...@aptron.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] User ID of a LOCKED record
I didn't read over Troy's comments earlier, but he's right. The user name portion of the LIST.READU -INTERNAL does not work. In my case when I run it the result shows me holding every single lock. I ended up using LISTME rather than LIST.READU -INTERNAL to pull the username. We are currently on Universe 10.2.10 so this will have to be good enough until we upgrade to 11.1.5. Thanks again. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Buss, Troy (Contractor, Logitek Systems) Sent: Monday, April 30, 2012 7:05 PM To: U2 Users List Subject: Re: [U2] User ID of a LOCKED record Also, on UV 11.1.1 the user name portion is broken. We had to work around it (by reading our own PID to USER table), but I understand a subsequent release addressed the issue. LIST.READU -INTERNAL Broken output: 11009371^677913942^0^2000^1^RU^ ^ ^333719*1^ 1606438775^34480532^0^5224^15^RU^ ^ ^270784^ 1718299426^1218558262^0^3692^15^RU^ ^ ^30742^ Original output: 814621824^1688564731^0^6896^82^RU^6896^DOMAIN\Joe.User^ZLIST.READUEX^ What they meant to say is that the USERNAME is not reported. Pid is there on 11.1.1. - - - - - - - - - - - - Problems Fixed in UniVerse Release 11.1.5 (Build 5757) UNV-5010UniVerse -- Beginning at UniVerse 11.1.1, the pid number of the UniVerse process holding a lock was no longer displayed in the LIST.READU output. This problem as been fixed. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Monday, April 30, 2012 4:28 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] User ID of a LOCKED record LIST.READU -INTERNAL you don't need the EVERY to see record locks but how wild that -INTERNAL gives you the USER NAME ! And the regular LIST.READU does not (even though the documentation says it will) _ Scanned by IBM Email Security Management Services powered by MessageLabs. For more information please visit http://www.ers.ibm.com This email is intended only for the use of the party to which it is addressed and may contain information that is privileged, confidential, or protected by law. If you are not the intended recipient you are hereby notified that any dissemination, copying or distribution of the email or its contents is strictly prohibited. If you have received this message in error, please notify us immediately, by replying to the message and deleting it from your computer. WARNING: Internet communications are not assured to be secure or clear of inaccuracies as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. Therefore, we do not accept responsibility for any errors or omissions that are present in this email, or any attachment, that have arisen as a result of e-mail transmission. _ ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] User timeout question
No guarantees as to how it works with SB, but UV has an AUTOLOGOUT {idle minutes} command that might be of use. -Rick Nuckolls -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lunt, Bruce Sent: Tuesday, May 01, 2012 11:58 AM To: u2-users@listserver.u2ug.org Subject: [U2] User timeout question Hi All, We are having a problem with a particular user who is opening up a maintenance screen and then leaving the record in the locked state when he goes home. Is there a way to log him off the system (and unsetting locks) after a certain amount of time has elapsed? Thanks in advance, Bruce btw we are running HPUX 11 on HP9000 with SB+ screens. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] User ID of a LOCKED record
LISTME only lists *you* It doesn't list every user on the system who might be holding a lock. Only your processes -Original Message- From: Andy Krause akra...@rammutual.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Tue, May 1, 2012 11:55 am Subject: Re: [U2] User ID of a LOCKED record I didn't read over Troy's comments earlier, but he's right. The user ame portion of the LIST.READU -INTERNAL does not work. In my case when run it the result shows me holding every single lock. I ended up using LISTME rather than LIST.READU -INTERNAL to pull the sername. We are currently on Universe 10.2.10 so this will have to be good enough ntil we upgrade to 11.1.5. Thanks again. -Original Message- rom: u2-users-boun...@listserver.u2ug.org mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Buss, Troy Contractor, Logitek Systems) ent: Monday, April 30, 2012 7:05 PM o: U2 Users List ubject: Re: [U2] User ID of a LOCKED record Also, on UV 11.1.1 the user name portion is broken. We had to work round it (by reading our own PID to USER table), but I understand a ubsequent release addressed the issue. LIST.READU -INTERNAL Broken output: 1009371^677913942^0^2000^1^RU^ ^ ^333719*1^ 606438775^34480532^0^5224^15^RU^ ^ ^270784^ 718299426^1218558262^0^3692^15^RU^ ^ ^30742^ Original output: 14621824^1688564731^0^6896^82^RU^6896^DOMAIN\Joe.User^ZLIST.READUEX^ What they meant to say is that the USERNAME is not reported. Pid is here on 11.1.1. - - - - - - - - - - - roblems Fixed in UniVerse Release 11.1.5 (Build 5757) UNV-5010UniVerse -- Beginning at UniVerse 11.1.1, the pid number f the UniVerse process holding a lock was no longer isplayed in the LIST.READU output. This problem as been fixed. -Original Message- rom: u2-users-boun...@listserver.u2ug.org mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson ent: Monday, April 30, 2012 4:28 PM o: u2-users@listserver.u2ug.org ubject: Re: [U2] User ID of a LOCKED record IST.READU -INTERNAL ou don't need the EVERY to see record locks but how wild that -INTERNAL gives you the USER NAME ! nd the regular LIST.READU does not (even though the documentation says t will) canned by IBM Email Security Management Services powered by essageLabs. For more information please visit http://www.ers.ibm.com This email is intended only for the use of the party to which it is ddressed and may contain information that is privileged, confidential, r protected by law. If you are not the intended recipient you are ereby notified that any dissemination, copying or distribution of the mail or its contents is strictly prohibited. If you have received this essage in error, please notify us immediately, by replying to the essage and deleting it from your computer. WARNING: Internet communications are not assured to be secure or clear f inaccuracies as information could be intercepted, corrupted, lost, estroyed, arrive late or incomplete, or contain viruses. Therefore, we o not accept responsibility for any errors or omissions that are resent in this email, or any attachment, that have arisen as a result f e-mail transmission. ___ __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] User timeout question
HELP AUTOLOGOUT -Original Message- From: Lunt, Bruce bl...@shaklee.com To: u2-users u2-users@listserver.u2ug.org Sent: Tue, May 1, 2012 11:59 am Subject: [U2] User timeout question Hi All, e are having a problem with a particular user who is opening up a aintenance screen and then leaving the record in the locked state when he oes home. Is there a way to log him off the system (and unsetting locks) fter a certain amount of time has elapsed? hanks in advance, ruce tw we are running HPUX 11 on HP9000 with SB+ screens. __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] User ID of a LOCKED record
We wrote a process that monitors all locks on a system based on how long they have been locked with a parameter you start the program with. e.g. LOCK.MONITOR 5 The code uses the GETREADU() function and it parses the results and puts it into an array. Then displays it on a screen with details of the user the record id etc. We also use the LIST.CONNECT command because we have remote files connected via NFA to see if there are any locks. We also use the LIST.QUEUE it shows who locked it first and the others waiting for it to be released. We also let you do a PORT.STATUS on the PID so you can actually view the files opened and the actual line of a UniBasic program last executed. Finally we let the user (if started as an Admin user) release the lock from the program. We used a lot when we first wrote in troubleshooting deadly embraces which enabled us to pinpoint and solve those locking issues. Questions? Email me below, or call me. Nick Nicholas M Gettino, Director of Professional Services Support, EnRoute Emergency Systems an Infor Company, Concourse Center 1, 3501 East Frontage Rd, Suite 350, Tampa, FL 33607 -(813) 207-6998 direct, (813) 334-3507 cell, FAX (678) 393-5389 nick.gett...@enroute911.com or nick.gett...@infor.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] READU vs READ
Updating 700,000 records. If you want speed on the reads and writes the best way to accomplish it is to MATREADU the record equate the attributes you are going to update or all of them in case you ever want to add and then MATWRITE. It takes more coding, but it is well worth it. It takes a little longer to start the program ( a few seconds) but the results will amaze you compared to a normal READU. Nicholas M Gettino, Director of Professional Services Support, EnRoute Emergency Systems an Infor Company, Concourse Center 1, 3501 East Frontage Rd, Suite 350, Tampa, FL 33607 -(813) 207-6998 direct, (813) 334-3507 cell, FAX (678) 393-5389 nick.gett...@enroute911.com or nick.gett...@infor.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] User timeout question
I tried HELP AUTOLOGOUT but it was not there. Is this a recent command? We are running version 7.1 of Unidata. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, May 01, 2012 12:18 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] User timeout question HELP AUTOLOGOUT -Original Message- From: Lunt, Bruce bl...@shaklee.com To: u2-users u2-users@listserver.u2ug.org Sent: Tue, May 1, 2012 11:59 am Subject: [U2] User timeout question Hi All, e are having a problem with a particular user who is opening up a aintenance screen and then leaving the record in the locked state when he oes home. Is there a way to log him off the system (and unsetting locks) fter a certain amount of time has elapsed? hanks in advance, ruce tw we are running HPUX 11 on HP9000 with SB+ screens. __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] READU vs READ
Maybe. There is the additional overhead of populating the DIM array on the MATREAD and the reverse on the MATWRITE. The more your program accesses the fields, esp. the more fields you have, then I agree, this can be MUCH faster. However, it you have big records and all you are doing is updating field 1, you may be doing a lot of overhead without getting the bang for your buck. Write a simple program that simulates your effort with READS/WRITES and then again with MATREADS/MATWRITES. Depending on what you are actually doing may or may not make a huge difference. If your performance is a real issue, this could be well worth the effort. John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Nick Gettino Sent: Tuesday, May 01, 2012 3:45 PM To: 'u2-users@listserver.u2ug.org' Subject: Re: [U2] READU vs READ Additional the larger the record the better the MATREADU works over the READU. Nicholas M Gettino, Director of Professional Services Support, EnRoute Emergency Systems an Infor Company, Concourse Center 1, 3501 East Frontage Rd, Suite 350, Tampa, FL 33607 -(813) 207-6998 direct, (813) 334-3507 cell, FAX (678) 393-5389 nick.gett...@enroute911.com or nick.gett...@infor.com From: Nick Gettino Sent: Tuesday, May 01, 2012 3:44 PM To: u2-users@listserver.u2ug.org Subject: [U2] READU vs READ Updating 700,000 records. If you want speed on the reads and writes the best way to accomplish it is to MATREADU the record equate the attributes you are going to update or all of them in case you ever want to add and then MATWRITE. It takes more coding, but it is well worth it. It takes a little longer to start the program ( a few seconds) but the results will amaze you compared to a normal READU. Nicholas M Gettino, Director of Professional Services Support, EnRoute Emergency Systems an Infor Company, Concourse Center 1, 3501 East Frontage Rd, Suite 350, Tampa, FL 33607 -(813) 207-6998 direct, (813) 334-3507 cell, FAX (678) 393-5389 nick.gett...@enroute911.commailto:nick.gett...@enroute911.com or nick.gett...@infor.commailto:nick.gett...@infor.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] User ID of a LOCKED record
Well maybe it's the way our system is setup but here is a portion of my LISTME: uid Pid User Name Terminal No Login Time 0 3520 RAMMUTUAL\ddowningtelnet:3520 May 1 07:01 0 6108 RAMMUTUAL\debel telnet:6108 May 1 07:04 0 732 RAMMUTUAL\akrause telnet:732 May 1 14:24 0 3396 RAMMUTUAL\marleneatelnet:3396 May 1 07:10 0 4484 RAMMUTUAL\rbaker telnet:4484 May 1 09:53 0 5016 RAMMUTUAL\ssunnarbor telnet:5016 May 1 07:15 0 4676 RAMMUTUAL\bvanreese telnet:4676 May 1 07:16 0 5604 RAMMUTUAL\araisanen telnet:5604 May 1 13:41 0 2684 RAMMUTUAL\kjohnsontelnet:2684 May 1 07:20 0 3320 RAMMUTUAL\kzweifeltelnet:3320 May 1 07:24 * 0 2992 RAMMUTUAL\akrause telnet:732 May 1 14:44 0 4844 RAMMUTUAL\caritelnet:4844 May 1 07:34 0 5164 RAMMUTUAL\bjohnsontelnet:5164 May 1 07:35 I am akrause. I am on there twice and once with as '*' and with a Pid different than my Terminal No. Other than my duplicate entry, the Pid and Terminal No match on all entries and the number of entries matches our number of logged on users. The documentation does say that LISTME is used to list your currently running processes but clearly it is not in my case unless I am not understanding. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, May 01, 2012 2:17 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] User ID of a LOCKED record LISTME only lists *you* It doesn't list every user on the system who might be holding a lock. Only your processes -Original Message- From: Andy Krause akra...@rammutual.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Tue, May 1, 2012 11:55 am Subject: Re: [U2] User ID of a LOCKED record I didn't read over Troy's comments earlier, but he's right. The user ame portion of the LIST.READU -INTERNAL does not work. In my case when run it the result shows me holding every single lock. I ended up using LISTME rather than LIST.READU -INTERNAL to pull the sername. We are currently on Universe 10.2.10 so this will have to be good enough ntil we upgrade to 11.1.5. Thanks again. -Original Message- rom: u2-users-boun...@listserver.u2ug.org mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Buss, Troy Contractor, Logitek Systems) ent: Monday, April 30, 2012 7:05 PM o: U2 Users List ubject: Re: [U2] User ID of a LOCKED record Also, on UV 11.1.1 the user name portion is broken. We had to work round it (by reading our own PID to USER table), but I understand a ubsequent release addressed the issue. LIST.READU -INTERNAL Broken output: 1009371^677913942^0^2000^1^RU^ ^ ^333719*1^ 606438775^34480532^0^5224^15^RU^ ^ ^270784^ 718299426^1218558262^0^3692^15^RU^ ^ ^30742^ Original output: 14621824^1688564731^0^6896^82^RU^6896^DOMAIN\Joe.User^ZLIST.READUEX^ What they meant to say is that the USERNAME is not reported. Pid is here on 11.1.1. - - - - - - - - - - - roblems Fixed in UniVerse Release 11.1.5 (Build 5757) UNV-5010UniVerse -- Beginning at UniVerse 11.1.1, the pid number f the UniVerse process holding a lock was no longer isplayed in the LIST.READU output. This problem as been fixed. -Original Message- rom: u2-users-boun...@listserver.u2ug.org mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson ent: Monday, April 30, 2012 4:28 PM o: u2-users@listserver.u2ug.org ubject: Re: [U2] User ID of a LOCKED record IST.READU -INTERNAL ou don't need the EVERY to see record locks but how wild that -INTERNAL gives you the USER NAME ! nd the regular LIST.READU does not (even though the documentation says t will) canned by IBM Email Security Management Services powered by essageLabs. For more information please visit http://www.ers.ibm.com This email is intended only for the use of the party to which it is ddressed and may contain information that is privileged, confidential, r protected by law. If you are not the intended recipient you are ereby notified that any dissemination, copying or distribution of the mail or its contents is strictly prohibited. If you have received this essage in error, please notify us immediately, by replying to the essage and deleting it from your computer. WARNING: Internet communications are not assured to be secure or clear f inaccuracies as information could be intercepted, corrupted, lost, estroyed, arrive late or incomplete, or contain viruses. Therefore, we o not accept responsibility for any errors or omissions that are resent in this email, or any attachment, that have arisen as a result f e-mail
Re: [U2] User timeout question
I don't know I'm on Universe -Original Message- From: Lunt, Bruce bl...@shaklee.com To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Tue, May 1, 2012 12:49 pm Subject: Re: [U2] User timeout question I tried HELP AUTOLOGOUT but it was not there. Is this a recent command? We re running version 7.1 of Unidata. -Original Message- rom: u2-users-boun...@listserver.u2ug.org mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson ent: Tuesday, May 01, 2012 12:18 PM o: u2-users@listserver.u2ug.org ubject: Re: [U2] User timeout question ELP AUTOLOGOUT -Original Message- rom: Lunt, Bruce bl...@shaklee.com o: u2-users u2-users@listserver.u2ug.org ent: Tue, May 1, 2012 11:59 am ubject: [U2] User timeout question i All, e are having a problem with a particular user who is opening up a aintenance creen and then leaving the record in the locked state when he oes home. Is here a way to log him off the system (and unsetting locks) fter a certain mount of time has elapsed? hanks in advance, uce tw we are running HPUX 11 on HP9000 with SB+ screens. _ -Users mailing list -us...@listserver.u2ug.org tp://listserver.u2ug.org/mailman/listinfo/u2-users ___ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] User timeout question
I gather that in Unidata, the command is TIMEOUT. Note that the parameter is seconds. TIMEOUT 0 might reset it, but it does not say anything in this document. (From Unidata Commands reference) -Rick TIMEOUT nn Description The ECL TIMEOUT command automatically logs a user out of a UniData session if input is not received in nn seconds. The setting remains in effect for the current UniData session only. TIMEOUT applies to the following: ECL (colon) prompt. Proc IP and IBP commands. Paragraph inline prompting (except with the I option). UniBasic INPUT commands and the IN function. TIMEOUT does not apply to the prompt that displays after an interrupt in ECL. UniData executes the LOGOUT paragraph before exiting the session.Warning: Depending on your application coding, setting TIMEOUT could cause logical database inconsistencies. For example, without transaction processing in effect, an application might update part of a record, prompt for user input, and then time out at the prompt without updating the rest of the record. Example In the following example, the TIMEOUT command logs the user off after 59 seconds if UniData receives no input: :TIMEOUT 59 Process will timeout after waiting 59 seconds for input. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lunt, Bruce Sent: Tuesday, May 01, 2012 12:48 PM To: 'U2 Users List' Subject: Re: [U2] User timeout question I tried HELP AUTOLOGOUT but it was not there. Is this a recent command? We are running version 7.1 of Unidata. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, May 01, 2012 12:18 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] User timeout question HELP AUTOLOGOUT -Original Message- From: Lunt, Bruce bl...@shaklee.com To: u2-users u2-users@listserver.u2ug.org Sent: Tue, May 1, 2012 11:59 am Subject: [U2] User timeout question Hi All, e are having a problem with a particular user who is opening up a aintenance screen and then leaving the record in the locked state when he oes home. Is there a way to log him off the system (and unsetting locks) fter a certain amount of time has elapsed? hanks in advance, ruce tw we are running HPUX 11 on HP9000 with SB+ screens. __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] User timeout question
On Unidata use TIMEOUT.This will logoff the session when inactive keyboard exceeds the desired time period. Marc Rutherford Principal Programmer Analyst Advanced Bionics LLC 661) 362 1754 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lunt, Bruce Sent: Tuesday, May 01, 2012 12:48 PM To: 'U2 Users List' Subject: Re: [U2] User timeout question I tried HELP AUTOLOGOUT but it was not there. Is this a recent command? We are running version 7.1 of Unidata. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, May 01, 2012 12:18 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] User timeout question HELP AUTOLOGOUT -Original Message- From: Lunt, Bruce bl...@shaklee.com To: u2-users u2-users@listserver.u2ug.org Sent: Tue, May 1, 2012 11:59 am Subject: [U2] User timeout question Hi All, e are having a problem with a particular user who is opening up a aintenance screen and then leaving the record in the locked state when he oes home. Is there a way to log him off the system (and unsetting locks) fter a certain amount of time has elapsed? hanks in advance, ruce tw we are running HPUX 11 on HP9000 with SB+ screens. __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] User timeout question
I don't have it either. HPUX, UniData 7.2. John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lunt, Bruce Sent: Tuesday, May 01, 2012 3:48 PM To: 'U2 Users List' Subject: Re: [U2] User timeout question I tried HELP AUTOLOGOUT but it was not there. Is this a recent command? We are running version 7.1 of Unidata. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, May 01, 2012 12:18 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] User timeout question HELP AUTOLOGOUT -Original Message- From: Lunt, Bruce bl...@shaklee.com To: u2-users u2-users@listserver.u2ug.org Sent: Tue, May 1, 2012 11:59 am Subject: [U2] User timeout question Hi All, e are having a problem with a particular user who is opening up a aintenance screen and then leaving the record in the locked state when he oes home. Is there a way to log him off the system (and unsetting locks) fter a certain amount of time has elapsed? hanks in advance, ruce tw we are running HPUX 11 on HP9000 with SB+ screens. __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] User ID of a LOCKED record
Evidently another of those places where Unix and Windows differ. LISTME These are the UniVerse processes running under your user id. uid Pid User Name Terminal No Login Time *198387 1568 RWCUNIVERSE1\W.Johns telnet:7140 May 1 13:59 198387 7140 RWCUNIVERSE1\W.Johns telnet:7140 May 1 09:32 There are actually 67 users logged on the system according to LISTU so this is only showing my processes, not all processes -Original Message- From: Andy Krause akra...@rammutual.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Tue, May 1, 2012 1:54 pm Subject: Re: [U2] User ID of a LOCKED record Well maybe it's the way our system is setup but here is a portion of my ISTME: uid Pid User Name Terminal No Login Time 0 3520 RAMMUTUAL\ddowningtelnet:3520 May 1 07:01 0 6108 RAMMUTUAL\debel telnet:6108 May 1 07:04 0 732 RAMMUTUAL\akrause telnet:732 May 1 14:24 0 3396 RAMMUTUAL\marleneatelnet:3396 May 1 07:10 0 4484 RAMMUTUAL\rbaker telnet:4484 May 1 09:53 0 5016 RAMMUTUAL\ssunnarbor telnet:5016 May 1 07:15 0 4676 RAMMUTUAL\bvanreese telnet:4676 May 1 07:16 0 5604 RAMMUTUAL\araisanen telnet:5604 May 1 13:41 0 2684 RAMMUTUAL\kjohnsontelnet:2684 May 1 07:20 0 3320 RAMMUTUAL\kzweifeltelnet:3320 May 1 07:24 0 2992 RAMMUTUAL\akrause telnet:732 May 1 14:44 0 4844 RAMMUTUAL\caritelnet:4844 May 1 07:34 0 5164 RAMMUTUAL\bjohnsontelnet:5164 May 1 07:35 I am akrause. I am on there twice and once with as '*' and with a Pid ifferent than my Terminal No. Other than my duplicate entry, the Pid nd Terminal No match on all entries and the number of entries matches ur number of logged on users. The documentation does say that LISTME is used to list your currently unning processes but clearly it is not in my case unless I am not nderstanding. -Original Message- rom: u2-users-boun...@listserver.u2ug.org mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson ent: Tuesday, May 01, 2012 2:17 PM o: u2-users@listserver.u2ug.org ubject: Re: [U2] User ID of a LOCKED record ISTME only lists *you* t doesn't list every user on the system who might be holding a lock. nly your processes -Original Message- rom: Andy Krause akra...@rammutual.com o: U2 Users List u2-users@listserver.u2ug.org ent: Tue, May 1, 2012 11:55 am ubject: Re: [U2] User ID of a LOCKED record didn't read over Troy's comments earlier, but he's right. The user me portion of the LIST.READU -INTERNAL does not work. In my case when run it the result shows me holding every single lock. ended up using LISTME rather than LIST.READU -INTERNAL to pull the ername. e are currently on Universe 10.2.10 so this will have to be good enough til we upgrade to 11.1.5. hanks again. Original Message- om: u2-users-boun...@listserver.u2ug.org ailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Buss, Troy ontractor, Logitek Systems) nt: Monday, April 30, 2012 7:05 PM : U2 Users List bject: Re: [U2] User ID of a LOCKED record lso, on UV 11.1.1 the user name portion is broken. We had to work ound it (by reading our own PID to USER table), but I understand a bsequent release addressed the issue. LIST.READU -INTERNAL roken output: 009371^677913942^0^2000^1^RU^ ^ ^333719*1^ 06438775^34480532^0^5224^15^RU^ ^ ^270784^ 18299426^1218558262^0^3692^15^RU^ ^ ^30742^ riginal output: 4621824^1688564731^0^6896^82^RU^6896^DOMAIN\Joe.User^ZLIST.READUEX^ hat they meant to say is that the USERNAME is not reported. Pid is ere on 11.1.1. - - - - - - - - - - - oblems Fixed in UniVerse Release 11.1.5 (Build 5757) NV-5010 UniVerse -- Beginning at UniVerse 11.1.1, the pid number the UniVerse process holding a lock was no longer splayed in the LIST.READU output. This problem as been fixed. -Original Message- om: u2-users-boun...@listserver.u2ug.org ailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson nt: Monday, April 30, 2012 4:28 PM : u2-users@listserver.u2ug.org bject: Re: [U2] User ID of a LOCKED record IST.READU -INTERNAL u don't need the EVERY to see record locks ut how wild that -INTERNAL gives you the USER NAME ! d the regular LIST.READU does not (even though the documentation says will) ___ ___ anned by IBM Email Security Management Services powered by ssageLabs. For more information please visit http://www.ers.ibm.com his email is intended only for the use of the party to which it is dressed and may contain information that is privileged, confidential, protected by law. If you are not the intended recipient you are reby notified that any dissemination, copying or
Re: [U2] READU vs READ
If the multivalues have many many values, and you are adding to the end, then a speed up may be possible. MATREAD in the data, RAISE those array elements you are changing. Before the MATWRITE, LOWER all array elements you raised. As I understand it, Universe keeps internal track on attributes, so processing these in ascending order is a LOT faster than it used to be. However this is not done for multivalues (space considerations?). Regards, Keith ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] READU vs READ
I think you complicating things ... Troy has it right: Sure files could be resized, and code re-engineered, and all these good thing do help, but I reduced a process scanning 20 million records from 12 days to 2 days just taking out the CRT to screen informing the user of progress (or lack of progress.) on such a large number I'd set the interval to around 2, so that the code as below sits at n,count += 1 if rem(count,2) then CRT n.count:' / ' : tot.count end On 1 May 2012 11:03, Buss, Troy (Contractor, Logitek Systems) troy.b...@nordsonasymtek.com wrote: Good point... For progress indications, I tend to do the following on the mass updates: N.COUNT += 1 IF REM(COUNT, 1000) ELSE CRT +: ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] READU vs READ
Computers keep getting faster, and databases keep getting larger. So as a refinement you could say, display something if a second or more has passed, and don't display anything if it hasn't. We used to use MOD 100, which was fine 20 years ago. Now it spins by so fast you cant read it. -Original Message- From: dennis bartlett dqbartl...@gmail.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Tue, May 1, 2012 3:16 pm Subject: Re: [U2] READU vs READ I think you complicating things ... Troy has it right: Sure files could be resized, and code re-engineered, and all these good hing do help, but I reduced a process scanning 20 million records from 12 ays to 2 days just taking out the CRT to screen informing the user of rogress (or lack of progress.) on such a large number I'd set the interval to around 2, so that the ode as below sits at n,count += 1 f rem(count,2) then CRT n.count:' / ' : tot.count nd On 1 May 2012 11:03, Buss, Troy (Contractor, Logitek Systems) roy.b...@nordsonasymtek.com wrote: Good point... For progress indications, I tend to do the following on the mass updates: N.COUNT += 1 IF REM(COUNT, 1000) ELSE CRT +: __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] User timeout question
Now for the $64 dollar question: Where do I put the timeout command to be sure that it is enabled when this user logs onto the system? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Rutherford, Marc Sent: Tuesday, May 01, 2012 1:00 PM To: U2 Users List Subject: Re: [U2] User timeout question On Unidata use TIMEOUT.This will logoff the session when inactive keyboard exceeds the desired time period. Marc Rutherford Principal Programmer Analyst Advanced Bionics LLC 661) 362 1754 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lunt, Bruce Sent: Tuesday, May 01, 2012 12:48 PM To: 'U2 Users List' Subject: Re: [U2] User timeout question I tried HELP AUTOLOGOUT but it was not there. Is this a recent command? We are running version 7.1 of Unidata. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, May 01, 2012 12:18 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] User timeout question HELP AUTOLOGOUT -Original Message- From: Lunt, Bruce bl...@shaklee.com To: u2-users u2-users@listserver.u2ug.org Sent: Tue, May 1, 2012 11:59 am Subject: [U2] User timeout question Hi All, e are having a problem with a particular user who is opening up a aintenance screen and then leaving the record in the locked state when he oes home. Is there a way to log him off the system (and unsetting locks) fter a certain amount of time has elapsed? hanks in advance, ruce tw we are running HPUX 11 on HP9000 with SB+ screens. __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] User timeout question
LOGIN -Original Message- From: Lunt, Bruce bl...@shaklee.com To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Tue, May 1, 2012 3:52 pm Subject: Re: [U2] User timeout question Now for the $64 dollar question: Where do I put the timeout command to be ure that it is enabled when this user logs onto the system? -Original Message- rom: u2-users-boun...@listserver.u2ug.org mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Rutherford, Marc ent: Tuesday, May 01, 2012 1:00 PM o: U2 Users List ubject: Re: [U2] User timeout question n Unidata use TIMEOUT.This will logoff the session when inactive eyboard exceeds the desired time period. Marc Rutherford rincipal Programmer Analyst dvanced Bionics LLC 61) 362 1754 -Original Message- rom: u2-users-boun...@listserver.u2ug.org mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lunt, Bruce ent: Tuesday, May 01, 2012 12:48 PM o: 'U2 Users List' ubject: Re: [U2] User timeout question I tried HELP AUTOLOGOUT but it was not there. Is this a recent command? We re running version 7.1 of Unidata. -Original Message- rom: u2-users-boun...@listserver.u2ug.org mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson ent: Tuesday, May 01, 2012 12:18 PM o: u2-users@listserver.u2ug.org ubject: Re: [U2] User timeout question ELP AUTOLOGOUT -Original Message- rom: Lunt, Bruce bl...@shaklee.com o: u2-users u2-users@listserver.u2ug.org ent: Tue, May 1, 2012 11:59 am ubject: [U2] User timeout question i All, e are having a problem with a particular user who is opening up a aintenance creen and then leaving the record in the locked state when he oes home. Is here a way to log him off the system (and unsetting locks) fter a certain mount of time has elapsed? hanks in advance, uce tw we are running HPUX 11 on HP9000 with SB+ screens. _ -Users mailing list -us...@listserver.u2ug.org tp://listserver.u2ug.org/mailman/listinfo/u2-users ___ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] User timeout question
Thanks! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, May 01, 2012 4:01 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] User timeout question LOGIN -Original Message- From: Lunt, Bruce bl...@shaklee.com To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Tue, May 1, 2012 3:52 pm Subject: Re: [U2] User timeout question Now for the $64 dollar question: Where do I put the timeout command to be ure that it is enabled when this user logs onto the system? -Original Message- rom: u2-users-boun...@listserver.u2ug.org mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Rutherford, Marc ent: Tuesday, May 01, 2012 1:00 PM o: U2 Users List ubject: Re: [U2] User timeout question n Unidata use TIMEOUT.This will logoff the session when inactive eyboard exceeds the desired time period. Marc Rutherford rincipal Programmer Analyst dvanced Bionics LLC 61) 362 1754 -Original Message- rom: u2-users-boun...@listserver.u2ug.org mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lunt, Bruce ent: Tuesday, May 01, 2012 12:48 PM o: 'U2 Users List' ubject: Re: [U2] User timeout question I tried HELP AUTOLOGOUT but it was not there. Is this a recent command? We re running version 7.1 of Unidata. -Original Message- rom: u2-users-boun...@listserver.u2ug.org mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson ent: Tuesday, May 01, 2012 12:18 PM o: u2-users@listserver.u2ug.org ubject: Re: [U2] User timeout question ELP AUTOLOGOUT -Original Message- rom: Lunt, Bruce bl...@shaklee.com o: u2-users u2-users@listserver.u2ug.org ent: Tue, May 1, 2012 11:59 am ubject: [U2] User timeout question i All, e are having a problem with a particular user who is opening up a aintenance creen and then leaving the record in the locked state when he oes home. Is here a way to log him off the system (and unsetting locks) fter a certain mount of time has elapsed? hanks in advance, uce tw we are running HPUX 11 on HP9000 with SB+ screens. _ -Users mailing list -us...@listserver.u2ug.org tp://listserver.u2ug.org/mailman/listinfo/u2-users ___ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] READU vs READ and CRT
Just an interesting piece of history that folks might find amusing. Back in the day, Ultimate had a development project to speed up the basic compiler. Everyone was really anticipating the performance improvements. However, when the new compiler was timed and tested, it didn't produce the expected speed improvements and the developers couldn't find the cause. At the time, Ultimate displayed one asterisk as each line of code was compiled. After much investigation, one of the developers thought to remove the display of the *, and the compiler flew! It was truly amazing - so much so that we didn't think the program compiled at all. The new compiler was finally released as one * for each 10 lines of code. :) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, May 01, 2012 6:24 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] READU vs READ Computers keep getting faster, and databases keep getting larger. So as a refinement you could say, display something if a second or more has passed, and don't display anything if it hasn't. We used to use MOD 100, which was fine 20 years ago. Now it spins by so fast you cant read it. -Original Message- From: dennis bartlett dqbartl...@gmail.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Tue, May 1, 2012 3:16 pm Subject: Re: [U2] READU vs READ I think you complicating things ... Troy has it right: Sure files could be resized, and code re-engineered, and all these good hing do help, but I reduced a process scanning 20 million records from 12 ays to 2 days just taking out the CRT to screen informing the user of rogress (or lack of progress.) on such a large number I'd set the interval to around 2, so that the ode as below sits at n,count += 1 f rem(count,2) then CRT n.count:' / ' : tot.count nd On 1 May 2012 11:03, Buss, Troy (Contractor, Logitek Systems) roy.b...@nordsonasymtek.com wrote: Good point... For progress indications, I tend to do the following on the mass updates: N.COUNT += 1 IF REM(COUNT, 1000) ELSE CRT +: __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] READU vs READ and CRT
Good story, Laura! We are figuring out where we need animated gifs in a web app to indicate something is happening. They seem mostly unnecessary (with test data, which, granted, might be the reason they seem unnecessary at this point), so we are erring on the side of keeping them out, rather than putting them in. --dawn On Tue, May 1, 2012 at 6:17 PM, Laura Hirsh la...@lhirsh.org wrote: Just an interesting piece of history that folks might find amusing. Back in the day, Ultimate had a development project to speed up the basic compiler. Everyone was really anticipating the performance improvements. However, when the new compiler was timed and tested, it didn't produce the expected speed improvements and the developers couldn't find the cause. At the time, Ultimate displayed one asterisk as each line of code was compiled. After much investigation, one of the developers thought to remove the display of the *, and the compiler flew! It was truly amazing - so much so that we didn't think the program compiled at all. The new compiler was finally released as one * for each 10 lines of code. :) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, May 01, 2012 6:24 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] READU vs READ Computers keep getting faster, and databases keep getting larger. So as a refinement you could say, display something if a second or more has passed, and don't display anything if it hasn't. We used to use MOD 100, which was fine 20 years ago. Now it spins by so fast you cant read it. -Original Message- From: dennis bartlett dqbartl...@gmail.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Tue, May 1, 2012 3:16 pm Subject: Re: [U2] READU vs READ I think you complicating things ... Troy has it right: Sure files could be resized, and code re-engineered, and all these good hing do help, but I reduced a process scanning 20 million records from 12 ays to 2 days just taking out the CRT to screen informing the user of rogress (or lack of progress.) on such a large number I'd set the interval to around 2, so that the ode as below sits at n,count += 1 f rem(count,2) then CRT n.count:' / ' : tot.count nd On 1 May 2012 11:03, Buss, Troy (Contractor, Logitek Systems) roy.b...@nordsonasymtek.com wrote: Good point... For progress indications, I tend to do the following on the mass updates: N.COUNT += 1 IF REM(COUNT, 1000) ELSE CRT +: __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Dawn M. Wolthuis Take and give some delight today ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] READU vs READ and CRT
Hi Laura and Dawn, This reminds me of a program I wrote about 20 years ago for a multilevel marketing company. Its job was to audit a seller's downline, which in many cases ran into thousands or tens of thousands of transactions. For some larger sellers it ran for several minutes. The users insisted on seeing what progress it was making, and settled on a whirly-gig. I explained that it would only slow the process down, but they didn't care. They were quite willing to sacrifice speed for a stupid little character twirling around. Go figure... Regards, Charlie Noah On 05-01-2012 6:41 PM, Dawn Wolthuis wrote: Good story, Laura! We are figuring out where we need animated gifs in a web app to indicate something is happening. They seem mostly unnecessary (with test data, which, granted, might be the reason they seem unnecessary at this point), so we are erring on the side of keeping them out, rather than putting them in. --dawn On Tue, May 1, 2012 at 6:17 PM, Laura Hirshla...@lhirsh.org wrote: Just an interesting piece of history that folks might find amusing. Back in the day, Ultimate had a development project to speed up the basic compiler. Everyone was really anticipating the performance improvements. However, when the new compiler was timed and tested, it didn't produce the expected speed improvements and the developers couldn't find the cause. At the time, Ultimate displayed one asterisk as each line of code was compiled. After much investigation, one of the developers thought to remove the display of the *, and the compiler flew! It was truly amazing - so much so that we didn't think the program compiled at all. The new compiler was finally released as one * for each 10 lines of code. :) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, May 01, 2012 6:24 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] READU vs READ Computers keep getting faster, and databases keep getting larger. So as a refinement you could say, display something if a second or more has passed, and don't display anything if it hasn't. We used to use MOD 100, which was fine 20 years ago. Now it spins by so fast you cant read it. -Original Message- From: dennis bartlettdqbartl...@gmail.com To: U2 Users Listu2-users@listserver.u2ug.org Sent: Tue, May 1, 2012 3:16 pm Subject: Re: [U2] READU vs READ I think you complicating things ... Troy has it right: Sure files could be resized, and code re-engineered, and all these good hing do help, but I reduced a process scanning 20 million records from 12 ays to 2 days just taking out the CRT to screen informing the user of rogress (or lack of progress.) on such a large number I'd set the interval to around 2, so that the ode as below sits at n,count += 1 f rem(count,2) then CRT n.count:' / ' : tot.count nd On 1 May 2012 11:03, Buss, Troy (Contractor, Logitek Systems) roy.b...@nordsonasymtek.com wrote: Good point... For progress indications, I tend to do the following on the mass updates: N.COUNT += 1 IF REM(COUNT, 1000) ELSE CRT +: __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] READU vs READ and CRT
It's better for peace of mind to know that the computer thinks it's doing something Rather than wondering Is it DOING something -Original Message- From: Dawn Wolthuis dw...@tincat-group.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Tue, May 1, 2012 5:30 pm Subject: Re: [U2] READU vs READ and CRT Well, I get it even if it seems foolish at first blush -- it's all about he user experience. --dawn On Tue, May 1, 2012 at 7:24 PM, Charlie Noah cwn...@comcast.net wrote: Hi Laura and Dawn, This reminds me of a program I wrote about 20 years ago for a multilevel marketing company. Its job was to audit a seller's downline, which in many cases ran into thousands or tens of thousands of transactions. For some larger sellers it ran for several minutes. The users insisted on seeing what progress it was making, and settled on a whirly-gig. I explained that it would only slow the process down, but they didn't care. They were quite willing to sacrifice speed for a stupid little character twirling around. Go figure... Regards, Charlie Noah On 05-01-2012 6:41 PM, Dawn Wolthuis wrote: Good story, Laura! We are figuring out where we need animated gifs in a web app to indicate something is happening. They seem mostly unnecessary (with test data, which, granted, might be the reason they seem unnecessary at this point), so we are erring on the side of keeping them out, rather than putting them in. --dawn On Tue, May 1, 2012 at 6:17 PM, Laura Hirshla...@lhirsh.org wrote: Just an interesting piece of history that folks might find amusing. Back in the day, Ultimate had a development project to speed up the basic compiler. Everyone was really anticipating the performance improvements. However, when the new compiler was timed and tested, it didn't produce the expected speed improvements and the developers couldn't find the cause. At the time, Ultimate displayed one asterisk as each line of code was compiled. After much investigation, one of the developers thought to remove the display of the *, and the compiler flew! It was truly amazing - so much so that we didn't think the program compiled at all. The new compiler was finally released as one * for each 10 lines of code. :) -Original Message- From: u2-users-bounces@listserver.**u2ug.orgu2-users-boun...@listserver.u2ug.org [mailto:u2-users-bounces@**listserver.u2ug.orgu2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, May 01, 2012 6:24 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] READU vs READ Computers keep getting faster, and databases keep getting larger. So as a refinement you could say, display something if a second or more has passed, and don't display anything if it hasn't. We used to use MOD 100, which was fine 20 years ago. Now it spins by so fast you cant read it. -Original Message- From: dennis bartlettdqbartl...@gmail.com To: U2 Users Listu2-users@listserver.u2ug.**orgu2-users@listserver.u2ug.org Sent: Tue, May 1, 2012 3:16 pm Subject: Re: [U2] READU vs READ I think you complicating things ... Troy has it right: Sure files could be resized, and code re-engineered, and all these good hing do help, but I reduced a process scanning 20 million records from 12 ays to 2 days just taking out the CRT to screen informing the user of rogress (or lack of progress.) on such a large number I'd set the interval to around 2, so that the ode as below sits at n,count += 1 f rem(count,2) then CRT n.count:' / ' : tot.count nd On 1 May 2012 11:03, Buss, Troy (Contractor, Logitek Systems) roy.b...@nordsonasymtek.com wrote: Good point... For progress indications, I tend to do the following on the mass updates: N.COUNT += 1 IF REM(COUNT, 1000) ELSE CRT +: __** 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/**mailman/listinfo/u2-usershttp://listserver.u2ug.org/mailman/listinfo/u2-users __**_ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/**mailman/listinfo/u2-usershttp://listserver.u2ug.org/mailman/listinfo/u2-users __**_ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/**mailman/listinfo/u2-usershttp://listserver.u2ug.org/mailman/listinfo/u2-users __**_ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/**mailman/listinfo/u2-usershttp://listserver.u2ug.org/mailman/listinfo/u2-users -- awn M. Wolthuis Take and give some delight today __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org
[U2] [AD] User timeout question
It's been a long time since I've posted about this, but our company wrote and has sold a product called LOGMON for many years (15? I don't even remember). This software works at the Unix level to monitor usage of the users on a system, actually monitoring cpu usage, not keystrokes. And so if a user is idle, you can decide what to do about it, via a script that is run. In a Unidata/Universe environment, a signal can be sent that an application will see and it can release the locks and close the user out gracefully. But there are other approaches too. When combined with our Peek software, a script can be run to generate keystrokes on behalf of that user. So...you can set up a script that sends a series of predetermined keystrokes to back the user out of the application, and thus no coding is required in the specific application. (This assumes there's a standard set of keystrokes that you can user for this purpose, like a series of escape characters then a Q or somesuch.) Anyway, there are a lot of options. Check out Logmon and/or Peek at http://www.computronics.com Free trial versions are available for download. As I said I haven't posted about this in years as I know users who are bothered by commercial plugs, hence the [AD] tag above. There are certainly other ways to do it but this is often the path of least resistance for users who want to solve this problem without changes to their programs. And it is in use by a number of U2 sites (and plenty of other Unix sites). Note that we are Unix/Linux only. We don't do Windows ;-) Thanks! Randy ++ | Computronics Randy Styka, ra...@computronics.com | | 4N165 Wood Dale Road Phone: 630/941-7767| | Addison, Illinois 60101 USA Fax:630/941-7714| |www:http://www.computronics.com | | for product information: i...@computronics.com | | for product support: supp...@computronics.com| ++ ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users