RE: [U2] U2 University Last Week In Denver

2007-09-12 Thread Symeon Breen
Ok no problem Thanks -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jackie Burhans Sent: 12 September 2007 01:03 To: u2-users@listserver.u2ug.org Subject: RE: [U2] U2 University Last Week In Denver Symeon, Sorry that would be me. I am on the road righ

RE: [U2] UV basic assignment error ?

2007-09-12 Thread Timothy Snyder
> As far as I can tell, UD doesn't have a BASIC runtime-error log. Oops - haphazard reading on my part. You're correct, of course. I actually get a lot of good information from the UniData logs that do exist, but then those are things that pertain more to what I normally do. And, as you poin

Re: RES: [U2] Universe and triggers

2007-09-12 Thread Brian Leach
Just to clarify 1. You can add triggers to non-sql files so long as they have a header. See the HELP SQL CREATE TRIGGER for the subroutine layout. 2. You can have up to 6 main triggers -before and after each type of event (insert, update, delete). 3. triggers must be globally cataloged since

Re: [U2] Religious Wars

2007-09-12 Thread Mats Carlid
I vote for moderated ( - having been in unmoderated lists.) One or two is of little importance - though I'd prefer one. -- mats --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Religious Wars

2007-09-12 Thread Dave Walker
Put me in the moderated one-list camp. I have rules that shove both u2-users and u2-community into the same inbox anyhow. And while I don't mind the occasional dead parrot reference, when the thread has devolved to the point that it's ALL MP there's very little that can be done to revive it. -- Da

Re: [U2] Universe and triggers

2007-09-12 Thread Mats Carlid
Clifton Oliver skrev: Since 10.0. Yes, it works on all file types except 1 and 19. Being directories, they don't have file headers, thus no place to put the SICA. It would be possible placing the SICA in a separate file .sica or in the .Type1 / .Type19 files wouldn't it? And it would reall

RE: [U2] U2 University Last Week In Denver

2007-09-12 Thread Perry Taylor
How does one go about signing up for the U2 News Flash? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jackie Burhans Sent: Tuesday, September 11, 2007 2:26 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] U2 University Last Week In Denver I though

RE: [U2] Religious Wars

2007-09-12 Thread Gahan, Mick
As a frequent lurker, but rare contributor to this list, I don't think my leaning towards a moderated list should carry a great deal of weight. But I think it's served us well in the past and I would like to see it continue as is. I find the list somewhat mirrors my personal life. Mostly good f

[U2] Unidata 7.1 system requirements

2007-09-12 Thread Michael Martin
We are upgrading to Unidata 7.1, with Window Server 2003 and purchasing a new server. I would be interested in opinions on hardware specifications from the group. Thanks, Michael Martin Innovation Industries Inc. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please vi

RE: [U2] Religious Wars

2007-09-12 Thread Brenda Price
I agree with the following as I do the same thing. I also think the moderators past and present have done an excellent job. I really don't care about the rules for when to put in our not. I do have to say that whether or not the is there, if the post is basically why aren't you using our produ

[U2] User Groups

2007-09-12 Thread Bob Wyatt
Is anyone aware of any active user groups operating within 100 miles of Philadelphia? This narrows it down to the NY/Baltimore corridor? Regards, Bob Wyatt --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

RES: RES: [U2] Universe and triggers

2007-09-12 Thread Marcos Fogaça
Hi Clif, My file is type 18 and it is multi data level. DICT GVMTA030 D_GVMTA030 18 7 DATA GVMTA030,BAIXADOS GVMTA030/BAIXADOS18 3001 DATA GVMTA030,DELETADOS GVMTA030/DELETADOS 18 3001 DATA GVMTA030

[U2] Siging up for U2 News Flash

2007-09-12 Thread Wally Terhune
Per Janet, you need to send an email to [EMAIL PROTECTED] stating that you would like to receive the news flash. Wally Terhune SWG Client Support - Information

RE: [U2] Unidata 7.1 system requirements

