Re: [U2] Large DICT affecting I/O

2013-08-07 Thread Brian Leach
Jeff By 'large dictionary' do you mean that the dictionary itself is too large - has lots of synonyms - or that the data it is describing has that number of fields and so has become too large for efficient storage? If the former, I've found people often forget to resize their dictionaries and

Re: [U2] Large DICT affecting I/O

2013-08-07 Thread Jeffrey Butera
Thanks to those who replied. 1) we have tools to easily edit dictionaries of any size (one of the few benefits of Datatel/ Ellucian) 2) we have tools to monitor and resize dictionaries just like any other file ( also a Datatel benefit) It's more of a general question about performance. We

[U2] Type 30 files modified when LISTed? (UV 10.0.2)

2013-08-07 Thread George Gallen
If I LIST a Type 30 file, Then execute a ls -la FILENAME it shows the last time DATA.30 portion was modified was when I did the LIST. Why would a LIST modify the date/time stamp that a file was modified? The OVER.30 wasn't changed at this point. George

Re: [U2] Large DICT affecting I/O

2013-08-07 Thread Rutherford, Marc
Jerry, As previous posts have pointed out a Dictionary is no different than any other file. It need to be properly sized for the data it holds. When properly sized will have maximum performance by definition. No need to 'split' files At TCL: 'file.stat DICT filename'

Re: [U2] Type 30 files modified when LISTed? (UV 10.0.2)

2013-08-07 Thread Aaron Titus
If I remember correctly, Universe always opens files for update, regardless if you actually write to the file or not. This will cause the modified time on the file to be changed. *Aaron Titus* Senior Software Engineer F.W. Davison Company, Inc. 508-747-7261 x245 ati...@fwdco.com On Wed, Aug

Re: [U2] Type 30 files modified when LISTed? (UV 10.0.2)

2013-08-07 Thread George Gallen
What is odd, is that If I LIST a Type 19/1 file, the time stamp doesn't get changed. George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Aaron Titus Sent: Wednesday, August 07, 2013 10:42 AM To: U2 Users List

Re: [U2] Type 30 files modified when LISTed? (UV 10.0.2)

2013-08-07 Thread Manu Fernandes
hi, When uv open a T30, it's header is loaded into uv's shared memory (until all user session which adress the file terminate), ready for writing. File is open for writing, I suppose some header info are updated at open time. Manu George Gallen ggal...@wyanokegroup.com a écrit : If I LIST

Re: [U2] Type 30 files modified when LISTed? (UV 10.0.2)

2013-08-07 Thread Aaron Titus
Type 19/1 files are actually directories at the operating system, not files. *Aaron Titus* Senior Software Engineer F.W. Davison Company, Inc. 508-747-7261 x245 ati...@fwdco.com On Wed, Aug 7, 2013 at 11:09 AM, Manu Fernandes e...@infodata.lu wrote: hi, When uv open a T30, it's header is

Re: [U2] Type 30 files modified when LISTed? (UV 10.0.2)

2013-08-07 Thread George Gallen
I figured that was the case for 1/19's, but still, it really messes things up when your trying To quickly decide which files have been changed recently. George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Aaron

Re: [U2] Large DICT affecting I/O

2013-08-07 Thread Wjhonson
Provided your dictionaries, in the one file scenario, or the five file scenario, are each and all, properly sized THEN You are more efficient in reading all dict entries from a single dict file BECAUSE Your app is only handling a single file pointer AND Your internal

[U2] I am looking for a CRM package on multi-value

2013-08-07 Thread Wjhonson
I am looking for a Customer Relationship Management application. I have a client who is familiar with Universe and would prefer that, but willing to look at other MV database applications. However they also will want to demo this to their own clients from time-to-time and so want a pretty

Re: [U2] I am looking for a CRM package on multi-value

