Re: [U2] Multi-threaded phantom processing
There are options you can explore using the BASIC SQL Client Interface. These will allow basic programs running as phantoms to establish their own connection to the remote site and run subroutines supplied with data as parameters. This would bypass the need for multiple server phantoms listening and reacting to socket connections. You could also look at hosting web services on the AIX server and use the submitrequest() functions. Gregor Scott System Group Manager 549 Blackburn Rd Mount Waverley VIC 3149 Australia P: +61 3 9535 F: +61 3 9535 2274 E: gregor.sc...@pentanasolutions.com W: pentanasolutions.com Pentana Solutions accepts no liability for the content of this email, or for the consequences of any actions taken on the basis of the information provided, unless that information is subsequently confirmed in writing. If you are not the intended recipient, you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited. Gregor Scott System Group Manager 549 Blackburn Rd Mount Waverley VIC 3149 Australia P: +61 3 9535 F: +61 3 9535 2274 E: gregor.sc...@pentanasolutions.com W: pentanasolutions.com Pentana Solutions accepts no liability for the content of this email, or for the consequences of any actions taken on the basis of the information provided, unless that information is subsequently confirmed in writing. If you are not the intended recipient, you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Left Outer Join Question
Just checking the obvious cause... Are there any items in FILE1 to be selected? Gregor Scott System Group Manager 549 Blackburn Rd Mount Waverley VIC 3149 Australia P: +61 3 9535 F: +61 3 9535 2274 E: gregor.sc...@pentanasolutions.com W: pentanasolutions.com Pentana Solutions accepts no liability for the content of this email, or for the consequences of any actions taken on the basis of the information provided, unless that information is subsequently confirmed in writing. If you are not the intended recipient, you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited. Gregor Scott System Group Manager 549 Blackburn Rd Mount Waverley VIC 3149 Australia P: +61 3 9535 F: +61 3 9535 2274 E: gregor.sc...@pentanasolutions.com W: pentanasolutions.com Pentana Solutions accepts no liability for the content of this email, or for the consequences of any actions taken on the basis of the information provided, unless that information is subsequently confirmed in writing. If you are not the intended recipient, you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of randyleesmith Sent: Tuesday, 4 March 2014 9:37 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Left Outer Join Question I must be doing something wrong. When I try this I get; SELECT FILE1 TO 1 SELECT FILE2 TO 2 MERGE.LIST 1 INTERSECT 2 TO 3 SELECT list 1 is not active. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] Programmatic Verification of Globally Cataloged Subroutine
I was also surprised to find it possible to ASSIGN a value to STATUS(). A quick test program shows it only allows integer values. Decimals have the ABS() of the value assigned, and text produces a Nonnumeric runtime error and STATUS() is (as expected) set to 0. Gregor Scott System Group Manager 549 Blackburn Rd Mount Waverley VIC 3149 Australia P: +61 3 9535 F: +61 3 9535 2274 E: gregor.sc...@pentanasolutions.com W: pentanasolutions.com Pentana Solutions accepts no liability for the content of this email, or for the consequences of any actions taken on the basis of the information provided, unless that information is subsequently confirmed in writing. If you are not the intended recipient, you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] I just discovered this
Gregor Scott System Group Manager I have been working with UV for a few years now but I occasionally uncover some functionality I never knew existed that is really cool and useful. Such as the invisible @TMP table (I just crated this post about it: http://wp.me/p1692U-1o). It is documented in the BASIC SQL Client Interface Guide and the UCI Developers Guide for those needing documentary evidence that it does exist. The premise of it is quite simple: 1. Create a dynamic array of data to be reported on. 2. Assign the array to a numbered select list 3. Use the SQL SELECT syntax to populate the @TMP table with the select list contents and produce an appropriate report/recordset. An example always helps to understand. The Test program: TEST.@TMP -- CATEG = ACBDAADBCB INFO = '' FOR II = 1 TO 10 ROW = II ROW2 = ROW :II ROW3 = TIME()-(II*(if mod(II,2) then -1 else 1)) ROW4 = CATEG[RIGHT(II,1)+1,1] INFOII = CONVERT(@AM,@TM,ROW) NEXT II SELECTN INFO TO 9 -- Note that each row's data is separated by @TM instead of an @VM. This is important for the SQL interface. Compile and run the above program. Using the active select list... Try this: SELECT F1 FMT 4R AS Row, F2 FMT 20L AS Descr, F3 FMT 10R CONV MTS AS Time, F4 FMT 3L AS Code FROM @TMP SLIST 9; This produces a simple output of the contents of select list 9 in a nicely formatted result. Row. Descr... Time.. Code 1 ROW 1 10:45:54 C 2 ROW 2 10:45:51 B 3 ROW 3 10:45:56 D 4 ROW 4 10:45:49 A 5 ROW 5 10:45:58 A 6 ROW 6 10:45:47 D 7 ROW 7 10:46:00 B 8 ROW 8 10:45:45 C 9 ROW 9 10:46:02 B 10 ROW 10 10:45:43 A 10 records listed. For a more complex sort sequence, try this one: SELECT F1 FMT 4R AS Row, F4 FMT 3L AS Category, F3 FMT 10R CONV MTS AS RowTime FROM @TMP SLIST 9 ORDER BY Category DESC, RowTime ASC; Row. Category RowTime... 6 D 11:20:15 3 D 11:20:24 8 C 11:20:13 1 C 11:20:22 2 B 11:20:19 7 B 11:20:28 9 B 11:20:30 10 A 11:20:11 4 A 11:20:17 5 A 11:20:26 10 records listed. Gotchas to be aware of: 1. You cannot use the WHERE clause in the select statement. All the rows (attributes) in the select list will be output 2. You cannot use the TO SLIST {n} option to create another select list from the re-ordered output. 3. To order the output using non-default formatting (i.e. 10L you must use the 'F1 FMT {xx} AS {ColName}' syntax in the output and then use {ColName} in the ORDER BY section 4. Only the SQL form of the SELECT verb works with the @TMP table - it does not exist for UV LIST SELECT statements ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] List of display control @ variables for UVBasic
The UniVerse BASIC Commands Reference documents it (look for @ function in the TOC) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny Sent: Wednesday, 20 November 2013 8:54 AM To: U2-Users@listserver.u2ug.org Subject: [U2] List of display control @ variables for UVBasic Anyone know where the list of @ variables for display control ( @(-1) = clear screen) is in the Universe documentation? I can't seem to find it. Thanks -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ 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/1IpKwm7RGU/5YCbcDsMLoLdzSG18nYGvY/0.204 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Rocket releases UniVerse version 11.2.0
Hey Dan, Nice to see the $DEFINE and $IFDEF facilities getting expanded to include UV versions. Has there been any thought to provide command-line options for the BASIC command to define/undefined these sorts of variables? I think this would be a huge benefit as it avoids the need to change code in order to adjust a variable that influences compilation. Regards, Gregor ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Writing to a Windoz box from Universe
AIX 6.1 does have it built in. I think 5.2 ML12 might also include the ability to mount CIFS shares -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Hona, David Sent: Thursday, 11 July 2013 10:39 AM To: U2 Users List Subject: Re: [U2] Writing to a Windoz box from Universe Last time I checked, AIX has no native built-in capabilities to mount CIFS/Windows shares. 1. Samba/AIX port - open source If you wish to load the Samba port to AIX, you can use smbclient to perform an sftp/ftp like connection that'll mount the share temporarily - then you can get/put the file(s), etc. 2. FastConnect - IBM supported If you use IBM's FastConnect for AIX - you have to mount the share as a filesystem first - as smbclient is not supported unfortunately. Both solutions - of course - require a Windows account to connect to the Windows server and it must have sufficient rights on that share/filesystem to write/read/delete files, etc. Having a Windows share mounted all the time can be a security risk - especially if using generic Windows accounts with too much rights. Cheers, David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Parks, Boyd Sent: Thursday, 11 July 2013 5:43 AM To: u2-users@listserver.u2ug.org Subject: [U2] Writing to a Windoz box from Universe I simply want to write a filename to a Windoz server from an IBM box running AIX. What is the simplest method? I would like to avoid ftp. Been there, done that! Thanks! Boyd Boyd Parks MDIV ERA Programmer/Analyst 770.237.7541 770.975.3303 (cell) 770.237.6541 (fax) McKesson Business Performance Services www.mckesson.comhttp://www.mckesson.com ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ** ___ 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/1HxsMXL8TR/2RPtkBcfWCsuqIZuZ7iELX/0.2 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 recipient. Liability limited by a scheme approved under Professional Standards Legislation. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Would anyone else like a change to *HS.UPDFINFO?
That has not been our experience. The actual workings of the program are not well explained in the UV doco. I did find in the UV11 UniOLEDB PDF an explanation of sorts: * Scans the dictionaries of all nonsystem files named in the VOC, finding all associations and unassociated multivalued columns. * Rewrites the file information cache (.hs_fileinfo) under the account's directory, based on the above dictionary information and on the contents of the HS_FILE_ACCESS file. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny Sent: Thursday, 2 May 2013 1:57 AM To: U2 Users List Subject: Re: [U2] Would anyone else like a change to *HS.UPDFINFO? That would be a nice feature. I do believe that it only processes files with a * or *SELECT dictionary item however. 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 recipient. Liability limited by a scheme approved under Professional Standards Legislation. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Would anyone else like a change to *HS.UPDFINFO?
I am trying to get Rocket to improve the behaviour of *HS.UPDFINFO to support active select lists so that only the files I want built into the .hs_fileinfo cache item (rather than have EVERY SINGLE F/Q-type item from the VOC included). Support inform me that I seem to be the only person interested in such a change, so I thought I would at least ask the question of the U2 community. Would anyone else find it useful to have the *HS.UPDFINFO command enhanced to support select lists, or have a new command created that deals with select lists? Thanks Gregor 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 recipient. Liability limited by a scheme approved under Professional Standards Legislation. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Apparent Data Problem
Bill, If I read the error message correctly the problem is to do with opening the file not reading the record. Are you really opening the file for each record read? Are you sure you are in the account where the RCVR file exists - i.e. does the code cross-log at all? Regards, Gregor -Original Message- snip __ 3.19.13 10R19 072220 M10857300530 222 ** 16516þ16516þN10091þ1þ124þ745240þ0þ60100þ16515þ124.0þ300468300468þþ1þ 1240 3.20.13 10R19 07 N10091 300468 124 ** 16517þ16517þM10762þ1þ13173þ8891775þ0þ6750þ16511þ13173.0þ303253303253 3.21.13 10R11 072232 M1076230325313,173 Program RECENT.RECEIVERS.R11: Line 313, Improper data type. File 0 not found in VOC 3.21.13 10R11 072232 M10762 30325313,173 Program RECENT.RECEIVERS.R11: Line 313, Improper data type. File 0 not found in VOC ___ 313: open 'RCVR' to fRcvrelse null 314: 315: read rRcvr from fRcvr, rcvrID else rRcvr = '' 316:AP.Invoice.ID = rRcvr20,1 crt '** ' : rRcvr crt 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 recipient. Liability limited by a scheme approved under Professional Standards Legislation. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] XDOMOpen returning -1
The first step is to understand what the exact issue is. There is a function that can return a description of the error you have encountered. Typically the code looks like this: xstat = XDOMOpen( xmlData, XML.FROM.STRING, hDOM) if xstat # XML.SUCCESS then call XMLGetError( xErrCode, xErrMessage) crt xErrCode: - :xErrMessage end Regards, Gregor 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 recipient. Liability limited by a scheme approved under Professional Standards Legislation. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Turn pagination back on
For a modern though totally undocumented alternative to !BPIOCP thy this... The code ASSIGN 1 TO SYSTEM(1005) will enable pagination. The code ASSIGN 0 TO SYSTEM(1005) will disable it. I think this is documented on the U2UG.org wiki. 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 recipient. Liability limited by a scheme approved under Professional Standards Legislation. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UD] Disabling/blocking ODBC
I asked Rocket Support about the ODBCLOGIN feature availability in UV. They have confirmed that it does not currently exist in UV. There is an enhancement request for it (UNV-13746) to be added. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: Wednesday, 30 January 2013 11:25 PM To: 'U2 Users List' Subject: Re: [U2] [UD] Disabling/blocking ODBC Hi David Thanks - this was probably back on version 10.x when I first heard about the UniData version so it may have been added since. Brian 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 recipient. Liability limited by a scheme approved under Professional Standards Legislation. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Help with REVISE (AKA ENTRO/ENTROC)
According to the UV11 System Description manual: --snip-- Inserts a new line item above the current line item. ReVise displays an explanation and prompts you to enter the new set of associated multivalues. #n Copies all associated multivalues of line item n and puts it above the current line item. --snip-- Perahps the double is causing the grief? 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 recipient. Liability limited by a scheme approved under Professional Standards Legislation. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Sleeping in Basic
This might be a bit late, but just be careful about using openSocket() in a phantom. On UV (and I suspect on UD) this will change the phantom to an iPHANTOM because it will consume a license. If you have multiple phantoms running this concurrently you will start to see a licensing impact you were not expecting. Regards, Gregor -Original Message- ... Doug this works for me in UniData: SLEEP.TIME = 500 ;* .5 Second ERR = openSocket(loopback, 25, 1, SLEEP.TIME, hBUFF) David A. Green (480) 813-1725 DAG Consulting ... 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 recipient. Liability limited by a scheme approved under Professional Standards Legislation. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Creating XML nodes with a namespace prefix
Of course it can go on a wiki - I documented it so people know there is a way. Which wiki - pickwiki or the U2Ug wiki? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Wednesday, 12 December 2012 4:03 AM To: U2 Users List Subject: Re: [U2] Creating XML nodes with a namespace prefix Hey Gregor. Could you put that on the wiki? If not, could I? Thanks, Bill - Original Message - *From:* gregor.sc...@pentanasolutions.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 12/10/2012 10:11 PM *Subject:* [U2] Creating XML nodes with a namespace prefix If anyone has tried to use the UV XDOM api to create nodes with a namespace prefix (and failed), there is a non-obvious method you need to use. We recently had a need to do this, and with the help of Rocket U2 support we were able to achieve the required XML output. I have documented the method here for those inclined to use the XDOM API in this way, as it is obscure enough to not be obvious: http://gdoesu2.wordpress.com/2012/12/10/creating-xml-elements-with-a-n amespace-prefix/ Regards, Gregor 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 recipient. Liability limited by a scheme approved under Professional Standards Legislation. ___ 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 -- 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/1G8tWp4vQS/2WPyIlohSCEKEzA6lDGi0k/0 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 recipient. Liability limited by a scheme approved under Professional Standards Legislation. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Creating XML nodes with a namespace prefix
If anyone has tried to use the UV XDOM api to create nodes with a namespace prefix (and failed), there is a non-obvious method you need to use. We recently had a need to do this, and with the help of Rocket U2 support we were able to achieve the required XML output. I have documented the method here for those inclined to use the XDOM API in this way, as it is obscure enough to not be obvious: http://gdoesu2.wordpress.com/2012/12/10/creating-xml-elements-with-a-namespace-prefix/ Regards, Gregor 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 recipient. Liability limited by a scheme approved under Professional Standards Legislation. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] UV11.1.9 uvconfig issue
I need guidance from those who have battled (and hopefully won!) the UV11 shared memory setup. I am configuring a RHEL6 server with UV11.1.9 to perform some load testing, and am getting an issue with uvregen processing the uvconfig settings. The error is: # uvregen Disk shared memory size of 44759272 exceeds maximum allowed size of 33554432 uvregen: error during regen, process aborted uvregen: error during regen, process aborted # The question is: What setting(s) in the uvconfig file (or in unix) control the maximum allowed size value of 33554432 (32768k, 32mb)? We are tuning for 1040 uv processes (with 10 device licenses per proc, and 2 connection pool licenses and possible 45% phantom process loading), so the following uvconfig settings are in place: NUSERS 15083 SHM_GNTBLS 32 SHM_GNPAGES 480 SHM_GPAGESZ 512 Thanks Gregor 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 recipient. Liability limited by a scheme approved under Professional Standards Legislation. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UV11.1.9 uvconfig issue
Interesting - a fixed ceiling of 32mb. Would you consider the following to be a large lock table: GSEMNUM 193 GLTABSZ 150 RLTABSZ 150 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Colin Lucas Sent: Thursday, 22 November 2012 11:53 AM To: U2 Users List Subject: Re: [U2] UV11.1.9 uvconfig issue At UV11.1.9 the shared memory segment cannot be greater than 32 megabytes. When I tried to set the various values for approximately 800 users and have a huge record/group lock table I blew the limit. Suggest you try to pare down as much as possible the lock table if it is large. Colin Lucas Youi Pty Ltd 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 recipient. Liability limited by a scheme approved under Professional Standards Legislation. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UV11.1.9 uvconfig issue
I would not consider those values as large. I did ask via our supplier in Australia ( Meier Business Systems) to lodge a case with Rocket to remove the limitation of 32MB particularly in view of our system having 512GB of main memory. Not sure if this will get a look in the upcoming release 11.1.10. Just had feedback from Rocket Support that this issue should be addressed in 11.1.10, due November-30. In the mean time, adjusting the NUSERS setting (as a result of reducing our Phantom Loading%), and reducing our locking table has finally resulted in a successful uvregen! Thanks Colin 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 recipient. Liability limited by a scheme approved under Professional Standards Legislation. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] What remote support product do YOU use?
Phablet - is that the next Android version? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ross Ferris Sent: Wednesday, 3 October 2012 4:49 PM To: U2 Users List Subject: [U2] What remote support product do YOU use? Just posted this to the pick/multivalue Google group, but figure there may be some (larger?) U2 only people who may have valuable insight on the subject, so We have been using TeamViewer (www.teamviewer.com) for the past 18 months or so, and I'm generally very happy with it - I can access Windows, Linux apple hosts from my desktop, or even my iPhone (screen is too small for remote support so will be upgrading to a GalaxyNote 2 Phablet soon, so will have a chance to try out the Android client), and would be happy to recommend others looking for a solution (quote coupon code 95051-42-600991 to get a 3% discount) We had previously used LogMeIn, RDP for server access, and/or even VNC if we had VPN access, but TeamViewer just works for us. Licencing is one off, based on number of people our end that will be running concurrent sessions to clients, rather than paying per client system, and I keep toying with the idea of integrating with Visage as a Support button. We also use TeamViewer to run presentations, though I tend to use Skype rather than integrated VOIP capabilities That said, I'm also curious if anyone has a better product they have used (first hand, rather than just something they have read about which sounded good), and/or especially if you had previously had a commercial TeamViewer licence moved on. Hoping for confirmation of our choice, but happy to have my horizons expanded :-) Ross Ferris Stamina Software Visage Better by Design! ___ 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/1FFUafXBSo/7KtjoQeo1oK7pQM42Yg6NT/0 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 recipient. Liability limited by a scheme approved under Professional Standards Legislation. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] What remote support product do YOU use?
Keeping more in line with the request, we also use TeamViewer as our remote support tool. I have not encountered internal complaints about it, so it seems a reasonable option for the job. 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 recipient. Liability limited by a scheme approved under Professional Standards Legislation. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [Windows]
You can adjust your network adaptor to stop the PC Power Management facility from turning it off. This should alleviate this problem for you. Run the Device Manager applet in the control panel, select the Network Adapters then select the appropriate adaptor. Right-click and select the Properties option. On Vista, there is a Power Management tab that shows a tick-box that indicates if the Power Management can turn the power off for the adaptor. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Thursday, 27 September 2012 7:21 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [Windows] Update on this case. If you set the sleep mode on your local PC such that it goes to sleep (power save), say while you are at lunch, this will apparently disconnect Universe telnet sessions. I tested this on my own PC, with ALL OTHER programs not running, except Accuterm connected to Universe which from the command prompt was doing a Loop-On Time with a five minute pause between loops. I set the sleep mode to go to sleep in one minute (typically you might have 15 minutes, 30 minutes or an hour). When it went to sleep, or rather when I woke it up ten minutes or so later, my session had been disconnected. This may explain not one, but *two* issues we are having here. Zombie sessions where the person never does login and yet the telnet process keeps running forever (which have apparentlydisappeared on Universe 11), and users getting disconnected while in records (because they went to lunch apparently). So the moral of the story is, set your sleep mode to wait at *least* an hour before going to sleep. -Original Message- From: Wjhonson wjhon...@aol.com To: u2-users u2-users@listserver.u2ug.org Sent: Tue, Sep 25, 2012 4:02 pm Subject: Re: [U2] [Windows] Update on this case. We recently upgraded our main server to Universe 11, and it's also a virtual server The problem with these zombie telnet sessions appears to have gone bye-bye. I haven't seen any in nine days, and they used to appear one to three times every day. -Original Message- From: Wjhonson wjhon...@aol.com To: u2-users u2-users@listserver.u2ug.org Sent: Mon, Sep 10, 2012 2:47 pm Subject: Re: [U2] [Windows] No that's wrong. So far none of the solutions presented has given me the IP or hostname of the particular telnet clients involved. As I mentioned before, you probably didn't read this one, when you start a telnet client it appears in the tasklist In this case, it's tl_server.exe which is Rocket's special telnet server However IF you do *not* login on that telnet server, then no corresponding entry is made in the netstat table, or perhaps one is made and then nulled out again. At the point you want to ask, well what are the ip numbers of these connections, you have 62 tl_server entries and 61 (repeat 61, not 62) netstat entries. That one extra zombie entry in the tasklist, is not present in the netstat output. So netstat is apparently only showing live or active connections or whatever you might call it, whereas the windows server is holding on to one or more *extra* zombies. Yes you can kill those *extra* tl_server.exe sessions, but really it would be nice to know what activated them. I killed all the zombies last week, and now I'm back up to about six extra tl_server sessions without corresponding netstat entries -Original Message- From: Tony Gravagno 3xk547...@sneakemail.com To: u2-users u2-users@listserver.u2ug.org Sent: Mon, Sep 10, 2012 2:37 pm Subject: Re: [U2] [Windows] What's the real goal here? To get the hostname of any random telnet client? You have the information you need to do that. If nothing else you can get the IP address and someone can manually chase down who's connecting in. Block rogue connections at the firewall. I mean, at this point you're going around in circles and the detail you're providing is irrelevant to the task. What still needs to be resolved? You're right. It doesn't matter what client program is being used as long as they come in via the standard telnet port and we don't care what time of night someone is connecting in. Why can't this thread be marked RESOLVED? T From: Wjhonson Oops I need to modify my message about these zombie tl_server.exe Windows sessions... [huge snip of mostly group-generated footers] ___ 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
Re: [U2] [U2[UV] @TIME and TIME() not reliable
The TIME() function is sensitive to local timezone settings in the OS. Is there a difference in the TZ environment variable between the two HP machines, or even for the user id running UV? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jacques G. Sent: Tuesday, 11 September 2012 2:50 AM To: U2 Users List Subject: Re: [U2] [U2[UV] @TIME and TIME() not reliable Hello, Has anyone else here observed this behavior for Universe 11.1.3 on a OS other than HP-UX ? Sometimes, @TIME will report an incorrect internal time. When I first observed this behavior, I changed my use of @TIME for a call to TIME(). It fixed the problem on one HP-UX server I was working on, but when I installed the program on a different HP-UX server, TIME() now sometimes reported an incorrect internal time. For example, it was around 6:00 am but the time reported was for about 4:00 am. I fixed the problem on that server by replacing TIME() by ICONVS(TIMEDATE()[1,8],MTS) We have a setup for temporary locks that expire after a given time these temporary locks were being created as already expired. It's a problem when a server can't determine the correct internal time. Thanks Jacques G. ___ 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/1FwBQGFAof/6zzhzgO3PktEIp1akWZRi4/2.953 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 recipient. Liability limited by a scheme approved under Professional Standards Legislation. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniQuery COPY FROM syntax error - Weird behavior
Check the VOC entries for COPY and FROM to ensure they are correct. It could be that something other than the failed COPY command has caused your problem by corrupting the FROM entry in the VOC. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Eric Malmberg Sent: Thursday, 2 August 2012 7:01 AM To: u2-users@listserver.u2ug.org Subject: [U2] UniQuery COPY FROM syntax error - Weird behavior I have encountered a strange problem after mistyping the UniQuery COPY command in one of our development environments. The command tried to copy the same record to itself and failed gracefully but subsequent attempts to properly copy records in this environment fail with a syntax error. :COPY FROM APPROVALS RECORD1, RECORD1 Copying APPROVALS RECORD1 to RECORD1... RECORD1 exists in APPROVALS, cannot overwrite 0 records copied All copy statements now result in the message: :COPY FROM APPROVALS RECORD1, RECORD2 -^ syntax error We have several environments on the same server but our dev account seems to be the only one affected. Does anyone have any thoughts on what could be the problem and suggest a resolution. Thanks in advance. Eric ___ 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/1Fge2UMmSJ/1IopnSZLqhJubA54RdaPfK/3.307 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 recipient. Liability limited by a scheme approved under Professional Standards Legislation. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] My first uniObject application
It just means they are invaluable -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Wednesday, 6 June 2012 2:10 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] My first uniObject application I have to bite my tongue. I am receiving the following error message: Children could not be valuated 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 recipient. Liability limited by a scheme approved under Professional Standards Legislation. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] Using Global sign certificates in UV
Is the actual host name (Leonardo.Rafael.be) in the hosts file on the server? Can you use ping Leonardo.Rafael.be to resolve the host name into the correct IP? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jacques G. Sent: Tuesday, 5 June 2012 1:55 AM To: U2 Users List Subject: [U2] [UV] Using Global sign certificates in UV Hello, The URL of a webservice I need to use has a port number in it ei: Acceptance = https://Leonardo.Rafael.be:9101/CustomerOrder/OrderManagementService/01/; The libraries U2 libraries I'm using are somehow interpreting: Leonardo.Rafael.be:9101 as the complete hostname (which it doesn't find in the host file. 05/29/2012 16:07:02 [ 26930 26925 ] new host 221010:Leonardo.Rafael.be:9101 allocated (proxy:no) 05/29/2012 16:07:02 [ 26930 26925 ] host Leonardo.Rafael.be:9101 not found in hostList 05/29/2012 16:07:09 [ 26930 26925 ] Unknown socket error : 1000 The code below is from the pick wiki article. Any ideas on now to get CreateSecureRequest() to interpret the host + port correctly ? Thanks. *** ### Code *** *For getting onto webservices we use this sort of code: * Read an xml request to send to the webservice * OPEN , WORK.OUT TO WORK.OUT ELSE STOP 201, WORK.OUT READ XML.REQUEST FROM WORK.OUT, TURTLE.XML ELSE STOP XML.REQUEST = CONVERT(@AM,,XML.REQUEST) PROMPT '' ;* 212.65.63.70 Acceptance = https://Leonardo.Rafael.be:9101/CustomerOrder/OrderManagementService/01/; ** Acceptance = https://212.65.63.70:9101/CustomerOrder/OrderManagementService/01/; Production = https://Leonardo.Rafael.be/CustomerOrder/OrderManagementService/01/; X.LOG.FILE = /trace_pc/work.out/CERT.LOG X.LOG.ACTION = 'ON' X.LOG.LEVEL = '10' WRITE ON WORK.OUT, CERT.LOG ;* Overwrite existing log file X.RTN.CODE = protocolLogging(X.LOG.FILE, X.LOG.ACTION,X.LOG.LEVEL) URL = Acceptance ;* Setting URL to the acceptance site L.ERR = sec_context='' L.ERR =createSecurityContext(sec_context,'') usedAs=2 ;* 2 = Issuer Certificate CA format = 2 ; algorithm = 1 ; * Uncomment to next 4 lines to create a new certificate * they only last for 365 days * action = 1 *req = '/PROD/certificates' CACert = '/trace_pc/work.out/CERT/REPTILE_SERVERS_CA.CRT' ; extensions = '' ; CertOut = '/trace_pc/work.out/CERT/ACTUAL' *ret = createCertificate(action,req,priveKey,explore,CACert,365,extensions,CertOut) ret = addCertificate(CertOut, usedAs, format, algorithm,sec_context) CRT The Return code is :ret depth=1; * 0 = self signed, 1 = Signed by a CA serverOrClient=2 ; * 1 = Server, 2 = client L.ERR+=setAuthenticationDepth(sec_context, depth, serverOrClient) CRT L.ERR After setAuthenticationDepth : :L.ERR CRT Hit a key to continue :;XX = KEYIN() ret = addAuthenticationRule(sec_context,serverOrClient,VerificationStrength,Generous) L.ERR+=setHTTPDefault(HEADERS,) CRT L.ERR after addAuthenticationRule : :L.ERR CRT Hit a key to continue :;XX = KEYIN() L.ERR+=setHTTPDefault(VERSION,1.1) CRT L.ERR after setHTTPDefault : :L.ERR CRT Hit a key to continue :;XX = KEYIN() request_handle='' L.ERR+=createSecureRequest(URL, POST, request_handle,sec_context) ;* Using the url CRT L.ERR after createSecureRequest : :L.ERR CRT Hit a key to continue :;XX = KEYIN() XML = XML.REQUEST MAX.RETRIES = 10 SERVER.IP.ADDRESS = Leonardo.Rafael.be TIMEOUT= 9 L.ERR+=addRequestParameter(request_handle, xmlStream, XML, ) CRT L.ERR after addRequestParameter : :L.ERR CRT Hit a key to continue :;XX = KEYIN() L.STATUS = 0 ; L.OUTPUT = ; L.TIMEOUT = ; L.POST.DATA = ; L.HEADER = L.ERR+=submitRequest(request_handle, TIMEOUT, L.POST.DATA, L.HEADER, L.OUTPUT, L.STATUS) CRT L.ERR : :L.ERR CRT L.HEADER:L.HEADER CRT CRT L.OUTPUT:L.OUTPUT CRT L.POST.DATA:L.POST.DATA SOCKET.PORT= 9101 BLOCKING.MODE = 1 ;* 1 = Blocking Mode, 2 = Non-Blocking Mode X.LOG.ACTION = 'OFF' X.RTN.CODE = protocolLogging(X.LOG.FILE, X.LOG.ACTION,X.LOG.LEVEL) ___ 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/1ESfTWqvLE/44bpo49N2SMmIDPHsjpPyk/7.157 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 recipient. Liability limited by a scheme approved
Re: [U2] U2 Dynamic Object API
All I have seen so far is in the UniData 7.3 new features PDF (see the tinyurl in my original post for a link to the PDF). I'd like to see some worked (and working!) examples at some point. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Tuesday, 29 May 2012 12:33 AM To: 'U2 Users List' Subject: Re: [U2] U2 Dynamic Object API I won't be there - where can I get more information on U2 Dynamic Objects. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wally Terhune Sent: 28 May 2012 13:51 To: U2 Users List Subject: Re: [U2] U2 Dynamic Object API There is a U2 University session on this - coming up June 26-8 at Carden Park, Cheshire: U2 Dynamic Objects - Hello JSON! Do you want to call a RESTful Web service and quickly deal with the data it brings back? Come learn how to use the new U2 Basic functionality to easily handle web services data in JSON (JavaScript Object Notation) format. Come learn about the interesting features in the new U2 Dynamic Objects (UDO) API in Basic and see how easy it is to consume web services. Wally Terhune Technical Support Architect Rocket Software 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA t: +1 720 475 8055 **e: wterh...@rocketsoftware.com **w: rocketsoftware.com/u2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Gregor Scott Sent: Sunday, May 27, 2012 11:41 PM To: U2 Users List Subject: [U2] U2 Dynamic Object API I was just working my way through the patchlist.txt for UV11.1.9, where I encountered an unexpected gem: U2 Dynamic Object API. To quote the full entry in the doc: UNV-5606 Beginning at UniVerse 11.1.9, the U2 Dynamic Object API is introduced as an emerging technology. U2 Dynamic Object API provides an object structure in UniVerse. It is based on JSON (JavaScript Object Notation), a lightweight text-based data interchange format. The details of the API are in Chapter 1 of the UniData 7.3 New Features manual (http://tinyurl.com/6q6hov8). Has anyone worked with this API yet and have any feedback/insights they care to share? Gregor 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 recipient. Liability limited by a scheme approved under Professional Standards Legislation. ___ 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 - No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1424 / Virus Database: 2425/5026 - Release Date: 05/27/12 ___ 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/1EPlOkoPKJ/5HCE7WfRkGsqA5bUriZYod/0 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] U2 Dynamic Object API
Good feedback - Thanks Doug. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug Averch Sent: Tuesday, 29 May 2012 3:10 AM To: U2 Users List Subject: Re: [U2] U2 Dynamic Object API I've been using JSON for many years now. I've written UniBasic code to build JSON in many of our Web applications and our middle-ware. I have written parser in UniBasic that can read JSON arrays and give you results. I was looking very excitedly to not having to maintain my code UniBasic code and have a function that can read and write JSON. I went to U2 University this year. I was at the session that discussed UDO. I had read the documentation several times and was unable to make heads or tails out using this technology. Dan, who taught the session in Denver, had several examples that got me going. However, his examples were very simplistic and did apply to the real world so I still had a lot of work to do. After spending more hours than I care to mention, I have working code. I've time tested my code against the UDO function on Unidata 7.3 and Universe 11.1.9. I found Rocket U2 code is just a touch faster than mine. This did not surprise me in that they could build it into the run engine. The hardest part of UDO is realizing when you write it yourself you can mix objects and arrays without being explicit. Not so with UDO. UDO allows you to mix and match objects and arrays but you must set them up as separate handles. Hopefully that helps, Doug www.u2logic.com/applications.html ___ 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/1EPoBdKhQv/4iB9HsdAEDtUq5AZF2iqon/0.204 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 recipient. Liability limited by a scheme approved under Professional Standards Legislation. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] Connecting to a WebService with UV using Authentication Certificate
There is a worked example on PickWiki. Search for CallHTTPwithSSL. This should give you a start. The UniVerse Security Features document explains how to use createSecurityContext() to create security context variables that are passed in to the createSecureRequest() function. It also covers the addCertificate() function needed to add a client certificate to the security context, which is what you will need. Regards, Gregor -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Jenkins Sent: Wednesday, 16 May 2012 8:58 AM To: Jacques G.; U2 Users List Cc: U2 Users List Subject: Re: [U2] [UV] Connecting to a WebService with UV using Authentication Certificate UniVerse has BASIC API extensions that support calling http with secure sockets. I suspect this will do the job for you if the web service is exposed. Regards JayJay Sent from my iPad On 15 May 2012, at 15:14, Jacques G. jacque...@yahoo.com wrote: Hello, A need has come up where I work to connect to a web service using Universe however the Webservice needs a Authentification Certificate. Is there any way to do this all with Universe or does one need to make use of Java on the UV server ? (Are there any examples available that do something like this ?) Jacques G. ___ 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 -- 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/1EK8ZVaFia/3zTCvLzq9b6pJCrufw3Q3K/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 recipient. Liability limited by a scheme approved under Professional Standards Legislation. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
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 recipient. Liability limited by a scheme approved under Professional Standards Legislation. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Where can I get UniAdmin?
I thought the new U2 DB Tools includes the extensible admin tool, built on eclipse. I have downloaded the package but not installed to confirm. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: Friday, 2 March 2012 10:36 AM To: u2-users@listserver.u2ug.org Subject: [U2] Where can I get UniAdmin? I am re-installing Universe and Unidata from scratch with the very latest 'everything'. The latest (?) Universe installation guide (October 2010 for v11.1) says The UniVerse Clients CD-ROM contains the following client software for use with Windows servers. The most recent (?) client and DBTools downloads from Rocket don't seem to include UniAdmin: http://www.rocketsoftware.com/u2/products/u2-clients-and-db-tools/u2-r esources So where is it these days for Universe and Unidata? Thanks! T ___ 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/1EfhESO4BU/4QyfMTGezeH3YBeHlxXACb/0 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 recipient. Liability limited by a scheme approved under Professional Standards Legislation. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Hushing commands
Not quite sure what you are asking with this. One just does a job. The other does any job supplied on the command line. You could avoid the performance penalty the three executes imposes, by using just 1: EXECUTE HUSH ON: @AM: COUNT VOC: @AM: HUSH OFF -- or -- EXECUTE HUSH OFF: @AM: OCONV(@COMMAND,'G1 99'): @AM: HUSH OFF -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Friday, 24 February 2012 9:06 AM To: u2-users@listserver.u2ug.org Subject: [U2] Hushing commands EXECUTE HUSH ON EXECUTE COUNT VOC EXECUTE HUSH OFF vs HUSHUP 001 EXECUTE HUSH ON 002 EXECUTE OCONV(@COMMAND,'G1 99') 003 EXECUTE HUSH OFF HUSHUP COUNT VOC 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 recipient. Liability limited by a scheme approved under Professional Standards Legislation. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Wintegrate 3 on Windows 7 issues
We had this issue with wInteg 4 on Vista and Windows 7. In most cases, a shutdown of all the MS Office products would allow it to start. It is resolved in wInteg 6, in case that helps in future upgrade discussions :) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of iggch...@comcast.net Sent: Wednesday, 9 November 2011 11:57 AM To: U2 Users List Subject: [U2] Wintegrate 3 on Windows 7 issues Hi All, Before I begin let me state that I know that I have an old version and should look into a better way. However, I'm stuck using the Wintegrate version that I have for the time being. That being said... Can anyone tell me a way of determining what is interfering with my Wintegrate application firing up? I just began experiencing the problem l ast night. I attempt to open the application and it never shows itself. I can see it in task manager. Image NameUser NameCPUMemory Description MSOSYNC.EXE THOMPSC 00 3364K Microsoft Office Document Cache w integ.exeTHOMPSC 00 wowexec.exe THOMPSC 00 It looks odd to me for winteg.exe to be a child of MSOSYNC.EXE. Maybe that's not the case but it looks that way in task manager. After quite a long time, the application will suddenly appear without rhyme or reason. My initial thought was that it was a communication issue with my host. However, I can ping without any loss whatsoever. Any advice would be greatly appreciated. Thanks Scott ___ 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/1DunNUaHeN/3n0EZU28udphMlY1XVbhdq/0 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 recipient. Liability limited by a scheme approved under Professional Standards Legislation. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] LIST.READU EVERY's waiters when there are writes w/o explicit readu.
The EVERY option on the LIST.READU shows the READ WAITERS. I remember from when I was digging into the universe performance counters that I enquired about this. The feedback I got was that there is nothing in UV that shows the WRITE WATIERS your test is creating. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson Sent: Tuesday, 25 October 2011 8:12 AM To: U2 Users List Subject: [U2] [UV] LIST.READU EVERY's waiters when there are writes w/o explicit readu. UV 10.2.10 on Windows is behaving differently from what I recall. Are my expectations out of line? Suppose Session A holds a readu lock; and Session B attempts a WRITE to same record withOUT!!! 1st explicitly getting the readu lock. Session B waits for Session A to release the lock before writing the record. While Session B is waiting, does it show up as a waiter in LIST.READU EVERY? I expected so, but it doesn't. Session A Session B _ ___ 1A. ED VOC DUMMY (this sets the readu lock.) 2A. (stay in editor)2B. run this: 01:OPEN 'VOC' TO F ELSE STOPM 'nope' 02: ***READU REC FROM F, 'DUMMY' ELSE NULL 03:WRITE '' TO F, 'DUMMY' 3A. Within ED: XEQ LIST.READU EVERY If I UN-comment line 2, LIST.READU EVERY shows something like this: Active Read Waiters: Owner Waiter Device Inode Userno Userno 746117947232860913 61163396 But when I comment out line 2, LIST.READU is silent. I have not yet explored what the deadlock daemon does. TIA, cds P.S. Yes, yes, Bad Form, Legacy Software, 20 min wait is configurable, . . . we can talk later. ___ 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/1Do90iBRjC/39zdi5b6C76BEMy9jDcLBL/0.6 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 recipient. Liability limited by a scheme approved under Professional Standards Legislation. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] test
Worked -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Jordan Sent: Wednesday, 28 September 2011 4:20 PM To: U2 Users List Subject: [U2] test test ___ 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/1DdbIApOh1/7DDwAhbDGi6YxfgeqyuRkV/0 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 recipient. Liability limited by a scheme approved under Professional Standards Legislation. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse backups to disk
Chris, add the options -notag -limit 1 to your command line. The -notag stops UV from updating the header of each record after it is included in the backup. The -limit 1 stops uvbackup from trying to use the shared-memory feature, which can severely impact the performance. The uvbackup command is the only one I know of that tests the integrity of the database structures as it goes. Filesystem-based backup of UV datafiles are ok so long as all changes have been flushed to disk prior to the backup starting and no files get changes during the backup process. To be certain that the files are ok, you need to suspend database writes, do the backup, then resume database writes. Other options are to suspend database writes, tape a snapshot of the filesystem, resume database writes, mount the snapshot in another filesystem then perform the backup. Gregor -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Lee Sent: Thursday, 18 August 2011 2:07 PM To: U2 Users List Subject: [U2] UniVerse backups to disk Hi All, We're running UniVerse 10.1.17 on AIX 5.3 and the backup feature included within our vendors software is pretty basic and only allows backups of Universe to tape. I'm going to continue running backups to tape on a nightly basis, but I'd also like to automate backups over the network to another file server so that if I'm not around to swap tapes they'll continue being backed up, as well as all the benefits of having extra copies in case a tape fails. What's the best way to achieve this, is it necessary to use UniVerse's built-in uvbackup utility ? I currently have a FreeNAS server setup in another building using rsync (the rsnapshot utility - http://rsnapshot.org/) to copy the files directly at the operating system level onto the FreeNAS box, however I've no way of really verifying the validity of these files copied over as to whether the server was in the midst of rewriting a file at the time it was copied. The FreeNAS rsnapshot setup appears to be doing a good job at copying the files and helps me rotate the backups through hourly, daily, weekly snapshots. It tries to save disk space by hard linking the rotated snapshots and only copying the changed files, however the problem is it validates the change by timestamp on the file, and of course when uvbackup runs each night it updates the timestamp on *every* file and hence each daily snapshot I end up with another entire copy of all the files when it probably wasn't necessary. If uvbackup is the way to go, what command line options should I be looking at ? I've read the examples in IBM's Universe admin manual but it doesn't give any examples of backup to to disk paths... Our current backup is about 15GB of data to tape, backing up our entire /UVdata directory and all the accounts under that. I'd like to do the same full backups to disk. From what I've pieced together in the manual the way to do this would be something like:- $ find /UVdata -print | uvbackup -f -v -l FULL UVDATA BACKUP - /remote.nfsshare/UVdata Once that's done I'm guessing I could then bundle that remote UVdata backup into a tarball and compress it to save space and keep several backups on disk. Any suggestions on the above would be greatly appreciated. Very interested to hear if uvbackup is necessary or not... I asked one of the guys from our software vendor in the past and he felt the files should be fine being backed up directly to another machine (ie: even via FTP) without uvbackup, but I'm not convinced myself that you could be 100% sure of the integrity of the files if you do a direct disk copy since how would you know if the server had some writes in a buffer it hadn't yet flushed or was in the middle of rewriting a file, or does it really not matter a great deal ? Thanks, Chris ___ 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/1CWgZEQvxW/1HpKcaS1Mr3xxV6sO44hVn/0 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 recipient. Liability limited by a scheme approved under Professional Standards Legislation. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] AIX uname and Redback
Have you confirmed if it is a reporting problem or a data capture problem? I.e. is that the uname -Fa is still producing the full output, but the RedBack environment does not return the entire result? You could try uname -Fa|tee /tmp/uname.redback.$$ to capture what is being output and compare it to the result RedBack is reporting. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: Friday, 5 August 2011 3:37 AM To: u2-users@listserver.u2ug.org Subject: [U2] AIX uname and Redback We have a client who found uname -Fa on AIX 5.3 doesn't return the unique system ID value when run through Redback. Suggestions are welcome about how to get the whole value. For example: From the command line and UO the result from 'uname -Fa' is: AIX hostname 3 5 ccsp mmmccs From a Redback connection that 'longnid' value is missing: AIX hostname 3 5 ccsp See the following page for details about how uname has changed in 5.3. http://www.ibm.com/developerworks/aix/library/au-aix-systemid.htm l Rocket has not been able to identify the cause. I guess they don't have access to IBM resources anymore. ;) It's my current guess that Redback is running in 32bit mode and that the longnid may only be generated for 64bit applications, but I can't test that. This is important for my purposes as uname is used as a component of the security mechanism to lock NebulaXLite and other software to a single system. I don't care what the value is, but I need it to be reported consistently. For now I'm issuing a site-specific version of the software so they can move forward, but I'd like to understand the problem. Thanks! Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com remove.pleaseNebula-RnD.com/blog Visit PickWiki.com! Contribute! http://Twitter.com/TonyGravagno ___ 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/1CQK4QfHQ7/4yuiblka8q8HrpDAq0e7ba/0 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 recipient. Liability limited by a scheme approved under Professional Standards Legislation. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Strange Selection Behavior
Hi Steve, It could be the CAPTURING clause causing you grief. Check the number of files in the UVTEMP directory. If there are a large number it could be that the OS is taking a long time to create the capturXXX file to store the results for the CAPTURING clause of the EXECUTE command. You could test this by removing the CAPTURING clause from the EXECUTE to see if it performs any better. If it does improve, and you are using the CAPTURING clause to hide the output of the select then look into the HUSH ON|OFF command. Regards, Gregor -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Long Sent: Wednesday, 15 June 2011 6:38 AM To: U2-Users@listserver.u2ug.org Subject: [U2] Strange Selection Behavior Hi All - I am getting strange results with selections that I am hoping someone else has encountered and can help me resolve. We have SB+ running on UV. I don't have the same issues running on Unidata. I have a BASIC program I have written that constructs a select statement based on the criteria specified in a screen by the user, then executes the constructed selection statement. Something like (although the real one is more complex): SEL.CMD = 'SELECT CUSTOMER WITH CUST.NUM = ' : CUST.NUM : ' AND WITH CUST.TYPE = ' : CUST.TYPE : '' EXECUTE SEL.CMD CAPTURING OUTPUT Indexes are built on the dictionaries and are working properly. When we test the constructed select statement at TCL, the results are retuned under 2 seconds. When it executes inside the BASIC program, it takes approximately 24 seconds to return the same results. We tried adding a NO.INDEX to the statement, which adds 6 seconds to the select at TCL but just a couple of seconds within the BASIC program. Nothing else we have tried has had any effect. Has anyone encountered this type of behavior? Thanks, Steve Long Spyderweb Technical Services, Inc. (360) 687-8797 Washington (503) 406-8797 Oregon (866) 354-5913 Fax ___ 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/1CvNKu7Zp8/1yOzkbOV9fOILTpT5SHfdr/2.4 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 recipient. Liability limited by a scheme approved under Professional Standards Legislation. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Limitations of uvrestore
I have just finished some testing of uvbackup and uvrestore on AIX and Linux to see if there are areas to improve performance. The results were interesting, and somewhat alarming - see http://gdoesu2.wordpress.com/2011/05/02/facts-about-uvbackup-and-uvrestore/ for details. What I am interested in is: a) Do UV platforms other than AIX and Linux have similar issues with uvrestore? b) Does anyone use block sizes beyond 1mb for uvbackup and uvrestore? If so, what size and what impact does it have on backup performance? Thanks Gregor 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 recipient. Liability limited by a scheme approved under Professional Standards Legislation. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] HMAC SHA256
We created an HMAC-SHA1 function in UV basic, using the digest() function of UV. Very quick and effective. I don't think UV supports SHA256, though so you might need to look externally to UV to generate the signature. Perhaps the SSL package within the underlying OS can provide it for you. Gregor -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Caminiti, Marc Sent: Friday, 25 March 2011 11:56 AM To: U2 Users List Subject: [U2] HMAC SHA256 We are looking to get onto Amazon and rather than using their php, java or c# packages, we are looking to use the createRequest and addRequestParameter functions in Universe. The one roadblock that I am running into is that they are requesting requests to be signed using HMAC SHA256. Is this something the universe can do, or is there any package out there that universe could call to calculate the signature? We run RHEL 5.3, UV 10.2.7 Thanks in Advance marc Marc Caminiti IS Manager Nashbar Direct, Inc 6103 State Route 446 Canfield, OH 44406 330.533.1989, ext 336 330.702.9733, fax Law of Logical Argument - Anything is possible if you don't know what you are talking about. CONFIDENTIALITY NOTICE: This e-mail and any attachments may contain confidential information that is legally privileged. The information is solely for the use of the intended recipient(s). Any disclosure, copying, distribution, or other use of this information is strictly prohibited. If you have received this e-mail in error, please notify the sender by return e-mail and delete this message. ___ 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/1BY7Hsqx6v/4UXIHC4dyG9jlasy8UHt9D/3.323 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 recipient. Liability limited by a scheme approved under Professional Standards Legislation. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] Uvsh exit status and @SYSTEM.RETURN.CODE
You might be able to use the ENVIRONMENT command in UV to set an environment variable, and test its value upon return to your shell. Something like: EXECUTE ENVIRONMENT SET UVRC=:@SYSTEM.RETURN.CODE will set the value. Gregor -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Phil Walker Sent: Thursday, 17 March 2011 8:25 AM To: U2 Users List Subject: Re: [U2] [UV] Uvsh exit status and @SYSTEM.RETURN.CODE Thanks Brad, That idea had crossed my mind, alternatively capturing some output as this is a non-interactive process but liked the simplicity of @SYSTEM.RETURN.CODE Maybe Mark Baldridge would have some ideas being the expert he is and an old colleague at VMARK last century ;-) But I suspect the @SYSTEM.RETURN.CODE is getting lost inside the uvsh executable and not returned to UNIX Cheers -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of bradley.sch...@usbank.com Sent: Thursday, 17 March 2011 10:20 a.m. To: U2 Users List Subject: Re: [U2] [UV] Uvsh exit status and @SYSTEM.RETURN.CODE Phil, I wrestled with this one quite a while a few years back under ud.. Never figured out a code-only solution. Ended up writing exit codes to a text file that the script reads when the program completes. If noone has any other ideas you like, ping me and I can explain what I did. Brad. From: Phil Walker p...@gnosys.co.nz To: U2 Users List u2-users@listserver.u2ug.org Date: 03/16/2011 04:02 PM Subject:[U2] [UV] Uvsh exit status and @SYSTEM.RETURN.CODE Sent by:u2-users-boun...@listserver.u2ug.org Hi all, I am trying to detect the success of failure of a BASIC program when running from UNIX. I was going to use @SYSTEM.RETURN.CODE setting to do this, hoping that the exit status of uvsh would reflect the value set for @SYSTEM.RETURN.CODE but it appears this is not the case. Does anyone know if this works and I am just missing something silly? Possibly VOC entry process mode setting or something? e.g. uvsh MYBASICPROGRAM SUCCESS would return exit status of 0 uvsh MYBASICPROGRAM FAILURE would return exit status 1 uvsh MYBASICPROGRAM would return 9 SUBROUTINE MYBASICPROGRAM @SYSTEM.RETURN.CODE = 9 Get(Arg.) EXITSTATUS ELSE STOP BEGIN CASE CASE EXITSTATUS = 'SUCCESS' @SYSTEM.RETURN.CODE = 0 CASE EXITSTATUS = FAILURE' @SYSTEM.RETURN.CODE = 1 END CASE RETURN This is a contrived example, but shows what I am trying to do with @SYSTEM.RETURN.CODE. Cheers Phil. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ 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 -- 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/1BULLlroVk/1rQ0ecbGO8cCUDpILHYDxQ/0 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 recipient. Liability limited by a scheme approved under Professional Standards Legislation. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Is this worth rewriting?
A suggestion: Raise the @VM to @AM to improve dynamic array performance. Attribute lookups are way faster than value lookups, and you have already extracted the data to a new variable MONTHLY.USAGE: CM = MONTH + LY.CNT P12.101 = RAISE(PARMS(12)101) P12.133 = RAISE(PARMS(12)133) P12.134 = RAISE(PARMS(12)134) P7.100 = RAISE(PARMS(7)100) P7.101 = RAISE(PARMS(7)101) P7.102 = RAISE(PARMS(7)102) FOR M = 1 TO 12 CUMO(M) = P12.101CM + P12.133CM + P12.134CM IF P7.100CM = '' THEN CUMO(M) += P12.101CM END ELSE CUMO(M) += P7.100CM END IF P7.101CM = '' THEN CUMO(M) += P12.133CM END ELSE CUMO(M) += P7.101CM END IF P7.102CM = '' THEN CUMO(M) += P12.134CM END ELSE CUMO(M) += P7.102CM END NEXT M RETURN -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Allen E. Elwood Sent: Thursday, 3 March 2011 2:22 PM To: 'U2 Users List' Subject: Re: [U2] Is this worth rewriting? All right, I just went ahead and rewrote this the way I would do it since I haven't written a single bit of code since I got laid off at the end of September. And I did it while my wife and I are watching Judge Judy - it was *fun* :-) Granted I can't use real var names since I don't know what these are, but using a simple var name replacement scheme, this illustrates what I would consider the least amount of overhead for this. A) reduced the overhead on the repetitive calls to over 100 attrs. The system needs to look at *every single byte* in the record until it gets to attr desired. If these are 25,000 byte records this would be a HUGE amount of needless throughput which you can calc by (iterations - 2) * average bytes to read before attr needed * number of times the statement is used in the loop B) Yup, got rid of the #. Not only does this make more sense, but # is REALLY doing two comparisons: and C) Got rid of the leading 7 digit indent to make it more readable D) I don't see the necessity of testing three vars to see if they aren't zero before adding them together. If they are zero, the equation will work. If they are not zero, the equation will work. I can see maybe doing that if the equation was doing any dividing to avoid the can't divide by zero error, but not on adding. E) I always make all my IF's block IF's to stub them out for future dev, as well as to make them easier to read. So I did that at the bottom even though it was just for one add stmt. F) My eyes are really getting old. I need spaces between VARs and operands so they don't smush together. So I spaced accordingly to make everything just a tad more readable as well. Now, this takes more lines of code. But many times more lines of code can be way faster than fewer lines of code especially if the extra lines of code are OUTSIDE of the loop. MONTHLY.USAGE: CM = MONTH + LY.CNT P12.101 = PARMS(12)101 P12.133 = PARMS(12)133 P12.134 = PARMS(12)134 P7.100 = PARMS(7)100 P7.101 = PARMS(7)101 P7.102 = PARMS(7)102 FOR M = 1 TO 12 CUM(M) = P12.1011,CM + P12.1331,CM + P12.1341,CM IF P7.1001,CM = '' THEN CUMO(M) += P12.1011,CM END ELSE CUMO(M) += P7.1001,CM END IF P7.1011,CM = '' THEN CUMO(M) += P12.1331,CM END ELSE CUMO(M) += P7.1011,CM END IF P7.1021,CM = '' THEN CUMO(M) += P12.1341,CM END ELSE CUMO(M) += P7.1021,CM END CM -= 1 IF CM = 0 THEN CM = 24 END NEXT M PARMS(12)101 = P12.101 PARMS(12)133 = P12.133 PARMS(12)134 = P12.134 PARMS(7)100 = P7.100 PARMS(7)101 = P7.101 PARMS(7)102 = P7.102 RETURN -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Keith Johnson [DATACOM] Sent: Wednesday, March 02, 2011 4:47 PM To: 'u2-users@listserver.u2ug.org' Subject: Re: [U2] Is this worth rewriting? Agreed that the dimensioned extract wouldn't make much difference, still the attributes numbers are quite high. The code below goes from 15 extracts maximum per for-next loop to 6. I can't help but think this might mean something if it takes 90 minutes to run. 001: MONTHLY.USAGE: 002: CM = MONTH + LY.CNT 003: FOR M = 1 TO 12 004: TEA = PARMS(12)101,CM 005: EAT = PARMS(12)133,CM 006: ATE = PARMS(12)134,CM 007: IF TEA # '' OR EAT # '' OR ATE # '' THEN CUM(M) = TEA + EAT + ATE 008: YAM = PARMS(7)100,CM 009: AMY = PARMS(7)101,CM 010: MYA = PARMS(7)102,CM 011: IF YAM # '' OR AMY # '' OR MYA # '' THEN 012: IF YAM # '' THEN CUMO(M) += YAM ELSE CUMO(M) += TEA 013: IF AMY # '' THEN CUMO(M) += AMY ELSE CUMO(M) += EAT 014: IF MYA # '' THEN CUMO(M) += MYA ELSE CUMO(M) += ATE 015: END 016: CM -= 1 ; IF CM = 0 THEN CM = 24 017: NEXT M 018: RETURN So I'd say AYE - or YEA, if you use meaningful variables Regards, Keith ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Is this worth rewriting?
The other thing to try, though not really a performance improvement, is the following: Replace: IF P7.100CM = '' THEN CUMO(M) += P12.101CM END ELSE CUMO(M) += P7.100CM END IF P7.101CM = '' THEN CUMO(M) += P12.133CM END ELSE CUMO(M) += P7.101CM END IF P7.102CM = '' THEN CUMO(M) += P12.134CM END ELSE CUMO(M) += P7.102CM END with CUMO(M) += (IF P7.100CM = '' THEN P12.101CM ELSE P7.100CM) CUMO(M) += (IF P7.101CM = '' THEN P12.133CM ELSE P7.101CM) CUMO(M) += (IF P7.102CM = '' THEN P12.134CM ELSE P7.102CM) Gregor -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Gregor Scott Sent: Thursday, 3 March 2011 3:13 PM To: U2 Users List Subject: Re: [U2] Is this worth rewriting? A suggestion: Raise the @VM to @AM to improve dynamic array performance. Attribute lookups are way faster than value lookups, and you have already extracted the data to a new variable MONTHLY.USAGE: CM = MONTH + LY.CNT P12.101 = RAISE(PARMS(12)101) P12.133 = RAISE(PARMS(12)133) P12.134 = RAISE(PARMS(12)134) P7.100 = RAISE(PARMS(7)100) P7.101 = RAISE(PARMS(7)101) P7.102 = RAISE(PARMS(7)102) FOR M = 1 TO 12 CUMO(M) = P12.101CM + P12.133CM + P12.134CM IF P7.100CM = '' THEN CUMO(M) += P12.101CM END ELSE CUMO(M) += P7.100CM END IF P7.101CM = '' THEN CUMO(M) += P12.133CM END ELSE CUMO(M) += P7.101CM END IF P7.102CM = '' THEN CUMO(M) += P12.134CM END ELSE CUMO(M) += P7.102CM END NEXT M RETURN -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Allen E. Elwood Sent: Thursday, 3 March 2011 2:22 PM To: 'U2 Users List' Subject: Re: [U2] Is this worth rewriting? All right, I just went ahead and rewrote this the way I would do it since I haven't written a single bit of code since I got laid off at the end of September. And I did it while my wife and I are watching Judge Judy - it was *fun* :-) Granted I can't use real var names since I don't know what these are, but using a simple var name replacement scheme, this illustrates what I would consider the least amount of overhead for this. A) reduced the overhead on the repetitive calls to over 100 attrs. The system needs to look at *every single byte* in the record until it gets to attr desired. If these are 25,000 byte records this would be a HUGE amount of needless throughput which you can calc by (iterations - 2) * average bytes to read before attr needed * number of times the statement is used in the loop B) Yup, got rid of the #. Not only does this make more sense, but # is REALLY doing two comparisons: and C) Got rid of the leading 7 digit indent to make it more readable D) I don't see the necessity of testing three vars to see if they aren't zero before adding them together. If they are zero, the equation will work. If they are not zero, the equation will work. I can see maybe doing that if the equation was doing any dividing to avoid the can't divide by zero error, but not on adding. E) I always make all my IF's block IF's to stub them out for future dev, as well as to make them easier to read. So I did that at the bottom even though it was just for one add stmt. F) My eyes are really getting old. I need spaces between VARs and operands so they don't smush together. So I spaced accordingly to make everything just a tad more readable as well. Now, this takes more lines of code. But many times more lines of code can be way faster than fewer lines of code especially if the extra lines of code are OUTSIDE of the loop. MONTHLY.USAGE: CM = MONTH + LY.CNT P12.101 = PARMS(12)101 P12.133 = PARMS(12)133 P12.134 = PARMS(12)134 P7.100 = PARMS(7)100 P7.101 = PARMS(7)101 P7.102 = PARMS(7)102 FOR M = 1 TO 12 CUM(M) = P12.1011,CM + P12.1331,CM + P12.1341,CM IF P7.1001,CM = '' THEN CUMO(M) += P12.1011,CM END ELSE CUMO(M) += P7.1001,CM END IF P7.1011,CM = '' THEN CUMO(M) += P12.1331,CM END ELSE CUMO(M) += P7.1011,CM END IF P7.1021,CM = '' THEN CUMO(M) += P12.1341,CM END ELSE CUMO(M) += P7.1021,CM END CM -= 1 IF CM = 0 THEN CM = 24 END NEXT M PARMS(12)101 = P12.101 PARMS(12)133 = P12.133 PARMS(12)134 = P12.134 PARMS(7)100 = P7.100 PARMS(7)101 = P7.101 PARMS(7)102 = P7.102 RETURN -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Keith Johnson [DATACOM] Sent: Wednesday, March 02, 2011 4:47 PM To: 'u2-users@listserver.u2ug.org' Subject: Re: [U2] Is this worth rewriting? Agreed that the dimensioned extract wouldn't make much difference, still the attributes numbers are quite high. The code below goes from 15 extracts maximum per for-next loop to 6. I can't help but think this might mean something if it takes 90 minutes to run. 001: MONTHLY.USAGE: 002: CM = MONTH + LY.CNT 003
Re: [U2] Is this worth rewriting?
Which is where the -T option on the BASIC statement comes in handy, though debugging then become s much harder. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan McGrath Sent: Thursday, 3 March 2011 4:24 PM To: U2 Users List Subject: Re: [U2] Is this worth rewriting? Actually, (at least in UniData) it is a performance improvement :). It has to do with how BASIC compiles the code into the object file and tags each line with a line number. Each time it jumps to a line or progresses to the next it must process the line number to update it for when it shows errors/warnings etc. By reducing the number of lines the instructions are on, you actually end up with both smaller object code and faster execution. How much though depends on how tight your looping and all but 99%+ cases the difference is dwarfed by disk access times, etc as to make it not worth it as a human optimisation task. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Gregor Scott Sent: Thursday, 3 March 2011 4:16 PM To: U2 Users List Subject: Re: [U2] Is this worth rewriting? The other thing to try, though not really a performance improvement, is the following: Replace: IF P7.100CM = '' THEN CUMO(M) += P12.101CM END ELSE CUMO(M) += P7.100CM END IF P7.101CM = '' THEN CUMO(M) += P12.133CM END ELSE CUMO(M) += P7.101CM END IF P7.102CM = '' THEN CUMO(M) += P12.134CM END ELSE CUMO(M) += P7.102CM END with CUMO(M) += (IF P7.100CM = '' THEN P12.101CM ELSE P7.100CM) CUMO(M) += (IF P7.101CM = '' THEN P12.133CM ELSE P7.101CM) CUMO(M) += (IF P7.102CM = '' THEN P12.134CM ELSE P7.102CM) Gregor -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Gregor Scott Sent: Thursday, 3 March 2011 3:13 PM To: U2 Users List Subject: Re: [U2] Is this worth rewriting? A suggestion: Raise the @VM to @AM to improve dynamic array performance. Attribute lookups are way faster than value lookups, and you have already extracted the data to a new variable MONTHLY.USAGE: CM = MONTH + LY.CNT P12.101 = RAISE(PARMS(12)101) P12.133 = RAISE(PARMS(12)133) P12.134 = RAISE(PARMS(12)134) P7.100 = RAISE(PARMS(7)100) P7.101 = RAISE(PARMS(7)101) P7.102 = RAISE(PARMS(7)102) FOR M = 1 TO 12 CUMO(M) = P12.101CM + P12.133CM + P12.134CM IF P7.100CM = '' THEN CUMO(M) += P12.101CM END ELSE CUMO(M) += P7.100CM END IF P7.101CM = '' THEN CUMO(M) += P12.133CM END ELSE CUMO(M) += P7.101CM END IF P7.102CM = '' THEN CUMO(M) += P12.134CM END ELSE CUMO(M) += P7.102CM END NEXT M RETURN -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Allen E. Elwood Sent: Thursday, 3 March 2011 2:22 PM To: 'U2 Users List' Subject: Re: [U2] Is this worth rewriting? All right, I just went ahead and rewrote this the way I would do it since I haven't written a single bit of code since I got laid off at the end of September. And I did it while my wife and I are watching Judge Judy - it was *fun* :-) Granted I can't use real var names since I don't know what these are, but using a simple var name replacement scheme, this illustrates what I would consider the least amount of overhead for this. A) reduced the overhead on the repetitive calls to over 100 attrs. The system needs to look at *every single byte* in the record until it gets to attr desired. If these are 25,000 byte records this would be a HUGE amount of needless throughput which you can calc by (iterations - 2) * average bytes to read before attr needed * number of times the statement is used in the loop B) Yup, got rid of the #. Not only does this make more sense, but # is REALLY doing two comparisons: and C) Got rid of the leading 7 digit indent to make it more readable D) I don't see the necessity of testing three vars to see if they aren't zero before adding them together. If they are zero, the equation will work. If they are not zero, the equation will work. I can see maybe doing that if the equation was doing any dividing to avoid the can't divide by zero error, but not on adding. E) I always make all my IF's block IF's to stub them out for future dev, as well as to make them easier to read. So I did that at the bottom even though it was just for one add stmt. F) My eyes are really getting old. I need spaces between VARs and operands so they don't smush together. So I spaced accordingly to make everything just a tad more readable as well. Now, this takes more lines of code. But many times more lines of code can be way faster than fewer lines of code especially if the extra lines of code are OUTSIDE of the loop. MONTHLY.USAGE: CM = MONTH + LY.CNT P12.101 = PARMS(12)101 P12.133 = PARMS(12)133 P12.134
Re: [U2] UUID [was Data in Dict]
The use of both the @USER.NO and the current PID ensure the UUID is unique across the installation, and the presence of the UV system id makes the UUID unique between systems. The named common ensures the current port does not generate the same UUID within the same second/millisecond. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of u2ug Sent: Thursday, 27 January 2011 11:19 PM To: U2 Users List Subject: Re: [U2] UUID [was Data in Dict] This is only guaranteed to be unique per process due to the usage of named common. Different processes running on the same system could generate duplicate values. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Gregor Scott Sent: January 26, 2011 07:35 PM To: U2 Users List Subject: Re: [U2] UUID [was Data in Dict] Interesting trade-off between the overhead of calculating a unique-yet compact sequential number and calculating a consistently long UUID. We use the last-number-stored-in-a-file method. We recently had need for a UUID as part of an XML exchange with a third party. I looked at the various options available, and eventually ended up writing a UV subroutine to create a UUID in v4 format. It is not overly complex - the hardest part was working out the bit manipulations needed. The result is unique across UV systems due to the use of the UV system id. - subroutine MAKE.UUID( UUID ) * * This subroutine generates a version 4 UUID, following the * rules outlined in the RFC found here: * http://tools.ietf.org/html/rfc4122.html * common /UUID$GEN/ UUID$lastgen if unassigned(UUID$lastgen) then UUID$lastgen = '' DECLARE GCI getpid time.NOW = system(12) date.NOW = date() date.BASE = iconv( 15 Oct 1582, D) * We need to determine the accuracy of the time value * From this we derive the appropriate factor to apply to * convert our time from seconds/milliseconds to nanoseconds if index( time.NOW, ., 1) then * The TIME.MILLISECOND compiler option is NOT active time.NOW = time.NOW * 1 nano.FACTOR = 10 time.PERDAY = 86400 * 1 end else * The TIME.MILLISECOND compiler option IS active nano.FACTOR = 100 time.PERDAY = 86400 * 1000 end * We need to ensure we can cope if we create more than 1 UUID * in the same millisecond. this.STAMP = date.NOW:-:time.NOW * Need to use 'compare' on large 'numbers'. * A result of 0 means they are equal if compare( this.STAMP, field( UUID$lastgen, ., 1)) = 0 then * We have already created one this (milli)second. TAIL = oconv( field( UUID$lastgen, ., 2), MCN) + 0 if TAIL then TAIL += 1 this.STAMP = fieldstore( UUID$lastgen, ., 2, 1, TAIL) end else TAIL = 1 this.STAMP := .1 end time.NOW += (TAIL / 10) end * Track our latest generation UUID$lastgen = this.STAMP * Now we can build our UUID time.UUID = ((date.NOW - date.BASE) * time.PERDAY) + time.NOW nano.UUID = time.UUID * nano.FACTOR port.NOW = abs(@USERNO) port.HEX = oconv( port.NOW, MCDX)R%4 ver.VAL = rnd(65535) ver.VAL = bitreset( ver.VAL, 12) ver.VAL = bitset( ver.VAL, 13) ver.VAL = bitreset( ver.VAL, 14) ver.VAL = bitreset( ver.VAL, 15) ver.HEX = oconv( ver.VAL, MCDX) rnd.VAL = rnd(255) rsvd.VAL = bitset( rnd.VAL, 6) rsvd.VAL = bitreset( rsvd.VAL, 7) rsvd.HEX = oconv( rsvd.VAL, MCDX) sysid.HEX = oconv( system(31), MCDX)R%6 pid.NOW = getpid() pid.HEX = oconv( pid.NOW, MCDX)R%6 * UUID Structure * 1 = time-low : 8 char hex value for time * 2 = time-mid : 4 char hex value * 3 = time-hi-and_version : 4 char hex value * 4 = clock-seq-and-reserved : 2 char hex value : clock-seq-low : 2 char hex value * 5 = node : 12 char hex value UUID = '' UUID1 = oconv(nano.UUID, MCDX)R%8 UUID2 = port.HEX UUID3 = ver.HEX UUID4 = rsvd.HEX:oconv(rnd(255), MCDX)R%2 UUID5 = sysid.HEX:pid.HEX convert @AM to - in UUID return - -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan McGrath Sent: Thursday, 27 January 2011 10:46 AM To: U2 Users List Subject: Re: [U2] UUID [was Data in Dict] We also are using a form of UUID instead of sequential numbering on most of our new files. A lot easier to handle and makes maintenance easier. Thanks for the Stuart, I wasn't aware of that. For those using UniData, you can use the VOC as follows instead: UUID 0001 S 0002 !/etc/ncs/uuid_gen -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Boydell, Stuart Sent: Thursday, 27 January 2011 10:07 AM To: U2 Users List Subject: Re: [U2] UUID [was Data in Dict] Most OSs have a call available for generating a UUID (Universally Unique ID) or GUID (Microsoft's acronym for Globally Unique ID). By definition and accepted
Re: [U2] UUID [was Data in Dict]
Interesting trade-off between the overhead of calculating a unique-yet compact sequential number and calculating a consistently long UUID. We use the last-number-stored-in-a-file method. We recently had need for a UUID as part of an XML exchange with a third party. I looked at the various options available, and eventually ended up writing a UV subroutine to create a UUID in v4 format. It is not overly complex - the hardest part was working out the bit manipulations needed. The result is unique across UV systems due to the use of the UV system id. - subroutine MAKE.UUID( UUID ) * * This subroutine generates a version 4 UUID, following the * rules outlined in the RFC found here: * http://tools.ietf.org/html/rfc4122.html * common /UUID$GEN/ UUID$lastgen if unassigned(UUID$lastgen) then UUID$lastgen = '' DECLARE GCI getpid time.NOW = system(12) date.NOW = date() date.BASE = iconv( 15 Oct 1582, D) * We need to determine the accuracy of the time value * From this we derive the appropriate factor to apply to * convert our time from seconds/milliseconds to nanoseconds if index( time.NOW, ., 1) then * The TIME.MILLISECOND compiler option is NOT active time.NOW = time.NOW * 1 nano.FACTOR = 10 time.PERDAY = 86400 * 1 end else * The TIME.MILLISECOND compiler option IS active nano.FACTOR = 100 time.PERDAY = 86400 * 1000 end * We need to ensure we can cope if we create more than 1 UUID * in the same millisecond. this.STAMP = date.NOW:-:time.NOW * Need to use 'compare' on large 'numbers'. * A result of 0 means they are equal if compare( this.STAMP, field( UUID$lastgen, ., 1)) = 0 then * We have already created one this (milli)second. TAIL = oconv( field( UUID$lastgen, ., 2), MCN) + 0 if TAIL then TAIL += 1 this.STAMP = fieldstore( UUID$lastgen, ., 2, 1, TAIL) end else TAIL = 1 this.STAMP := .1 end time.NOW += (TAIL / 10) end * Track our latest generation UUID$lastgen = this.STAMP * Now we can build our UUID time.UUID = ((date.NOW - date.BASE) * time.PERDAY) + time.NOW nano.UUID = time.UUID * nano.FACTOR port.NOW = abs(@USERNO) port.HEX = oconv( port.NOW, MCDX)R%4 ver.VAL = rnd(65535) ver.VAL = bitreset( ver.VAL, 12) ver.VAL = bitset( ver.VAL, 13) ver.VAL = bitreset( ver.VAL, 14) ver.VAL = bitreset( ver.VAL, 15) ver.HEX = oconv( ver.VAL, MCDX) rnd.VAL = rnd(255) rsvd.VAL = bitset( rnd.VAL, 6) rsvd.VAL = bitreset( rsvd.VAL, 7) rsvd.HEX = oconv( rsvd.VAL, MCDX) sysid.HEX = oconv( system(31), MCDX)R%6 pid.NOW = getpid() pid.HEX = oconv( pid.NOW, MCDX)R%6 * UUID Structure * 1 = time-low : 8 char hex value for time * 2 = time-mid : 4 char hex value * 3 = time-hi-and_version : 4 char hex value * 4 = clock-seq-and-reserved : 2 char hex value : clock-seq-low : 2 char hex value * 5 = node : 12 char hex value UUID = '' UUID1 = oconv(nano.UUID, MCDX)R%8 UUID2 = port.HEX UUID3 = ver.HEX UUID4 = rsvd.HEX:oconv(rnd(255), MCDX)R%2 UUID5 = sysid.HEX:pid.HEX convert @AM to - in UUID return - -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan McGrath Sent: Thursday, 27 January 2011 10:46 AM To: U2 Users List Subject: Re: [U2] UUID [was Data in Dict] We also are using a form of UUID instead of sequential numbering on most of our new files. A lot easier to handle and makes maintenance easier. Thanks for the Stuart, I wasn't aware of that. For those using UniData, you can use the VOC as follows instead: UUID 0001 S 0002 !/etc/ncs/uuid_gen -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Boydell, Stuart Sent: Thursday, 27 January 2011 10:07 AM To: U2 Users List Subject: Re: [U2] UUID [was Data in Dict] Most OSs have a call available for generating a UUID (Universally Unique ID) or GUID (Microsoft's acronym for Globally Unique ID). By definition and accepted generation standards these are almost guaranteed (!) to be unique (the probability of a clash is extremely small) across all computers. In UV you could use GCI to create a UV verb to invoke the OS call. Or just create a VOC item which you can execute and capture. There are usually options which affect the format of the output. For AIX the VOC item might look like this: UUID 0001 V 0002 /etc/ncs/uuid_gen 0003 U 0004 CGHIM For Linux use: /usr/bin/uuidgen For Windows (not installed by default): guidgen HTH -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Wolverton Sent: Thursday, 27 January 2011 01:55 To: 'U2 Users List' Subject: Re: [U2] Data in Dict I'm curious what your logic is to generate the Unique ID -- can you share that without giving away a trade secret?? It's too bad it's not a database function call in
Re: [U2] Reading a Unix file from another machine.
You could try converting the ^M (carriage return) into a linefeed using the command: cat master | tr \r \n | new.master And cating the file might not be a true indication of your ability to open and read the file within UV/UD. The vt100 view indicates that the content is legible. The vt220 emulation is corrupting the *view* of the content and is not a true reflection of the contents. Converting the carriage return to a linefeed will make the file more usable in unix. Gregor -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Roy Beard Sent: Wednesday, 10 November 2010 9:27 AM To: 'U2 Users List' Subject: Re: [U2] Reading a Unix file from another machine. # cat master | more °³üªü·¶ üªüªü ü ü ü ü ü ü ü ü M-^M° üªü·¶ üªüªü ü ü ü ü ü ü ü ü M-^M°µüªü·¶ üªü ü ü ü ü ü ü ü M-^M°¶üªü·¶ üªüªü ü ü ü ü ü ü ü ü M-^M°·üªü·¶ üªüªü ü ü ü ü ü ü üM ° üªü·¶ üªüªü ü ü ü ü ü ü ü ü M-^M°¹üªü·¶ üªüªü ü ü ü ü ü ü ü ü M-^M°³üªüÌDz°²Íü °°± ³°üü ü ü ü ü ü ü M-^M° üªüÌDz°²Íüªüªü°°± ³°ü ü ü ü ü ü ü M-^M°µüªüÌDz°²Íüªüªü°°± ³°üü ü ü ü ü ü ü M-^M°¶üªüÌÍ üªüªü°°± ³°üü ü ü ü ü ü ü M-^M°·üªüÌDz°²Íüªüªü°°± ³°ü ü ü ü ü ü ü ü M-^M° üªüÌDz°²Íüªüªü°°± ³°üü ü ü ü ü ü ü M-^M°Ì Dz°²Íüªüªü°°± ³°üü ü ü ü ü ü ü M-^M° üªüÔdz³³ ÚÕÒÎüªüªü°°± ¹ ü ü ü ü ü ü ü M-^M°¹üªüÔdz³³ ÚÕÒÎüªüªü°°± ¹ ü ü ü ü ü ü ü ü M-^M°³üªüÔdz³³ ÚÕÒÎüªü± ¹ ü ü ü ü ü ü ü ü M-^M° üªüÔdz³³ ÚÕÒÎüªüªü°°± ¹ ü ü ü ü ü ü ü ü M-^M°µüªüÔdz³³Î üªüªü°°± ¹ ü ü ü ü ü ü ü ü M-^M°¶üªüÔdz³³ ÚÕÒÎüªüªü°°± ¹ ü ü ü ü ü ü ü ü M-^M°·Ç ³³³ ÚÕÒÎüªüªü°°± ¹ ü ü ü ü ü ü ü ü M-^M°±ü±ü ËÏÈÌÅÒ± ÒÅÍÉÅÒüÎÏÎ ÉÎÖÅÎÔÏÒÙ ÉÔÅÍü ü ü ü ü ü ü ü ü M-^M°²ü±ü ËÏÈÌÅÒ± ÒÅÍÉÅÒüÎÏÎ ÉÎÖÅÎÔÏÒÙ ÉÔÅÍü ü ü ü ü ü ü ü ü M-^M°±ü±ü ËÏÈÌÅÒ± ÒÅÍÉÅÒü ÒÅÍÉÅÒ ÆÁÕÃÅÔÓüËÏÈÌÅÒ ÃÁÔ ÈÅÁÄÅÒü°°±³µ°ü ü ü ü ü ü ü M-^M°²ü±ü ËÏÈÌÅÒ± ÒÅÍÉÅÒü ÒÅÍÉÅÒ ÆÁÕÃÅÔÓüËÏÈÌÅÒ ÃÁÔ ÈÅÁÄÅÒü°°±³µ°ü ü ü ü ü ü As vt100 # cat master | more 03|*|764|*|*| | | | | | | | | M-^M08|*|764|*|*| | | | | | | | | M-^M05|*|764|*| | | | | | | | M-^M06|*|764|*|*| | | | | | | | | M-^M07|*|764|*|*| | | | | | | |M 04|*|764|*|*| | | | | | | | | M-^M09|*|764|*|*| | | | | | | | | M-^M03|*|LG202M| 001430|| | | | | | | M-^M08|*|LG202M|*|*|001430| | | | | | | M-^M05|*|LG202M|*|*|001430|| | | | | | | M-^M06|*|LM |*|*|001430|| | | | | | | M-^M07|*|LG202M|*|*|001430| | | | | | | | M-^M04|*|LG202M|*|*|001430|| | | | | | | M-^M0L G202M|*|*|001430|| | | | | | | M-^M04|*|TG333-ZURN|*|*|001894| | | | | | | M-^M09|*|TG333-ZURN|*|*|001894| | | | | | | | M-^M03|*|TG333-ZURN|*|1 894| | | | | | | | M-^M08|*|TG333-ZURN|*|*|001894| | | | | | | | M-^M05|*|TG333N |*|*|001894| | | | | | | | M-^M06|*|TG333-ZURN|*|*|001894| | | | | | | | M-^M07G 333-ZURN|*|*|001894| | | | | | | | M-^M01|1| KOHLER1 PREMIER|NON INVENTORY -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan Goble Sent: Tuesday, November 09, 2010 5:09 PM To: 'u2-users@listserver.u2ug.org' Subject: Re: [U2] Reading a Unix file from another machine. Try using at the unix command line String filename newfilenamer This will strip out all control characters - Original Message - From: Roy Beard [mailto:r...@cfl.rr.com] Sent: Tuesday, November 09, 2010 05:05 PM To: 'U2 Users List' u2-users@listserver.u2ug.org Subject: [U2] Reading a Unix file from another machine. Hi all, I am trying to read a Unix file from and old aix machine. The people who sent it will not bend in how they sent it. What I got was in binary format so I used 'od' to convert it to ascii. When I tried to cat the file before trying to READSEQ records it looked like gibberish! I realized that if I set my Term type to vt100, I could read it but the carriage returns were just ^M after each record. After trying 'sed' I gave up. Universe will not read the file at all. I still get gibberish even on the converted file. Any ideas? There must be a way to do this. What am I missing? Thanks, Roy ___ 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 -- 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/1B4vNP9s6S/4ebGoJHMofhf2Tjg3O0ZOv/0.6 This email and any attachments to it are confidential. You must not use,
Re: [U2] Building XML using the UV XDOM API functions
I actually like the XML handling built into UV. I have always been a believer in using the intrinsic facilities of the database where possible to maximise the performance of the process being automated. The XDOM API is a good example of this, and is a good fit for our requirements. My biggest issue is with the poor state of the documentation. It does not allow me to easily obtain a good level of competency, which I think is needed to feel like I can be productive with a tool, and to feel that the tool is worth using. Once I got past the documentation and did a lot of testing, and raising cases with Rocket Software (the guys here in Australia should now know their XDOM backwards!), I have a much clearer understanding of what is possible and what the limitations are. Which is why I created the blog and started adding entries for various aspects of the XDOM that were not obvious from the documentation. I just hope it helps others get a handle on the XDOM API a bit quicker than I did. It might also allow others to better evaluate the XDOM API as a valid toolset, rather than discount it out of hand due to FUD, or marketing pressures. Gregor -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: Tuesday, 26 October 2010 3:35 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Building XML using the UV XDOM API functions Gregor, your comments serve as a testimonial to support my position against using many of these vendor-supplied toolkits. Some of them are OK, but many not. People insist on the DBMS vendors building stuff for them, but then we get the mess that you've described. For this reason I continue to recommend at least consideration for integration with tools that are outside of the DBMS. DBMS vendors should be focusing on making superior databases, not XML, web services, or a lot of this other fluff. People in the open source and commercial markets spend a great deal of time focused on these things, and because of this, their offerings are often much better. So take a look around and weigh other offerings against the built-in functionality. It would be nice to see people here comparing more toolkits - it might save others from feeling like they're stuck with whatever is provided by the DBMS vendors. T ___ 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/1AYrw4K3L1/76hLrBplQLdEzGQ20K2ljp/0 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 recipient. Liability limited by a scheme approved under Professional Standards Legislation. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Building XML using the UV XDOM API functions
I have recently been involved in a project that gave me my first chance to get acquainted with the UV XDOM API functions. gripe I must say that I was bitterly disappointed with the documentation on the XML functionality in UniVerse 10.2. Nothing more than a simple description of each of the API functions, and no clear example of how to go about getting started. Not to mention the inter-weaving of UniData and UniVerse configurations that lead me into much confusion about what was going on. /gripe Once I got a handle on how things worked, it was obvious that if we were to be building XML docs in code, we would need to create some supporting code to make things easier. I ended up creating a function to add new elements and attributes that made a huge difference. I used a function instead of a subroutine because it fits in easier with the XDOM API function calls, and this makes it easier to adopt. I created a description of the function and its implementation over at http://gdoesu2.wordpress.com/2010/10/25/an-easier-way-to-build-xml-in-universe/, in case anyone else needs a helping hand getting started with manual XML document building. The site also has a few other entries on the quirks/features of the XDOM API functions which might be of interest as well. Regards, Gregor 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 recipient. Liability limited by a scheme approved under Professional Standards Legislation. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Licensing
On UniVerse (10.2 onwards), the uvregen command will tell you if device licensing is active, and the max connections per device. SH $cd `cat /.uvhome` $uvregen -z UniVerse Ver.: 10.2.4 Serial#..: 99887766 Expiry Date..: 1/1/2500 Max Logins...: 162 Device Licn..: Enabled Conn per Dev.: 10 Authorized...: Yes UV master key: SYSTEMICMEZMERISM Package NameUser Limit Expiry Date -UVNET 0 uv -GCI162 1/1/2500 -UCI162 1/1/2500 -UVCS 162 1/1/2500 -UVADM 162 1/1/2500 -UVODBC 162 1/1/2500 -iPHANTOM 162 1/1/2500 -CONNPL 2 1/1/2500 You might need to be root user to run this command, as it relies on the user's access to the .uvconfig file I nthe UniVerse installation directory. The Device Licn setting indicates that it is active. The Conn per Dev setting indicates how many connections from one device will consume 1 database license. NOTE: Each and every connection above this setting from the same device will consume an additional license. With the above setting, an device that established 12 connections will use 3 database licenses. Gregor -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ross Ferris Sent: Friday, 22 October 2010 2:39 PM To: U2 Users List Subject: Re: [U2] Licensing Would depend on the TYPE of licences you have as to wether device licencing would work for you I believe Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of charles_shaf...@ntn-bower.com Sent: Friday, 22 October 2010 6:34 AM To: U2 Users List Cc: U2 Users List; u2-users-boun...@listserver.u2ug.org Subject: Re: [U2] Licensing There has been a lot of discussion about that. If there is a way to take advantage of device licenses or connection pooling, we would like to take a look at that. Charles Shaffer Senior Analyst NTN-Bower Corporation George Gallen ggal...@wyanokegroup.com Sent by: u2-users-boun...@listserver.u2ug.org 10/21/2010 02:28 PM Please respond to U2 Users List To: U2 Users List u2-users@listserver.u2ug.org cc: Subject:Re: [U2] Licensing Shorten the autologout limit? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of charles_shaf...@ntn- bower.com Sent: Thursday, October 21, 2010 3:28 PM To: U2 Users List Cc: U2 Users List; u2-users-boun...@listserver.u2ug.org Subject: Re: [U2] Licensing I think there is some of that, but for the most part they are real. Some folks like to keep 4 or 5 sessions open at a time instead of moving around between screens. Charles Shaffer Senior Analyst NTN-Bower Corporation ___ 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 -- 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/1AWMsrgsiI/5ghGrz6Xtf89aqmIKuCadR/0 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 recipient. Liability limited by a scheme approved under Professional Standards Legislation. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] running ftp from UV (Windows)
George, Have you considered using the GCI functions for dealing with Pipes? The UV GCI manual documents some GCI functions that only work in UV on Windows, and provides an example program for using them. This would allow you to create an interactive program to control and react to the Windows FTP command, rather than the blind execution approach you currently have to use on Unix. And it avoids the need to install additional software. Gregor -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Friday, 3 September 2010 5:00 AM To: U2 Users List Subject: Re: [U2] running ftp from UV (Windows) Using curl is fine, as I can put the usrname/passwd in the command line and not embedded in the batch file. But I'm guessing there isn't anyway to load the input stack like you can with unix. I'm guessing it's been so long since i've used DOS and batch files, I will need to brush up on automating tasks with batch files. Thanks for the code reference, that was helpful. George George Gallen Senior Programmer/Analyst Accounting/Data Division ggal...@wyanokegroup.com ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.com From: u2-users-boun...@listserver.u2ug.org [u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny [jscha...@gmail.com] Sent: Thursday, September 02, 2010 1:47 PM To: U2 Users List Subject: Re: [U2] running ftp from UV (Windows) I'll second Tony on this. I have been using cURL for years whenever I need to send/receive data. The HTTP/HTTPS protocol stuff is especially good because you can manipulate the HTTP headers. I have a couple FTP routines (for a Windows based system but easily adapted for Unix) using cURL here: http://www.schasny.com/BP/FTP.SEND http:/www.schasny.com/BP/FTP.GET Also, if you are REALLY against writing out a command file,you could put a bunch of commands together on one line using command separators (';' in Unix and '' in Windows) Tony Gravagno wrote: Having written FTP interfaces with MV before (in production use at end-user sites) my recommendation is that you shift to cURL. - It's a high quality utility, - well supported, - does much more than FTP, - adapts to Secure FTP without you having yet again go learn a new utility, - cross-platform, - easy to install - well documented, - and free. Because it's cross-platform the only changes to your app code that are required would be making sure that you have your directories identified properly with proper slashes, and other OS-specific details. But cURL itself, unlike FTP, works exactly the same on all platforms. And no, I don't sell it or get a commission for referrals. *sigh* ;) http://curl.haxx.se/ HTH T From: George Gallen Currently I use something like: (Using Universe under Unix) CMD=ftp -n EOF [snip] EXECUTE sh -c ':CMD:' CAPTURING JUNK Is there a way to do this in Windows as well? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot 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 -- 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/1ACtSCXfDL/2E64d7Muny9obxumAjN2He/1.6 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 recipient. Liability limited by a scheme approved under Professional Standards Legislation. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UD] UniRPC Port#
Hi Bill. Have you looked at port-mapping on the firewall? This allows port 31439 at the firewall to be mapped to port 31438 on the second UD machine, alleviating the need to re-locate the UniRPC port on the second server. Gregor -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Monday, 30 August 2010 8:48 AM To: U2 Users List Subject: Re: [U2] [UD] UniRPC Port# The problem I'm having is I have two machines, inside a firewall and on a single network, running UniData. I want to get access, using uo.net, to each machine. I have a single IP address. Thus, I'd have to be able to start the unirpc service on each machine using a different port (one 31438 and one 31439, for example). Then, I'd have to figure out how to get the UO client to make a call using one or the other port#s. Is this possible? I know, when I'm using UniAdmin, I can create a connection to a U2 dbms server and specify the port#. Does this only apply to UV? Thanks, Bill Bill Haskett said the following on 8/29/2010 3:13 PM: In UniData (on Windows) the default unirpc port is 31438. Can I change this? It seems I can in UV but not on UD. How can this be? The E:\IBM\unishared\unirpc\uniprcservices file doesn't include the port... udcs E:\IBM\ud\bin\udapi_server.exe * TCP/IP 0 300 defcs E:\IBM\ud\bin\udapi_server.exe * TCP/IP 0 300 udserver E:\IBM\ud\bin\udsrvd.exe * TCP/IP 0 3600 udadmin E:\IBM\ud\bin\udadmin_server.exe * TCP/IP 0 3600 udadmin72 E:\IBM\ud\bin\udadmin_server.exe * TCP/IP 0 3600 unirep72 E:\IBM\ud\bin\udsub.exe * TCP/IP 0 3600 rmconn72 E:\IBM\ud\bin\repconn.exe * TCP/IP 0 3600 Any help would be appreciated. Bill ___ 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 -- 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/1AATdbcpvt/3QKUUCNoGdNyGG7nSuJOVz/0.602 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 recipient. Liability limited by a scheme approved under Professional Standards Legislation. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Sending interrupt to UniBasic program
Brad, I'm not familiar with UD, but in UV it is possible to change the break key (character). Try changing the break char from ctrl-c to something else to see if the ctrl-c then gets passed to the PROG1 program. Gregor -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of bradley.sch...@usbank.com Sent: Wednesday, 11 August 2010 1:50 AM To: u2-users@listserver.u2ug.org Subject: [U2] Sending interrupt to UniBasic program All, I'm hoping the bit-heads in the group can help me out with this one. It's kind of difficult to explain, but I'll try my best. My apologies for any lack of clarity. What we're trying to do is automate a third-party batch process. The automation piece is working well. But there's one requirement that's proving problematic, with two key requirements at play. First, batch process must run automagically and completely unattended. Second, operators must have the option to interact directly with the automated batch for trouble-shooting purposes. The second requirement is what's presenting the challenge. Since we need to be able to directly interact with the batch process, we can't use a phantom, since any keyboard I/O causes a phantom to terminate. The solution we chose was to run everything under GNU Screen. If you aren't familiar with Screen, here's a one sentence description from our friends at GNU -- Screen is a full-screen window manager that multiplexes a physical terminal between several processes, typically interactive shells. You can check http://www.gnu.org/software/screen for more info. I think of Screen as a terminal emulator that runs locally on the server. So if you start screen and then launch UniData from within your screen session, you are safe if the connection from your workstation is dropped; everything continues to run on the server. You just need to issue a command to reconnect to your screen session and you're back in business. Very handy tool. If the batch runs with no issues, this works well. But if we need to diagnose a run-time issue, e.g. a process appears to be hung, we need to do things like send ctrl-c to break the current program. This is where the problem comes in. Screen seems to be sending ctrl-c (or any other interrupt, for that matter) to udt, not the program that is running under udt. This causes the udt session to end which kills the batch process when all we want to do is get to the debug prompt. Questions to the Screen users group have not generated helpful answers. Here's an attempt at an illustration of what I'm talking about. Nesting indicates that a process is running under the outer process. Non-Automated: Can press ctrl-c while PROG1 is running to get to debug prompt AIX udt PROG1 Automated: Ctrl-c and AIX kill's are directed to udt, not PROG1 AIX screen udt PROG1 Does anyone have any thoughts on how to resolve this? My hope is that there's a way to send an interrupt from outside that will be directed towards a specific program. Environment info: AIX 5.3 UniData 7.1 TIA, Brad U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ 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/1AsWsnCEGR/7usjQpChsH1mcrVjkxlz5x/0 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 recipient. Liability limited by a scheme approved under Professional Standards Legislation. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Filesystem options cio for AIX 5.3
Dan, We have done a lot of work on tuning AIX for UniVerse. I looked into CIO and its potential benefits to UV. I even raised a case with U2 support. Their response was that as CIO essentially eliminates caching updates in memory it requires the update to be physically made to disk before the process can continue. The nature of UV (and possibly UD) updates made U2 support think there would not be much benefit. The biggest improvements we made were to how AIX manages memory and its I/O buffers. The memory changes made a huge different to process paging, and the I/O buffers played a large part in stabilising our I/O activities. These settings are the culmination of taking advised adjustments from various sources and then fine tuning for our UV installations. ___Memory Management Parameter Default New Value Command to Adjustment minperm%20 5 vmo -p -o minperm%=5 maxperm%80 90 vmo -p -o maxperm%=90 maxclient% 80 90 vmo -p -o maxclient%=90 lru_file_repage 1 0 vmo -p -o lru_file_repage=0 page_steal_method 0 1 vmo -p -o page_steal_method=1 ___PBUFS___ pv_min_pbuf 512 4096 ioo -p -o pv_min_pbuf=4096 ___JFS2___ j2_dynamicBufferPreallocation 16 128 ioo -p -o j2_dynamicBufferPreallocation=128 j2_nBufferPerPagerDevice512 8192ioo -p -o j2_nBufferPerPagerDevice=8192 ___JFS___ numfsbufs 196 2048 ioo -p -o numfsbufs=2048 maxpgahead 8 16 ioo -p -o maxpgahead=16 I found the following links very helpful when exploring the AIX performance tuning options: http://www.circle4.com/blosxomjl.cgi/ http://users.ca.astound.net/baspence/AIXtip/j2_buffer.htm This PDF explains the benefits of tuning Memory: http://www.ibm.com/developerworks/wikis/download/attachments/53871915/VMM+Tu ning+Tip+-+Proctecting+Comp+Memory.pdf?version=2 Whilst focused on Oracle, this PDF provides an interesting snippet on page 9: Large hdisks are evil for I/O performance! http://www.circle4.com/papers/PAI22.pdf Hope this helps Gregor -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan Goble Sent: Friday, 4 June 2010 6:51 AM To: U2 Users List Subject: [U2] Filesystem options cio for AIX 5.3 I am working with an AIX 5.3 system using Unidata 7.1.10 We are having some performance issues that are directly related to I/O. The files have been resized and brought down some of the I/O problems. In the past with some Oracle system I have had to administer ( I still prefer the mv world ), we used the cio options for mounting filesystems which allows for concurrent reads and writes. Has anyone tried this with Unidata or know of any pitfalls to doing so. Thanks in advance -Dan ___ 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/1A12oPLg1S/6aKdA6wbF9XEaIVKtBO7mB/3.05 3 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Question about umask
We had the same problem. We had to change all our RPC connection logic so the first thing it does is to run a function (a logon program for UVCS connections) equivalent to the UV.LOGIN so we could trigger the execution of the UMASK for the duration of the RPC connection to UV. This works well for us, and we no longer have the issues of incorrect permissions for created files. Gregor -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Augusto Alonso Sent: Friday, 21 May 2010 4:14 AM To: U2 Users List Subject: [U2] Question about umask Hi. Does anyone know how to change the default UMASK (022) inside a RPC connection? Our UV.LOGIN has a sentence: UMASK 002 and it works from telnet connections. But if I do a EXECUTE CREATE.FILE x from inside a RPC connection, the permissions of the new file are -rw-r--r--. Regards -- Augusto Alonso ___ 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/1zVek3cTyU/1q3yxsfHme6B6P9ROLUMBr/0.6 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Question about umask
We specifically changed our client code to always call our UVCS login subroutine when it first connects. This subroutine then does all the necessary environment massaging and checking to ensure the connection is valid and the environment is right. If you are unable to change your client code to do this, then the only other way is to change the umask within the unix user profile of the user that runs the unix unirpc process (normally either root or uniadm). If this is the root user you need to be VERY careful about changing umask settings, even to the point of considering changing UV to use a non-root user as the UV administrator user and then changing this user's unix profile. Regards, Gregor From: Augusto Alonso [mailto:aalo...@quiter.com] Sent: Friday, 21 May 2010 10:21 AM To: gregor.sc...@pentanasolutions.com; U2 Users List Subject: Re: [U2] Question about umask Hi Gregor. How do you make the call to this routine? Is it made on the server (a PAragraph or something), or is it made by the client? Thanks -- Augusto Alonso 2010/5/21 Gregor Scott gregor.sc...@pentanasolutions.com We had the same problem. We had to change all our RPC connection logic so the first thing it does is to run a function (a logon program for UVCS connections) equivalent to the UV.LOGIN so we could trigger the execution of the UMASK for the duration of the RPC connection to UV. This works well for us, and we no longer have the issues of incorrect permissions for created files. Gregor -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Augusto Alonso Sent: Friday, 21 May 2010 4:14 AM To: U2 Users List Subject: [U2] Question about umask Hi. Does anyone know how to change the default UMASK (022) inside a RPC connection? Our UV.LOGIN has a sentence: UMASK 002 and it works from telnet connections. But if I do a EXECUTE CREATE.FILE x from inside a RPC connection, the permissions of the new file are -rw-r--r--. Regards -- Augusto Alonso ___ 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/1zVek3cTyU/1q3yxsfHme6B6P9ROLUMBr/0.6 ___ 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 Report https://login.mailguard.com.au/report/1zVkQ9dj0o/6IayR89SiiHahPm3fsjela/0.6 02 this message as spam ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Dynamic Connect - Mousing
Bill This is an issue that is also present in the current wIntegrate version (the basis for the DC product). I understand that it is due to an interaction between WINTEG (DC) and the Aero interface of Vista and Win7. Has your boss changed PCs or upgraded OS recently? Gregor -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brutzman, Bill Sent: Wednesday, 7 April 2010 8:21 AM To: U2 Users List Subject: [U2] Dynamic Connect - Mousing An important user here (my boss) likes to use the mouse to move around our green screen applications. Although I have tried to discourage this type of mouse use, he asked me to find the answer. He tells me that this worked at one time. It is not clear to me if I changed our applications or if there were pertinent changes in subsequent releases of DC. When he does things like copy and paste say a six-digit part number such as 101234... When he pastes it, some screens will come back with 10?1234. Of course some screen validate keystroke entries such as... Read the first character of the PN and require it to be a 1 or a 3. Fixes would be appreciated. --Bill ___ 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/1zDbOoAvQC/3vX11UFGrm47fP2MXsFt1m/0 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Is there something wrong with the new wiki?
It must be something to do with my login. A colleague can login and gets access to the wiki. They even have a logout option on the home page. I do not get access to the wiki, nor do I have a logout option on the home page. I'm going to create a new login and see how it goes. Gregor -Original Message- From: Brian Leach [mailto:br...@brianleach.co.uk] Sent: Tuesday, 16 February 2010 8:21 PM To: gregor.sc...@pentanasolutions.com; 'U2 Users List' Subject: RE: [U2] Is there something wrong with the new wiki? Hi Gregor It works for me when logged in.. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Gregor Scott Sent: 16 February 2010 1:23 AM To: 'U2 Users List' Subject: [U2] Is there something wrong with the new wiki? Hello, I am just trying to access the new wiki on the u2ug.org website, and am having trouble seeing anything. First, without logging in I clicked on the New Wiki link which just re-displayed the home page. After logging in, all I see is what looks to be the toolbar, with links and icons for Home, Wiki Home, Bookmarks, History and the Jump to select field. Does anyone else have this view, or does it work for others? Gregor ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.733 / Virus Database: 271.1.1/2689 - Release Date: 02/15/10 07:35:00 -- 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/1ziNv8mOvX/6QX1BdJcQRnAuxQWAGdmc7/0 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Is there something wrong with the new wiki?
new user id, same problems :( -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Gregor Scott Sent: Wednesday, 17 February 2010 11:43 AM To: 'Brian Leach'; 'U2 Users List' Subject: Re: [U2] Is there something wrong with the new wiki? It must be something to do with my login. A colleague can login and gets access to the wiki. They even have a logout option on the home page. I do not get access to the wiki, nor do I have a logout option on the home page. I'm going to create a new login and see how it goes. Gregor -Original Message- From: Brian Leach [mailto:br...@brianleach.co.uk] Sent: Tuesday, 16 February 2010 8:21 PM To: gregor.sc...@pentanasolutions.com; 'U2 Users List' Subject: RE: [U2] Is there something wrong with the new wiki? Hi Gregor It works for me when logged in.. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Gregor Scott Sent: 16 February 2010 1:23 AM To: 'U2 Users List' Subject: [U2] Is there something wrong with the new wiki? Hello, I am just trying to access the new wiki on the u2ug.org website, and am having trouble seeing anything. First, without logging in I clicked on the New Wiki link which just re-displayed the home page. After logging in, all I see is what looks to be the toolbar, with links and icons for Home, Wiki Home, Bookmarks, History and the Jump to select field. Does anyone else have this view, or does it work for others? Gregor ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.733 / Virus Database: 271.1.1/2689 - Release Date: 02/15/10 07:35:00 -- 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/1ziNv8mOvX/6QX1BdJcQRnAuxQWAGdmc7/0 ___ 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/1zj3QI2gEZ/5nlkmnNnBAbYAoHq0ggSyC/2.31 8 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Is there something wrong with the new wiki?
Hello, I am just trying to access the new wiki on the u2ug.org website, and am having trouble seeing anything. First, without logging in I clicked on the New Wiki link which just re-displayed the home page. After logging in, all I see is what looks to be the toolbar, with links and icons for Home, Wiki Home, Bookmarks, History and the Jump to select field. Does anyone else have this view, or does it work for others? Gregor ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Dynamic Connect (Wintegrate) 6.1.0 and Vista; Error Pasting Text
We found it early on in our testing of wInteg 6.1.3. Vista and Windows 7 clients have the behaviour - XP does not. Something to do with the Aero functions in Vista/7. It took a while to be able to provide U2 support with a reproducible scenario, but we eventually succeeded in getting an engineering case opened to deal with it. I'm hoping the wIntegrate 6.2 version going into beta soon will have a fix, because it is a very frustrating phenomenon for developers here. Gregor -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Perry Taylor Sent: Monday, 1 February 2010 8:20 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Dynamic Connect (Wintegrate) 6.1.0 and Vista; Error Pasting Text I, too, have had this happen since going to Windows 7. Perry - Original Message - From: u2-users-boun...@listserver.u2ug.org u2-users-boun...@listserver.u2ug.org To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed Jan 27 00:09:02 2010 Subject: [U2] Dynamic Connect (Wintegrate) 6.1.0 and Vista;Error Pasting Text I just found this post in Nabble and I have exactly the same issue with 6.1.0 on Windows Server 2008 (Vista server). Did anyone find a fix? Stuart --- Noah Hart - Fri, 13 Feb 2009 16:14:39 -0800 We recently upgraded some workstations to Vista, and notice that when we paste text (control-V) into the terminal window, a ? will randomly appear. This happens about 10% of the time Has anyone else seen this? Regards, - Noah Hart Stuart Boydell BI/Reporting Technical Lead Information Services Spotless T +61 3 9269 7398 M +61 4 1115 0246 E stuart.boyd...@spotless.com.au W www.spotless.com ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this communication in error, please reply to this e-mail to notify the sender of its incorrect delivery and then delete it and your reply. It is your responsibility to check this email and any attachments for viruses and defects before opening or sending them on. Spotless collects information about you to provide and market our services. For information about use, disclosure and access, see our privacy policy at http://www.spotless.com.au Please consider our environment before printing this email. ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. ZirMed, Inc. has strict policies regarding the content of e-mail communications, specifically Protected Health Information, any communications containing such material will be returned to the originating party with such advisement noted. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. ___ 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/1zcq07soh5/4H6bYZYscFfc9aLbAu1tRv/0.6 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] RECORDLOCKED statement
The other consideration is that each case statement uses the same RECORDLOCKED(PICH.TX, SO) function reference, meaning it runs the function 3 times (according to your snippet). I would normally assign the function result to a variable and test the variable in the case statements: stat.LOCK = RECORDLOCKED(PICH.TX, SO) CASE stat.LOCK = CASE stat.LOCK = ... Gregor Scott -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of raul_doming...@neimanmarcus.com Sent: Wednesday, 16 December 2009 10:27 AM To: U2 Users List Subject: Re: [U2] RECORDLOCKED statement The only consideration is that your second case statement picks up at -2 instead of -1. I think you are going for CASE RECORDLOCKED(PICH.TX, SO) = LOCK$OTHER.READL which is the -1 return value. At least according to the UniVerse documentation. Regards, Raul Dominguez raul_doming...@neimanmarcus.com 972-401-6502 Baker Hughes baker.hug...@mouser.com Sent by: u2-users-boun...@listserver.u2ug.org 12/15/2009 05:17 PM Please respond to U2 Users List u2-users@listserver.u2ug.org To 'U2 Users List' u2-users@listserver.u2ug.org cc Subject [U2] RECORDLOCKED statement I admit I have never used this little jewel of a [UV] statement, so although the code runs and works as designed, before I load it to production, someone please tell me if there are any nuances that would improve the design/operation. CASE RECORDLOCKED(PICH.TX, SO) = LOCK$MY.READU * This user/process already has a lock on the record, and we DO NOT * WANT to clear the lock if process is ORDER.UPDATE so check the stack. IF INDEX(SYSTEM(9001),ORDER.UPDATE,1) THEN WRITEVU ON PICH.TX, SO, 37 END ELSE WRITEV ON PICH.TX, SO, 37 RELEASE PICH.TX, SO END CLEARED.CCA.HOLD = TRUE CASE RECORDLOCKED(PICH.TX, SO) = LOCK$OTHER.READU * Another User has the record locked, we cannot update at this time ERR.NUM = 'C043' ERR.MSG = 'PICH.TX RECORD IS LOCKED, TRYING TO CLEAR CREDIT CARD HOLD' DOC.NUM = SO ; DOC.TYP = 'ORDER' ; FILE.NM = 'PICH.TX' GOSUB SEND.ERROR CASE RECORDLOCKED(PICH.TX, SO) = LOCK$NO.LOCK * There is no lock on this record presently, free and clear READVU HOLD.RSN FROM PICH.TX, SO, 37 LOCKED * ...but that could change in 1 ms so still handle the locked condition. ERR.NUM = 'C043' ERR.MSG = 'PICH.TX RECORD IS LOCKED, TRYING TO CLEAR CREDIT CARD HOLD' DOC.NUM = SO ; DOC.TYP = 'ORDER' ; FILE.NM = 'PICH.TX' GOSUB SEND.ERROR RELEASE PICH.TX, SO END THEN WRITEV ON PICH.TX, SO, 37 CLEARED.CCA.HOLD = TRUE END CASE Thank you. -Baker This communication, its contents and any file attachments transmitted with it are intended solely for the addressee(s) and may contain confidential proprietary information. Access by any other party without the express written permission of the sender is STRICTLY PROHIBITED. If you have received this communication in error you may not copy, distribute or use the contents, attachments or information in any way. Please destroy it and contact the sender. ___ 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 -- 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/1yT6IW24xN/50V5hqHqZ3Up5ajJTQzChu/3 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] FW: Universe just quits
The who command's interpretation of idle is solely based on terminal activity: Is there any input coming from the user? type of activity. Any unix process that does not have terminal i/o will register as idle in the who output. Gregor -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Oaks, Harold Sent: Thursday, 23 July 2009 7:01 AM To: U2 Users List Subject: Re: [U2] FW: Universe just quits Thanks to all who made suggestions. I'm definitely going to use some of them to improve processing. Good news: Universe is not at fault! So why did the process just end? Because a background process we run logs out processes idle for more than 3 hours. To determine idle time we check the 7th column of the output from the unix command who -HTR. Here was the surprise for me: even though the process was furiously performing I/O, as far as that unix command was concerned, it was idle. Oops! Easy to fix that, of course. The best parts of this were that UniVerse came through as more robust than I had worried it wasn't, and that contributors gave me some great advice. Thanks again to all. Harold Oaks -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Wednesday, July 22, 2009 8:14 AM To: U2 Users List Subject: Re: [U2] FW: Universe just quits I'm leaning towards the string too large theory. I'd definitely try this same thing with sequential I/O. -K ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ 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/1xUYc2DuCm/7HvnjYZB2DCQyJk1ZdTcqC/0 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] UniVerse configuration options SCRMIN, SCRMAX and SCRSIZE
Hello all. I have been working through some performance issues with a customer of ours, and naturally have been looking at what changes are possible in the UniVerse configuration. At present I am looking to better understand the SCRMIN, SCRMAX and SCRSIZE parameters. I understand these parameters to influence the scratch buffer pool for UniVerse (apparently used for temporary storage in an attempt to minimise calls to 'malloc' and 'free' during execution). What I do not yet understand is under what circumstances would changing these parameters be of benefit. Has anyone encountered a situation where the SCRMIN, SCRMAX and SCRSIZE parameters were adjusted? What where the conditions that lead to the change, and what was the impact of the changes on performance? Thanks Gregor Scott ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Linux / file create default permissions
You could try the UniVerse command UMASK 000. Works exactly like the Unix version. Put it in the UV.LOGIN or the account LOGIN macro and everyone will get the settings applied. Gregor From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Susan Joslyn Sent: Wednesday, 17 June 2009 2:11 AM To: u2-users@listserver.u2ug.org Subject: [U2] Linux / file create default permissions Greetings group. Anyone know how to set an overall parameter so that files created in Universe over Linux get r/w/x permissions? We are having to chmod 777 after we create any file. want that to be the default. Thanks! Susan Joslyn SJ+ Systems Associates, Inc. PRC(r) Software life-cycle management and IT Governance for U2/Multivalue http://sjplus.com _ Message protected by DealerGuard: e-mail anti-virus, anti-spam and content filtering. http://www.pentanasolutions.com Report https://login.mailguard.com.au/report/1xG4kNUV9q/7zz8WE1eeNgPzaEgAc2vJC/0.0 02 this message as spam ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
RE: [U2] Opening UniBasic Source Code - Tab Key
Bill, What exactly are you trying to achieve with the unix file? On UniVerse the openpath command will open a unix path as a database file, from which you then read items as normal. You either need to change to use the openseq command so you can sequentially read the contents of the unix item, or openpath '/u2/SOFTWARE/BP' to open the unix path as a file and then read the BASELINE.R0 item. Gregor -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Brutzman, Bill Sent: Thursday, 21 May 2009 9:20 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Opening UniBasic Source Code - Tab Key 1. Nope... I did not copy them; I would rather not have to copy them. 2. So far I have not have to do a fnuxi. 3. What does a Tab key come over as? I have a little method to buzz out the blank spaces. I would like to use this method on the pesky Tabs. --Bill -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Wednesday, May 20, 2009 5:34 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Opening UniBasic Source Code Into A UniBasic Have you copied these programs over from another host - esp another host with a different endian processor ? you may need to do a fnuxi or such thing on the code. -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Brutzman, Bill Sent: 20 May 2009 21:35 To: u2-users@listserver.u2ug.org Subject: [U2] Opening UniBasic Source Code Into A UniBasic I am writing on how to open a Unix file of UniBasic source code. When I try a openpath '/u2/SOFTWARE/BP/BASELINE.R0' to F.This then crt 'OK' end else crt 'Error' end *--- --- The.End: crt status() crt crt ' [] ' : input Ans crt @(-1) END *--- - 02 RUN BP FILESCAN.R0 Error -7 [] Where -7 is InValid file revision or wrong byte-ordering for the platform. The platform is UniVerse v10.1 on HP-Ux 11i v2. 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- 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/1xv5n3xAdt/24cAapgssVfLPUFP8fUeWL/0 Please consider the environment before printing this email --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Downloading and Installing RHEL Desktop 5.1 From Scratch
Another excellent burner is ImgBurn (http://www.imgburn.com/) - it also is free. Gregor Scott Development Department Reynolds and Reynolds Pty Ltd Ph: +61-3-9535- Fax: +61-3-9562-8143 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Schasny Sent: Monday, April 21, 2008 5:07 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Downloading and Installing RHEL Desktop 5.1 From Scratch I use CDBurnerXP to write ISO images. Its Free. http://cdburnerxp.se/ Dave Taylor wrote: Larry, Bill, Allen, David, You all hit the bulls-eye. But, I'm running XP Pro 2002 SP2 and I can not find any mention of BURN CD or DVD Manager or CopyToDVD in the help section. I have old copies of both Nero and Roxio, but they do not mention iso type files. Since I need to purchase a current copy of either Nero or Roxio, do any of you have a preference between the two? Thanks again for your help, Dave Dave Taylor Sysmark Information Systems, Inc. Authorized IBM Business Partner 49 Aspen Way Rolling Hills Estates, CA 90274 (O) 800-SYSMARK (800-797-6275) (F) 310-377-3550 (C) 310-561-5200 www.sysmarkinfo.com - Original Message - From: Bill Haskett [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Saturday, April 19, 2008 2:28 PM Subject: RE: [U2] Downloading and Installing RHEL Desktop 5.1 From Scratch Dave: I hate to suggest this but did you burn an ISO image with the proper XP burning software that does this properly? If not, then the drag'n drop won't read. So, on my machine I use CopyToDVD (I think) and open the DVD manager. I then drag'n drop the ISO image and the software puts it properly on my machine. Sorry if you've already done this. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Dave Taylor Sent: Saturday, April 19, 2008 12:09 PM To: u2-users@listserver.u2ug.org Subject: [U2] Downloading and Installing RHEL Desktop 5.1 From Scratch Well, here it is Saturday morning and my long-anticipated weekend project of installing Universe on Linux has just come to a screeching halt. I downloaded RHEL 5.1 Desktop and burned the disk1 cd image to a CD-ROM using Windows XPPro. When I install the the CD-ROM on the new machine with only the CD-ROM drive designated as a bootable device, I get a message: Boot Error. System Halted. I tried to install it on my laptop and it failed to install there also. The CD-ROM drive read lite came on in both cases, so I believe that it's reading the CD-ROM but not finding what it expects to find. Using Explorer to view the download or the burned image, I see only one icon representing an unknown file type. I don't see any individual folders or files within the image. To fail this early in the process suggests that I'm doing something very wrong. Any suggestions? tia, Dave Dave Taylor Sysmark Information Systems, Inc. Authorized IBM Business Partner 49 Aspen Way Rolling Hills Estates, CA 90274 (O) 800-SYSMARK (800-797-6275) (F) 310-377-3550 (C) 310-561-5200 www.sysmarkinfo.com --- 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/ -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com --- 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] TZ in AIX
The ENVIRONMENT command can be used inside UniVerse to adjust the shell TZ varaible, and it has an immediate impact on UniVerse DATE() and TIME() functions. We have used this to great effect, having all the required Timzone info we need stored inside UV. Gregor Scott Development Department Reynolds and Reynolds Pty Ltd Ph: +61-3-9535- Fax: +61-3-9562-8143 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Type ahead buffer overflow
tOM, Do not rule out AIX as being part of the problem. I encountered an issue with AIX having a buffer overrun when dealing with a large paste into an input in UniVerse. I was able to diagnose the isse for IBM by using a packet sniffer to track exactly what was sent to the AIX machine, and log all input received in UniVerse. Such a technique might help you pinpoint the problem. Gregor Scott Development Department Reynolds and Reynolds Pty Ltd Ph: +61-3-9535- Fax: +61-3-9562-8143 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom Dodds Sent: Tuesday, February 26, 2008 4:41 AM To: u2-users@listserver.u2ug.org Subject: [U2] Type ahead buffer overflow Or something like that. We have a client that uses a paste from Windows into an input statement, within a UniBasic program, to enter data. The string get quite large and in the transmission from VMS to Unix AIX 5.2 running UniData 7.10 we are losing data. We have played with the terminal emulator as much as possible, but we still lose data coming from Windows into UniData. We have set the sty to utilize xon/xoff, but still we lose data. Is there a way to increase the type ahead buffer so we won't overrun it. The data string could contain multiple pages. Or does anyone have a solution other then changing terminal emulators, that is out of the question at this installation. Thanks Tom Dodds --- 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/