Performance Degraded running u10.0.0 in Aix 5.2 ML 2
Hi, We are facing performance degraded when running Universe 10.0.0 in AIX 5L 5.2. A bit intro on hardware specs. We are using pSeries 650 running on SMP 2 Power4 processor with 4GB of RAM, 4GB Paging size and RAID5 SSA Hard Disk. My Universe configuration as below: Current tunable parameter settings: MFILES = 300 T30FILE= 200 OPENCHK= 1 WIDE0 = 0x3dc0 UVSPOOL= /uvspool1 UVTEMP = /uvtmp1 SCRMIN = 3 SCRMAX = 5 SCRSIZE= 512 QDEPTH = 16 HISTSTK= 99 QSRUNSZ= 2000 QSBRNCH= 4 QSDEPTH= 8 QSMXKEY= 32 TXMODE = 0 LOGBLSZ= 512 LOGBLNUM = 8 LOGSYCNT = 0 LOGSYINT = 0 TXMEM = 32 OPTMEM = 64 SELBUF = 4 ULIMIT = 128000 FSEMNUM= 23 GSEMNUM= 97 PSEMNUM= 64 FLTABSZ= 11 GLTABSZ= 75 RLTABSZ= 75 RLOWNER= 300 PAKTIME= 5 NETTIME= 5 QBREAK = 1 VDIVDEF= 1 UVSYNC = 1 BLKMAX = 131072 PICKNULL = 0 SYNCALOC = 1 MAXRLOCK = 74 ISOMODE= 1 PKRJUST= 0 PROCACMD = 0 PROCRCMD = 0 PROCPRMT = 0 ALLOWNFS = 0 CSHDISPATCH= /bin/csh SHDISPATCH = /bin/sh DOSDISPATCH= NOT_SUPPORTED LAYERSEL = 0 OCVDATE= 0 MODFPTRS = 1 THDR512= 0 UDRMODE= 0 UDRBLKS= 0 MAXERRLOGENT = 100 JOINBUF= 4095 64BIT_FILES= 0 TSTIMEOUT = 60 PIOPENDEFAULT = 0 MAXKEYSIZE = 255 SMISDATA = 0 EXACTNUMERIC = 15 MALLOCTRACING = 0 CENTURYPIVOT = 1930 SPINTRIES = 0 SPINSLEEP = 1 CONVERT_EURO = 0 SYSTEM_EURO= 164 TERM_EURO = 164 SQLNULL= 128 When the uv restarted it run fine for a day before it used up all the CPU and memory resources. A fast check on 'topas' show CPU resources used up for Kernel and User. There are no free resources on Wait and Idle. Around 70% of the CPU resources used for User and 30% used for Kernel. On memory side, seem all the physical memory had been consumed up. Even Paging space also been used. A quick snapshot on the memory from 'topas' as below: MEMORY Real,MB4095 % Comp 22.4 % Noncomp 76.2 % Client 75.1 PAGING SPACE Size,MB4096 % Used 1.4 % Free 98.5 When all the physical resources are fully occupied, the Universe processing become slow. The only thing I can do now is to restart Universe when the performance degraded? Are there any performance tuning we need to do on the OS to prevent this issue? Or is there any known issue with this version of Universe? Please assist me to solve this problem. Regard's, Foo --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.657 / Virus Database: 422 - Release Date: 4/13/2004 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Performance Degraded running u10.0.0 in Aix 5.2 ML 2
Hi Foo Could it be an application problem. It sounds like an application is adding data to a possible type 1 file as a log or a como file or even a print job and it is growing to an enormous size consuming resources. There might be some other application that has gone rogue. Can you identify the time this problem started and relate it to a program that was updated. Can you identify a user who is using a lot of the resources and find out what they are doing. Regards David Jordan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Foo Chia Teck Sent: Friday, 16 April 2004 4:22 PM To: [EMAIL PROTECTED] Subject: Performance Degraded running u10.0.0 in Aix 5.2 ML 2 Hi, We are facing performance degraded when running Universe 10.0.0 in AIX 5L 5.2. A bit intro on hardware specs. We are using pSeries 650 running on SMP 2 Power4 processor with 4GB of RAM, 4GB Paging size and RAID5 SSA Hard Disk. My Universe configuration as below: Current tunable parameter settings: MFILES = 300 T30FILE= 200 OPENCHK= 1 WIDE0 = 0x3dc0 UVSPOOL= /uvspool1 UVTEMP = /uvtmp1 SCRMIN = 3 SCRMAX = 5 SCRSIZE= 512 QDEPTH = 16 HISTSTK= 99 QSRUNSZ= 2000 QSBRNCH= 4 QSDEPTH= 8 QSMXKEY= 32 TXMODE = 0 LOGBLSZ= 512 LOGBLNUM = 8 LOGSYCNT = 0 LOGSYINT = 0 TXMEM = 32 OPTMEM = 64 SELBUF = 4 ULIMIT = 128000 FSEMNUM= 23 GSEMNUM= 97 PSEMNUM= 64 FLTABSZ= 11 GLTABSZ= 75 RLTABSZ= 75 RLOWNER= 300 PAKTIME= 5 NETTIME= 5 QBREAK = 1 VDIVDEF= 1 UVSYNC = 1 BLKMAX = 131072 PICKNULL = 0 SYNCALOC = 1 MAXRLOCK = 74 ISOMODE= 1 PKRJUST= 0 PROCACMD = 0 PROCRCMD = 0 PROCPRMT = 0 ALLOWNFS = 0 CSHDISPATCH= /bin/csh SHDISPATCH = /bin/sh DOSDISPATCH= NOT_SUPPORTED LAYERSEL = 0 OCVDATE= 0 MODFPTRS = 1 THDR512= 0 UDRMODE= 0 UDRBLKS= 0 MAXERRLOGENT = 100 JOINBUF= 4095 64BIT_FILES= 0 TSTIMEOUT = 60 PIOPENDEFAULT = 0 MAXKEYSIZE = 255 SMISDATA = 0 EXACTNUMERIC = 15 MALLOCTRACING = 0 CENTURYPIVOT = 1930 SPINTRIES = 0 SPINSLEEP = 1 CONVERT_EURO = 0 SYSTEM_EURO= 164 TERM_EURO = 164 SQLNULL= 128 When the uv restarted it run fine for a day before it used up all the CPU and memory resources. A fast check on 'topas' show CPU resources used up for Kernel and User. There are no free resources on Wait and Idle. Around 70% of the CPU resources used for User and 30% used for Kernel. On memory side, seem all the physical memory had been consumed up. Even Paging space also been used. A quick snapshot on the memory from 'topas' as below: MEMORY Real,MB4095 % Comp 22.4 % Noncomp 76.2 % Client 75.1 PAGING SPACE Size,MB4096 % Used 1.4 % Free 98.5 When all the physical resources are fully occupied, the Universe processing become slow. The only thing I can do now is to restart Universe when the performance degraded? Are there any performance tuning we need to do on the OS to prevent this issue? Or is there any known issue with this version of Universe? Please assist me to solve this problem. Regard's, Foo --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.657 / Virus Database: 422 - Release Date: 4/13/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: PI Open is going away
Working for Prime in Copenhagen from 1984 to 1992 supporting PI I certainly remember these international events. It's fun to see the names popping up on this list, it brings along a lot of fine memories, including that I owe Lance a beer next time we met. It never happened, but the memories... Thanks PI for at very fine part of my working life. Med venlig hilsen (Best Regards) -Paul I remember the Prime Information release 6 (and first official GCI) in Copenhagen - Dennis Beldotti arranging? Remember the fun !*! With !AMLC and it's handy way of writing to absolute memory addresses (gosh - and you didn't want those disk drives did you !?) Was anyone else there? - Bent Pristed was the head boy there then I thik and we were pushing out Viewbase on Primenet Memories eh? The passing of an age. Regards JayJay -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: PI Open is going away
I was one of the two technical managers for the development of PI/open. It's always sad watching a product that you worked on be put into retirement. Perhaps I can now throw out my collection of PI/open manuals. Martin Phillips Ladybridge Systems 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB +44-(0)1604-709200 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: PI Open is going away
Funny that... I was only thinking the other day that I should throw out my ICL 1900 COBOL and PLAN Manuals!!! :-) -Original Message- From: Martin Phillips [mailto:[EMAIL PROTECTED] Sent: 16 April 2004 09:54 To: U2 Users Discussion List Subject: Re: PI Open is going away I was one of the two technical managers for the development of PI/open. It's always sad watching a product that you worked on be put into retirement. Perhaps I can now throw out my collection of PI/open manuals. Martin Phillips Ladybridge Systems 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB +44-(0)1604-709200 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: PI Open is going away
I'm planning (when I get the chance) to resurrect the EXL7330 in my garage. And the reason I salvaged it from work is that it has PI/Open on it ... Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Fitzgerald Sent: 15 April 2004 21:34 To: 'U2 Users Discussion List' Subject: RE: PI Open is going away Clif, We're using PI/Open on our HP for a subset of our accounting data. We also have a copy of PI/Open 3.2 running on an old Prime/EXL - the MIPS based box that Prime used to sell! We may even have a copy of PI/PC around somewhere. Jeff Fitzgerald Fitzgerald Long, Inc. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Clifton Oliver Sent: Thursday, April 15, 2004 1:08 PM To: U2 Users Discussion List Subject: Re: PI Open is going away As one of the engineers of the original Prime INFORMATION, I am curious how many people on the list are still using PI Open. Anyone care to sound off? -- Regards, Clif ~~~ W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com ~~~ On Apr 15, 2004, at 12:10, Jerry Banker wrote: The DB2 IMS Today newsletter has the following announcement. U2 Product Lifecycle Announcement Effective October 1, 2004, IBM will withdraw from marketing the programs noted below. If available, their replacement products are listed in the second column: PI/Open -- 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 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
RE: PI Open is going away
Ummm... My wife will murder me for this ... but I'd love to have a copy (we've lost a lot of ours). Scan them or whatever. If I'm up your way for some reason (I go up the M1 regularly, but have my wife with me ...) I'd relieve you of them. Cheers, Wol -Original Message- From: Martin Phillips [mailto:[EMAIL PROTECTED] Sent: 16 April 2004 09:54 To: U2 Users Discussion List Subject: Re: PI Open is going away I was one of the two technical managers for the development of PI/open. It's always sad watching a product that you worked on be put into retirement. Perhaps I can now throw out my collection of PI/open manuals. Martin Phillips Ladybridge Systems 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB +44-(0)1604-709200 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users 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
RE: U2 Personal Editions
For SuSE, I had to remove all the options to cpio. Note also, that when it tries to set up the daemon to autostart on boot, that fails also because SuSE uses a different /etc/rc.d setup. That needs manually fixing, because you can't run uv as a user unless uvd is running. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 07 April 2004 22:28 To: U2 Users Discussion List Subject: RE: U2 Personal Editions For Debian, i had to remove the c option from the taperead='cpio -ivc... line. Somewhere along the way, i must have installed compress/uncompress, so that wasn't an issue. Now, if i can figure out why my xterm gets clobbered when i start uv as root. Something wrong with the emulation somewhere. Seems to work ok as a normal user. There must be something in the admin menu that messes it up. Charles Hawkins -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users 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
RE: PI Open is going away
I was at Hoskyns, did a bit of gin for George II+... or our version of it! -Original Message- From: Martin Phillips [mailto:[EMAIL PROTECTED] Sent: 16 April 2004 14:19 To: U2 Users Discussion List Subject: Re: PI Open is going away Funny that... I was only thinking the other day that I should throw out my ICL 1900 COBOL and PLAN Manuals!!! :-) Don;t start me on that nostalgia! I was an operating system developer with ICL all those years ago. Martin Phillips Ladybridge Systems 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB +44-(0)1604-709200 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: UniVerse vs Progress Performance
Sounds like something is not tuned properly somewhere. Another Onion that needs a damn good peeling! Download the DPMonitor on both of these puppies, and then you can realistically compare volumes of I/O, volumes of CPU, volumes of memory, etc... in an apples to apples sort of comparison of sorts. Once you have it peeled and profiled, you will then have the technology required to put it all back together properly, so that it will scream like a raped-ape as they say. Not only that - you can monitor what ever changes you make along the way and clearly see if they help, or hurt your cause, and why. See my other reply to the Performance Degraded... thread. When you peel all the layers off these tight, nasty onions, and understand what's going on at all the different levels - it make it easy to identify, address resolve these problems - and monitor them proactively going forward as changes occur, growth/shrinkage happens, or additional processes / users come into the mix. UV applications, properly tuned and configured on their platform, should run extremely well, price/performance-wise. Been there, done that. Many times over. Sincere Regards, Scott Richardson Senior Systems Engineer / Consultant Marlborough, MA 01752 Email: [EMAIL PROTECTED] Web: http://home.comcast.net/~CheetahFTL/CC/CheetahFTL_1.htm eFax: 208-445-1259 - Original Message - From: Ross Ferris [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Friday, April 16, 2004 12:48 AM Subject: RE: UniVerse vs Progress Performance Probably need to see Progress running on the IBM under AIX - or UV on Intel chip with same OS to make significant comparison; even neglecting just WHAT is going on under the hood could have been 400+ users doing 'nothing' Ross Ferris Stamina Software Visage - an Evolution in Software Development -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dawn M. Wolthuis Sent: Friday, 16 April 2004 1:36 PM To: 'U2 Users Discussion List' Subject: RE: UniVerse vs Progress Performance I'm curious if there is a follow up on this? Is it a database tuning issue? Indexing? Memory? ... Thanks. --dawn Dawn M. Wolthuis Tincat Group, Inc. www.tincat-group.com Take and give some delight today. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of André Nel Sent: Tuesday, March 23, 2004 3:07 AM To: [EMAIL PROTECTED] Subject: FW: UniVerse vs Progress Performance Hi All Visited a neighbouring company (same line of business as ours) running 430 users on a Compaq Proliant box with SCO Openserver 5 and Progress version 9.1c as database. Application is in-house. At the time of my visit the CPU usage was constantly running at 80%. No problems being experienced with users complaining the system is slow etc. The server spec is as follows: 2x intel pentium III xeon 500Mhz processors 1.8GB RAM Smart Array 3200 controller Compaq Fast SCSI-2 controller 10x 18.2 GB Ultra SCSI-2 drives (8 drives are RAID 1, other 2 RAID 0) and 5 drives on Ultra 2 controller and 5 drives on Ultra 3 Controller 2x 10/100 Tx Ethernet controllers We are running AIX v5.1 with Maintainance Level 3 and UniVerse 10.0.7 (190 users) on a p620 box with the following specs: System Model: IBM,7025-6F1 Machine Serial Number: 6577ABA Processor Type: PowerPC_RS64-III Number Of Processors: 2 Processor Clock Speed: 602 MHz CPU Type: 64-bit Kernel Type: 32-bit LPAR Info: -1 NULL Memory Size: 4096 MB Good Memory Size: 4096 MB Paging 3072MB Firmware Version: IBM,M2P01208 Our box is struggling with the 190 users. File types are T30. All our lines are minimum 64K diginet. Comparing the 2 boxes, the amount of users on each box, any reason why we are struggling with the 190 users? The transaction volumes of the company running 430 users are considerably higher than ours? Any comments please Thanks André -- 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 --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.658 / Virus Database: 421 - Release Date: 9/04/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.658 / Virus Database: 421 - Release Date: 9/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: Performance Degraded running u10.0.0 in Aix 5.2 ML 2
Okay, it's AIX not linux, but I've just noticed that RAM = swap. You are an ABSOLUTE FOOL if you do that on linux. Maybe (or maybe not) the same applies to AIX - quite likely since they are both nixen and probably manage memory similiarly. Double swap space to 8Gb and see if that improves matters. Oh - and if you don't believe me, a swap = ram configuration will CRASH the early vanilla 2.4 kernels and that's 2002 vintage. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Scott Richardson Sent: 16 April 2004 14:06 To: U2 Users Discussion List Subject: Re: Performance Degraded running u10.0.0 in Aix 5.2 ML 2 Performance of UV applications on various Operating Systems is not rocket science. Perhaps better described as large, nasty tight onions that need peeling, one layer at a time, and understanding what each peeled layer is doing and why. Once this knowledge is acquired and understood, a plan can be built and executed to attack/resolve the problem. Are users logging out/off when they're done using the system, or when they've completed some large tasks or operations? How often is the system rebooted? RAID 5 file systems can slow down IO. We'll need specifics on file system setup and parameters. How many users? What are these users doing? Have you got everyone and their siblings all running SELECT and SORT operations all the time? Data Entry out the wazoo? How big are the files, and how are they sized? How frequently does data change in the files, (grow, shrink, etc...) How big is your /tmp file system, and what kind of file system, and where is it physically located?? Provide it it's own file system, on it's own disk or disk set, (i.e. not the same disks where other activity is going on). 4GB of RAM, yet only 4 GB paging/swap space? Where is this swap paging space, (i.e. what disks?) topas may be fine for quick and dirty analysis and understanding, but using it extensively can help contribute to performance problems. You need to configure and tune the platform, the OS, the UV DB, the IO sub-system, the applications, the users, and the administration/operations, and thenensure they're all coordinated with each other, to maximize platform performance. To find, (and therefore address resolve), the root causes of what is happening here, you need to profile the platform using something such as the DPMonitor, (extremely low-overhead monitoring Agent) and display/crunch the performance metrics on another platform, (i..e. a Windows Performance Explorer Console). Using this method, you'll be able completely profile the entire platform, (OS and applications), around the clock, and then easily dial into specific timeframes where problems are occurring, and fully understand exactly what is happening and learn why it is happening, so it can be addressed and resolved, and measure the progress along the entire way. The DPMonitor is available with a free 10 day evaluation license where it will track system-wide performance metrics. Fully licensed version will track individual processes that you select, or all processes if you so desire. When you monitor all of the processes, you can quickly and easily identify processes deserving further analysis, and stop tracking processes that are not casuing any problems. More information on the DPMonitor can be found at http://www.deltek.us and the DPMonitor can be downloaded right off the website. If you're short on memory, DPMonitor will allow you to see how much memory you will need to allow the system to run as fast as it can, given how you're running it. If you need tuning of OS or UV parameters, or other things that ay be playing contributing factor/roles, the DPMonitor will clearly point this out, grahically, so that anyone can plainly see what is happening. Once you make any changes, you'll be able to monitor, and measure, any differences, consistently, and prove whether or not you have improved, or detrimented, your cause. Best of all, you'll be able to show, prove, and justify to management what you're doing, and why, and show them what it will take to get the problems addressed and resolved, positively, without question. Hope this helps. I know the DPMonitor can will help. I have used it personally, numerous times, to peel many a complex onion, understand what is exactly going on, find out why, and then put together and executed plans that have successfully addressed and resolved similar problems and streamlined operations moving forward saving many a business significant time, frustration, and money, and then ensured that any all operations moving forward were done from a pro-active, knowing ahead of time manner, rather than fire-fighting problems on a continual basis. If you want something done, why not do it right, once? Stop beating your head against the onion wall! Work smarter! Let the DPMonitor be your detailed, EKG-like instrument to cut to the heart of your complex application server
RE: Jbase handles multivalue on RDBMS
For what it's worth the Revelation / Arev / OpenInsight crowd have a thing called Bonding where in you can create a bond with another database structure, and natively list/sort/query that database. Bundled with Arev comes Dbase / Ascii bonds. I don't know what comes with OI, but I believe you get bonds for all manner of database(s). As far as I remember, the emphasis is on data movement _from_ the other data structure, altho' it handles creation of data within that structure, but only within the rules of that structure - ie you can't create multivalues within a normalised base, and it's up to your programming to convert mv files into flat form based files. The best people to ask about this sorta thing have got to be Sprezzatura (Andrew McAuley and co) at www.sprezzatura.co.uk -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dawn M. Wolthuis Sent: 15 April 2004 02:04 To: 'U2 Users Discussion List' Subject: RE: Jbase handles multivalue on RDBMS Do you know if there is a flavor of the type-it-in multivalue query language (e.g. UniQuery) that can be executed against data stored in Oracle, DB2, SQL Server, etc? I know that DataBASIC can be with jBASE and ONGroup, for example. --dawn Dawn M. Wolthuis Tincat Group, Inc. www.tincat-group.com Take and give some delight today. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of djordan Sent: Thursday, April 15, 2004 12:27 AM To: 'U2 Users Discussion List' Subject: Jbase handles multivalue on RDBMS Hi Steve Just to correct you, jbase does not require you to move to 1NF files to run on an RDBMS. Jbase will port multi dimensional data across to an RDBMS and automatically handle the conversion to multiple tables invisible to the application. The issue is in the quality of the dictionary, like lengths and data types that RDBMS do not handle breaking the rules. Jbase does handle a lot of these issues and I would assume IBM will incorporate that in U2. Also in such an environment you would not move all your files over to an RDBMS, it would make sense to leave work files and control files in Universe which are usualy the worst offenders. If you wish to make your application portable in a future environment like this, look at SQLising your files including multivalues and starting cleaning your data as this will be your biggest issue, not multivalues. Just another point, jbase does the same for Cache, which is another multi-dimensional database, although not PICK. Regards David Jordan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steve Mayo Sent: Thursday, 15 April 2004 4:01 AM To: U2 Users Discussion List Subject: RE: The future of U2 The way that jBase handles the problem is by requiring the database be flattened out (i.e., no multivalues) and strict data typing. This is of course the standard with 1NF databases. Unfortunately for most of us, it means a complete redesign of the existing mv database structure. Over the past several years, all new systems that I have developed have used 1NF. Still most of the data still uses multivalues and would take years to convert. :-) Steve -- 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: PI Open is going away
Well, I'm hanging on to my Leo III docs - just waiting for someone to come up with an emulator for the intel platform! CLEO anyone? The System/4 stuff went ages ago. Derek Falkner Kingston, Ontario, Canada -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Keith Upton Sent: April 16, 2004 9:19 AM To: U2 Users Discussion List Subject: RE: PI Open is going away I was at Hoskyns, did a bit of gin for George II+... or our version of it! -Original Message- From: Martin Phillips [mailto:[EMAIL PROTECTED] Sent: 16 April 2004 14:19 To: U2 Users Discussion List Subject: Re: PI Open is going away Funny that... I was only thinking the other day that I should throw out my ICL 1900 COBOL and PLAN Manuals!!! :-) snip -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Performance Degraded running u10.0.0 in Aix 5.2 ML 2
HI All, Before doubling you swap space, check to see how much you are using at your busy times. We have an 8 Gig system, and a 6 Gig pool: Page Space Physical Volume Volume GroupSize %Used Active Auto Type paging00hdisk1rootvg6144MB 2 yes yeslv Everyone into the pool! Regards, Steve Ferries Vice President, Information Technologies Total Credit Recovery Limited -Original Message- From: Anthony Youngman [ mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Sent: Friday, April 16, 2004 9:31 AM To: U2 Users Discussion List Subject: RE: Performance Degraded running u10.0.0 in Aix 5.2 ML 2 Okay, it's AIX not linux, but I've just noticed that RAM = swap. You are an ABSOLUTE FOOL if you do that on linux. Maybe (or maybe not) the same applies to AIX - quite likely since they are both nixen and probably manage memory similiarly. Double swap space to 8Gb and see if that improves matters. Oh - and if you don't believe me, a swap = ram configuration will CRASH the early vanilla 2.4 kernels and that's 2002 vintage. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [ mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] On Behalf Of Scott Richardson Sent: 16 April 2004 14:06 To: U2 Users Discussion List Subject: Re: Performance Degraded running u10.0.0 in Aix 5.2 ML 2 Performance of UV applications on various Operating Systems is not rocket science. Perhaps better described as large, nasty tight onions that need peeling, one layer at a time, and understanding what each peeled layer is doing and why. Once this knowledge is acquired and understood, a plan can be built and executed to attack/resolve the problem. Are users logging out/off when they're done using the system, or when they've completed some large tasks or operations? How often is the system rebooted? RAID 5 file systems can slow down IO. We'll need specifics on file system setup and parameters. How many users? What are these users doing? Have you got everyone and their siblings all running SELECT and SORT operations all the time? Data Entry out the wazoo? How big are the files, and how are they sized? How frequently does data change in the files, (grow, shrink, etc...) How big is your /tmp file system, and what kind of file system, and where is it physically located?? Provide it it's own file system, on it's own disk or disk set, (i.e. not the same disks where other activity is going on). 4GB of RAM, yet only 4 GB paging/swap space? Where is this swap paging space, (i.e. what disks?) topas may be fine for quick and dirty analysis and understanding, but using it extensively can help contribute to performance problems. You need to configure and tune the platform, the OS, the UV DB, the IO sub-system, the applications, the users, and the administration/operations, and thenensure they're all coordinated with each other, to maximize platform performance. To find, (and therefore address resolve), the root causes of what is happening here, you need to profile the platform using something such as the DPMonitor, (extremely low-overhead monitoring Agent) and display/crunch the performance metrics on another platform, (i..e. a Windows Performance Explorer Console). Using this method, you'll be able completely profile the entire platform, (OS and applications), around the clock, and then easily dial into specific timeframes where problems are occurring, and fully understand exactly what is happening and learn why it is happening, so it can be addressed and resolved, and measure the progress along the entire way. The DPMonitor is available with a free 10 day evaluation license where it will track system-wide performance metrics. Fully licensed version will track individual processes that you select, or all processes if you so desire. When you monitor all of the processes, you can quickly and easily identify processes deserving further analysis, and stop tracking processes that are not casuing any problems. More information on the DPMonitor can be found at http://www.deltek.us http://www.deltek.us and the DPMonitor can be downloaded right off the website. If you're short on memory, DPMonitor will allow you to see how much memory you will need to allow the system to run as fast as it can, given how you're running it. If you need tuning of OS or UV parameters, or other things that ay be playing contributing factor/roles, the DPMonitor will clearly point this out, grahically, so that anyone can plainly see what is happening. Once you make any changes, you'll be able to monitor, and measure, any differences, consistently, and prove whether or not you have improved, or detrimented, your cause. Best of all, you'll be able to show, prove, and justify to management what you're doing, and why, and show them what it will take to get the problems addressed and resolved, positively, without question. Hope this helps. I know the DPMonitor can will help. I have used it personally,
Re: Installation unirpc
First off, try killing iptables. Even if you tell RH9 that you don't want a firewall, it still installs it and can cause this type of trouble. HTH, David Beahm Christophe Marchal wrote: Hello, I have installed universe 10.0 on a redhat 9. It works well on a telnet, unirpc daemon is running but I could not established an ODBC connection. Some knows what should be configure on the new server to get odbc works ? thanks for help, Christophe -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UniVerse vs Progress Performance
I thought that Progress lives as more-or-less a traditional SQL database. Please clarify...What is special about Progress ? --Bill -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: UV to Text Conversion Standard?
In a message dated 4/15/2004 12:52:51 AM Pacific Daylight Time, [EMAIL PROTECTED] writes: You can use the UniVerse ODBC Driver to pull the data from UniVerse to Excel, using correct dictionaries UniVerse will normalise the data and sort out the VM and SVM for you. Jonathan can you give a exact method for sorting of SVM's within Universe using an ODBC (or really any tool). I am not aware of this Thank you Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Database decoupling (Was: Future of U2)
In a message dated 4/15/2004 4:37:24 AM Pacific Daylight Time, [EMAIL PROTECTED] writes: Without this ability, I see no reason why anyone would commence new application development on the U2 platform. Since you will always require another application server (Websphere, Tomcat, Bea, Jboss, etc.) to talk to the U2 server, that would in-turn interact with the database. I'm sure Mark you mean New application development that must have a web presence. Unless you feel that all application development must have a web presence. Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: UV to Text Conversion Standard?
In a message dated 4/15/2004 6:12:27 AM Pacific Daylight Time, [EMAIL PROTECTED] writes: Will - your posting mentioned CONVERT(VM,|, mydata) - my version of UV does not seem to like that. Jim, Excel CAN read comma delimited data. Ask again why the requirement for fixed length? Excel DOES NOT NEED fixed length :) Ok now having said that. Type HELP BASIC CONVERT to see what options you have and what the syntax is for your version. Barring that, presumably you are using UV 8.0 or lower or something... Then you can achieve the same result with a loop on WhereVM = INDEX(MYSTRING,@VM,1) mystring = mystring[1,wherevm-1]:,:mystring[wherevm+1,len(mystring)] -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Jbase handles multivalue on RDBMS
In a message dated 4/15/2004 9:53:43 AM Pacific Daylight Time, [EMAIL PROTECTED] writes: And for the not so faint of heart, jBASE provides the capability to roll your own driver(s) to transform your MV database definition into the relational database without using the jEDI development kit. Tom Firl Columbia Ultimate And I can use my shoe as a hammer, but of course it doesn't work so well that way. Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: RedBack from .net
David and Graham, Thanks for mentioning the U2 .NET white paper. It was encouraging to see that IBM is still developing U2. The code examples listed in the white paper were almost identical to the code I had written to access a RedBack object and call its methods through the OleDb provider. Unfortunately, I get the same results as I had gotten originally. The call comes back with the schema of all the properties (including any custom properties that I pass to the method), but no data. We're currently running RedBack 4.1.3.2. I've had success using regular ADO (via COM interop) to call an RBO, so I think that's my best option until IBM releases the next version of RedBack. Is there a list to which I can subscribe to receive announcements of U2 product releases/updates? We purchased our U2 products through a reseller (Jenkon) and IBM won't allow me to access the U2TechConnect site. Thanks, -Tony Tony Evans Web Developer Richmont -Original Message- From: djordan [mailto:[EMAIL PROTECTED] Sent: Thursday, April 15, 2004 7:28 AM To: 'U2 Users Discussion List' Subject: RE: RedBack from .net Graham There is a white paper on U2 .Net on the IBM U2 web page. This had some references on how to use Redback with .Net Regards David Jordan Managing Consultant [EMAIL PROTECTED] Dacono Holdings Pty Ltd Business Technology Consulting PO Box 909 Lane Cove NSW 2066 Australia Ph 61 2 9418 8329 Fax 61 2 9427 2371 www.dacono.com.au -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, 15 April 2004 5:55 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RedBack from .net Tony RedBack 4.1 is not compliant with .net I have had limited success, see sample code : Dim oRead As New REDPAGESLib.RedObject Try oRead.Open2(ACCOUNT, MODULE:OBJECT) oRead.Property(PROPERTY).Value = oRead.CallMethod(METHOD) Catch Dim theErr = Err.Description End Try Dim b = oRead.Property(PROPERTY).Value New version of RedBack out end of this month which is compliant with .net Regards Graham Can anyone share any experience they've had calling a RedBack RBO from .NET? I've tried the following methods: 1. OleDbConnection to the RedPages OLE DB Provider: results in an error when trying to call the RBO's .Create() method. 2. ADODB Connection (via COM Interop) to the RedPages OLE DB Provider: retrieves the schema (all the property names), but no data, and does not return any error messages. 3. RedObject (via COM Interop to RedPages.dll): I can't set any property values for method calls, so this doesn't work at all. Does anyone have any other ideas? Any help would be greatly appreciated. This email may contain information which is privileged or confidential. If you are not the intended recipient of this email, please notify the sender immediately and delete it without reading, copying, storing, forwarding or disclosing its contents to any other person Thank you Check us out at http://www.btsyntegra.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: Jbase handles multivalue on RDBMS
And for the not so faint of heart, jBASE provides the capability to roll your own driver(s) to transform your MV database definition into the relational database without using the jEDI development kit. Tom Firl Columbia Ultimate And I can use my shoe as a hammer, but of course it doesn't work so well that way. The drivers can be written in BASIC... so any programmer can do it. But, in the context of using DB2 (or some other relational database) as the application's primary data store, writing those drivers in C or C++ will probably yield a little better throughput. You also don't get the other bells and whistles included in the jEDI development kit. Tom Firl Columbia Ultimate -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Database decoupling (Was: Future of U2)
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, April 16, 2004 11:28 AM To: [EMAIL PROTECTED] Subject: Re: Database decoupling (Was: Future of U2) In a message dated 4/15/2004 4:37:24 AM Pacific Daylight Time, [EMAIL PROTECTED] writes: Without this ability, I see no reason why anyone would commence new application development on the U2 platform. Since you will always require another application server (Websphere, Tomcat, Bea, Jboss, etc.) to talk to the U2 server, that would in-turn interact with the database. I'm sure Mark you mean New application development that must have a web presence. Unless you feel that all application development must have a web presence. Will -- 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: Database decoupling (Was: Future of U2)
Well no, not really. I was thinking more in the line of New application development that would like to provide the ability to utilize modern Internet protocols. A web presence would be included in that - but was actually furthest from my mind. B2B interaction for example. Or even internal application integration. Being able to publish web services etc. etc. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, April 16, 2004 11:28 AM To: [EMAIL PROTECTED] Subject: Re: Database decoupling (Was: Future of U2) In a message dated 4/15/2004 4:37:24 AM Pacific Daylight Time, [EMAIL PROTECTED] writes: Without this ability, I see no reason why anyone would commence new application development on the U2 platform. Since you will always require another application server (Websphere, Tomcat, Bea, Jboss, etc.) to talk to the U2 server, that would in-turn interact with the database. I'm sure Mark you mean New application development that must have a web presence. Unless you feel that all application development must have a web presence. Will -- 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: Database decoupling (Was: Future of U2)
I'm just not seeing a great demand for this sort of thing from the majority 10 to 100 user businesses that typically utilize multi-value products. I mean some of my clients, and myself are only just NOW playing with Triggers and transaction sets. Most application are very business oriented, and even getting them up and running with FTPing a product list to a web page, or browsing documentation in HTML or PDF format is a major leap forward. Not saying all businesses are this way. But I'm saying I don't think that is where most of the traditional multi-value market is focused. Will In a message dated 4/16/2004 1:09:48 PM Eastern Daylight Time, [EMAIL PROTECTED] writes: Well no, not really. I was thinking more in the line of New application development that would like to provide the ability to utilize modern Internet protocols. A web presence would be included in that - but was actually furthest from my mind. B2B interaction for example. Or even internal application integration. Being able to publish web services etc. etc. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, April 16, 2004 11:28 AM To: [EMAIL PROTECTED] Subject: Re: Database decoupling (Was: Future of U2) In a message dated 4/15/2004 4:37:24 AM Pacific Daylight Time, [EMAIL PROTECTED] writes: Without this ability, I see no reason why anyone would commence new application development on the U2 platform. Since you will always require another application server (Websphere, Tomcat, Bea, Jboss, etc.) to talk to the U2 server, that would in-turn interact with the database. I'm sure Mark you mean New application development that must have a web presence. Unless you feel that all application development must have a web presence. Will -- -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: PI Open is going away
PI/Open-ers, I'd like to write a 'memorial' article for Database Trends acknowledging the PI and Prime contributions to the community as a whole. Would a few of you be willing to write up some brief paragraphs on things like: So I said to Mike, we'll call them I Descriptors and he said it would never catch on... In other words, I'd like to collect some personal stories about how these functions came about. If I get enough (and enough variety) I'll present it to my editors. Contributions to: [EMAIL PROTECTED] -- Sincerely, Charles Barouch www.KeyAlly.com [EMAIL PROTECTED] -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: PI Open is going away
Like when PI 5.4 was supposed to come out with Relational features and then we backed them out of the release? Results wrote: PI/Open-ers, I'd like to write a 'memorial' article for Database Trends acknowledging the PI and Prime contributions to the community as a whole. Would a few of you be willing to write up some brief paragraphs on things like: So I said to Mike, we'll call them I Descriptors and he said it would never catch on... In other words, I'd like to collect some personal stories about how these functions came about. If I get enough (and enough variety) I'll present it to my editors. Contributions to: [EMAIL PROTECTED] -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UV to Text Conversion Standard?
I've done lots of tables in UniData with VM levels of data. We only have a couple of files that have SVM level data - a co-worker of mine set at least one up that was working with Crystal reports. For the multi-values it simply keeps the information that it needs to access it as part of the primary key. I would think that it simply does the same with subvalues. You just appear to have a lot more tables and some of them have some pretty funky primary keys. 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: Geoffrey Mitchell [mailto:[EMAIL PROTECTED] Sent: Friday, April 16, 2004 12:06 PM To: U2 Users Discussion List Subject: Re: UV to Text Conversion Standard? To my knowledge, no. Not in Universe anyway. I *think* (from the docs, I've never played with it) that UniData has a way to map sub-values to ODBC/JDBC, but UniVerse does not. Multivalues work fine, but it doesn't go any lower than that. Best answer: don't use sub-values. They're evil, anyway. On Fri, 2004-04-16 at 12:48, [EMAIL PROTECTED] wrote: Thank you, but what is the exact method to do this? I have never seen a view of SVM level data that actually works. Using ODBC or any other tool And by works I mean that it understands the relationship of the SVM data to the VM data and the relationship of that to the AM data and properly processes table-in-a-table configurations for editing, etc. It's one thing to use BY-EXP to understand VM level tables, but can you really use some tool to understand SVM embedded data at that second table level? Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Crystal Reports
Crystal is indeed a very fine product. It is a banded report writer with a multitude of programmability. Multivalued data is indeed a pain in the neck. Normalize the data 1st and you'll find Crystal a joy to use with output, features and polish that MV can't come close to. The 'problems' that your users are facing can be addressed with Crystal code (VB syntax or Crystal's scripting syntax). After using it a while, you'll never want to go back... Mike R. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson Sent: Friday, April 16, 2004 2:51 PM To: U2 Users Discussion List Subject: Crystal Reports One of my clients wants to connect Crystal Reports to their UD database to apparently give greater access to the data that they sometimes deem as hidden and only accessable through me. This client converted to Great Plains 6 weeks ago (SQL based) and their CR experts were struggling with duplicating some of the more mundane reports that already exist in UD. A monthly sales tax summary (by jurisdiction) took the GP guy 3 days futzing with CR using GP's data. How much trouble are they going to get in trying to use MV'd data from the UD system (ODBC) if they have so much trouble with more 'normalized' data. Everyone seems to think that CR is a magic pill and once attached to a SQL database, the sophisticated reports simply roll off. I'm trying to strongly propose a data warehouse concept whereby the day's sales data gets exported and updated into their prior application for the sake of the multitude of existing, proven reports in MV. If these guys took 3 days for a simple tax report, how can CR fabricate temporary tables for the sake of these consolidated sophisticated MV reports? I'm just interested in hearing of some experiences. This client is too stubborn to go back from GP and may even disregard their entire MV system completely. I really have nothing to lose if I insult them. Thanks in advance. -- 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: Crystal Reports
Mark, it's interesting to see this project unfold, please do keep us up on events there. (Ready for some acronym soup?) Crystal Reports is heavily tied to .NET these days. Microsoft has selected CR for integration with Great Plains, so there is a high level of commitment to the CR/GP/.NET links. It shouldn't be a problem to create a middle-tier which interfaces data from both GP and UD into CR via ADO.NET.ADO.NET is _not_ ADO, which was basically supposed to be an upgrade to ODBC. In addition to other things, ADO.NET is really a data hub which allows you to create a source-independent set of tables and relations. The end result is that CR doesn't know or care where the data is coming from, it comes from an ADO.NET data model. How you get the data into ADO.NET is up to you. My recommendation is to take a look at the Pick Data Provider .NET from Raining Data, another product which has endorsement from Microsoft. Pricing is very reasonable, it's stable, well documented and supported. Since there are questions about other interfaces working with U2 from .NET, like RBO's, UniObjects, UniODBC, etc, it seems reasonable to choose a connectivity module that was written for the purpose. Using technology that is endorsed by Microsoft from end to end should give you some political leverage as well, since that seems to be a priority with management there. [Ad] Here at Nebula RD, we can prototype a report on a TM basis, even going all the way back and forth between GP, MV, and CR. I honestly have no idea how long it would take without looking at this closer, but the tools are available, we have everything here, it's just a matter of connecting the dots. (Nebula RD is an authorized Raining Data reseller and MSDN Universal Developer.) If you'd like to contract for more specific work, we now have highly qualified people available to do this sort of work (MS MVP/MSDE trainer/developers), and we'll be happy to take a back seat and let you get the glory as projects are completed. Good luck. Tony [EMAIL PROTECTED] 949-380-1668 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson Sent: Friday, April 16, 2004 11:51 AM To: U2 Users Discussion List Subject: Crystal Reports One of my clients wants to connect Crystal Reports to their UD database to apparently give greater access to the data that they sometimes deem as hidden and only accessable through me. This client converted to Great Plains 6 weeks ago (SQL based) and their CR experts were struggling with duplicating some of the more mundane reports that already exist in UD. A monthly sales tax summary (by jurisdiction) took the GP guy 3 days futzing with CR using GP's data. How much trouble are they going to get in trying to use MV'd data from the UD system (ODBC) if they have so much trouble with more 'normalized' data. Everyone seems to think that CR is a magic pill and once attached to a SQL database, the sophisticated reports simply roll off. I'm trying to strongly propose a data warehouse concept whereby the day's sales data gets exported and updated into their prior application for the sake of the multitude of existing, proven reports in MV. If these guys took 3 days for a simple tax report, how can CR fabricate temporary tables for the sake of these consolidated sophisticated MV reports? I'm just interested in hearing of some experiences. This client is too stubborn to go back from GP and may even disregard their entire MV system completely. I really have nothing to lose if I insult them. Thanks in advance. -- 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
Performance Degraded running u10.0.0 in Aix 5.2 ML 2
We upgraded UniVerse 10.0.11 from AIX 4.3.3 to AIX 5.2 last October. We also run Oracle and Vantive on the same box. One thing we have found is that we need to have at least twice the amount of Paging Space as real memory. If the free Paging Space gets down to zero the machine dies a horrible death. As I understand it with AIX the data is first written to the Paging Space then to memory - rather unusual. So if your Paging Space is low then you may be doing a lot of swapping out to somewhere else. After the upgrade we noticed that the batch processes were faster but we did notice a degradation in the user interface for Oracle / Vantive although not noticeable with UniVerse. When you run topas check to see if there are any processes consuming large amounts of cpu constantly. One of our non-UniVerse applications suffers from run-aways and we see them consuming one cpu each constantly. Fortunately we have 4 cpus so can live with these run-aways (as we cannot remove them without dropping multiple users in critical applications). If you get more run-aways AIX will drop their priority so this will become less obvious - but it will affect all users of the machine. It is not common to have UniVerse run-aways but we have seen it infrequently. If you see a process consuming high cpu look at it in PORT.STATUS to see what it is doing. Check you are not using PORT.STATUS for any utilities that run often. This can have a major effect on the performance of the machine. Also topas has an effect as well. We are not running any ML patches on our production machine as neither ML1 nor ML2 are compatible with one of our other applications - the one that runs away. Generally we are very pleased with the performance on AIX - only management wants us to move from this platform. Our approx specs are p660, 4 cpu, 6Gb RAM, 12Gb Paging Space Universe 10.0.11, 320 users Oracle 9.2 - usually about 600 oracle processes Vantive 9 - 100 processes each with up to 5 threads Sara Burns Sara Burns (SEB) Development Team Leader Public Trust Phone: +64 (04) 474-3841 (DDI) Mobile: 027 457 5974 mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Information contained in this communication is confidential. If you are not the intended recipient the information should not be used, disclosed, copied or commercialised. The information is not necessarily the views nor the official communication of Public Trust. No guarantee or representation is made that the communication is free of errors, virus or interference. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Crystal Reports
Take the Lead If they have SQL Server already, build a mini datawarehouse that you populate Daily, and then set up the new Report Services of SQL Server which is a free add on to SQL Server 2000. In somes ways it has some better features than Crystal reports. It gives your system a fresh face for little work and will keep the MV system in the organisation. Crystal Reports is a good tool, but when it comes to complex reports, I can quicker write a Basic Program to achieve the result than a good Crystal Reports programmer will achieve the results. The big thing for you is the user just wants to feel in control of data access and this can be achieved in a number of ways even if it is a perception. Regards David Jordan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson Sent: Saturday, 17 April 2004 4:51 AM To: U2 Users Discussion List Subject: Crystal Reports One of my clients wants to connect Crystal Reports to their UD database to apparently give greater access to the data that they sometimes deem as hidden and only accessable through me. This client converted to Great Plains 6 weeks ago (SQL based) and their CR experts were struggling with duplicating some of the more mundane reports that already exist in UD. A monthly sales tax summary (by jurisdiction) took the GP guy 3 days futzing with CR using GP's data. How much trouble are they going to get in trying to use MV'd data from the UD system (ODBC) if they have so much trouble with more 'normalized' data. Everyone seems to think that CR is a magic pill and once attached to a SQL database, the sophisticated reports simply roll off. I'm trying to strongly propose a data warehouse concept whereby the day's sales data gets exported and updated into their prior application for the sake of the multitude of existing, proven reports in MV. If these guys took 3 days for a simple tax report, how can CR fabricate temporary tables for the sake of these consolidated sophisticated MV reports? I'm just interested in hearing of some experiences. This client is too stubborn to go back from GP and may even disregard their entire MV system completely. I really have nothing to lose if I insult them. Thanks in advance. -- 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: PI Open is going away
Goo'day, Martin, At 18:53 16/04/04, you wrote: I was one of the two technical managers for the development of PI/open. It's always sad watching a product that you worked on be put into retirement. Perhaps I can now throw out my collection of PI/open manuals. And stop telling QM users That's how it's done in PI/open, so that's how we're doing it here!!! ??? ~8^)) Martin Phillips Ladybridge Systems 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB +44-(0)1604-709200 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- Incoming mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.230 / Virus Database: 262.8.3 - Release Date: 15/04/04 Regards, Bruce Nichol Talon Computer Services ALBURYNSW 2640 Australia Tel: +61 (0)411149636 Fax: +61 (0)260232119 If it ain't broke, fix it till it is! -- Outgoing mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.230 / Virus Database: 262.8.3 - Release Date: 15/04/04 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: UV Crash on W2K3
In a message dated 4/16/2004 3:38:16 PM Pacific Daylight Time, [EMAIL PROTECTED] writes: 1.is this a problem with PROCS - does anyone else run a UniVerse system on NT which relies on PROCS to launch several layers of programs? Sara can you explain this more? Perhaps with an example of exactly what you mean? Thanks Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
