RE: 2 gig limits
On the version of Unix we're running (SCO 3.2), you can't even create a FILESYSTEM over 2Gb - we had to partition our 4Gb drives in two ... (that dates the system :-) Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Logan, David (SST - Adelaide) Sent: 10 February 2004 20:52 To: U2 Users Discussion List Subject: RE: 2 gig limits It would have to be a 64bit file, there are no exceptions as this is a limitation brought on by the size of a number. (I think a couple of earlier posters had the numbers involved) therefore you literally cannot create a file larger than 2Gb with 32 bit addressing. *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
(no subject)
[EMAIL PROTECTED] -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
SQL Server and Crystal Reports
I would like to know the best beginning books for either of these two topics. I don't yet want a reference, rather to know if 'Dummies' Books are appropriate or if anyone else has better beginning selections. My UD client migrating to these wants to keep me and this is the environment. thanks. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: SQL Server and Crystal Reports
Mark, Not quite an answer to your question, but the first thing I would do would be to get your client to set up an MSDN subscription. The library will help you loads once you get past the initial learning curve and need to see how to do things, and has sample applications to check out. Remember that if you want to 'play', you can load a copy of the MSDE (Microsoft Data Engine) which is fully SQL server compatible (available with professional versions of Office, Visual Studio 6 and .Net) but has a smaller footprint and no licence requirements. As well as SQL Server, (SQL and TransactSQL) you will probably need to know about the various interfaces, so the MSDN is a good choice for reference materials on subjects such as OleDB (ADO). I don't know what the various editions cost - we get the Enterprise edition which is pricey, but not for what you get, and includes a 10 user SQL server licence as well as licences for all the MS platforms, office versions, development tools etc. If your client wants to retain you this could be a very good investment on their part. Regards, Brian Leach -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson Sent: 11 February 2004 12:17 To: [EMAIL PROTECTED] Subject: SQL Server and Crystal Reports I would like to know the best beginning books for either of these two topics. I don't yet want a reference, rather to know if 'Dummies' Books are appropriate or if anyone else has better beginning selections. My UD client migrating to these wants to keep me and this is the environment. thanks. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This email was checked by MessageLabs SkyScan before entering Microgen. This email was checked on leaving Microgen for viruses, similar malicious code and inappropriate content by MessageLabs SkyScan. DISCLAIMER This email and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information. In the event of any technical difficulty with this email, please contact the sender or [EMAIL PROTECTED] Microgen Information Management Solutions http://www.microgen.co.uk -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Login question for Universe/SB+
No, you're correct. But if you're going to rely on the universe login for security, you can set all the SB+ passwords to the same thing. -Dianne Bruce Lunt wrote: What caught my attention was MYPASSWORD. I assumed (maybe wrongly?) that that was an ASCII string in the VOC. If that can be found by others then my password is not very secure. Or did I misunderstand? R. Bruce Lunt 408.832.1900 cell From: Bruce Lunt [EMAIL PROTECTED] Reply-To: U2 Users Discussion List [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: Login question for Universe/SB+ Date: Tue, 10 Feb 2004 13:31:20 -0800 Is there a way to do this so that MYPASSWORD is encrypted? R. Bruce Lunt From: Dianne Ackerman [EMAIL PROTECTED] Reply-To: U2 Users Discussion List [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Subject: Re: Login question for Universe/SB+ Date: Tue, 10 Feb 2004 15:58:33 -0500 Jason Theis wrote: All, We use UniVerse/NT and SB+. It seems redundant to have to login to UniVerse with a valid user and password, then choose an account, and then login to SB+ with a user and password. What options do we have to avoid this redundant entry. Is there a way to pass the user's authentication information to UniVerse, or the Universe information to SB+? Thanks. You can put an entry in the VOC of the SB+ account for the user's name which looks like the following: dianne 001 PA 002 SB.LOGIN 003 DATA DIANNE 004 DATA MYPASSWORD The DIANNE on line 3 is the System Builder user and the MYPASSWORD on line 4 is the user's password. -Dianne -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
D3 on NT
Although I have been working in many pick flavors for the past 20+ years, I have been working in Universe for the past 8 years. I have a client that is looking for a conversion out of D3/NT to Oracle. I have two questions; 1. does D3 support the OPENSEQ and WRITESEQ that Universe does. I downloaded the d3 basic manual and found the UOPEN and UCREATE. 2. Could the D3 experts in the group please offer any suggestion and information about there experiences in conversions from D3. I know that this is not the direction that we would like to see software going in, but I did not make the decision about the companys IS goals. Dahn Finard -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: [UD] stopudt and recycled pids
[EMAIL PROTECTED] wrote... I can't help with the sleep question on stopudt but I just want to point out that listuser and deleteuser are actually OS level commands. This means that your administrators don't need to access your system to issue the deleteuser command. They can even do the listuser to make sure they get the right pid. Aargh - you sound like IBM support :-). It's also that it's only the users of the system who know that someone needs logging off, and in this day of IT outsourcing they'd need to raise a support call with their IT department to get a process logged off - a bit trickier than doing it themselves with a button on the list user screen. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
HPUX 11 to 11i upgrade, UV10.0.16. Any gotchas?
I am particularilly interested in knowing whether Universe adapted well to the new OS version for you. It is certified for both. But I would be more than happy to know of any 11-11i hiccoughs unrelated to UV, too. Thanks, Charles Stevenson -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Avante/Infoflo training.
I have a client that is looking for Avante/Infoflo user training in accounting and inventory control. What is available outside Epicor. Dave Raven Mobile(949) 228 2224 e Fax (815)4259364 P.O. Box 17811, Irvine CA 92623-7811 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Avante/Infoflo training.
http://msg.epicor.com/msg/Services/Education/default.htm Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dave Raven Sent: Wednesday, February 11, 2004 11:31 AM To: [EMAIL PROTECTED] Subject: Avante/Infoflo training. I have a client that is looking for Avante/Infoflo user training in accounting and inventory control. What is available outside Epicor. Dave Raven Mobile(949) 228 2224 e Fax (815)4259364 P.O. Box 17811, Irvine CA 92623-7811 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Using the Telnet via SSL feature on wIntegrate and uniVerse 1 0.1
Hmm... interesting. Does anyone know if this works with Dynamic Connect instead of wIntegrate? I may have to try this when I get a few spare minutes to play with it. Re Ian Foster's original question - if you're wedded to SSL for some reason you may want to take a look at stunnel (www.stunnel.org). It looks like it would be a lot more work to set up than SSH via Putty though. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 11, 2004 9:01 AM To: U2 Users Discussion List Subject: Re: Using the Telnet via SSL feature on wIntegrate and uniVerse 10.1 At 06:27 AM 2/11/2004, you wrote: Has anyone had any success setting up wIntegrate 5.1 to connect to a uniVerse 10.1 server using the Telnet via SSL feature. I have not done it but here is a write up IBM put out in a newsletter on how to make a SSH tunnel. I think this is what you were looking for as opposed to SSL. Using SSH security with wIntegrate DESCRIPTION: *Secure Shell (SSH), sometimes known as Secure Socket Shell, is a Unix-based command interface and protocol for securely getting access to a remote computer. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: D3 on NT
Is the conversion to an existing ORACLE application or is your client writing a new Oracle application? Also, how old is the D3? Does it support ODBC? Pull the data out by ODBC to a TEXT ODBC target and then load it into Oracle. If it's a new application, you might want to take a look at ON-WARE. It's a product that will allow you to keep the business rules within your application but use Oracle as a datastore. Chees, Ray D - Original Message - From: Dahn Finard [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Wednesday, February 11, 2004 6:23 AM Subject: D3 on NT Although I have been working in many pick flavors for the past 20+ years, I have been working in Universe for the past 8 years. I have a client that is looking for a conversion out of D3/NT to Oracle. I have two questions; 1. does D3 support the OPENSEQ and WRITESEQ that Universe does. I downloaded the d3 basic manual and found the UOPEN and UCREATE. 2. Could the D3 experts in the group please offer any suggestion and information about there experiences in conversions from D3. I know that this is not the direction that we would like to see software going in, but I did not make the decision about the companys IS goals. Dahn Finard -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UV on SCO Unix
Why not Linux? -Original Message- From: Brutzman, Bill [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 11, 2004 10:35 AM To: 'U2 Users Discussion List' Subject: UV on SCO Unix We bought the year-end UV amnesty upgrade from IBM. Because of an existing ERP license agreement, we need to stay with Unix. While I would prefer to stay with HP-Ux, pricing for a new HP-Ux server seems to be approaching $10,000. Right now, I am not sure if it makes any sense to upgrade hardware in our HP-9000-E45 box. We would rather spend $3k. Thus, I am considering running SCO on say a Dell server. Any comments on running UV on SCO ? Perhaps there is another Unix besides SCO... Bill Brutzman, Manager IT HK MetalCraft Mfg Corp PO Box 775 35 Industrial Road Lodi NJ 07644-0775 973.471.7770 x145 .voice 973.471.9666 .fax [EMAIL PROTECTED] www.hkMetalCraft.com -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UV on SCO Unix
I would prefer to go with RedHat... The license agreement says Unix. The platform migration fee is ~$10k. I suspect that their lawyer would say that while Linux may be a flavor of Unix, we would still be on the hook to pay the migration fee. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Jeff Schasny Sent: Wednesday, February 11, 2004 12:33 PM To: U2 Users Discussion List Subject: RE: UV on SCO Unix Why not Linux? -Original Message- From: Brutzman, Bill [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 11, 2004 10:35 AM To: 'U2 Users Discussion List' Subject: UV on SCO Unix We bought the year-end UV amnesty upgrade from IBM. Because of an existing ERP license agreement, we need to stay with Unix. While I would prefer to stay with HP-Ux, pricing for a new HP-Ux server seems to be approaching $10,000. Right now, I am not sure if it makes any sense to upgrade hardware in our HP-9000-E45 box. We would rather spend $3k. Thus, I am considering running SCO on say a Dell server. Any comments on running UV on SCO ? Perhaps there is another Unix besides SCO... Bill Brutzman, Manager IT HK MetalCraft Mfg Corp PO Box 775 35 Industrial Road Lodi NJ 07644-0775 973.471.7770 x145 .voice 973.471.9666 .fax [EMAIL PROTECTED] www.hkMetalCraft.com -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: UV on SCO Unix
I would not put ANYTHING on SCO. Have a look here http://www.groklaw.net and here http://yro.slashdot.org/search.pl?topic=88 for specifics. If you need a better HP server, consider purchasing a used machine that has come off lease. You may be surprised at how far 3k will go. If you must stay with Unix and pc type hardware, go with SuSE, Debian or Redhat. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: D3 on NT
From my understanding it does have the ODBC but the ODBC is blowing up when they attempt to use it. They want to extract the data to the Oracle tables. Dahn -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Ray Daignault Sent: Wednesday, February 11, 2004 12:34 PM To: U2 Users Discussion List Subject: Re: D3 on NT Is the conversion to an existing ORACLE application or is your client writing a new Oracle application? Also, how old is the D3? Does it support ODBC? Pull the data out by ODBC to a TEXT ODBC target and then load it into Oracle. If it's a new application, you might want to take a look at ON-WARE. It's a product that will allow you to keep the business rules within your application but use Oracle as a datastore. Chees, Ray D - Original Message - From: Dahn Finard [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Wednesday, February 11, 2004 6:23 AM Subject: D3 on NT Although I have been working in many pick flavors for the past 20+ years, I have been working in Universe for the past 8 years. I have a client that is looking for a conversion out of D3/NT to Oracle. I have two questions; 1. does D3 support the OPENSEQ and WRITESEQ that Universe does. I downloaded the d3 basic manual and found the UOPEN and UCREATE. 2. Could the D3 experts in the group please offer any suggestion and information about there experiences in conversions from D3. I know that this is not the direction that we would like to see software going in, but I did not make the decision about the companys IS goals. Dahn Finard -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UV on SCO Unix
Bill, We have run UniVerse on Linux for years (actually about 10 years, originally using the SCO emulation package for Linux). If you know your way around Linux, and if it is UNIX-y enough for you, we have always found it to be solid. Regards, Brian Leach -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill Sent: 11 February 2004 17:35 To: 'U2 Users Discussion List' Subject: UV on SCO Unix We bought the year-end UV amnesty upgrade from IBM. Because of an existing ERP license agreement, we need to stay with Unix. While I would prefer to stay with HP-Ux, pricing for a new HP-Ux server seems to be approaching $10,000. Right now, I am not sure if it makes any sense to upgrade hardware in our HP-9000-E45 box. We would rather spend $3k. Thus, I am considering running SCO on say a Dell server. Any comments on running UV on SCO ? Perhaps there is another Unix besides SCO... Bill Brutzman, Manager IT HK MetalCraft Mfg Corp PO Box 775 35 Industrial Road Lodi NJ 07644-0775 973.471.7770 x145 .voice 973.471.9666 .fax [EMAIL PROTECTED] www.hkMetalCraft.com -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This email was checked by MessageLabs SkyScan before entering Microgen. This email was checked on leaving Microgen for viruses, similar malicious code and inappropriate content by MessageLabs SkyScan. DISCLAIMER This email and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information. In the event of any technical difficulty with this email, please contact the sender or [EMAIL PROTECTED] Microgen Information Management Solutions http://www.microgen.co.uk -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UV on SCO Unix
We are in the process of switching from DG intel to IBM intel running Red Hat Linux. We don't have the IBM server yet. We are currently experimenting with a Dell Poweredge server with Red Hat AS 2.1. All of our Universe files and apps convert over just fine. I really cant put a full load on it to give it a true test. However, it has been blowing the doors off the old system (sselect on 721657 records Red Hat/Dell = 1min 12 sec, DG = 11min 10sec). Nothing has crashed yet, no core dumps. Red Hat is as expensive or as cheap as you want it to be depending on what support option you purchase. Isn't it true that the SCO code is now in Red Hat anyway ;) ? Guess we'll find out when the dust settles. Anyway, I would say that it is worth a look. We're very happy with it so far. We are a small Universe shop - 100 users realtime point of sale. Anthony Dzikiewicz IT Manager Alperts Furniture -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill Sent: Wednesday, February 11, 2004 12:35 PM To: 'U2 Users Discussion List' Subject:UV on SCO Unix We bought the year-end UV amnesty upgrade from IBM. Because of an existing ERP license agreement, we need to stay with Unix. While I would prefer to stay with HP-Ux, pricing for a new HP-Ux server seems to be approaching $10,000. Right now, I am not sure if it makes any sense to upgrade hardware in our HP-9000-E45 box. We would rather spend $3k. Thus, I am considering running SCO on say a Dell server. Any comments on running UV on SCO ? Perhaps there is another Unix besides SCO... Bill Brutzman, Manager IT HK MetalCraft Mfg Corp PO Box 775 35 Industrial Road Lodi NJ 07644-0775 973.471.7770 x145 .voice 973.471.9666 .fax [EMAIL PROTECTED] www.hkMetalCraft.com -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: SQL Server and Crystal Reports
Mark, I don't know about SQL books, but I have found the Crystal manuals to be all that I needed to customize forms for our clients who have used Crystal Reports. The manuals are pretty good - they included enough examples to get me going! Susan M. Lynch F.W. Davison Company, Inc. - Original Message - From: Mark Johnson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, February 11, 2004 7:16 AM Subject: SQL Server and Crystal Reports I would like to know the best beginning books for either of these two topics. I don't yet want a reference, rather to know if 'Dummies' Books are appropriate or if anyone else has better beginning selections. My UD client migrating to these wants to keep me and this is the environment. thanks. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
[OT] - UCCnet
This is not at all UV related... If there is anybody out there that has made a commitment to UCCnet and would not mind discussing this issue offline, please let me know. It is a major issue facing us corporately and if I could tap into some experience, it would be very helpful. Barry Rogen Senior Programmer PNY Technologies (973) 515 - 9700 ext 5327 [EMAIL PROTECTED] _ The quality of a person's life is in direct proportion to their commitment to excellence regardless of their chosen field of endeavor vince lombardi _ -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UV on SCO Unix
They just want us to pay them American dollars. They messed up on the licensing agreement. They re-wrote the agreement to cover our existing situation and merely specifed Unix. Right now, they regret the way they wrote this license agreement. They want customers to pay for a platform migration from anything to anything else. While I offered them $1k for a single sheet of paper, they want more like $10k. --Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Jefferson, Jim Sent: Wednesday, February 11, 2004 1:33 PM To: U2 Users Discussion List Subject: RE: UV on SCO Unix I guess what I'm saying is that HP-UX is a flavor of Unix. If they don't have a problem with you moving from HP-UX to SCO, they shouldn't have one if you choose AIX or Redhat or SuSE instead. I wonder if the restriction is there to cover them if you chose to move to Windows? Jim -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill Sent: Wednesday, February 11, 2004 12:33 PM To: 'U2 Users Discussion List' Subject:RE: UV on SCO Unix Maybe they should have...but they did not. It looks like ...will provide a non-exclusive license for the licensee to use the following Application Software and Documentation at fees shown below on one _ Unix _ Computer to be located only at Licensee's Installation Address, under the Terms and Conditions shown on the reverse. --Bill -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UV on SCO Unix
Are they going to have to support the application and provide upgrades after the migration? And do or assist with the migration? The unique variations can be bothersome if they make extensive use of O/S utilities and functions. If you're totally self-sufficient and this is just a paperwork thing, and they don't use Unix in the sense of a trademarked product name, you may be in the catbird seat. However, I'm no lawyer (thought I've done one or two other things in my life I'm not terribly proud of grin). Jim -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill Sent: Wednesday, February 11, 2004 12:52 PM To: 'U2 Users Discussion List' Subject:RE: UV on SCO Unix They just want us to pay them American dollars. They messed up on the licensing agreement. They re-wrote the agreement to cover our existing situation and merely specifed Unix. Right now, they regret the way they wrote this license agreement. They want customers to pay for a platform migration from anything to anything else. While I offered them $1k for a single sheet of paper, they want more like $10k. --Bill -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Universe/RedBack on Linux
Yes for UniVerse but not RedBack (at the moment). I will be curious to see what you find and what you do here. Regards, T. - Original Message - From: Baruch Salamander [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, February 12, 2004 9:01 AM Subject: Universe/RedBack on Linux Is anyone out there using Universe and RedBack on Linux? If so, how's the performance? For those who are not on Linux, are you considering Linux as an option for the future? -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
UV command failing mystery - RESOLUTION
I had the following kernel parameters changed over the weekend: SDELSIM 256 to 1024 SEMOPM 64 to 100 SEMUME 64 to 1024 SHMMNI 2048 to 4096 SEMMNI 2048 to 4096 SEMMSL 256 to 1024 And the problem has not occurred since! I have reviewed the documentation on each of the above parameters in hopes of determining which parameter was set incorrectly. SDELSIM - The default number of file descriptors per process. (Referred to as NOFILES in the UV documentation.) I had set SDELSIM to exceed MFILES plus the 8 internal UV files. HDESLIM (the maximum number of file descriptors a user is allowed to have open) was left at the default value of 1024. SEMOPM - The maximum number of semaphore operations per semop (2) call. Although not a parameter mentioned in the UV documentation I had concluded from some Unix documentation that the value of 100 was unnecessarily large and had reduced the value to 64. The default value is 10. SEMUME - The maximum number of Undo entries per Undo structure. Also not a parameter mentioned in the UV documentation, a reading (mis-reading) of the Unix documentation led me to conclude that the value was unnecessarily large. Since I have now learned that the default value is 1024 this change is suspect. SHMMNI - The maximum number of shared memory segments that may exist in the system at one time. The UV documentation recommends setting this to a number greater than the maximum number of concurrent Universe users plus 2. Our UV user count has not exceeded 700 users in the last few months. SEMMNI - The maximum number of semaphore sets. The UV documentation states that Universe requires 2 semaphore sets. The ipcs -s command reports that our system uses 7. SEMMSL - The maximum number of semaphores per set. The UV documentation states that this should be at least equal to FSEMNUM + GSEMNUM + 5. On our system that total is 152. I still am not sure which parameter(s) were the source of the problem. And I intend to leave well enough alone so I may never know for sure. In any case I hope that if someone else encounters the same problem they can benefit from my experience. I want to thank everyone who offered help and took the time to make suggestions. Vance Dailey -Original Message- From: Vance Dailey [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 03, 2004 5:23 PM To: '[EMAIL PROTECTED]' Subject:UV command failing mystery We are having a very strange intermittent problem with the UV command not working from Unix. Occasionally, after a user logs into Unix (without noticing anything unusual) typing UV simply returns the user to the UNIX shell almost instantly. When the problem occurs it seems to affect everyone who logins in and attempts to go into Universe for a period of time and then the problem seems to resolve itself. Any users who logged into Unix during that period of time still can not go into Universe but new logins work fine. The problem seems to be with Universe. Unix commands work fine and when we have tried executing other Universe commands which normally can be run from Unix they fail also. The Unix login script seems to run fine. When the problem occurs users already in Universe notice no problems. No unusual locks or performance problems have been noticed. The problem does not seem to be load related since it happens at apparently random times including times when very few users are logged in. We have been running 9.6.2.2 on DG/UX for several years and have never had the problem until the last couple of months. The only thing that may be suspicious is some changes we made to some kernel and UV config settings a few weeks prior to the first reported problem. The following changes were made: (KERNEL) SDELSIM 2048 TO 256 SEMOPM 100 TO 64 SEMUME 1024 TO 64 SHMMNI 4096 TO 2048 SEMMNI 4096 TO 2048 (UV CONFIG) MFILES 56 TO 200 T30FILE 8000 TO 200 (we have no dynamic files) FSEMNUM 101 TO 50 GSEMNUM 211 TO 97 GLTABSZ 150 TO 75 RLTABSZ 150 TO 75 MAXRLOCK 100 TO 74 Any help solving this puzzle would be greatly appreciated. Thanks, Vance Dailey -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: UV on SCO Unix
At 04:34 AM 12/02/2004, Brutzman, Bill wrote: We bought the year-end UV amnesty upgrade from IBM. Because of an existing ERP license agreement, we need to stay with Unix. I believe i read recently you can now transfer U2 between platforms without paying the 15% transfer fee(Yay!). So the transfer fee is just for your ERP vendor only? While I would prefer to stay with HP-Ux, pricing for a new HP-Ux server seems to be approaching $10,000. Right now, I am not sure if it makes any sense to upgrade hardware in our HP-9000-E45 box. Yikes! an E45 goes a way back: http://www.openpa.net/systems/e-class.html processor 100mhz, roughly equivalent to a mid range pentium. We would rather spend $3k. Thus, I am considering running SCO on say a Dell server. Any comments on running UV on SCO ? I would say you could easily spend a large part of the $7000 in savings transferring to another platform with various porting issues that always seem to come up. Perhaps there is another Unix besides SCO... Solaris x86 in linux compatibility mode if you are desperate ;-) This is what i would try in order: 1) Talk to ERP sales rep to get them to clarify unix as including linux(maybe offer a separate payment for this service). 1a) If above does not work complain to sales rep boss + all of your management about situation. 2) 2nd hand hpux server ie on ebay today( rp5400 dual 440mhz 2.5G ram 72G hd for $3750) 3) Reconditioned solaris or ibm 4) Linux 5) Windows 6) Update resume and quit 7) Consider SCO If using a reconditioned unit might also need to spend some getting it back under maintenance. - Robert -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UV on SCO Unix
I can only agree to placing option 7 where it is, I would seriously look at an X86 server running a couple of Xeon processors at 2.4Ghz or quicker. If you have good Unix skills, take a long look at Linux, the price is right and there haven't been too many complaints on the list about the Universe product on Linux. Regards David Logan Database Administrator HP Managed Services 139 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 +61 417 268 665 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Robert Colquhoun Sent: Thursday, 12 February 2004 9:13 AM To: U2 Users Discussion List Subject: Re: UV on SCO Unix At 04:34 AM 12/02/2004, Brutzman, Bill wrote: We bought the year-end UV amnesty upgrade from IBM. Because of an existing ERP license agreement, we need to stay with Unix. I believe i read recently you can now transfer U2 between platforms without paying the 15% transfer fee(Yay!). So the transfer fee is just for your ERP vendor only? While I would prefer to stay with HP-Ux, pricing for a new HP-Ux server seems to be approaching $10,000. Right now, I am not sure if it makes any sense to upgrade hardware in our HP-9000-E45 box. Yikes! an E45 goes a way back: http://www.openpa.net/systems/e-class.html processor 100mhz, roughly equivalent to a mid range pentium. We would rather spend $3k. Thus, I am considering running SCO on say a Dell server. Any comments on running UV on SCO ? I would say you could easily spend a large part of the $7000 in savings transferring to another platform with various porting issues that always seem to come up. Perhaps there is another Unix besides SCO... Solaris x86 in linux compatibility mode if you are desperate ;-) This is what i would try in order: 1) Talk to ERP sales rep to get them to clarify unix as including linux(maybe offer a separate payment for this service). 1a) If above does not work complain to sales rep boss + all of your management about situation. 2) 2nd hand hpux server ie on ebay today( rp5400 dual 440mhz 2.5G ram 72G hd for $3750) 3) Reconditioned solaris or ibm 4) Linux 5) Windows 6) Update resume and quit 7) Consider SCO If using a reconditioned unit might also need to spend some getting it back under maintenance. - Robert -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: D3 on NT
Tony, Could you do me a favor and not declare my entire market segment dead. You now have the keys to data integration heaven and you don't need to buy any more tools or migration services. The fact is, I could move data from any system to any other system before XML, we all could. The question is always the 'time value of money' equation. If a tool makes things work more consistently, faster, and with less setup time I still see a value. - Charles Barouch Tony Gravagno wrote: Without purchasing extra software, probably the easiest thing to do in a migration these days is to take advantage of free .NET features which allow seamless exchanges between XML and ADO.NET: 1) It's simple to write code to wrap data in XML. 2) You can use a program provided with the .NET Framework to generate a Schema from the XML into a .XSD file. 3) ADO.NET imports XSD files to create an internal map of a dataset. 4) With one line of code ADO.NET can read XML and store the data as a relational dataset. Connecting the dots: It's easy to go from any MV platform into XML, then into ADO.NET, and from there to any Relational DBMS. And now that I've let the cat out of the bag, I have to retire a poor man. You now have the keys to data integration heaven and you don't need to buy any more tools or migration services. Seriously the way the technology is implemented depends on the application. If you ARE interested in data migrations From any platform To any platform, I'll be happy to help. Tony Nebula RD Former D3 DBMS Product Manager, Raining Data Technical Editor, C#Builder Kick Start, SAMS Publishing Author, Web Services and .NET series, Spectrum Magazine -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: D3 on NT
Notice my next paragraph begins with the word Seriously Yes XML has been usuable as a connectivity medium for years, but how many people are taking advantage of it? Microsoft and other companies are continually developing tools to reduce the time and money aspect of using XML, and make it easier to make use of relational databases, but I doubt most MV users or developers are keeping up with the details. No matter how much free information is available, I don't seriously think professionals like us who provide information, products, and services will go out of business anytime soon. ETL tools are always in vogue. Tony Tony, Could you do me a favor and not declare my entire market segment dead. You now have the keys to data integration heaven and you don't need to buy any more tools or migration services. The fact is, I could move data from any system to any other system before XML, we all could. The question is always the 'time value of money' equation. If a tool makes things work more consistently, faster, and with less setup time I still see a value. - Charles Barouch Tony Gravagno wrote: Without purchasing extra software, probably the easiest thing to do in a migration these days is to take advantage of free .NET features which allow seamless exchanges between XML and ADO.NET: 1) It's simple to write code to wrap data in XML. 2) You can use a program provided with the .NET Framework to generate a Schema from the XML into a .XSD file. 3) ADO.NET imports XSD files to create an internal map of a dataset. 4) With one line of code ADO.NET can read XML and store the data as a relational dataset. Connecting the dots: It's easy to go from any MV platform into XML, then into ADO.NET, and from there to any Relational DBMS. And now that I've let the cat out of the bag, I have to retire a poor man. You now have the keys to data integration heaven and you don't need to buy any more tools or migration services. Seriously the way the technology is implemented depends on the application. If you ARE interested in data migrations From any platform To any platform, I'll be happy to help. Tony Nebula RD Former D3 DBMS Product Manager, Raining Data Technical Editor, C#Builder Kick Start, SAMS Publishing Author, Web Services and .NET series, Spectrum Magazine -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UNCLASSIFIED RE: Universe / ODBC
Hey hey ! I've just looked at our readme file and it appears our problem is issue #11264. Extract from readme file: = Problems Fixed in UniVerse ODBC Client Version 3.7.r2 = So this appears to be the same as what you've got, but where I got my numbers from was the windows odbc manager, when looking at a list of drivers the version number appears in one column - that's where the 3.07.02.1084 appears. Regards, Andrew -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Universe/RedBack on Linux
We learned the hard way that you must have Windows IIS front end for Redback to run the ASP code. We are currently converting many green screen programs to Redback for a client running on Linux using our tool XLr8. Response time for this 4 processor system is very good. - Original Message - From: Baruch Salamander [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, February 11, 2004 3:01 PM Subject: Universe/RedBack on Linux Is anyone out there using Universe and RedBack on Linux? If so, how's the performance? For those who are not on Linux, are you considering Linux as an option for the future? -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Universe/RedBack on Linux
There are a few modules on Apache that run the asp code. I've tried the ASP Version 2.53 but haven't worked it particularly hard, it works but would need a bit more testing to try redback. Would be most interesting and save having to use IIS with the attendant security issues. 8=) Apache runs very well on XP etc. but if you wish to continue to use *nix then IMHO Apache is the way to go. http://modules.apache.org and search for asp Apache::ASP Version 2.53 for Apache 1.3, 2.x License: GPL Last Updated June 14th, 2003Author Josh Chamas Active Server Pages with perl scripting. Advanced extensions include extra events, XSLT rendering, output caching, and more. More info ... Chili!Soft ASP Version 3.04 for Apache 1.3.xLicense: Commercial Software Last Updated May 15th, 2000 Author Dave Weaver Active Server Pages for Apache More info ... ModVB Version alpha for Apache 1.3 License: GPL/LGPL Last Updated June 12th, 2003Author Trinity Bays ASP/VBScript/JScript for Apache More info ... mod_monoVersion 0.3.5 for Apache 2.x License: Apache License Last Updated June 13th, 2003Author Daniel Lopez Runs ASP.NET pages on Unix with Apache and Mono More info ... OpenASP Module Version 0.1 for Apache 1.3.xLicense: Apache License Last Updated September 01st, 1998 Author Nathan Woods Open Source implementation of Active Server Pages (ASP) More info ... Regards David Logan Database Administrator HP Managed Services 139 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 +61 417 268 665 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of D Averch Sent: Thursday, 12 February 2004 1:55 PM To: [EMAIL PROTECTED] Subject: Re: Universe/RedBack on Linux We learned the hard way that you must have Windows IIS front end for Redback to run the ASP code. We are currently converting many green screen programs to Redback for a client running on Linux using our tool XLr8. Response time for this 4 processor system is very good. - Original Message - From: Baruch Salamander [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, February 11, 2004 3:01 PM Subject: Universe/RedBack on Linux Is anyone out there using Universe and RedBack on Linux? If so, how's the performance? For those who are not on Linux, are you considering Linux as an option for the future? -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
U2 List Archive... How big is it?
Sometimes (out here in Africa) we cannot get access to the internet - whilst I realise it would just be a snapshot without updating, would it be possible to use something like webstripper and copy the entire site to my HDD? dennis -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users