RE: [U2] [Udt] RFS and NFA performance
Martin Phillips wrote: > I am looking for some information about the performance > impact of using the > RFS and NFA components of Unidata.. > > 1. Does anyone have experience of just how much use of RFS degrades > performance? The application concerned does not currently > use transactions > though this would be beneficial if the RFS mechanism is to > give business > level data integrity. Martin, my problem with answering this is that while I've got plenty of experience with UniData sites that run RFS and plenty with ones that don't, I've never really had a site go from 'without' to 'with' on the same box so I could do a comparison. Clearly there is more load on the box with RFS active. Beyond this, it also seems clear that batch update operations where the WRITE to READ ratio is pretty high, and where a large portion of certain key data files gets updated can run substantially slower with RFS active. I have a large site that runs exclusively with RFS during the day, but which switches RFS off every night to do their EOD because otherwise it takes too long - maybe 50% longer than the current 3.5 hours or so. During the day however, they don't seem to have any issues with interactive response and perceived performance of reporting etc with RFS running. IBM have always said lots of guarded things about memory requirements and performance with RFS, but I've never really subscribed to that negativity. These days 4MB per user isn't actually a great deal, and I'm not sure I've seen usage that high. Certainly though, it is vital to configure RFS properly before using it in production. Under no circumstances should you just say 'Yes' to the question udtinstall asks about using RFS and leave it at that. You need to allocate log space intelligently, and you need to configure buffer sizes generously. If the client wants benefits from RFS then they need to use archiving so they have a rollforward path, and if you simply switch that on 'out of the box' you are certainly asking for trouble. Email me offline if you want more details. > 2. The same client is looking to use NFA to access files on > other systems in > a wide area network. Any information about experiences of its > performance > would be much appreciated. NFA isn't a performance hog, but you wouldn't want to do all your IO across it, and you can't cleanly have it interact with RFS - ie you can't have a transaction which updates both local and remote files. Cheers, Ken --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Universe/wIntegrate/Thin Client
Please consider re-writing this blurb using indentation and paragraphs. Sorry for the blurbyness of the message. I find that if spend a lot of time making it look pretty in my mail client, doesnt mean that it will look good your mail client. Mail clients come in many shapes and sizes. When I got the message relayed back from the list server, it got 'reformatted' a little and doesnt look like it did when I originally sent it. Anyway, sorry to all to be long winded and blurby. Anthony --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.776 / Virus Database: 523 - Release Date: 10/12/2004 --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Resizing All Files in a System
There is an inexpensive tool from U2logic that resizes files using wIntegrate as the front end called U2ReSizer. You can find them at www.u2logic.com. - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, November 24, 2004 7:17 AM Subject: [U2] Resizing All Files in a System > Is there a way to semi-automagically resize all the files in a UniData > account/system? > > When we used Pick D3, we could run a process which would store the mod to > use on restore in the file definition item. If we did a full system file > save and restore, the files would be recreated with the "new and improved" > mod. We use to do this on a fairly regular basis, but since changing to > UniData, we haven't really addressed this. > > I know I can use guide to get suggested resizing, and that I can use > memresize to actually resize an individual file, but is there a way to do > this system wide? We are considering migrating to a newer machine, and > since we would have a system with no users on it for a while, it seems to > be the best time to implement a massive update. > > Pointers to the correct manual would be appreciated, or a brief summary. > I'm certain that this has been discussed before, but I couldn't find it in > the archives. > > --Tom Pellitieri > Century Equipment > Toledo, Ohio > --- > u2-users mailing list > [EMAIL PROTECTED] > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Universe/wIntegrate/Thin Client
Anthony Dzikiewicz wrote: Does this sound like a messy set up ? Would this be robust enough to place at point of sale where the users are basically kids and are by no means technical ? Any comments or insight be anyone who has been down this road would be appreciated ? We use thin clients and also do slave printing, but not in conjunction with each other. Combining the two shouldn't be a problem though. We do slave printing for remote users through Accuterm, and it's pretty simple to set up. You just send an escape sequence to the screen, send all your print data, then send another escape sequence to terminate the print job. The output goes to whatever Accuterm's default printer is. If you're going to do this with thin clients, you're going to need, at the very least, a beefy Windows 2003 server with terminal services. You may want to add Citrix for better speed and better remote printer support. Your users will log into the server to access their windows desktop and have a COM or LPT port mapped to their local thin client's printer. We use the following NeoWare linux thin client, which I highly recommend: http://www.neoware.com/products/eon/eon_e100.html You'll want to get the ghostscript and thinprint snap-ins (free). Ghostscript will let you use a non-postscript printer to print postscript content. This should be a fairly robust and easily managed environment. If you're using Citrix on the terminal server, support is also enhanced by the ability to shadow a user's session and see and manipulate their desktop. -John -- John Hester System & Network Administrator Momentum Group Inc. (949) 833-8886 x623 http://memosamples.com --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Universe/wIntegrate/Thin Client
Please consider re-writing this blurb using indentation and paragraphs. --Bill Message-ID: <[EMAIL PROTECTED]> From: Anthony Dzikiewicz <[EMAIL PROTECTED]> Sender: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: [U2] Universe/wIntegrate/Thin Client Date: Wed, 24 Nov 2004 13:49:12 -0500 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2657.72) X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) Content-Type: text/plain Hello Everyone, I am in the midst of thinking up a solution for upgrading dumb terminal/dot matrix printers at point of sale retail. We would like to get some new functionality at these cashiers stations including, printing invoice receipts on a laser printer, possibly doing credit card auth via web, and capturing signatures. Primarily doing the laser printing and then everything else to follow. A while back I was trying to see if I could take the invoice, which is created as a pdf file, transform it to postscript and echo it thru the parallel 'aux' port on the dumb terminal. Well this is just not feasible. It takes minutes to get that puppy thru to the printer (the ps file ends up being very large) and you end up needing a special postscript type printer. One other thing I did not want to do is to create a bunch of spooled printers and have the application spool the invoice. We are running Linux AS 3. The spooler sometimes gets sluggish. Ive had experience where one printer getting 'hung' can hang the whole spooler (not just in Linux, but on our old DG and on the older Prime). So I want the printing operation to continue to be independent and not interfere with anything else. I started looking into wIntegrate and Windows thin clients as a possible solution. I figured that the host application could probably tell wIntegrate to print the document on the local thin client to solve that problem (invoice being a pdf in a type1 samba share). I am thinking that we can link things like credit card auth and signature capture with wIntegrate as well. I am looking for anyone who is doing something similar to let me know if I am on the right track. I have absolutely no experience with wIntegrate (I have downloaded the trail version) or windows thin clients. Does this sound like a messy set up ? Would this be robust enough to place at point of sale where the users are basically kids and are by no means technical ? Any comments or insight be anyone who has been down this road would be appreciated ? Thanks Anthony Dzikiewicz Alperts Furniture --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ [demime 1.01d removed an attachment of type application/octet-stream which had a name of Brutzman, Bill.vcf] --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] CALLC - unidata
Ken, You helped me with the original 'c' wrapper and were correct with this one. The supplier did indeed use the 'extern declarator' to work around internal routine name mangling. All I really had to do was add any new libraries and perform a new make/build. Thanks again. Vance Alspach J & L Industrial Supply "[EMAIL PROTECTED] n.net" Unidata 6.0 > HP/UX 11.11 > > This list was instrumental in assisting me with my original > implementation of a third-party address correction > application/program using an external 'C' program interface. The > original code was written in 'C' but the vendor has upgraded to C++ > and only support that version of their application. Since Unidata > does not have a C++ build, how do I integrate the C++ routine with my > makeudt? Carefully Vance ;^) There should be nothing fundamental which prevents 'C' code from calling 'C++' routines, but the argument handling and internal routine name mangling/decoration are completely different. makeudt only knows how to generate code to call standard 'C' routines, so what you have to do is create standard 'C' routines which call your supplier's C++ library functions. You may need to build your routines into a library of their own so that you can solve the linking issues between your 'C' and the supplier's 'C++' in isolation without the makeudt complication. You would then just have to set up your cfuncdef_user so that makeudt knew how to find your routines in your library, and didn't need to know anything about the supplier's libraries. This of course, implies that your supplier's library is a shared object library, and that the library you build of your own routines may also need to be a shared library so that you can pre-link it and set up all the dependencies inside it, rather than trying to get makeudt to build the whole thing statically. HTH, Ken --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ [demime 1.01d removed an attachment of type image/gif which had a name of graycol.gif] [demime 1.01d removed an attachment of type image/gif which had a name of ecblank.gif] [demime 1.01d removed an attachment of type image/gif which had a name of pic08456.gif] --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] Universe/wIntegrate/Thin Client
Hello Everyone, I am in the midst of thinking up a solution for upgrading dumb terminal/dot matrix printers at point of sale retail. We would like to get some new functionality at these cashiers stations including, printing invoice receipts on a laser printer, possibly doing credit card auth via web, and capturing signatures. Primarily doing the laser printing and then everything else to follow. A while back I was trying to see if I could take the invoice, which is created as a pdf file, transform it to postscript and echo it thru the parallel 'aux' port on the dumb terminal. Well this is just not feasible. It takes minutes to get that puppy thru to the printer (the ps file ends up being very large) and you end up needing a special postscript type printer. One other thing I did not want to do is to create a bunch of spooled printers and have the application spool the invoice. We are running Linux AS 3. The spooler sometimes gets sluggish. Ive had experience where one printer getting 'hung' can hang the whole spooler (not just in Linux, but on our old DG and on the older Prime). So I want the printing operation to continue to be independent and not interfere with anything else. I started looking into wIntegrate and Windows thin clients as a possible solution. I figured that the host application could probably tell wIntegrate to print the document on the local thin client to solve that problem (invoice being a pdf in a type1 samba share). I am thinking that we can link things like credit card auth and signature capture with wIntegrate as well. I am looking for anyone who is doing something similar to let me know if I am on the right track. I have absolutely no experience with wIntegrate (I have downloaded the trail version) or windows thin clients. Does this sound like a messy set up ? Would this be robust enough to place at point of sale where the users are basically kids and are by no means technical ? Any comments or insight be anyone who has been down this road would be appreciated ? Thanks Anthony Dzikiewicz Alperts Furniture --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Resizing All Files in a System
If you choose to automate the resize, you better be sure to lock users out, including any off-hours unattended batch processing. I was part of an environment where an evening batch process ran simultaneous with the resize and unfortunately the DBA failed to check the file system the next day. 5 working went by before the users reported strange problems with their application - investigation revealed 3 corrupt files. Because of the integrated nature of the application, they has to restore from backup back to the day before the disaster occurred and the 5 days work had to be recreated! A Disaster to Remeber! At 09:17 AM 11/24/2004 -0500, [EMAIL PROTECTED] wrote: Is there a way to semi-automagically resize all the files in a UniData account/system?e When we used Pick D3, we could run a process which would store the mod to use on restore in the file definition item. If we did a full system file save and restore, the files would be recreated with the "new and improved" mod. We use to do this on a fairly regular basis, but since changing to UniData, we haven't really addressed this. I know I can use guide to get suggested resizing, and that I can use memresize to actually resize an individual file, but is there a way to do this system wide? We are considering migrating to a newer machine, and since we would have a system with no users on it for a while, it seems to be the best time to implement a massive update. Pointers to the correct manual would be appreciated, or a brief summary. I'm certain that this has been discussed before, but I couldn't find it in the archives. --Tom Pellitieri Century Equipment Toledo, Ohio --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Resizing All Files in a System
Hi Tom, We use a product from http://www.fitzlong.com/ called fastcs. This product is well worth the money!!! Check it out - you won't be sorry. -- Original message -- > Is there a way to semi-automagically resize all the files in a UniData > account/system? > > When we used Pick D3, we could run a process which would store the mod to > use on restore in the file definition item. If we did a full system file > save and restore, the files would be recreated with the "new and improved" > mod. We use to do this on a fairly regular basis, but since changing to > UniData, we haven't really addressed this. > > I know I can use guide to get suggested resizing, and that I can use > memresize to actually resize an individual file, but is there a way to do > this system wide? We are considering migrating to a newer machine, and > since we would have a system with no users on it for a while, it seems to > be the best time to implement a massive update. > > Pointers to the correct manual would be appreciated, or a brief summary. > I'm certain that this has been discussed before, but I couldn't find it in > the archives. > > --Tom Pellitieri > Century Equipment > Toledo, Ohio > --- > u2-users mailing list > [EMAIL PROTECTED] > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Re: [UD] problem with hex conversions
Bill, You're forgiven - but just cuz it's Thanksgiving tomorrow. Chuck Stevenson, old primate -Original Message- From: Bill H. Goes to show ya...coming from a Pick background I see nothing wrong with the results. :-) --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Resizing All Files in a System
Thanks to Tom, Steve, Kevin for the kind words about FAST. FAST isn't a "magic" solution, but it can certainly take a lot of the pain out of resizing. I'll be happy to field questions about FAST either here or privately. FAST is now actively used by over 2,000 shops worldwide on NT, UNIX and Linux for both UniVerse and UniData. Obviously, we are pretty proud of our product! More info can be had at www.fitzlong.com or email me at [EMAIL PROTECTED] Our website contains a number of technical papers about files and resizing that may be helpful. Peggy and I have also authored a series (6 so far) of articles in Spectrum magazine about files. I think you can download these as .pdf files at http://www.intl-spectrum.com/SPECTRUMMAG.HTML. Jeff Fitzgerald Fitzgerald & Long, Inc. (303) 755-1102 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom Dodds Sent: Wednesday, November 24, 2004 9:22 AM To: [EMAIL PROTECTED] Subject: RE: [U2] Resizing All Files in a System I would recommend FAST from Fitzgerald & Long. I have used it and it does a great job, it has all of the manual ness and automation needed to control your environment. Jeff Fitzgerald [EMAIL PROTECTED] Tom Dodds [EMAIL PROTECTED] 630-235-2975 Cell 708-482-4510 Office -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, November 24, 2004 8:17 AM To: [EMAIL PROTECTED] Subject: [U2] Resizing All Files in a System Is there a way to semi-automagically resize all the files in a UniData account/system? When we used Pick D3, we could run a process which would store the mod to use on restore in the file definition item. If we did a full system file save and restore, the files would be recreated with the "new and improved" mod. We use to do this on a fairly regular basis, but since changing to UniData, we haven't really addressed this. I know I can use guide to get suggested resizing, and that I can use memresize to actually resize an individual file, but is there a way to do this system wide? We are considering migrating to a newer machine, and since we would have a system with no users on it for a while, it seems to be the best time to implement a massive update. Pointers to the correct manual would be appreciated, or a brief summary. I'm certain that this has been discussed before, but I couldn't find it in the archives. --Tom Pellitieri Century Equipment Toledo, Ohio --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Re: [UD] problem with hex conversions
Goes to show ya...coming from a Pick background I see nothing wrong with the
results. :-)
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of Simon Lewington
> Sent: Wednesday, November 24, 2004 3:35 AM
> To: [EMAIL PROTECTED]
> Subject: [U2] Re: [UD] problem with hex conversions
>
>
> Switch to $BASICTYPE 'U' to stop this supposed Pick-Style behaviour.
>
> Simon
>
> "Ben Gladman" <[EMAIL PROTECTED]> wrote in message
> news:[EMAIL PROTECTED]
> >
> > I'm getting unexpected results from the hex conversions in
> Unidata 6.0.12
> on
> > NT:
> >
> > PROGRAM BJGTEST
> > *
> > CRT "OCONV('1','MO')=" : OCONV('1','MO')
> > CRT "OCONV('1','MO0C')=" : OCONV('1','MO0C')
> > CRT "OCONV('1','MX0C')=" : OCONV('1','MX0C')
> > CRT "OCONV('1','MX')=" : OCONV('1','MX')
> > CRT "ICONV('F','MX')=" : ICONV('F','MX')
> > *
> > STOP
> >
> >
> > the results I get are:
> >
> > OCONV('1','MO')=001
> > OCONV('1','MO0C')=061
> > OCONV('1','MX0C')=31
> > OCONV('1','MX')=31
> > ICONV('F','MX')=
> >
> > The octal conversions and the hex-ascii conversion seem okay.
> But I would
> > expect the fourth line to read '1' or '01', and the fifth line to read
> '15'?
> > Is this a problem anyone else gets?
> >
> > Cheers,
> > -Ben
> ---
> u2-users mailing list
> [EMAIL PROTECTED]
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Resizing All Files in a System
Kevin, Keep in mind, you still need a "quiet" database or you'll have numerous file access or corruption issues if processes try to access the file(s) while you reseize. Also, you need to be sure to monitor temp space or multiple resizes can fill it up and fail. Dynamics use the local space, so you need to treat those differently. I looked at FAST, but due to several limitations, it was not going to work in our environment. I created my own program, using guide -r for recommendations, that only resizes static files 200meg and under, checks temp space before and after(using the new sizing numbers), redirects the resizes to an area with enough free space. Dynamics and large files are done manually. I also stop and start Unidata, locking out all access to the accounts, rerun guide when I am done to check for corruption, and only resize files in overflow, never downsizing a file automatically. There is alot to think about and I'd look long and hard at tools like FAST before using them as a cure all, may be a good tool, but I'd be prepared for alot of monitoring and manual intervention. Good luck! "Kevin King" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 11/24/2004 10:01 AM Please respond to u2-users To: <[EMAIL PROTECTED]> cc: Subject:RE: [U2] Resizing All Files in a System Can we then assume that you're not interested in a packaged solution like FAST? -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, November 24, 2004 7:17 AM To: [EMAIL PROTECTED] Subject: [U2] Resizing All Files in a System Is there a way to semi-automagically resize all the files in a UniData account/system? When we used Pick D3, we could run a process which would store the mod to use on restore in the file definition item. If we did a full system file save and restore, the files would be recreated with the "new and improved" mod. We use to do this on a fairly regular basis, but since changing to UniData, we haven't really addressed this. I know I can use guide to get suggested resizing, and that I can use memresize to actually resize an individual file, but is there a way to do this system wide? We are considering migrating to a newer machine, and since we would have a system with no users on it for a while, it seems to be the best time to implement a massive update. Pointers to the correct manual would be appreciated, or a brief summary. I'm certain that this has been discussed before, but I couldn't find it in the archives. --Tom Pellitieri Century Equipment Toledo, Ohio --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2][UD] - Transaction Processing
Sure, that'll be great. U can email me directly. thanks Savita Chauhan, Programmer/Analyst x:1754 Central Texas College. --- Change is the only Constant. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Witney Sent: Wednesday, November 24, 2004 9:10 AM To: [EMAIL PROTECTED] Subject: RE: [U2][UD] - Transaction Processing i've got a basic prog that does it if you would like it bob -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Charlie Rubeor Sent: 24 November 2004 14:59 To: [EMAIL PROTECTED] Subject: RE: [U2][UD] - Transaction Processing >-Original Message- >From: Chauhan, Savita [mailto:[EMAIL PROTECTED] >Sent: Wednesday, November 24, 2004 8:50 AM >To: Charlie Rubeor >Subject: RE: [U2][UD] - Transaction Processing > >Hi Charlie, >Does UNIX keep a user's login history somewhere, i.e. > his/her login/logout times (not just the last one, but > for some amount of period in past)? If it does, where > does it keep it and how can I see it? > >Thank you, > >Savita Chauhan, >Programmer/Analyst >x:1754 Central Texas College. >--- >Change is the only Constant. That is what user accounting does. IBM has a whole book on how to manage this. I don't have access to an aix server right now, so I can't give you detailed instructions on how to set it up. A quick overview: /var/adm/utmp - keeps a list of current users /var/adm/wtmp - keeps a list of past login/logout activity /var/adm/btmp - keeps a list of bad login attempts. (This is a great place to look for the root password, btw.) To activate the process, (acctcon?) I believe that you can use smit. There are also a couple of crontab entries that monitor the free space in /var/adm. Once activated, the last and lastb commands will display information from the files listed above. We are kinda off-topic for a U2 list here. Unless someone else finds this interesting, email me directly. Or maybe the U2 community list? Hth. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Verify Universe - was [U2] UniObjects and Triggers
OK I'll bite ( again ) yes the uvhome/bin/csum script does check the checksums saved from the installation 'tape' . Usage: cd to uvhome (bin/)csumlistOfGroups where the list is one or more of DOCIC OBJSTARTUPUVODBC FILESIZE JDBC PORTINGUCI DEVELOPGCIMAIN QA UOJ HTH -- mats Tom Dodds wrote: >In following Mats lead and poking around in /.../uv/bin there is a script >called csum that seems to do what you want to do, we all want to do. Not >being a script writer myself we will need a script reader to look at this >and verify that it really does what I think it does. > >Script reader anyone?? >/.../uv/bin/csum > >Tom Dodds >[EMAIL PROTECTED] >630-235-2975 Cell >708-482-4510 Office > > > >-Original Message- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] On Behalf Of Mats Carlid >Sent: Wednesday, November 24, 2004 2:40 AM >To: [EMAIL PROTECTED] >Subject: Re: [U2] Verify Universe - was [U2] UniObjects and Triggers > > >Sara Burns wrote: > > > >>We have solved our problem with the UniObjects by re-installing >>UniVerse after we found the checksum for uvapi_slave was different on >>our two machines. >> >>Is there any way to verify that the UniVerse binaries are correct? >> >>This would have saved us many hours of testing, red herrings and >>general desperation. There was nothing visible at the file level which >>indicated the file had been updated, only the checksum. We have been >>having disk errors on the machine and have now found that these >>binaries are on a mirrored set showing errors. That was a surprise as >>we thought they were on a different disk array. >> >>AIX 5.2 ML_01, UniVerse 10.0.11 >> >>Sara Burns >> >> >> >> >> >Yes, > >when you install uv a checksum check is performed and the checksums > are kept in .../uv/checksums > You'll find the code to rerun the check in one of the installation >scripts (uv.install?). > >If they could be corrput reload them from the installation medium. > >HTH >-- mats >--- >u2-users mailing list >[EMAIL PROTECTED] >To unsubscribe please visit http://listserver.u2ug.org/ >--- >u2-users mailing list >[EMAIL PROTECTED] >To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Resizing All Files in a System
I would recommend FAST from Fitzgerald & Long. I have used it and it does a great job, it has all of the manual ness and automation needed to control your environment. Jeff Fitzgerald [EMAIL PROTECTED] Tom Dodds [EMAIL PROTECTED] 630-235-2975 Cell 708-482-4510 Office -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, November 24, 2004 8:17 AM To: [EMAIL PROTECTED] Subject: [U2] Resizing All Files in a System Is there a way to semi-automagically resize all the files in a UniData account/system? When we used Pick D3, we could run a process which would store the mod to use on restore in the file definition item. If we did a full system file save and restore, the files would be recreated with the "new and improved" mod. We use to do this on a fairly regular basis, but since changing to UniData, we haven't really addressed this. I know I can use guide to get suggested resizing, and that I can use memresize to actually resize an individual file, but is there a way to do this system wide? We are considering migrating to a newer machine, and since we would have a system with no users on it for a while, it seems to be the best time to implement a massive update. Pointers to the correct manual would be appreciated, or a brief summary. I'm certain that this has been discussed before, but I couldn't find it in the archives. --Tom Pellitieri Century Equipment Toledo, Ohio --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Unidata Odbc
Yeah...the frustrating part (for me anyways) is managing the privileges. Try on the views, hopefully that will doit. Or...what we've ended up doingis generating the schema as a generic user (we created a unix account called sqlmgr) then when we deliver an access database, the password is saved. Anyone creating queries will login via odbc as sqlmgr. Just so you know, if you wish to do that now, I believe you'll need to cleanup the schema then regenerate as the generic user (so everything's owned by the same person). I'm not sure how you do that in vsg...i don't have it loaded right now. But...there's probably an option to do so? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steven Frost Sent: Tuesday, November 23, 2004 7:01 PM To: [EMAIL PROTECTED] Subject: RE: [U2] Unidata Odbc Thanks Amy. I was granting Select to Public on the SQL tables , but not on the views maybe that could help. The consultant is pointing his ERWIN tool at MS access ,to show the columns. -Original Message- # This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal # CAUTION: This email and any attachments may contain information that is confidential. If you are not the intended recipient, you must not read, copy, distribute, disclose or use this email or any attachments. If you have received this email in error, please notify us and erase this email and any attachments. You must scan this email and any attachments for viruses. DISCLAIMER: Powerco Limited accepts no liability for any loss, damage or other consequences, whether caused by its negligence or not, resulting directly or indirectly from the use of this email or attachments or for any changes made to this email and any attachments after sending by Powerco Limited. The opinions expressed in this email and any attachments are not necessarily those of Powerco Limited. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2][UD] - Transaction Processing
i've got a basic prog that does it if you would like it bob -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Charlie Rubeor Sent: 24 November 2004 14:59 To: [EMAIL PROTECTED] Subject: RE: [U2][UD] - Transaction Processing >-Original Message- >From: Chauhan, Savita [mailto:[EMAIL PROTECTED] >Sent: Wednesday, November 24, 2004 8:50 AM >To: Charlie Rubeor >Subject: RE: [U2][UD] - Transaction Processing > >Hi Charlie, >Does UNIX keep a user's login history somewhere, i.e. > his/her login/logout times (not just the last one, but > for some amount of period in past)? If it does, where > does it keep it and how can I see it? > >Thank you, > >Savita Chauhan, >Programmer/Analyst >x:1754 Central Texas College. >--- >Change is the only Constant. That is what user accounting does. IBM has a whole book on how to manage this. I don't have access to an aix server right now, so I can't give you detailed instructions on how to set it up. A quick overview: /var/adm/utmp - keeps a list of current users /var/adm/wtmp - keeps a list of past login/logout activity /var/adm/btmp - keeps a list of bad login attempts. (This is a great place to look for the root password, btw.) To activate the process, (acctcon?) I believe that you can use smit. There are also a couple of crontab entries that monitor the free space in /var/adm. Once activated, the last and lastb commands will display information from the files listed above. We are kinda off-topic for a U2 list here. Unless someone else finds this interesting, email me directly. Or maybe the U2 community list? Hth. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Resizing All Files in a System
Check out FAST from www.fitzlong.com We use it regularly on a Universe/NT system and it works great. I think they have a version for Unidata. Steve Moore Amerex Corporation [EMAIL PROTECTED] This message has been scanned for viruses by Webshield E500, Groupshield for Exchange, and McAfee Virus Enterprise --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Resizing All Files in a System
I wrote a routine that would run guide with the -R option to create a report file. It then parsed the file and did a memresize on the files that required resizing. I had some logic so that "work" files that were empty weren't resized smaller. It wasn't that hard. I know that when you do an ACCT_RESTORE from a Pick system it resizes the files. I'm not sure if any of those routines are available anywhere (I never bothered to look as they don't work quite right on an NT system). hth Colin Alfke >-Original Message- >From: [EMAIL PROTECTED] > > >Is there a way to semi-automagically resize all the files in a UniData >account/system? --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Resizing All Files in a System
Can we then assume that you're not interested in a packaged solution like FAST? -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, November 24, 2004 7:17 AM To: [EMAIL PROTECTED] Subject: [U2] Resizing All Files in a System Is there a way to semi-automagically resize all the files in a UniData account/system? When we used Pick D3, we could run a process which would store the mod to use on restore in the file definition item. If we did a full system file save and restore, the files would be recreated with the "new and improved" mod. We use to do this on a fairly regular basis, but since changing to UniData, we haven't really addressed this. I know I can use guide to get suggested resizing, and that I can use memresize to actually resize an individual file, but is there a way to do this system wide? We are considering migrating to a newer machine, and since we would have a system with no users on it for a while, it seems to be the best time to implement a massive update. Pointers to the correct manual would be appreciated, or a brief summary. I'm certain that this has been discussed before, but I couldn't find it in the archives. --Tom Pellitieri Century Equipment Toledo, Ohio --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2][UD] - Transaction Processing
>-Original Message- >From: Chauhan, Savita [mailto:[EMAIL PROTECTED] >Sent: Wednesday, November 24, 2004 8:50 AM >To: Charlie Rubeor >Subject: RE: [U2][UD] - Transaction Processing > >Hi Charlie, >Does UNIX keep a user's login history somewhere, i.e. > his/her login/logout times (not just the last one, but > for some amount of period in past)? If it does, where > does it keep it and how can I see it? > >Thank you, > >Savita Chauhan, >Programmer/Analyst >x:1754 Central Texas College. >--- >Change is the only Constant. That is what user accounting does. IBM has a whole book on how to manage this. I don't have access to an aix server right now, so I can't give you detailed instructions on how to set it up. A quick overview: /var/adm/utmp - keeps a list of current users /var/adm/wtmp - keeps a list of past login/logout activity /var/adm/btmp - keeps a list of bad login attempts. (This is a great place to look for the root password, btw.) To activate the process, (acctcon?) I believe that you can use smit. There are also a couple of crontab entries that monitor the free space in /var/adm. Once activated, the last and lastb commands will display information from the files listed above. We are kinda off-topic for a U2 list here. Unless someone else finds this interesting, email me directly. Or maybe the U2 community list? Hth. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] Resizing All Files in a System
Is there a way to semi-automagically resize all the files in a UniData account/system? When we used Pick D3, we could run a process which would store the mod to use on restore in the file definition item. If we did a full system file save and restore, the files would be recreated with the "new and improved" mod. We use to do this on a fairly regular basis, but since changing to UniData, we haven't really addressed this. I know I can use guide to get suggested resizing, and that I can use memresize to actually resize an individual file, but is there a way to do this system wide? We are considering migrating to a newer machine, and since we would have a system with no users on it for a while, it seems to be the best time to implement a massive update. Pointers to the correct manual would be appreciated, or a brief summary. I'm certain that this has been discussed before, but I couldn't find it in the archives. --Tom Pellitieri Century Equipment Toledo, Ohio --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Verify Universe - was [U2] UniObjects and Triggers
In following Mats lead and poking around in /.../uv/bin there is a script called csum that seems to do what you want to do, we all want to do. Not being a script writer myself we will need a script reader to look at this and verify that it really does what I think it does. Script reader anyone?? /.../uv/bin/csum Tom Dodds [EMAIL PROTECTED] 630-235-2975 Cell 708-482-4510 Office -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mats Carlid Sent: Wednesday, November 24, 2004 2:40 AM To: [EMAIL PROTECTED] Subject: Re: [U2] Verify Universe - was [U2] UniObjects and Triggers Sara Burns wrote: >We have solved our problem with the UniObjects by re-installing >UniVerse after we found the checksum for uvapi_slave was different on >our two machines. > >Is there any way to verify that the UniVerse binaries are correct? > >This would have saved us many hours of testing, red herrings and >general desperation. There was nothing visible at the file level which >indicated the file had been updated, only the checksum. We have been >having disk errors on the machine and have now found that these >binaries are on a mirrored set showing errors. That was a surprise as >we thought they were on a different disk array. > >AIX 5.2 ML_01, UniVerse 10.0.11 > >Sara Burns > > > Yes, when you install uv a checksum check is performed and the checksums are kept in .../uv/checksums You'll find the code to rerun the check in one of the installation scripts (uv.install?). If they could be corrput reload them from the installation medium. HTH -- mats --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] Re: [UD] problem with hex conversions
Also just found out [[thanks Adam]] that if you put any other character at
the end of the conversion code, it works ok:
PROGRAM BJGTEST
*
CRT "OCONV('1','MX*')=" : OCONV('1','MX*')
CRT "ICONV('F','MX*')=" : ICONV('F','MX*')
*
STOP
produces:
OCONV('1','MX*')=01
ICONV('F','MX*')=15
"Simon Lewington" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
Switch to $BASICTYPE 'U' to stop this supposed Pick-Style behaviour.
Simon
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
[U2] Re: [UD] problem with hex conversions
Switch to $BASICTYPE 'U' to stop this supposed Pick-Style behaviour.
Simon
"Ben Gladman" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
>
> I'm getting unexpected results from the hex conversions in Unidata 6.0.12
on
> NT:
>
> PROGRAM BJGTEST
> *
> CRT "OCONV('1','MO')=" : OCONV('1','MO')
> CRT "OCONV('1','MO0C')=" : OCONV('1','MO0C')
> CRT "OCONV('1','MX0C')=" : OCONV('1','MX0C')
> CRT "OCONV('1','MX')=" : OCONV('1','MX')
> CRT "ICONV('F','MX')=" : ICONV('F','MX')
> *
> STOP
>
>
> the results I get are:
>
> OCONV('1','MO')=001
> OCONV('1','MO0C')=061
> OCONV('1','MX0C')=31
> OCONV('1','MX')=31
> ICONV('F','MX')=
>
> The octal conversions and the hex-ascii conversion seem okay. But I would
> expect the fourth line to read '1' or '01', and the fifth line to read
'15'?
> Is this a problem anyone else gets?
>
> Cheers,
> -Ben
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
[U2] [UD] problem with hex conversions
I'm getting unexpected results from the hex conversions in Unidata 6.0.12 on
NT:
PROGRAM BJGTEST
*
CRT "OCONV('1','MO')=" : OCONV('1','MO')
CRT "OCONV('1','MO0C')=" : OCONV('1','MO0C')
CRT "OCONV('1','MX0C')=" : OCONV('1','MX0C')
CRT "OCONV('1','MX')=" : OCONV('1','MX')
CRT "ICONV('F','MX')=" : ICONV('F','MX')
*
STOP
the results I get are:
OCONV('1','MO')=001
OCONV('1','MO0C')=061
OCONV('1','MX0C')=31
OCONV('1','MX')=31
ICONV('F','MX')=
The octal conversions and the hex-ascii conversion seem okay. But I would
expect the fourth line to read '1' or '01', and the fifth line to read '15'?
Is this a problem anyone else gets?
Cheers,
-Ben
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Verify Universe - was [U2] UniObjects and Triggers
Sara Burns wrote: We have solved our problem with the UniObjects by re-installing UniVerse after we found the checksum for uvapi_slave was different on our two machines. Is there any way to verify that the UniVerse binaries are correct? This would have saved us many hours of testing, red herrings and general desperation. There was nothing visible at the file level which indicated the file had been updated, only the checksum. We have been having disk errors on the machine and have now found that these binaries are on a mirrored set showing errors. That was a surprise as we thought they were on a different disk array. AIX 5.2 ML_01, UniVerse 10.0.11 Sara Burns Yes, when you install uv a checksum check is performed and the checksums are kept in .../uv/checksums You'll find the code to rerun the check in one of the installation scripts (uv.install?). If they could be corrput reload them from the installation medium. HTH -- mats --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
