RE: Pro-4
TNT Australia was/is a big users of Pro-IV under MVS, I believe. http://www.proiv.com/p4web/home/index.xsp Sorry, don't know of any Pro-IV gurus. Regards, David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Dave Taylor Sent: Thursday, April 08, 2004 1:16 PM To: U2 Users Discussion List Subject: Re: Pro-4 Barry, Try contacting: www.northgate-is.com Rgds, Dave Dave Taylor Sysmark Information Systems, Inc. 49 Aspen Way Rolling Hills Estates, CA 90274 800-SYSMARK (800-797-6275) (O) 310-544-1974 (F) 310-377-3550 www.sysmarkinfo.com - Original Message - From: Barry Brooks [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, April 07, 2004 6:53 PM Subject: Pro-4 Hi all I'm looking for someone who maybe be able to assist with support of a customer using PRO-4 (ex McDonald Douglas ALL) I think. Support will be required in Sydney, Australia. Can anyone help ? Thanks ... Barry Brooks -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UniVerse and RedBack
We are running UniVerse 10.0.19. We are running RedBack ver 4.1.3. The issue seems to be related to WWSTATE getting too big and i think there WAS a bug in Redback 4.0 that is claimed to be fixed in RedBack 4.1. We use an internal WWState Purging mechanism though. Check WWState, when this happens. HTH Joe Eugene -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Barry Rogen Sent: Wednesday, April 07, 2004 10:19 AM To: [EMAIL PROTECTED] Subject: UniVerse and RedBack I was not sure whether to make this an '[OT]', so if it is deserving of such status, forgive me. We are running UniVerse 10.0.19. We are running RedBack ver 4.1.3. We seem to be having a problem where our Responders go busy and never return to idle. Eventually all Responders go busy and our web 'goes down'. The log files show nothing that would even raise an eyebrow of uncertainty. It is as if, RedBack is running great and then it ain't. Some scenarios that might cause this would at least give us some areas to investigate for problems. Any thoughts as always are much appreciated. Thank you, 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 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
*** END OF THREAD *** Was: RE: Modern Universe (TESTING)
Hi Clif A bit late in the day, but it would be better if you put END OF THREAD in the subject line as those of us who selectively read posts often miss these posts. On any thread that wanders about one starts to get interesting snippets that are tempting to reply to... Thus inadvertently breaking this cardinal rule... dennis -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Clif Oliver Sent: 06 April 2004 06:06 To: U2 Users Discussion List Subject: Re: Modern Universe (TESTING) *** END OF THREAD *** DO NOT REPLY TO THIS THREAD ANY FURTHER (That means *anyone* not just the poster of the message used for the Moderator reply) On Apr 5, 2004, at 7:54 PM, Andrew Gissing wrote: If you Dont Agree, Prove it... Everybody can Talk.. Where are your Test Results? The problem with performance tests is that there are so many variables. And then if you remove a lot of the variables to perform a lab test, that does not reflect real world. So then you try and make your lab conditions simulate real world - and simply doing a COUNT on a file is not enough - sorry ! Yes, UV could count for 15 mins if say the file was really badly sized. So what does that mean ? It does not mean that UV is crap, it means it's not been tuned right. Send Michael Schumaker round the track with flat tyres - when he does not perform is that the fault of the car ? So my final point is that it takes time and effort to do proper testing - something most of us are not going to dedicate resources to just to prove a point here. Andrew Gissing -- 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: *** END OF THREAD *** Was: RE: Modern Universe (TESTING)
Excellent idea. I will make sure it gets passed along to the new hosts. Thank you. -- Regards, Clif On Apr 8, 2004, at 1:14 AM, Dennis Bartlett wrote: A bit late in the day, but it would be better if you put END OF THREAD in the subject line as those of us who selectively read -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UniVerse and RedBack
Follow up question - Our WWSTATE file has close to 500,000 records. Are these records needed or 'garbage' records to be purged out on a regular basis ? 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 _ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Trevor Ockenden Sent: Wednesday, April 07, 2004 10:38 PM To: U2 Users Discussion List Subject: Re: UniVerse and RedBack We are running UniVerse 10.0.19. We are running RedBack ver 4.1.3. We seem to be having a problem where our Responders go busy and never return to idle. Eventually all Responders go busy and our web 'goes down'. The log files show nothing that would even raise an eyebrow of uncertainty Definitely not OT. We recently had this problem (or very similar) so we may have an answer for you. It is my pet topic - Do an ANALYZE.FILE on WWSTATE file and report the results and for the benefit of all we'll suggest suitable changes for the RESIZE. The WWSTATE file is heavily used by RedBack and some of the items can be rather large. Correct set up of this file is essential. If the set up is inappropriate then the system can get bogged down just trying to update items in this file. Also, you should ensure the GARBAGE COLLECT is done often enough to keep the entries in this file to the minimum. Cheers Trevor Ockenden Open Systems Professionals - Original Message - From: Barry Rogen [EMAIL PROTECTED] Sent: Thursday, April 08, 2004 12:18 AM . --- Outgoing mail is certified Virus Free by AVG 6.0. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.654 / Virus Database: 419 - Release Date: 6/04/2004 -- 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 and RedBack
Thats pretty high, how is your WWSTATE file configured? Unless your website is very busy I'd say you've probably got some old data in there. As for the data you can see how old it is by looking at field 2, I can't say whether it's garbage or not, that depends on your system. -Original Message- From: Barry Rogen [mailto:[EMAIL PROTECTED] Sent: 08 April 2004 12:16 To: U2 Users Discussion List Subject: RE: UniVerse and RedBack Follow up question - Our WWSTATE file has close to 500,000 records. Are these records needed or 'garbage' records to be purged out on a regular basis ? 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 _ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Trevor Ockenden Sent: Wednesday, April 07, 2004 10:38 PM To: U2 Users Discussion List Subject: Re: UniVerse and RedBack We are running UniVerse 10.0.19. We are running RedBack ver 4.1.3. We seem to be having a problem where our Responders go busy and never return to idle. Eventually all Responders go busy and our web 'goes down'. The log files show nothing that would even raise an eyebrow of uncertainty Definitely not OT. We recently had this problem (or very similar) so we may have an answer for you. It is my pet topic - Do an ANALYZE.FILE on WWSTATE file and report the results and for the benefit of all we'll suggest suitable changes for the RESIZE. The WWSTATE file is heavily used by RedBack and some of the items can be rather large. Correct set up of this file is essential. If the set up is inappropriate then the system can get bogged down just trying to update items in this file. Also, you should ensure the GARBAGE COLLECT is done often enough to keep the entries in this file to the minimum. Cheers Trevor Ockenden Open Systems Professionals - Original Message - From: Barry Rogen [EMAIL PROTECTED] Sent: Thursday, April 08, 2004 12:18 AM . --- Outgoing mail is certified Virus Free by AVG 6.0. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.654 / Virus Database: 419 - Release Date: 6/04/2004 -- 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 ** 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. ** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Pro-4
Dear Mr Barry Brooks I would love to help. I have used Pro-4 for 3 years Pick for 18 years I have extensive experience with both development and maintenance work. I have extensive experience working within tight deadlines and managing multiple tasks. I cannot send you my CV using the U2 Users Discussion List. Regards Sami Pierre Massarany Mobile: 0414 408 229 or +61 414 408 229 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Barry Brooks Sent: Thursday, 8 April 2004 11:53 AM To: [EMAIL PROTECTED] Subject: Pro-4 Hi all I'm looking for someone who maybe be able to assist with support of a customer using PRO-4 (ex McDonald Douglas ALL) I think. Support will be required in Sydney, Australia. Can anyone help ? Thanks ... Barry Brooks -- 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: U2 Personal Editions
Folks ln -s would have done the same job but would have avoided potential future upgrade issues (single copy of object etc.) Regards JayJay -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Gallen Sent: 07 April 2004 19:50 To: U2 Users Discussion List Subject: RE: U2 Personal Editions yes, it's uncompress, and the problem isn't just in PE. Since I believe gunzip works with .Z files as well, what I did was cp /sbin/gunzip /sbin/uncompress I will now see if that works :) George snip -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UniVerse and RedBack
Thanks for the pointer. I cleanup up WWSTATE, adjusted the parameters for garbage collect. I will watch and see but this has to (logically) have a positive affect on RedBack performance. Thanks again !! 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 _ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of James Cowell Sent: Thursday, April 08, 2004 7:25 AM To: U2 Users Discussion List Subject: RE: UniVerse and RedBack Thats pretty high, how is your WWSTATE file configured? Unless your website is very busy I'd say you've probably got some old data in there. As for the data you can see how old it is by looking at field 2, I can't say whether it's garbage or not, that depends on your system. -Original Message- From: Barry Rogen [mailto:[EMAIL PROTECTED] Sent: 08 April 2004 12:16 To: U2 Users Discussion List Subject: RE: UniVerse and RedBack Follow up question - Our WWSTATE file has close to 500,000 records. Are these records needed or 'garbage' records to be purged out on a regular basis ? 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 _ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Trevor Ockenden Sent: Wednesday, April 07, 2004 10:38 PM To: U2 Users Discussion List Subject: Re: UniVerse and RedBack We are running UniVerse 10.0.19. We are running RedBack ver 4.1.3. We seem to be having a problem where our Responders go busy and never return to idle. Eventually all Responders go busy and our web 'goes down'. The log files show nothing that would even raise an eyebrow of uncertainty Definitely not OT. We recently had this problem (or very similar) so we may have an answer for you. It is my pet topic - Do an ANALYZE.FILE on WWSTATE file and report the results and for the benefit of all we'll suggest suitable changes for the RESIZE. The WWSTATE file is heavily used by RedBack and some of the items can be rather large. Correct set up of this file is essential. If the set up is inappropriate then the system can get bogged down just trying to update items in this file. Also, you should ensure the GARBAGE COLLECT is done often enough to keep the entries in this file to the minimum. Cheers Trevor Ockenden Open Systems Professionals - Original Message - From: Barry Rogen [EMAIL PROTECTED] Sent: Thursday, April 08, 2004 12:18 AM . --- Outgoing mail is certified Virus Free by AVG 6.0. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.654 / Virus Database: 419 - Release Date: 6/04/2004 -- 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 ** 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. ** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This e-mail message from PNY Technologies, Inc. is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited.
BETWEEN in a CASE structure
Before I just go off and do this, I thought I'd throw the question out there... In a CASE construct in UniBasic, can you use the BETWEEN keyword to test against a range. For example, I've got a large number of values I'm testing for and several of them are contiguous. Would something like CASE val BETWEEN 6000 6009 be correct or would I need to do something like Case (val = 6000 AND val = 6009) be what I need. Thanks. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: BETWEEN in a CASE structure
From: [EMAIL PROTECTED] Jason, Unless UniData 6.0 supports a 'BETWEEN' relational operator, I recommend to you to use the second scenario, Case (val = 6000 AND val = 6009). I'm using UniData 5.1 and 'BETWEEN' in not a valid relational operator in UniBasic. UniQuery, yes... You could check the code generated, but I tend to write a statement using just the greater_than operator, rather than the greater_than_or_equal_to, feeling that the number of actual operations is less. I also tend to use the explicitly test operators rather than those which can be test or assignment, but that's just style and open for debate. So, I'd use: CASE ((VAL GT 5999) AND (VAL LT 6010)) Rgds. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: BETWEEN in a CASE structure
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Unless UniData 6.0 supports a 'BETWEEN' relational operator, I recommend to you to use the second scenario, Case (val = 6000 AND val = 6009). I'm using UniData 5.1 and 'BETWEEN' in not a valid relational operator in UniBasic. UniQuery, yes... Case VALL#3 = 600 I don't want to start a flame war but, to me, this falls in the category of unnecessarily complicated programming tricks. I'd kill one of my programmers who did that. Testing the end values is definitely more straight forward. Not to mention that this would fail if VAL = 600... - jmh -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: BETWEEN in a CASE structure
In a message dated 4/8/2004 8:58:16 AM Pacific Daylight Time, [EMAIL PROTECTED] writes: Case VALL#3 = 600 I don't want to start a flame war but, to me, this falls in the category of unnecessarily complicated programming tricks. I'd kill one of my programmers who did that. Testing the end values is definitely more straight forward. Not to mention that this would fail if VAL = 600... - jmh Case (val matches ''6001N') -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Performance
Duh duh duh Please ignore my last post. I scanned it and missed 'AIX'. It's the end of the day here Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin Vezertzis Sent: 08 April 2004 17:08 To: [EMAIL PROTECTED] Subject: Performance We are looking for some insight from anyone that has experienced performance degradation in UV, as it relates to the OS. We are running UV 10.0.14 on AIX 5.1.we are having terrible 'latency' within the application. This is a recent conversion from D3 to UV and our client is extremely disappointed with the performance. We've had IBM hardware support and Universe support in on the box, but to no avail..we are seeing high paging faults and very highly utilized disk space. Any thoughts or suggestions? Thanks, Kevin Kevin D. Vezertzis Project Manager Cypress Business Solutions, LLC. 678.494.9353 ext. 6576 Fax 678.494.9354 [EMAIL PROTECTED] Visit us at www.cypressesolutions.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: Performance
Kevin, We had the same problem when migrating UV from DEC in one data center to HP managed in another data center, even though it was a honking big HP. The sys admins configured memory memory similar to how their 20 other unix machines were set up. The trick was to configure most memory for shared data, so that the large UV files used most of the day pretty much stay in memory all the time. I have no personal experience managing unix memory, but these guys did, for Informix, Oracle, etc, and they see UV as acting very differently (well, weird was their exact word) from all other DBMSs they have managed. Once the memory allocation was resolved, the new system screamed as expected. Give it a try, Chuck Stevenson -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin Vezertzis Sent: Thursday, April 08, 2004 9:08 AM To: [EMAIL PROTECTED] Subject: Performance We are looking for some insight from anyone that has experienced performance degradation in UV, as it relates to the OS. We are running UV 10.0.14 on AIX 5.1.we are having terrible 'latency' within the application. This is a recent conversion from D3 to UV and our client is extremely disappointed with the performance. We've had IBM hardware support and Universe support in on the box, but to no avail..we are seeing high paging faults and very highly utilized disk space. Any thoughts or suggestions? Thanks, Kevin Kevin D. Vezertzis Project Manager Cypress Business Solutions, LLC. 678.494.9353 ext. 6576 Fax 678.494.9354 [EMAIL PROTECTED] Visit us at www.cypressesolutions.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: Performance
Screen savers? Best performance to background processes? On AIX? -Original Message- From: Brian Leach [mailto:[EMAIL PROTECTED] Sent: Thursday, April 08, 2004 9:24 AM To: 'U2 Users Discussion List' Subject: RE: Performance First things, 1. turn off any screen savers 2. ensure your server is set to adjusted to give best performance to background processes 3. turn off any virus checkers 4. turn off veritas backup Brian Leach -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Extracting data directly from dbf files...
I have a program(s) to convert a DBF to a U2 file natively it's in Unidata not Universe though. Email me directly if interested. Thanks, [EMAIL PROTECTED] 4:47:06 PM 04/07/2004 Has anyone developed any processes to natively read '.dbf' type files from within Universe basic? I know we could use ODBC or UniObjects but prefer a more direct approach. Lee J Messenger Sr VP Operations [EMAIL PROTECTED] DLT Transportation Services, Inc. Phone :(816) 242-4505 Fax :(816) 483-7222 -- 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: BETWEEN in a CASE structure
In a message dated 4/8/2004 12:10:33 PM Eastern Daylight Time, [EMAIL PROTECTED] writes: And yet it is between 6000 6999. 6555.555 is another example. (There might be even more examples, but I haven't checked!) The context is integer. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Performance
Hello Kevin, I have seen many good posts in reply to your situation already. File-sizing, (and therefore disk IO) is a key/critical area. What kind of file systems do you have? How much memory swap space do you have? What are the Virtual Memory AIX tuning parameters set to? IBM Hardware - AIX support and IBM U2 support - are all the same company, and they can't find it? Please give us the system configuration information so we can all develop a more clear picture of what you're running there. Is this system a recent OS upgrade from AIX 4.X? Any new or different hardare added or subtracted? Any other changes that may be noteworthy? The way you discuss memory, page faulting, and very high disk IO, I would make sure they verify each of your uvconfig parameters, and kernel system tunable parameters, and make sure you have more than ample swap space, and a large /tmp mounted file system space with fast striped disk sub-system underneath. One tool that will help map out exactly what is going on, and therefore provide a road map on how to address/resolve these issues, and then prove that these issues are indeed resolved, would be the DPMonitor. DPMonitor is available on the internet and has a free 10 day evaluation license available that will allow you to track system-wide parameters and performance metrics that will provide a very clear picture as to what is happening. Check it out at www.deltek.us. This tool has been used on AIX 5.1, on small single processor configurations, up through very large systems, 16 32 processor systems. Performance Agent runs on the AIX Application Server. Extremely low overhead Agent. Performance Explorer runs on a Windows Workstation. Well worth the free 10 day evaluation license. Regards, Scott Sr. Systems Engineer / Consultant Marlborough, MA - Original Message - From: Kevin Vezertzis [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, April 08, 2004 12:08 PM Subject: Performance We are looking for some insight from anyone that has experienced performance degradation in UV, as it relates to the OS. We are running UV 10.0.14 on AIX 5.1.we are having terrible 'latency' within the application. This is a recent conversion from D3 to UV and our client is extremely disappointed with the performance. We've had IBM hardware support and Universe support in on the box, but to no avail..we are seeing high paging faults and very highly utilized disk space. Any thoughts or suggestions? Thanks, Kevin Kevin D. Vezertzis Project Manager Cypress Business Solutions, LLC. 678.494.9353 ext. 6576 Fax 678.494.9354 [EMAIL PROTECTED] Visit us at www.cypressesolutions.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: Extracting data directly from dbf files...
I think I got this stuff from wotsit.org... The header record size are stored as binary fields in pos 9-10 11-12 of the file header. Here is some D3 code that I use to read dbf files: (you still need to already know the record layout re: fields, etc, although I'm sure that information is encoded in the header as well; this code just figures out where the header ends so you can start parsing the data.) --- begin basic--- * [42] Sometimes headers are one char smaller than expected, * which shifts entire file. To watch for this, check * the first record's RC code -- if that doesn't start * with an R, then we're shifted, so subtract one * from the header size. block.size = 1 execute cd /path/to/files execute !exec ls *dbf capturing dbf.files max = dcount(dbf.files,@am) for n = 1 to max dbf.file = dbf.filesn print print now processing :dbf.file:... fv = %open(dbf.file,o$rdonly) char new.block[block.size] first.time = 1 done = 0 loop until done do r = %read(fv,new.block,block.size) if r lt block.size then done = 1 new.block = new.block[1,r] end if first.time then * header.size rec.size can be determined by reading the * header data, but make sure that block size is greater * than the header size. h1 = seq(new.block[9,1]) h2 = seq(new.block[10,1]) header.size = (256*h2)+h1 + 2 r1 = seq(new.block[11,1]) r2 = seq(new.block[12,1]) rec.size = (256*r2)+r1 ** [42] rc.index = header.size + 100 rc.char = new.block[rc.index,1] if rc.char ne R then header.size = header.size - 1 end first.time = 0 block = new.block[header.size,99] end else block = block:new.block end loop while len(block) ge rec.size do rec = block[1,rec.size] block = block[rec.size+1,99] gosub 1000 ;* parse the rec repeat repeat * last one may be partial record ach.rec = block gosub 1000 x = %close(fv) next n -- end basic - I have also seen a freeware DOS program that convert dbase files to csv (google for convert file?), but you have to have a DOS environment available to shell out to... Good Luck, Scott Ballinger Pareto Corporation Edmonds WA USA 425-670-0831 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Richard A. Wilson Sent: Wednesday, April 07, 2004 3:35 PM To: U2 Users Discussion List Subject: Re: Extracting data directly from dbf files... I'm fairly certain that the cedarville download utility handles dbf files. Since it comes with source code perhaps you can change the write logic to read Rich Lee Messenger wrote: Has anyone developed any processes to natively read '.dbf' type files from within Universe basic? I know we could use ODBC or UniObjects but prefer a more direct approach. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Performance
Thanks for all of the posts...here are some of our 'knowns'... 1.) Application files have all been analyzed and sized correctly. 2.) IBM U2 support analyzed Universe files, locking, swap space and all have been adjusted accordingly or were 'ok'. 3.) We are running RAID 5, with 8G allocated for Universe 4.) We are already running nmon, which is how we identified the paging faults and high disk I/O 4.) Attached you will find the following: smat -s LIST.READU EVERY PORT.STATUS Uvconfig Nmon (verbose and disk) Vmtune I know this is a lot of data, but it is a mix of what each of you have suggested. Thanks again for all of the help. Kevin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin Vezertzis Sent: Thursday, April 08, 2004 12:08 PM To: [EMAIL PROTECTED] Subject: Performance We are looking for some insight from anyone that has experienced performance degradation in UV, as it relates to the OS. We are running UV 10.0.14 on AIX 5.1.we are having terrible 'latency' within the application. This is a recent conversion from D3 to UV and our client is extremely disappointed with the performance. We've had IBM hardware support and Universe support in on the box, but to no avail..we are seeing high paging faults and very highly utilized disk space. Any thoughts or suggestions? Thanks, Kevin File access State Netnode Owner Collisions Retries Semaphore # 1 00 0 0 0 Semaphore # 2 00 0 0 0 Semaphore # 3 00 0 0 0 Semaphore # 4 00 0 0 0 Semaphore # 5 00 0 0 0 Semaphore # 6 00 0 0 0 Semaphore # 7 00 0 0 0 Semaphore # 8 00 0 0 0 Semaphore # 9 00 0 0 0 Semaphore # 10 00 0 0 0 Semaphore # 11 00 0 0 0 Semaphore # 12 00 0 0 0 Semaphore # 13 00 0 0 0 Semaphore # 14 00 0 0 0 Semaphore # 15 00 0 0 0 Semaphore # 16 00 0 0 0 Semaphore # 17 00 0 0 0 Semaphore # 18 00 0 0 0 Semaphore # 19 00 0 0 0 Semaphore # 20 00 0 0 0 Semaphore # 21 00 0 0 0 Semaphore # 22 00 0 0 0 Semaphore # 23 00 0 0 0 Group accessState Netnode Owner Collisions Retries Semaphore # 1 00 0 34 34 Semaphore # 2 00 0 13 13 Semaphore # 3 00 0 6 6 Semaphore # 4 00 0 21 21 Semaphore # 5 00 0 10 10 Semaphore # 6 00 0 12 12 Semaphore # 7 00 0 12 12 Semaphore # 8 00 0 43 43 Semaphore # 9 00 0 7 7 Semaphore # 10 00 0 9 9 Semaphore # 11 00 0 11 11 Semaphore # 12 00 0 10 10 Semaphore # 13 00 0 11 11 Semaphore # 14 00 0 16 16 Semaphore # 15 00 0 10 10 Semaphore # 16 00 0 11 11 Semaphore # 17 00 0 17 17 Semaphore # 18 00 0 12 12 Semaphore # 19 00 0 19 19 Semaphore # 20 00 0 5 5 Semaphore # 21 00 0 22 22 Semaphore # 22 00 0 8 8 Semaphore # 23 00 0 34 34 Semaphore # 24 00 0 5 5 Semaphore # 25 00 0 10 10 Semaphore # 26 00 0 11 11 Semaphore # 27 00 0 15 15 Semaphore # 28 00 0 21 21 Semaphore # 29 00 0 12 12 Semaphore # 30 00 0 41 41 Semaphore # 31 00 0 7 7 Semaphore # 32 00 0 49 49 Semaphore # 33 00 0 9 9 Semaphore # 34 00 0 25 25 Semaphore # 35 00 0 13 13 Semaphore # 36 00 0 10 10 Semaphore # 37 00 0 6 6 Semaphore # 38 00 0 11 11
RE: Connection to account failure!
In VSG did you make sure the user your are connecting as has the required SQL privileges to access the files. Do they also have the required OS permissions to access the files? I've done this with a Win 2000 Dell PC with MS Access 2000 (and Excel 2000 - with which I had more trouble) accessing UD 6.02, 6.07, 6.0.12 on Win 2000 servers. Our Aix box is in the middle of an upgrade to 6.0 something and I haven't had a chance to test with it. hth -- Colin Alfke Calgary, Alberta Canada Just because something isn't broken doesn't mean that you can't fix it Stu Pickles -Original Message- From: Bright, Frank [mailto:[EMAIL PROTECTED] Sent: Thursday, April 08, 2004 12:41 PM To: U2-Users Group (E-mail) Subject: Connection to account failure! Good Afternoon All! I am setting up an ODBC query and I get the error Connection to 'whatever account' failure after the listing of ODBC files to choose from. I am testing this out with MS Access 2000 on Win 2000 Dell PC. The same problem occurs on other PCs running Win XP. We are using Unidata 6.03 on an IBM P630 Box with AIX 5.2.02. Has anyone else encountered this problem and was able to solve it? Thanks in advance! Frank [EMAIL PROTECTED] ___ Frank M. Bright -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: [UV] MCP
I will be out of the on April 12th and April 13th. I will not have access to e-mail or voice mail. If this cannot wait until my return please e-mail [EMAIL PROTECTED], or call 410.691.2888. Thank you, Josh -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Performance
I saw /tmp mentioned in one of Scott Richardson's posts. UniVerse uses /tmp for building select lists and sorts. If it is undersized, it can cause page faults like you are seeing. How big is /tmp? It might pay to monitor it's usage. It can be as critical as having adequate swap / paging space. Double check Scott's recommendation on /tmp. Bob Gerrish - [EMAIL PROTECTED] Kingsgate Enterprises, Inc. At 12:18 PM 4/8/2004, you wrote: Thanks for all of the posts...here are some of our 'knowns'... 1.) Application files have all been analyzed and sized correctly. 2.) IBM U2 support analyzed Universe files, locking, swap space and all have been adjusted accordingly or were 'ok'. 3.) We are running RAID 5, with 8G allocated for Universe 4.) We are already running nmon, which is how we identified the paging faults and high disk I/O 4.) Attached you will find the following: smat -s LIST.READU EVERY PORT.STATUS Uvconfig Nmon (verbose and disk) Vmtune I know this is a lot of data, but it is a mix of what each of you have suggested. Thanks again for all of the help. Kevin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin Vezertzis Sent: Thursday, April 08, 2004 12:08 PM To: [EMAIL PROTECTED] Subject: Performance We are looking for some insight from anyone that has experienced performance degradation in UV, as it relates to the OS. We are running UV 10.0.14 on AIX 5.1.we are having terrible 'latency' within the application. This is a recent conversion from D3 to UV and our client is extremely disappointed with the performance. We've had IBM hardware support and Universe support in on the box, but to no avail..we are seeing high paging faults and very highly utilized disk space. Any thoughts or suggestions? Thanks, Kevin -- 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
Objectcall headache...
I just recently found you folks...this is good stuff! Maybe you can help me with this one (sorry if there has been previous discussion)... Client upgraded UD to 6.0.3 on an AIX 4.31 box. Try as I may, I can no longer get an Objectcall connection to that server. I have used uniapi_admin to recreate the server and database, Verified that $UDTBIN, $UDTHOME, etc are valid and matches what I input in uniapi_admin, I recreated the uniapi.ini on the remote workstation to ensure that it has no munged text, I can telnet server name 4343 to the server and it connects...doesn't do anything of course but it connects (verified using netstat), Tried objping as root on the server and get the same errors as I do from a remote workstation: ERROR ON CLIENT in UniOpenPos: Server terminated unexpectedly. ERROR ON CLIENT in UniClose: Argument at position 1 has NULL handle. Any thoughts? David Litzau -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Objectcall headache...
Hi Dave :) Sayhopefully you'll get some expert responses...(disregard the fact that IBM doesn't support object call anymore, but.) there's a couple of simple things to check that's gotten me before 1) make sure it's licensed w/ VERSION (if it's even still listed at 6?) 2) In uniapi_admin, under administer servers, make sure you've got a valid Log dir... 3) make sure unirpcd daemon is running.. Other than that...you might be able to find something in the unidata documentation...what uniclose is looking for, at position one...? Good luck!! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Litzau Sent: Thursday, April 08, 2004 3:08 PM To: [EMAIL PROTECTED] Subject: Objectcall headache... I just recently found you folks...this is good stuff! Maybe you can help me with this one (sorry if there has been previous discussion)... Client upgraded UD to 6.0.3 on an AIX 4.31 box. Try as I may, I can no longer get an Objectcall connection to that server. I have used uniapi_admin to recreate the server and database, Verified that $UDTBIN, $UDTHOME, etc are valid and matches what I input in uniapi_admin, I recreated the uniapi.ini on the remote workstation to ensure that it has no munged text, I can telnet server name 4343 to the server and it connects...doesn't do anything of course but it connects (verified using netstat), Tried objping as root on the server and get the same errors as I do from a remote workstation: ERROR ON CLIENT in UniOpenPos: Server terminated unexpectedly. ERROR ON CLIENT in UniClose: Argument at position 1 has NULL handle. Any thoughts? David Litzau -- 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
Kansas City Regional User Group
Take a look at the announcement at www.u2ug.org regarding a desire to start a Kansas City area U2 Regional User Group (scroll down on the page to see it). Thanks. --dawn Dawn M. Wolthuis Tincat Group, Inc. www.tincat-group.com Take and give some delight today. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Extracting data directly from dbf files...
From: Lee Messenger Has anyone developed any processes to natively read '.dbf' type files from within Universe basic? I wrote one for Universe back in 1995 and improved on it up until 1998. It converts dbf files, creates an include file which has a DIM and equates for a matrice to use the fields with their names. It also creates dictionnary elements for the converted file using the dbf headers.It does not convert .dbt files. I based it on a dbf file format description I found on the Internet back then. I also made it able to convert fixed-length files, delimited files provided a header is defined for the file. The program asks several questions the first time it converts a file. It will remember the answers for subsequent conversions. It was tested over several data conversions I did overseas. The reason I had the tool produce an include file with equates is that sometimes the customers would provide me with .dbf files for the live conversion in which some fields were sometimes in different positions from the test data files I was given to develop the conversion programs. The equates includes made it possible for me to manipulate the fields by their names (all I had to do is recompile the program which used the includes). The program also generates a tab-delimited excel file with the name of each column on each line with a description of the data type. This was initially for me to document what the fields were for. __ Do you Yahoo!? Yahoo! Small Business $15K Web Design Giveaway http://promotions.yahoo.com/design_giveaway/ -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Objectcall headache...
Client upgraded UD to 6.0.3 on an AIX 4.31 box. Try as I may, I can no longer get an Objectcall connection to that server. Well, IBM end-of-lifed ObjectCall a while ago, but I still think they ship it. IBM also end-of-lifed AIX 4.3 mid last year IIRC. Having just checked the availability matrix at https://www-927.ibm.com/software/data/u2/support/u2techconnect/matrix.asp, I see that 6.0.3 and 6.0.8 ARE both certified for AIX 4.3.3, but 4.3.1 definitely isn't mentioned. Moving beyond this bunch of uncertainty I have about the supportability of your client's platform set, it might be worth asking what they upgraded from and what you are trying to connect with. ObjectCall is a highly version dependent beast. If they upgraded from an early UniData version like 3.3.2 or 4.0 and went straight to 6.0, then whatever ObjectCall client piece you used to be able to connect with would now be incompatible. Anyway, how to resolve this? First push the server and client logging levels up high (level 9?), then start off on the AIX box with objping and see if you can get a connection on the same box. Once you have that working, see if you can connect an external client. HTH, Ken -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Performance
Kevin As this is AIX (and only on AIX please - as it has it's own memory flush) - set UVSYNC=0 in uvconfig and run uvregen (Universe stopped please) This stops UniVerse doing its own sync There is a small risk with this but not much. Please do *not* change SYNCALLOC. FSEMNUM and GSEMNUM look fine (assuming this was under load). UVTEMP could do with relocating off root onto another volume - ideally on a SAN. I am sure you know that RAID 5 costs disk throughput (parity disk writes - but this is a business call - just be aware). There are a lot of processes in CLR.OM.LOCK - what does this do and is it intensive? Looking at SELECTs in use - we don't see the file sizes information etc - but check out the following: SELECT UNPOSTED.MRE WITH TEMP.LOC EQ BS2 BY BIN.SORT BY PROD SSELECT CATALOG.DETAIL BY-DSND DATE.TO (seen 3x) SSELECT INVENTORY WITH 67 = PETSAFE (seen 2x) SSELECT MAIL.MSG BY-DSND CREATE.DATE BY-DSND CREATE.TIME SSELECT ADJ.CODES SSELECT SMTP WITH 6 EQ SSELECT IMPORT.ORDERS Are these SELECTs performed a lot and are the files large? - if so look at indexes and watch the use of NO.NULLS where appropriate. Also watch that you do *not* build index on DICT itmes which translate to data out of the primary file (things like DATE() or a file translate). I have ignored a couple of SELECTS with SAMPLE statements. Would be interested in sar output for file opens - hopefully you are caching these file handles in COMMON (ideally named) - also the run queue (how many CPUs? - the run queue should not (other than very occasionally) exceed more than 2x the number of CPUs on the system (or in the LPAR if you use these). By heavily utilized disk space do you mean you use lots of disk ? - if so - and it seems disproportionate to yout data volumes - then are you using lots of dynamic files and if so have you tuned the file split/merge ratios?. Final points - I am sort-of-assuming that MFILES is appropriately set..? (see PORT.STATUS .. MFILE.HIST). You might also want to check out FILE.USAGE. Email me off-line if you want to go through any reports you already have on this - let's see what was and what was not covered (saves retreading old ground). Regards JayJay -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin Vezertzis Sent: 08 April 2004 20:18 To: 'U2 Users Discussion List' Subject: RE: Performance Thanks for all of the posts...here are some of our 'knowns'... 1.) Application files have all been analyzed and sized correctly. 2.) IBM U2 support analyzed Universe files, locking, swap space and all have been adjusted accordingly or were 'ok'. 3.) We are running RAID 5, with 8G allocated for Universe 4.) We are already running nmon, which is how we identified the paging faults and high disk I/O 4.) Attached you will find the following: smat -s LIST.READU EVERY PORT.STATUS Uvconfig Nmon (verbose and disk) Vmtune I know this is a lot of data, but it is a mix of what each of you have suggested. Thanks again for all of the help. Kevin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin Vezertzis Sent: Thursday, April 08, 2004 12:08 PM To: [EMAIL PROTECTED] Subject: Performance We are looking for some insight from anyone that has experienced performance degradation in UV, as it relates to the OS. We are running UV 10.0.14 on AIX 5.1.we are having terrible 'latency' within the application. This is a recent conversion from D3 to UV and our client is extremely disappointed with the performance. We've had IBM hardware support and Universe support in on the box, but to no avail..we are seeing high paging faults and very highly utilized disk space. Any thoughts or suggestions? Thanks, Kevin -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Moderation via the moderator
Thank you, Chuck. I appreciate the nice words. -- Regards, Clif Stevenson, Charles wrote: From: ... Clif Oliver The CyberSpankings will now begin Sheesh! I am not Santa Claus and am not going to make a naughty / nice list. EVERYBODY KNOCK IT OFF! Clif, I guess this means you won't reconsider remaining the list moderator, huh? On the plus side, you go out with a bang with a final example of what a fine job you've done. May we be so blessed in our next u2ug life. Thanks again. A word to the wise, Remember that these posts are archived. I, myself, have searched posts here and in other forums when evaluating candidates. I know that at least once my own posts were looked at when I candidated. Chuck extremely moderate Stevenson -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Objectcall headache...
On behalf of Dave, let me expand. We have a DataStage job which is still relying on ObjectCall (until we can rewrite it to utilise the new UniData6 stage), unfortunately, after the UniData upgrade ObjectCall ceased to function no matter what we do we just cannot get it to work again Martin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ken Wallis Sent: Thursday, April 08, 2004 5:05 PM To: 'U2 Users Discussion List' Subject: RE: Objectcall headache... Client upgraded UD to 6.0.3 on an AIX 4.31 box. Try as I may, I can no longer get an Objectcall connection to that server. Well, IBM end-of-lifed ObjectCall a while ago, but I still think they ship it. IBM also end-of-lifed AIX 4.3 mid last year IIRC. Having just checked the availability matrix at https://www-927.ibm.com/software/data/u2/support/u2techconnect/matrix.asp, I see that 6.0.3 and 6.0.8 ARE both certified for AIX 4.3.3, but 4.3.1 definitely isn't mentioned. Moving beyond this bunch of uncertainty I have about the supportability of your client's platform set, it might be worth asking what they upgraded from and what you are trying to connect with. ObjectCall is a highly version dependent beast. If they upgraded from an early UniData version like 3.3.2 or 4.0 and went straight to 6.0, then whatever ObjectCall client piece you used to be able to connect with would now be incompatible. Anyway, how to resolve this? First push the server and client logging levels up high (level 9?), then start off on the AIX box with objping and see if you can get a connection on the same box. Once you have that working, see if you can connect an external client. HTH, Ken -- 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