RE: [UV] paragraph labels
0001: IF @LOGNAME NE 'FRED' THEN GO OUT : .X BAS BOB filed in file BP. Executing the command BASIC BP BOB. Compiling: Source = 'BP/BOB', Object = 'BP.O/BOB' * Label 'OUT' not defined 1 Errors detected, No Object Code Produced Are you sure there not an include somewhere and this is set up in a common block ? bob -Original Message- From: Barry Brevik [mailto:[EMAIL PROTECTED] Sent: 19 February 2004 22:08 To: U2 list (E-mail) Subject: [UV] paragraph labels On UV versions 9.4.1.1d through 9.6.1.3 as far as I know... We have a great many paragraphs (third party app) that contains a line like this: IF some condition THEN GO OUT ...however, there is no OUT: label in the paragraph. Somehow, this works. Is OUT some kinda built-in label? I'd like to know because I don't want to learn any bad habits g. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com Confidentiality Notice: This e-mail and any attachments are intended solely for the addressee and may contain confidential or privileged information. If you are not the named addressee, or the person responsible for delivering the message to the named addressee, please notify the sender as soon as possible and delete the material from your computer. This message will be protected by copyright. If it has come to you in error, you must not take any action based on its contents nor must you copy or show the message to any person other than the intended recipient. This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: [UV] Very slow SQL query
Hello Björn I build the index and the result is equal. Tanks. -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de Björn Eklund Enviado el: jueves, 19 de febrero de 2004 17:41 Para: 'U2 Users Discussion List' Asunto: SV: [UV] Very slow SQL query Cesar, You need to build the index also, try BUILD.INDEX FILNAME ALL In Unidata that is. Björn Eklund -Ursprungligt meddelande- Från: Cesar Riba [mailto:[EMAIL PROTECTED] Skickat: den 19 februari 2004 17:24 Till: 'U2 Users Discussion List' Ämne: RE: [UV] Very slow SQL query -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de Brian Leach Enviado el: jueves, 19 de febrero de 2004 16:22 Para: 'U2 Users Discussion List' Asunto: RE: [UV] Very slow SQL query César, I think we will need more information to help you. 1. are you running the SQL query at TCL or through ODBC or OleDB? César: I running the SQL query at TCL 2. Can you give the command you are running please. Cesar: SELECT PEDIDO,REFART,DESART,CANTIDAD,CANTMODALB FROM GCMLIAL WHERE EMPALBA = '1*05236' ORDER BY EMP, ALBA, NUMLIN; Cesar: SELECT PEDIDO, SUREF FROM GCMLIAL WHERE EMPALBA = '1*05236' GROUP BY PEDIDO, SUREF; 3. Are there any indexes on the files? (LIST.INDEX filename ALL) Cesar: There aren't indexes on the files, I create index but the result is the same. Regards, Brian Leach -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Cesar Riba Sent: 19 February 2004 15:04 To: [EMAIL PROTECTED] Subject: [UV] Very slow SQL query Hello, I have two files one has 300.000 records and another has 200.000 records, I wante to make SQL Query whit the two files and this takes bettewn 30 seconds and 1 minute to return the result. However, I have a program with BASIC to obtime the same result and it takes less than one second, I have heard that other DB Systems like SQL Server, Oracle, etc... are very fast with the SQL Query. Is this posible or do have I made a mistake? Thanks César -- 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 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: [UV] paragraph labels
This is just plain, simple bad programming. In a paragraph, jumping to an undefined label terminates the paragraph. It is totally unsafe to use this as a nifty way to end because someone might later add the label for some other meaning in the same paragraph. In a Basic program, as one responder showed, you get a compilation error. 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: [UV] Very slow SQL query
César, So the problem is not joins or indices. So it must be somewhere else :-) 1. If you use a SORT command, is that as slow? SORT CCMLIAL BY EMP BY ALBA BY NUMLIN WITH EMPABLA = 1*05236 PEDIDO REFART DESART CANDIDAD CANTMODALB NOPAGE 2. If it is, what are these fields doing? Are they Data fields or I Descriptors? Do any call BASIC subroutines, or do translates (TRANS or XLATE functions?) 3. The obvious one - what is the file sizing like? 4. What does the BASIC program do that is different? There should be no reason for this SQL command to be slow. Brian Leach Hello, I have two files one has 300.000 records and another has 200.000 records, I wante to make SQL Query whit the two files and this takes bettewn 30 seconds and 1 minute to return the result. However, I have a program with BASIC to obtime the same result and it takes less than one second, I have heard that other DB Systems like SQL Server, Oracle, etc... are very fast with the SQL Query. Is this posible or do have I made a mistake? Thanks César 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: @SPAM+++++++++
Doesn't time fly! I can (just about) remember when 1c == 1d. That really DOES go back! Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Neil Charrington Sent: 20 February 2004 10:25 To: U2 Users Discussion List Subject: RE: @SPAM+ Wol, that would be awfully long time ago - an exchange rate of 1.20 to the pound (maybe around 1983ish). For a long time it was at around 1.50 to the pound ;-) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Anthony Youngman Sent: 20 February 2004 09:32 To: U2 Users Discussion List Subject: @SPAM+ $72 per user? That's CHEAP! We pay IBM direct £60 per user. At current exchange rates, that's about $110. In mitigation, though, sterling has been rising markedly of late - not that long ago £60 would have been about $72. Cheers, Wol *** 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: version control software (AD for PRC)
There've been a few people post about the way their company has wrapped a unix or other outside 'change control tool'. I think these are interesting and I admire the technicality that goes into that approach. And I appreciate their sharing it, here. But it stimulates in me a rather wild and uncontrollable desire to express my differences in opinion and approach. It's different when I do it, because this is what I do -- and I have a product to sell. Thus: AD WARNING: Following is a blatant PRC brag and sales pitch thinly disguised as a technical discussion of its approach. (But I will stick with the main technical differences ... unless you want more, then e.mail me!) PRC is a complete software configuration management tool -- including change control / version control -- developed in and for the U2 environment. Besides the obvious -- that it is a finished / supported product -- PRC differs in some basic ways from other mainstream approaches. * PRC is written in and for the U2 environment. * PRC is project-centric, as opposed to file-centric (or item-centric) meaning the versioning is not so much against a specific file (program) (although that detail is kept) but rather the collection of bits and pieces of whatever (program, subroutine, process, paragraph, dictionary, Voc entry, whatever) that comprise the change. * Backward regress-able versions of all changed items are stored -- in their entirety. (And self-managed.) No delta records, to apply in order to 'rebuild' ... you can pull up an old copy and look at it. Or view it against the current version with changes highlighted. * There are tools and utilities so that the programmer -- not from a management perspective but from a head-down/ coders / convenience perspective -- WANTS and LIKES what PRC is doing. This is key, along with ... * Our #1 mission in the development of PRC was that there not be any 'extra' task or step that must be remembered or could be (accidentally or otherwise) forgotten. With PRC you just work as usual -- the software is checked out, reviewed against permissions, backed up and so forth AS YOU GO. No extra steps or checking required. * There are clearances and procedures that can be put into place to handle any emergency or exception without violating audit requirements. * PRC supports he whole SCM /SDLC process from the problem report, through management of the projects (in terms of assigning, scheduling, estimating, tracking progress), the change control piece, test management, deployment and provides a single repository for auditing and reporting. I'll stop now. Reluctantly. :) Susan Joslyn SJ+ Systems Associates, Inc. [EMAIL PROTECTED] PRC(r) Real software configuration management for U2. Message: 2 Date: Thu, 19 Feb 2004 09:53:22 - From: Brian Leach [EMAIL PROTECTED] Subject: RE: version control software To: 'U2 Users Discussion List' [EMAIL PROTECTED] Message-ID: [EMAIL PROTECTED] Content-Type: text/plain; charset=us-ascii Jeff, We use a two pronged attack - I don't think I can share it (sorry) but here is what it does - none of it should be too difficult to emulate: First we have some BASIC routines that stamp our programs with a string in the format: ADGVERDATA='Version=x;' ADGVERDATA:= 'VerDate=xx;' ADGVERDATA:='VerHist=xx' etc. The format of the string means that we can search both source and object code for version stamps (being a variable assignment not a comment they get compiled into the object code string table). We have some simple subroutines that return this version information which we can use e.g. from I-Descriptors to list the versions and from setup routines to check versions; and we have wrappers around our installation routines and checks in the routine we use for any global cataloging to ensure that we don't accidentally catalog an older routine over a newer version. Secondly, we use RCS for delta-ing (we could use CVS but RCS was a simpler option for interfacing). To allow it to handle non-source items (eg dictionaries and parameter records) we wrapper the RCS routines (ci and co) through some routines that essentially maintain an index of the UniVerse location (ACCOUNT DICT FILE LEVEL ITEM) to a numbered UNIX file. These allow allow us to things like accept select lists, so the whole thing is command line driven and very flexible. The routines maintain an index between our version stamps (which are 3 level major.minor.build) and the RCS version (which is 2 level major.minor) so we can search on either. We also apply tags in the index rather than using RCS tags, which are a bit flaky. The routines use the index to copy the item to a type 19 file using sequentially assigned IDs, then commit the copy to RCS. The same index is used to retrieve the item again, and optionally copy the item back to its original location OR to a new location (another reason for using the index). As most of our applications are client/server or Web based, we then
uvbackup
Hi, Can anyone help me with the proper syntax for this problem : I want to backup a single uv file (DYNAMIC) and compress it with gzip in one go, i have no problems doing it in two steps like this : /usr/uv/bin/uvbackup -f -v -l TEST /data1/MEMBERSHIP/GM.MEDLE /backup/GM.MEDLE gzip -9 /backup/GM.MEDLE this leaves me with GM.MEDLE.gz in /backup, very nicely since uvbackup uses stdout and gzip uses stdin it must somehow be possible to redirect gzip output to /backup/GM.MEDLE.gz best regards from denmark Claus Derlien edb-afdelingen direkte : 63 13 86 69 email : [EMAIL PROTECTED] Frie Funktionærer - faglig organisation og tværfaglig a-kasse - www.f-f.dk *** Denne email og alle filer vedlagt som bilag kan indeholde fortroligt materiale, der kun er beregnet for adressaten, og maa ikke udleveres eller kopieres til uvedkommende. Har De ved en fejltagelse modtaget denne email, bedes De venligst omgaaende meddele os dette pr. telefon : 6313 8550. Paa forhaand tak. *** This email and any files transmitted with it may contain confidential information intended for the addressee(s) only. The information is not to be surrendered or copied to unauthorised persons. If you have received this communication in error, please notify us immediately by telephone: +45 6313 8550. Thank you. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: version control software (AD for PRC)
Susan Joslyn wrote: AD WARNING: Following is a blatant PRC brag and sales pitch thinly disguised as a technical discussion of its approach. (But I will stick with the main technical differences ... unless you want more, then e.mail me!) He he... nvm the bad disguised shameless ad, your product looks cool, last year we had the pleasure of being educated a bit in SB+ by Susan's sister, and she also told us some good things about PRC :-) If I have an 8 user developer machine running linux + uv 10.1 and a 75 user production machine running linux + uv 10.1 will PRC then be able to deploy from the test machine to the production machine ?? If its project oriented, can you use it to keep track on status for a project like time used etc etc. ?? and when a project is finished can you write out all source code nicely on paper and also make a report on all the changes ?? We could seriously use a product like that! best regards from deepfreezing denmark Claus Derlien Frie Funktionærer - faglig organisation og tværfaglig a-kasse - www.f-f.dk *** Denne email og alle filer vedlagt som bilag kan indeholde fortroligt materiale, der kun er beregnet for adressaten, og maa ikke udleveres eller kopieres til uvedkommende. Har De ved en fejltagelse modtaget denne email, bedes De venligst omgaaende meddele os dette pr. telefon : 6313 8550. Paa forhaand tak. *** This email and any files transmitted with it may contain confidential information intended for the addressee(s) only. The information is not to be surrendered or copied to unauthorised persons. If you have received this communication in error, please notify us immediately by telephone: +45 6313 8550. Thank you. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: uvbackup
Original Message- From: Anthony Youngman [mailto:[EMAIL PROTECTED] Sent: Friday, February 20, 2004 12:04 PM To: U2 Users Discussion List Subject: RE: uvbackup Replace the file concatenate symbol with the pipe symbol |, and then follow that directly with the gzip command. /usr/uv/bin/uvbackup -f -v -l TEST /data1/MEMBERSHIP/GM.MEDLE | gzip -9 /backup/GM.MEDLE.gz Thanks alot. Made my day a lot more easier, im writing a wrapper to move selected data from production to test i guess its fairly safe to use uvrestore to restore to a live environment (TEST machine) anyway im back on track :-) best regards from sunny but icecold denmark Claus Derlien Frie Funktionærer - faglig organisation og tværfaglig a-kasse - www.f-f.dk *** Denne email og alle filer vedlagt som bilag kan indeholde fortroligt materiale, der kun er beregnet for adressaten, og maa ikke udleveres eller kopieres til uvedkommende. Har De ved en fejltagelse modtaget denne email, bedes De venligst omgaaende meddele os dette pr. telefon : 6313 8550. Paa forhaand tak. *** This email and any files transmitted with it may contain confidential information intended for the addressee(s) only. The information is not to be surrendered or copied to unauthorised persons. If you have received this communication in error, please notify us immediately by telephone: +45 6313 8550. Thank you. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: [OT] Looking for U2 owners in northern suburbs PA, USA
pickjobs.net -Original Message- From: Mark Johnson [mailto:[EMAIL PROTECTED] Sent: Thursday, February 19, 2004 11:20 PM To: U2 Users Discussion List Subject: Re: [OT] Looking for U2 owners in northern suburbs PA, USA go to pickjobs.com. there's one in wilkesbarre. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
wIntegrate Lookup Box
All, I am a little green with using wintegrate so please bear with me. I am trying to populate a lookup box with a list using WIN.LOOKUP on V3.0.7. I get a script error if the list is too big for the box it appears. Any thoughts would be appreciated. Thanks, Les -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Unicode for System Builder
Does anyone have knowledge or experience of using UniData double byte and SB+ to implement an application in Chinese? Does SB+ support Unicode? Thanks ...OLE_Obj... Tom Jobe Database Administration Group Yamanouchi Consumer, Inc. 4747 Willow Rd Pleasanton, CA 94588 Phone: (925) 924-2156 Fax:(925) 924-3660 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Unicode for System Builder
i'm looking for the same thing, but for straight Unidata code. At 08:31 AM 2/20/04 -0800, you wrote: Does anyone have knowledge or experience of using UniData double byte and SB+ to implement an application in Chinese? Does SB+ support Unicode? Thanks ...OLE_Obj... Tom Jobe Database Administration Group Yamanouchi Consumer, Inc. 4747 Willow Rd Pleasanton, CA 94588 Phone: (925) 924-2156 Fax:(925) 924-3660 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users Thank you, Peter Gonzalez Senior Programmer -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Unicode for System Builder
Didn't we just see this same message from Bruce @ YCI (same company)? You might check w/ Bruce to see if he received any offline info. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Friday, February 20, 2004 9:32 AM To: [EMAIL PROTECTED] Subject: Unicode for System Builder Does anyone have knowledge or experience of using UniData double byte and SB+ to implement an application in Chinese? Does SB+ support Unicode? Thanks ...OLE_Obj... Tom Jobe Database Administration Group Yamanouchi Consumer, Inc. 4747 Willow Rd Pleasanton, CA 94588 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: wIntegrate Lookup Box
I think there is a 32k limit on the size of a variable in v3 of wIntegrate. [EMAIL PROTECTED] wrote: All, I am a little green with using wintegrate so please bear with me. I am trying to populate a lookup box with a list using WIN.LOOKUP on V3.0.7. I get a script error if the list is too big for the box it appears. Any thoughts would be appreciated. Thanks, Les -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UniVerse and Backup Exec
snip Excellent write up Tom. This is a keeper email. Thanks, -Doug snip Yes, Tom. The Windows SharedSection registry tweak write-up was great. I apologize for neglecting to acknowledge it sooner! Thank you, Gwen Buck -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: recursive values
is this one record or two records ? Notice of Confidentiality: The information included and/or attached in this electronic mail transmission may contain confidential or privileged information and is intended for the addressee. Any unauthorized disclosure, reproduction, distribution or the taking of action in reliance on the contents of the information is prohibited. If you believe that you have received the message in error, please notify the sender by reply transmission and delete the message without copying or disclosing it. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: recursive values
You mean repeating values. You have BY-EXP don't you? From: [EMAIL PROTECTED] on behalf of Dave Raven Sent: Fri 2/20/2004 2:03 PM To: [EMAIL PROTECTED] Subject: recursive values I am using Universe and am looking for a way to have recursive values in my retrive report. I would like to export this report to a spreadsheet. The pick command for a dictonary would be LPV (last previous value) and I have tried TRANSPORT. report name... street ... city Raven 1234 IRVINE A STREET Would like this name... street ... city Raven 1234 IRVINE Raven A STREET IRVINE Dave R P.O. Box 17811, Irvine CA 92623-7811 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users Our company accepts no liability for the content of this email, or for the consequences of any actions taken on the basis of the information provided, unless that information is subsequently confirmed in writing. Any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. 11/29/2003 ACE Software, LLC -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: recursive values
Did you tried with the REUSE en the dictionary ? -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] En nombre de Dave Raven Enviado el: viernes, 20 de febrero de 2004 13:03 Para: [EMAIL PROTECTED] Asunto: recursive values I am using Universe and am looking for a way to have recursive values in my retrive report. I would like to export this report to a spreadsheet. The pick command for a dictonary would be LPV (last previous value) and I have tried TRANSPORT. report name... street ... city Raven 1234 IRVINE A STREET Would like this name... street ... city Raven 1234 IRVINE Raven A STREET IRVINE Dave R P.O. Box 17811, Irvine CA 92623-7811 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: recursive values
snip report name... street ... city Raven 1234 IRVINE A STREET Would like this name... street ... city Raven 1234 IRVINE Raven A STREET IRVINE /snip BY.EXP STREET would separate your MV'd street field unacceptably. A quick dirty would be to create I-Types for your name and city fields, each of which would DCOUNT the values in street and construct a MV'd repeating list of the name/city with a matching number of values. Make sure the new I-Types are defined as Multivalued, and this should give you the output you are looking for. Jim -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Damaged files
John; There are a couple of tools for file repair that I miss from D3. The good thing is I don't have to worry about it much :-). 1. Yes, I at least hope you wrote a program to do that all for you. Generally, I copy the file at the OS level (after making sure no one will access it etc). I then try to resize the file. It will often times clean up this kind of stuff. It pretty much just copies the items out and back in. There is also a File Fixing document on the U2 TechSupport Survival CD. It provides a lot of techniques for fixing file corruption. 2. If the file is damaged in certain ways I've had these fail. Yes, it's very annoying. 3. RECORD filename ID will list everything in the group that the ID hashes to. I've only found dumpgroup to give the items in a group - so if you don't have a key that hashes to that group you're in for the hunt-and-peck method. Perhaps the fileview utility would help here - I haven't had the time to go work with it much. 4. The file fixing documentation on the Tech Survival CD has some good advice. I don't know if any of the UD courses go into the file structure. 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: John Cassidy [mailto:[EMAIL PROTECTED] [snip] 1. I'm sorry, but this was the best I could come up with after many hours. Please tell me there's a better way. 2. Why did dumpgroup/fixgroup fail? Isn't this what they're designed to do? 3. Is there another way to extract the keys from a damaged UniData file? 4. Is there a white paper or available technical document which describes, in some detail, the structure and layout of UniData files, which would aid me in writing my own utilities? -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UniData 6.0.b Clients - now on PE download site
Does anyone have a list of the new features or bug fixes for 6.0b? It seems that each individual product (UniDK, UniAdmin, etc.) each has its own version number so it doesn't really specify what has changed from 6.0. Thanks. Regards, Jim I had the current clients posted on the PE site to replace the original 6.0 clients. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Unidata, Monitoring system parameters
Date: Thu, 19 Feb 2004 18:50:24 +1100 From: Ken Wallis [EMAIL PROTECTED] Subject: RE: Unidata, Monitoring system parameters James Hogan wrote: From time to time we have customers who break a Unidata parameter and the program they are running will crash with errors such as No more entries in MI table in 'LCT -n'. [snip] I have had a look at the commands sms, gstt and lstt. With some clever scripting these could be used to take snap shots of the system periodically to check for an over step of the parameters. The script could then warn the user if any parameter is over 80% utilised. :I doubt it could warn them in time James. When programs go wild and eat smm resources they tend to do it in a big hurry. With decent tuning you should be able to find a reasonable compromise between making lots of memory available for big jobs without lumbering little jobs with a huge footprint. Even on AIX now there are some extended shared memory facilities which allow you to have more segments instead of just making them all huge! I can't remember the exact details but EXTSHM rings a bell. Cheers, Ken Hello James Hogan,of Sungard and Ken Wallis, I have been getting the U2 Users Daily Digest for a for weeks now, after getting individual emails for the longest time. I just caught this thread, and had to get in on this. What James Hogan wants to accomplish can be done. There are products out there such as the DPMonitor that do exactly that. There are several key factors though: 1) Situations like that require constant monitoring, and mapping out of platform operational dynamics, and knowing the behaviors that occur when things start to go wrong. 2) The Monitor needs to be external to the application server being monitored. You need a real low overhaed process (Agent) on the Application Server doing low level kernel calls, consistently, over time, and establish what the operational baseline characteristics of the application are in normal mode. A real key is having that Agent talking to an Operations Console Performance Explorer and Alert Center, and having Probes, or Alarms set up, to notify Operations in things get out of whack, and therefore allow corrective action to take place before the application server or process gets hung. Imagine that - a proactive response as compared to a reactive response. 3) You can't run such standard system commands/programs/utilities, especially ones on the application server being monitored, as they consume significant volumes of resources, and contribute to the problem, if they ever report back to you, (such as Ken mentions). So, what do you do? Reinvent the wheel with some configuration of scripts? The smart choice is to download and evaluate the DPMonitor Performance Monitoring Solution. The licensed version will monitor individual, user-selected processes, in addition to the system wide parameters and metrics. You can set up Probes to test and watch for certian conditions or thresholds to be crossed, and then take pro-active, pre-programmed by the user responses to those situations, or simply generate an email, a page, or what have you. DPMonitor has Performance Agents for AIX, Solaris, and Windows. Even an Oracle Agent. U2 Products and applications can be monitored via individual per process monitoring. One Performance Explorer can display Agent data from all Agents, for centralized Enterprise, or ASP providers. Very easily installed and set up, and provides dynamic scaling, colorful, detail graphs of the health and resource level consumption of the application server platform, history of resource consumption, aggregation, and user-selectable timeframe periods for display. Dial right into problems situations quickly and easily and understand exactly what is going on, when it happens, and what ripple affects it causes in paltform operational dymanics. Real easy to solve the problems if you have a clear roadmap. DPMonitor provides that roadmap, at reasonable pricing. Check out the significantly updated www.deltek.us websoyte for product information and examples of how the DPMonitor could be easily quickly setup to provide exactly the type of application server monitoring James at Sungard was asking about. Regards, Scott Richardson Senior Systems Engineer / Consultant Marlborough, MA 01752 Email: [EMAIL PROTECTED] Web: http://home.comcast.net/~CheetahFTL/CC eFax: 208-445-1259 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users