2007-09-12 Thread Bob Wyatt
We are upgrading to Unidata 7.1, with Window Server 2003 and purchasing a new server. I would be interested in opinions on hardware specifications from the group. Thanks, Michael Martin Michael, Insufficient data. Number of users? Size of database? Redundancy desired? Ratio of reads to writes

RE: [U2] U2 University Last Week In Denver

2007-09-12 Thread Jackie Burhans
Email [EMAIL PROTECTED] and ask to be added. Jackie Burhans U2 Portfolio Manager IBM Information Management Tel: 303-773-7717 T/L 656-7717 Mobile: 719-238-1553 Email: [EMAIL PROTECTED] http://www.ibm.com/software/data/u2 Register Now!Tune

RE: [U2] U2 University Last Week In Denver

2007-09-12 Thread D
Symeon, [AD] Why wait? Try our FREE GUI editor today at www.u2logic.com [/AD] Regards, Doug -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jackie Burhans Sent: Tuesday, September 11, 2007 6:03 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] U2 Un

RE: [U2] Unidata 7.1 system requirements

2007-09-12 Thread Bill Haskett
Michael: We run a Dell 1435 in development...2GB memory and two 150Gb SATA raid 1 drives. In production we have a Dell 2850 with 4Gb memory and 4 75Gb SCSI RAID 10 drives. So far it's holding up nicely with 50 users and we're moving up from there. You'll need more horsepower for larger, or 24

RE: [U2] U2 University Last Week In Denver

2007-09-12 Thread karlp
I would like to make a general request to anyone interested: Please add http:// before web URLs so the link will become a clickable link for all the email clients (except maybe AOL's client) group members use. Okay, it's for me. I guess I'm getting too lazy to copy and paste... Which is quite a s

[U2] Easysoft ODBC driver - Anyone had any issues with it?

2007-09-12 Thread Brenda Price
We had been trying for about a week to get DataDirect (a trial version) to work with UniVerse. It would work with Linux but not UniVerse. Because of that and its price tag, we looked for another product and found Easy Soft. We had the trial version of it up and working within hours and the price

RE: [U2] Unidata 7.1 system requirements

2007-09-12 Thread Michael Martin
We are upgrading to Unidata 7.1, with Window Server 2003 and purchasing a new server. I would be interested in opinions on hardware specifications from the group. Thanks, Michael Martin ** Michael, Insufficient data. Number of users? Size of database? Redundancy desired? Ratio of read

RE: [U2] U2 University Last Week In Denver

2007-09-12 Thread Symeon Breen
I have - and it is a nice editor - but no better than the wintegrate editor or unidebugger What I am interested in is the full GUI IDE not just the editor. Thanks Symeon. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of D Sent: 12 September 2007 17:11 T

RE: [U2] Easysoft ODBC driver - Anyone had any issues with it?

2007-09-12 Thread Mathew Varghese
Brenda: We use the Easysoft ODBC driver for both UNIDATA (AIX) and UNIVERSE (WINDOW NT). We have no issues with the driver and find the company to be very supportive. Let me know if you have any further questions on this. Thanks, Matt -Original Message- From: [EMAIL PROTECTED] [mailt

[U2] Does anyone know the effect of adding an ndex to a UniVerse file?

2007-09-12 Thread Louie Bergsagel
Does anyone know the effect of adding an index to a UniVerse file? I'd like to add a date index to a type 30 file with 11 million records. ( ANALYZE.FILE Total size . 2,115,325,952 bytes) Would this have any measurable speed slowdown on applications running against the file? Th

Re: [U2] Who has the largest Windows U2 installation?

2007-09-12 Thread George Land
We have a 250 user implementation, been running for three or four years now without any problems. We've got another with 120 users, and several more around the 100 mark. With some decent hardware it's fine. George Land www.u2uk.com On 12/9/07 19:15, "Marc Harbeson" <[EMAIL PROTECTED]> wrote:

[U2] Who has the largest Windows U2 installation?

2007-09-12 Thread Marc Harbeson
I have 45 Enterprise UniData 6.1 Just looking for examples of just how large some of you have scaled on Win before crossing the boundary into Unix, and if you had any issues if you scaled large scale (say larger than 100 user sessions) :-) No virus found in this outgoing message. Checked by AV