2013-08-07 Thread Doug Averch
Hi: I have a 100% Web based CRM package that runs on Universe or Unidata. I would be happy at anytime to give you a demo of its capabilities or check out our web site for more information. Regards, Doug www.u2logic.com Full Suite of applications for U2 On Wed, Aug 7, 2013 at 10:22 AM, Wjhonson

Re: [U2] I am looking for a CRM package on multi-value

2013-08-07 Thread Tony Gravagno
You're quite clear that you don't want a pitch for non-MV so that's not where I'm going here. I think this inquiry is fascinating for how it's presented rather than what it's about. In short, in this case I think you're doing MV a dis-service by being so supportive. Because my response isn't

Re: [U2] I am looking for a CRM package on multi-value

2013-08-07 Thread Daniel Ruckel
Always appreciate your insights Tony, thank you. Danny Ruckel -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: Wednesday, August 07, 2013 12:50 PM To: u2-users@listserver.u2ug.org Subject: Re:

Re: [U2] I am looking for a CRM package on multi-value

2013-08-07 Thread Doug Averch
The reason U2 is such a small player in the database market is, in my opinion, we are a VAR driven market. The VAR's can only sell so much. The software quality of the applications is dependent on the VAR. And don't get me start on telnet applications. If Rocket Software U2 sold applications,

Re: [U2] I am looking for a CRM package on multi-value

2013-08-07 Thread George Gallen
We export to flat files (tearing apart the multivalue bonds) and import into Microsoft Dynamics (via a C# routine) on a nightly basis. So far it works fairly well - especially for collating all the different sources we have customers in (multiple files - multiple product types). Whereas, our MV

Re: [U2] I am looking for a CRM package on multi-value

2013-08-07 Thread George Gallen
Boy, I'm starting to feel inadequate - I've no blog to offer! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug Averch Sent: Wednesday, August 07, 2013 5:18 PM To: U2 Users List Subject: Re: [U2] I am looking for

Re: [U2] I am looking for a CRM package on multi-value

2013-08-07 Thread Wjhonson
What do you do about data change conflicts between these two disconnected systems? -Original Message- From: George Gallen ggal...@wyanokegroup.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, Aug 7, 2013 2:21 pm Subject: Re: [U2] I am looking for a CRM package on

Re: [U2] I am looking for a CRM package on multi-value

2013-08-07 Thread George Gallen
The nightly export scans the files each night and detects any changes or additions. We are working on removals - as these are harder to detect What I did was create a set of files on the UV side that mimick the flat files. Essentially, we take each set of data - figure out how it would look as

Re: [U2] I am looking for a CRM package on multi-value

2013-08-07 Thread Wjhonson
Why about in the other direction? Or is that strictly ad hoc ? -Original Message- From: George Gallen ggal...@wyanokegroup.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, Aug 7, 2013 2:30 pm Subject: Re: [U2] I am looking for a CRM package on multi-value The

Re: [U2] I am looking for a CRM package on multi-value

2013-08-07 Thread George Gallen
For anything that would need to come back, we pull using SQL But, we are using a business rule that any changes must be made at the source (MV) Which would then percolate back to the CRM that night. We aren't using the CRM to update the MV - only the MV to update the CRM As well, we have non

[U2] Removing bad Q-pointers. Good idea or not so much?

2013-08-07 Thread Wjhonson
Does anyone see any issues with removing Q pointers to files that won't open? 0001 * 0002 * Find Q-pointers that point to nothing, and delete them 0003 * 0004 EQUATE FALSE TO 0, TRUE TO 1 0005 OPEN 'VOC' TO F.VOC ELSE 0006 DISPLAY 'Cannot open VOC file.' ; STOP 0007 END

Re: [U2] Removing bad Q-pointers. Good idea or not so much?

2013-08-07 Thread Peter Cheney
If you were worried then you could write the suspect ones off to a log file before you deleted them. Then you could see what the were afterwards if needed? Perhaps also for some reason you might have q-pointer off to another account that may not exist right now but that will be used down the