Re: [U2] re directing a unidata directory to another server
On 22/01/11 15:10, grmhbeers wrote: I have created a Unidata (1.7x) directory to which I am writing files in a unibasic program. However I want the file to be saved directly in a folder on another server that is in the same virtual machine as our Unidata based system. All reside on windows server. I have tried everything I can think of from drive mapping to shortcuts, but Unidata still can't find the folder on the other server. What do I do so Unidata sees the mapping or shortcut or ??. Can this be done in Unidata? I do not want to ftp the files, I want them saved on the other server when the Unibasic program writes the file. Is the other server a Unidata server too? Can't speak for Unidata, but Universe won't allow this scenario by default. All locks are on the CPU that UV is running on, so in order for two Universe servers to talk to each other you need UV-net to ensure that locking works. There is an ALLOWNFS option that will let UV talk to another server, on the assumption that it is the only UV server accessing the remote files. I suspect UD has a similar setup. Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] re directing a unidata directory to another server
Can you see this other file/folder from the cmd prompt ? From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of grmhbeers Sent: 22 January 2011 15:10 To: u2-users@listserver.u2ug.org Subject: [U2] re directing a unidata directory to another server I have created a Unidata (1.7x) directory to which I am writing files in a unibasic program. However I want the file to be saved directly in a folder on another server that is in the same virtual machine as our Unidata based system. All reside on windows server. I have tried everything I can think of from drive mapping to shortcuts, but Unidata still can't find the folder on the other server. What do I do so Unidata sees the mapping or shortcut or ??. Can this be done in Unidata? I do not want to ftp the files, I want them saved on the other server when the Unibasic program writes the file. -- View this message in context: http://old.nabble.com/redirecting-a-unidata-directory-to-another-server-tp30 736884p30736884.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 _ No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1191 / Virus Database: 1435/3395 - Release Date: 01/21/11 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] re directing a unidata directory to another server
The other server is not a unidata server. It's our moodle server. Both are on sql server platforms. Unidata is underneath the sql server platform for the application where the Unibasic program is generating the output files. Wols Lists wrote: On 22/01/11 15:10, grmhbeers wrote: I have created a Unidata (1.7x) directory to which I am writing files in a unibasic program. However I want the file to be saved directly in a folder on another server that is in the same virtual machine as our Unidata based system. All reside on windows server. I have tried everything I can think of from drive mapping to shortcuts, but Unidata still can't find the folder on the other server. What do I do so Unidata sees the mapping or shortcut or ??. Can this be done in Unidata? I do not want to ftp the files, I want them saved on the other server when the Unibasic program writes the file. Is the other server a Unidata server too? Can't speak for Unidata, but Universe won't allow this scenario by default. All locks are on the CPU that UV is running on, so in order for two Universe servers to talk to each other you need UV-net to ensure that locking works. There is an ALLOWNFS option that will let UV talk to another server, on the assumption that it is the only UV server accessing the remote files. I suspect UD has a similar setup. Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- View this message in context: http://old.nabble.com/redirecting-a-unidata-directory-to-another-server-tp30736884p30737692.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
Re: [U2] re directing a unidata directory to another server
From what I understand you have Unidata on one machine and you want to write to a directory on another machine within your network (node). I'm not sure what you mean by a folder on another server that is in the same virtual machine...a virtual machine spans two physical machines? Assuming I've misunderstood, if you're running Windows 2003 it's easy. If you're running Windows 2008 it's relatively easy but different. Which O/S are you running? Bill grmhbeers said the following on 1/22/2011 9:45 AM: The other server is not a unidata server. It's our moodle server. Both are on sql server platforms. Unidata is underneath the sql server platform for the application where the Unibasic program is generating the output files. Wols Lists wrote: Is the other server a Unidata server too? Can't speak for Unidata, but Universe won't allow this scenario by default. All locks are on the CPU that UV is running on, so in order for two Universe servers to talk to each other you need UV-net to ensure that locking works. There is an ALLOWNFS option that will let UV talk to another server, on the assumption that it is the only UV server accessing the remote files. I suspect UD has a similar setup. Cheers, Wol Original Message Subject:[U2] re directing a unidata directory to another server Date: Sat, 22 Jan 2011 07:10:28 -0800 (PST) From: grmhbeersghbe...@cox.net Reply-To: U2 Users Listu2-users@listserver.u2ug.org To: u2-users@listserver.u2ug.org I have created a Unidata (1.7x) directory to which I am writing files in a unibasic program. However I want the file to be saved directly in a folder on another server that is in the same virtual machine as our Unidata based system. All reside on windows server. I have tried everything I can think of from drive mapping to shortcuts, but Unidata still can't find the folder on the other server. What do I do so Unidata sees the mapping or shortcut or ??. Can this be done in Unidata? I do not want to ftp the files, I want them saved on the other server when the Unibasic program writes the file. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] re directing a unidata directory to another server
On 22/01/11 17:45, grmhbeers wrote: The other server is not a unidata server. It's our moodle server. Both are on sql server platforms. Unidata is underneath the sql server platform for the application where the Unibasic program is generating the output files. In other words, assuming UD is the same as UV, all you need do is find the NFSALLOW (or equivalent) flag, and set it to true (ie 1). As I say, I guess UD, by default, will refuse to write to a network drive but by setting that flag you are telling UD no, it's safe to write to the network. Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] re directing a unidata directory to another server
I don't think UD has the NFSALLOW flag. In UD, you can simply write to any directory that's available to the network where the user had write privileges. This raises a number of issues but, for instance, in Windows 2003 Server you can create a VOC entry to: OSFILE 001 DIR 002 \\SOMESERVER\D$\SOMEDIRECTORY 003 D_VOC This works but you may have to alter the permissions, if a UD user doesn't have the proper Windows permissions. In Windows 2008, however, you have to explicitly share the directory on the server. Then the VOC entry is like: OSFILE 001 DIR 002 \\SomeServer\ShareName 003 D_VOC At least this has been my experience so far. Bill Wols Lists said the following on 1/22/2011 2:02 PM: On 22/01/11 17:45, grmhbeers wrote: The other server is not a unidata server. It's our moodle server. Both are on sql server platforms. Unidata is underneath the sql server platform for the application where the Unibasic program is generating the output files. In other words, assuming UD is the same as UV, all you need do is find the NFSALLOW (or equivalent) flag, and set it to true (ie 1). As I say, I guess UD, by default, will refuse to write to a network drive but by setting that flag you are telling UD no, it's safe to write to the network. Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] re directing a unidata directory to another server
Symeon Breen syme...@gmail.com wrote: Can you see this other file/folder from the cmd prompt ? From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of grmhbeers Sent: 22 January 2011 15:10 To: u2-users@listserver.u2ug.org Subject: [U2] re directing a unidata directory to another server I have created a Unidata (1.7x) directory to which I am writing files in a unibasic program. However I want the file to be saved directly in a folder on another server that is in the same virtual machine as our Unidata based system. All reside on windows server. I have tried everything I can think of from drive mapping to shortcuts, but Unidata still can't find the folder on the other server. What do I do so Unidata sees the mapping or shortcut or ??. Can this be done in Unidata? I do not want to ftp the files, I want them saved on the other server when the Unibasic program writes the file. -- View this message in context: http://old.nabble.com/redirecting-a-unidata-directory-to-another-server-tp30 736884p30736884.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 _ No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1191 / Virus Database: 1435/3395 - Release Date: 01/21/11 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] re ceiving error message XX record corrupt on logto
Hi Susan In your logto script try adding CLEARCOMMON then LOGIN so that you go in cleanly. You can add a Logto subroutine in SB+, go to the Admin screen, SB+ Setup, SB+ Control Parameters, F9 Logto Sub. I've experienced this error when logging between accounts from different versions of SB+ (different COMMON blocks). Regards David Susan Joslyn wrote: I have this happening at a client site and I've been all through the re-file everything and it won't quit. It happens *consistently* if I have more than one session open, but still happens intermittently when I don't. If you do come up with a fix for this I'd be very keen to learn it! Thanks, Susan Joslyn SJ+ Systems Associates, Inc. PRC - IT Governance for U2/Multivalue. From: Susan Lynch sly...@fwdco.com To: U2 Users List u2-users@listserver.u2ug.org Subject: Re: [U2] receiving error message XX record corrupt on logto Message-ID: 004b3459d050475daf942cfccd93c...@susanhome Content-Type: text/plain; format=flowed; charset=iso-8859-1; reply-type=original Kevin, yes, ROOT was the first one I did! Susan Lynch F. W. Davison Company, Inc. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- View this message in context: http://old.nabble.com/receiving-error-message-XX-record-corrupt-on-logto-tp28646451p28654669.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
Re: [U2] re ceiving error message XX record corrupt on logto
I tried this - it did not seem to help. Thanks for the idea, though. And thanks to all who have tried to help on this one. Susan Lynch F. W. Davison Company, Inc. - Original Message - From: inquieti dinqui...@zafire.com To: u2-users@listserver.u2ug.org Sent: 05/24/2010 4:26 AM Subject: Re: [U2] re ceiving error message XX record corrupt on logto Hi Susan In your logto script try adding CLEARCOMMON then LOGIN so that you go in cleanly. You can add a Logto subroutine in SB+, go to the Admin screen, SB+ Setup, SB+ Control Parameters, F9 Logto Sub. I've experienced this error when logging between accounts from different versions of SB+ (different COMMON blocks). Regards David Susan Joslyn wrote: I have this happening at a client site and I've been all through the re-file everything and it won't quit. It happens *consistently* if I have more than one session open, but still happens intermittently when I don't. If you do come up with a fix for this I'd be very keen to learn it! Thanks, Susan Joslyn SJ+ Systems Associates, Inc. PRC - IT Governance for U2/Multivalue. From: Susan Lynch sly...@fwdco.com To: U2 Users List u2-users@listserver.u2ug.org Subject: Re: [U2] receiving error message XX record corrupt on logto Message-ID: 004b3459d050475daf942cfccd93c...@susanhome Content-Type: text/plain; format=flowed; charset=iso-8859-1; reply-type=original Kevin, yes, ROOT was the first one I did! Susan Lynch F. W. Davison Company, Inc. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- View this message in context: http://old.nabble.com/receiving-error-message-XX-record-corrupt-on-logto-tp28646451p28654669.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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] re ceiving error message XX record corrupt on logto
Hi Susan This is caused by either a missing or corrupt DMSECURITY item(s). We had a customer that couldn't add anything to their menus because when they did, upon saving half the menus would disappear completely. It was all due to the fact that they had removed an account at Unix but everything was still in the DMSECURITY file. When the menus were re-built the 'missing' account caused corruption. It could even be the fact that the Allow Disallow on accounts with restrictions has modules missing. Make sure the DMSECURITY is totally up to date and in line with the actual accounts. Regards David Susan Lynch wrote: I am hoping that someone has a good memory - the company I am working with is running SBPlus 5.3.3, which is past the End of Service date. I have checked the U2 Knowledge Base for this problem, and have checked everything that they listed, and none of those possible causes are the reason for this account. My user says that he changed SB security for this account, and now HE can't log to the account without getting this message, and neither can I - and I am in the ROOT group, and the account is in the ROOT group's list of accounts without restrictions. If all else fails, I can try copying over all the XX files from an account where we are not getting this message, but I am not convinced that it will solve the problem, since it arose immediately after he changed something in the security settings for the account. Any ideas? Thanks! Susan Lynch F. W. Davison Company, Inc. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- View this message in context: http://old.nabble.com/Question-about-umask-tp28624993p28633985.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
Re: [U2] re ceiving error message XX record corrupt on logto
Thanks! I will go check that now! Susan Lynch F. W. Davison Company, Inc. - Original Message - From: inquieti dinqui...@zafire.com To: u2-users@listserver.u2ug.org Sent: 05/21/2010 9:47 AM Subject: Re: [U2] re ceiving error message XX record corrupt on logto Hi Susan This is caused by either a missing or corrupt DMSECURITY item(s). We had a customer that couldn't add anything to their menus because when they did, upon saving half the menus would disappear completely. It was all due to the fact that they had removed an account at Unix but everything was still in the DMSECURITY file. When the menus were re-built the 'missing' account caused corruption. It could even be the fact that the Allow Disallow on accounts with restrictions has modules missing. Make sure the DMSECURITY is totally up to date and in line with the actual accounts. Regards David Susan Lynch wrote: I am hoping that someone has a good memory - the company I am working with is running SBPlus 5.3.3, which is past the End of Service date. I have checked the U2 Knowledge Base for this problem, and have checked everything that they listed, and none of those possible causes are the reason for this account. My user says that he changed SB security for this account, and now HE can't log to the account without getting this message, and neither can I - and I am in the ROOT group, and the account is in the ROOT group's list of accounts without restrictions. If all else fails, I can try copying over all the XX files from an account where we are not getting this message, but I am not convinced that it will solve the problem, since it arose immediately after he changed something in the security settings for the account. Any ideas? Thanks! Susan Lynch F. W. Davison Company, Inc. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- View this message in context: http://old.nabble.com/Question-about-umask-tp28624993p28633985.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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Re trieving Unix Date and Time stamp on records in a DIR type file
You could use EXECUTE ! stat ./BP/PROG1 CAPTURING OUT and parse out the bits you are interested in. This will show date/time of the most recent access, modification and change -- View this message in context: http://www.nabble.com/Retrieving-Unix-Date-and-Time-stamp-on-records-in-a-DIR-type-file-tp26077531p26079891.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
Re: [U2] Re trieving Unix Date and Time stamp on records in a DIR type file
Use the DIR command on the file. Get the path of the file, append the appropriate \ or /, then do a DIR. For example, on a Unix machine: ITEM.ID = 'TEST' OPEN '','BP' TO BP THEN FILE.PATH = FILEINFO(BP,2) ITEM.PATH = FILE.PATH:'/':ITEM.ID ITEM.DATE = OCONV(DIR(ITEM.PATH)2,'D2/') END PRINT ITEM.DATE This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. Any views and/or opinions expressed in this e-mail are of the author only and do not represent the views of Epicor Software Corporation or any other company within its group. This message has been scanned for malware by Websense. www.websense.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Re trieving Unix Date and Time stamp on records in a DIRtype file
Perfect. Thank you! David Laansma IT Manager Hubbard Supply Co. Direct: 810-342-7143 Office: 810-234-8681 Fax: 810-234-6142 www.hubbardsupply.com Delivering Products, Services and Innovative Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug Farmer Sent: Tuesday, October 27, 2009 11:56 AM To: U2 Users List Subject: Re: [U2] Re trieving Unix Date and Time stamp on records in a DIRtype file Use the DIR command on the file. Get the path of the file, append the appropriate \ or /, then do a DIR. For example, on a Unix machine: ITEM.ID = 'TEST' OPEN '','BP' TO BP THEN FILE.PATH = FILEINFO(BP,2) ITEM.PATH = FILE.PATH:'/':ITEM.ID ITEM.DATE = OCONV(DIR(ITEM.PATH)2,'D2/') END PRINT ITEM.DATE This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. Any views and/or opinions expressed in this e-mail are of the author only and do not represent the views of Epicor Software Corporation or any other company within its group. This message has been scanned for malware by Websense. www.websense.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
RE: [U2] RE: Truncated catdir names
Any reason for not resizing catdir as type 19? I have done this and nothing seems to have broken. In fact I would hope that it would not as the file type should be transparent to any application. -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2- us...@listserver.u2ug.org] On Behalf Of Hona, David Sent: Wednesday, 27 May 2009 6:30 p.m. To: u2-users@listserver.u2ug.org Subject: [U2] RE: Truncated catdir names Hi David This probably goes back to the limitations of the original port of UNIX that had the directory name limited and the maximum number of characters in a pathname. It's unfortunate that IBM hasn't address this - but it has been around for a long, long time. But, I guess there has been little demand, as most U2 applications are legacy ones with short filenames and accounts names. You definitely should **NOT** resize your catdir to type 19 (or any other filetype)! :) Regards, David -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2- us...@listserver.u2ug.org] On Behalf Of Norman, David (Health) Sent: Wednesday, 27 May 2009 4:02 PM To: 'u2-users@listserver.u2ug.org' Subject: [U2] Truncated catdir names I made an unpleasant discovery when I recataloged (normally) one of my accounts (UV10.0, HP-UX). Some of the catalog names became too long (e.g. *SJ.RR.MAST.DEVELOP*GET.COUNTRY.RESPONSE.SE) and were truncated by the catalog process (*SJ.RR.MAST.DEVELOP*GET.COUNTRY.RESPONSE.). Unfortunately I had several programs with similar names (GET.COUNTRY.RESPONSE.ALL, .METRO, .NW, .RV, .SE). All of these resulted in the same truncated name so only 1 catdir entry was created, which was for the last one of the 5 cataloged. The catdir path is ...catdir/*SJ.RR.MAST.DE/VELOP*GET.COUN with a single file of *GET.COUN . Trying to run the programs results in a warning File name *SJ.RR.MAST.DEVELOP*GET.COUTRY.RESPONSE.SE too long. Truncated to *SJ.RR.MAST.DEVELOP*GET.COUNTRY.RESPONSE. Is this a known limitation ? Why does the directory nesting stop at the 2nd level ? The VOC entries show the full names. catdir is type 1 out of the box. David Norman Senior Software Engineer - SA Ambulance Service ** 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 To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: Truncated catdir names
I was going to add that in the past it would break stuff...I haven't tried it recently!! I guess you can just make a backup / shutdown UV first whilst people aren't accessing the catdir :) -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of phil walker Sent: Wednesday, 27 May 2009 5:16 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] RE: Truncated catdir names Any reason for not resizing catdir as type 19? I have done this and nothing seems to have broken. In fact I would hope that it would not as the file type should be transparent to any application. -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2- us...@listserver.u2ug.org] On Behalf Of Hona, David Sent: Wednesday, 27 May 2009 6:30 p.m. To: u2-users@listserver.u2ug.org Subject: [U2] RE: Truncated catdir names Hi David This probably goes back to the limitations of the original port of UNIX that had the directory name limited and the maximum number of characters in a pathname. It's unfortunate that IBM hasn't address this - but it has been around for a long, long time. But, I guess there has been little demand, as most U2 applications are legacy ones with short filenames and accounts names. You definitely should **NOT** resize your catdir to type 19 (or any other filetype)! :) Regards, David -Original Message- ** 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 To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: Another probably simple SB+ issue.
David, Works in text mode and from word etc. Interestingly enough managed to duplicate the problem. Before clicking the connect in a SBClient session there's a File option at the top of the window. Selecting that then selecting Print Options gets a small window up with a tick box labeled Use Windows Print Drivers. If you click that then carry on into your session the same issue occurs. Now the real cool part is after logging off and going back to the Print Options window the Use Windows Print Drivers is no longer ticked but the issue occurs if you log back onto the system. Thinking this has to be some sort of bug in SBClient. Unfort we have zero support over here, don't even get me started on the Aussie VAR situation, so am unable to call in the cavalry at this stage. Maybe if I stuffed up all the PCs I could claim it always worked that way :) Cheers, Jeff -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of David Jordan Sent: Wednesday, 6 May 2009 2:52 PM To: u2-users@listserver.u2ug.org Subject: [U2] RE: Another probably simple SB+ issue. Hi Jeff Check the default printer for that PC. It probably has no printer so it is saving the print image as a file Regards David Jordan Managing Consultant da...@dacono.com.au --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: Interest results on VOC file
It's a feature! For old legacy apps that use the marker (and other control/non-printable) characters as part of the key and are too hard to change. UV lets you turn that feature off, maybe UD does too now. -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Dan McGrath Sent: Wednesday, 29 April 2009 3:10 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] RE: Interest results on VOC file Hi Nick, I had tried checking out the ID's of the keys affected. There was was nothing unusual about them that I can tell. One was 1 and another was 2. When attempting to edit them, they didn't exist. After reading your email, I write a quick test program: 001: OPEN BREAKME TO FH ELSE STOP 003: WRITE 1 TO FH,1:@SM 002: WRITE 2 TO FH,2:@VM 003: WRITE 3 TO FH,3:@AM 004: WRITE 4 TO FH,4:CHAR(10) 005: WRITE 5 TO FH,5:CHAR(13) Bottom. *--: After running it, I did the select/nselect on BREAKME and it came back with 1 record. :) Record 3 didn't exist, the attribute marker is the culprit. Now I need to find out who has written a program that is causing this, because it isn't the first time these ghost records have appeared... It begs a question though. How come Unidata allows a program to write records with keys that it can not handle without error? 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 To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Re: [UV] Passing a string when a Matrix is expected
INMAT() looks like it may do the job for you. HTH. INMAT function _ SYNTAX INMAT ( [array] ) DESCRIPTION Use the INMAT function to return the number of array elements that have been loaded after the execution of a MATREAD, MATREADL, MATREADU, or MATPARSE statement, or to return the modulo of a file after the execution of an OPEN statement. You can also use the INMAT function after a DIM statement to determine whether the DIM statement failed due to lack of available memory. If a preceding DIM statement fails, INMAT returns a value of 1. If the matrix assignment exceeds the number of elements specified in its dimensioning statement, the zero element is loaded by the MATREAD, MATREADL, MATREADU, or MATPARSE statement. If the array dimensioning is too small and the zero element has been loaded, the INMAT function returns a value of 0. If array is specified, the INMAT function returns the current dimensions of the array. If array is the null value, the INMAT function fails and the program terminates with a run-time error message. EXAMPLE DIM X(6) D='123456' MATPARSE X FROM D,'' Y=INMAT() PRINT 'Y= ':Y * DIM X(5) A='CBDGFH' MATPARSE X FROM A,'' C=INMAT() PRINT 'C= ':C * OPEN '','VOC' TO FILE ELSE STOP T=INMAT() PRINT 'T= ':T This is the program output: Y= 6 C= 0 T= 23 -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Jacques G. Sent: Friday, 17 April 2009 7:27 AM To: u2-users@listserver.u2ug.org Subject: [U2] Re: [UV] Passing a string when a Matrix is expected I came accross a case in legacy code where a subroutine is defined to accept some matrixes as parameter ei: SUBROUTINE FOOBAR(TXT, MAT A, MAT B, MAT C, MAT D, OPTION) One of the calling programs that makes use of this subroutine does this: CALL FOOBAR(HELLO, , , , , WORLD) Instead of passing a matrix, it is passing an empty string. The result is that in FOOBAR, matrixes A, B, C and D are of size zero. In FOOBAR there is code that does: MATBUILD REC.A FROM A USING CHAR(1) Now the MATBUILD command on a matrix of size zero is giving me an undefined variable in a test program I wrote but in the program in production, it is giving me the content of a variable in the program. I was wondering if there is a way to detect if a matrix is of size zero in Unibasic. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Message protected by MailGuard: e-mail anti-virus, anti-spam and content filtering. http://www.mailguard.com.au/rr Click here to report this message as spam: https://login.mailguard.com.au/report/1xh3PzGPBt/7m4U8ME624iLZKoyw58t7e/0.6 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] RE: U2 Users Digest V1 #2599
True, but they will appear in the right order when they arrive and, barring a failure, they will all arrive. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] RE: U2 Users Digest V1 #2599
Kevin, aren't you describing UDP communication, not TCP? Packets can be fragged and move through any number of different channels w/ UDP, but they're reassembled as a part of being received through TCP. If you sent a 1024 packet over UDP I would expect exactly what you've stated. Send a 1024 packet through TCP and I'd expect 1024 to arrive, and in order, as long as there's no failure. Of course, failures can occur with any protocol, even those that self-negotiate, so timeouts, dropouts, disconnects, and other failures have to be addressed in the implementation. -K --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: U2 Users Digest V1 #2599
The issue is that if you send a 1024 byte message through a TCP socket, you may eventually get 1024 bytes out the other end, but you may not get them all at once. The message may be broken up into lots of pieces, i.e. if you do a read(), you may get 1024 bytes, or you may get a lot less, and have to read() again. Best regards, Henry Henry P. Unger Hitech Systems, Inc. http://www.hitech.com -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Thursday, April 09, 2009 4:01 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] RE: U2 Users Digest V1 #2599 Kevin, aren't you describing UDP communication, not TCP? Packets can be fragged and move through any number of different channels w/ UDP, but they're reassembled as a part of being received through TCP. If you sent a 1024 packet over UDP I would expect exactly what you've stated. Send a 1024 packet through TCP and I'd expect 1024 to arrive, and in order, as long as there's no failure. Of course, failures can occur with any protocol, even those that self-negotiate, so timeouts, dropouts, disconnects, and other failures have to be addressed in the implementation. -K --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] RE: UV Timed INPUT
George, I've run into that before - it's probably network latency. If there's nothing in your keyboard buffer, your routine will bail. If a multi-character keystroke gets broken between packets, that can happen. Experiment with a delay before the INPUT TEST,-1 to allow the network to catch up with you. It takes some tweaking, but faster hardware lessens the effect. Of course, if you're not networked in any way, then I'm probably all wet. I've been there before. Regards, Charlie Noah Inland Truck Parts Company George Gallen wrote: I Tried to write something similar, but kept getting random program lockups or universe bombouts. What I was trying to do was as letters were being typed, fine tune a listing to the right. Also, I tried to make a full screen editor, allowing the arrow s to allow the user to move from field to field, and the insert key would function as e xpected. Because I was only taking one key at a time, I had to use KEYIN (otherwise back space wouldn't trigger the routine as a key typed, or a function key would be returned as o nly the first character of the key. Most of the time it worked, just everynow and again, it would blow up, and I co uld never figure out why (although I was told it was most like something in the keyin( ) internally). The gist of the routine is below: It requires you to roll your own input routin e, that is you have to check for an ENTER, and check for a backspace, then remove the last char from BUFFER. 1000: INPUT TEST,-1: LOOP WHILE(TEST=1) DO BUFFER=BUFFER:KEYIN() INPUT TEST,-1: REPEAT RETURN George -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2- us...@listserver.u2ug.org] On Behalf Of Norman, David (Health) Sent: Wednesday, March 11, 2009 11:27 PM To: u2-users@listserver.u2ug.org Subject: [U2] UV Timed INPUT I'm sure I've seen something about this recently, but I've searched the past 2 years with no luck. I want to do a timed INPUT in UV - if after n seconds the Enter key hasn't been pressed, do something. Anyone got any clever ways of doing this ? Thanks, David Norman Senior Software Engineer - SA Ambulance Service ICT Services SA Health Government of South Australia Box 3, GPO Adelaide, South Australia 5001 *+61 8 8274 0384 * fax +61 8 8271 4844 * norman.da...@saambulance.com.au This e-mail may contain confidential information, which also may be legally privileged. Only the intended recipient(s) may access, use, distribute or copy this e-mail. If this e-mail is received in error, please inform the sender by return e-mail and delete the original. If there are doubts about the validity of this message, please contact the sender by telephone. It is the recipient's responsibility to check the e-mail and any attached files for viruses. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] RE: UV Timed INPUT
George, Email me tomorrow at charlien at inlandtruck.com and remind me and I'll share some code with you that worked extremely well on Universe, and now on Jbase - it's almost identical. I almost never get those straggling characters anymore. Charlie Charlie Noah wrote: George, I've run into that before - it's probably network latency. If there's nothing in your keyboard buffer, your routine will bail. If a multi-character keystroke gets broken between packets, that can happen. Experiment with a delay before the INPUT TEST,-1 to allow the network to catch up with you. It takes some tweaking, but faster hardware lessens the effect. Of course, if you're not networked in any way, then I'm probably all wet. I've been there before. Regards, Charlie Noah Inland Truck Parts Company George Gallen wrote: I Tried to write something similar, but kept getting random program lockups or universe bombouts. What I was trying to do was as letters were being typed, fine tune a listing to the right. Also, I tried to make a full screen editor, allowing the arrow s to allow the user to move from field to field, and the insert key would function as e xpected. Because I was only taking one key at a time, I had to use KEYIN (otherwise back space wouldn't trigger the routine as a key typed, or a function key would be returned as o nly the first character of the key. Most of the time it worked, just everynow and again, it would blow up, and I co uld never figure out why (although I was told it was most like something in the keyin( ) internally). The gist of the routine is below: It requires you to roll your own input routin e, that is you have to check for an ENTER, and check for a backspace, then remove the last char from BUFFER. 1000: INPUT TEST,-1: LOOP WHILE(TEST=1) DO BUFFER=BUFFER:KEYIN() INPUT TEST,-1: REPEAT RETURN George -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2- us...@listserver.u2ug.org] On Behalf Of Norman, David (Health) Sent: Wednesday, March 11, 2009 11:27 PM To: u2-users@listserver.u2ug.org Subject: [U2] UV Timed INPUT I'm sure I've seen something about this recently, but I've searched the past 2 years with no luck. I want to do a timed INPUT in UV - if after n seconds the Enter key hasn't been pressed, do something. Anyone got any clever ways of doing this ? Thanks, David Norman Senior Software Engineer - SA Ambulance Service ICT Services SA Health Government of South Australia Box 3, GPO Adelaide, South Australia 5001 *+61 8 8274 0384 * fax +61 8 8271 4844 * norman.da...@saambulance.com.au This e-mail may contain confidential information, which also may be legally privileged. Only the intended recipient(s) may access, use, distribute or copy this e-mail. If this e-mail is received in error, please inform the sender by return e-mail and delete the original. If there are doubts about the validity of this message, please contact the sender by telephone. It is the recipient's responsibility to check the e-mail and any attached files for viruses. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: UV - Error when using WHEN [not-secure]
Colin and Ron are correct! A quick I-descriptor to CONVERT 4A to something else caused proved it. As soon as I read the first mention of MATCHING... I remembered, with a sinking feeling, that LIKE is just a synonym for MATCHING... Thanks again! Mark --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: UV - Error when using WHEN [not-secure]
Use LIKE ...'4A'... to prevent pattern matching -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Hennessey, Mark F. Sent: 03 February 2009 21:03 To: u2-users@listserver.u2ug.org Subject: [U2] RE: UV - Error when using WHEN [not-secure] Apologies - no one has gotten a package from me... important or otherwise! Apparently something in my e-mail triggered our security appliance to lock the message. Sorry! From: Hennessey, Mark F. Sent: Tuesday, February 03, 2009 3:59 PM To: u2-users@listserver.u2ug.org Subject: UV - Error when using WHEN Solaris 10, UV 10.2.2, Information flavor. We are seeing some very odd behavior when trying to use SORT / WHEN on a multi-subvalued field. And by odd behavior I mean totally incorrect output... File Type: Dynamic File Makeup: The file contains associated multivalues and subvalues. Issue: When using the when clause with subvalued Field 7 like '...4a... (DISB LINE column), the only records displayed have PDSB in field 7 no records with 4A are displayed. Here's part of what an unconditional SORT looks like... Notice that OC34.UD.07 (DISB LINE) has values like 'PDSB', 4A. etc. SORT OC34UD.WORK.SP16504 OC34UD.01 OC34UD.02 OC34UD.03 OC34UD.04 OC34UD.06 OC34 UD.07 09:27:25 02-03-09 PAGE 1 LINE. PYEAMT ADD.RPTD.AMT SUB. DISB OC34UD.KEYCDSTO 2a-2h2a-2hLN 2a-2hAMT DISB LINE 14464*19030799*27 10.81REP 10.81 10.81 PDSB 14683*20382253*13 509.00VRC509.00 509.00 PDSB 14811*21191410*115.00VRC 5.005.00 PDSB 14840*21417980*1 22 21.00REP 21.00 21.00 PDSB 14859*21512820*11 142.04VRC142.04 142.04 PDSB 14863*21553328*11 20.00VRC 20.00 20.00 PDSB 14865*700369*1 1 900.00VRC900.00 900.00 PDSB 14869*21548157*17 76.14VRC 76.14 76.14 PDSB 14871*21578431*173.89VRC 3.893.89 PDSB 14877*21601594*17 76.14VRC 76.14 76.14 PDSB 14879*21653295*21 61.002E 61.00 4A 14879*21654502*11 78.002E 26.00 7dF 52.00 4A 14879*21654965*11 232.002E 232.00 4A 14884*21649378*11 379.172E 379.17 4A 14886*21700617*11 432.002E 432.00 4A Now when we try to limit output to just 4A: SORT OC34UD.WORK.SP16504 WHEN OC34UD.07 LIKE ...4A... OC34UD.01 OC34UD.02 OC3 4UD.03 OC34UD.04 OC34UD.05 OC34UD.06 OC34UD.07 09:58:32 02-03-09 PAGE 1 LINE.LINE. PYE AMT ADD. RPTD. AMT SUB. SUBTD DISB OC34UD.KEY CDS TO 2a-2h 2a-2h LN 2a-2h 2a-2h AMT DISB LINE 14464*19030799*2 7 10.81 REP 10.81 2F10.81 PDSB 14683*20382253*1 3509.00 VRC 509.00 2B 509.00 PDSB 14811*21191410*1 1 5.00 VRC5.00 2H 5.00 PDSB 14840*21417980*1 22 21.00 REP 21.00 2C21.00 PDSB 14859*21512820*1 1142.04 VRC 142.04 2F 142.04 PDSB Any ideas/thoughts are welcome... Thanks! Mark --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ - ** The contents of this e-mail are subject to contract in all cases and William Hill PLC, its subsidiaries or affiliates make no contractual commitment save where confirmed by hard copy. The contents of this e-mail do not necessarily represent the views of William Hill PLC, its subsidiaries or affiliates. We accept no liability, including liability for negligence, in respect of any statement in this e-mail. This e-mail and any files transmitted with it are confidential, may be subject to legal privilege and intended solely for the use of the individual or entity to which they are addressed. If you are not the intended recipient, you are hereby notified that any use or dissemination of this communication is strictly prohibited. If you have received this e-mail in error, please notify us immediately, then delete this e-mail. Please note that William Hill can accept no responsibility for viruses and it is your responsibility to scan any emails and their attachments. This message was from William Hill PLC whose registered office is Greenside House, 50 Station Road, Wood Green, London N22 7TP. Company Registration Number: 4212563 England.
Re: [U2] RE: UV - Error when using WHEN [not-secure]
Yes, WHEN can be frustrating. 1st, make sure the multi-valued associated fields are properly defned with M's in field 6, association name in field 7 and, for good measure, create a phrase with said association name as the id of the phrase, and all the associated fields listed in 2. Then add a BY.EXP to the SORT(or other RetrieVe statement) statement, even if you don't care about the sort on the values, sub-values. Just piuck a field to sort by. If you really care about sorting by @IDs do that explicitly as the primary sort, the by.exp sort secondary: LIST OC34UD.WORK.SP16504BY @ID BY.EXP OC34UD.01_ OC34UD.01 OC34UD.02 OC34UD.03 OC34UD.04 OC34UD.06 OC34 I was really looking forward to that package. cds --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: UV - Error when using WHEN [not-secure]
Isn't the ...4A... evaluating to the match string and not the literal? That means it will match anything with 4 alphanumeric chars??? Hth Colin Alfke Calgary, Canada -Original Message- From: Charles Stevenson Yes, WHEN can be frustrating. 1st, make sure the multi-valued associated fields are properly defned with M's in field 6, association name in field 7 and, for good measure, create a phrase with said association name as the id of the phrase, and all the associated fields listed in 2. Then add a BY.EXP to the SORT(or other RetrieVe statement) statement, even if you don't care about the sort on the values, sub-values. Just piuck a field to sort by. If you really care about sorting by @IDs do that explicitly as the primary sort, the by.exp sort secondary: LIST OC34UD.WORK.SP16504BY @ID BY.EXP OC34UD.01_ OC34UD.01 OC34UD.02 OC34UD.03 OC34UD.04 OC34UD.06 OC34 I was really looking forward to that package. cds --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: UV - Error when using WHEN [not-secure]
Remember 4A is a valid match qualifier, to look for 4 alphabetic characters. I experience this sort of behavior and had a real challenge to force it to find the values for which I was looking. Subject: [U2] RE: UV - Error when using WHEN [not-secure] Date: Tue, 3 Feb 2009 16:03:00 -0500 From: mark.hennes...@ct.gov To: u2-users@listserver.u2ug.org Apologies - no one has gotten a package from me... important or otherwise! Apparently something in my e-mail triggered our security appliance to lock the message. Sorry! From: Hennessey, Mark F. Sent: Tuesday, February 03, 2009 3:59 PM To: u2-users@listserver.u2ug.org Subject: UV - Error when using WHEN Solaris 10, UV 10.2.2, Information flavor. We are seeing some very odd behavior when trying to use SORT / WHEN on a multi-subvalued field. And by odd behavior I mean totally incorrect output... File Type: Dynamic File Makeup: The file contains associated multivalues and subvalues. Issue: When using the when clause with subvalued Field 7 like '...4a... (DISB LINE column), the only records displayed have PDSB in field 7 no records with 4A are displayed. Here's part of what an unconditional SORT looks like... Notice that OC34.UD.07 (DISB LINE) has values like 'PDSB', 4A. etc. SORT OC34UD.WORK.SP16504 OC34UD.01 OC34UD.02 OC34UD.03 OC34UD.04 OC34UD.06 OC34 UD.07 09:27:25 02-03-09 PAGE 1 LINE. PYEAMT ADD.RPTD.AMT SUB. DISB OC34UD.KEYCDSTO 2a-2h2a-2hLN 2a-2hAMT DISB LINE 14464*19030799*27 10.81REP 10.81 10.81 PDSB 14683*20382253*13 509.00VRC509.00 509.00 PDSB 14811*21191410*115.00VRC 5.005.00 PDSB 14840*21417980*1 22 21.00REP 21.00 21.00 PDSB 14859*21512820*11 142.04VRC142.04 142.04 PDSB 14863*21553328*11 20.00VRC 20.00 20.00 PDSB 14865*700369*1 1 900.00VRC900.00 900.00 PDSB 14869*21548157*17 76.14VRC 76.14 76.14 PDSB 14871*21578431*173.89VRC 3.893.89 PDSB 14877*21601594*17 76.14VRC 76.14 76.14 PDSB 14879*21653295*21 61.002E 61.00 4A 14879*21654502*11 78.002E 26.00 7dF 52.00 4A 14879*21654965*11 232.002E 232.00 4A 14884*21649378*11 379.172E 379.17 4A 14886*21700617*11 432.002E 432.00 4A Now when we try to limit output to just 4A: SORT OC34UD.WORK.SP16504 WHEN OC34UD.07 LIKE ...4A... OC34UD.01 OC34UD.02 OC3 4UD.03 OC34UD.04 OC34UD.05 OC34UD.06 OC34UD.07 09:58:32 02-03-09 PAGE 1 LINE.LINE. PYE AMT ADD. RPTD. AMT SUB. SUBTD DISB OC34UD.KEY CDS TO 2a-2h 2a-2h LN 2a-2h 2a-2h AMT DISB LINE 14464*19030799*2 7 10.81 REP 10.81 2F10.81 PDSB 14683*20382253*1 3509.00 VRC 509.00 2B 509.00 PDSB 14811*21191410*1 1 5.00 VRC5.00 2H 5.00 PDSB 14840*21417980*1 22 21.00 REP 21.00 2C21.00 PDSB 14859*21512820*1 1142.04 VRC 142.04 2F 142.04 PDSB Any ideas/thoughts are welcome... Thanks! Mark --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ _ Windows Live Hotmail.:more than just e-mail. http://windowslive.com/explore?ocid=TXT_TAGLM_WL_t2_hm_justgotbetter_explore_ 012009 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: UV - Error when using WHEN [not-secure]
Aw shucks, LIST I_Love_it WHEN I.Get.Packages ;-) -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org]on Behalf Of Hennessey, Mark F. Sent: Tuesday, February 03, 2009 1:03 PM To: u2-users@listserver.u2ug.org Subject: [U2] RE: UV - Error when using WHEN [not-secure] Apologies - no one has gotten a package from me... important or otherwise! Apparently something in my e-mail triggered our security appliance to lock the message. Sorry! From: Hennessey, Mark F. Sent: Tuesday, February 03, 2009 3:59 PM To: u2-users@listserver.u2ug.org Subject: UV - Error when using WHEN Solaris 10, UV 10.2.2, Information flavor. We are seeing some very odd behavior when trying to use SORT / WHEN on a multi-subvalued field. And by odd behavior I mean totally incorrect output... File Type: Dynamic File Makeup: The file contains associated multivalues and subvalues. Issue: When using the when clause with subvalued Field 7 like '...4a... (DISB LINE column), the only records displayed have PDSB in field 7 no records with 4A are displayed. Here's part of what an unconditional SORT looks like... Notice that OC34.UD.07 (DISB LINE) has values like 'PDSB', 4A. etc. SORT OC34UD.WORK.SP16504 OC34UD.01 OC34UD.02 OC34UD.03 OC34UD.04 OC34UD.06 OC34 UD.07 09:27:25 02-03-09 PAGE 1 LINE. PYEAMT ADD.RPTD.AMT SUB. DISB OC34UD.KEYCDSTO 2a-2h2a-2hLN 2a-2hAMT DISB LINE 14464*19030799*27 10.81REP 10.81 10.81 PDSB 14683*20382253*13 509.00VRC509.00 509.00 PDSB 14811*21191410*115.00VRC 5.005.00 PDSB 14840*21417980*1 22 21.00REP 21.00 21.00 PDSB 14859*21512820*11 142.04VRC142.04 142.04 PDSB 14863*21553328*11 20.00VRC 20.00 20.00 PDSB 14865*700369*1 1 900.00VRC900.00 900.00 PDSB 14869*21548157*17 76.14VRC 76.14 76.14 PDSB 14871*21578431*173.89VRC 3.893.89 PDSB 14877*21601594*17 76.14VRC 76.14 76.14 PDSB 14879*21653295*21 61.002E 61.00 4A 14879*21654502*11 78.002E 26.00 7dF 52.00 4A 14879*21654965*11 232.002E 232.00 4A 14884*21649378*11 379.172E 379.17 4A 14886*21700617*11 432.002E 432.00 4A Now when we try to limit output to just 4A: SORT OC34UD.WORK.SP16504 WHEN OC34UD.07 LIKE ...4A... OC34UD.01 OC34UD.02 OC3 4UD.03 OC34UD.04 OC34UD.05 OC34UD.06 OC34UD.07 09:58:32 02-03-09 PAGE 1 LINE.LINE. PYE AMT ADD. RPTD. AMT SUB. SUBTD DISB OC34UD.KEY CDS TO 2a-2h 2a-2h LN 2a-2h 2a-2h AMT DISB LINE 14464*19030799*2 7 10.81 REP 10.81 2F10.81 PDSB 14683*20382253*1 3509.00 VRC 509.00 2B 509.00 PDSB 14811*21191410*1 1 5.00 VRC5.00 2H 5.00 PDSB 14840*21417980*1 22 21.00 REP 21.00 2C21.00 PDSB 14859*21512820*1 1142.04 VRC 142.04 2F 142.04 PDSB Any ideas/thoughts are welcome... Thanks! Mark --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: Internal Visage
Oops -- obviously I didn't mean to do that. (NOTE TO SELF: check email address after outlook auto-completes) Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2- us...@listserver.u2ug.org] On Behalf Of Ross Ferris Sent: Tuesday, 20 January 2009 10:17 AM To: Beau Murray Cc: NILWA; Sally Clark; u2-users@listserver.u2ug.org Subject: [U2] RE: Internal Visage Beau, I'm trying to hook into the Virtual Server Manager @ NILWA as I've just had to restart the Linux virtual ` trying to logon as administrator with our usual invisible password with no joy. Created a STAMINA user that I assigned to administrator group ... same story Has anything changed? Is there another user/password I need to be using to get access to this console. Ross Ferris Stamina Software Visage Better by Design! From: Sally Clark [mailto:sallycl...@nilwa.com.au] Sent: Tuesday, 20 January 2009 8:42 AM To: Ryan Hafey; Ross Ferris Cc: NILWA Subject: Internal Visage Hi Guys, We have been experiencing some slow processing speeds this week. No errors till this morning just slow moving. This morning when I opened the BIT viewer to list all cubes I got a pick core dump error (no screen print, I closed out too quick). Could this be related to our slow processing speeds? Cheers Sally Clark IT/HUB Manager Accounts Receivable National Independent Liquor Wholesalers Association Pty Limited Phone: 02 4929 5866 Fax: 02 4929 3622 Mobile: 0438 48 77 99 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] RE: Triggers on a NFS file?
Hi Wol, But, rather more seriously, we have had UV file corruption which was laid pretty conclusively down to two systems accessing the same dynamic file - oh and one of them, allegedly, only had read access! This is an even worse case of what I brought out in my earlier reply. A dynamic file keeps information about its current modulus and load values (etc) in shared memory. Having this on two separate systems is a recipe for disaster. UV introduced the ALLOWNFS configuration option long ago with a default setting of 0 (no). When I deliver UV training, I take great care to emphasise that setting this to 1 (yes) also means it's all my fault if the file gets corrupted. Martin Phillips Ladybridge Systems Ltd 17b Coldstream Lane, Hardingstone, Northampton, NN4 6DB +44-(0)1604-709200 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: spaces in file names
That could be the answer to my question. Tony, you've got to slow down. We all enjoy your posts on this list and you would be missed, but, life is too short, smell some roses. You and I don't know each other personally but I can tell by your writing that you should probably take a vacation instead of paying for a doctor to take one. Jerry Banker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Symeon Breen Sent: Saturday, October 04, 2008 3:35 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] RE: spaces in file names I enjoy Tonys insights, what I dont understand is how he ever finds the time to post such long responses not only in here but in cdp and on his own blog as well -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin King Sent: 04 October 2008 16:47 To: u2-users@listserver.u2ug.org Subject: Re: [U2] RE: spaces in file names Nah, Tony's solid. A bit stressed out - aren't we all? - and amazingly comprehensive in his explanations, but SOLID overall. Then again, not like he needs my endorsement... On Fri, Oct 3, 2008 at 7:59 PM, JPB-U2UG [EMAIL PROTECTED] wrote: Not offensive, I just think he sounds angry in a lot of his emails. He really should watch his blood pressure. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.173 / Virus Database: 270.7.5/1702 - Release Date: 01/10/2008 09:05 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: spaces in file names
Holy cow. Um, thanks for the concern. Now that this thread has gone non-technical, I'll be the first to request its termination. Best, T --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] RE: spaces in file names
Nah, Tony's solid. A bit stressed out - aren't we all? - and amazingly comprehensive in his explanations, but SOLID overall. Then again, not like he needs my endorsement... On Fri, Oct 3, 2008 at 7:59 PM, JPB-U2UG [EMAIL PROTECTED] wrote: Not offensive, I just think he sounds angry in a lot of his emails. He really should watch his blood pressure. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: spaces in file names
I enjoy Tonys insights, what I dont understand is how he ever finds the time to post such long responses not only in here but in cdp and on his own blog as well -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin King Sent: 04 October 2008 16:47 To: u2-users@listserver.u2ug.org Subject: Re: [U2] RE: spaces in file names Nah, Tony's solid. A bit stressed out - aren't we all? - and amazingly comprehensive in his explanations, but SOLID overall. Then again, not like he needs my endorsement... On Fri, Oct 3, 2008 at 7:59 PM, JPB-U2UG [EMAIL PROTECTED] wrote: Not offensive, I just think he sounds angry in a lot of his emails. He really should watch his blood pressure. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.173 / Virus Database: 270.7.5/1702 - Release Date: 01/10/2008 09:05 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: spaces in file names
Do you wake up on the wrong side of the bed every morning? Jerry Banker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tony G Sent: Friday, October 03, 2008 3:59 PM To: u2-users@listserver.u2ug.org Subject: [U2] RE: spaces in file names For reference, Windows still stores path/file names internally in short 8.3 format. Support for long names and additional characters was added in Windows 95 as an abstraction (a view) over that for common usage where non-technical people want to use file names like: J. Jones Budget, 2007-2008 (revised).doc Chelsea smashed! at homecoming '07.jpg Windows was designed to be an operating system for home users and later became a server. (Most people forget that PC stands for Personal Computer.) Macintosh supported long, friendly filenames back in 1984 for the same reasons. Unix is a system for engineers, not intended to be used by people creating OS-level filenames for their docs or pictures. Now, just to be clear, I didn't suggest that DBMS files should be allowed to have spaces in them, like CUSTOMER MASTER. I was giving IBM a little grief for not making use of a file system enhancement which was added to Windows 13 years ago so that we can put IBM programs under Program Files. There's no need for *nix compatibility at this level, commands like uv, udt, UniAdmin, and the UniSDK tools are all platform-specific, OS-level programs, and have nothing to do with the data in the DBMS. It's almost understandable that paths to data may give the DBMS grief if they contain spaces, like: D:\Data Sources\ABC Company\UV\Accounts\WAREHOUSE But even in this case, if ported to *nix anyone would know to move that to something more appropriate like: /home/data/abc_company/uv/acccounts/WAREHOUSE In either case, the DBMS-level file system should abstract the MV DBA from OS-level issues. For example, we should be allowed to create files like the following without OS-related issues: .TEMP OPEN-A/R CUSTMAST*DEPT That said, the CREATE.FILE verb should also prevent the creation of filenames that are commonly agreed as being a bad idea, like CUSTOMER MASTER. As always (like case sensitivity) this whole situation is just another case of engineers who decide not to make changes because they speak Unix and they expect the rest of the world to do so as well. The burden is not on them to make software work for the target OS but on developers to have to know how another OS works so that they understand why their own platform isn't working. That's just lazy and backwards thinking. Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] RE: spaces in file names
jpb-u2ug wrote: Do you wake up on the wrong side of the bed every morning? snip Um, I'm not sure why you found what Tony wrote offensive. I thought it was a reasonable presentation of his point of view. -- Allen Egerton [EMAIL PROTECTED] 860-912-8067 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] RE: spaces in file names
Not offensive, I just think he sounds angry in a lot of his emails. He really should watch his blood pressure. -- From: Allen Egerton [EMAIL PROTECTED] Sent: Friday, October 03, 2008 5:52 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] RE: spaces in file names jpb-u2ug wrote: Do you wake up on the wrong side of the bed every morning? snip Um, I'm not sure why you found what Tony wrote offensive. I thought it was a reasonable presentation of his point of view. -- Allen Egerton [EMAIL PROTECTED] 860-912-8067 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] RE: Ssh connections to Universe DB?
Bob Rasmussen wrote: I'm exploring a possibility, and would like feedback. The problem: administrators want the security that SSH offers, but Universe (and some others) running on Windows offers only telnet access. Possible solution: One possible solution would be to setup a linux PC local to the Universe host running a sshd daemon, and configure your windows ssh client to connect to the linux PC with automatic port forwarding, that would open a standard telnet session thru to the Universe host. This telnet session is then passed automatically back thru the ssh connection to the ssh client. This does require a ssh client that understands port forwarding. I used to setup putty on the windows client to open the ssh tunnel for the windows terminal emulator. Art --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] RE: Ssh connections to Universe DB?
I'm exploring a possibility, and would like feedback. The problem: administrators want the security that SSH offers, but Universe (and some others) running on Windows offers only telnet access. Possible solution: 1) Obtain and run an SSH daemon on the Windows server, such as WinSSHd. 2) Run an SSH client with tunneling capabilities, to connect from a Windows desktop, via SSH, to the WinSSHd on the server. 3) Configure that SSH client to do local port forwarding (tunneling) of some arbitrary port (say, 1234) on the client PC to port 23 (the telnet port) on the server's localhost (that is, the server). 4) Run a (2nd) terminal emulator on the client, connected to the client's localhost, port 1234. The client's SSH receives a connection on its port 1234, and forwards it to the server, causing a connection to the server's port 23, where Universe's telnetd receives it. Connection is made. Because the tunneled connection is within the SSH session, it is authenticated and encrypted. I just tested this scenario using AnzioWin (our terminal emulator/SSH client) and it all appears to work. Is anyone doing this? Does anyone have any thoughts on this? It occurs to me that we could add functionality to AnzioWin to allow telnet over SSH all in one running program. Regards, Bob Rasmussen, President, Rasmussen Software, Inc. personal e-mail: [EMAIL PROTECTED] company e-mail: [EMAIL PROTECTED] voice: (US) 503-624-0360 (9:00-6:00 Pacific Time) fax: (US) 503-624-0760 web: http://www.anzio.com street address: Rasmussen Software, Inc. 10240 SW Nimbus, Suite L9 Portland, OR 97223 USA --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] RE: UNIVERSE on Red Hat?
Hi. We have a lot of clients in linux-boxes, with and without cluster. Most of them are new installations, but others came from Aix, from HP-UX, and even from Windows. No one complaints. The biggest one has 350 users (rpc sessions): CentOS 2.6.9-34.ELsmp on a Xeon 3.40GHz and 5Gb RAM Don't forget to have at least MFILES 400 And make sure your Universe release is high enough to manage 64bit files, or you will be in trouble with your 5Gb file. (Try doing RESIZE TESTFILE 18 101 1 64BIT) Regards, __ Augusto Alonso Alonso I.T. Manager Quiter Servicios Informaticos Tel: +34 902 23 33 23 Fax: +34 902 23 42 80 [EMAIL PROTECTED] www.quiter.com __ - Original Message - From: Doug Chanco [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Friday, September 05, 2008 9:56 PM Subject: [U2] RE: UNIVERSE on Red Hat? Hey all, First off thanks for the responses I have gotten so far! A couple more questions: 1. what kind of systems are you running red hat/universe on (model, specs, etc ) 2. what are you doing for high availability? 3. what are you using for backups (software/type of tape drives)? These questions are for people running universe on red hat enterprise server Thanks again everyone! Dougc From: Doug Chanco Sent: Friday, September 05, 2008 9:36 AM To: 'u2-users@listserver.u2ug.org' Subject: UNIVERSE on Red Hat? Hey all, Does anyone have any experience running universe on red hat in an enterprise environment? I have run UV PE on centos and red hat just fine BUT I am talking about 400+ users, uniobjects, tons of printers, etc .. I would LOVE to hear about enterprise experiences running universe on a red hat system in particular; 1. any gotchas? 2. any praises? 3. any performance issues? 4. any universe/OS issues? 5. any printing issues? 6. any issues with terminals or termdefs/termcaps? 7. uniobject problems? 8. anything else anyone may have run across that I did not mention This is really a question for fitzgerlad/long but what about running FAST on linux? (a wonderful chance for a plug here) :-) Any and ALL experiences/thoughts/whatever are welcomed! IF we move it would be from aix 5.2/universe 10.1 to red hat enterprise server/universe 10.2 on a beefed up dell server Our current setup is about @400 users @40 printers @250 uniobjects connections (from a windows app) Connections from datastage throughout the day @3000 pick databases The biggest being @ 5 gig in size Also while this is not really pick related does anyone have any experience with flash copy on linux/red hat? It allows us to unmount file systems and 'flash copy the data to another area and the remount the file system and then make a backup from the flash copy area. Thanks! Dougc --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: UNIVERSE on Red Hat?
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Doug Chanco Sent: Friday, September 05, 2008 12:56 PM To: u2-users@listserver.u2ug.org Subject: [U2] RE: UNIVERSE on Red Hat? Hey all, First off thanks for the responses I have gotten so far! A couple more questions: 1.what kind of systems are you running red hat/universe on (model, specs, etc ) 2.what are you doing for high availability? 3.what are you using for backups (software/type of tape drives)? We're running UV 10.2.7 on RH ES 5.1. The hardware is a pair of IBM xSeries 3650s with 2GHz CPUs and 15K rpm hard drives configured in a 2-node HA cluster. The HA management software is LifeKeeper from Steeleye. We've been running on this hardware since sometime in April, and prior to that we ran UV 10.1.4 with RH AS 3.0 on a pair of IBM xSeries 345s in the same 2-node HA setup for a little over 3 years. The servers have been running contiuously since the upgrade: 14:58:19 up 139 days, 5:12, 52 users, load average: 0.05, 0.18, 0.17 There is one gotcha with terminal setup if you use ADDS Viewpoint emulation. You'll want to make sure any Viewpoint users have the following entry in their .bash_profile: if tty --quiet; then stty erase '^H' stty susp undef fi Actually, the '^H' backspace fix is needed for any emulation, but without the susp undef setting, Viewpoint terminal sessions with hang if the up-arrow key is pressed. We usually have around 100 terminal users at peak times, and probably average around 30K UniObjects for Java connections per day from our web site. For backups we're currently using a disk-to-disk-to-tape appliance solution from UniTrends. The UniTrends appliance dumps 200GB of UV on-disk backups to a Certance (now Quantum) 8-slot LTO-2 autoloader at the beginning of each month. We also do additional redundant backups before and after our end-of-month batch processing to a 2TB NAS appliance from Aberdeen. I just have a script that uses cp -r at the OS level to copy to an NFS mount for those. -John --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: U2UG Board Meeting
Yes, that would be nice BUT! Ordinary members would be observers, and that's quite difficult to enforce on a conference call. What would be best if the call could be streamed so that anyone could listen in, but (unless it's changed) the calls are courtesy of IBM on IBM's equipment, and I don't know whether the equipment the board are using even has that capability. Cheers, Wol (ex board member) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill Sent: 28 August 2008 19:12 To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] RE: U2UG Board Meeting Consider opening these conference calls up to ordinary U2UG members. --Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: U2UG Board Meeting
Consider opening these conference calls up to ordinary U2UG members. --Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Re: U2 Users Digest V1 #2326
That makes perfect sense. I am only handling UniSessionException and UniSubroutineException in the routine. If I am understanding correctly, I should add a catchall exception. Sort of a KitchenSinkException to account for other exceptions. Thanks a lot. Charles Shaffer Senior Analyst NTN-Bower Corporation David Beahm [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/18/2008 09:29 PM Please respond to u2-users To: u2-users@listserver.u2ug.org cc: Subject:[U2] Re: U2 Users Digest V1 #2326 Charles- As I read it, the unhandled exception is happening within the U2 object when you are trying to execute the Java method PbrGetMgrList. I never heard of JavaBridge before, but after reading the requirements at http://php-java-bridge.sourceforge.net/doc/overview.php, I don't think that is the source of the problem (java.inc is a PHP include file, and might be referenced through a URL such as |once(http://localhost:9090/JavaBridge/java/Java.inc;);|). You can verify that the JavaBridge is working by calling a Java method outside of the U2 object prior to calling the PbrGetMgrList method; if it works, then something is happening to your U2 object. I don't have enough to troubleshoot any further at this point. HTH, David Beahm Date: Fri, 15 Aug 2008 11:23:41 -0500 From: [EMAIL PROTECTED] Subject: [U2] Uniobjects for Java Hello, I am accessing our Unidata server from PHP using the java bridge for a few months It has been working pretty well up until the current project I am working on. PHP calls a method in a U2 object, which uses Uniobjects for Java to invoke a UniBasic Subroutine on our Unidata 7.1 redhat based server. Recently I have intermittently received the following error message. ** Fatal error: Uncaught [[o:Exception]:java.lang.Exception: Invoke failed: [[o:U2]]-PbrGetMgrList. Cause: java.lang.NoSuchMethodException: PbrGetMgrList(). Candidates: [] Responsible VM: [EMAIL PROTECTED]://java.sun.com/ at: #-5 php.java.bridge.JavaBridge.Invoke(JavaBridge.java:1045) #-4 php.java.bridge.Request.handleRequest(Request.java:405) #-3 php.java.bridge.Request.handleRequests(Request.java:481) #0 java.inc(257): java_ThrowExceptionProxyFactory-getProxy(52, '@N', true) #1 java.inc(473): java_Arg-getResult(true) #2 java.inc(479): java_Client-getWrappedResult(true) #3 java.inc(672): java_Client-getResult() #4 java.inc(1786): java_Client-invokeMethod(51, 'PbrGetMgrList', Array) #5 java.inc(1910): java_JavaProxy-__call('PbrGetMgrList', Array) #6 java.inc(2072): java_AbstractJava-__call('PbrGetMgrList', Array) #7 [internal function]: Java-__call('PbrGetMgrList', Array) #8 /var/www/pbr/pbr.php(14): Java-PbrGetMgrList() #9 {main}] thrown in java.inc on line 220 I am not sure what this is referring to. I don't find a java.inc anywhere on the web server host. This works most of the time, but sometimes not. and I don't see a pattern. Most of the time it can be fixed by recompiling and rejarring the Java object, but that doesn't always fix it. One thing I wondered about is that this is the first time that I have called a program with no input parameters. Here is the java code. /** * @param none * @return Tab delimited list of MGR_NAMES */ public String PbrGetMgrList() { String result = ; try { OpenU2Session(); UniSubroutine uSub = uSession.subroutine(PbrGetMgrList, 1); uSub.call(); result = uSub.getArg(0); CloseU2Session(); } catch (UniSessionException e) { result = N; } catch (UniSubroutineException e) { result = N; } finally { return result; } } Here is the UniBassic Subroutine code $BASICTYPE 'U' SUBROUTINE PbrGetMgrList(RESULT) * Tab delimits data items EQU HTABTO CHAR(9) * Select records for this supervisor RESULT = 'N' ECMD = SELECT MGRACCT.DATA SAVING UNIQUE NAME EXECUTE ECMD IF @SYSTEM.RETURN.CODE = 0 THEN RETURN *** * Build the list *** RESULT = '' FIRST = 1 LOOP READNEXT ID ELSE ID = '' UNTIL ID = '' * Insert a delimiter unless this is the first record IF FIRST = 0 THEN RESULT := HTAB END ELSE FIRST = 0 END * ADD THE ID RESULT := ID REPEAT
RE: [U2] RE: TCL literal select
Hi, I ended up using this from Martin C. (of Epicor fame). I don't know why none of the TCL examples would work for me. Something to do with Unidata 5.2 and my particular flavor I guess. Thanks to you all a Virtual Field type dictionary using the INDEX function... i.e. 001: V 002: INDEX(F1,'',1) 003: 004: 005: 6L 006: S -Original Message- From: Anthony Youngman [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 13, 2008 7:08 AM To: 'u2-users@listserver.u2ug.org' Subject: [U2] RE: TCL literal select Ooops ... COUNT, not DCOUNT Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman Sent: 13 August 2008 12:01 To: 'u2-users@listserver.u2ug.org' Subject: [U2] RE: TCL literal select Rather than writing a simple program ... SELECT PARTS WITH EVAL DCOUNT(F1, '') GT 0 Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Israel, John R. Sent: 12 August 2008 21:59 To: 'u2-users@listserver.u2ug.org' Subject: [U2] RE: TCL literal select I tried using the lower case SELECT/LIST to use native UniData syntax, and that did not work. Try writing a simple program to convert the double quotes to something else (like a tilda) then search the I-desc for that. ED BP TILDA SUBROUTINE TILDA(RTN.VAL, ORIG.VAL) RTN.VAL = CONVERT(ORIG.VAL, '', '~') RETURN ED DICT PARTS F1.TILDA I SUBR(TILDA, F1) ... SELECT PARTS WITH F1.TILDA = [~] John Israel Sr. Programmer/Analyst Dayton Superior Corporation 721 Richard St. Dayton, OH 45342 937-866-0711 x44380 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bruce Ordway Sent: Tuesday, August 12, 2008 4:00 PM To: u2-users@listserver.u2ug.org Subject: [U2] TCL literal select Hi, I work with a Unidata/Dataflo system on HPUX. I am having trouble selecting records in my PARTS file. I want to select all parts that have a in the description field (F1). People have been using instead of INCH. This causes problems for me during processing some reports and exports. I have tried quite a few select statements with no success. LIST PARTS WITH F1 = [//] LIST PARTS WITH F1 = // LIST PARTS WITH F1 = /''/ LIST PARTS WITH F1 = [''] LIST PARTS WITH F1 = '' LIST PARTS WITH F1 = /''/ LIST PARTS WITH F1 = \[]\ LIST PARTS WITH F1 = [\\] LIST PARTS WITH F1 = '' Wildcards on my system are brackets, [ leading and ] following Any ideas on what would work? Somebody showed me once, so I know it can be done. I lost my notes though. Thanks, Bruce Ordway Viking Engineering Development Inc. 5750 Main St. N.E. Fridley, MN 55432 Visit us at www.Vikingeng.com This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ Viking Engineering Development Inc. 5750 Main St. N.E. Fridley, MN 55432 Visit us at www.Vikingeng.com This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: TCL literal select
Bruce: I think it's UD specifically (even D3 works with a number of the suggestions). UD is very finicky with AQL and drives almost ALL PICK people crazy, and many who work both UD and something else concurrently. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Bruce Ordway Sent: Wednesday, August 13, 2008 8:26 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] RE: TCL literal select Hi, I ended up using this from Martin C. (of Epicor fame). I don't know why none of the TCL examples would work for me. Something to do with Unidata 5.2 and my particular flavor I guess. Thanks to you all a Virtual Field type dictionary using the INDEX function... i.e. 001: V 002: INDEX(F1,'',1) 003: 004: 005: 6L 006: S -Original Message- From: Anthony Youngman [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 13, 2008 7:08 AM To: 'u2-users@listserver.u2ug.org' Subject: [U2] RE: TCL literal select Ooops ... COUNT, not DCOUNT Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman Sent: 13 August 2008 12:01 To: 'u2-users@listserver.u2ug.org' Subject: [U2] RE: TCL literal select Rather than writing a simple program ... SELECT PARTS WITH EVAL DCOUNT(F1, '') GT 0 Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Israel, John R. Sent: 12 August 2008 21:59 To: 'u2-users@listserver.u2ug.org' Subject: [U2] RE: TCL literal select I tried using the lower case SELECT/LIST to use native UniData syntax, and that did not work. Try writing a simple program to convert the double quotes to something else (like a tilda) then search the I-desc for that. ED BP TILDA SUBROUTINE TILDA(RTN.VAL, ORIG.VAL) RTN.VAL = CONVERT(ORIG.VAL, '', '~') RETURN ED DICT PARTS F1.TILDA I SUBR(TILDA, F1) ... SELECT PARTS WITH F1.TILDA = [~] John Israel Sr. Programmer/Analyst Dayton Superior Corporation 721 Richard St. Dayton, OH 45342 937-866-0711 x44380 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bruce Ordway Sent: Tuesday, August 12, 2008 4:00 PM To: u2-users@listserver.u2ug.org Subject: [U2] TCL literal select Hi, I work with a Unidata/Dataflo system on HPUX. I am having trouble selecting records in my PARTS file. I want to select all parts that have a in the description field (F1). People have been using instead of INCH. This causes problems for me during processing some reports and exports. I have tried quite a few select statements with no success. LIST PARTS WITH F1 = [//] LIST PARTS WITH F1 = // LIST PARTS WITH F1 = /''/ LIST PARTS WITH F1 = [''] LIST PARTS WITH F1 = '' LIST PARTS WITH F1 = /''/ LIST PARTS WITH F1 = \[]\ LIST PARTS WITH F1 = [\\] LIST PARTS WITH F1 = '' Wildcards on my system are brackets, [ leading and ] following Any ideas on what would work? Somebody showed me once, so I know it can be done. I lost my notes though. Thanks, Bruce Ordway Viking Engineering Development Inc. 5750 Main St. N.E. Fridley, MN 55432 Visit us at www.Vikingeng.com This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ Viking Engineering Development Inc. 5750 Main St. N.E. Fridley, MN 55432 Visit us at www.Vikingeng.com This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions
Re: [U2] RE: SELECT problem with quote characters
In message [EMAIL PROTECTED], Israel, John R. [EMAIL PROTECTED] writes You need the double quotes on the outside of the ... SELECT FILE WITH FIELD LIKE ...LLOYD'S... Alternatively, you can often get away with no quotes. Loosely speaking, you only NEED quotes on the outside if you have spaces in your search string, though if you have a single quote in your search string, that would likely confuse it. The problem is, this is a program constructing a select string. I have no control over what the user types in, and I want to do a literal match. What if they enter something like 6A'S? Basically, I need to quote the search string to get a literal match, which means I need to put quotes outside the dots, which means I need to use all three different quote characters, which then doesn't work :-( Cheers, Wol -- Anthony W. Youngman [EMAIL PROTECTED] 'Yings, yow graley yin! Suz ae rikt dheu,' said the blue man, taking the thimble. 'What *is* he?' said Magrat. 'They're gnomes,' said Nanny. The man lowered the thimble. 'Pictsies!' Carpe Jugulum, Terry Pratchett 1998 Visit the MaVerick web-site - http://www.maverick-dbms.org Open Source Pick --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: SELECT problem with quote characters
OK - I see the problem. True, it will not work the way it is, but there might be a work around. If the string we are looking for could contain both single and double quotes, we are out of luck with the standard way of searching. However, we could write a simple I-desc that calls a program which would return a value where the quotes are replaces with some odd character (like a tilda or some non-printing character). Then have the program tweaked to select on the I-desc looking for these odd characters. For example: Raw data = LLOYD'S I-desc = LLOYD~S Now, instead of: SELECT FILE WITH FIELD LIKE ...LLOYD'S... We would do: SELECT FILE WITH I-desc LIKE ...LLOYD~S... This is not as fancy as you would likely need, but it shows the concept of something that should work. I have also had situations where I needed to determine a non-standard delimiter. To do this, I would build a string of potential characters like: DELIMITERS = [EMAIL PROTECTED]*()_+{}[]\|:;? I would then loop through each of the characters in DELIMITER attempting to find a character that was NOT found in the target string. Once I find one, that character is stored in some fashion and used to encrypt/decrypt as needed. Hopefully, between these two ideas you can get pointed in a useful direction. John Israel Sr. Programmer/Analyst Dayton Superior Corporation 721 Richard St. Dayton, OH 45342 937-866-0711 x44380 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony W. Youngman Sent: Wednesday, August 06, 2008 7:26 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] RE: SELECT problem with quote characters In message [EMAIL PROTECTED], Israel, John R. [EMAIL PROTECTED] writes You need the double quotes on the outside of the ... SELECT FILE WITH FIELD LIKE ...LLOYD'S... Alternatively, you can often get away with no quotes. Loosely speaking, you only NEED quotes on the outside if you have spaces in your search string, though if you have a single quote in your search string, that would likely confuse it. The problem is, this is a program constructing a select string. I have no control over what the user types in, and I want to do a literal match. What if they enter something like 6A'S? Basically, I need to quote the search string to get a literal match, which means I need to put quotes outside the dots, which means I need to use all three different quote characters, which then doesn't work :-( Cheers, Wol -- Anthony W. Youngman [EMAIL PROTECTED] 'Yings, yow graley yin! Suz ae rikt dheu,' said the blue man, taking the thimble. 'What *is* he?' said Magrat. 'They're gnomes,' said Nanny. The man lowered the thimble. 'Pictsies!' Carpe Jugulum, Terry Pratchett 1998 Visit the MaVerick web-site - http://www.maverick-dbms.org Open Source Pick --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: English phrases
No, they don't... PA LIST MASTER _ BY ATTR1 _ BREAK.ON ATTR1 _ ATTR2 _ TOTAL ATTR3 _ HEADING this is the best heading you ever saw 'D'PAGE 'PLL' _ ID.SUP _ DET.SUP _ LPTR Works a bomb! (provided of course you have a file called MASTER with dict items ATTR1, ATTR2, ATTR3, AND ATTR3 is numeric ;-) Oh, yeah - put a space before each '_' -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Boyd Parks Sent: 24 July 2008 07:34 PM To: u2-users@listserver.u2ug.org Subject: [U2] RE: English phrases Sorry to bother - I have found that on Universe , all the definitions have to be listed on attribute 2 instead of being in subsequent attributes as we can do on our jBASE system. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: English phrases
You can use the underscore at the end of attributes 2 to 9 to indicate continuation on Universe. Laure Hansen, City of Redwood City - Information Technology 1017 Middlefield Road - Redwood City, CA 94063 Office 650-780-7087 - Cell 650-207-3235 - Fax 650-556-9204 [EMAIL PROTECTED] o Please think green before printing this e-mail Subscribe to receive Redwood City E-News, news releases, or other documents via email: Click here to register/subscribe -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Boyd Parks Sent: Thursday, July 24, 2008 10:34 AM To: u2-users@listserver.u2ug.org Subject: [U2] RE: English phrases Sorry to bother - I have found that on Universe , all the definitions have to be listed on attribute 2 instead of being in subsequent attributes as we can do on our jBASE system. Boyd -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Boyd Parks Sent: Thursday, July 24, 2008 12:21 PM To: u2-users@listserver.u2ug.org Subject: [U2] English phrases I am trying to use the same phrase in Universe as I use in jBASE, but it is not working properly on our Universe systems. The beginning of my definitions on both jBASE and Universe look like this: ED DICT DH CA.ATTRS DICT DH CA.ATTRS (BACS) Top .P 001 PH 002 PHONE-CHECK 003 COLL.SCORE 004 CA.AVAILCR 005 SSN.DECEASED 006 SSN.DOD 007 292 008 CA.BK7 009 CA.BK11 010 CA.BK13 The problem with the phrase is that it only lists the first definition in the phrase. I just tested by removing PHONE-CHECK (it is a Basic subroutine call, whereas all the others are normal, local definitions), but that is not the issue. Here is the output: LIST DH 6793700 CA.ATTRS 10:36:09am 18 Jul 2008 PAGE1 DEBHIST... COLLECTABILITY 6793700 592 1 records listed. Many more attributes should have been listed. Any ideas? Boyd Parks HOV Services CUBS Software Engineering O: 678-229-5002 C: 770-975-3303 Any technology distinguishable from magic is insufficiently advanced. --Larry Niven's Corollary to Clarke's 3rd Law. [cid:image001.jpg@01C8ED87.ACA82E10] The information contained in this message, including any attachments, is privileged and/or confidential information intended only for the use of the individual or entity named as addressee. The review, dissemination, distribution, or copying of this communication by or to anyone other than the intended addressee is strictly prohibited. If you have received this communication in error, please immediately notify the sender by replying to the message and destroy all copies of the original message The information contained in this message, including any attachments, is attorney privileged and/or confidential information intended only for the use of the individual or entity named as addressee. The review, dissemination, distribution or copying of this communication by or to anyone other than the intended addressee is strictly prohibited. If you have received this communication in error, please immediately notify the sender by replying to the message and destroy all copies of the original message. [demime 1.01d removed an attachment of type image/jpeg which had a name of image001.jpg] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this message, including any attachments, is attorney privileged and/or confidential information intended only for the use of the individual or entity named as addressee. The review, dissemination, distribution or copying of this communication by or to anyone other than the intended addressee is strictly prohibited. If you have received this communication in error, please immediately notify the sender by replying to the message and destroy all copies of the original message. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Re: Going to U2 University 2008?
One of Janet Oswald's email ad broadcasts for U2U indicated that there would be pre-conference chargeable tutorials the day before each of the 4 editions of the conference. The list of tutorials and their charges are not yet on the web-site, but she tells me they should be there tomorrow. These tutorials have been worthwhile in years past. I'm holding off on registering for San Diego until I can see those. I think the regional conference idea is a good one. I attended the San Francisco one 2 prior pan-IBM ones, as well as others off and on dating back to Infocus/VMark days. Pluses: + Cheaper. + Shorter. 2 nights lodging only. + More targeted. (That 2006 Anaheim Information on Demand event for all IBM software users was ghastly. Sure, we got to see Gladys Knight and the Pips and got in free one night to part of Disneyland where the music blared that you couldn't network (the primary purpose for the social events), provided you could even find any fellow U2 users amid the AIX, Tivoli, DB2, etc. users, almost half of whom seemed to be IBM employees.) + If you attend the later venues, the presenters have honed their show a bit. + The audience seemed a bit more technical last year. I'm guessing the lower price shorter time span allowed companies to send technical people other than the mucky-mucks who see these conferences like junkets. + More content, less junket. Minuses: - You don't see some users from other parts of the world. I miss that. - Almost all sessions are presented by IBM staff, since not many independent presenters want to commit to 4 such events. I have always appreciated the presentations by users independent consultant groups, myself, so I miss that. - More content, less junket. (Some people will see that as a minus, anyway.) cds P.S. Pardon me if some of this has already been discussed. I've been unsubscribed for a month long vacation. -Original Message- From: Louie Bergsagel Ah, found the U2 University session abstracts: http://www-306.ibm.com/software/info/u2/university/index3.jsp --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Re: Going to U2 University 2008?
Unfortunately I'll be in the wrong part of the planet for all four sessions. I note that the fourth session (in England) clashes directly with Information on Demand 2008 (which is where I will be that particular week). --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Re: Going to U2 University 2008?
This is only the second year for U2U. Before that they were part of the general IBM yearly conferences. They decided that U2 had enough of a specialized and enthusiastic following that they could have conferences in multiple areas of the world. Jerry Banker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Louie Bergsagel Sent: Wednesday, July 16, 2008 12:25 PM To: u2-users@listserver.u2ug.org Subject: [U2] Re: Going to U2 University 2008? Ah, found the U2 University session abstracts: http://www-306.ibm.com/software/info/u2/university/index3.jsp --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: ODBC problems
Is it the same query for both files/tables (that share the same dictionary)? Do both your queries work from a different client PC? If so, is there different client software versions or ODBC clients? Regards, david -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman Sent: Tuesday, July 01, 2008 12:01 AM To: 'u2-users@listserver.u2ug.org' Subject: [U2] RE: ODBC problems What's odd is it looks like it's the PC end getting the query wrong before it sends it, but I've got two files sharing the same physical dictionary file and one works while the other one doesn't ... which implies a data problem ... cue headscratching here ... --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: ODBC problems
What I did was link to the table in Access, open it, and then click on a column to sort it. So it should have been an identical query. I thought I'd test it - get Dr Dee Bee Spy to monitor me doing it on the table that worked - and guess what! That table won't sort now, either! I thought that would give some credence to David Jordan's idea of the temp space, but there's masses of free disk space both on my pc and the server. And I don't see how it could be permissions, seeing as it works sometimes and not others. As for different client software etc, we're having problems on at least two pcs. The one we first noticed it on is running Office (Access) 2007, and my pc is running Office (Access) 2003. The ODBC software is identical - installed from a 10.2 client CD. Probably (but not definitely) the same CD. Thing is, we really need to know what's causing it so we can definitely avoid the problem - we don't want to install this on our customer's site and then have them go down with this problem... Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Hona, David S Sent: 01 July 2008 06:37 To: u2-users@listserver.u2ug.org Subject: RE: [U2] RE: ODBC problems Is it the same query for both files/tables (that share the same dictionary)? Do both your queries work from a different client PC? If so, is there different client software versions or ODBC clients? Regards, david -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman Sent: Tuesday, July 01, 2008 12:01 AM To: 'u2-users@listserver.u2ug.org' Subject: [U2] RE: ODBC problems What's odd is it looks like it's the PC end getting the query wrong before it sends it, but I've got two files sharing the same physical dictionary file and one works while the other one doesn't ... which implies a data problem ... cue headscratching here ... --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: ODBC problems
Which U2 and os -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman Sent: Tuesday, July 01, 2008 1:27 AM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] RE: ODBC problems What I did was link to the table in Access, open it, and then click on a column to sort it. So it should have been an identical query. I thought I'd test it - get Dr Dee Bee Spy to monitor me doing it on the table that worked - and guess what! That table won't sort now, either! I thought that would give some credence to David Jordan's idea of the temp space, but there's masses of free disk space both on my pc and the server. And I don't see how it could be permissions, seeing as it works sometimes and not others. As for different client software etc, we're having problems on at least two pcs. The one we first noticed it on is running Office (Access) 2007, and my pc is running Office (Access) 2003. The ODBC software is identical - installed from a 10.2 client CD. Probably (but not definitely) the same CD. Thing is, we really need to know what's causing it so we can definitely avoid the problem - we don't want to install this on our customer's site and then have them go down with this problem... Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Hona, David S Sent: 01 July 2008 06:37 To: u2-users@listserver.u2ug.org Subject: RE: [U2] RE: ODBC problems Is it the same query for both files/tables (that share the same dictionary)? Do both your queries work from a different client PC? If so, is there different client software versions or ODBC clients? Regards, david -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman Sent: Tuesday, July 01, 2008 12:01 AM To: 'u2-users@listserver.u2ug.org' Subject: [U2] RE: ODBC problems What's odd is it looks like it's the PC end getting the query wrong before it sends it, but I've got two files sharing the same physical dictionary file and one works while the other one doesn't ... which implies a data problem ... cue headscratching here ... --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: ODBC problems
Hi Anthony It may be an issue with permissions for the temp directory where the sort is occurring, whether on the PC or the server. Regards David Jordan --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Re: ODBC Connection Hanging Around
Kevin, It sounds as though the server is seeing the disconnects, but the client is not getting the response back to recognize that it is truly disconnected. Therefore the object is waiting on a response. I am not sure if the driver is thread safe, but I would not count on it. I might suggest putting all your communications code in a separate module and subroutine. Also don't wait on the response since it seems like the closing is actually happening. Make all the object variables local to that module/subroutine so that when that routine exits they will fall out of scope and should get cleaned up. Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.454.8392 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively. The more they complicate the plumbing the easier it is to stop up the drain - Montgomery Scott NCC-1701 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Re: ODBC Connection Hanging Around
The client terminates fine. It's the server session that doesn't disconnect. And in a weird twist that I'm still watching, I added a generic CLOSE statement to close all the files being used by the subroutine before it returns to the caller and since making that change the server has not left any connections open. But like I said, I'm still watching this to see if this was the silver bullet or merely a coincidence. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Re: ODBC Connection Hanging Around
Well, the CLOSE appears to have been a red herring. Everything ran fine for several hours, then all at once a half dozen sessions didn't get disconnected. And again it appears to have been when there were a lot of simultaneous sessions. I'm leaning more and more to a threading issue with the Unidata ODBC driver. On Wed, May 28, 2008 at 8:15 AM, Kevin King [EMAIL PROTECTED] wrote: The client terminates fine. It's the server session that doesn't disconnect. And in a weird twist that I'm still watching, I added a generic CLOSE statement to close all the files being used by the subroutine before it returns to the caller and since making that change the server has not left any connections open. But like I said, I'm still watching this to see if this was the silver bullet or merely a coincidence. -- -Kevin http://www.PrecisOnline.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Re: ODBC Connection Hanging Around
Idea/Suggestion: Take a look at DOS CMD / Unix CMD netstat -an output on the Server. If you see a significant amount of sockets in TIME_WAIT state, you may need to add the TcpTimedWaitDelay parameter to the Registry, (for Windows). There are ways to modify this in various Unix platforms - you'll need to dig out the particulars for your 'nix variant. A lot of applications will call/open a socket, send data, then close the socket, rather than re-use, and then call a new socket next time. When next connection is opened, or a lot of connections are opened, perhaps the Server does not have the free resources to clean up these connection/sockets that are lingering around, as the OS is designed to perform such clean up in the background when it has the capacity to do so. Busy Servers may not be able to free up these resources as fast as they're being called/used. (This behavior exists across all Windows and Unix platforms). For Windows, you can add a Registry setting called TcpTimedWaitDelay which does not exist by default, but it does use a default parameter, (240 I believe). which may be way too long for many/most applications, especially if applications do not re-use alread opened socket/ports. By adding this parameter as specificed in the MS TechNote, and setting its value to 30 decimal (i.e. 30 seconds), this will help free up significant amounts of ports stuck in TIME_WAIT state in a significantly faster manner, proving in more smooth server network operations and sockets availabilty. http://technet2.microsoft.com/windowsserver/en/library/38b8bf76-b7d3-473c-84e 8-e657c0c619d11033.mspx?mfr=true I have seen this behavior numerous times, across numerous applications and across numerous platforms, verticals, etc... I hope this helps. Regards, Scott Richardson Senior Systems Engineer / Consultant Sr. Product Support Engineer Marlborough, MA 01752 Email: CheetahFTLat comcast.net DPMonitor - http://www.deltek.us - Original Message - From: Kevin King [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, May 28, 2008 12:07 PM Subject: Re: [U2] Re: ODBC Connection Hanging Around Well, the CLOSE appears to have been a red herring. Everything ran fine for several hours, then all at once a half dozen sessions didn't get disconnected. And again it appears to have been when there were a lot of simultaneous sessions. I'm leaning more and more to a threading issue with the Unidata ODBC driver. On Wed, May 28, 2008 at 8:15 AM, Kevin King [EMAIL PROTECTED] wrote: The client terminates fine. It's the server session that doesn't disconnect. And in a weird twist that I'm still watching, I added a generic CLOSE statement to close all the files being used by the subroutine before it returns to the caller and since making that change the server has not left any connections open. But like I said, I'm still watching this to see if this was the silver bullet or merely a coincidence. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: U2 - SQL Server ODBC Connection via Universe[AD]
Since this is an Ad sub-thread and recent topics ask related questions, I'll add two points: 1) Nebula Research and Development has partnered with a large global company that specializes in providing end-to-end Business Intelligence solutions. We're days away from posting information on our website about our new offerings. Our goal is to facilitate the choice and implementation of common mainstream BI tools (including Cognos and Business Objects) for use with MV applications. You read it here first... 2) mv.NET is capable of moving data back and forth between U2 and relational environments via .NET DataSets. For all of these questions involving data exchanges with relational environments, mv.NET is worthy of consideration. I've written a bit on MV/relational exchanges in my blog: remove.pleaseNebula-RnD.com/blog See: MV and Relational Data Exchanges Part 1 and: Cross-MV development made easy.er Those and some other articles should provide some insight, search for sql, relational, and other keywords if you wish. I'll post a note on the blog in a couple days when the BI info is up. HTH Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com Nebula RD sells mv.NET and DesignBais worldwide, and provides related development and training services -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Robert Houben Robert.Houben-at-fusionware.net |U2UG3| Sent: Thursday, May 08, 2008 10:39 AM To: ... Subject: [U2] RE: U2 - SQL Server ODBC Connection via Universe[AD] We have a product that uses JDBC to connect to SQL Server (various flavors - we've had to do both 2000 and 2005). It allows you to call subroutines that mimic the functionality of WRITE, READ, COPY and other commands to let you read/write single valued data to/from SQL Server, Oracle and others. Feel free to contact us at [EMAIL PROTECTED] for more info.[/AD] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Caminiti, Marc Sent: Thursday, May 08, 2008 10:20 AM To: u2-users@listserver.u2ug.org Subject: [U2] U2 - SQL Server ODBC Connection via Universe Has anyone had success in setting up a ODBC connection from Universe to MS SQL Server 2005? We are needing to get data imported into SQL Server and I was hoping that there is an easy way for UniVerse to connect to the database and do the inserts on its own. Universe 10.0.9 running on Red Hat 7.3 Thanks in advance Marc Marc Caminiti IS Manager Nashbar Direct, Inc 6103 State Route 446 Canfield, OH 44406 330.533.1989, ext 336 330.702.9733, fax Obey gravity, It's the law! --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Re: Damaged files
What's the error message? What commands get you the error (analyze.file doesn't, so it's not completely hosed). Generally, a broken file occurs when one of two things occur (these are just the most frequent; there are other ways): a write to overflow (and you got overflow!) begins, writes the forward link, then doesn't complete in writing the backward link (blink error). Perhaps it got distracted by a particularly fetching barista g. Looking at errpt is a good idea for you; if there's a hardware problem causing it, you wanna catch it asap. This is one reason we like to avoid overflow: your risk of breaking a file increases with each link to overflow created. The second most likely cause is when something else is writing to your file; maybe there are uv jobs running out of cron that update something, but aren't in phantom you use commons to open files. Perhaps there is some sequential write occurring to the file. Anyway, start by resizing that to reduce the overflow therefore your risk. I'd at least double the mod, and at a rough pass, I'd say 2.5 times that mod would be a good guess - I often find that a well-sized file will have physical bytes to data bytes in a 2:1 ratio. The mod*sep*512 on this file is about 6g. Date: Fri, 11 Apr 2008 11:14:37 -0700 From: [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Subject: [U2] Re: Damaged files I'm sure someone will ask, so here is the FILE.STAT of our damaged file: FILE.STAT ... File name = [removed] File type = 18 Number of groups in file (modulo) = 1464863 Separation = 8 Number of records = 4494202 Number of physical bytes = 11519762432 Number of data bytes = 8015319848 Average number of records per group = 3.0680 Average number of bytes per group = 5471.7198 Minimum number of records in a group = 0 Maximum number of records in a group = 8 Average number of bytes per record = 1783.4801 Minimum number of bytes in a record = 32 Maximum number of bytes in a record = 3138752 Average number of fields per record = 146.2144 Minimum number of fields per record = 1 Maximum number of fields per record = 5707 Groups 25% 50% 75% 100% 125% 150% 175% 200% full 72507 139475 227723 274491 215462 150922 103011 281272 -- Louie --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ _ Going green? See the top 12 foods to eat organic. http://green.msn.com/galleries/photos/photos.aspx?gid=164ocid=T003MSN51N1653 A --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: UNIDATA 7.1 performance measures
Some Anti-Virus software still hogs your system even if you disable it - you need to *REMOVE*. Feel free to email me directly me for names and pack drill offline (not wanting to offend the guilty etc). If in doubt: remove and reboot. If the problem goes away then job done.. Regards JayJay -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Smith, Robert Sent: 31 March 2008 14:46 To: u2-users@listserver.u2ug.org Subject: RE: [U2] RE: UNIDATA 7.1 performance measures Good Morning John, Our Network Manager asked why you recommended removing the anti-virus software vs. disabling them. Could/would you please share your rationale for making that recommendation? The feedback I am getting as a result of this posting has been incredibly helpful. Rob Smith Philadelphia University -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Jenkins Sent: Saturday, March 29, 2008 8:29 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] RE: UNIDATA 7.1 performance measures Ibd start by looking for specific bottlenecks. Itbs too easy to see one of the system constraints and assume that's your bottleneck (been there). Run some mete As others have said, see a specific bottleneck first then take it from there. Some suggestions on things to look at in Windows and hardware - I'm assuming all the usual has been done inside UniData itself. __ Anti-Virus software killing you? REMOVE it first for the avoidance of doubt - then decide. Donbt just reconfigure or disable - REMOVE. Tweak afterwards - know whether itbs worth tweaking first. Paging (yes/no/how much)? Disk performance *read *write *wait I/O Are you using RAID? Should be 0+1, try and avoid RAID 5 Use hardware RAID not software Turn off read-ahead, optimise for random, not sequential Steps vary for different SANS (Hitachi / Veritas / Shark etc). If using an external SAN: * has the memory battery failed? (turns off write caching - a killer) Put paging space on a separate disk, and UniData TMP also. * Do you have remote mirroring on the SAM turned on (requiring remote commit on writes can be a killer). _ If 3Gb is does turn out to be an issue consider Unix, much better memory management. Linux on your x86 platform seems the logical move (same hardware). You also get better CPU resource usage on Unix then Windows. Memory could be a bottleneck for you, but Ibd be surprised. The usual memory related issues I see on Windows (or Unix come to that) are due to file import/export programs READING and WRITING truly enormous text files from the O/S file structures. READSEQ and WRITESEQ are the cure there/ Regards JayJay From: Smith, Robert Sent: Thursday, March 27, 2008 11:37 AM To: u2-users@listserver.u2ug.org Subject: UNIDATA 7.1 performance measures Good Morning, We are a UNIDATA shop and presently we are struggling with identifying the best way to increase the performance level of our environment. We presently are running UD on a Windows Enterprise server (SP2) with 16gig of ram and 8 - 3gig processors. We have read through some MS Knowledge Base articles that suggest a possible performance increase if we use the /PAE and /3GB boot.ini switches. We were wondering whether anyone has deployed these settings before and if there were any problems that resulted...with either the OS or database. Does anyone have any suggestions regarding ways to increase UD performance levels in a Win2k3 environment? Thanks in advance, Rob Smith Philadelphia University --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: UNIDATA 7.1 performance measures
Firstly, you should NEVER run AV software on a database server. It's known for causing performance issues. By all means run a scan on the database from a remote machine via a share ... And you don't want it installed on the db server, because a lot of these things have a nasty habit of self-activating, or leaving dlls in the autoload, or whatever. AV software mucks about in the guts of the OS, and caution teaches you not to trust it ... Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Smith, Robert Sent: 31 March 2008 14:46 To: u2-users@listserver.u2ug.org Subject: RE: [U2] RE: UNIDATA 7.1 performance measures Good Morning John, Our Network Manager asked why you recommended removing the anti-virus software vs. disabling them. Could/would you please share your rationale for making that recommendation? The feedback I am getting as a result of this posting has been incredibly helpful. Rob Smith Philadelphia University -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Jenkins Sent: Saturday, March 29, 2008 8:29 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] RE: UNIDATA 7.1 performance measures Ibd start by looking for specific bottlenecks. Itbs too easy to see one of the system constraints and assume that's your bottleneck (been there). Run some mete As others have said, see a specific bottleneck first then take it from there. Some suggestions on things to look at in Windows and hardware - I'm assuming all the usual has been done inside UniData itself. __ Anti-Virus software killing you? REMOVE it first for the avoidance of doubt - then decide. Donbt just reconfigure or disable - REMOVE. Tweak afterwards - know whether itbs worth tweaking first. Paging (yes/no/how much)? Disk performance *read *write *wait I/O Are you using RAID? Should be 0+1, try and avoid RAID 5 Use hardware RAID not software Turn off read-ahead, optimise for random, not sequential Steps vary for different SANS (Hitachi / Veritas / Shark etc). If using an external SAN: * has the memory battery failed? (turns off write caching - a killer) Put paging space on a separate disk, and UniData TMP also. * Do you have remote mirroring on the SAM turned on (requiring remote commit on writes can be a killer). _ If 3Gb is does turn out to be an issue consider Unix, much better memory management. Linux on your x86 platform seems the logical move (same hardware). You also get better CPU resource usage on Unix then Windows. Memory could be a bottleneck for you, but Ibd be surprised. The usual memory related issues I see on Windows (or Unix come to that) are due to file import/export programs READING and WRITING truly enormous text files from the O/S file structures. READSEQ and WRITESEQ are the cure there/ Regards JayJay From: Smith, Robert Sent: Thursday, March 27, 2008 11:37 AM To: u2-users@listserver.u2ug.org Subject: UNIDATA 7.1 performance measures Good Morning, We are a UNIDATA shop and presently we are struggling with identifying the best way to increase the performance level of our environment. We presently are running UD on a Windows Enterprise server (SP2) with 16gig of ram and 8 - 3gig processors. We have read through some MS Knowledge Base articles that suggest a possible performance increase if we use the /PAE and /3GB boot.ini switches. We were wondering whether anyone has deployed these settings before and if there were any problems that resulted...with either the OS or database. Does anyone have any suggestions regarding ways to increase UD performance levels in a Win2k3 environment? Thanks in advance, Rob Smith Philadelphia University --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] RE: UNIDATA 7.1 performance measures
As far as removing the AV altogether? One reason (in Microsoft at least), is file system filter drivers. AV applications, and many other applications, are adding these fsfd's into their products. Another reason, on any platform, is the intense and constant struggle constraint for server platform resources between the number of applications Server paltofrms are running these days: - File system fragmentation. - Un-Delete applications. - Anti-Virus Applications. - Security applications. - Various snap shot technologies. - Backup products. - Replication products. Low overhead, detailed performance monitoring, 24x7x365, tells you all these things and more, not only in U2 but across the entire application server technology spectrum. Remember when application servers had scheduled downtime, for periodic platform maintenance? Disk integrity checks, defragmentation, etc? Patches and updates applied? These days, it can almost take an act of congress at some places to get a server reboot accomplished. Remember when hardware vendors ran industry standard benchmarks and characterization - simulation testing, to push Systems / Servers under real life application load to see how to best, code, configure tune them? Seems like these functions have fairly much fallen by the wayside, left to the individual company/organization, due to the uniqueness peculiaralities of your actual mileage may vary, and explosion of technology that has occurred over the years. This is not a bad thing, necessarily, but how does a company / organization or indivdual go about such montioring, in any given environment, be it production or pre-production, without the overhead of such montioring interfereing in the performance of the platform? How does one know, in their specific environment, with their given hardware platforms, network configurations, user loads, and data set sizes, and operational business dynamics, what is normal performance, what is bottle-necked or throttling server platform performance, and why? It is predictable? Is it a problem that can be fixed, re-coded, adjusted, tuned, or configured better? More hardware required? What is the cost of running multple applications at once and where/when do they conflict for resources? What resources? Why? How does my Windows application server platform performance compare with a similar Linux or other Unix platform performance, apples to apples?? Can my current application server platform support our anticipated growth ? How much will running month-end impact our normal business processing cycles? It's always a lot easier when debugging any problem, tuning any application or server platform, or explaining / justifying capital expenses, (or even justifying a reboot!), to have easy to see/understand detailed graphical, factual and specific current real-time data to help point out the operational dynamics of any problem in terms everyone can see/understand, and then pro-actively monitor and verify as time moves forward, in real time, and changes are made in hopes of alleviating or resovling the problem. Have proof positive that your suggestion or changes did indeed identify and/or resolve a problem. Coming from an operational, uptime, and perfomance minded server platforms used in business background, I can not understand why companies/organizations/individuals would not want/need/require such data pro-actively, to continually improve, justify, and ensure that your technology infastructure is delivering all it can, 24x7x365. /ad on Performance Montoring technology exisits to allow very similar, very detailed server wide and process level montioring of numerous diverse Server application platforms; hardware, operating systems and databases/applications - in one common interface, with extremely low overhead foot print. - multiple processors / cores - distributed applications - network configuration and throughput - storage sub-systems - Windows - Linux - AIX - Solaris One such performance monitoing application can be found at deltek.us /ad off (PS: I tried real hard to not jump into this one, but in the end, I could not help myself - as I deal with this stuff all the time, successfully ;^). Regards, Scott Richardson Senior Systems Engineer / Consultant Product Support Engineer Marlborough, MA 01752 DPMonitor - http://www.deltek.us - Original Message - From: Smith, Robert [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, March 31, 2008 9:45 AM Subject: RE: [U2] RE: UNIDATA 7.1 performance measures Good Morning John, Our Network Manager asked why you recommended removing the anti-virus software vs. disabling them. Could/would you please share your rationale for making that recommendation? The feedback I am getting as a result of this posting has been incredibly helpful. Rob Smith Philadelphia University -Original Message- From: [EMAIL
RE: [U2] RE: UNIDATA 7.1 performance measures
And, if you find the bottleneck is I/O don't neglect looking at file sizing of your UniData files. Badly sized files can drag a system down regardless of hardware and OS tweaks. Jeff Fitzgerald Fitzgerald Long, Inc. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Jenkins Sent: Saturday, March 29, 2008 6:29 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] RE: UNIDATA 7.1 performance measures Ibd start by looking for specific bottlenecks. Itbs too easy to see one of the system constraints and assume that's your bottleneck (been there). Run some mete As others have said, see a specific bottleneck first then take it from there. Some suggestions on things to look at in Windows and hardware - I'm assuming all the usual has been done inside UniData itself. __ Anti-Virus software killing you? REMOVE it first for the avoidance of doubt - then decide. Donbt just reconfigure or disable - REMOVE. Tweak afterwards - know whether itbs worth tweaking first. Paging (yes/no/how much)? Disk performance *read *write *wait I/O Are you using RAID? Should be 0+1, try and avoid RAID 5 Use hardware RAID not software Turn off read-ahead, optimise for random, not sequential Steps vary for different SANS (Hitachi / Veritas / Shark etc). If using an external SAN: * has the memory battery failed? (turns off write caching - a killer) Put paging space on a separate disk, and UniData TMP also. * Do you have remote mirroring on the SAM turned on (requiring remote commit on writes can be a killer). _ If 3Gb is does turn out to be an issue consider Unix, much better memory management. Linux on your x86 platform seems the logical move (same hardware). You also get better CPU resource usage on Unix then Windows. Memory could be a bottleneck for you, but Ibd be surprised. The usual memory related issues I see on Windows (or Unix come to that) are due to file import/export programs READING and WRITING truly enormous text files from the O/S file structures. READSEQ and WRITESEQ are the cure there/ Regards JayJay From: Smith, Robert Sent: Thursday, March 27, 2008 11:37 AM To: u2-users@listserver.u2ug.org Subject: UNIDATA 7.1 performance measures Good Morning, We are a UNIDATA shop and presently we are struggling with identifying the best way to increase the performance level of our environment. We presently are running UD on a Windows Enterprise server (SP2) with 16gig of ram and 8 - 3gig processors. We have read through some MS Knowledge Base articles that suggest a possible performance increase if we use the /PAE and /3GB boot.ini switches. We were wondering whether anyone has deployed these settings before and if there were any problems that resulted...with either the OS or database. Does anyone have any suggestions regarding ways to increase UD performance levels in a Win2k3 environment? Thanks in advance, Rob Smith Philadelphia University --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: UNIDATA 7.1 performance measures {Unclassified}
For what it's worth, that's why when we recently upgraded out UniVerse / Windows2003 Production server, I specifically said don't get more than 4GB. To use more than that, with a 32-bit Windows platform, you need to use the /PAE and /3GB switches. I think you may also need to use Win2K3 Enterprise or DataCenter versions. I didn't want to make our UV server the first one in our network to be configured that way, so we 'stayed small' If you want to use more than 4GB RAM with Windows, you really need to go to the Windows Server 64-bit editions, and you'd want to check the Availability Matrix to see which releases of UD are qualified. My $NZ0.02 Regards Mike -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Smith, Robert Sent: Saturday, 29 March 2008 9:31 a.m. To: u2-users@listserver.u2ug.org Subject: RE: [U2] RE: UNIDATA 7.1 performance measures Hi Jeff, We have since come to realize that the /3gig switch is not for us. What we are trying to do is be proactive to hopefully avoid a problem situation. Late last year we were forced to move to the latest version of the vendor software we use. Under the previous version, our registration process ran like a charm. It took a while for us to get to that plateau but once we had achieved it...life was good. This new software has a number of challenges that we've been able to address however, this coming month will be the first time we've used it for student registration. We only recently realized that because we are a Win2k3 32bit client that is *not* using SQL Server, we really can't take advantage of some of the advanced memory options available. Because of the way Windows manages memory, we effectively only have control of memory in the 4gig window. And to make matters worse, said 4gig window is sub-divided between user and kernel activities. So after monitoring system activities using RRDTOOL over a period of time, we realized that everything we are doing on the app server is crammed into 2.5gig...this is a 16gig box. We discovered that if our vendors' software had made use of the AWE API that allows for better memory management, we would be in a better position...but they don't and we're not. We have run registration simulations and have discovered approximately when registration will crash...but we doubt (and hope) we will ever reach that level of activity. You mentioned UD settings below. Would you mind sharing yours with us? Thanks, Rob Smith Philadelphia University -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Lettau, Jeff Sent: Friday, March 28, 2008 2:22 PM To: u2-users@listserver.u2ug.org Subject: [U2] RE: UNIDATA 7.1 performance measures All the /3gig switch does for you is allow more memory to be available. You would still need to make settings in Unidata to take advantage of the additional memory. Unless I'm getting the /3gig switch confused with the SQL settings. I'd also start with turning off hyper threading on the processors if you're using that just to see if it helps. Although I'm not sure if 7.1 has these kinds of problems or not. Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Smith, Robert Sent: Friday, March 28, 2008 11:51 AM To: u2-users@listserver.u2ug.org Subject: [U2] RE: UNIDATA 7.1 performance measures From: Smith, Robert Sent: Thursday, March 27, 2008 11:37 AM To: u2-users@listserver.u2ug.org Subject: UNIDATA 7.1 performance measures Good Morning, We are a UNIDATA shop and presently we are struggling with identifying the best way to increase the performance level of our environment. We presently are running UD on a Windows Enterprise server (SP2) with 16gig of ram and 8 - 3gig processors. We have read through some MS Knowledge Base articles that suggest a possible performance increase if we use the /PAE and /3GB boot.ini switches. We were wondering whether anyone has deployed these settings before and if there were any problems that resulted...with either the OS or database. Does anyone have any suggestions regarding ways to increase UD performance levels in a Win2k3 environment? Thanks in advance, Rob Smith Philadelphia University --- The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: UNIDATA 7.1 performance measures
Ibd start by looking for specific bottlenecks. Itbs too easy to see one of the system constraints and assume that's your bottleneck (been there). Run some mete As others have said, see a specific bottleneck first then take it from there. Some suggestions on things to look at in Windows and hardware - I'm assuming all the usual has been done inside UniData itself. __ Anti-Virus software killing you? REMOVE it first for the avoidance of doubt - then decide. Donbt just reconfigure or disable - REMOVE. Tweak afterwards - know whether itbs worth tweaking first. Paging (yes/no/how much)? Disk performance *read *write *wait I/O Are you using RAID? Should be 0+1, try and avoid RAID 5 Use hardware RAID not software Turn off read-ahead, optimise for random, not sequential Steps vary for different SANS (Hitachi / Veritas / Shark etc). If using an external SAN: * has the memory battery failed? (turns off write caching - a killer) Put paging space on a separate disk, and UniData TMP also. * Do you have remote mirroring on the SAM turned on (requiring remote commit on writes can be a killer). _ If 3Gb is does turn out to be an issue consider Unix, much better memory management. Linux on your x86 platform seems the logical move (same hardware). You also get better CPU resource usage on Unix then Windows. Memory could be a bottleneck for you, but Ibd be surprised. The usual memory related issues I see on Windows (or Unix come to that) are due to file import/export programs READING and WRITING truly enormous text files from the O/S file structures. READSEQ and WRITESEQ are the cure there/ Regards JayJay From: Smith, Robert Sent: Thursday, March 27, 2008 11:37 AM To: u2-users@listserver.u2ug.org Subject: UNIDATA 7.1 performance measures Good Morning, We are a UNIDATA shop and presently we are struggling with identifying the best way to increase the performance level of our environment. We presently are running UD on a Windows Enterprise server (SP2) with 16gig of ram and 8 - 3gig processors. We have read through some MS Knowledge Base articles that suggest a possible performance increase if we use the /PAE and /3GB boot.ini switches. We were wondering whether anyone has deployed these settings before and if there were any problems that resulted...with either the OS or database. Does anyone have any suggestions regarding ways to increase UD performance levels in a Win2k3 environment? Thanks in advance, Rob Smith Philadelphia University --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: UNIDATA 7.1 performance measures
I may be mistaken but the /3gig means an individual process can take over 2gig ram at any one time. So you need to use your task monitor to see if your udt processes are reaching this limit. Personally I very much doubt it, but you certainly need to see where the limits are. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Smith, Robert Sent: 28 March 2008 15:51 To: u2-users@listserver.u2ug.org Subject: [U2] RE: UNIDATA 7.1 performance measures From: Smith, Robert Sent: Thursday, March 27, 2008 11:37 AM To: u2-users@listserver.u2ug.org Subject: UNIDATA 7.1 performance measures Good Morning, We are a UNIDATA shop and presently we are struggling with identifying the best way to increase the performance level of our environment. We presently are running UD on a Windows Enterprise server (SP2) with 16gig of ram and 8 - 3gig processors. We have read through some MS Knowledge Base articles that suggest a possible performance increase if we use the /PAE and /3GB boot.ini switches. We were wondering whether anyone has deployed these settings before and if there were any problems that resulted...with either the OS or database. Does anyone have any suggestions regarding ways to increase UD performance levels in a Win2k3 environment? Thanks in advance, Rob Smith Philadelphia University --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: UNIDATA 7.1 performance measures
Hi Jeff, We have since come to realize that the /3gig switch is not for us. What we are trying to do is be proactive to hopefully avoid a problem situation. Late last year we were forced to move to the latest version of the vendor software we use. Under the previous version, our registration process ran like a charm. It took a while for us to get to that plateau but once we had achieved it...life was good. This new software has a number of challenges that we've been able to address however, this coming month will be the first time we've used it for student registration. We only recently realized that because we are a Win2k3 32bit client that is *not* using SQL Server, we really can't take advantage of some of the advanced memory options available. Because of the way Windows manages memory, we effectively only have control of memory in the 4gig window. And to make matters worse, said 4gig window is sub-divided between user and kernel activities. So after monitoring system activities using RRDTOOL over a period of time, we realized that everything we are doing on the app server is crammed into 2.5gig...this is a 16gig box. We discovered that if our vendors' software had made use of the AWE API that allows for better memory management, we would be in a better position...but they don't and we're not. We have run registration simulations and have discovered approximately when registration will crash...but we doubt (and hope) we will ever reach that level of activity. You mentioned UD settings below. Would you mind sharing yours with us? Thanks, Rob Smith Philadelphia University -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Lettau, Jeff Sent: Friday, March 28, 2008 2:22 PM To: u2-users@listserver.u2ug.org Subject: [U2] RE: UNIDATA 7.1 performance measures All the /3gig switch does for you is allow more memory to be available. You would still need to make settings in Unidata to take advantage of the additional memory. Unless I'm getting the /3gig switch confused with the SQL settings. I'd also start with turning off hyper threading on the processors if you're using that just to see if it helps. Although I'm not sure if 7.1 has these kinds of problems or not. Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Smith, Robert Sent: Friday, March 28, 2008 11:51 AM To: u2-users@listserver.u2ug.org Subject: [U2] RE: UNIDATA 7.1 performance measures From: Smith, Robert Sent: Thursday, March 27, 2008 11:37 AM To: u2-users@listserver.u2ug.org Subject: UNIDATA 7.1 performance measures Good Morning, We are a UNIDATA shop and presently we are struggling with identifying the best way to increase the performance level of our environment. We presently are running UD on a Windows Enterprise server (SP2) with 16gig of ram and 8 - 3gig processors. We have read through some MS Knowledge Base articles that suggest a possible performance increase if we use the /PAE and /3GB boot.ini switches. We were wondering whether anyone has deployed these settings before and if there were any problems that resulted...with either the OS or database. Does anyone have any suggestions regarding ways to increase UD performance levels in a Win2k3 environment? Thanks in advance, Rob Smith Philadelphia University --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ 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. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: UNIDATA 7.1 performance measures
I would like to see an individual UDT session consume over 2 gig hehehehe.. My largest one is 27M and itbs a service phantom executing other jobs. On this wide open topic with no guidance as to what the performance issue is - we're just throwing rocks at the wall... For all we know it could be a disk performance issue. I would be interested in how many user sessions we're talking about on this large box as well. :-) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Symeon Breen Sent: Friday, March 28, 2008 3:17 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] RE: UNIDATA 7.1 performance measures I may be mistaken but the /3gig means an individual process can take over 2gig ram at any one time. So you need to use your task monitor to see if your udt processes are reaching this limit. Personally I very much doubt it, but you certainly need to see where the limits are. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Smith, Robert Sent: 28 March 2008 15:51 To: u2-users@listserver.u2ug.org Subject: [U2] RE: UNIDATA 7.1 performance measures From: Smith, Robert Sent: Thursday, March 27, 2008 11:37 AM To: u2-users@listserver.u2ug.org Subject: UNIDATA 7.1 performance measures Good Morning, We are a UNIDATA shop and presently we are struggling with identifying the best way to increase the performance level of our environment. We presently are running UD on a Windows Enterprise server (SP2) with 16gig of ram and 8 - 3gig processors. We have read through some MS Knowledge Base articles that suggest a possible performance increase if we use the /PAE and /3GB boot.ini switches. We were wondering whether anyone has deployed these settings before and if there were any problems that resulted...with either the OS or database. Does anyone have any suggestions regarding ways to increase UD performance levels in a Win2k3 environment? Thanks in advance, Rob Smith Philadelphia University --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: U2 Users Digest V1 #2120
Thanks to all of you for pointing me to UVAdmin for the account access control. This is the answer I needed. Laure Hansen, City of Redwood City Information Technology 1017 Middlefield Road Redwood City, CA 94063 Tel 650-780-7087 Cell 650-207-3235 Fax 650-556-9204 [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom Whitmore Sent: Tuesday, March 18, 2008 5:07 AM To: u2-users@listserver.u2ug.org Subject: [U2] RE: U2 Users Digest V1 #2120 Laure, The easiest way to handle this situation to use UniAdmin. Expand Network Services and double-click on Telnet. On the first tab (Parameters), set the User Policy to UV Account and press the Save button. Now, Click on the Users tab, click Add User and Enter the user name. NOTE: the user name is case sensitive, you must type the user exactly as it is entered when you set up the user in Windows. If it is a domain user, you must include the domain. ALSO, if the user has admin rights, they will always be prompted for the account. If you aren't familiar with UniAdmin feel free to send me an email and I'll send you a word document that provides greater details. Tom RATEX Business Solutions Plymouth Meeting, PA -- Date: Mon, 17 Mar 2008 10:58:54 -0700 From: IT-Laure Hansen [EMAIL PROTECTED] Subject: [U2] Windows 2003 server security on new users Universe 10.2 on Win2003 server SP2 (but was happening before SP2 as well): our set-up requires that users get created with the path to a valid Universe account in the user's profile tab. As soon as I do this, using the admin login on the server, the original permissions on the account are removed and all that remains are administrator and the new user. This is not acceptable, as Universe requires wide-open security (the effect of this is that other users can no longer even log to the account). I've been creating new users after hours because of this, and it's starting to drive me nuts! Does anyone know of a fix, either via change to Windows security policies, hotfixes etc? Thanks, Laure Hansen, City of Redwood City Information Technology 1017 Middlefield Road Redwood City, CA 94063 Tel 650-780-7087 Cell 650-207-3235 Fax 650-556-9204 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] RE: Switching from D3 to U2
Actually, what was the VAR's reason for switching. One of my client's VAR's forced a switch from UV to UD around 9 years ago when they went from a green-screen app to having rewritten their package with SB. Not SB GUI but regular SB. SB GUI came later for those newer clients. Thanks Mark Johnson - Original Message - From: Norman Morgan [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, February 04, 2008 10:13 AM Subject: RE: [U2] RE: Switching from D3 to U2 -Original Message- From: MAJ So what's the number one reason for switching from D3 to U2? Not to create an onslaught of replies, but I've worked on many MV platforms and have my opinions on each. Because our VAR told use they wouldn't support their product on D3 any longer. grin === Norman Morgan [EMAIL PROTECTED] http://www.brake.com === Real programmers don't document. Documentation is for simps who can't read the listings or the object deck. === --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Re: PCL: command
Mark, Could you post your version of PCL.INCLUDE on PickWiki.com or the U2UG wiki? rex MAJ Programming wrote: I'm surprised someone in any MV hasn't submitted a comprehensive PCL.INCLUDE that would help many of these requests. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: Switching from D3 to U2
I can't speak authoritatively for Prelude (Activant), but I suspect they more or less followed where SB+ went. They made a tremendous effort to convert their whole application from all legacy code to SB+ about 13 years ago. Perhaps it was general fear for the future of D3, perhaps it was fear that SB+ would cease to be supported on D3, or perhaps since IBM owned the whole mess and they were IBM business partners, they thought it was the prudent thing to do. From our standpoint, we were happy with D3. It did everything we needed and I really liked FlashConnect for web connectivity. But we were about 3 major versions behind on the Prelude application code and wanted some of the newer features. When Prelude said they would not support the newer versions on D3, we were forced to switch. Conversion by coercion. === Norman Morgan [EMAIL PROTECTED] http://www.brake.com === Orville Wright didn't have a pilot's license. === -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of MAJ Programming Sent: Tuesday, February 05, 2008 8:14 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] RE: Switching from D3 to U2 Actually, what was the VAR's reason for switching. One of my client's VAR's forced a switch from UV to UD around 9 years ago when they went from a green-screen app to having rewritten their package with SB. Not SB GUI but regular SB. SB GUI came later for those newer clients. Thanks Mark Johnson - Original Message - From: Norman Morgan [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, February 04, 2008 10:13 AM Subject: RE: [U2] RE: Switching from D3 to U2 -Original Message- From: MAJ So what's the number one reason for switching from D3 to U2? Not to create an onslaught of replies, but I've worked on many MV platforms and have my opinions on each. Because our VAR told use they wouldn't support their product on D3 any longer. grin === Norman Morgan [EMAIL PROTECTED] http://www.brake.com === Real programmers don't document. Documentation is for simps who can't read the listings or the object deck. === --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: Switching from D3 to U2
-Original Message- From: MAJ So what's the number one reason for switching from D3 to U2? Not to create an onslaught of replies, but I've worked on many MV platforms and have my opinions on each. Because our VAR told use they wouldn't support their product on D3 any longer. grin === Norman Morgan [EMAIL PROTECTED] http://www.brake.com === Real programmers don't document. Documentation is for simps who can't read the listings or the object deck. === --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Re: PCL: command
David, For commands with the same prefix (2 characters after ESC), change the last character to lower case in all commands except the last. In any case there shouldn't be a problem just concatenating the commands. Most printer manufacturers have downloadable manuals which include PCL defintions - if not refer to HP, who invented it! Francis - Original Message - From: david yu [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Tuesday, February 05, 2008 12:12 PM Subject: [U2] Re: PCL: command hello, how do you write multiple PCL command in one program, I have a program that I need to write a compress 8pt arial narrow and another font within the same letter. Right now I am using esc(s20H and the printout compress it but the height stayed so I have a visible space between lines. any ideas would be greatly appreciated. thanks! Never miss a thing. Make Yahoo your home page. http://www.yahoo.com/r/hs --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Re: PCL: command
I'm surprised someone in any MV hasn't submitted a comprehensive PCL.INCLUDE that would help many of these requests. I have one that I use for 60% of what I need (pitch, orientation, typefaces, some line graphics and other simple functions) but I'm sure there could be a greatest hits INCLUDE that has the advanced stuff as well. My 1 cent Mark Johnson - Original Message - From: david yu [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, February 04, 2008 9:12 PM Subject: [U2] Re: PCL: command hello, how do you write multiple PCL command in one program, I have a program that I need to write a compress 8pt arial narrow and another font within the same letter. Right now I am using esc(s20H and the printout compress it but the height stayed so I have a visible space between lines. any ideas would be greatly appreciated. thanks! Never miss a thing. Make Yahoo your home page. http://www.yahoo.com/r/hs --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] RE: Switching from D3 to U2
Doesn't sound like a real useful reason for the rest of us. Thanks Mark Johnson - Original Message - From: Norman Morgan [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, February 04, 2008 10:13 AM Subject: RE: [U2] RE: Switching from D3 to U2 -Original Message- From: MAJ So what's the number one reason for switching from D3 to U2? Not to create an onslaught of replies, but I've worked on many MV platforms and have my opinions on each. Because our VAR told use they wouldn't support their product on D3 any longer. grin === Norman Morgan [EMAIL PROTECTED] http://www.brake.com === Real programmers don't document. Documentation is for simps who can't read the listings or the object deck. === --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: Switching from D3 to U2
From: MAJ So what's the number one reason for switching from D3 to U2? Not to create an onslaught of replies, but I've worked on many MV platforms and have my opinions on each. Might be best to just wait for George to put his notes together and post for everyone later... --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] RE: Switching from D3 to U2
I have had a number of responses directly as well as to the group, I'll be putting together a document on it and will look at publishing it. But if anyone specifically wants a copy please let me know and I'll email it when I have it. george.land@ (remove) u2uk.com George Land APT Solutions Limited IBM U2 UK Distributor www.u2uk.com On 01/02/2008 00:26, MAJ Programming [EMAIL PROTECTED] wrote: I too am interested in this comparison. The majority of my clients are D3 yet I have 1 or 2 UV and UD clients, hence the straddling. I know that U2 products have many more technical features but I would like to see where it gets admin heavy versus D3. Thanks Mark Johnson - Original Message - From: Janet Bond [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, January 30, 2008 12:26 PM Subject: [U2] RE: Switching from D3 to U2 Hello George, We created a report comparing D3 and the U2 products along with other available MultiValue databases for one of our customers. Please email me directly and I can provide this content to you. Thanks Janet Bond FusionWare Corporation IBM Premier Business Partner Microsoft Gold Partner www.fusionware.net -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Land Sent: Wednesday, January 30, 2008 5:30 AM To: u2-users@listserver.u2ug.org Subject: [U2] Switching from D3 to U2 I am in the process of putting together a document to support the case for switching an application from D3 to U2 but my knowledge of D3 is a little old and hazy. Has anyone any product or technical justifications for switching over that they would be willing to share? Thanks George Land APT Solutions Limited IBM U2 UK Distributor www.u2uk.com ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify us immediately on +44 (01952) 214000 or at [EMAIL PROTECTED] . Please delete and destroy any copies in any format of this email you may have received in error. The recipient should note that the views contained or expressed within this correspondence do not necessarily reflect those of APT Solutions Limited , it subsidiaries, affiliates or associates. This email and any attachments are not guaranteed to be free from so-called computer viruses and it is recommended that you check for such viruses before down-loading it to your computer equipment. It is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message or any attachments will not adversely affect their systems or data. Registered Office:- Stratum House, Stafford Park 10, Telford, Shropshire, TF3 3AB Registration Number:- 2228445 Place of Registration: England Wales ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] RE: Switching from D3 to U2
So what's the number one reason for switching from D3 to U2? Not to create an onslaught of replies, but I've worked on many MV platforms and have my opinions on each. Thanks Mark Johnson - Original Message - From: George Land [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Friday, February 01, 2008 12:22 PM Subject: Re: [U2] RE: Switching from D3 to U2 I have had a number of responses directly as well as to the group, I'll be putting together a document on it and will look at publishing it. But if anyone specifically wants a copy please let me know and I'll email it when I have it. george.land@ (remove) u2uk.com George Land APT Solutions Limited IBM U2 UK Distributor www.u2uk.com On 01/02/2008 00:26, MAJ Programming [EMAIL PROTECTED] wrote: I too am interested in this comparison. The majority of my clients are D3 yet I have 1 or 2 UV and UD clients, hence the straddling. I know that U2 products have many more technical features but I would like to see where it gets admin heavy versus D3. Thanks Mark Johnson - Original Message - From: Janet Bond [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, January 30, 2008 12:26 PM Subject: [U2] RE: Switching from D3 to U2 Hello George, We created a report comparing D3 and the U2 products along with other available MultiValue databases for one of our customers. Please email me directly and I can provide this content to you. Thanks Janet Bond FusionWare Corporation IBM Premier Business Partner Microsoft Gold Partner www.fusionware.net -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Land Sent: Wednesday, January 30, 2008 5:30 AM To: u2-users@listserver.u2ug.org Subject: [U2] Switching from D3 to U2 I am in the process of putting together a document to support the case for switching an application from D3 to U2 but my knowledge of D3 is a little old and hazy. Has anyone any product or technical justifications for switching over that they would be willing to share? Thanks George Land APT Solutions Limited IBM U2 UK Distributor www.u2uk.com ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify us immediately on +44 (01952) 214000 or at [EMAIL PROTECTED] . Please delete and destroy any copies in any format of this email you may have received in error. The recipient should note that the views contained or expressed within this correspondence do not necessarily reflect those of APT Solutions Limited , it subsidiaries, affiliates or associates. This email and any attachments are not guaranteed to be free from so-called computer viruses and it is recommended that you check for such viruses before down-loading it to your computer equipment. It is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message or any attachments will not adversely affect their systems or data. Registered Office:- Stratum House, Stafford Park 10, Telford, Shropshire, TF3 3AB Registration Number:- 2228445 Place of Registration: England Wales ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] RE: Switching from D3 to U2
I too am interested in this comparison. The majority of my clients are D3 yet I have 1 or 2 UV and UD clients, hence the straddling. I know that U2 products have many more technical features but I would like to see where it gets admin heavy versus D3. Thanks Mark Johnson - Original Message - From: Janet Bond [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, January 30, 2008 12:26 PM Subject: [U2] RE: Switching from D3 to U2 Hello George, We created a report comparing D3 and the U2 products along with other available MultiValue databases for one of our customers. Please email me directly and I can provide this content to you. Thanks Janet Bond FusionWare Corporation IBM Premier Business Partner Microsoft Gold Partner www.fusionware.net -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Land Sent: Wednesday, January 30, 2008 5:30 AM To: u2-users@listserver.u2ug.org Subject: [U2] Switching from D3 to U2 I am in the process of putting together a document to support the case for switching an application from D3 to U2 but my knowledge of D3 is a little old and hazy. Has anyone any product or technical justifications for switching over that they would be willing to share? Thanks George Land APT Solutions Limited IBM U2 UK Distributor www.u2uk.com ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify us immediately on +44 (01952) 214000 or at [EMAIL PROTECTED] . Please delete and destroy any copies in any format of this email you may have received in error. The recipient should note that the views contained or expressed within this correspondence do not necessarily reflect those of APT Solutions Limited , it subsidiaries, affiliates or associates. This email and any attachments are not guaranteed to be free from so-called computer viruses and it is recommended that you check for such viruses before down-loading it to your computer equipment. It is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message or any attachments will not adversely affect their systems or data. Registered Office:- Stratum House, Stafford Park 10, Telford, Shropshire, TF3 3AB Registration Number:- 2228445 Place of Registration: England Wales ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: Switching from D3 to U2
Hello Mark, Drop me an email at [EMAIL PROTECTED] and I will provide you with this document. I cannot publish this on the list without marketing approval, but, I can send it to you directly. Thanks Janet From: [EMAIL PROTECTED] [EMAIL PROTECTED] On Behalf Of MAJ Programming [EMAIL PROTECTED] Sent: Thursday, January 31, 2008 4:26 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] RE: Switching from D3 to U2 I too am interested in this comparison. The majority of my clients are D3 yet I have 1 or 2 UV and UD clients, hence the straddling. I know that U2 products have many more technical features but I would like to see where it gets admin heavy versus D3. Thanks Mark Johnson - Original Message - From: Janet Bond [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, January 30, 2008 12:26 PM Subject: [U2] RE: Switching from D3 to U2 Hello George, We created a report comparing D3 and the U2 products along with other available MultiValue databases for one of our customers. Please email me directly and I can provide this content to you. Thanks Janet Bond FusionWare Corporation IBM Premier Business Partner Microsoft Gold Partner www.fusionware.net -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Land Sent: Wednesday, January 30, 2008 5:30 AM To: u2-users@listserver.u2ug.org Subject: [U2] Switching from D3 to U2 I am in the process of putting together a document to support the case for switching an application from D3 to U2 but my knowledge of D3 is a little old and hazy. Has anyone any product or technical justifications for switching over that they would be willing to share? Thanks George Land APT Solutions Limited IBM U2 UK Distributor www.u2uk.com ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify us immediately on +44 (01952) 214000 or at [EMAIL PROTECTED] . Please delete and destroy any copies in any format of this email you may have received in error. The recipient should note that the views contained or expressed within this correspondence do not necessarily reflect those of APT Solutions Limited , it subsidiaries, affiliates or associates. This email and any attachments are not guaranteed to be free from so-called computer viruses and it is recommended that you check for such viruses before down-loading it to your computer equipment. It is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message or any attachments will not adversely affect their systems or data. Registered Office:- Stratum House, Stafford Park 10, Telford, Shropshire, TF3 3AB Registration Number:- 2228445 Place of Registration: England Wales ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] RE: Switching from D3 to U2
Could you put that document on the PickWiki? I think there are more that would benefit from it's content, and being on the wiki, it could be updated as time passes and the parameters change. Thanks, Karl quote who=Janet Bond Hello George, We created a report comparing D3 and the U2 products along with other available MultiValue databases for one of our customers. Please email me directly and I can provide this content to you. Thanks Janet Bond FusionWare Corporation IBM Premier Business Partner Microsoft Gold Partner www.fusionware.net -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Land Sent: Wednesday, January 30, 2008 5:30 AM To: u2-users@listserver.u2ug.org Subject: [U2] Switching from D3 to U2 I am in the process of putting together a document to support the case for switching an application from D3 to U2 but my knowledge of D3 is a little old and hazy. Has anyone any product or technical justifications for switching over that they would be willing to share? Thanks George Land APT Solutions Limited IBM U2 UK Distributor www.u2uk.com ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify us immediately on +44 (01952) 214000 or at [EMAIL PROTECTED] . Please delete and destroy any copies in any format of this email you may have received in error. The recipient should note that the views contained or expressed within this correspondence do not necessarily reflect those of APT Solutions Limited , it subsidiaries, affiliates or associates. This email and any attachments are not guaranteed to be free from so-called computer viruses and it is recommended that you check for such viruses before down-loading it to your computer equipment. It is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message or any attachments will not adversely affect their systems or data. Registered Office:- Stratum House, Stafford Park 10, Telford, Shropshire, TF3 3AB Registration Number:- 2228445 Place of Registration: England Wales ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Karl Pearson Director of I.T. ATS Industrial Supply, Inc. [EMAIL PROTECTED] http://www.atsindustrial.com 800-789-9300 x29 Local: 801-978-4429 Fax: 801-972-3888 To mess up your Linux PC, you have to really work at it; to mess up a microsoft PC you just have to work on it. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: testing [not secure] [off topic]
Because it's Christmas I was thinking about posting a question about determining the best size for swap on a Solaris 10/UV 10.2.2 box... But instead: http://www.courant.com/news/nationworld/wire/sns-ap-odd-santa-groped,0,2 086133.story The lead: Santa Claus says that a woman who sat on his lap was naughty, not nice. A Santa at the Danbury Fair mall said the woman groped him. The security officer at the mall said Santa Claus has been sexually assaulted, police Detective Lt. Thomas Michael said of the weekend complaint. Sandrama Lamy, 33, of Danbury, was charged with sexual assault and breach of peace. She was released on a promise to appear in court on Jan. 3. Mark Hennessey -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Monday, December 24, 2007 10:56 AM To: u2-users@listserver.u2ug.org Subject: [U2] RE: testing hohoho? My son says that's the response Santa gave when he found 3 blondes under the Christmas tree. He's getting coal for Christmas this year. -- Karl Pearson Director of I.T. ATS Industrial Supply, Inc. [EMAIL PROTECTED] http://www.atsindustrial.com 800-789-9300 x29 Local: 801-978-4429 Fax: 801-972-3888 To mess up your Linux PC, you have to really work at it; to mess up a microsoft PC you just have to work on it. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: testing
He's getting coal for Christmas this year. Does he know what coal is? I actually found some at a lumberyard several years ago got a few pieces for my kids' stockings. A shiney black rock that burns? No way. This is so cool! --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: testing
I agree. I'd like some more, please... I think he knows what it is because of the annoying coal mine disaster that could/should have been avoided here in Utah this past fall. That put coal on the front burner once again. Karl quote who=Stevenson, Charles He's getting coal for Christmas this year. Does he know what coal is? I actually found some at a lumberyard several years ago got a few pieces for my kids' stockings. A shiney black rock that burns? No way. This is so cool! --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Karl Pearson Director of I.T. ATS Industrial Supply, Inc. [EMAIL PROTECTED] http://www.atsindustrial.com 800-789-9300 x29 Local: 801-978-4429 Fax: 801-972-3888 To mess up your Linux PC, you have to really work at it; to mess up a microsoft PC you just have to work on it. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] RE: testing
I get it, front burner. Ha, Ha, Ha. Don't laugh. Some of my client's MV systems still run on coal. I'm working on one right now. Mark Johnson - Original Message - From: [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, December 24, 2007 1:15 PM Subject: RE: [U2] RE: testing I agree. I'd like some more, please... I think he knows what it is because of the annoying coal mine disaster that could/should have been avoided here in Utah this past fall. That put coal on the front burner once again. Karl quote who=Stevenson, Charles He's getting coal for Christmas this year. Does he know what coal is? I actually found some at a lumberyard several years ago got a few pieces for my kids' stockings. A shiney black rock that burns? No way. This is so cool! --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Karl Pearson Director of I.T. ATS Industrial Supply, Inc. [EMAIL PROTECTED] http://www.atsindustrial.com 800-789-9300 x29 Local: 801-978-4429 Fax: 801-972-3888 To mess up your Linux PC, you have to really work at it; to mess up a microsoft PC you just have to work on it. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: testing
Coal?!!!? Why that's modern. My client Mv is running on a squirrel cage with 9 gerbils! Coincidentally their names are Dasher, Dancer, Prancer, Vixen, Comet, Cupid, Donner, Blitzen, and Rudolph! Merry Christmas Everyone! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of MAJ Programming Sent: Monday, December 24, 2007 11:31 To: u2-users@listserver.u2ug.org Subject: Re: [U2] RE: testing I get it, front burner. Ha, Ha, Ha. Don't laugh. Some of my client's MV systems still run on coal. I'm working on one right now. Mark Johnson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: Universe Replication [ad]
[ad] Interesting. We have been toying with the idea of migrating our Visage.DRS product across to UV from D3, but have been unsure of the demand level, especially as IBM have a product (then again, so to RD, but possibly with similar limitations?). DRS gracefully recovers from network interruptions, and you can also suspend updates on mirrored systems, allowing clean backups to be produced. We can also produce a clean replicated system from a dirty backup (ie: backup produced while system is active), support replication to multiple replication servers (subscribers), and keep logs in 4 places to ensure a high level of redundancy. That said, we would have the same limitation on type 1/19 files on *NIX platforms, though I can see a fairly straight forward solution on windows that would work with updates from anywhere. More details here if you are interested, even if only the approach we have used http://www.stamina.com.au/Visage/visageDRS.htm Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Scott Ballinger Sent: Tuesday, 11 December 2007 4:20 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] RE: Universe Replication The problem I ran into with replication (UV on Linux), is that if the subscriber system was off-line or the subscriber process not running, writes on the publisher would cause the writing application to hang and eventually error. Since our goal was to the use subscriber system for reporting as well as testing, this caused a problem whenever the back-up system need to be rebooted or taken off-line. We concluded that we needed something more asynchronous that would allow buffered updates to the back-up system. Other problems, such as managing many published files spread over many accounts, and the fact that type 1/19 files are not replicated, caused us to abandon replication. However, it is likely that IBM has continued to improve replication and my problems may not have been typical. But I am curious if a work-around to allow buffering of updates to the subscriber system was ever developed, because for us that was a stopper. /Scott Ballinger Pareto Corporation Edmonds WA USA 206 713 6006 On Dec 10, 2007 4:06 AM, Barry Rogen [EMAIL PROTECTED] wrote: Robin, We attempted (operative word) to embrace Replication for a solution to our needs. We are a little different, in that we are running Unix. We have a D/R system off site and the primary/production box here. Our intentions were similar, to establish a scenario where our second system would not only be our D/R, but allow us to offload many of our reportings from the production system. Data Replication was touted as the solution. A solution that would update our D/R system real time from our production system. If you would like to discuss in further detail, off line, U2's Data Replication solution (in the real world), I would be more that happy to spend some time. Barry Rogen PNY Technologies, Inc. Senior Programmer/Analyst (973) 515 - 9700 ext 5327 [EMAIL PROTECTED] - Far better it is to dare mighty things, to win glorious triumphs even though checkered by failure, than to rank with those poor spirits who neither enjoy nor suffer much because they live in the gray twilight that knows neither victory nor defeat.t. roosevelt -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of LeRoy Dreyfuss Sent: Sunday, December 09, 2007 6:35 AM To: u2-users@listserver.u2ug.org Subject: [U2] RE: Universe Replication Hello Robin, 10.2.x is still pretty new, even though it has been out a whole year now. With most busy organizations, uptake on a new release can be pretty slow, so I doubt many folks have it going in a production environment. When I worked for the U2 group, I did quite a bit of testing with replication. It is ideal for what you propose to use it for. In 10.2, the services changed to improve overall replication performance and recoverability after a network outage. If you've never set it up before, there are some things to consider first. For example, how reliable are the file pointers? Can everyone of the file pointers be opened? Are they referencing files that live in other file systems and not where the account itself exists? Replication expects that the files not be UV/NET files and will skip them when you start looking for files within accounts to publish. Like transaction logging, replication ships with TCL verbs to greatly speed up the selection, publish, and subscribe process when there are many files per account to be replicated. They are documented in the UV 10.2 documentation set. I made improvements to two of those programs-- just ping me off-line if you'd like the updated programs. I
RE: [U2] RE: Universe Replication
Is there a replication system that does replicate all file types? Seems to me that not replicating all file types would be a major problem, seeing as many people use type 1/19 files for a variety of reasons. Jerry Banker Sr Programmer Analyst Affiliated Acceptance Corp Sunrise Beach, MO 1-800-233-8483 www.affiliated.org snip That said, we would have the same limitation on type 1/19 files on *NIX platforms, though I can see a fairly straight forward solution on windows that would work with updates from anywhere. snip/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: Universe Replication
Robin, We attempted (operative word) to embrace Replication for a solution to our needs. We are a little different, in that we are running Unix. We have a D/R system off site and the primary/production box here. Our intentions were similar, to establish a scenario where our second system would not only be our D/R, but allow us to offload many of our reportings from the production system. Data Replication was touted as the solution. A solution that would update our D/R system real time from our production system. If you would like to discuss in further detail, off line, U2's Data Replication solution (in the real world), I would be more that happy to spend some time. Barry Rogen PNY Technologies, Inc. Senior Programmer/Analyst (973) 515 - 9700 ext 5327 [EMAIL PROTECTED] - Far better it is to dare mighty things, to win glorious triumphs even though checkered by failure, than to rank with those poor spirits who neither enjoy nor suffer much because they live in the gray twilight that knows neither victory nor defeat.t. roosevelt -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of LeRoy Dreyfuss Sent: Sunday, December 09, 2007 6:35 AM To: u2-users@listserver.u2ug.org Subject: [U2] RE: Universe Replication Hello Robin, 10.2.x is still pretty new, even though it has been out a whole year now. With most busy organizations, uptake on a new release can be pretty slow, so I doubt many folks have it going in a production environment. When I worked for the U2 group, I did quite a bit of testing with replication. It is ideal for what you propose to use it for. In 10.2, the services changed to improve overall replication performance and recoverability after a network outage. If you've never set it up before, there are some things to consider first. For example, how reliable are the file pointers? Can everyone of the file pointers be opened? Are they referencing files that live in other file systems and not where the account itself exists? Replication expects that the files not be UV/NET files and will skip them when you start looking for files within accounts to publish. Like transaction logging, replication ships with TCL verbs to greatly speed up the selection, publish, and subscribe process when there are many files per account to be replicated. They are documented in the UV 10.2 documentation set. I made improvements to two of those programs-- just ping me off-line if you'd like the updated programs. I intend to deploy replication across my Linux servers, with transaction logging running on each server as well. I am confident with 10.2's ability to handle them both quite well in the scenario I chose to deploy them. I believe I can tell you quite a bit more about the process if you want to write me off-line. Regards, LeRoy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Robin Smith Sent: Friday, December 07, 2007 10:59 PM To: u2-users@listserver.u2ug.org Subject: [U2] Universe Replication We are about to install Universe File Replication on a Windows 2003 server, using Universe 10.2.3 with replication to a similarly specified Subscriber Server. The subscriber will be used for reporting purposes to reduce the load on the publishing server. Most of the reporting is done via UVODBC. Has anyone had experience of installing Universe Replication in a Windows 2003 server environment? How stable is it? What problems have you encountered along the way? Any help/tips/advice would be much appreciated. Robin Smith Reflex Data Systems Ltd Tel: 01482 881152 Fax:01482 881195 Registered Office: Reflex House, Tokenspire Business Park, Beverley, East Yorkshire, HU17 0TB Registered in England No. 2767946. VAT Registration No. GB 599 0463 94 Scanned by MailDefender - managed email security from intY - www.maildefender.net --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ 10/12/2007NOT INTENDED AS A SUBSTITUTE FOR A WRITING NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A PART, OR IN ANY ATTACHMENTS THERETO, SHALL CONSTITUTE A BINDING CONTRACT, OR ANY CONTRACTUAL OBLIGATION BY PNY, OR ANY INTENT TO ENTER INTO ANY BINDING OBLIGATIONS, NOTWITHSTANDING ANY ENACTMENT OF THE UNIFORM ELECTRONIC TRANSACTIONS ACT, THE FEDERAL E-SIGN ACT, OR ANY OTHER STATE OR FEDERAL LAW OF SIMILAR SUBSTANCE OR EFFECT. THIS EMAIL MESSAGE, ITS CONTENTS AND ATTACHMENTS ARE NOT INTENDED TO REPRESENT AN OFFER OR ACCEPTANCE OF AN OFFER TO ENTER INTO A CONTRACT. NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A PART, OR IN ANY ATTACHMENTS THERETO SHALL ALTER THIS DISCLAIMER. This e-mail message
Re: [U2] RE: Universe Replication
The problem I ran into with replication (UV on Linux), is that if the subscriber system was off-line or the subscriber process not running, writes on the publisher would cause the writing application to hang and eventually error. Since our goal was to the use subscriber system for reporting as well as testing, this caused a problem whenever the back-up system need to be rebooted or taken off-line. We concluded that we needed something more asynchronous that would allow buffered updates to the back-up system. Other problems, such as managing many published files spread over many accounts, and the fact that type 1/19 files are not replicated, caused us to abandon replication. However, it is likely that IBM has continued to improve replication and my problems may not have been typical. But I am curious if a work-around to allow buffering of updates to the subscriber system was ever developed, because for us that was a stopper. /Scott Ballinger Pareto Corporation Edmonds WA USA 206 713 6006 On Dec 10, 2007 4:06 AM, Barry Rogen [EMAIL PROTECTED] wrote: Robin, We attempted (operative word) to embrace Replication for a solution to our needs. We are a little different, in that we are running Unix. We have a D/R system off site and the primary/production box here. Our intentions were similar, to establish a scenario where our second system would not only be our D/R, but allow us to offload many of our reportings from the production system. Data Replication was touted as the solution. A solution that would update our D/R system real time from our production system. If you would like to discuss in further detail, off line, U2's Data Replication solution (in the real world), I would be more that happy to spend some time. Barry Rogen PNY Technologies, Inc. Senior Programmer/Analyst (973) 515 - 9700 ext 5327 [EMAIL PROTECTED] - Far better it is to dare mighty things, to win glorious triumphs even though checkered by failure, than to rank with those poor spirits who neither enjoy nor suffer much because they live in the gray twilight that knows neither victory nor defeat.t. roosevelt -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of LeRoy Dreyfuss Sent: Sunday, December 09, 2007 6:35 AM To: u2-users@listserver.u2ug.org Subject: [U2] RE: Universe Replication Hello Robin, 10.2.x is still pretty new, even though it has been out a whole year now. With most busy organizations, uptake on a new release can be pretty slow, so I doubt many folks have it going in a production environment. When I worked for the U2 group, I did quite a bit of testing with replication. It is ideal for what you propose to use it for. In 10.2, the services changed to improve overall replication performance and recoverability after a network outage. If you've never set it up before, there are some things to consider first. For example, how reliable are the file pointers? Can everyone of the file pointers be opened? Are they referencing files that live in other file systems and not where the account itself exists? Replication expects that the files not be UV/NET files and will skip them when you start looking for files within accounts to publish. Like transaction logging, replication ships with TCL verbs to greatly speed up the selection, publish, and subscribe process when there are many files per account to be replicated. They are documented in the UV 10.2 documentation set. I made improvements to two of those programs-- just ping me off-line if you'd like the updated programs. I intend to deploy replication across my Linux servers, with transaction logging running on each server as well. I am confident with 10.2's ability to handle them both quite well in the scenario I chose to deploy them. I believe I can tell you quite a bit more about the process if you want to write me off-line. Regards, LeRoy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Robin Smith Sent: Friday, December 07, 2007 10:59 PM To: u2-users@listserver.u2ug.org Subject: [U2] Universe Replication We are about to install Universe File Replication on a Windows 2003 server, using Universe 10.2.3 with replication to a similarly specified Subscriber Server. The subscriber will be used for reporting purposes to reduce the load on the publishing server. Most of the reporting is done via UVODBC. Has anyone had experience of installing Universe Replication in a Windows 2003 server environment? How stable is it? What problems have you encountered along the way? Any help/tips/advice would be much appreciated. Robin Smith Reflex Data Systems Ltd Tel: 01482 881152 Fax:01482 881195 Registered Office: Reflex House, Tokenspire Business Park, Beverley, East Yorkshire, HU17
RE: [U2] RE: U2 SOAP Server
You get such great information on this list. Based on the comments since I posted last Friday we have been doing some experiments. I believe it would be best for us to develop Web Services in a Windows environment then deploy to a Linux SOAP Server. We have managed to transfer the files for a Web Service (test.xml and test.wsdl) from one Windows PC running the Development tools to a second Windows PC also running the Development tools. Each had a SOAP Server pointing to the same Linux based Universe 10.2 database. This was successful. Next we tried to incorporate this into a Service on an Oracle Enterprise Service Bus (ESB) on my PC. This almost worked but not quite. Unfortunately I appear to have broken the ESB rather badly so progress has stopped until I can work out how to fix it. Lots of nasty java error messages. Our aim is to have our 4 environments - Development, Test, Pre-Prod and Production each able to have a version of the Oracle ESB running with the appropriate U2 SOAP Server connecting to the applicable UV account. Ideally we would not want to have to change the internals of the WSDL or other code. Server names and ports are listed multiple times within the XML code. Our thought was to place the ESB and the U2 SOAP Server on the same hardware and use localhost and the same port. We hoped that config files would enable this. We still have more experimentation to do in this area. Moving to this industry standards methodology is a very steep learning curve. The creation of the U2 WSDL from an existing subroutine was a breeze. I wish the rest was as simple. Back to the manuals. Sara Burns Sara Burns (SEB) IS Development Manager Public Trust Phone: +64 (04) 978 4534 (DDI) Mobile: 029 978 4534 mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] The information contained in this communication (including any attachment) is confidential. If you are not the intended recipient, please destroy this communication. You must not disclose, copy or use in any way the information contained in this communication. Any views expressed in this communication are not necessarily the views of Public Trust. No representation is made that this communication is free of error, virus or interference. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: U2 SOAP Server
In my experience that is the wonderful world of Java By contrast you can write your own web service in asp.net, using uniobjects.net and connection pooling (or not if you donbt want it) in about 30 minutes end to end and 30 lines of vb.net or c# or j# etc code -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sara Burns Sent: 04 December 2007 08:17 To: u2-users@listserver.u2ug.org Subject: RE: [U2] RE: U2 SOAP Server You get such great information on this list. Based on the comments since I posted last Friday we have been doing some experiments. I believe it would be best for us to develop Web Services in a Windows environment then deploy to a Linux SOAP Server. We have managed to transfer the files for a Web Service (test.xml and test.wsdl) from one Windows PC running the Development tools to a second Windows PC also running the Development tools. Each had a SOAP Server pointing to the same Linux based Universe 10.2 database. This was successful. Next we tried to incorporate this into a Service on an Oracle Enterprise Service Bus (ESB) on my PC. This almost worked but not quite. Unfortunately I appear to have broken the ESB rather badly so progress has stopped until I can work out how to fix it. Lots of nasty java error messages. Our aim is to have our 4 environments - Development, Test, Pre-Prod and Production each able to have a version of the Oracle ESB running with the appropriate U2 SOAP Server connecting to the applicable UV account. Ideally we would not want to have to change the internals of the WSDL or other code. Server names and ports are listed multiple times within the XML code. Our thought was to place the ESB and the U2 SOAP Server on the same hardware and use localhost and the same port. We hoped that config files would enable this. We still have more experimentation to do in this area. Moving to this industry standards methodology is a very steep learning curve. The creation of the U2 WSDL from an existing subroutine was a breeze. I wish the rest was as simple. Back to the manuals. Sara Burns Sara Burns (SEB) IS Development Manager Public Trust Phone: +64 (04) 978 4534 (DDI) Mobile: 029 978 4534 mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] The information contained in this communication (including any attachment) is confidential. If you are not the intended recipient, please destroy this communication. You must not disclose, copy or use in any way the information contained in this communication. Any views expressed in this communication are not necessarily the views of Public Trust. No representation is made that this communication is free of error, virus or interference. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: U2 SOAP Server
Thanks! Now I can at least start exploring. I've been making fair progress getting a small ruby script to talk to it, with an eye towards eventually hooking it up with some rails work a fellow programmer has been working on. -- Dave Walker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Hona, David S Sent: Monday, December 03, 2007 1:08 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] RE: U2 SOAP Server Here's what I've managed to work out so far (it would be nice of IBM U2 Support) could confirm/deny... A) To invoke the SOAPServer without starting up U2WSD (on Wintel): X:\ibm\tools\RunSOAPServer.bat SOAPServerName (See the -classpath for the plugs-in that are required to run the U2 UniSOAP server) B) If you wish to migrate to another server or environment, update the SOAPServerName details in: (mostly self-explanatory): X:\ibm\tools\U2SOAP.config C) Log files created (if debug mode is on): SOAP server optional debug file: X:\ibm\u2soap\SOAPServerName\SOAPServerName.log UniObject sessions trace log file: X:\ibm\tools\uoj_trace.log D) Key directories with JAR files required: X:\ibm\tools\plugins\com.ibm.u2.unisoap_1.0.0\ X:\IBM\Tools\plugins\com.ibm.u2.uoj_1.0.0\ Regards, David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of LeRoy Dreyfuss Sent: Saturday, December 01, 2007 11:33 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] RE: U2 SOAP Server Hey folks, Just thought I'd take a second to reply back to the recent posts... The SOAP Server included with U2WSD gets installed when you install the tool. There isn't an option (during install) to install the SOAP Server by itself or elsewhere. That doesn't mean you can't relocate the SOAP Server somewhere else when you are ready to deploy. If you have no GUI desktop (Gnome/KDE/etc.) on your Linux server, then it will be hard to install U2WSD on that platform (and as such, gain access to the SOAP Server). That wouldn't be an issue for Windows server users since Windows has a GUI desktop. At the end of the day, the SOAP Server is just a simple Jetty server enhanced to communicated only with U2 servers enabled for it. It is really light-weight. You don't have to fire up U2WSD to start/stop it, but I don't believe IBM includes that tidbit of info in there documentation. Regards, LeRoy --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/