RE: [U2] Who has the largest Windows U2 installation?

2007-09-12 Thread Marc Harbeson
Did you have to do anything special to the installation beyond the normal tune up to U2 paramaters? And with 250 users, how much ram is that box running? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Land Sent: Wednesday, September 12, 2007 2:41

RE: [U2] Does anyone know the effect of adding an ndex to a UniVerse file?

2007-09-12 Thread Dan Fitzgerald
I have seen some slight performance degradation above 4 indices. I usually recommend that you have no more than 6, but 5 or even 6 can be ok, in a pinch. So the answer is that you're approaching the point where there will be a measurable negative impact on throughput. The complete answer is test it

RE: [U2] Easysoft ODBC driver - Anyone had any issues with it?

2007-09-12 Thread Brian Leach
Hi Brenda There was a forum post on the U2UG website about this. Forums->Success Stories->ODBC connectivity to and from Oracle It's currently in the recent list on the front page. Brian > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Brenda Pric

RE: [U2] Who has the largest Windows U2 installation?

2007-09-12 Thread Dan Fitzgerald
You do have to do some configuration to address more than 2Gb of RAM (PAE set to on). Windows server 2003 standard in 32-bit can only address 4Gb max. Enterprise versions and 64-bit ones can do more.> Subject: [U2] Who has the largest Windows U2 installation?> Date: Wed, 12 Sep 2007 14:15:44 -0400>

RE: [U2] Easysoft ODBC driver - Anyone had any issues with it?

2007-09-12 Thread Brenda Price
That was how I found out about Easysoft, just looking other opinions. Thanks, Brenda -Original Message- From: Brian Leach [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 12, 2007 2:39 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Easysoft ODBC driver - Anyone had any issues

Re: [U2] Universe and triggers

2007-09-12 Thread Clifton Oliver
There currently isn't a .Type19 file; that's the default in the absence of a .Type1 or .Type30. But they could add one and do what you suggest. I know this has been discussed within IBM for some time. You have a similar issue for the same reason of being able to Transaction Log a type 1 or

Re: [U2] Does anyone know the effect of adding an ndex to a UniVerse file?

2007-09-12 Thread Clifton Oliver
That completely depends on how densely the index is populated. Example by extremes: If you index on a status code that has only two equally possible values, you'd have about 5.5 million records in each index. Updates to that file will grind to a near halt. If the code could have a couple of

Re: RES: [U2] Universe and triggers

2007-09-12 Thread Clifton Oliver
Two more come to mind: If you change and recompile the subroutine, you have to drop and re- create the trigger. Files with triggers cannot be updated via UV/Net. -- Regards, Clif On Sep 12, 2007, at 2:04 AM, Brian Leach wrote: 5. Triggers impose some limitations : they all make sense if

Re: [U2] Does anyone know the effect of adding an ndex to a UniVerse file?

2007-09-12 Thread Louie Bergsagel
I've never heard about MINIMUM.MODULUS, but then again when I did most of my operations & database work late last century, dynamic files did not exist. I've never heard of split operations either. Here are all the ANALYZE.FILE results: >ANALYZE.FILE ABC File name .. ABC ... Fil

RE: [U2] Unidata 7.1 system requirements

2007-09-12 Thread Bob Wyatt
Number of users?40 user Size of database? 21 Gig in Live Realm / 75 gig all Realms / Live Realm gets 99% of activity. Redundancy desired? RAID 5 or HP's RAID 6 Ratio of reads to writes today? 3/2 READ/WRITE Anticipated growth? 30% a yea

[U2] Product Distribution Methods

2007-09-12 Thread Liesse, Dave
I wish I could contribute more, instead of just asking questions when I have problems beyond the documentation, but since I subscribe to the digest each question has usually been answered 16 times before I see it. Anyway, thanks to all of you who have helped with my queries in the past! Now I have

Re: [U2] Does anyone know the effect of adding an ndex to a UniVerse file?

2007-09-12 Thread Louie Bergsagel
The date index would contain internal-format dates, and there would be one for every record, as it is the POST.DATE. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] Universe and triggers

