Re: Flushing memory
Steven R. Shourds wrote: I am currently evaluating different platforms and have been lurking here for a bit. Very lively and informative! We currently use D3 on Windows. I had to integrate SYNC from Sysinternals to flush memory since Windows (or D3) does not seem do it right. We've had problems in the past where customers could loose hours worth of data if there was a system halt! So, would I have to do the same thing with Unidata or did Unidata do it right and provide for safe delivery of the data to the harddrive and then if so is it configurable? Thanks, Steve I can't speak for Unidata or Windows, but UniVerse on unix handles syncs correctly in the default configuration. This is the default setting from the uvconfig file along with comments: # UVSYNC - This boolean if set will change the # behavior of UniVerse calling the UNIX sync() # call on exit the environment. A non-zero value # will mean UniVerse will do a UNIX sync() if a job # leading UniVerse process exits. This value should # only be modified if you know exactly what you are # doing. Data loss may occur if UNIX sync is not # executed frequently enough. UVSYNC 1 I'm assuming the default for Unidata is the same. -John -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: [UV] Problem reactivating select list
Thanks to everyone for all the suggestions. Turns out the solution was relatively simple. I just needed to use PERFORM ED instead of EXECUTE ED to make ED run in the wrapper program's workspace. This is in PICK flavor. Seems like I once knew the difference between EXECUTE and PERFORM in PICK flavor, but I forgot. Reading through all the posts jogged my memory. To answer some of the questions as to why I chose this particular route: I prefer to never copy and modify the system utilities themselves because I'm then relegated to that version of the tool and miss out on any fixes/enhancements in later UV releases. There's also the possibility that the current version won't work correctly in later releases. I'd rather not have the ongoing maintenance and overhead of adding triggers to every file in the database (and can't in UV 9.6 anyway). Also one of the main benefits of the audit trail is capturing changes to BPs and procs that reside in type 19 files. As to the issue of people finding loopholes in ED to get around the auditing, that's not really a big concern. We have good people here and this is more of a tool to assist them rather than being big brother. If someone has to quickly fix some data on the fly and they fail to document it, now they have automatic documentation to fall back on. Thanks, John -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
[UV] Problem reactivating select list
I wrote a wrapper for the ED command last week to keep an audit trail of any changes made to files outside our applications. I'm just writing a before and after version of an edited record to a temp file and comparing afterwards. All seemed fine until one of my coworkers informed me he could no longer use X to drop back to TCL after editing from a select list. This was due to the fact that I was processing the select list in the wrapper program and just executing ED once for each record. For X to work as it used to, I need to write out all the selected records at the beginning, let ED process the select list, then go back through the list again for comparison. Here's the problem: No matter what I do, I can't get ED to recognize an active select list that is activated within the wrapper program. I use READLIST ITEMS at the beginning to get the list of items to write to the temp file, then SELECTN ITEMS TO 0 prior to executing ED. I also tried writing the list to SAVEDLISTS and executing GET.LIST :TEMP.LIST prior to executing ED, but got the same result. These two test programs illustrate the problem: BP TEST.READLIST 0001: READLIST ITEMS ELSE ITEMS = '' 0002: PRINT 'CONTENTS OF ITEMS=':ITEMS 0003: SELECTN ITEMS TO 0 0004: EXECUTE 'RUN BP TEST.READLIST2' 0005: LOOP 0006: READNEXT ITEM ELSE EXIT 0007: PRINT 'READNEXT ITEM=':ITEM 0008: REPEAT 0009: END BP TEST.READLIST2 0001: READLIST ITEMS ELSE ITEMS = '' 0002: PRINT 'CONTENTS OF ITEMS=':ITEMS 0003: END Output: SELECT BP SAMPLE 10 10 record(s) selected to SELECT list #0. RUN BP TEST.READLIST CONTENTS OF ITEMS=1 2 3 4 5 DD FF MCT1 T2 CONTENTS OF ITEMS= READNEXT ITEM=1 READNEXT ITEM=2 READNEXT ITEM=3 READNEXT ITEM=4 READNEXT ITEM=5 READNEXT ITEM=DD READNEXT ITEM=FF READNEXT ITEM=MC READNEXT ITEM=T1 READNEXT ITEM=T2 Clearly the select list is activated by SELECTN because the subsequent READNEXT works, but the executed program can't see an active select list. Is there any way around this? I'd hate to have to make a modified copy of the UV ED command, but that's the only alternative I see at this point. TIA, John -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: [UV] Problem reactivating select list
[EMAIL PROTECTED] wrote: John what is wrong with this approach loop readnext id else done = true until done do list-1 = id repeat select list to mylist loop readnext id else done = true until done do execute ed :file: :id repeat then before, after, between the two loops you can do whatever you wanted to do Will That's close to what I did originally. The problem is that ED needs to think that it is reading from a select list for the X command to work. If I process the select list outside of ED, ED thinks it is working against a single item and the only way you can exit the middle of a list is with crtlC. -John -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
[OT] ANTIVIRUS - CA - GOOD
John Jenkins wrote: Can we have a straw poll on AV software? Just post a subject of ANTIVIRUS - (name) - (version) *GOOD* or *BAD* as necessary - let's hear it. We're using CA's eTrust AV. It's installed on all WinXX workstations and servers. It's centrally managed, so you set up rule sets once and they get pushed out to all the machines. We have different rule sets for servers, workstations, roaming laptops, etc. You can also do the initial install on a machine remotely. The alert capabilities are very good - I get a text page, an email, and a popup message when a virus hits any machine in the company. As far as conflicts with other software, I've not run into any. We're running it on XP Pro, Windows 2003 server, Windows 2000 server and workstation, and Windows NT 4 server and workstation. -John -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: D3 Automatic Faxing
Karl L Pearson wrote: I don't know if it runs on D3 or not. Ask Esker Software (U.S. 800-556-4874). We use this product over 2 faxes. We routinely send between 150 to 300 faxes a day and over 600 at Month-End. I monitor it with a 'roll-my-own' package I wrote and it seems quite okay so far. There are NT-based (NTFS required) monitoring and admin tools that are supposed to be nice, but since I run Linux as my desktop OS, I haven't bothered using those tools. I don't know if anyone else is using this product or not. We're in the process of implementing Esker's VSI-FAX product. It's running on its own linux box and I'm getting the faxes to it via an NFS share mounted to our UV server. Just a matter of writing a flat file with some tags at the top. You can also email faxes to it. It's very customizable. The Windows client interface is convenient. You can start/stop the server, monitor queues, etc. -John -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: File permissions problem with UniObjects for Java
Wendy Smoak wrote: John Hester wrote: The default umask may be someplace like /etc/profile or /etc/default/login depending on your platform. Permissions on files created by OUJ logins on our system appear to be determined by the .profile of the UOJ login though. Don't know why yours would be different. The UOJ login does not have a home directory or a shell. You can't actually log in with that user id and get to a unix prompt. So no .profile for that user. I still don't get how umask could do this-- it only subtracts from the existing permissions, right? In this case I'm gaining world readable permission. (And I have only a vague grasp of how this all works, anyway.) umask does subtract permissions, but I think a system with no default umask specified would give full permissions for ugo. My /etc/defualt/login umask is set to 022, which is what I get with files created by non-shell processes, like those run by cron, when I don't explicitly set it differently. -John -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: UV Secure ODBC drivers for AIX?
Robert Stearns wrote: Is there a secure ODBC driver for this environment? Has anyone gotten ODBC to work over SSL or as a port tunnel of SSH? In the University environment, with users distributed all across campus, I really don't want unencrypted user names, passwords, and sensitive data on the wire. Good, free packet sniffers are all to easy to come by. I've never tried it, but it should be possible with a Windows SSH client that supports tunneling setup. Here's an example of how to tunnel SMB shares: http://www.csuglab.cornell.edu/Info/ssh-smb.html -John -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: UV on Itanium
Brutzman, Bill wrote: We need to buy a new server. Perhaps we should chill for a few months... I gather that HP-Ux runs on Itanium now. What is IBM's timetable for rolling out Itanium servers with AIX? When is UV targeted to run on Itanium? --Bill I beleive you can run UV on Itanium now if you go the linux route. UV 10.1 has been ported to RedHat EL 3.0 which has been ported to Itanium. -John -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: UV on Itanium
Glenn Herbert wrote: So does this mean it's still a 32-bit app that now runs on RH itanium? Or does this mean its a real 64-bit app At 03:17 PM 03/09/2004, you wrote: I'm sure UV is still a 32-bit app. I doubt there's currently enough interest in a 64-bit version of UV for IBM to invest the money in porting it. Performance of 32-bit apps was notoriously bad on Itanium until Intel and Microsoft released a new 32-bit driver in January. Of course this only helps with 32-bit Windows apps. I would hope they're working on a similar fix for linux. It didn't occur to me before, but I guess you could also run UV 10.1 on Windows Server 2003 on Itanium. Personally I'd wait to see if Intel comes up with a 32-bit Itanium driver enhancement for linux, or consider Opteron or Intel's new 64-bit version of Xeon as has already been suggested. -John -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: UniVerse on NT vs *nix
Sara Burns wrote: The general thinking is that it must be more effective to only have one operating system. Less staff training etc etc etc. As there is so much that is NT based they think that all should be on NT. That includes UniVerse and Oracle. Of course SQLServer doesn't have the choice. The fact that UniVerse and Oracle are supported on NT makes it that much harder to explain that this is not such a good idea. I need facts to back up my feelings. Some years ago I was told by one of the knowledgeable contributors to this list that We would be brave to go the NT route, as we would be the biggest site to do this. I am trying to find out if that has changed with the evolution of new versions of NT - now W2K3. The main argument I would make against such a move is the frequent need to load security patches and the need to reboot every time you do. With worms floating around that infect Windows machines without any user intervention there's no choice but to load critical patches immediately, whether it's convenient or not. We're not that large a shop and I would have a hard time scheduling downtime on a monthly basis. There's almost always some important time-sensitive process running in UV. I would imagine this problem is magnified at a larger company. Our UV unix server has run for periods of close to a year without a reboot. Just my .02 -John -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: [UV] Change prompt?
Barry Brevik wrote: OK, I know about UVPROMPT, but it will only let you specify a single character. I work in numerous accounts, and it would be good if the LOGIN PA could change the prompt to have multiple characters so I can see which account I'm in. Believe me, all it takes is one mistake to leave a lasting impression. Anyone know of a way to use multiple chars for the prompt without writing my own shell? I had the same concern a few years ago. We have a development account which is a verbatim copy of yesterday's production environment so it's pretty easy to forget where you are. I ended up writing a basic program that replaces the UV prompt with the currect directory name. I also added code to duplicate all the command stack functionality (.X, .C, .D) because I use those commands frequently. I'd be happy to share the code. Email me off-list if you're interested. -John -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
[UV] XML conversion in UV 10.1
We're planning a platform migration to UV 10.1 and hope to utilize the built-in XML functionality to exchange data with our trading partners. From what I read on the IBM U2 site it appears that XML can be created from standard UV files in 10.1. Are there also tools that enbable data to go the other direction - from XML to a standard UV file? Sorry if I'm not being specific enough, but I'm a newbie to XML. Also, since UV 10.1 has not been ported to our chosen platform yet, can anyone recommend an XML to CSV parsing tool? I'm looking for something that can be run in batch mode, preferably on a unix server. Thanks, John -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Enabling ODBC for non-SQL file
Anthony Youngman wrote: Did you run HS.UPDATE.FILEINFO? Have you put the correct SQL type definitions in fields 8? Did HS.UPDATE.FILEINFO actually work correctly! THAT'S A BIGGIE! I've shoved a little article on pickwiki you might want to look at - multivaluedatabasesuniverseodbcaccess Cheers, Wol Thanks for pointing me to the pickwiki. That was a lot easier to follow than the UV documentation. I made sure the correct SQL types were in attr. 8 of all the dict items. I had previously cleared the entire dict and put in only the things I needed (I copied the live file to a separate ODBC-only account), so I only have a handful to worry about. I also manually added the file to HS_FILE_ACCESS. I used the verbose version of HS.UPDATE.FILEINFO from the wicki and there were no complaints about this particular file. Still can't get this file to be seen though. HS.SCRUB does give an error message on all the I-type dict items and I'm not sure exactly what it's telling me. I get this message: CUST.CITY was analyzed using VARCHAR(254) for a data type * Invalid conversion code ' '. And here's the I-type: 0001: I 0002: TRANS(CR,@ID[8,8],21,X) 0003: 0004: CITY 0005: 20L 0006: S 0007: 0008: VARCHAR The I-type is referencing a file that's a Q-pointer to a non-SQL file in another account. All the other I-types it complains about point to the same file. The only other potential problem I can think of is since I'm using a stripped down version of the actual dict, there are attributes in the data portion that now have no corresponding dict entry. Could this be a problem? Thanks, John -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
UV 10.1 on RedHat AS 2.1
Anyone running UV on RedHat AS 2.1 and planning to upgrade to UV 10.1? I'm preparing to migrate to RH AS 2.1 and need the MQ functionality built into UV 10.1. IBM has told me that it hasn't been ported yet but I can't get an answer on a timeframe for the port. Just wondering if anyone else has any info on this. TIA, John -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
UV: Enabling ODBC for non-SQL file
I'm trying to enable ODBC access to a standard UV non-SQL file and have found the following in the ODBC manual: To make UniVerse files accessible to ODBC applications, you must run the ODBC file access utility in the account. However, they don't bother to say what this ODBC file access utility is called. I've tried listing the VOC LIKE ...HS... and ...MENU... but can't find anything relevant. Are they referring to HS.UPDATE.FILEINFO? TIA, John -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Enabling ODBC for non-SQL file
Thanks, I went through the options on the HS.ADMIN menu, including HS.SCRUB and the HS_FILE_ACCESS file was created. For some reason it excluded the file I need from HS_FILE_ACCESS though, even though I added an @SELECT dictionary item. If I run CONVERT.SQL against the file (not using my live data file), I can then see it via ODBC in Excel, but the dict items don't work correctly. Is it safe to manually add a record for the non-SQL file to HS_FILE_ACCESS? Thanks, John Jeff Schasny wrote: First create an @SELECT item in the dictionarys of the files you are aiming at. Then logto HS.ADMIN and issue the HS.ADMIN command from TCL. Select Option #3 to activate access to files in an account. Whenever you change an @SELECT Item or want to add access to another file you can run HS.UPDATE.FILEINFO in the account rather than going back to the HS.ADMIN account and running option #4 (Update File Information Cache in an account). -Original Message- From: John Hester [mailto:[EMAIL PROTECTED] Sent: Monday, February 16, 2004 3:34 PM To: U2 Users Discussion List Subject: UV: Enabling ODBC for non-SQL file I'm trying to enable ODBC access to a standard UV non-SQL file and have found the following in the ODBC manual: To make UniVerse files accessible to ODBC applications, you must run the ODBC file access utility in the account. However, they don't bother to say what this ODBC file access utility is called. I've tried listing the VOC LIKE ...HS... and ...MENU... but can't find anything relevant. Are they referring to HS.UPDATE.FILEINFO? TIA, John -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users