Re: [U2] Array Types
I understand the performance trade off between dynamic and dimensioned arrays but I'm curious about quantifying. I know the answer will depend on hardware and load, but in general at what point (length) do dimensioned arrays become better performing than dynamic? 1000? 1? 10? Any examples or benchmarks appreciated. Jeff Butera Sent from my iPhone On Jul 27, 2012, at 11:14 AM, David L. Wasylenko d...@pickpro.com wrote: Speed There is a *long* thread here demonstrating the difference between *DAYS* of processing and seconds, using large records for demonstration. ... david ... David L. Wasylenko President, Pick Professionals, Inc w) 314 558 1482 d...@pickpro.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Friday, July 27, 2012 10:16 AM To: U2 Users List Subject: [U2] Array Types I am surprised that anyone uses dimensioned arrays. I use dynamic arrays for everything. If there are any advantages that dimension arrays have over dynamic... please let me know... without getting sentimental. --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse backups to disk
We don't mirror but we use filesystem snapshotting for a clean backup with less than 10 seconds of downtime: Dbpause Sleep few (3-5) seconds File system snapshot (5 seconds or so) Dbresume Backup from snapshot Trash snapshot Only cost in this is enough disk for snapshot. Jeff Butera Sent from my iPhone On Aug 20, 2011, at 1:51 PM, Bill Haskett wphask...@advantos.net wrote: That's what I like... As others have mentioned, you can pause the database. If you've got a mirror then DBPAUSE the database, break the mirror, and DBRESUME. Sounds so simple yet can be so complex and expensive. There are so many ifs with the term break the mirror it's not much of a wonder that most small businesses never go down that path; as much as we'd all like to! :-) Wouldn't it be nice if we had a simple white-paper describing this functionality so the next batch of inexpensive servers we bought we could accomplish this. Presently I have to shut down the database and keep it shutdown for the 30-60 minutes the backup runs. :-(Jeeze, we have simple Windows backup scripts we've shared and would always share; you'd think U2 would have this down pat and distributed onto their site or to the wiki. Oh well, should anyone figure out a simple, effective and inexpensive way to do this sort of thing, please post it. Bill Wols Lists wrote: On 18/08/11 05:07, Chris Lee wrote: Hi All, We're running UniVerse 10.1.17 on AIX 5.3 and the backup feature included within our vendors software is pretty basic and only allows backups of Universe to tape. [snipped] [snipped] As others have mentioned, you can pause the database. If you've got a mirror then DBPAUSE the database, break the mirror, and DBRESUME. [snipped] Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse backups to disk
Yes this is on Linux (we don't touch windows here). Same approach works on solaris and other *nix but I'm betting someone who knows windows better than I could also make it work. Jeff Butera Sent from my iPhone On Aug 20, 2011, at 6:56 PM, Bill Haskett wphask...@advantos.net wrote: Jeff: Am I mistaken to assume this is for Linux (or other variant)? See, things aren't anywhere near as easy as they seem. :-) Bill jbut...@hampshire.edu wrote: We don't mirror but we use filesystem snapshotting for a clean backup with less than 10 seconds of downtime: Dbpause Sleep few (3-5) seconds File system snapshot (5 seconds or so) Dbresume Backup from snapshot Trash snapshot Only cost in this is enough disk for snapshot. Jeff Butera Sent from my iPhone On Aug 20, 2011, at 1:51 PM, Bill Haskettwphask...@advantos.net wrote: That's what I like... As others have mentioned, you can pause the database. If you've got a mirror then DBPAUSE the database, break the mirror, and DBRESUME. Sounds so simple yet can be so complex and expensive. There are so many ifs with the term break the mirror it's not much of a wonder that most small businesses never go down that path; as much as we'd all like to! :-) Wouldn't it be nice if we had a simple white-paper describing this functionality so the next batch of inexpensive servers we bought we could accomplish this. Presently I have to shut down the database and keep it shutdown for the 30-60 minutes the backup runs. :-(Jeeze, we have simple Windows backup scripts we've shared and would always share; you'd think U2 would have this down pat and distributed onto their site or to the wiki. Oh well, should anyone figure out a simple, effective and inexpensive way to do this sort of thing, please post it. Bill Wols Lists wrote: On 18/08/11 05:07, Chris Lee wrote: Hi All, We're running UniVerse 10.1.17 on AIX 5.3 and the backup feature included within our vendors software is pretty basic and only allows backups of Universe to tape. [snipped] [snipped] As others have mentioned, you can pause the database. If you've got a mirror then DBPAUSE the database, break the mirror, and DBRESUME. [snipped] Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] How to Clear Empty VM marks in Field
We've long had a strip nulls subroutine we use to do this sort of thing. You'd have to write a program to select the records, read, strip and write out the data. Jeff Butera Sent from my iPhone On Jan 28, 2011, at 7:29 PM, Garry Smith gar...@charlesmcmurray.com wrote: FXI = 1ýý DCount(FXI,VM) returns 3 Is there function to clear the blank value marks so that FXI = 1 and then DCOUNT would return 1 TIA Garry L. Smith Dir Info Systems Charles McMurray Company V# 559-292-5782 F# 559-346-6169 -Original Message- From: Garry Smith Sent: Friday, January 28, 2011 2:04 PM To: 'U2 Users List' Subject: RE: [U2] What do you do with CallHTTP? I tried to but we are still using AIX 4.3.3 and UV 9.6 Garry L. Smith Dir Info Systems Charles McMurray Company V# 559-292-5782 F# 559-346-6169 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Romanow Sent: Friday, January 28, 2011 1:29 PM To: U2 Users List Subject: Re: [U2] What do you do with CallHTTP? On 1/28/2011 1:50 PM, David Wolverton wrote: What uses have you found for CallHTTP for in your applications? None whatsoever. Are you 'eating' someone else's data with it - like doing lookups against a web service call? Or are you using it to 'serve' data to others? Rocket says you can do this, but I can't see how it would work offhand and would like to know the scenario. How complex have you found it and how stable? Too complex, not sure about stability. I am following someone on c.d.p's lead from 2006 and using curl. I have also used wget in the past for a dictionary items to do a filecheck on web images. You can use wget in --spider mode and it will just give you back an http 200 if the file resolves, but will not actually download it. Thanks for your thoughts! ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Need help with MV assoc/I-desc
Sorry-I'm not familiar with @USER0 Also this is thru a web interface so the user running the code in unidata isn't the same as the person running the web interface. Jeff Butera Sent from my iPhone On Dec 23, 2010, at 11:48 AM, Shawn Hayes go_mnviki...@yahoo.com wrote: I don't know if I completely understand the issue here... I have created dynamic sorts using @USER0 values. By LOCATEing the user in XEM.PERSON, use that position to set the @USER0 value to the correct XEM.VALUE. Then use @USER0 value for the purpose of sorting the file Am I understanding your question? 'We act as though comfort and luxury were the chief requirements of life, when all that we need to make us happy is something to be enthusiastic about.' - Original Message From: Jeffrey Butera jbut...@hampshire.edu To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, December 22, 2010 9:06:54 PM Subject: [U2] Need help with MV assoc/I-desc I need insight from the U2 faithful. This is Unidata 7, if that affects the answer... I have a file which has 2 associated fields, such as: XEM.PERSON = 1737292:@VM:1818182:@VM:9187311 XEM.VALUE = 23:@VM:14:@VM:99 What I'd like is a field which sorts by XEM.VALUE for the associated person querying the records. That is, if person 1737292 is selecting records it would use 23 for purposes of sorting this record. If 1818182 is selecting, it would use 14 for sorting. I've done plenty of i-descriptors both with and without subroutines, but I don't have insight as to any method of allowing the query to know who's running it. I've dreamed about WHEN...ASD but Unidata only allow this in a LIST statement and it doesn't really do what I need, even if it were allowed in a SELECT. I need the data stored as listed above, but I am open to using a database trigger to store this in some alternative form that makes the query easier to deal with - but I can't think of how this might be accomplished. Any insight is appreciated. -- Jeff Butera, Ph.D. Manager of ERP Systems Hampshire College jbut...@hampshire.edu 413-559-5556 Dad, one [dollar bills] are good but tens are way better. Catherine Butera ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Sequential Files Question
Here's a wrapper I've used around seq file opens for years on unidata. F.FILE IS THE RETURNED FILE HANDLE-all others arguments are inputs. You need not force creation (at least not on *nix) http://jeff.hampshire.edu/seq.txt Jeff Butera Sent from my iPhone On Sep 8, 2010, at 6:55 PM, Al DeWitt adew...@stylmark.com wrote: Unidata 7.1.20 I've never dealt with sequential files, but I have a need to output records to a text file. Each record will be a series of fixed-length fields. Each file will need to be created at the time of opening. The destination will be a Windows folder on one of our servers. I will be using OPENSEQ to open the file. However, since each file needs to be created at time of opening what do I use to create the file? My reading of OPENSEQ doesn't indicate that it will create it automatically if it doesn't exist. Thanks. Al DeWitt ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users