2007-09-12 Thread Clifton Oliver
Oops. Meant to type "not" able to TL a type 1 or 19. -C On Sep 12, 2007, at 1:15 PM, Clifton Oliver wrote: There currently isn't a .Type19 file; that's the default in the absence of a .Type1 or .Type30. But they could add one and do what you suggest. I know this has been discussed within I

Re: [U2] Product Distribution Methods

2007-09-12 Thread Charles Barouch
David, I believe Brian Leach was working on a commercial delivery system. U2UG has a discussion about developing a freeware method and [AD] I, myself have half of one written [AD]. You should talk to Brian about his, as it is most likely the most complete option of the three. - Chuck

Re: [U2] User Groups

2007-09-12 Thread Charles Barouch
Bob, Sounds like time for you to start one. I suspect you could get a good group up for a quarterly meeting structure. - Chuck Bob Wyatt wrote: Is anyone aware of any active user groups operating within 100 miles of Philadelphia? This narrows it down to the NY/Baltimore corridor? ---

RE: [U2] Easysoft ODBC driver - Anyone had any issues with it?

2007-09-12 Thread Shin.Tanaka
We use ES Oracle ODBC driver. We've been using it for almost a year with UniData 6.1 on 64-bit HP-UX 11.11. Before that, we were using Data Direct sequelink. I like ES because * Cheaper than SequeLink * Easy to install. * and ES Support is very responsible. ES knows about U2. You can even fin

Re: [U2] Product Distribution Methods

2007-09-12 Thread Craig Bennett
Hi Dave, Our system is far too complex to describe here in a single email, but I'd like to discuss the topic in general with anyone who needs to distribute their server-based code to clients, whether external or internal. I'm willing to provide specifics; I just don't want to bore everyone else

RE: [U2] Product Distribution Methods

2007-09-12 Thread Hona, David S
Brian Leach and U2Logic both have client/server-style U2 installers/packaging toolsets. I haven't tried either yet. But both look interesting and have slightly different approaches. See their respective websites for more info. http://www.brianleach.co.uk http://www.u2logic.com Regards, David

RE: [U2] Easysoft ODBC driver [ad/solution/sigh]

2007-09-12 Thread Tony G
Brenda Price wrote: > We will only be using to from UniVerse to access a MicroSoft SQL for > our credit card numbers this is due to PCI compliance and we wanted 1 > database for all of our different systems. From the UniVerse side of > things, we will have to access the SQL with a batch process 2

And the Winner is: [U2] [UV] checking files for corruption - Humor Here - plus Do this Every Month

2007-09-12 Thread Stephen O'Neal
Scott Thompson asked ..."> What is the best way to verify the integrity of a file while users are accessing (if possible at all)?" Please note that Scott only asked for a single file... Runner Up: Karl P was extremely close with "LIST FNAME LASTATTRIBUTE". If he would have added DET.SUP, he w

Re: RES: [U2] Universe and triggers

2007-09-12 Thread Clifton Oliver
Oooo! Now there's a neat trick (excuse me, "technique"). I'd never thought of it. Have you ever used Mark Baldridge's Profiler ("Travels With Mark," on the IBM Developer Works site) to quantify what I assume is a rather trivial amount of overhead in the double call? If not, I'll take a go

Re: [U2] User Groups

2007-09-12 Thread Stephen O'Neal
In the mean time, attend U2 University coming up this fall in Terrytown. I'll be there speaking on HW, O/S & the U2 Data Servers. Worth every penny of the $850 tuition. http://www-306.ibm.com/software/info/u2/university/index.jsp Bob, Sounds like time for you to start one. I suspect you c