Hi All,
uv 10.2.7 / hpux 11.11 First things first (skip this section if you don't care for goodbyes)... I wanted to say thanks to all of the contributors to this list. I have learned a tremendous amount from all of you. The passion that many of you have for your work is really inspiring. I am being moved to our corporate office to join a team of 10 who will be learning, configuring, and customizing SAP to meet the needs of the best wine and spirits distribution company in the world. Ok, I'm a little partial... All of you deserve a great deal of credit for my opportunity as you have all contributed to the things that I've been able to accomplish with my current system. Without the great system that we here in Illinois have developed, I'm sure that noone would trust in my abilities to deliver in a different environment. <blockquote> A special thanks to a couple of people I have been blessed to work directly with. I cannot recommend their services enough! </blockquote> <blockquote> Tony Gravagno ( http://www.nebula-rnd.com/ ): When each division of SWS was asked to provide a web service that would interface our sales force automation units to our business systems, I was terrified. I had never had the opportunity to work with web technology and, based on a heavy workload, did not have the time to dive in at that time. I did take the web developer that Universe offered for a spin. Pretty cool tool. While I was able to develop a web service that could work had I set the requirements myself, I could not get it to meet the requirements that corporate was developed. I even worked with one of the IBM engineers and he could not get it done. Keep in mind that I have always believed in my abilities to provide solid solutions using the tools that we have in the multivalue world. It killed me to have to bring in a resource from the outside. I swallowed my pride and turned to Tony. I was amazed at the incredible service that he provided. He developed a service for me that has been rock solid. I am still amazed that I have never had to revisit it after years of pounding by our sales force. This is plug, play, and forget about it at its best! Not only that but our web service which provides incredibly powerful and complicated pricing blows the web service developed on our corporate as400 system out of the water from a performance standpoint. Thanks Tony, you've made me look a lot better than I really am :) </blockquote> <blockquote> Jeff Fitzerald ( http://www.fitzlong.com/ ): Your write-ups on file performance have really helped me to ensure that our system is always operating at a high level. I wish I could get everyone around here to read it. I was also fortunate enough to have been allowed to use your file maintenance product - FAST. I can't tell you how much time that this saved me. When I first arrived at this company, all the files were dynamic. I made the mistake of converting them all to static because I believed the performance was much better. I was right and the system was screaming. The reason I use "mistake" is that it brought me into a whole new world of ensuring the thousands of files used by the application continued to perform by spending all my weekends sizing. Yuck! By allowing me to break away from managing the monster that I had created by using your product, I had my weekends free again. Yay! Not only that, your product was doing a much better job than I ever did. Unfortunately, budgets were cut and I could no longer continue to use it. Thanks Jeff, you helped me to spend my time moving the company forward by developing great tools rather than maintaining files. </blockquote> FILE SIZING question: As mentioned, I'm moving on. Before leaving I'm trying my best to ease the burden on my friends here in Illinois by automating many of the things that I never got around to doing for myself . That being said, I put together a routine that will analyze our files and resize as necessary. It's pretty slick but not near the software offered by fitzlong.com - refer to previous section. I would like to set it up to execute from cron so that noone has to babysit. Being the scaredy cat that I am, I've always phantomed off the process and monitored over the weekend to ensure that noone is accessing the files in question. I put the CONCURRENT option in there as a safeguard but never really trusted it enough to turn the program loose without policing. My questions regarding CONCURRENT are these: 1. Is the option trustworthy enough to use on a live system while users are possibly accessing the files? 2. Are there any sort of performance issues? In other words, would a file that takes 2 hours to size take 8 hours to size while users are accessing? The routine keeps a history of various statistics including how much time it took to do its business. 3. Does it slow the application that is accessing the file? 4. Any other considerations? Thanks in advance for your response and for all of the tremendous help that you've all been over the years. Scott Thompson _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users