Re: [U2] jobnotify: Error 913 occurred
Sorry, I forgot to reply... I vaguely recall having a jobnotify errors when we migrated to AIX6.1 and UV11.1.9 during the testing phases...but do not recall if it was the 913 version you got...I cannot find my notes on this and didn't raise it as a problem case with Rocket... You could be occasionally running out of user processes - but only when the system is busy... or perhaps some settings are not optimised for your server / license, etc. A quick check is to verify 'ulimit' sessions for your UV session (do a ulimit -a at the shell prompt). Check the current values of the ULIMIT and SHMMNI kernel parameters. SHMMNI should be set to Number of Users + 2. (This is from a Rocket UV11 tech note) Finally, I think we also ran into issues with running out of LCTs...not necessarily relayed to the jobnotify error... This was another configuration issue not documented in the install guide at the time. That required of the tweaking of the UVCONFIG NUSERS parameters to ensure that everything was 'optimised', etc. and documented in the tech guidese UniVerse 11.1 - Before You Upgrade.pdf (previously What You Need To Know for Eleven One.pdf). Hope this helps... Cheers, David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Leverett, Brendon Sent: Thursday, 20 March 2014 2:40 PM To: U2 Users List (u2-users@listserver.u2ug.org) Subject: Re: [U2] jobnotify: Error 913 occurred Nearly one week and no responses... Do I assume no one encountered the 'jobnotify: Error 913 occurred' message or has any knowledge of it. Regards, Brendon Leverett From: Leverett, Brendon Sent: Friday, 14 March 2014 11:09 AM To: U2 Users List (u2-users@listserver.u2ug.org) Subject: jobnotify: Error 913 occurred We have recently upgraded Universe (10.2.4 to 11.1.15) and are now finding some unusual activity around phantom jobs and the documented change to NOTIFY ON. There are a lot of details behind the scenes but in summary: - started a job via phantom command (phantom SYNC.COPY.BNET) - noticed 90 mins later that this job had crashed. This crash happens for various reasons but is more frequently crashing since the upgrade - restarted the same job with the same phantom command At this time the following 3 lines of text was returned to the user's session: jobnotify: Error 913 occurred [15466830] SYNC.COPY.BNET - terminated Phantom process started with process ID 33161456 Seems the 1ST 2 lines of text related to the previous phantom and 3rd line related to the phantom just started. My Q is: Does anyone have any ideas about the specific message jobnotify: Error 913 occurred We are running on AIX. Regards, Brendon Leverett ** 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
Re: [U2] U2 ODBC error
Do you have a context? New UV version? Old process just stopped working? New version of software X or Y? New server? New everything and old query A or updated query B? Those error message aren't helpful without some context... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Judy M Sent: Wednesday, 19 March 2014 3:38 PM To: u2-users@listserver.u2ug.org Subject: [U2] U2 ODBC error U2 UviVerse verions is The version of UniVerse TIO run is 11.1.9. ODBC U2 version is 32 bit 6.140.01.7533 I am call the ODBC DSN from Cognos Data Manager V10.2.1. This is the last entry in the ODBC log anyone give me any pointer. databuild.exe cfc-c40 ENTER SQLGetDiagRecW SQLSMALLINT 2 SQL_HANDLE_DBC SQLHANDLE 0x0018CCC8 SQLSMALLINT 1 SQLWCHAR * 0x0032C4A8 SQLINTEGER *0x0032C610 SQLWCHAR * 0x0018D9D0 SQLSMALLINT512 SQLSMALLINT * 0x0032C61C databuild.exe cfc-c40 EXIT SQLGetDiagRecW with return code 0 (SQL_SUCCESS) SQLSMALLINT 2 SQL_HANDLE_DBC SQLHANDLE 0x0018CCC8 SQLSMALLINT 1 SQLWCHAR * 0x0032C4A8 [ 5] S1003 SQLINTEGER *0x0032C610 (0) SQLWCHAR *0x0018D9D0 [ 55] [Rocket U2][U2ODBC][0400864]SQL data type out of range.SQLSMALLINT512 SQLSMALLINT * 0x0032C61C (55) databuild.exe cfc-c40 ENTER SQLGetDiagRecW SQLSMALLINT 2 SQL_HANDLE_DBC SQLHANDLE 0x0018CCC8 SQLSMALLINT 2 SQLWCHAR * 0x0032C4A8 SQLINTEGER *0x0032C610 SQLWCHAR * 0x0018D9D0 SQLSMALLINT512 SQLSMALLINT * 0x0032C61C databuild.exe cfc-c40 EXIT SQLGetDiagRecW with return code 100 (SQL_NO_DATA_FOUND) SQLSMALLINT 2 SQL_HANDLE_DBC SQLHANDLE 0x0018CCC8 SQLSMALLINT 2 SQLWCHAR * 0x0032C4A8 SQLINTEGER *0x0032C610 SQLWCHAR * 0x0018D9D0 SQLSMALLINT512 -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/U2-ODBC-error-tp42865.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ** 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
Re: [U2] Embedded help as hypertext
Wrapping in HTML is easy. Like anything ...doing it properly is hard...doing it right costs time and money...is it really worth it?? Unlikely - unless Rocket did it for us! :) Why don't just used BDT it has online context sensitive help and like the original poster said he uses the PDF. Key flaw in any plans is the large amount of missing commands and functions in all versions of the documentation (PDF, BDT, online in U2, etc.). In the past Rocket Software predecessor companies did produce Windows help file versionsas they do now for the fix/bug/release list download'ble from their website. Ideally, you should be just google it...and it would refer to a page on their site...just like you can do already for a numerous vendors... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny Sent: Thursday, 13 March 2014 1:05 AM To: U2 Users List Subject: Re: [U2] Embedded help as hypertext The Universe 'HELP' (and HELP BASIC and HELP SQL) listings are all contained as records in the file 'HELP.FILE'. Creating a program to make an index page and html-ized versions of the individual items would be an easy project: LIST HELP.FILE PICK*SAVE.LIST TEXT 07:59:54am 12 Mar 2014 PAGE1 HELP.FILE. PICK*SAVE.LIST Text.. SAVE.LIST . . Use SAVE.LIST to save an active select list. You can use GET.LIST . to recall this list for subsequent processing and avoid having to . repeat the selection process each time you want to use the same selec . list. . . . Syntax . . SAVE.LIST [ [ filename ] listname ] [ FROM n ] . . . Parameters . . . The following table describes each parameter of the syntax. . On Tue, Mar 11, 2014 at 11:49 PM, Hona, David david.h...@cba.com.au wrote: I assume you're talking about UV? Define 'improved'? It could be improved by actually having all the commands, options and functions in it first. Even the PDF versions are missing information :) However, if you want another/better built-in HELP facility for your own purposes...PIHELP may help you (it offers paging back, sub-topics, indexing, etc.)... If so, take a look at PIHELP (TCL verb) and SHOW.HELP (subroutine -SHOW) which is a port of the Prime INFORMATION help which has 'hypertext' (sub-topics) and paging (back/forwards). In PI, there was also a subroutine you could call (rather than EXECUTE PIHELP subject. It has own format where you can specify the help file source and sub-topics indexed based on keywords in the topic/help message, like this in field/line one: 0001: .*X PIHELP ONLINE COMMAND VERB TOPIC SUBJECT AID ASSISTANCE An index on the help file would on the above field allow PHELP ABOUT keyword. The FROM key word lets you specify you own help file. It is better than the native UV HELP in some respects and utilises the default SYS.HELP file or your own (if required). I did note that there is no indices for the SYS.HELP file, so the PIHELP ABOUT topic function doesn't work...the required I-type dictionary item to parse the help records appears to be missing from the dictionary of SYS.HELP (Rocket Support should be able to assist there). The source is in APP.PROGS (PIHELP.B and SHOW.HELP.B) - good luck! I guess it has been ported over for PI/open users that used this facility for their own applications... The U2 Tools have built online help too - which are handy. If you use them - I'd encourage all newcomers to use these tools and similar commercial products to supplement the built-in native command-line tools (aka terminal shell session)... Cheers, David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Wednesday, 12 March 2014 3:43 AM To: u2-users@listserver.u2ug.org Subject: [U2] Embedded help as hypertext Does anyone have an improved version of the TCL command HELP ? Are there any wiki's or anything that comprise all of the HELP text and perhaps more ? I sometimes use it, sometimes use the PDFs and sometimes just google. I think it would be a great resource were there a better solution. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ** 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
Re: [U2] Embedded help as hypertext
I assume you're talking about UV? Define 'improved'? It could be improved by actually having all the commands, options and functions in it first. Even the PDF versions are missing information :) However, if you want another/better built-in HELP facility for your own purposes...PIHELP may help you (it offers paging back, sub-topics, indexing, etc.)... If so, take a look at PIHELP (TCL verb) and SHOW.HELP (subroutine -SHOW) which is a port of the Prime INFORMATION help which has 'hypertext' (sub-topics) and paging (back/forwards). In PI, there was also a subroutine you could call (rather than EXECUTE PIHELP subject. It has own format where you can specify the help file source and sub-topics indexed based on keywords in the topic/help message, like this in field/line one: 0001: .*X PIHELP ONLINE COMMAND VERB TOPIC SUBJECT AID ASSISTANCE An index on the help file would on the above field allow PHELP ABOUT keyword. The FROM key word lets you specify you own help file. It is better than the native UV HELP in some respects and utilises the default SYS.HELP file or your own (if required). I did note that there is no indices for the SYS.HELP file, so the PIHELP ABOUT topic function doesn't work...the required I-type dictionary item to parse the help records appears to be missing from the dictionary of SYS.HELP (Rocket Support should be able to assist there). The source is in APP.PROGS (PIHELP.B and SHOW.HELP.B) - good luck! I guess it has been ported over for PI/open users that used this facility for their own applications... The U2 Tools have built online help too - which are handy. If you use them - I'd encourage all newcomers to use these tools and similar commercial products to supplement the built-in native command-line tools (aka terminal shell session)... Cheers, David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Wednesday, 12 March 2014 3:43 AM To: u2-users@listserver.u2ug.org Subject: [U2] Embedded help as hypertext Does anyone have an improved version of the TCL command HELP ? Are there any wiki's or anything that comprise all of the HELP text and perhaps more ? I sometimes use it, sometimes use the PDFs and sometimes just google. I think it would be a great resource were there a better solution. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ** 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
Re: [U2] Multi-threaded phantom processing
Hi Peter Clearly, you have no other option than to go the direction you have. Sounds like you're using the correct API and approach for the task at hand and with the constraints you have. Sounds like you have considered various implications and you're constrain by UV versions and UniRPC being blocked (a good thing if you're connectivity to third-parties and over unsecure/public networks :))... BTW: UV File triggers are light-weight triggers available in UV11.x - without the overhead and complexity of UV SQL Triggers. The MQSeries interface is good, but it's learning curve can be steep and is only feasible if both sites are licensed users. I've used it a lot, but the underlying complexity of the MQ setup and API can be up there with TCP/IP sockets :(... if you're new to it all! SQL BCI requires UniRPC access so that would be ruled out for your use as well. All of the higher-level APIs just save you the hassle of writing a complex low-level interface which could be hard to develop, debug and maintain in the future... In my experience, it is difficult to optimise any interface unless you have some minimum, average and maximum loads or throughput requirements to be met. It'll be difficult to optimise the interface other than setting minimum and maximum phantom processes - as you're and other have already mentioned. I guess time will tell how it works and what tweaking (aka optimisation) will be required...nothing like real-world usage to sort things out... Another potential consideration you need to consider or at least have test cases is loss of connectivity due to abnormal termination by the client, network (local/carrier/remote) or remote server. All these events may cause various issues that can impact UV locally, remotely and your TCP connectivity. Troubleshooting network and application connectivity is never easy - hence working through worse case scenarios in advance is a worthwhile - and somewhat very tedious exercise. Such issues have are applicable to all applications - of course. Such network issues impact the native UV APIs as well...but I am sure you'll get to know and loathe errors such as FIN_WAIT, etc., etc. as you get more usage and issues, etc. Cheers, David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter Cheney Sent: Friday, 7 March 2014 6:00 PM To: 'U2 Users List' Subject: Re: [U2] Multi-threaded phantom processing Initially data volume will be small - probably about 20 customers per day and about 6 records per customer but it is likely to grow very quickly up to some unknown amount. We'll have to see I guess. The records per customer are likely to be the high volume stuff. There is transaction logging on the remote system that I can use and am relying on for data integrity but I did not know about the SQL stuff until this week. Not sure if it would work until I can find time to play with it and see how it might suit us. Some of the other constraints were: no access allowed to the remote unirpc port, the remote UV is below 10.3 and different from ours, neither site has a UV/Net licence in prod. So I think I'm pretty much stuck with file queuing and multiple phantoms for now at least. I also was able to get a successful remote file process going on our test system while waiting for confirmation of UV/Net accessibility. It is very nice and might have been a nice solution too. Then I did some experimenting with the performance requirements on the file triggers and found there to be too much of a lag for the triggers to fire directly to the other end. This would've caused unacceptable problems in testing not to mention going live so a file queuing process had to be devised. In all the file queuing works quite well and can be coded for rock solid reliability so it has a lot of pluses. I can also fine tune the phantom loop times and socket timeouts on the fly at both ends once the data starts flowing and we get some idea of what needs changing. Fingers, toes, arms, legs (and eyes!) all currently crossed. Cheers Peter Peter Cheney Ultracs Developer t 07 3017 8837 | f 07 3002 8400 e peter.che...@firstmac.com.au w firstmac.com.au -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Hona, David Sent: Friday, 7 March 2014 13:41 To: U2 Users List Subject: Re: [U2] Multi-threaded phantom processing Hi Peter Sounds like an interested piece of work, just a couple of questions for you: - what sort of data volumes and update frequencies are involved? - do you need to know if the data has been successfully committed to the remote UV database? - did you consider SQL BCI or even UV/Net (read the different UV versions is an issue and so this may be a constraint) Gregor mentioned SQL BCI as an alternative interface - I've used that before to exchange data between systems
Re: [U2] Multi-threaded phantom processing
Hi Peter Sounds like an interested piece of work, just a couple of questions for you: - what sort of data volumes and update frequencies are involved? - do you need to know if the data has been successfully committed to the remote UV database? - did you consider SQL BCI or even UV/Net (read the different UV versions is an issue and so this may be a constraint) Gregor mentioned SQL BCI as an alternative interface - I've used that before to exchange data between systems and it works well. If you had the same UV version on both hosts - then UV/Net is simple effect way of transmitting data between UV systems with only licenses required on the remote system. With BCI you could utilise the Stored Procedure facility via an ExecDirect() call to push the data to the remote system in your UV file trigger. With UV/Net you could push the items to be copied the by your UV file trigger - thus the updates being written directly onto the remote host. BCI is free/included in UV and of course will utilise a license on the remote host. You need to write your own custom code. Probably a bit easier to maintain than any TCP/IP sockets based interface. Definitely a lot easier to troubleshoot ;-) ! YMMV. UV/Net is licensed on the number user connections on the remote host. Hence the above alternative as designed to eliminate the file-based queue - which in some instances by be desirable to maintain - depending on business, technical or operational needs/objections. Cheers, David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter Cheney Sent: Wednesday, 5 March 2014 12:18 PM To: U2 Users List (u2-users@listserver.u2ug.org) Subject: [U2] Multi-threaded phantom processing Hi Everyone, A project that I’m currently working on requires transmission of transactional and ancillary data from one UV site to site to another. I have the communications all set up and it is working very well via the UV socket functions with a client at one end and a server at the other. Both the client and the server both run as a UV phantom processes written in UV basic and the data being transferred (also encrypted) is more or less real time with various UV file triggers on the client end creating queue items for transmission based on the data content / transaction type. This set up is a single threaded affair and I am wondering how it will cope and what options I’ll have as the volume of data increases. Multi-threading my server process to dish out some of the load might be one possibility and I’ve seen examples in the past where the last digit of a numeric key (i.e. 0-9) is used to determine which one of 10 phantoms to call thus providing an effective distribution of the work. But even then, reading/writing processing data to a file for each child process seems to me to be the only way to achieve parent - child phantom communications at either end. Is there another way perhaps? It may be that I will need 2 sets of phantoms, 1 for the transactions and one for the ancillary data. Although we run UV on AIX the only other requirement is that I must be able to do it within UV Basic. Does anyone out there on the list know of a better way or any alternatives/advice so I can get a better appreciation of what else might be possible please? Many thanks in advance, Peter Peter Cheney Ultracs Developer t 07 3017 8837 | f 07 3002 8400 e peter.che...@firstmac.com.au w firstmac.com.au --- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. Firstmac Limited (ABN 59 094 145 963) (AFSL 290600) --- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains
Re: [U2] [UV] Programmatic Verification of Globally Cataloged Subroutine
There is the !EXIST subroutine. It's a legacy Prime INFO subroutine - created for legacy code that need it. The source code is in UV APP.PROGS and just reads GLOBAL.CATDIR and also sets STATUS() with a return code too. CATALOGED.NAME = '*MYGLOBALSUB' call !EXIST(CATALOGED.NAME, RC) crt CATALOGED.NAME: = :(if RC then exists else NOT found) crt CATALOGED.NAME: STATUS() = :STATUS(): = :(if STATUS() then exists else NOT found) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Perry Taylor Sent: Tuesday, 28 January 2014 4:06 AM To: U2-Users List Subject: [U2] [UV] Programmatic Verification of Globally Cataloged Subroutine Does anyone know of a good method in UniVerse BASIC to be able to verify if a subroutine is globally cataloged? Thanks. Perry Taylor Senior MV Architect Office (877) 494-7633 ext. 4392 Direct (502) 779-4392 ZirMed 888 West Market Street, Suite 400 Louisville, KY 40202 www.zirmed.comhttp://www.zirmed.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
Re: [U2] Migrating UniVerse 10.1.20 on HP-UX to UV 11.x on Redhat Linux
Did you use format.conv (UNIX / DOS/Windows command) or FORMAT.CONV (TCL command) on the HPUX sourced files that restored - post-restore? This will convert them into the format required for the target system... There are many options to choose from...see Admin.pdf (In the UV11.1 edition, see section 15-21 - PDF page 362 or do a TCL HELP FORMAT.CONV) A quick google would've revealed to you the following thread... which could be useful as well... http://u2-universe-unidata.1073795.n5.nabble.com/UniVerse-On-RedHat-td7144.html -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of mburgun Sent: Wednesday, 8 January 2014 4:56 PM To: u2-users@listserver.u2ug.org Subject: [U2] Migrating UniVerse 10.1.20 on HP-UX to UV 11.x on Redhat Linux Hi, The general consensus seems to be that when migrating UniVerse across platforms the best approach is to use UVBACKUP on the old platform and then UVRESTORE on the target platform and all platform issues are taken care of. We, however have just attempted this process in migrating UniVerse 10.1.20 on HP-UX to UV 11.x on Redhat Linux and have come across the following problem ... UVBACKUP seemed to worked OK (we were able to restore on old platform UVRESTORE seemed to work OK on target platform http://u2-universe-unidata.1073795.n5.nabble.com/file/n42468/uvscreen.png In the above screenshot the directory contains UniVerse files but UniVerse doesn’t recognise them. UniVerse can’t run in this directory without its essential database files. Answering “Y” to the question also won’t work as UniVerse is unable to initialise the directory while it contains rubbish files having the same names as the required UniVerse files. Does anyone have any ideas? Thanks! Michael -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/Migrating-UniVerse-10-1-20-on-HP-UX-to-UV-11-x-on-Redhat-Linux-tp42468.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ** 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
Re: [U2] UV/Net usage and licensing
Hi Peter, It's been a while since I've used/played around with UV/Net, but this may help... 1. Setup You only need a ensure UniRPC is active and you license for UV/Net on the server you wish to access. I don't recall you need to anything other than the UniRPC Daemon listening for requests and it will invoke uvnet for your client request. 2. Security I can't recall if you're using UNIX or not...(it is supposed to OS independent) Although, UV/Net is supposed to set the effective user (UID numer) and group (GID numer) for the remote users connecting to the remote UV server...if required. Plus if specified - as you're doing so. My experience with similar DB product tools is it is far better to have the UID and GIDs directly aligned. Specifically: make sure the UID and GID for the same named accounts are exactly the same on both servers. Or if you use SET.REMOTE.ID that the account locally has sufficient rights or in fact it exists. I have issues with the same accounts and groups on different users have different UIDs and GIDs on the different client and servers - causing grief/ havoc on similar products to UV/Net, etc. Also - check if you have UniVerse Dynamic Type30 files, that your UNIX file ownerships, group ownership and Other are set exactly the same. This includes the hidden file.Type30. Having different settings are recipe for lots of grief! Finally, be forewarned that allowing testers/developers access to your production server via UV/Net is an EXTREMELY bad idea! (Career terminating if things go pear shaped when they have write/delete rights!). It is far too easy for these types of users to be unaware their test account is in fact pointing to your production service and there access is write/delete. Did you try the UVNETRID environment variable in place of SET.REMOTE.ID? If you are still having issues, you may have to enabled UniRPC debugging which is very extensive and generate logs of data - but is useful for seeing exactly where things are going wrong. Cheers, David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter Cheney Sent: Thursday, 12 December 2013 2:23 PM To: U2 Users List (u2-users@listserver.u2ug.org) Subject: [U2] UV/Net usage and licensing Hi Everyone, We’re looking at doing some remote file mangling and was wondering if there are any gotchas when using UV/Net to do this? In my scenario if I am on host A and want to read/write files on host B. Host B only needs to read/write files on host B but not on host A. Do I need UV/Net on host A as well as host B or just on host A? Host A is running UV 10.3.4 and host B is running UV 10.2.6. Local testing on host A to host A/DR shows record locking is working OK but if the remote file does not have read/write on ‘other’ (e.g. 660) then all writes fail regardless of how I spec the credentials via SET.REMOTE.ID. Setting the permissions to 666 is the only way I can get this to work even when using the same login and group membership at each end. Also does anyone know if firewall ports other than standard unirpc port 31438 need to be opened either end for bi-directional file access too please? Regards, Peter Peter Cheney Ultracs Developer t 07 3017 8837 | f 07 3002 8400 e peter.che...@firstmac.com.au w firstmac.com.au ** 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
Re: [U2] Exporting to File regularly
Hi David If you upgrade to the latest UV version you have access to the built-in UV DB audit logging facility. Then you can setup a logging event to log changes to the file(s) in question. Hence, not violating the NDAs nor application flow (which you would have too if modifying the file with adding indices / triggers or the like). A simple file-based trigger (not the UV/SQL triggers - which a different more powerful beasts) that copies could make a copy to your own file or invokes a BASIC program/script to send notifications should do the trick too. A working example someone has posted on U2-Users List: http://u2-universe-unidata.1073795.n5.nabble.com/universe-11-1-triggers-via-indexing-and-IDX-IOTYPE-sample-tc41706.html#a41718 Audit logging is not for you unless you upgrade UVbut perhaps in the future...I guess you need a job to check the audit log for these events...too https://docs.rocketsoftware.com/nxt/gateway.dll/RKB14/universe/11.2/security1.pdf See page 372 Section 7 for Audit logging BTW: Look at from the vendors' perspective they have a lot of intellectual property tied up in their product. They sell it with consultancy, etc. It's how they make their living - pay their bills and eat... ;) Plus a lot of clients go out of their way not to pay for anything... it's a two-way rocky road sometimes! Regards, David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Campbell Sent: Thursday, 12 December 2013 9:05 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Exporting to File regularly Wow, overwhelming response to this question, thank you VERY MUCH for all of your idea's, I have a lot to process and decide what I can achieve... as a bit of background that I probably should have included, I am running UniVerse 11.1.9 on an IBM AIX 7.1.1.15 box. So far Bruce Decker seems to have the most appealing option if I can get it going, I'm sure I be full of more questions than answers in a few days, I just hope making this script doesn't make me the go to guy at work when someone needs weird universe stuff done... *gulp* Oh and its a database that is populated by a contact form from a secure website which then alerts the old terminal sessions that this business used in the past, but since they switched to a web interface for the software and hardly anyone uses the terminal full time any more the items sit there sometimes for hours before a response, so yes I want to be spammed by this all day long, and once it works I can point that spam at a receptionist or two :) The problem with notifying just on changes, is the file changes every time an individual reads a record and marks a particular record as READ for that user by removing their name from the users who have not read this yet column, the file size never changes unless it needs to grow and when records are deleted it simply fills with junk, which I take it is a standard universe thing it does, at this point the numbers appear sequential but that is best guess sigh. The vendor is incredibly secretive, they wont tell me how it works and their NDA says I am not allowed to memorize how their interface works... WTF so YAY obscure software that we cant leave because we are backed into a corner! /end rant Anyway thanks for all the help guys, so glad I found this place! -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/Exporting-to-File-regularly-tp42264p42277.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ** 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
Re: [U2] Rocket releases UniVerse version 11.2.0
This has to be one of the most feature rich releases of UV for a long time. There are many new features and enhancements that we've been holding out for a long time... Well done Dan Rocket U2 team for the big effort for this huge release and the keeping U2/UV alive a kicking... Cheers, David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath Sent: Friday, 15 November 2013 4:39 AM To: U2 Users List (u2-users@listserver.u2ug.org) Subject: [U2] Rocket releases UniVerse version 11.2.0 If you haven't received an email already, I just wanted to let you all know we have released the next major version of the UniVerse Database today! You can find out more from our website, or from my blog post here: http://blog.rocketsoftware.com/2013/11/the-universe-database-version-11-2-released Cheers, Dan McGrath Managing Director, U2 Servers Lab Rocket Software ** 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
Re: [U2] Select from one file with save-list from another file
Hi Brandon, If you want to send one of your columns/fields in your UV/SQL SELECT result to an active select list or saved list - within the same SQL query - you need to use 'TO SLIST' keyword option... See the HELP SQL SELECT online for the limitations though. For example: To save the column/field Y.INFO.packet.id to select list 0: select Y.INFO.packet.id TO SLIST 0 from X.INFO, Y.INFO where X.INFO.packet.id=Y.INFO.packet.id and X.INFO.status='ccc'; - OR- To save the column/field Y.INFO.packet.id to a saved list named MYSQLJOIN in SAVEDLISTS: select Y.INFO.packet.id TO SLIST MYSQLJOIN from X.INFO, Y.INFO where X.INFO.packet.id=Y.INFO.packet.id and X.INFO.status='ccc'; Regards, David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Hilk, Brandon Sent: Wednesday, 28 August 2013 6:24 AM To: u2-users@listserver.u2ug.org Subject: [U2] Select from one file with save-list from another file Hello! UniVerse 10.1, HP/UX, Pick. Is there a way I can build a save-list from a selection from one file X.INFO (where the record ID is an 8 digit number) and use that list to select from file Y.INFO (where that 8 digit number is not the record ID but does exist as a foreign key elsewhere in the file). In SQL this would be considered a join and would look something like this: select * from X.INFO, Y.INFO where X.INFO.packet.id=Y.INFO.packet.id and X.INFO.status='ccc'; I can run this in TCL and have it return the results I want but can't build a save-list from it because I don't know the UniVerse/SQL syntax to do so. So to summarize, is there a way to use a save-list built from X.INFO to make another save-list comprised of the record ID's from Y.INFO? Thanks for any advice you can give. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ** 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
Re: [U2] [UV] Do you avoid TRIGGERS because of the difficulty using DEBUG or RAID with them? Was: Universe Triggers
Yes, Chuck a typo in the release number and much less capable than SQL style triggers...so a backwards step too. But far less overhead and drama to setup/maintain... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson Sent: Wednesday, 7 August 2013 7:58 AM To: U2 Users List Subject: Re: [U2] [UV] Do you avoid TRIGGERS because of the difficulty using DEBUG or RAID with them? Was: Universe Triggers @IDX.IOTYPE Thanks to a fellow u2-list member who mailed me privately. I think David Hona was maybe thinking of that, but it's available at 11.1, not 10.1. Chuck On 8/5/2013 6:23 PM, Perry Taylor wrote: Rocket added an @variable (don't recall the name of it) that tells which call is being made. Perry -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson Sent: Saturday, August 03, 2013 9:40 AM To: U2 Users List Subject: Re: [U2] [UV] Do you avoid TRIGGERS because of the difficulty using DEBUG or RAID with them? Was: Universe Triggers David, I didn't understand your 1st clause, Now that (from UV10.1) Index-based triggers are officially supported, By index-based triggers, I assume you mean the trick of indexing an I-descriptor that calls a subroutine that updates some other file, which is generally not the sort of thing you expect such a subroutine to do. What is this official support? Did I miss an announcement, a change in the documentation, or a whitepaper? And by support - just to get my hopes up beyond all reason - does that mean they've introduced some mechanism (@variable?) to help distinguish among calls of the subroutine for insert (where indexing calls the subroutine once, to find the new value to index) delete (where indexing calls the subroutine 1x, to find the value to delete), and change (where indexing calls the subroutine 2x, once with the old version of the record, once with the new, to see whether the indexed value has changed and, if so, what to delete, what to add. Distinguishing these has always been tricky for the general case. Hope springs eternal, Chuck On 8/1/2013 12:32 PM, Hona, David wrote: Now that (from UV10.1) Index-based triggers are officially supported, can these replace your SQL-based triggers? These have less functionality and less overhead, but that's the price you have to pay Can't say I had a chance to try it for myself...yet...! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson Sent: Saturday, 27 July 2013 5:32 AM To: U2 Users List Subject: [U2] [UV] Do you avoid TRIGGERS because of the difficulty using DEBUG or RAID with them? Was: Universe Triggers How many people avoid using triggers BECAUSE of the virtual impossibility of using RAID with Triggers? On 7/26/2013 12:33 PM, Phil Walker wrote: I won't be holding my breath Charles ;-) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson Sent: Friday, 26 July 2013 9:22 p.m. To: U2 Users List Subject: Re: [U2] Universe Triggers re. triggers Raid, I could not agree with Phil more. Well said. Come on, Rocket! On 7/19/2013 1:32 AM, Phil Walker wrote: Ken, I am glad you raised the issue about debugging a program with a file which has a trigger attached. I have been on to UV (Vmark/Ardent/IBM/Rocket for ages about fixing this pushing for the ability to be able to step into the trigger code, but at a VERY MINIMUM being able to debug the program and perform the write on the file, and in effect step over the trigger subroutine and carry on debugging. The issue is the trigger subroutine cannot support input, so what UV have done is basically say you are using the debugger so you are inputting debug commands so you will abort. They need to turn this restriction off for debugging so that either of the above two scenarios is supported. In a Microsoft world I can debug anything through the connected world of web/databases etc.. Have had no feedback from UV -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ken Ford Sent: Friday, 19 July 2013 9:48 a.m. To: u2-users@listserver.u2ug.org Subject: Re: [U2] Universe Triggers Dan, In addition to the other responses you have received, I suggest the following: 1. Have one master file trigger subroutine (globally catalogued) that calls subroutines (locally catalogued) tailored to individual files. This means you don't have to stop and restart Universe when a new trigger is required or a change to an existing one. If the master subroutine changes, you do have to restart Universe
Re: [U2] [UD] BASIC Code Failing
the wheel. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Hona, David Sent: 01 August 2013 10:49 To: U2 Users List Subject: Re: [U2] [UD] BASIC Code Failing In UV we're had similar strange problems with seemingly unchanged source/object code - not work as per normal and things going amiss for no good reason...once we found the object code in BP and the catalog space were mismatched and simply re-catalog'd it. Another time we re-compiled a program - as it was always invoked via RUN BP PROGNAME... in both instances the problem seem to go away. This was in a controlled product environment so it's in highly unlikely someone could of or would've changed the code... In UV you can do a VCATALOG to verify the BASIC object to what is actually catalogued... All of these issues made me wonder if our implementation routines need to have a more robust. More robust in terms of storing some control information for both pre/post verification - hence being able to detect 'unauthorised changes' through the various stages. This could include calculating and storing (say) MD5 (etc) hashes on the source and object to cross verify changes. Hence, make it more easy to detect object or source changes outside the authorised/control deployment process... without having to go through every single file and comparing to tape or disk backups, etc., etc. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Wednesday, 31 July 2013 6:06 AM To: U2 Users List Subject: Re: [U2] [UD] BASIC Code Failing John: That's an interesting thought. We do backups of the application account every night, so I do have the last 10 days object code in a backup (plus the last four months weekly backups). I'll look at this the next time it happens. Thanks, Bill Untitled Page -- -- - Original Message - *From:* jhes...@momtex.com *To:* U2 Users Listu2-users@listserver.u2ug.org *Date:* 7/30/2013 11:01 AM *Subject:* Re: [U2] [UD] BASIC Code Failing I would also consider the possibility of data corruption at the hardware level. Granted, I would expect that you'd also occasionally find anomalies within your source code and data files if this were the case, but I don't know how your filesystems are set up. If the object code has become corrupt, that would explain why recompiling fixes the problem. The newly created object code will be stored on a new location in the filesystem. Fortunately this possibility is very easy to test for. Just make a copy of your application account on alternate storage and wait for the problem to recur. When it does, open the live object file and your backup copy in an editor with diff capability (Notepad++ is a good one) and see if they still match. -John ** 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 ___ 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 ** 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
Re: [U2] [UV] Do you avoid TRIGGERS because of the difficulty using DEBUG or RAID with them? Was: Universe Triggers
Now that (from UV10.1) Index-based triggers are officially supported, can these replace your SQL-based triggers? These have less functionality and less overhead, but that's the price you have to pay Can't say I had a chance to try it for myself...yet...! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson Sent: Saturday, 27 July 2013 5:32 AM To: U2 Users List Subject: [U2] [UV] Do you avoid TRIGGERS because of the difficulty using DEBUG or RAID with them? Was: Universe Triggers How many people avoid using triggers BECAUSE of the virtual impossibility of using RAID with Triggers? On 7/26/2013 12:33 PM, Phil Walker wrote: I won't be holding my breath Charles ;-) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson Sent: Friday, 26 July 2013 9:22 p.m. To: U2 Users List Subject: Re: [U2] Universe Triggers re. triggers Raid, I could not agree with Phil more. Well said. Come on, Rocket! On 7/19/2013 1:32 AM, Phil Walker wrote: Ken, I am glad you raised the issue about debugging a program with a file which has a trigger attached. I have been on to UV (Vmark/Ardent/IBM/Rocket for ages about fixing this pushing for the ability to be able to step into the trigger code, but at a VERY MINIMUM being able to debug the program and perform the write on the file, and in effect step over the trigger subroutine and carry on debugging. The issue is the trigger subroutine cannot support input, so what UV have done is basically say you are using the debugger so you are inputting debug commands so you will abort. They need to turn this restriction off for debugging so that either of the above two scenarios is supported. In a Microsoft world I can debug anything through the connected world of web/databases etc.. Have had no feedback from UV -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ken Ford Sent: Friday, 19 July 2013 9:48 a.m. To: u2-users@listserver.u2ug.org Subject: Re: [U2] Universe Triggers Dan, In addition to the other responses you have received, I suggest the following: 1. Have one master file trigger subroutine (globally catalogued) that calls subroutines (locally catalogued) tailored to individual files. This means you don't have to stop and restart Universe when a new trigger is required or a change to an existing one. If the master subroutine changes, you do have to restart Universe. 2. Use a control record that records the subroutine name and state of the trigger for each file having a trigger. 3. Use a program to change the state of a trigger, using the control records in 2 above. 4. Make sure all background processes that have a file with a trigger open are logged out when recompiling the subroutine for that file trigger. 5. Remember that you can't do anything to a file with an active trigger whilst in the RAID debugger (it will crash). Rather, if you are testing a file trigger subroutine, drop the trigger and use a trigger testing program that calls the subroutine after taking a copy of the record being changed, pausing whilst you change it in another session, and then resuming, calling the subroutine. If you would like samples of any of the software mentioned above, let me know, and I can send them to you. Regards, Ken Ford Universe Software Developer t 07 3013 8605 | f 07 3002 8400 e ken.f...@firstmac.com.au | w firstmac.com.au ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ** 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
Re: [U2] [UD] BASIC Code Failing
In UV we're had similar strange problems with seemingly unchanged source/object code - not work as per normal and things going amiss for no good reason...once we found the object code in BP and the catalog space were mismatched and simply re-catalog'd it. Another time we re-compiled a program - as it was always invoked via RUN BP PROGNAME... in both instances the problem seem to go away. This was in a controlled product environment so it's in highly unlikely someone could of or would've changed the code... In UV you can do a VCATALOG to verify the BASIC object to what is actually catalogued... All of these issues made me wonder if our implementation routines need to have a more robust. More robust in terms of storing some control information for both pre/post verification - hence being able to detect 'unauthorised changes' through the various stages. This could include calculating and storing (say) MD5 (etc) hashes on the source and object to cross verify changes. Hence, make it more easy to detect object or source changes outside the authorised/control deployment process... without having to go through every single file and comparing to tape or disk backups, etc., etc. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Wednesday, 31 July 2013 6:06 AM To: U2 Users List Subject: Re: [U2] [UD] BASIC Code Failing John: That's an interesting thought. We do backups of the application account every night, so I do have the last 10 days object code in a backup (plus the last four months weekly backups). I'll look at this the next time it happens. Thanks, Bill Untitled Page - Original Message - *From:* jhes...@momtex.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 7/30/2013 11:01 AM *Subject:* Re: [U2] [UD] BASIC Code Failing I would also consider the possibility of data corruption at the hardware level. Granted, I would expect that you'd also occasionally find anomalies within your source code and data files if this were the case, but I don't know how your filesystems are set up. If the object code has become corrupt, that would explain why recompiling fixes the problem. The newly created object code will be stored on a new location in the filesystem. Fortunately this possibility is very easy to test for. Just make a copy of your application account on alternate storage and wait for the problem to recur. When it does, open the live object file and your backup copy in an editor with diff capability (Notepad++ is a good one) and see if they still match. -John ** 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
Re: [U2] UML mapping tool for MV (UniVerse)
Regardless of the toolset, the first hurdle would be to normalise your database to look like a relational one. Which is likely to be the greatest hurdle. Data dictionaries in U2/PICK are optional are a purely for reporting purposes - they can have duplicates and these can be conflicting. Even worse (as if you thought it could be) - data dictionaries can be incomplete or wrong. This added to the lack of enforcement of data integrity and constraints usually causes these toolsets to fail (indeed, even the UV/ODBC driver fails too!)... so good luck! Rocket released U2 Metadata Manager to assist in this respect and is designed to allow forward and backwards capability. Although, support for this in UV is limited to the latest official release... so your alternative is UV/ODBC... For UV/ODBC users - I have always recommended a separate UV account and data dictionary that is spotless. For some this is the best option - why go against the flow - when you create your own stream... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lynette LeDoux Sent: Tuesday, 16 July 2013 5:45 AM To: u2-users@listserver.u2ug.org Subject: [U2] UML mapping tool for MV (UniVerse) Hello all. The call has come to locate possible data modelling tools (UML) that could potentially would connect to our UniVerse system. Ideas? L2 (Lynette LeDoux) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of u2-users-requ...@listserver.u2ug.org Sent: Monday, July 15, 2013 2:00 PM To: u2-users@listserver.u2ug.org Subject: U2-Users Digest, Vol 51, Issue 13 Send U2-Users mailing list submissions to u2-users@listserver.u2ug.org To subscribe or unsubscribe via the World Wide Web, visit http://listserver.u2ug.org/mailman/listinfo/u2-users or, via email, send a message with subject or body 'help' to u2-users-requ...@listserver.u2ug.org You can reach the person managing the list at u2-users-ow...@listserver.u2ug.org When replying, please edit your Subject line so it is more specific than Re: Contents of U2-Users digest... Today's Topics: 1. Re: Mobile phones (Symeon Breen) 2. Re: [ANN] FOSS4MV - Free Open Source Software for the MVDB world (Daniel McGrath) 3. SORT reports line length, change right margin? (randyleesmith) 4. Re: SORT reports line length, change right margin? (Anthonys Lists) 5. Re: SORT reports line length, change right margin? (Don Robinson) 6. Re: Mobile phones (Bill Haskett) 7. Re: SORT reports line length, change right margin? (randyleesmith) 8. Re: SORT reports line length, change right margin? (Bill Haskett) 9. Re: SORT reports line length, change right margin? (Wols Lists) 10. Re: SORT reports line length, change right margin? (randyleesmith) 11. Re: SORT reports line length, change right margin? (Wols Lists) 12. Re: SORT reports line length, change right margin? (randyleesmith) 13. Re: SORT reports line length, change right margin? (Wols Lists) -- Message: 1 Date: Mon, 15 Jul 2013 13:20:14 +0100 From: Symeon Breen syme...@gmail.com To: 'U2 Users List' u2-users@listserver.u2ug.org Subject: Re: [U2] Mobile phones Message-ID: 004d01ce8155$a9f67e30$fde37a90$@gmail.com Content-Type: text/plain; charset=us-ascii Thanks everyone for your information. -- Message: 2 Date: Mon, 15 Jul 2013 14:25:42 + From: Daniel McGrath dmcgr...@rocketsoftware.com To: U2 Users List u2-users@listserver.u2ug.org Subject: Re: [U2] [ANN] FOSS4MV - Free Open Source Software for the MVDB world Message-ID: 61ef3a8534e14d709dffdc5bd2f27...@den-vm-mbx3.rocketsoftware.com Content-Type: text/plain; charset=iso-8859-1 Thanks Tony Kevin! Unhappy to see we both ended up on different platforms (GitHub BitBucket) which means people would need to learn 2 different sites, but ecstatic to see we both ended up using Git which means people really only need to learn 1 tool chain to be able to work with both. Cheers, Dan McGrath Managing Director, U2 Servers Lab Rocket Software 4600 South Ulster Street? ?? Suite 1100? ??? Denver, CO 80237 ?? USA T: +1 720 475 8098 ? E: dmcgr...@rocketsoftware.com ? W: u2.rocketsoftware.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: Saturday, July 13, 2013 5:47 PM To: u2-users@listserver.u2ug.org Subject: [U2] [ANN] FOSS4MV - Free Open Source Software for the MVDB world Posted for Kevin Powick === Fellow developers, I'm happy to announce a new resource for MVDB developers. FOSS4MV! FOSS4MV is a community for people that use or develop Free and Open Source Software for MVDB platforms, such as D3, OpenQM,
Re: [U2] Writing to a Windoz box from Universe
Ah, yes - we used in AIX6.1 :) It was the older AIX5.x environments it wasn't there... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Gregor Scott Sent: Thursday, 11 July 2013 3:54 PM To: U2 Users List Subject: 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 ** 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
Re: [U2] [UV] Auto Starting Applications
Yes, this was a problem - but I haven't recently tried to execute UV11 and cron. UV11 has a different shared memory model - inherited from UD - in comparison to older releases. A quick test shows that phantom processes are getting their own shared memory segment under UV11. So - at first glance - it appears no longer to be an issue from UV11 onwards. Dave Church's uvcron.c program was the solution in the past/now to help for those still waiting to user cron or similar scheduling tool...with uv. http://www.pickwiki.com/cgi-bin/wiki.pl?Uvcron -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Phil Walker Sent: Thursday, 11 July 2013 9:23 AM To: U2 Users List Subject: Re: [U2] [UV] Auto Starting Applications You should use uvsh rather than uv and you also need to consider multiple cron jobs running as the same user at the same time as Universe does not like this or never used to at least. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter Cheney Sent: Thursday, 11 July 2013 10:51 a.m. To: U2 Users List Subject: Re: [U2] [UV] Auto Starting Applications You can certainly launch a UV process from a unix script. e.g. #!/usr/bin/bash cd /$path_to_uv_account/$ACCOUNTNAME $UVHOME/bin/uv phantom PROGRAMNAME /somedir/log1.txt $UVHOME/bin/uv LIST SOMEFILE DICTITEM1 DICTITEM2 /somedir/log2.txt You can call this from cron too if required. Cheers Peter Peter Cheney Universe Engineer t 07 3017 8837 | f 07 3002 8400 e peter.che...@firstmac.com.au | w www.firstmac.com.au From: u2-users-boun...@listserver.u2ug.org [u2-users-boun...@listserver.u2ug.org] on behalf of Kevin King [ke...@precisonline.com] Sent: Thursday, 11 July 2013 8:34 AM To: U2 Users List Subject: Re: [U2] [UV] Auto Starting Applications Wouldn't a simple startup script suffice - like in /etc/init.d/rc*x*.d (depending on Linux)? On Wed, Jul 10, 2013 at 12:42 PM, Perry Taylor perry.tay...@zirmed.comwrote: What techniques are you folks using to start up apps when UniVerse on Linux is started? Obviously hooking into uv.rc is an option. Are there others? Thanks. Perry ** 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
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
Re: [U2] Flip Case command?
TCL: PTERM -CASE INVERT BASIC: TTYSET -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Saturday, 6 July 2013 7:50 AM To: u2-users@listserver.u2ug.org Subject: [U2] Flip Case command? Does anyone know of an internal command of any sort that will allow one to flip the case of some input stream ? That is, not just make it all lower case or all upper case, but actually make all lower case input upper, AND at the same time all upper case input lower. That is truly flip the case of each input character ? I'm going to write my own, unless someone has one. Thanks ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ** 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
Re: [U2] Running total
You can also see what the I-type does by DLIST yourfile yourdictitem It's the equivalent of VLIST for I-Types... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter Cheney Sent: Thursday, 4 July 2013 9:48 AM To: U2 Users List Subject: Re: [U2] Running total I believe the expression in the second example is referred to as a compound expression? Can't put my finger on the exact documentation but I seem to recall that compound expressions are broken up into parts (for want of a better term) delimited by a ';' and each part can be referenced throughout the entire expression by an @ number e..g. @1 refers to the first part and the nth part is @n etc. So for: LIST VOC SIZE EVAL SIZE + @2;@ My take on how this works is the the first part of the expression (SIZE + @2) can be referenced later on as @1, The second part is referenced as @ (instead of @2) and I believe is used to refer to the result of the entire expression (sum of all the parts). Can @ in this case also be referenced as @2? It probably could but would break the expression. Therefore the reference to @2 is causing the expression to grab the entire result using contents of @ (via @2 thus keeping it separate to @) and add it to SIZE which then becomes the new result (@) of the expressions and the whole thing is repeated. Does that sound about tight? Or have I got it way wrong? Cheers Peter Peter Cheney Universe Engineer t 07 3017 8837 | f 07 3002 8400 e peter.che...@firstmac.com.au | w www.firstmac.com.au From: u2-users-boun...@listserver.u2ug.org [u2-users-boun...@listserver.u2ug.org] on behalf of Wjhonson [wjhon...@aol.com] Sent: Thursday, 4 July 2013 7:31 AM To: u2-users@listserver.u2ug.org; donr_w...@yahoo.com Subject: Re: [U2] Running total Can anyone explain this situation better. I've only ever used the @ to simplify a few I-descriptors. I have a dict item SIZE that is just the LEN(@RECORD) So in this thread we've seen two EVAL solutions to a running total LIST VOC SIZE EVAL @1+SIZE LIST VOC SIZE EVAL SIZE + @2;@ In the first example is the @1 just saving the previous result of THIS eval ? And then in the second example does the fact that SIZE is first in the Eval, effectively *push* the accumulator into position two or something? So that's why you need @2 ? And then what would be the meaning of ;@ at the end of that? Pretty confusing stuff! ** 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
Re: [U2] UniVerse v11.2 private beta starting next week!
Hi Dan What's new in UV11.2 beta? Or is that not yet public yet? As per the private beta test... :) Cheers, David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath Sent: Monday, 20 May 2013 11:40 PM To: U2 Users List (u2-users@listserver.u2ug.org) Subject: [U2] UniVerse v11.2 private beta starting next week! Drop a line to u2as...@rs.com or your support partner if you want in. Spots are limited. Dan McGrath Managing Director, U2 Servers Lab Rocket Software ** 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
Re: [U2] canon ir4025 printer on redhat
UniVerse admin guide details printing options. Using the admin tools won't setup remote network interfaces by default. Hence, in unix you need to write/use the a UV spooler driver Unix script interface. From: u2-users-boun...@listserver.u2ug.org [u2-users-boun...@listserver.u2ug.org] On Behalf Of Dale Kelley [dalekel...@dalewkelleyinc.com] Sent: Friday, 3 May 2013 8:00 AM To: u2-users@listserver.u2ug.org Subject: [U2] canon ir4025 printer on redhat I have a customer who just got a Canon ir-4025 copier/printer/everythingelse. Unable to find a linux driver I downloaded a product called BrightQPro which allowed me to install the printer on the redhat system. I can print using lp or lpr, I can print web pages and from Office, but UniVerse cannot see the printer: Requested printer does not exist. Has anybody used these products, I have done everything I could think of about 7 times. Thanks -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/canon-ir4025-printer-on-redhat-tp40657.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ** 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
Re: [U2] History of Prime Information
Ah, I recall Prime small mini-tower (under the desk) ATT System V boxes too -the EXL 300 series which ran a re-branded version of UniVerse (PI/EXL I think). This was rolled out before the EXL 7000 series which were MIPS RISC/os based servers. I vaguely recall Prime was looking at Silicon Graphics and Sequent (the latter was bought by IBM) When PI/Open finally arrived it was great, but the loss of the Primos Batch subsystem and spooler was a bit of a culture shock and required some rewrites...Prime tried to port their Batch and Spooler products to UNIX (not that successfully as I recall!). UV at the time was a giant step backwards for Prime INFORMATION users in many respects but the catch the fact it got you off very old, slow expensive hardware. :) But even then they weren't cheap (by today's standards)... http://www.cbronline.com/news/prime_adds_to_exl_line_pick_netware_on_all_its_unix_kit For those interested the demise of Prime/CV is documented in these links partially documented here: http://www.fundinguniverse.com/company-histories/computervision-corporation-history/ I recall a story from some ex-Prime employees that ponder where Prime would be today...if only they purchased another company instead of Computervision...that company was Sun Microsystems... probably still in the same place! :) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Monday, 29 April 2013 6:59 PM To: 'U2 Users List' Subject: Re: [U2] History of Prime Information I think prime and vmark had done business together hence why the purchase - I remember back in 92/93 when we had a pair of prime 1920's (I think) running prime information, we then got a new prime unix box, that was actually a rebadged MIPS running Riscos, they said at the time that PI+ the new version of Information for unix was not quite ready but they would supply universe version 1 for free while they finished it off. Going from prime information to uv v1 was like taking a backward step, and we found a load of bugs in uv, esp with the locking tables, and deadlocks etc. Anyway we eventually got PI+ but I think it was just after that that Prime went out of business, we also used the CAD software, so we took the computervision CAD and ended up with PI+ but supplied by universe. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: 27 April 2013 14:54 To: u2-users@listserver.u2ug.org Subject: Re: [U2] History of Prime Information On 27/04/13 05:26, Wjhonson wrote: Okay but let's just talk about 1990-1993 How did Computer Vision exactly get its hands on Prime Information ? This happened *before* the final bankruptcy of Prime? Or did somehow Prime sell or spin off Computer Vision with Prime Information as well? iirc they didn't. Computer Vision did a sort of reverse buyout, taking Prime's CAD business with it. INFORMATION was sold to Vmark, and the hardware business was sold to ?Pericom? That might be why Pr1mos has ended up in copyright limbo. There was a White Knight involved in this, so I'm guessing that the breakup and sale was along the lines of PI to Vmark, software to Computer Vision, and hardware and support to this other company. With the result that it wasn't clearly specified who got the copyrights to Pr1mos and now nobody can do much with it because they don't know who actually owns it... Enquiring minds want to know Well, I might not be much good at enlightening, but I was around as a customer when it all happened ... Cheers, Wol ___ 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: 2012.0.2241 / Virus Database: 3162/5776 - Release Date: 04/26/13 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ** 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. **
Re: [U2] UV Creating a Soap Request
Hi Peter Is your SOAPAction correct?? The tempURI.org is a Microsoft standard placeholder - usually replaced by a proper URI or hostname name, etc. SOAPAction: http://tempuri.org/IJobService/CreateJob1UserPartyRole Cheers, David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter Cheney Sent: Tuesday, 16 April 2013 4:14 PM To: U2 Users List (u2-users@listserver.u2ug.org) Subject: [U2] UV Creating a Soap Request Hi Everyone, Recently I had some success getting a secure version of this to work etc. but now they want to change it to non-SSL so am trying to get plain old http to work. Using this example as a starting point: https://u2devzone.rocketsoftware.com/accelerate/articles/soap-api I've managed to (I think) translate the example above with our URL and soap action etc. but I have a question regarding the UV SOAPCreateRequest and hope someone may be able to assist. The URL I specify in SOAPCreateRequest is http://our-dev.domain.com/apps/jobs/Services/Job.svc However in the log file I get: 04/16/2013 15:05:16 [ 446706 925928 ] Assembled Request: POST /apps/jobs/Services/Job.svc HTTP/1.1 Date: Tue, 16 Apr 2013 05:05:16 GMT Host: our-dev.domain.com SOAPAction: http://tempuri.org/IJobService/CreateJob1UserPartyRole User-Agent: IBM UniVerse 11.x Content-Type: text/xml; charset=utf-8 Content-Length: 1670 The POST seems to be missing the first part of the URL and with the response being a 400 bad request I'm wondering if there's anything I can do to force the complete URL? In particular is there a SOAP command that I'm missing? Briefly I do the following in this order: Ret = setHTTPDefault( VERSION , 1.1 ) Ret = SOAPSetDefault( VERSION , 1.2 ) Ret = SOAPCreateRequest( URL , SoapAction , SoapReq ) Ret = SOAPSetRequestContent( SoapReq , PAYLOAD , 1 ) Ret = SOAPSubmitRequest( SoapReq, Timeout, RespHeaders, RespData, SoapStatus ) The return codes from above are: setHTTPDefault result = 0 SOAPSetDefault result = 0 SOAPCreateRequest result = 0 SOAPSetRequestContent result = 0 SOAPSubmitRequest result = 0 The SoapStatus from SOAPSubmitRequest above is: Response status : 400▒Bad Request The RespHeaders returned from SOAPSubmitRequest above is: Response headers : Cache-Control▒private▒Server▒Microsoft-IIS/7.5▒X-Powered-By▒4.0.30319▒X-Powered-By▒ASP.NET▒Date▒Tue, 16 Apr 2013 05:46:06 GMT▒Content-Length▒0 To me the soap action seems good and the xml in the payload looks ok too so it has to be something in the delivery. We're running UV 10.3.4 on AIX 5.3. Reckon I must be missing something above so looking at the basic ref manual but it does not indicate if any of the soap commands therein and the above have other dependencies/pre-requisites and in what order they should occur. I guess a prior soap knowledge is expected but I'm just starting to get into this so if anyone can assist that'd be really helpful thanks. Cheers Peter --- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. Firstmac Limited (ABN 59 094 145 963) (AFSL 290600) --- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ** 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
Re: [U2] is this an INDEX ISSUE?
Hello David 1) Is your file you're indexing corrupt or does it have any errors or warnings as reported by 'fixtool'? If corrupt, can you repair it (after backing it up:)) ? 2) What queries using the indices are slow? All or one? 3) What UV release? 4) How and when do you re-index the file? 5) Has the file been recently been resized/restored or otherwise changed? Cheers, David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of david yu Sent: Saturday, 13 April 2013 9:47 AM To: u2-users@listserver.u2ug.org Subject: [U2] is this an INDEX ISSUE? hello, We have a file that is updated almost every minute for transportation appointment, we index a field in a file to make the reporting much faster but recently we noticed when we ran the report not all the transportation appt shows up on the report, so customer doesnt get their transportation. We have been rebuilding the index every night but problem still exists. Anyone encounter this issue? we are on HP-UX b.11.23. thanks in advance. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ** 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
Re: [U2] UV Creating a Soap Request
Oops, yes - sorry for my misleading reply regarding the URIs. Tempui.org is a valid placeholder and you don't need to replace it. Have you tried now SOAPAction and what error do you get then? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter Cheney Sent: Wednesday, 17 April 2013 9:24 AM To: U2 Users List Subject: Re: [U2] UV Creating a Soap Request Thanks again David and Symeon for your replies I thought the SOAPAction was correct but now am not sure. If I browse to the WSDL schema I see the following spec though. Would this mean the 'tempuri.org' should be replaced with 'our-dev.domain.com' in the WSDL too? wsdl:operation name=CreateJob1UserPartyRole soap:operation soapAction=http://tempuri.org/IJobService/CreateJob1UserPartyRole; style=document/ wsdl:input soap:body use=literal/ /wsdl:input wsdl:output soap:body use=literal/ /wsdl:output /wsdl:operation I went and checked out the www.webservicex.net site (from the e.g. below) and looking in there and comparing to what I had and they seem to be pretty much a match except for the domain part of the SOAPAction. So perhaps I need to look elsewhere? There seems to me to be only 3 variables at play here: The URL, the SOAPAction, and the XML request. Given that I've just finished fiddling with the URL and SOAPAction with no apparent change in the log output I'll turn my attention to the XML ... One other question is it possible to query the WSDL from UV? Cheers Peter ** 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
Re: [U2] How do you print a .pdf from inside a Unix Box
First up - Adobe PDF is a subset of the Adobe Postscript page description language (PDL). Some printer vendors have Postscript emulations. Most business class laser/LED printers or multi-function devices (MFDs) today have intelligent page description language detection built in and typically analyse the datastream before attempting to do anything with it...mean that they can switch between plain text from UniVerse or UNIX or PDF/Postscript or HP PCL / PXL formats and others on-the-fly... Some modern printers have Adobe PDF and Adobe Postscript (or an emulation) built-in. Meaning they can be sent files in either format. . (Side note - Google: PDF Direct Print support). If you have printers are capable of accepting Adobe PDF files - then just simply submit an those files direct to the printer from your host. If your printer has Adobe Postscript or a Postscript emulation - you translate the PDF data file into 'native' Postscript via Ghostscript or similar toolset prior to sending it to the printer. If you don't have any Postscript capable printers - you can - using Ghostscript translate the file from PDF into HP PCL or similar PDL (many are supported). Then send the generated output to your printer queue. You can write custom version of the Ghostscript supplied 'ps2pdf' script to generate to PCL file from an Postscript file (and call the script, say ps2pcl). It's not difficult to customise this scripts for your own output device (printer, image file, etc)... have done this before... As implied by others - you won't have the same capabilities nor any options to dynamically or selectively control over the output (orientation, N-up printing, duplex, tray selection, page-fit, paper type, copies, page range, etc)... that you can perform from Windows Acrobat PDF viewer. An alternative to this is to perhaps utilise one or more host-based printer print queue defined for (some of these may be feasible) such printing preferences, etc. HPJetDirect for HPUX and other UNIX platforms is pretty feature rich especially when talking with HPDirectJet printers... See what Adobe has on this issue here: http://www.adobe.com/products/postscript/pdf.html Cheers, David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bruce Conway - Bamac LTD Sent: Friday, 5 April 2013 2:54 AM To: 'U2 Users List' Subject: [U2] How do you print a .pdf from inside a Unix Box I may have missed this discussion but if someone can help me that would be great. We have been executing a SB command to windows to open Adobe and print the PDF document. We would like to either not have to open Adobe and print the document or print the document from within our Unix box. We have a hp7640 11iv3 running on an Itanium processor. Here is the Unidata information: Module Name Version Licensed UniData RDBMS 7.2 Yes Connection Pooling... 7.2 No Device License... 7.2 No NFA.. 7.2 No RFS.. 7.2 No EDA.. 7.2 No 721 Oh, love this list, I have been using Pick since 1985 and still going strong. Bruce ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ** 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
Re: [U2] [uv] Message[010252]
Hi Adrian The SYS.MESSAGE file has all the system messages... DAVID: CT SYS.MESSAGE 010252 010252 0001 Message %i is either invalid or not found in the SYS.MESSAGE file. 0002 I have no idea what it really means. I'd check if that particular has an existing UV process and has a pre-existing shared memory segment for a start... (likely to be unrelated)... this is not a UV process executing via crontab is it?? Cheers, David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Adrian Overs Sent: Thursday, 4 April 2013 12:04 PM To: U2 Users List Subject: [U2] [uv] Message[010252] I am getting the above obscure error message when a particular user tries to invoke the uniVerse environment /usr/lpp/uv/bin/uv AIX v5 and uniVerse 10.1.22 can anyone please help me by telling me what this means? Or better yet how I can find out for myself? Sent from my iPhone ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ** 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
Re: [U2] UV: Consuming https service from within UVBasic using SOAP
You're welcome Peter. Sounds like you're past first base (communications OK) and now the challenge is handing the XML data exchanges. That will be fun! Will you use be the UV BASIC XML DOM routines? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter Cheney Sent: Wednesday, 6 March 2013 11:37 AM To: U2 Users List Subject: Re: [U2] UV: Consuming https service from within UVBasic using SOAP Hi again, Finally had a chance to get back to this and have had success using a slightly modified version of the code here: http://www.mail-archive.com/u2-users@listserver.u2ug.org/msg17243.html After reviewing David's suggestions below and confirming the certificate requirements, the only areas requiring change were the URL (to the https url we had set up), and the path to where our client certificate accessible by UV (e.g. /opt/uv/certificates/Client-Root.cer) This brought some success as I was at least getting a response from the webserver but it was an error code 415 indicating incorrect mime type. e.g. 415 Cannot process the message because the content type 'application/x-www-form-urle. (the output is truncated but is just enough to get an idea of what is wrong) Then I discovered that the http_method parameter for 'POST' in the createSecureRequest function has a default mime type of application/x-www-form-urlencoded so I changed the HTTP.POST variable from POST to POST:application/soap+xml. Hey presto! Now I get this reply from the webserver: e.g. ResponseHeaders : Content-Length▒518▒Content-Type▒application/soap+xml; charset=utf-8▒Server▒Microsoft-IIS/7.0▒X-Powered-By▒ASP.NET▒Date▒Tue, 05 Mar 2013 23:41:35 GMT ResponseData: s:Envelope xmlns:s=http://www.w3.org/2003/05/soap-envelope; xmlns:a=http://www.w3.org/2005/08/addressing;s:Headera:Action s:mustUnderstand=1http://tempuri.org/IJobService/CreateJob1UserPartyRoleResponse/a:Actiona:RelatesTourn:uuid:5af711cc-4ed3-4208-baa1-48aa9f74af60/a:RelatesTo/s:Headers:BodyCreateJob1UserPartyRoleResponse xmlns=http://tempuri.org/;CreateJob1UserPartyRoleResult513682af531c9e1090b67f20/CreateJob1UserPartyRoleResult/CreateJob1UserPartyRoleResponse/s:Body/s:Envelope HttpStatus : 200 OK Many thanks again to David and Symeon for their assistance in this. Cheers Peter PS My code at this stage is only a prototype and is functionally the same as the example in the URL above but if anyone would like a copy then please let me know. ** 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
Re: [U2] UV: Consuming https service from within UVBasic using SOAP
Hi Peter, You easily change that sample source code try amending these lines to access any SSL webserver/appserver. For example the Firstmac.com.au website using SSL by default I see - so that'll be a good site to use as an worked example - that uses a CA Root certificate. Basically, all you'll need a copy of you GeoTrust's root certificate accessible by your (UV SOAP/HTTP) client application. You must upload this (or any other SSL certificate) to your UV host and tell you UV application where it can be found... * Assumes client host can resolve and access this URL * For HTTPS SSL www.firstmac.com.au is using GeoTrust CA certificates, hence upload a DER copy of it first. URL = https://www.firstmac.com.au/home; * Define the full path to the GeoTrust CA Root certificate, uploaded to the host (exported in DER format) X.CERT.PATH=@PATH:/geotrust.cer ;* Full path to a DER copy of GeoTrust CA Root Certificate X.USED.AS=2 ; * 1=Self-signed, 2=CA Issued certificate X.FORMAT=2 ; * DER format X.ALGORITHM=1; * RSA key Hope this helps. The CA Root SSL certificate business is complex and is part of that steep learning curve! Good luck! Cheers, David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter Cheney Sent: Thursday, 21 February 2013 11:44 AM To: U2 Users List Subject: Re: [U2] UV: Consuming https service from within UVBasic using SOAP Hi David, Thanks for the url - am going through this now and the accompanying log. It seems the host not found in hostlist error is not an issues so will continue investigating other causes. I do believe the answer will lie somewhere in my own malformed request so just need to work it out I guess. Will post updates as this progresses. Many thanks, Cheers Peter -Original Message- From: u2-users-boun...@listserver.u2ug.orgmailto:u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Hona, David Sent: Wednesday, 20 February 2013 20:17 To: U2 Users List Subject: Re: [U2] UV: Consuming https service from within UVBasic using SOAP Peter, As Symeon mentioned, protocol logging is required to help troubleshoot issues. If you like to use Firefox, the 'Firebug' plug-in is helpful to see what goes on behind the scenes - but only once you have familiarised yourself with the basic concepts of the HTTP protocol. Otherwise, not much will make much sense... The variable unassigned and UV version, shouldn't be an issue... we got UV SOAP going on UV10.1 ...years ago... using the IBM UV sample code mentioned in this URL: http://www.mail-archive.com/u2-users@listserver.u2ug.org/msg17243.html We cloned this code for a proof of concept and our version worked for us (if I recall correctly)... Obviously (maybe not), this is sample code in the URL will not actually work anymore - if actually did all those years ago (I can't recall) but it should give you a heads-up so to speak and point you in the right direction (more or less - hopefully more!)... Regards, David ** 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
Re: [U2] UV: Consuming https service from within UVBasic using SOAP
Peter, As Symeon mentioned, protocol logging is required to help troubleshoot issues. If you like to use Firefox, the 'Firebug' plug-in is helpful to see what goes on behind the scenes - but only once you have familiarised yourself with the basic concepts of the HTTP protocol. Otherwise, not much will make much sense... The variable unassigned and UV version, shouldn't be an issue... we got UV SOAP going on UV10.1 ...years ago... using the IBM UV sample code mentioned in this URL: http://www.mail-archive.com/u2-users@listserver.u2ug.org/msg17243.html We cloned this code for a proof of concept and our version worked for us (if I recall correctly)... Obviously (maybe not), this is sample code in the URL will not actually work anymore - if actually did all those years ago (I can't recall) but it should give you a heads-up so to speak and point you in the right direction (more or less - hopefully more!)... Regards, David ** 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
Re: [U2] U2 Test Tools for system/unit regression testing w/integration with HP QualityCenter
Thanks Brian - that sounds great! I would be keen to get a trial version, once you have a SSH capable version. How is the product licensed? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: Tuesday, 5 February 2013 10:14 PM To: 'U2 Users List' Subject: Re: [U2] U2 Test Tools for system/unit regression testing w/integration with HP QualityCenter Hi David I've recently released a testing product called (predictably!) mvTest. This supports automated testing of U2 applications using a dedicated scripting language modelled after UniBasic for familiarity but with a number of key extensions to handle data validation, test data handling, UI scripting and assertions. You can use this to create unit tests, UI tests (currently TELNET and U2-compatible secure TELNET/SSL but with SSH to follow shortly), regression and volume tests. Here's a quick overview of how it works - - You create unit or UI tests using the scripting language. These can be run through either of a Windows client or through a server-side script runner e.g. if you want to perform CI testing through a phantom. There's a nice Windows based editor to create, organize and test these. - The tests return pass or fail information based on assertions, so you can see at a glance if anything has broken. You can save the information and run various reports against it. - The tests can run direct against the database through a UO.NET connection (e.g. for testing subroutine calls and parameters) or through a terminal-style UI. It embeds a complete terminal emulator with all the necessary functions, and this allows you to drive screens, perform spot checks, branch on different results (e.g. handling error messages raised from your screens), handle send/expect style scripting and more complex conditions (such as wait until the cursor is at this location and this message has appeared here). - It keeps a separate shared server connection open while the UI tests run so you can, for example, script an entry screen via the terminal UI that ends up saving some data like a sales order, and then immediately check what has been written to the database through the underlying connection as part of the same script. - Unit tests can be organized into batches in which the tests run in order, so you can set up sequences that match business operations. - Batches can be organized into runs, so you can test whole suites of your application. Each run can be customized, so you can feed in per-site or per-system information. Runs can optionally randomize the order in which batches are executed, and you can set up different run scenarios and iteration patterns. - You can feed in and randomize test data and from the client side runner, access local features as well as the database operations. - Volume testing can take place using the Windows client. This is a multithreaded client supporting multiple concurrent UI sessions - I've tested up to 250 concurrent connections from a single PC running against an SB+ system for one customer last year who needed to stress test their SB+ system performance coming up to the New Year sales. This first release is targeting U2 with other MVDBMS to follow. I'm also adding support for GUI testing using the Microsoft Automation APIs and WebUI testing going forward. Anyone interested can contact me for an evaluation version, or download the user guide from www.brianleach.co.uk. Regards Brian ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ** 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
Re: [U2] [UV] Large File Operations Kill Linux
Yes, sounds like it's been identified and fixed a while ago... like Dan says...kernel update will the simple way to address it... (time outage permitting) https://bugzilla.redhat.com/show_bug.cgi?id=735946 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan Fitzgerald Sent: Tuesday, 5 February 2013 9:32 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [UV] Large File Operations Kill Linux Other users could have been hanging at malloc. With a swappiness of 100 (on some kernels) or 100 (on others) or not 0 or 100(not sure which behavior you get on 2.6.18), pages wouldn't be getting freed up quickly enough duing the creation/copying of a large file. Another thing to look at (although I prefer the support route, since you have it), is /sys/kernel/mm/transparent_hugepage/defrag. Other people who have had this problem alleviated it by setting this to never. Of course, others fixed it by updating the kernel. My aged eyes read what you have as 2.6.8.1... ** 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
[U2] U2 Test Tools for system/unit regression testing w/integration with HP QualityCenter
Hello All, I am just wondering what U2 or UniVerse specific integrated testing suites people are using out there and ideally in use today. We have the need for a UV11.x specific or capable tool for automating our existing system/unit and regression test packages. We have a our existing test suites/scripts in HP QualityCenter (HPQC) and we currently manually capture and store the results (plus track 'defects') there as well. Ideally, this tool should be able to integrate with HPQC. At minimum some means to capture results - test case number plus success/failure to a file. Our primary application interface is via a terminal interface via SSH emulating VT220 terminals. But we also use various interfaces UV Clients APIs or third-party utilities (accessed via UNIX shell scripts or the like). Ideally, testing package should be able to drive (simulate keystrokes via keyboard entry) or invoke all of these in some fashion. Hence some sort of scripting of terminal emulator or UNIX shell and/or client APIs would be ideal. Another requirement is a tool that has the ability to perform simulated end-user terminal session load testing (ie., connect X number of users via terminal emulation over SSH and perhaps client APIs too) - we would could simulate actual users interactive access and run X, Y or Z test scripts. The primarily purpose of this is to simulate database record locking contention, etc. under load, etc. Plus other stress testing under load. Your solution could be a commerical product or a perhaps some in-house tool or opensource or combination thereof...whatever it is - I'd be interested to hear about this tool or your experience of attempting to do this. Thanks in advance for any feedback. Cheers, David ** 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
Re: [U2] [UD] Disabling/blocking ODBC
Brian, *UOLOGIN works for me in UV11.1.9 AIX. What arguments are you specifying? I haven't got been able to get *ODBCLOGIN to work. I'm speculating if the arguments the same though - such is the nature of undocumented features? Perhaps they should have *APILOGIN to for all API clients? Plus a new @-variable that can identify what server-side interface is handling the call - thus eliminating the need for UOLOGIN and ODBCLOGIN... ? Cheers, David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: Tuesday, 29 January 2013 8:05 PM To: 'U2 Users List' Subject: Re: [U2] [UD] Disabling/blocking ODBC Sadly these appear to be UniData only. Or at least, in the past I've tried with local catalog, global catalog as *UOLOGIN and global catalog as the (illegal) UOLOGIN. None of these got fired. Would be really useful as a central consolidation point for things like setting DATE.FORMAT. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Phil Walker Sent: 28 January 2013 21:23 To: U2 Users List Subject: Re: [U2] [UD] Disabling/blocking ODBC Is this only Unidata or Universe? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath Sent: Tuesday, 29 January 2013 9:15 a.m. To: U2 Users List Subject: Re: [U2] [UD] Disabling/blocking ODBC Glad to hear that! Regards, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of bradley.sch...@usbank.com Sent: Monday, January 28, 2013 12:25 PM To: U2 Users List Subject: Re: [U2] [UD] Disabling/blocking ODBC There is an undocumented feature: ' ODBCLOGIN'. This is a subroutine that is called for every ODBC call. You can use this to either blank prevent ODBC, or setting up restricted login access login. Dan, I got the info from our VAR and it works great. Thanks! 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 ___ 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 ** 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
Re: [U2] Universal COMO
So you do what you want to do, but not hard code it and hence require manual updating of all those VOCs. When you want to move for some reason...like lack of disk space or a new disk letter... UD also supports multiple version to operate on the same host/server...done mainly through the use of shell variables to point to proper version. Much like you can do with Oracle too. Now that would be handy if UV could do that too...especially when upgrading/test new releases, etc. Back to your query... In the past we use to have multiple UV accounts from the old legacy systems. But then we bit the bullet and simply created a single account. Not all sites can do this if you have duplicate filenames. We had few files like this and just renamed them and end up prefixing the duplicates with the (original) account name to ease the transition. Then we just change any applications/dictionaries that use to refer to. We didn't have any issues with duplicate HOLD, SAVEDLISTS nor COMO filenames. But you do have to aware of potential gotchas like this when applications start overwriting each other's' output. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Thursday, 24 January 2013 7:07 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Universal COMO What's the reason for using a variable, @MY_COMO, instead of the actual path ? -Original Message- From: Bill Haskett wphask...@advantos.net To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, Jan 23, 2013 7:22 pm Subject: Re: [U2] Universal COMO In UniData (on Windows) this is pretty simple. First you create an environment variable for the como file (e.g. MY_COMO) that points to the directory under which you've created a _PH_ directory and a D__PH_ dictionary file. Then you create a VOC item as follows: _PH_ 001 DIR 002 @MY_COMO\_PH_ 003 @MY_COMP\D__PH_ ...to include in every account's VOC file. This will now act as a centralized como repository. I do this with the _HOLD_ directory, as everyone on our machines share the same spooler file, and each spooler file name is a unique .txt file. I'm sure it would be even easier on a nix machine. :-) Bill ** 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
Re: [U2] Database time question
Potentially simple approach is to have separate server or virtual machine for your other UDT environment setup with the desired timezone. No code changes. On AIX, you can setup a WPAR for stuff like this pretty easily. Or change you source code... The best solution depends on if you control the source code for the application and how it currently extracts and utilises the time information. By implication, you will also need to separately maintain the date information as well in your application. Especially, if it cross the multiple timezones or the international dateline... One approach is to ask the user to specify the timezone they wish or simply force it when they get into the respective account. Then you merely store a time offset (to your servers real time zone) in a separate field in addition to the time / date fields in your respective files (perhaps using a file based trigger if you don't want to change the code). Then just update date time display routines (a good time to make sure you have a single routine) to check if there is an offset and apply prior to displaying. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Frailey Sent: Thursday, 24 January 2013 4:45 AM To: U2 Users List Subject: [U2] Database time question Running unidata on hpux11.11i I have two databases in unidata that I would like to operate at different time zones. Lets say my Midvale database is set to mountain standard, USA which is also the base unix kernal time. I have an account called Austrailia, I would like it to run on australian time. Any ideas on making a unidata database independant of the unix kernal time. Thank You Robert Frailey Manager Information Systems Utah Medical Products Inc. Femcare-Nikomed Ltd. rfrai...@utahmed.com 801-569-4016 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ** 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
Re: [U2] External database
http://u2.rocketsoftware.com/downloads/whitepapers/64_Bit_Question_wp.pdf Advice here is free here, but the it may cost you later if you don't plan, execute, test and know what you're doing. Given your responses to queries it very much sounds like you some need technical advice/help...contact U2 Professional services or a U2 certified VAR in your area/region/country. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of asad50089 Sent: Tuesday, 15 January 2013 2:22 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] External database Hi, Thanks for guidance. Please let me know, my most of the work is on UniVerse 32-bit edition including massive coding in infobasic as well. Now if I turned 64-bit on switch, what will be the complications I can face otherwise it will be safe ride? Do I need resize all files again and also compile code on 64-bit? Cheers Asad -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/External-database-tp39618p39634.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ** 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
Re: [U2] [UV Retrieve] Selecting file based on partial key
This may help you... https://u2devzone.rocketsoftware.com/accelerate/articles/u2-select/u2-select -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter Cheney Sent: Tuesday, 15 January 2013 2:10 PM To: u2-users@listserver.u2ug.org Subject: [U2] [UV Retrieve] Selecting file based on partial key Dear U2 List, Is the below at all possible in universe retrieve please? I didn't think it was but there're a lot more clever people out there than I plus it's been too long since I was doing this regularly and cannot remember if it is or not. I cannot see anything obvious in the manuals. We have a file in a production environment with 5477108 records whose @ID/Key are all '9-digit-account-number':'4-digit-sequence-number'. Q. Is it possible to obtain a list of @ID's based on a separate saved list of '9-digit-account-number'? The remaining record fields are all out of scope for the selection apart from an internal date in attribute 4 but that can be interrogated later. Is it possible to construct a kind of reverse select based on my existing saved-list and pass this data into a dict item for the account number? I've tried numerous permutations of this but have yet to find the answer. Or can I do something lie an sql SELECT FILENAME WHERE ACC_NBR = 'GET-LIST ACC_LIST'? How is this done on a (live) normal type 18 UV file? Of course I can always whip up some basic code to do this but it is production and getting it there will take a while. (and no I didn't design the file layout ...) Many thanks in advance. Regards, Peter --- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. Firstmac Limited (ABN 59 094 145 963) (AFSL 290600) --- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ** 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
Re: [U2] [UV Retrieve] Selecting file based on partial key
I meant to add what was the original selection criteria...so you could write a SQL SELECT with a join to filter out the records you want to include/exclude... Barring a non-programming solution you have to write, here's one someone else already has written... :) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Hona, David Sent: Tuesday, 15 January 2013 6:27 PM To: U2 Users List Subject: Re: [U2] [UV Retrieve] Selecting file based on partial key This may help you... https://u2devzone.rocketsoftware.com/accelerate/articles/u2-select/u2-select -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter Cheney Sent: Tuesday, 15 January 2013 2:10 PM To: u2-users@listserver.u2ug.org Subject: [U2] [UV Retrieve] Selecting file based on partial key Dear U2 List, Is the below at all possible in universe retrieve please? I didn't think it was but there're a lot more clever people out there than I plus it's been too long since I was doing this regularly and cannot remember if it is or not. I cannot see anything obvious in the manuals. We have a file in a production environment with 5477108 records whose @ID/Key are all '9-digit-account-number':'4-digit-sequence-number'. Q. Is it possible to obtain a list of @ID's based on a separate saved list of '9-digit-account-number'? The remaining record fields are all out of scope for the selection apart from an internal date in attribute 4 but that can be interrogated later. Is it possible to construct a kind of reverse select based on my existing saved-list and pass this data into a dict item for the account number? I've tried numerous permutations of this but have yet to find the answer. Or can I do something lie an sql SELECT FILENAME WHERE ACC_NBR = 'GET-LIST ACC_LIST'? How is this done on a (live) normal type 18 UV file? Of course I can always whip up some basic code to do this but it is production and getting it there will take a while. (and no I didn't design the file layout ...) Many thanks in advance. Regards, Peter ** 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
Re: [U2] External database
As long as your OS and the filesystem is already 64-bit enabled - you should be able to resize the UV file to 64BIT (make sure you have a verified backup first :)). Otherwise, use UV distributed file create a logical file view of your UV physical files. Note that BCI is a programmatic API interface only - that implements OBDC calls, it's not a DB-level interface of likes of EDA or UV/Net, etc. Useful largely with batch-like operations to push/pull data. Since you already use Nabble, search the U2 forums there for UV ODBC setup... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of asad50089 Sent: Sunday, 13 January 2013 7:20 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] External database Many thanks, In fact I am running old version of UniVerse 9.6 and due to is limitation of 2GB file, I am designing an interface to transfer data from U2 data files to Oracle. In this regard I have heard about ODBC drivers but very little knowledge how to use them. I will be grateful if you can guide by an example how to configure ODBC/BCI driver for this task. Regards Rauf ** 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
Re: [U2] How to check which sproc is called by user
Here's some troubleshooting tips we use for our applications using the U2 APIs in background non-interactive processes. We have a common interfacing subroutine our API clients must use to sign-on and initialise their UV environment. In that code, we turn on COMO output, to capture any output that BASIC code or any other UV command may output. We tend to generate unique COMO filenames, with the OS user ID, process-ID, UV User No. and a date stamp - as typically you're executing multiple instances under the same user ID. With this, we can see what unexpected input or output is captured. Otherwise, you never really know what's going on. For further debugging we have a debug subroutine we can put into a code to log messages to a sequential file with details of what step or data is being processed. We use to as a non-invasive way to capture detail information. It is really just something of a glorified PRINT statement you'd have in BASIC program you'd place to debug it when running from a terminal session...but written to a unique log file for each background process. We've found it valuable in the past - especially in the development stage to do this. Then remove it or disable it later. You don't mention if your UniObjects code is designed to interact with interactive UV BASIC or UV commands. This could be an issue regardless, if someone changes code that expects terminal input and none is forthcoming. If you don't already, have a ON.ABORT and ON.EXIT paragraph setup to log the fact that your API process has triggered that. Just simply outputting the fact it got executed should be sufficient. This you know if aborted or cleanly exited UV - something which isn't always easy to determine due to lack of decent session event logging in UV. We also have a protocol that API processes must sign-off so we can tell if they cleanly exited from the application. This is useful as well. Likewise, the application has a transaction log which flags when the update transaction starts. That isn't cleared, if abnormal termination of the application occurs. Further nor future transactions aren't possible for the user ID until it is cleaned/investigated - but that's then logged. Cheers, David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Andy Krause Sent: Wednesday, 9 January 2013 1:44 AM To: U2 Users List Subject: Re: [U2] How to check which sproc is called by user I will chime in since I work with Ravi and I am dealing with this issue along with him. Thanks for the response Brian, PORT.STATUS should be useful for our situation. I'll try and be a little more specific and hopefully I know what I'm talking about: We have a web application which is using UniObjects and we are randomly getting multiple (we've seen as many as 9) user sessions in the LISTU which appear to be hung and it's causing us to reach our user limit. We have debugged the web application and verified that all sessions are being closed properly so we do not believe that it's on the web side of things. Although, we cannot duplicate this problem in the live application either, so we cannot say for sure it's not on the web side. My first thought was that the application is calling a PICK subroutine that is stalling (possibly waiting for input or stuck in an infinite loop or something). So, at this point all we know is we are getting these stalled sessions but we don't know how. Hopefully with PORT.STATUS we can see whether is a PICK subroutine that is stalling? Now, to limit the severity of this problem we discovered there is a Timeout property of the UniSession object. However, it seems in the past we were advised against setting this parameter by Rocket support and that this timeout should be handled in the unirpcservices file in the unishared directory? Does that sound right? UniAdmin uses the timeout in the unirpcservices file so I don't think we would want to shorten the timeout and be booted from UniAdmin sooner. Thanks in advance for any responses. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: Tuesday, January 08, 2013 3:35 AM To: 'U2 Users List' Subject: Re: [U2] How to check which sproc is called by user If it is a session hang you're possibly looking at locking issues so check the lock table to see what is waiting and also check for any group locks that persist. If it is UniVerse, It's also a good idea to check the errlog file in the uv account: if that does not exist, create it as a zero length file (you can go into the UV account and ED UFD errlog and just file it) and it will log the last 100 errors. If you can catch the session that has hung you can use the PORT.STATUS command to see where they were and their calling stack. Phil's idea of using the remote item security subroutine to audit calls is
Re: [U2] Garbage in locks
Looks like UV? What version or platform? Did these user process normally exit UV or did they drop connectivity or abnormally terminate from UV?? UV Lock Daemon typically cleans-up non-deadlock locking issues, including orphaned locks (sometimes :)). -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Holt, Jake Sent: Tuesday, 8 January 2013 8:17 AM To: u2-users@listserver.u2ug.org Subject: [U2] Garbage in locks Is there a way to resync, or clean the lock list? It seems like every once in a while we will get garbage in the lock list that will not go away until we reboot.The users are long since logged off and these locks do not show up in uniadmin. It doesn't actually seem to do anything other than make it hard to find active waiters. Example: Active Read Waiters: Owner Waiter Device Inode Userno Userno 10465106915866934427836 62692 10465106915866934427836 58520 104651069158669344278365836 20297666099756827340769560 20297666099756827340768264 115824063137137493724007836 2029766609975682737836 236 20297666099756827378365216 20297666099756827378367912 2029766609975682737836 59820 20297666099756827378363424 20297666099756827378367140 Thanks, Jake Holt |Information Technology Director Samsill Corporation 5740 Hartman Rd | Fort Worth, TX 76119 (817) 536 - 1906 x 217 | Fax (817) 535 - 6900 www.samsill.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ** 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
Re: [U2] [UV]Corrupted object in global catalog
Here's some options for you... 1. Verify it is cataloged in Global Catalog The subroutine !EXIST subroutine was created for Prime INFORMATION compatibility and does a simple check to verify the program is catalogued only. Check out the source code in UV account APP.PROGS, EXIST. 2. Verify Object code matches The VCATALOG verb is also used to verify the compiled object in your BP object file and the Global Catalog space are the same. (Interestingly, on my UV11.1.9/AIX system, VCATALOG isn't working! :-( ). 3. Extract detailed object code header data Finally, writing your own custom verification utility combining VLIST verb and/or Gyle Iversons' excellent (NB: I understand he will soon close down this website) SRS.UV.HEADER subroutine to extract header information from the global catdir and your BP object file for comparison purposes. URL: http://www.srs4uv.com/srs_uv_header.htm -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of bpa...@serta.com Sent: Saturday, 29 December 2012 2:32 AM To: u2-users@listserver.u2ug.org Subject: [U2] [UV]Corrupted object in global catalog Greetings, all! We have recently upgraded to the latest version of our vendor's software, and in the process have gone from Pick flavored accounts to Ideal flavored accounts. This has drastically changed the way programs are cataloged, as we are now using the global catalog directory (catdir, aka GLOBAL.CATDIR). We have discovered that some of the object code in the global catalog is corrupted (for lack of a better term). It looks like some of the object code files were somehow truncated. Since we don't discover this until someone notices that a program is behaving oddly, or working differently between the different servers (dev, test, production), and since the date stamp on the file in the catdir directory is the last time someone ran the program (as opposed to the time it was actually cataloged), it is impossible to tell if the object code was 'bad' from the beginning or got corrupted somewhere along the way. At this point, we can just recatalog everything. It would be a royal pain, but it is possible to do. That would ensure everything was all good right now, but doesn't do anything to make sure it stays that way. Does anyone know if there is a command we can ruin or some other way to verify object code in the global catalog? We would much rather monitor this proactively than wait until a user runs into a mysterious issue that we can't explain - or worse, runs something that ends up corrupting data because of a problem with the object code. Of course the ideal would be to figure out what's corrupting the object code to begin with - or to be able to determine if it was somehow corrupted in the initial install and we're just running into the bad pieces now. Without being able to monitor the object code and see when/if it gets corrupted again, though, that's going to be almost impossible. Any assistance would be greatly appreciated! Thanks! Brian _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material not intended for Public use. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is strictly prohibited. If you received this communication in error, please notify the sender and delete the material from any and all computers or devices. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ** 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
Re: [U2] Universe 11.x
Your mileage will vary - the more UV specific features or APIs or the like you utilise - they more issues you're likely to have. As these tend to change at each release. If on the other hand, you have plain vanilla application then you're unlikely to have issues...then all you're doing is project managing your migration to a new host, UV release and performing testing to ensure you configuration, software and end-to-end processes are A-OK afterwards. As with any software release - carefully review the release / technical notes - especially if you have any mind any new feature you wish to use. Caution and clear objectives on how and why you're going to implement ADE is recommended. It's a greatly improved facility over previous versions - with some new features added to dramatically improve it and easy administration. However, never buy or use version 1.x of any software - extra care (and testing) is needed (especially reading the tech / release notes so you're fully aware of known issues - some which can be OS and release specific). Some good test cases for worse cases scenarios for ADE would be recommended too... also think about what would happen if you needed to retrieve encrypted files from backups. Will these same backups include the UV version/keys, etc. that you can restore the data in any unencrypted form? Is the administrative overhead of maintaining a ADE database files really worth it? Would OS-level filesystem encryption be a better choice? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Oaks, Harold Sent: Saturday, 15 December 2012 4:16 AM To: U2 Users List Subject: [U2] Universe 11.x Universe folks: Who has upgraded from Universe 10.x to Universe 11.x lately? Is it painless? Like - get the users out, install Universe 11.x in 5 minutes, then get the users back in. Then, as time permits, take advantage of the new features within Universe 11.x. Or - is it a big deal to install it? My manager is interested in data encryption in the underlying data. It is my understanding the Automatic Data Encryption (ADE) only exists in Universe 11.x. Is that right? If the install is simple enough, that would seem to be the way to go to obtain this feature for all fields. Thanks- Harold Oaks Clark County, WA 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 ** 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
Re: [U2] Advantage of indirect call in BASIC
If you encounter this, it is probably a Prime INFORMATION (PI) legacy code. As this was a commonly used convention in natively developed PI applications (rather than PICK-ported apps). As globally catalog'd object was a typical naming convention for production object in PI. Plus as mentioned by others it was also primarily for performance reasons. Some of those performance reasons still exist. If you don't resolve the subroutine name in your BASIC code, then the VOC file has to be referenced to find out the true catalog name. If you define and call a variable - if by-passing the VOC calling entirely. Of course there were many non-native applications running on PI from the PICK world that never took any advantage of this and many other PI features. Legacy PICK code tends to be account catalog centric (ie., *MYACCT*MYOBJECT). So typically doesn't use this convention, we use this convention to define test / non-production object code in the catalog space. Hence, we also use it to load/deignate different versions of the object code dynamically. Our account initialisation code defines *CATALOGNAME as the production code. When initialising on logon to the UV account, It then checks the local VOC for any different definitions in the local account - and asks the test user (not end-users) if they wish to local that object version. This allows versions of the code to be loaded for different users - for testing and pre-implementation purposes - on demand. For example, we run to run *V1.1*SOME.PROGRAM rather than *SOME.PROGRAM. This is especially useful if you share your single UV environment with multiple accounts and versions of your software. This saves having change VOC entries too, but of course you can do that too. But then if you have some users that don't what or need to test that version - then how would you control/enforce that? Regards, David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, 4 December 2012 11:39 AM To: u2-users@listserver.u2ug.org Subject: [U2] Advantage of indirect call in BASIC I've not encountered this is my career previously, but now I'm seeing a system written almost entirely with the use of indirect calls in Universe BASIC. That is SOURCE = *SOME.PROGRAM ... CALL @SOURCE(INPUTS) Is there some advantage to the use of indirect calls that a system would be written entirely in this fashion? ** 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
Re: [U2] New Rocket U2 website!
Looks good and well organised A new addition to the Rocket U2 team, I see! Totally RAD! :) http://u2.rocketsoftware.com/images/minihome/sbxa/sbxa_rad.png The learn more icons the rolling animation are all a bit too large...and the text in the footer section too small...but looks good - nice and clean look. But those big parts are perfect for us U2 old timers with our multi-focal specs anyways! :0 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Friday, 26 October 2012 2:52 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] New Rocket U2 website! why are you using that odd mask? http://u2.rocketsoftware.com/ -Original Message- From: Daniel McGrath dmcgr...@rocketsoftware.com To: U2 Users List (u2-users@listserver.u2ug.org) u2-users@listserver.u2ug.org Sent: Thu, Oct 25, 2012 1:59 pm Subject: [U2] New Rocket U2 website! For anyone who wants to check it out, we have launched a new website today: http://goo.gl/ON5qL Let's know what you think! Cheers, Dan ___ 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 ** 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
Re: [U2] [BDT] A giant leap forward
Yes, it is a vastly improved beast over earlier versions. Like others, I not a fan of the timeout of the UniObject session. BDT has features the competition has yet to add. I especially like being able to expand the inserts and see the BASIC Labels easily accessible. I still haven't been to get to SSH to our hosts, but I have never had the time to dig in the whys, etc. It is still worthwhile looking at U2Logic XLR8Editor and Brian Leach's freeware Windows thick-client MVDeveloper. I don't use any of these tools myself (occasionally fire up BDT)... but have trialled an early version of XLR8Editor...and trialled MVDeveloper. www.u2logic.com/tools.html (the links to download the documentation seem to have gone AWOL) http://www.brianleach.co.uk/pages/mvdeveloper.htm Each has unique features which means you choose the one the suits your needs. Or use all of them! I'm not a big fan of Eclipsed based products. I loathe the wealth of non-functional menus, menu-items that they all seem to have. Its weird shoving your specific tool into some else's generic tool framework. In general dedicated software tool vendors tend to much more responsive to feedback and bug fixes, etc. They have a short lead time / development cycle so are able to be more 'agile'. For us 'dabblers', this isn't such a big thing. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath Sent: Thursday, 25 October 2012 9:17 AM To: U2 Users List Subject: Re: [U2] [BDT] A giant leap forward Thank you, it's always great to hear when we've hit the mark. I've sent this off to the team members responsible. Regards, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Wednesday, October 24, 2012 3:55 PM To: u2-users@listserver.u2ug.org Subject: [U2] [BDT] A giant leap forward I would like to *commend*, yes commend, the developers of the Basic Developers Toolkit for recent changes. In particular, the ability to *install updates* from within the Eclipse package. In conjunction with the *detailed release notes* highlighting changes in each version, for example July's here: http://updates.rocketsoftware.com/u2/July2012_ReleaseNotes.htm It's quite useful to be able to read the release notes and try out the fixed features ___ 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 ** 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
Re: [U2] UPLOAD not DOWNLOAD
You could modify Brian Leach's freeware BCI.IMPORT tool which is designed for SQL / BCI imports. But looks relatively easy to modify for what you want ! ;-) With his permission, of course ! I just downloaded to have a peek... as I have been looking at his other tools lately... There is also provision for multivalues so that's great! Check out Brian's website... http://www.brianleach.co.uk/pages/freebies.htm -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Saturday, 27 October 2012 2:40 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UPLOAD not DOWNLOAD That goes the wrong way. Download does not depend on knowing who is consuming what to create it's results. So Upload should not need to have interactive consumption details either. That's my take. It's reads a source and decides on its own without the sources assistance where to put what. You're coming at it more from a point of view of both sides *agreeing* on what data is in what position. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ** 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
Re: [U2] Chap Up, Chap Down, Chap chap chap the chapper
Task Manager and add Base Priority column...see if that changes...after you do your thing. May do nothing if Rocket hasn't actually hook in the required hooks into UV. Plus a lot of the times you will need to be a Local Admin to change priority higher (if it works at all). In some cases like UNIX - mortal users can't even change their priority at all... up or down (in any meaningful way)... All of this is robbing Peter to pay Mary...what goes around...comes back to bite you if you're not careful. Sometimes it worth not mucking around with dangerous stuff like this. Tis far better invest more time to tune/optimise your U2 app or DB first - fiddle with Windows task scheduling priorities LAST. :) Use at your own considerable risk ;-) http://msdn.microsoft.com/en-us/library/windows/desktop/ms685100(v=vs.85).aspx -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, 16 October 2012 5:41 AM To: u2-users@listserver.u2ug.org Subject: [U2] Chap Up, Chap Down, Chap chap chap the chapper Does anyone know what exactly the Chap Up and Chap Down do, as far as the underlying system settings? Can I see how Chap is currently *set* on my process or some other process? Does the setting of Chap appears somewhere, that I can view, either in Universe, or in Windows (or Unix) ? Can you Chap down multiple times and will this actually do something? If I Chap down on my process, not as admin, can I then Chap up on my process and still not need to be admin? These are burning questions and the kitchen's on fire. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ** 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
Re: [U2] Consuming Web Services
Very true and I agree that the DB Server (SQL, et al) and the DB client engine (UV) models each have pros and cons. UV is a lightweight DB and application engine with some very good capabilities in the DB and application area. Plus of course some truly powerful features too! It is not the best or worse in any of these fields. It fills its own little niche very nicely. UV has had some truly good native SQL engine abilities (schemas, tables, triggers, integrity constraints, stored procedures, dynamic normalisation of multi-valued fields, etc) for a long time. Not tacked on like the UD counterparts. But next to no one uses them. As they would break your legacy application. Plus if you created a new application/DB using it - you may as well use a read SQL database server! Some of the nifty features of true SQL DB servers are really to work around the limitations of the relational model and how you store your data (requiring complex joins, queries, etc). Which tends to make those nifty features essential. Whereas SQL DB servers are progress in leaps and bounds in many different and diverse ways and this is where they truly diverge - be it to cater for massive databases or distributed or failover-active/active database clusters, etc., of any data type or structure you could imagine. Whereas the U2 database engine has not really progressed or evolved much at all in reality - that is not a bad thing. Adding various extensions to the traditional PICK/U2 application interfaces is a very good thing. It does add lots of functions that are truly useful - requiring minimal effort and zero install or cost (a key requirement for lots of sites). If you need something better AND you have local talent to build/maintain it (or consultancy budget) - then go again and do it. :) There are many examples of organisations using their own interfaces/extensions - because they can afford something better that works for them. Your mileage and budgetary will vary! Hence, as you imply - use each database - exploiting their inherent strengths. Use the right tool for the right job. Every tool has its sweet spot! ;) I won't mention the number of MS Access databases out there doing real work...groan! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Thursday, 4 October 2012 5:56 PM To: 'U2 Users List' Subject: Re: [U2] Consuming Web Services But we all know U2 is much more than a DB, in fact it is also much less than a DB. The concept of having the DB just do DB stuff works fine for SQL server and MySQL where the DB itself actually does a lot in terms of the data, and the clients, written in .NET, C, Python Java etc do all the business logic. For these stored procedures do exist but are usually kept to a minimum and certainly only for data interaction. The U2 databases are actually quite stupid, they store and retrieve data from tables in a (hopefully) quick and efficient manner, but they certainly don't do any of the clever stuff you find inside Sql server like map reduce, caching, indexing etc. The clever bits are what we do in the unibasic code. So I firmly believe there IS a case for the clever Unibasic code we write to access data over http, read in xml and to then process all of these different data streams. Yeah sure there are things which in theory are easier to do outside It does not mean you should always do things outside of unibasic. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: 03 October 2012 23:48 To: U2 Users List Subject: Re: [U2] Consuming Web Services Tony and Ben are right on... Invoking Stephen Colbert's concept of... The Word... the word is... MiddleWare. As legacy U2 was ahead of its time... by building-in middleware technologies... it is easy to lose sight of what belongs where. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: Wednesday, October 03, 2012 6:31 PM Subject: Re: [U2] Consuming web services I do the same as Ben but with .NET: -- Local U2 .NET client web service Remote server Pick is a database server, not a communications protocol end-point. We simply should not be doing direct comms from this platform anymore, given the huge number of mainstream options. This is coming from someone who has written all of the bi-directional comms interfaces to/from MV with sockets and cURL and plugins and anything else I could create - because (in the 90's) people said it wasn't possible and because I figured it would be kewl just to do it. It _is_ all technically possible, but that doesn't mean it makes good business sense: Doing things like this in BASIC creates a maintenance hassle later. It leaves the environment subject to DBMS-specific
Re: [U2] STARTUP file issue with UV11.1 PE version (Linux)
The installation instructions of Rocket is quite good and does indeed mention the need to use cpio on UNIX servers. See Quick Installation and Step-by-step Instructions (of NEWINSTALL.PDF)... However, the instructions from Rocket could be improved - with a minor revision, as the Installation guide assumes you're using a CD-ROM or tape drive to get the installation software on your system. It is not clear that after you download the software archive file from the Internet, that you can upload it (as a binary file) to your UNIX host. Once there, un-zip (preferably as root) and then you must perform the cpio after that step. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of doug chanco Sent: Tuesday, 2 October 2012 3:43 AM To: 'U2 Users List' Subject: Re: [U2] STARTUP file issue with UV11.1 PE version (Linux) No sir, I did not know that, why would they cpio it anyway? Not that it matters I was just curious, anyway thanks for the info. Dougc -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: Monday, October 01, 2012 1:19 PM To: 'U2 Users List' Subject: Re: [U2] STARTUP file issue with UV11.1 PE version (Linux) Doug Have you remembered that STARTUP is a cpio archive? # cpio -uvcdumB uv.load STARTUP ./uv.load -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of doug chanco Sent: 01 October 2012 17:37 To: U2 Users List Subject: [U2] STARTUP file issue with UV11.1 PE version (Linux) I recently downloaded uv 11 and when I went to run STARTUP I got a weird error, upon looking at the STARTUP script I noticed it had a bunch of binary and other junk at the beginning of the file, I removed all the extra stuff, saved the file and it ran just fine. Has anyone else seen this? I re downloaded the zip and still had this issue. It was easy enough to resolve but I thought I would mention it. Dougc ** 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
Re: [U2] Scrub Hangs Up
Is this query related to the one you posted/resolved here: http://listserver.u2ug.org/pipermail/u2-users/2011-July/008153.html Same problem/solution? I kindly suggest that you go on a Rocket UV course to help work out how to get the best from UV. Plus the UV ODBC documentation is quite detailed on the use of HS.SCRUB. So I assume you're followed it's correct used - before you posted this request for help. BTW check this out Rocket U2 Webinar coming soon: http://www.rocketsoftware.com/u2/about/events/dictionary-cleanup-a -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Wednesday, 29 August 2012 6:16 AM To: U2 Users List Subject: Re: [U2] Scrub Hangs Up When I do a LOGTO HS.ADMIN HS.ADMIN 5. Run HS.SCRUB on a File/Table.. [F]ix Most of the files here work ok. This one (important) data file INVOICE... it starts an... Analyzing: *and then just sits there. I looked at the dictionary and purged a bunch of extraneous } characters from several the NAME fields. I expect to resize the file but... it is not like the file is badly oversized. This is on UniVerse v10.1 running on HP-Ux Itanium. Suggestions would be appreciated. --Bill ** 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
Re: [U2] PI/UV: Decompiler *** mispelling correction *** in the previous email
I don't believe it is free nor freely even away to anyone who asksfor obvious legal reasons, etc. As there are some dishonest types at there! :) Or you just buy that third-party tool. Which is probably going to be a lot cheaper and you don't have to disclose to anyone, have proof of ownership, sign a legal wave and explain what you're doing and why. Best bet: call Rocket U2 Support direct and discuss your requirements/issues. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Sent: Tuesday, 28 August 2012 12:48 PM To: U2 Users List Subject: Re: [U2] PI/UV: Decompiler *** mispelling correction *** in the previous email OOPS: IBM's compiler should read IBM's decompiler. Robert Norman ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ** 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
Re: [U2] Escaping quotes
I think this article says it all... http://en.wikipedia.org/wiki/Comma-separated_values -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Thursday, 16 August 2012 10:48 AM To: u2-users@listserver.u2ug.org Subject: [U2] Escaping quotes I'm curious about this escaping quotes thing in the csv format. Two double-quotes in a row means what exactly? That it should be converted to one double-quote in the output ? Or that it should be converted to nothing? What if I encountere three double-quotes in a row, or four or fifteen? Do I take them out in pairs? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ** 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
Re: [U2] Universe; SQL; Indexes?? (10.3.7 on Windows)
Try and be very specific what it is you are doing and why. For example - why are you using SQL? Are you doing SQL queries via the TCL prompt or using a client tool on Windows? What is the query? What do you mean by 'optimize the performance'...Etc., etc. UV has two query languages and a single database engine. Meaning, there is should be no difference in respect to the utilisation of indices. Clearly, if you have having to do a SQL query that requires unnest or join operation - then indices may not be significant in improving performance. Try adding the EXPLAIN keyword to your query give some clue to what (if any) query optimisation is going on...including of indices. Being unfamiliar with SQL can also be part of the issue...it's extremely powerful and can be difficult to master. Hence not for the faint hearted - especially if the query is complex and/or your table/schema is also complex. You can perform queries which can have a profound impact on the system performance, if incorrectly structured. Indexes aren't the answer to every optimisation issue. There needs to be a balance between cost versus benefit. It depends on the nature and utilisation of the file in question. Therefore: one really needs to optimise one's own SQL skills...not an easy ask...then optimise your query in order maximise expected query performance. Or perhaps avoid SQL, if it is not really necessary to utilise it. Regards, David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Allen Egerton Sent: Saturday, 28 July 2012 1:35 AM To: .U2 List Subject: [U2] Universe; SQL; Indexes?? (10.3.7 on Windows) I'm using SQL to query Universe 10.3.7 data files, (ANSi-compliant and non-compliant formats) and indexing the files to try to optimize the performance seems in some cases to have little or no effect. I'm pretty clear on index behavior with Universe's native query language, but SQL is somewhat unfamiliar to me, and I'm wondering why I'm not getting the behavior I expect. Can anyone either point me to reference material on this, or offer thoughts based on experience? Thank you. -- Allen Egerton; aeger...@pobox.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
Re: [U2] UV 11.1 64-bit on Cisco UCS with NetApp Filer?
Is your UVCONFIG parameters still set to the default values? If so, you need to change these to suit. You can baseline them using your previous UVCONFIG parameters from your old host and see how your application performs. Further tweaking of them may be required if your application profile (utilisation requirements), etc. has changed. Also, what was the previous release of UV you were on previously? Regards David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Adam Taylor Sent: Wednesday, 10 August 2011 12:17 AM To: u2-users@listserver.u2ug.org Subject: [U2] UV 11.1 64-bit on Cisco UCS with NetApp Filer? All, We recently upgraded and virtualized our UniVerse servers to UV 11.1 64-bit on a Cisco UCS B Series platform with a NetApp 3040A/A Filer. Going to 64-bit with an upgrade in the virtualized environment, we expected to see a noticeable (if not significant) increase in performance than we were achieving on our old physical 32-bit server. However, not only has performance not notably increased, we are having random slowdowns in various areas of the system that were not occurring before. I say random, because while it does seem to affect certain areas more, it is not consistent. Some examples of behavior that has changed since the virtualization: An SB screen that has some calculated fields on it will take a minute to load, but the next time it loads it loads in just a couple seconds for the same record. An ASP webpage with 10+ queries against different files (heavy-duty processes) using Web DE to connect will takes 5-6 minutes to load that was only taking a minute before. Randomly, saving a change in the SBClient screen designer on our Dev environment will hang for 20-30 seconds. (Same virtualized specs, but far less traffic due to being a dev environment.) Simply initiating a telnet session, sometimes it will be 10-15 seconds before the login prompt appears to enter username and password. Does anyone out there have any experience with any of these pieces (UV 11.1 64-bit, Cisco UCS, NetApp Filer) that could shed some light on why we are now seeing these performance issues? Thanks. Adam Taylor Director of Software Development O: (713) 795-2352 www.INXI.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
Re: [U2] AIX uname and Redback
One 'simple' thing to try... I'd ask them to first check the ulimit settings from the UNIX shell before they enter (ie., what is the default). For all the values not set already to unlimited. Retry and see if that makes any difference. Only other thing I can suggest: create a Korn Shell VOC entry and call that...I am guessing that this for UV? -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 11:36 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] AIX uname and Redback To my knowledge Redback itself isn't being asked for anything. A BASIC sub was executed and returned the short result - I believe this does what you're suggesting. That sub also kicks off a phantom with the same results. Code is below. FYI, I don't use Redback myself so please forgive any misunderstanding of something that you're trying to convey. I'll pass along new suggestions to the client. ** 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
Re: [U2] Why use U2, was Interesting Article
Always...use the right tool, for the right job...one size doesn't fit all, etc., etc. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Thursday, 14 July 2011 3:56 AM To: 'U2 Users List' Subject: Re: [U2] Why use U2, was Interesting Article I am a bit of a mongo DB fanboy myself, I think regarding performance, because of its autosharding any large scale application will definitely beat u2. Mongo db powers many mainstream enterprise solutions, and high profile websites, - bit.ly comes to mind, so it certainly has a pedigree as well. However i am also a u2 fanboy for many many reasons. ** 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
Re: [U2] Universe 10.1.22 on AIX 5.3 ML 4
Hi Bob My bad experience with label common variables in the same context was we implemented a program that compiled and implemented - it had the very same variables. It never got picked-up in the testing, 'cause it didn't use the variable for display purposes...Hence, our terminal attributes go screwed up - screw displays for unrelated programs stopped working. Perhaps you have a similar issue? Hence well known prefix for reserved variables is always advisable (TERM$ENTRY$, etc) - of course it is very hard to go back into 10-20 year old code though to fix though. If not thatare you also certain your didn't customise your uv terminfo database for the terminal emulation in question? You never know! I assume ENTRY$ = @(-14):@(-17) is the equivalent = Stop Rev Video and Insert Line. I am guess you have a test program you have to ensure the escapes output match that? Also, have you re-compiled and re-cataloged (if applicable) all your application code? Every time we upgrade or refresh our server / upgrade UV - we perform an install from scratch - we don't assume anything is installed (usually it's a new server, new install). Plus we always re-compile source, re-catalog object code, re-compile dictionaries, resize files before migration and post-migration. Paranoid, but it works for us. :-) Regards, David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bob Witney Sent: Monday, 20 June 2011 5:26 PM To: u2-users@listserver.u2ug.org Subject: [U2] Universe 10.1.22 on AIX 5.3 ML 4 I gave up trying to go to Universe 11 because its needs ML8 and we are on ML4 and we didn't want to upgrade AIX So, we thought we'd do the easy thing and go to 10.1.22 (we are currently on 10.1.14) Installed and licensed fine BUT When using this command: CRT ENTRY$:@(10,(C$PS+1)+(C$PG*WS)):C$PPM 'R#2' :'. ':TEMPL$:C$MLT(C$PPM):CLN: The line doesn't show on the screen However when using this CRT @(10,(C$PS+1)+(C$PG*WS)):C$PPM 'R#2' :'. ':TEMPL$:C$MLT(C$PPM):CLN: It does !!! ENTRY$ is set as a common variable ENTRY$ = @(-14):@(-17) Now old people like me will remember that at Release 7, @(-11) changed to @(-58) and @(-12) changed to @(-59) could it be we have something similar at 10.1.22 Any thoughts ?? Confidentiality Notice: This e-mail and any attachments are intended solely for the addressee and may contain confidential or privileged information. If you are not the named addressee, or the person responsible for delivering the message to the named addressee, please notify the sender as soon as possible and delete the material from your computer. This message will be protected by copyright. If it has come to you in error, you must not take any action based on its contents nor must you copy or show the message to any person other than the intended recipient. _ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ** 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
Re: [U2] Enterprise Scheduling solution
Like another poster said AutoSys is common enterprise multi-platform scheduling tool with it's own scripting/scheduler language. But it won't be cheap and it probably will be an overkill. Tivoli, There are lots of similar tools out there, some optimized for the major enterprise ERP packages, RDBMSs, etc. Some of the larger enterprise multi-platform/ERP/DB schedulers can be found from companies such as UC4 Software, Tidal Software, etc. Another interesting open source scheduler (with optional support from the developer) is Open Scheduler (http://www.sos-berlin.com/modules/cjaycontent/index.php?id=osource_scheduler_introduction_en.htm). It is multi-platform, has an API, supports remote host job execution, is using XML format configuration files, job editor, job monitoring GUI via a webserver, optionally complex jobs can be managed via a number of majors databases (not UV though - but didn't check if it had a generic JDBC/ODBC driver). What all will have issues with UV and what should concern you is their inter-interoperability, impact on your U2 licenses (depending on how they invoke jobs), job management and the inability for UV applications executing to return return codes back to them to indicate success or failure of their execution. The later may negate much of the functionality of such tools if are unaware of the state of your jobs (specifically when the process terminates). From: u2-users-boun...@listserver.u2ug.org [u2-users-boun...@listserver.u2ug.org] On Behalf Of Baker Hughes [baker.hug...@mouser.com] Sent: Tuesday, 14 June 2011 7:23 AM To: U2 Users List (u2-users@listserver.u2ug.org) Subject: [U2] Enterprise Scheduling solution Many MV systems have some kind of home-brewed or even purchased scheduling solution for handling batch processes. Many times, in distribution or manufacturing ERP applications, certain processes such as Aging A/R, or stock replenishment/reserving, is performed 'after hours' by these schedulers. We've all worked with one or perhaps written our own. We have one of these, that gets the job done. Does anyone know of an Enterprise Scheduler solution that can handle jobs across a heterogeneous enterprise, that is also MV or *nix compatible? Rather than try and take our UniVerse based scheduler front end to the next level of perfection, we need a job/phantom/scheduler solution that would allow an Operator with little or no MV knowledge to monitor/adjust/manage jobs across a plethora of different OS-based enterprise applications. The Enterprise Scheduler we are interested in can be MV based, or other DB based, but must have a graphical front end, and must be able to manage jobs on non-MV systems as well as MV systems. Thanks for any ideas. -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 ** 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
Re: [U2] UniObjects.Net error message
Is this a new program/process? Do it is just stop working? Does it rely upon label common variables, file hands/variables, etc which perhaps aren't defined when calling it via your call? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ken Ford Sent: Wednesday, 1 June 2011 8:50 AM To: u2-users@listserver.u2ug.org Subject: [U2] UniObjects.Net error message I wonder if anyone can assist with this problem: We are using UniObjects.Net with Universe 10.3 on under AIX 5.3. A web request is returning an error about a subroutine failing to complete: [IBM U2][UODOTNET - UNICLIENT][ErrorCode=30107] The subroutine failed to complete successfully It works successfully with other web requests, and the format of the request is correct. The apiserver log file reveals that the request was received, but has this line after the request details: ICSubCall UVSETJMP returncode=30107. When I run the request using a Universe request emulation program that calls the same subroutine, it works correctly and the output is correctly formatted. Thanks for any help or suggestions you may have. Ken Ford Software Engineer (Universe, etc.) ** 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
Re: [U2] [UV] Emulate SQL MAX() function at TCL
Hi Stuart, Probably too late now... but... If you defined your SQL table with the DEFAULT NEXT AVAILABLE it will automatically increment the primary key value by 1 when you insert a new row... CREATE TABLE MYTABLE (CLIENT_NUMBER INT PRIMARY DEFAULT 'NEXT AVAILABLE', CLIENT_NAME VARCHAR FMT 30T DEFAULT '', CREATE_ADDRESS VARCHAR FMT 30T DEFAULT '' ... See UniVerse SQL Reference Guide sqlref.pdf page 113 (UV11.1 docset). Regards, David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Boydell, Stuart Sent: Friday, 27 May 2011 4:04 PM To: U2 Users List Subject: [U2] [UV] Emulate SQL MAX() function at TCL Just wondering if anyone has a neat trick for picking up the highest ID from a file. Where the file ID is an integer. With UVSQL I would SELECT MAX(@ID) FROM TABLE; - however, the program I need to do this within has the file (table) open and if I try to execute it returns the error 'Non-SQL re-entrant query calls are not allowed.' The best I have so far is: st = 'SELECT FILE @ID BY.DSND @ID' st-1 = 'LIST ONLY FILE SAMPLE 1' exec st capturing cap maxId = trim(cap4) Any other ideas? Cheers, Stuart ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ** 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
Re: [U2] UVSQL CALL with MSSQL Openquery against linked UV server.
Hi Stuart, I've used SQLExecDirect with UV before, we always allocate and prepare for each of the required parameter markers. Then call UV BASIC subroutines via SQLExecDirect. I would hazard a guess that QueryTool is doing a SQLExec and Transact-SQL pass-through is doing a SQLExecDirect. The later which requires the parameters to be pre-declared using SQLPrepare in order for the query result set to be returned successfully. You could test this by calling DATE using both tools and see what happens. As it has no parameters - I suspect both queries should work. Whereas, anything requiring parameters is likely to fail where the tool is using SQLExecDirect. Finally, is your ZSELECT_CUST a BASIC subroutine? Is it globally catalogued? If not, try cataloguing it as *ZSELECT_CUST and then call it like CALL *ZSELECT_CUST(1), etc. Hope this helps... :) Regards, David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Boydell, Stuart Sent: Monday, 16 May 2011 5:48 PM To: U2 Users List Subject: [U2] UVSQL CALL with MSSQL Openquery against linked UV server. Hi, Just wondering if anyone has used the SQL CALL statement from MSSQL against a linked UV server and got it working. I have a linked server set up in MSSQL using UniOLEDB which works for most SQL queries. I now find I need to call a basic program to do some work to setup the result set I need. I have built and tested the program which does some updating and sets @hstmt using SQLExecDirect(). Using a simple third party OLEDB client (ADO Query Tool http://www.gpoulose.com/), the CALL to the program returns the expected row set. However, if I try the same query from within SSMS it bombs out with an error. Using ADO QueryTool: Works: CALL ZSELECT_CUST(1) Using MSSQL Management Studio: Works: select * from openquery(UVServer,'SELECT * FROM CUST SLIST QQQ') Doesn't work:select * from openquery(UVServer,'CALL ZSELECT_CUST(1)') And returns the error: Cannot get the column information from OLE DB provider IBM.UniOLEDB for linked server UVServer. The other possibility might be running as a 4 part exec - which also isn't working for me. Exec UVServer...[ZSELECT_CUST(1)] Which returns Msg 7411, Level 16, State 1, Line 1 Server 'UVServer' is not configured for RPC. In the meanwhile I can work around the issue by SELECTING from an I type which runs the setup program... but that's not what I would like to do. Anyone have any experience with getting this type of thing going? Cheers, Stuart Boydell ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ** 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
Re: [U2] Limitations of uvrestore
I don't know of anyone who actually relies upon uvbackup/restore for their backup/restore strategy. Other than supposedly support online backups and checking file integrity - I would see it's relatively slow speed as another reason not to utilise it. Other DB vendors tools tend to suffer from similar such drawbacks as well... The only other comment I'd make is that you don't mention of your AIX rmt device block size was set to automatic or not. This may potentially be the cause of some of your issues? Regards, David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Gregor Scott Sent: Tuesday, 3 May 2011 12:13 PM To: U2 Users List Subject: [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 ** 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
Re: [U2] [BDT] U2 Resource View
The first two-lines after Bill: has the answer ...I can confirm that it is correct, as well. The answer doesn't exist in the manual either...yet one more reason to hate Eclipse :-) I can't vouch for the other claims though... I was initially confused by the response - hence missing the answer too! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Wednesday, 20 April 2011 4:37 PM To: 'U2 Users List' Subject: Re: [U2] [BDT] U2 Resource View Sorry - but how does that help the op ? From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug Averch Sent: 20 April 2011 00:55 To: U2 Users List Subject: Re: [U2] [BDT] U2 Resource View Bill: From the menus Window-Show View-Other-U2Views, then click on plus and then click on the U2 Resource to highlight it. Once it is highlighted click on the okay button. The twenty plus people that went to the February Colorado Multi value Users Group (CMUG) all got training from me on Eclipse plug-ins. The training was good for all plug-ins including the one we sell called XLr8Editor and BDT. Regards, Doug www.u2logic.com On Tue, Apr 19, 2011 at 2:16 PM, Bill Brutzman bi...@hkmetalcraft.comwrote: I clicked on something (unknown) and lost the U2 Resource View. I have looked in the BDT manual, Help, and a lot of buttons without much luck. Help would be appreciated. --Bill ___ 2-users ** 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
Re: [U2] Databasic conversion
UniVerse PICK flavour account would probably be - out of the box - the path of least resistance. As UniVerse emulates the PICK D3 environment much better than Unidata. Unidata was designed to be a clone of Prime INFORMATION - engineered from the manual up (which including doing this the PI Manual said it could do, but in reality it didn't almost do as published!). Bill H has nicely documented stuff for you already in his post and elsewhere on the Net: http://www.rhinocerus.net/forum/databases-pick/305503-migration-d3-universe-doco.html http://old.nabble.com/RE:-D3-to-U2---how-to-import-a-FileSave-tape-p4361606.html -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Thursday, 7 April 2011 7:14 AM To: 'U2 Users List' Subject: [U2] Databasic conversion Hi I am looking at a little side project to convert an entire system written in databasic on D3 to run on unidata. The guy i work with says it is a couple of hours work - I am not so sure myself. Anyone done this and know what the 'gotchyas' are ? Cheers Symeon. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ** 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
Re: [U2] Databasic conversion
Also see Pick.pdf in the Rocket U2 UV11.1 document set. It documents the differences between D3/PICK and UniVerse. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Thursday, 7 April 2011 7:42 PM To: 'U2 Users List' Subject: Re: [U2] Databasic conversion Thanks Bill and Mecki. As ever some fantastic information from this group. From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: 06 April 2011 23:31 To: U2 Users List Subject: Re: [U2] Databasic conversion Symeon: I converted our application from D3 to UniData. There was quite a bit of work. I believe I started in Dec 2005 and finished at the end of March 2006 (I had to work a lot of overtime), and beta tested through Aug 2006. We went live with one our clients in Sep 2006 and then 10 more moved over in Nov and Dec 2006. I spent the next six months moving most of the rest of our clients to UniData. I'd say I spent about a thousand man hours on this. It could have been half that, but I had no help from anyone (including IBM/RS) except Colin Alfke in Canada. I have a lot of emails on this, but the following is one in particular. HTH, Bill - Original Message - *From:* Bill Haskett *To:* 'Bob Little' *Date:* 2/28/2006 6:29 AM *Subject:* Re: [U2] Changes to mail list configurations We're mostly done but have spent about 140 man-days. We spent a fair amount of our time grinding away with the line editor. We were constantly editing data, dictionaries, VOC entries, and BASIC programs. We were able to port a few utilities to UD to help (a TCL shell, a file listing program, a dictionary listing program, and a screen-scroll program). We feel that we could have saved about 30% of our time if there was a decent screen editor, as the productivity was extremely low with the stone age line editor (AE). This would have saved us about 40 man-days! We spent about 20% of our time messing around with moving D3 to UV to UD and all subsequent data moves. This would have saved us around 30 man-days. There weren't too many surprises but there were some. Here are the major ones: 1) There was absolutely no interest by IBM in helping us, 2) There were absolutely no utilities to assist in the conversion. When I consulted at a large UD user they had converted from Sequoia several years before and they said there were numerous utilities that converted their dictionaries and BASIC programs. These were unavailable to us. 3) We had to convert to UV first then to UD...well, not actually. We had to move our data to UV, convert the dictionaries, then move to UD. However, we eventually found a utility to restore a D3 account to UniData, which helped tremendously during our client upgrades. 4) There is no (or virtually no) security in U2. It's handled by the O/S. 5) There are no users in U2. They're managed by the O/S. 6) UD requires a lot more interaction with the O/S. For instance, since UD has no 'Q' pointers you have to create file pointers using environment variables. In Windows, this requires the creation of the environment variables on the server...very strange. 7) There is no backup facility in UD. 8) I-Descriptors don't apply to each value in a multi-valued field. One has to mange the multi-values as though the dbms was never designed to have multi-values. There are separate functions for multi-values and if one uses a called subroutine, the subroutine has to manage the multi-values and return an MV array back. There are also some peculiarities to UD (things you wouldn't believe). For instance: 1) COPY MYFILE '1''2''3' TO:(ANOTHERFILE ...sometimes doesn't work at all. COPY, BASIC, CATALOG, DELETE-LIST, and numerous other VERBS can't handle multiple items in the command line. You have to SELECT the items first before executing these verbs. 2) You can't create an account from within UD. You have to open a DOS window, create a directory, and execute a DOS command from within this new directory. 3) A new UD account has all kinds of new UD files created within the account. Not really a big deal but surprising. 4) Managing your TERM settings is difficult. 5) Some default settings are weird. For instance, when compiling a BASIC program it gets globally compiled and cataloged...like a new MV user wants this by default?! :-) 6) Items in the SAVEDLISTS file have a number appended to the end so one won't be able to manage these without using the ...LIST commands. For instance SAVE-LIST BILL ends up in the SAVEDLISTS file as BILL000. Some other things to expect: + SAVED LISTS - In D3 you can SELECT-LIST ME YOU and you get a list of both lists. In UD you need to SELECT WHATEVER TO 1 then SELECT WHATEVER TO 2 then MERGE.LIST 1 UNION 2 TO 3 and hope it works. :-) - In
Re: [U2] UV Common
Pick-style BASIC COMMON is documented in the Pick.pdf document in the UV 11.1 document set. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dianne Ackerman Sent: Thursday, 7 April 2011 1:52 AM To: U2 List Server Subject: [U2] UV Common Can anyone point me to a manual somewhere that describes the differences between behaviors in the COMMON basic statement between the different flavors of Universe? Thanks! -Dianne ** 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
Re: [U2] Trigger questions
When/if you upgrade to UV 11.1 - perhaps you should use Index-based triggers - now supported by Rocket. Simpler than SQL-style triggers... see the new features.pdf in UV 11.1. Excerpt: In some circumstances, an application may not require all of the capabilities available to conventional triggers. In these cases, index-based subroutines may serve the purpose better because they have reduced overhead, which may translate to better performance. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug Chanco Sent: Friday, 1 April 2011 3:19 AM To: U2 Users List Subject: Re: [U2] Trigger questions While it's working I am getting back: [error] SQL update failed good But I am also seeing Error performing trigger for customer but It works the record is not updated Write failure good Any idea on why I am getting the error performing trigger when it's obvious it's working? Thanks Dougc ** 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
Re: [U2] dynamically disassociate associated fields?
You can use an alternate dictionary in native or SQL queries... USING DICT MYALTDICT Or more practical suggest made by Kate is to have a different dictionary definition... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Shane Ricciardi Sent: Thursday, 31 March 2011 4:22 AM To: u2-users@listserver.u2ug.org Subject: [U2] dynamically disassociate associated fields? Hello. I have a rather large MV association that contains around 40 or so I- type dicts that all call subroutines. Since this is essentially a subtable to uv/SQL, selecting any field from the subtable causes all the fields to be processed, although only the requested field is returned. As you can imagine this slows things down a ton. Is there a way to tell universe to *just* process the field(s) requested in the SELECT stmt without creating new dicts associations? Thanks. ** 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
Re: [U2] User LogOut Cabbage
It is my view that you should never manipulate any UniVerse file (even directories) from outside UniVerse (especially when it is up)...without due care or being aware of the negative impact, etc. If you must clear SAVEDLISTS, use the vendor supplied CLEAR.FILE command. If you execute say CREATE.FILE MYUNIXDIR 19, it will create .Type19 within the UNIX directory created - common sense says you should do so too. :-) UniVerse will always use the correct UMASK you define (which should be set in your LOGIN or UV.LOGIN so it is consistently applied for every UV process) when you use CREATE.FILE. Good practise dictates you should use the tools and processes provided by the vendor unless there is a very good reason(s) why you should not. Of course, experienced and brave souls...can do as they deem fit. I guess as with all advice on here - use it at your own risk - caveat emptor applies :-) Regards David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tom Whitmore Sent: Thursday, 10 March 2011 1:17 AM To: U2 Users List Subject: Re: [U2] User LogOut Cabbage HI, You don't need the .Type19 file. You can do rm -R \SAVEDLISTS\ mkdir \SAVEDLISTS\ You do need to make sure the permissions are correct on the directory, we have found people not having the correct UMASK so people have trouble writing to the directory. Tom RATEX Business Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Hona, David Sent: Tuesday, March 08, 2011 8:22 PM To: 'U2 Users List' Subject: Re: [U2] User LogOut Cabbage Are you clearing your SAVEDLISTS directory from UNIX (scheduled or manually) and then this error appears? If so, it is probably deleting the required .Type19 entry (within the SAVEDLISTS directory. Possible solution: purge away, but re-create the .Type19 file using 'touch .Type19' or the like in your UNIX script. )...refrain from doing when you have users logged in too. Perhaps use CLEAR.FILE instead from within UV instead? Regards, David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Wednesday, 9 March 2011 9:35 AM To: U2 Users List Subject: [U2] User LogOut Cabbage When a user here logs out of UniVerse on HP-Ux, it comes back with repeating... Mkpath: @SAVEDLISTS/S.maryann.14 is not a directory Suggestions would be appreciated. --Bill ** 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
Re: [U2] File Corruption
Are they dynamic files? Are your cron jobs phantoms or are you using uvcron (http://www.pickwiki.com/cgi-bin/wiki.pl?Uvcron) or something similar? Any issues recently with locking or UV processes core dumping and/or the T30FILE semaphore remaining locked/with high collision count? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bob Witney Sent: Wednesday, 9 March 2011 7:02 PM To: U2 Users List Subject: Re: [U2] File Corruption Yes lots of them and have been for years though this corruption has only just occured -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan Fitzgerald Sent: 08 March 2011 22:51 To: u2-users@listserver.u2ug.org Subject: Re: [U2] File Corruption Are you kicking off any uv jobs from cron? More than one? (Clif, wipe that grin off your face...) Date: Tue, 8 Mar 2011 13:50:57 + From: b...@explore.co.uk To: u2-users@listserver.u2ug.org Subject: Re: [U2] File Corruption Universe 10 Aix 5.3 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wally Terhune Sent: 08 March 2011 13:23 To: U2 Users List Subject: Re: [U2] File Corruption UniData? UniVerse? OS vendor/version? U2 version? Wally Terhune U2 Support Architect Rocket Software 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA Tel: +1.720.475.8055 Email: wterh...@rs.com Web: www.rocketsoftware.com/u2 ** 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
Re: [U2] User LogOut Cabbage
Are you clearing your SAVEDLISTS directory from UNIX (scheduled or manually) and then this error appears? If so, it is probably deleting the required .Type19 entry (within the SAVEDLISTS directory. Possible solution: purge away, but re-create the .Type19 file using 'touch .Type19' or the like in your UNIX script. )...refrain from doing when you have users logged in too. Perhaps use CLEAR.FILE instead from within UV instead? Regards, David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Wednesday, 9 March 2011 9:35 AM To: U2 Users List Subject: [U2] User LogOut Cabbage When a user here logs out of UniVerse on HP-Ux, it comes back with repeating... Mkpath: @SAVEDLISTS/S.maryann.14 is not a directory Suggestions would be appreciated. --Bill ** 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
Re: [U2] Multi-Threading Universe Socket traffic
I'd agree with this approach...I've used it many times before... A good well thought out design well help you...design first: code second :-) I've in the past done the following: - control program to configure, start/monitor/stop phantom processes - I find writing a phantom process which logs what it is doing/done is used for debugging purposes too (saves guessing what's going) - just remember to have a toggle to turn this on/off for production (to save disk space) - it is important that each phantom logs its progress, its process ID, start, last checkpoint reached and that it has successfully terminated. This helps prevent the case of you accidently firing off 100 phantoms and consuming all your UV licenses, etc. :-) The purpose of this is to: - make the process scalable and tuneable without re-coding via parameter record (include things like operating windows, etc) - have an application to manage the phantoms and monitor what they're doing (or if they're doing anything) - have phantom processes log what they're doing and allow options for a verbose logging mode to log everything they're doing in case of problems Some approaches I've used: a) each phantom could be started with a unique saved list of record keys to processed (generated by a control program or some other process beforehand) b) each phantom can perform its own query (but sleeping for a specified period so not to continuously performing disk I/O) c) Inbound and outbound transaction phantom process - each handles only response or send requests respectively. Such an approach only works if you can reconcile the response with the original request. Very application specific and not generally optimised for throughput. We first tested this to get ensure we weren't thrashing the disk I/O with too many phantom processes...as this was a pure database read/lock/write type transactional batch process. Use performance monitoring tools to help you do this. Plus your case - networking monitoring, etc. Yours needs to be optimised for sockets I/O as well as DB updates. It shouldn't be opening/closing socket connections unnecessarily (if that wasn't obvious already) - due to the high over head of doing so. Like disk I/O you need to be ensure that the path out to your internet connection is already optimised so it doesn't contribute to the delays. Likewise that it can support X number of connections and your third-party service provider allows you to do this. I'd say you need to optimise your socket program first and think about how to multi-stream (multi-thread implies low-level OS type functions) your processing. Care needs to be taken to ensure you design your process with the with sufficient error handling to ensure that you don't write an application which becomes part of the problem! This is so easy with stuff like this to go amiss. :-) Before you go live - in your test environment - try to break this process (overload/kill phantoms). Better it breaks there, than in production. It's really hard to fix UV problems, when you have no licenses left :-( Good luck. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Monday, 7 March 2011 8:17 PM To: 'U2 Users List' Subject: Re: [U2] Multi-Threading Universe Socket traffic Ok the python solution mentioned is one way - however this multi threading you requiree is not a multi threading requirement - you are consuming a socket service, and not accepting connections, - we do this kind of thing all the time using phantoms. Lets say your batch of transactions is in a file, as you process each one set a flag saying it is done, or delete the record or something, then yourprogram can select the file, loop through the records and if the flag is set or the record does not exist it just skips onto the next one. You can then start 10 processes running all doing the same thing and they will work through the file. Or you could have process 1 doing all the ones beginning with a 1, 2 for 2 and so on. You may want a controlling program that runs up, counts the records on the file/in the batch and from that determined how many phantoms to run up. It then runs up the phantoms and then stops. Rgds Symeon. From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of nschroth Sent: 05 March 2011 16:55 To: u2-users@listserver.u2ug.org Subject: [U2] Multi-Threading Universe Socket traffic On Universe 10.1.14 over AIX 5.3, we currently communicate Credit Card transactions via sockets (ISO-8583) using the following logic (works fine): OPEN.ERR=openSocket(THIS.IP,THIS.PORT,TCP.MODE,TIMEOUT,THIS.HANDLE) INFO.ERR=getSocketInformation(THIS.HANDLE,PEER.FLAG,SOCKETINFO) WRITE.ERR=writeSocket(THIS.HANDLE,SEND.MSG,TIMEOUT,TCP.MODE,SEND.SIZE) READ.ERR=readSocket(THIS.HANDLE,RECV.MSG,RECV.LEN,TIMEOUT,TCP.MODE,RECV.SIZE ) I am looking into
Re: [U2] Version Control
If you are using U2 environment a lot of stuff won't work without utilising the VOC some fundamental or critical way. VOC entries for files, programs, paragraphs/PROCS, etc. Granted, in some cases these don't change often. Unless you are like some poor sites I have seen and run their entire or parts of their application process from a paragraph or proc in the VOC file - more common than you would like to think or hope! Likewise, control information inside U2 files are in many case extremely critical for many applications - this also needs to be managed and versioned, rolled-back if required, etc., etc. Any configuration management application needs to take everything into account not just source code. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug Sent: Friday, 4 March 2011 1:48 PM To: 'U2 Users List' Subject: Re: [U2] Version Control Hi Bill: The U2 world works inside the database. The rest of the world thinks source code control should be outside the database. Your use of VOC is very unique and probably applicable to a small set of the U2 community. Source code control, except for U2, is done from the local workstation and not on the server. ** 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
Re: [U2] U2 soap server on startup
Unless you need a Windows service for specific reason...a Windows scheduled task should be fine. Of course there are pros and cons to that approach such as scalability and recovery, etc. Multiple instance sexecuting, etc., etc. There are many free Windows Run As Service wrappers out there. The free generic ones are very basic and Java unaware. There are a few Java specific wrappers, including this one: http://wrapper.tanukisoftware.com/doc/english/download.jsp From: u2-users-boun...@listserver.u2ug.org [u2-users-boun...@listserver.u2ug.org] On Behalf Of Lettau, Jeff [jlet...@polkaudio.com] Sent: Friday, 25 February 2011 1:07 AM To: U2 Users List Subject: Re: [U2] U2 soap server on startup Sorry, Windows I saw the commands in the manual for runsoapserver and stopsoapserver. This does allow for starting and stopping without using the tools. The link does help explain where things are operating from, thanks. I guess the question is, can I make the runsoapserver a service? Or would it be starting the instance of javaw as a service? Or am I stuck having to login and manually start the soapserver? If I have to just run it manually to insure it is up, then it's not a big issue, there are other things I need to do this with. Thanks for the feedback and info. Every little bit helps. Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Hona, David Sent: Thursday, February 24, 2011 2:41 AM To: 'u2-users@listserver.u2ug.org' Subject: Re: [U2] U2 soap server on startup See the Webservices.pdf in the U2 Documentation. Specifically Deploying Web Services...If in Windows create your own scheduled task or UNIX - a crontab job. Also, from the archivesthis may help if you like to know what's going on behind the scenes (this pre-dates the above chapter being published in that PDF guide): http://www.mail-archive.com/u2-users@listserver.u2ug.org/msg24130.html -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lettau, Jeff Sent: Thursday, 24 February 2011 8:29 AM To: u2-users@listserver.u2ug.org Subject: [U2] U2 soap server on startup I just noticed a potentially bad thing. The soap service will only run if you run it manually after logging into the server. If I log off of the server the soap service stops running. I'm guessing the problem is that it is not actually running as a service, but I don't see how to make it run as a service. Does anyone have any suggestions on how to enable a soap server to run on startup? Jeffrey Lettau ERP Systems Manager polkaudio ** 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 Disclaimer: This email may contain confidential and/or privileged information. It is intended only for the person or persons to whom it is addressed. Any unauthorized review, use, or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email or telephone and destroy all copies of the original message. Please consider the environment before printing this email. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ** 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
Re: [U2] U2 soap server on startup
See the Webservices.pdf in the U2 Documentation. Specifically Deploying Web Services...If in Windows create your own scheduled task or UNIX - a crontab job. Also, from the archivesthis may help if you like to know what's going on behind the scenes (this pre-dates the above chapter being published in that PDF guide): http://www.mail-archive.com/u2-users@listserver.u2ug.org/msg24130.html -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lettau, Jeff Sent: Thursday, 24 February 2011 8:29 AM To: u2-users@listserver.u2ug.org Subject: [U2] U2 soap server on startup I just noticed a potentially bad thing. The soap service will only run if you run it manually after logging into the server. If I log off of the server the soap service stops running. I'm guessing the problem is that it is not actually running as a service, but I don't see how to make it run as a service. Does anyone have any suggestions on how to enable a soap server to run on startup? Jeffrey Lettau ERP Systems Manager polkaudio ** 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
Re: [U2] Telnet session limt has been reached (was Retrieving data from remote SQL DB from Universe via ODBC?)
Oh, did you fix your ODBC problem? :-) I can't recall you posting any responses back?? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ken Ford Sent: Thursday, 24 February 2011 11:47 AM To: u2-users@listserver.u2ug.org Subject: [U2] Telnet session limt has been reached (was Retrieving data from remote SQL DB from Universe via ODBC?) Firstly, my apologies for using an old posting's subject line as clarified in the new subject line! Now, the problem described in my last posting (the body of which was correct!) has been solved. The message in question was actually generated by our Universe Administrator's putting a new step in the UV account login paragraph and forgetting to tell the Universe development staff (unless I have just forgotten being told - quite possible). Thanks anyone who was wrestling with a response or who has responded already. I shall try to expect the unexpected in future before burdening the list with such questions. :-) Ken Ford Software Engineer Brisbane, Queensland, Australia. ** 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
Re: [U2] Frustrated with Rocket / Unidata 7.2
It's impossible to please everyone. My bug report (and the long awaited fix...comes before yours :-) Get to the back of the line!! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Friday, 18 February 2011 2:20 PM To: U2 Users List Subject: Re: [U2] Frustrated with Rocket / Unidata 7.2 I dunno man. There's some really good folks in the U2 group but sometimes I wonder if the decision makers over there ever consider that there are real people trying to use these products? On Thu, Feb 17, 2011 at 8:14 PM, Charlie Noah cwn...@comcast.net wrote: Totally OT, and I'm just musing here - Rocket, Raining Data then TigerLogic. Does anyone besides me see a trend here? ** 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
Re: [U2] UniSubroutineException: Unknown Error [30102] Occurred
Does this subroutine do file I/O? Does it explicitly open the file or assume some other program or subroutine opens it and stores the file variable in labelled common...? Sometimes it can even be a call subroutine call that is called using a labelled common variable (CALL @MYSUB)... Easiest thing to do is look how the subroutine is used now...if you don't emulate the same initialisation sequence it requires from UV native runtime environment in Java runtime environment...it more than likely will not work. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Stephen Jackson Sent: Thursday, 17 February 2011 1:28 AM To: u2-users@listserver.u2ug.org Subject: [U2] UniSubroutineException: Unknown Error [30102] Occurred I am new to the U2 java api. I am trying to make a subroutine call but get the following Exception. It is not in the documentation and I have not had a lot of luck tracking it down. I am able to make a simple query so not sure if there is some configuration or something I am not aware of which is causing the error. Version Number :4.1.3 Max Open Files :32 Account Path :/mypath Locking Strategy :0 Release Strategy :12 Calling S.XTMS.TEST.LOOKUP... [IBM U2][UniObjects for Java][UniSubroutine Exception][ErrorCode: 30102]Unknown Error [30102] Occurred asjava.uniobjects.UniSubroutineException: Unknown Error [30102] Occurred at asjava.uniobjects.UniSubroutine.call(UniSubroutine.java:150) Any help would be much appreciated. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ** 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
Re: [U2] [UV][AIX] System Management and Performance Tools
We have used nmon on AIX. But we don't use UV on AIX here. It's free and doesn't come with anything fancy like the commercial toolsets... I have used GlancePlus on HP-UX. There is an AIX version available and a trial can be arranged via: https://h10078.www1.hp.com/cda/hpms/display/main/hpms_content.jsp?zn=btocp=1-11-15-28^9637_4000_100 Whatever tool you use, where it lets you categorise UNIX processes will help. In the past, a previous employer hired a consultant from HP to do the analysis (GlancePlus temp license came with the consultancy). He put together a report to help tune HP-UX and help us identify processes that we needed to optimise. Whatever the tool, clearly you need to have a good handle of what processes you run. You can do additional stuff like have your own phantom verb which logs when it is fired up and get your any program run as phantom to log it's PID, @PARASENTENCE and @SENTENCE values into a log file (along with date time stamps, etc). Correlate these with your performance collections stats which hopefully includes PIDs and UNIX commands (uv, uvsh, phantom, u2amiproxy, etc, etc).. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Boydell, Stuart Sent: Friday, 21 January 2011 11:04 AM To: U2 Users List Subject: [U2] [UV][AIX] System Management and Performance Tools Hi, Just wondering if anyone has any recommendations for systems monitoring/management tools for aix5.3/uv10.2.4. I've seen occasional discussions on the topic here over the years. Ideally, what we would like to do is be able to track down those end of month type processes which bog the system down with CPU IO bottlenecks during peak load periods. I suppose this could be done with something like topas, truss and PORT.STATUS but just wondering what is available. There was a tool called DPMonitor that looked like it could be suitable - does this exist in any form? Also, does anyone know if the Travels with Mark: A Hitchhiker's Guide to the UniVersehttp://www.google.com/url?sa=tsource=webcd=1sqi=2ved=0CBIQFjAAurl=http%3A%2F%2Fwww.mail-archive.com%2Fu2-users%40listserver.u2ug.org%2Fmsg13400.htmlrct=jq=dm-dw-dm-0512baldridge-iei=jMs4TavnI4mYvAOC0uiJCgusg=AFQjCNGTQCWE14j2-XEP6lQSFjTnMi98Zgcad=rja series on performance tuning is available anywhere. It was on the IBM developerworks site but, no more. ** 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
Re: [U2] LIST.READU - RELEASE (done)
Try the UNLOCK command. Also, I recommend you use LIST.READU EVERY to see all locks held. Usage: UNLOCK USER xxx ALL or UNLOCK INODE ALL (or similar if I recall the syntax. (Copy entries mentioned above from the UV account VOC file, if not present) NEVER use UNLOCK ALL...unless you wish to potentially wreak havoc on your system. ;-) The UV Deadlock daemon does periodic clean-ups of locks for dead and deadlocked processes - check it's log fie in the UV account to see if it released these locks. FYI: This is wealth of archived emails for U2-Users email list with lots of UV specific info you can Google or use the likes of Mail-archive to search... such as this posting: http://www.mail-archive.com/u2-users@listserver.u2ug.org/msg03438.html It's quite helpful...as it is impossible to remember all this stuff! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Garry Smith Sent: Wednesday, 19 January 2011 11:55 AM To: U2 Users List Subject: [U2] LIST.READU - RELEASE (done) I guess the command RELEASE clears the UV lock table --- So great -- LIST.READU shows you some information ... but how do you clear these locks Active Record Locks: Device Inode Netnode Userno Lmode Pid Login Id Item-ID. 2621441 328100 50 4 RUS1970666 2621441 328100 48 30 RUS1970676 2621441 328100 44885 31 RUS1970557 = PID kill what ?? clear ?? 26214417866190 36393 31 RU448659~VG.6 2621441 328100 82 32 RUS1970438 When I try to kill 44885 as reported by Userno Unix says no such user. clear.locks only looks at your current login session. Any suggestions ? UV 9.6 and Aix 5.2 Garry L. Smith ** 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
Re: [U2] Sockets problem
Also check and updated your /etc/services with your desired TCP or UDP ports you end up using. Saves grief in the future too :) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Don Robinson Sent: Tuesday, 11 January 2011 2:38 PM To: U2 Users List Subject: Re: [U2] Sockets problem David, 1024 and below are considered well known ports and are reserved for things like telnet, ftp, http, etc. You need to be careful assigning private ports so you don't tramp on other assignments. netstat will show you your current assignments. Don Robinson ___ 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 __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ 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 ** 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
Re: [U2] uonet
None of these articles give you exactly want you want...but they should point you in the right direction... :-) Brian Leach posted an example, which may help, some time ago: http://old.nabble.com/list-DICT-uniObjects-to24476618.html#a24476618 Also Brian wrote this detailed introduction to VB UO available from the U2Users Knowledge Base: http://109.104.64.69/kb/kbview.wsp?id=10 Brian also has his own website various items with tools, freebies and (for a reasonable fee) training manuals, etc. http://www.brianleach.co.uk/pages/books.htm Regards, David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Cooper, Rudy Sent: Friday, 7 January 2011 10:02 AM To: 'U2-Users@listserver.u2ug.org' Subject: [U2] uonet I need some help. I'm writing a front-end program using vb.net and uo.net. My form has single valued fields, text boxes and a datagrid. My backend is uv 10.3.3 in windows. Does anyone have or can they direct me to an example that shows how to loop thru a datagrid, pull out the values and update or insert into a uv file using uo.net without using UniSubroutine, preferrable using Unidynarray? Thx, Rudy ** 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
Re: [U2] [UV] Invalid SELECT list specification keyword ignored.
Do you get the same problem with EXECUTE? BTW: Do you have $OPTION PERF.EQ.EXEC set in your code? Finally, have you tried adding SELECT.ONLY keyword so it only executes if there is an active select list (not sure if it can/will check select list 9 though!). -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jacques G. Sent: Thursday, 6 January 2011 7:58 AM To: U2 Users List Subject: [U2] [UV] Invalid SELECT list specification keyword ignored. Hello, I have the following command: SSELECTY VOC FROM 9 TO 10 (10 It works fine from the TCL level but when used in a PERFORM statement in a program I get the: Invalid SELECT list specification keyword ignored. Error message: Any ideas ? ** 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
Re: [U2] UVODBC Connection Problem
Are you certain the UniRPC daemon is started on your UV HPUX host? Also I suggest you do a CONNECT to localuv via TCL prompt to ensure every is OK from UV on your host system before hand...if you are unable to do an local connection it's very unlikely a remote connect will work either. At the TCL prompt, type CONNECT and press ENTER/RETURN key - this should show all your ODBC data sources from default UCI configuration file. Ensure the localuv definition is correct for your HPUX host (IP or hostname is correct) that you're performing the test on. If the localuv definition details are all correct, then proceed to connect to localuv to the application UV account you wish to do the test. Hope this helps :) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chambers, Gary Sent: Thursday, 2 December 2010 7:27 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UVODBC Connection Problem Bill, In my example 'uvdbsizes' is the account. Now that you mentioned it I did give passing thought to put that account name in caps on the notion it may be expected. I will try that. The file in the account I am going after is UV.DB.SIZES and contains some 10,000 odd records which are not necessarily complex but the file is dynamic, which I neglected to include in previous detail. So, I could try a different and trimmed down non-dynamic file. Thank you for the comments from Gary Smith. I have plenty of new things to try and I do hope to be claiming victory soon. Gary Chambers ** 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
Re: [U2] Connectivity issue with ODBC - SQL.
You don't mention the nature of the processing you're doing...so here's some 'potential' scenarios... :) But in reality it could be lots of things... 1) Lost connection to UV Is it possible you connection is timing out? That is, your UV ODBC connection is timing out - possibly? Check the timeout in your unirpcservices file for ODBC connections and check what your application is doing - perhaps it is opening the connection first, doing a MS SQL query and in the mean time the connection is lost? 2) UV SQL Query failure due Check the log files on the UV side in the account where you queries are connecting to for any log files (uvodbc.log or uverror.log, etc) applicable for your UV release. Is the files/tables you're querying dynamic hashed files (are they OK? Not need of repair/fixing) and have you checked by manually doing the same SQL query from UV itself using the CONNECT verb or at the TCL prompt in the account you're connecting to? Are there any SQL Updates going on? If so I'd be thinking that there is locking contention issues may be happening (such things you can't reproduce on demand)... I also wonder if your process is running out of memory or the like (any core files?)...perhaps consider explicitly setting up the buffers in the uci.config. But that seems unlikely and perhaps should be a last resort type change! Yet, again speculation unless we really know what you're query is doing... It may be worth while to turn on some UVODBC logging if you still have problems - beware of log file sizes though! :) Regards, David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ken Ford Sent: Wednesday, 24 November 2010 12:44 PM To: u2-users@listserver.u2ug.org Subject: [U2] Connectivity issue with ODBC - SQL. From: Ken Ford Sent: Wednesday, 24 November 2010 11:37 AM To: 'u2-users@listserver.u2ug.org' Cc: Angel Frost Subject: Connectivity issue with ODBC - SQL. Could anyone shed light on the following problem we are having? We have a Windows 2003 R2, running SQL Server 2008R2 connecting to Universe 10.3 on AIX 5.3, via UniVerse ODBC driver 3.7 And are getting the error below intermittently (sensitive details represented with '*'s): Message: Executed as user: ***. The OLE DB provider MSDASQL for linked server ** reported an error. The provider reported an unexpected catastrophic failure. [SQLSTATE 42000] (Error 7399) Cannot initialize the data source object of OLE DB provider MSDASQL for linked server **. [SQLSTATE 42000] (Error 7303). The step failed. We have checked the user group list archives, and couldn't find anything matching this completely. Thanks for any help you can provide, Ken Ford Senior Software Engineer - Universe Today, the Universe - tomorrow, the world! ** 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
Re: [U2] Uniobjects on windows mobile/CE
Talk about bad timing, it's now moved here: https://u2devzone.rocketsoftware.com/accelerate/articles/compact-framework/compact-framework Annoyingly, yet another (separate) user-ID and password is required for this site!! :-( All the U2 articles/tutorials have been moved to: https://u2devzone.rocketsoftware.com/accelerate/articles/index https://u2devzone.rocketsoftware.com/accelerate/tutorials/index -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny Sent: Tuesday, 23 November 2010 3:55 AM To: U2 Users List Subject: Re: [U2] Uniobjects on windows mobile/CE Thanks David, but I got a 404 not found on the link. I did start a Windows Mobile app in Visual Studio 2008 and added in the Uniobjects.NET .dll with no problem. I pasted in the whole Try loop for establishing a session from another app I had previously developed and it seemed to like the syntax/objects just fine. Unfortunately, not being in the office today I could only attempt to deploy it to the emulator and the deploy blew up quite nicely. I'm not too worried about that however since the emulator is notoriously buggy. Hona, David wrote: Check this out: https://u2tcint.rocketsoftware.com/developerzone/techarticles/nkesic0909/ -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny Sent: Saturday, 20 November 2010 4:53 AM To: U2-Users@listserver.u2ug.org Subject: [U2] Uniobjects on windows mobile/CE Does anyone know if Uniobjects with work on Windows Mobile or CE? ** 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
Re: [U2] Uniobjects on windows mobile/CE
Check this out: https://u2tcint.rocketsoftware.com/developerzone/techarticles/nkesic0909/ -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny Sent: Saturday, 20 November 2010 4:53 AM To: U2-Users@listserver.u2ug.org Subject: [U2] Uniobjects on windows mobile/CE Does anyone know if Uniobjects with work on Windows Mobile or CE? -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot 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
Re: [U2] New Client Specifics
In fact IBM wrote the basis of what we now call Eclipse... But Doug's company has been in the U2/MV Eclipse market way before IBM U2/Rocket got there...perhaps they were in fact inspired by the U2Logic editor.. :-) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Saturday, 13 November 2010 3:27 AM To: 'U2 Users List' Subject: Re: [U2] New Client Specifics Erm i think IBM have been 'doing' eclipse ever since it first started ** 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
Re: [U2] Building XML using the UV XDOM API functions
Hi Gregor Thanks for sharing your useful experiences and your blog. I found the same issue with U2 MQSeries API documentation too. Although, I guess when you are using such complex API's - it helps first to understand the underlying technology and concepts. Be it MQSeries or XML, etc. Otherwise, it is a case of learning or mis-learning two things at once. I find nearly all documentation from vendors have issues. Be they specialists in a particular field of a jack-of-trades multi-national software corporation. :) Your mileage will varyas it vary in respect with your own competency and the fact one size can never fit all skills/knowledge (etc)...be it tools or documentation or vendors or consultants! ;-) I do see value in investing some time/effort in the potential value that third-party tools and consultants can provide. Should budget, time and capabilities dictate such a requirement. Alas, we rarely have enough the later attributes... Cheers, David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Gregor Scott Sent: Wednesday, 27 October 2010 10:30 AM To: U2 Users List Subject: 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 ** 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
Re: [U2] mv.NET and U2.NET
I'll second that... Perhaps some of the large amount of energies expended in this colourful exchange can be diverted to a blow-by-blow feature comparison of U2.NET and MV.NET for a Spectrum magazine article? :-) - features - optimisation - benefits - licensing arrangements/schemes - installed licensed user base figures would be interesting to know - perhaps some basic benchmarking against the same back-end database/server would be great :-) And just for the heck of it - why not throw in the ISS PDP.NET into the mix too! Just a thought for someone! David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Friday, 13 August 2010 6:03 PM To: 'U2 Users List' Subject: Re: [U2] mv.NET and U2.NET So back the original point - what has been done to U2.net in the past 2 years, as a var of udt buying from APT I don't know ! - so i, and it looks like this group as well, would like some enlightenment please. I know how MV.NET has come on in leaps and bounds and it would be good to compare. Thanks Symeon. ** 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
Re: [U2] Impossible to handle big files (over 2 Gb) with Universe onPowerPC
Hi Augusto, Oh, I see. I guess the only option you have is to either move off PowerPC or get the AIX for PowerPC - then you can get vUV 10.3.x? I guess that isn't going to be cheap or perhaps not feasible for your existing server? Or perhaps use UV/Net to connect to a server with a later version of UniVerse that has 64BIT files? I believe UV file indices are supported via UV/Net...you can check with U2 support to double-check. I guess cost and complexity with help you determine what option suits you best... Hope this helps... Regards, David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Augusto Alonso Sent: Friday, 13 August 2010 7:17 PM To: U2 Users List Subject: Re: [U2] Impossible to handle big files (over 2 Gb) with Universe onPowerPC Hi David. The problem is that our App needs a File definition that way: BIGFILE_1 1: F 2: D_BIGFILE_1 3: I_BIGFILE/INDEX.001 So that, if we distribute BIGFILE, then the indexes will be distributed as well. And we loose the single definition for INDEX.001, because we will have several INDEX.001 Regards -- Augusto Alonso Alonso Director de Sistemas QUITER SERVICIOS CENTRALES Zoco Gran Santander, 1ª planta - 39011 Santander - España Telf: +34 902233323 - Fax: +34 902234280 ** 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
Re: [U2] Impossible to handle big files (over 2 Gb) with Universe onPowerPC
Hi Augusto It would be interesting to know why you think your application can't utilise distributed files. Regards David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of aalo...@quiter.com Sent: Wednesday, 4 August 2010 8:27 PM To: U2 Users List Subject: Re: [U2] Impossible to handle big files (over 2 Gb) with Universe onPowerPC It is not a matter of the OS nor the File System. It is a UV limitation. I know the distributed files option, but this is not possible because of the app. Regards -- AA -mensaje original- Asunto: Re: [U2] Impossible to handle big files (over 2 Gb) with Universe onPowerPC De: Morawa, Hans hans.mor...@boral.com.au Fecha: 04/08/2010 10:44 Augusto, To check if your system handles large file support you need to use the getconf program, syntax something like getconf FILESIZEBITS /path on most systems. Regards, Hans Morawa ** 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
Re: [U2] Universe 10.3 - Issues with I-Types when using subroutine calls, and the dictionary items is Alt-key
The most common problems with conversions to new versions of UV is that the UVCONFIG parameters are not aligned to what they were under the previous release and/or what is appropriate for the new OS and UV version. Where applicable you must also ensure if you are re-hosting (ie., different host) that any applicable kernel changes if using a version UNIX - for the new release are made in accordance with Rocket U2 recommendations and your actual requirements for your application (ie., your UVCONFIG, etc). Check MFILES. Check T30FILES if using dynamic files are set to values equivalent to what you had previous, etc. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Aramaies Sent: Thursday, 5 August 2010 9:24 AM To: u2-users@listserver.u2ug.org Subject: [U2] Universe 10.3 - Issues with I-Types when using subroutine calls, and the dictionary items is Alt-key Good Day, We are in the process of upgrading from Universe 9.6 to 10.3, and we have noticed that the system performance is degraded when we use an I-Type dictionary with subroutine calls, and the item is also an alternate key. It seems that the report run about 4 or 5 times slower. Is there someone else who has encountered similar issues? Any ideas? Best regards, Aramaies Baghdasraian ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ** 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
Re: [U2] Tracing ODBC requests
Hello Ken, Check out the API Supplement PDF (apisupp.pdf) Try this... haven't used it for a long time...I believe ODBC connections go via uvserver. Last time I used was for uvcs though, I can't recall it actually works for ODBC connections. You can also get your remote system to invoke a stored procedure to your UV Regards David Extracted out of the PDF: Logging Client Connections Beginning at UniVerse 10.0, a server-side debugging log is available for tracking client connections. The debugging log is located in the /tmp/ directory on UNIX, or C:\tmp on Windows platforms, by default. Complete the following steps to set up the debugging log: 1.Edit the serverdebug file in the UVHOME directory. 2.In the first column, enter uvcs, indicating that you want to log the connection progress for both uvapi_server and uvapi_slave. 3.In the next column, enter an integer indicating the level of logging information you want to maintain. The valid integers are: 0 - No debugging. 1 - Captures information about the startup connection only. 9 - Captures information about every call. 4.In the third column, enter the full path for the log file location. If this value does not exist, the logs are written to /tmp/uvapiserver_###.log as the default on UNIX systems, or C:\tmp\uvapiserver.log as the default on Windows systems. is the uvapi_server process ID. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ken Ford Sent: Tuesday, 20 July 2010 1:35 PM To: u2-users@listserver.u2ug.org Subject: [U2] Tracing ODBC requests Hello List Members. Can anyone suggest a way to log the SQL requests sent via ODBC to the Universe DB (from a MS Windows client to a AIX based Universe DB). I suppose I want the commands processed by the uvapi_slave process. I have tried capturing them via the LOGIN paragraph to no avail. Any help would be appreciated. The manuals, as is often the case, were unhelpful. Regards, Ken Ford Software Engineer - Universe Phone: 07 3013 8605 Fax: 07 3002 8400 Email: ken.f...@firstmac.com.au Web: www.firstmac.com.au ** 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
Re: [U2] UniJDBC calling UV subroutine: MESSAGE command limitations?
Does the !MESSAGE subroutine work? It probably just calls the MESSAGE verb! :) Pages 57-59 (3-15) of the UV 10.3 Sysdesc.pdf (Feb 09) details the Dispatch Codes and Processor Modes available. I can't recall watch combination you need. But you likely need the Dispatch Code not be E or U. Simply look at any VOC entry of a VERB that does do work as a phantom or via the UV API/JDBC and add those Dispatch Codes - at your own risk, of course :) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Womack, Adrian Sent: Wednesday, 30 June 2010 1:59 PM To: 'U2 Users List' Subject: Re: [U2] UniJDBC calling UV subroutine: MESSAGE command limitations? Thanks for that Dan - I was coming to the same conclusion myself. We already have another phantom that uses MESSAGE, so I knew that wouldn't be a problem. I was a bit disheartened when I found out i could use PHANTOM either - that would have been a relatively painless approach. We do have a number of other phantoms already doing tasks at various intervals, so adding an extra task to just poll a file would be too much to ask. It's a pity that I can't use MESSAGE (or PHANTOM) directly. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan McGrath Sent: Wednesday, 30 June 2010 11:54 AM To: U2 Users List Subject: Re: [U2] UniJDBC calling UV subroutine: MESSAGE command limitations? I just checked on our system and I can call MESSAGE within a PHANTOM if it is executed from a normal session. With this in mind, a possible work around would be to run a 24/7 phantom that either accepts data from a named piped/socket or polls a file and sends out a message based on the data received. From your UV subroutine you could then just passed the required data by the appropriate method. It's dirty and obviously having it work natively from your UV sub would be better, but if it isn't possible... Regards, Dan ** 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