Re: [U2] uniobjects dll question

2013-07-12 Thread Jeff Schasny
Doug, The .dll does not need to be installed. Visual Studio will include it in the installation package for your C# application after you add it to the project. doug chanco wrote: Is it possible to just put the uniobjects dll on a system without installing it? I am working on a home

[U2] Unbelievable or Believable you decide [ad]

2013-07-12 Thread Doug Averch
Our competitor, who shall be nameless in this post, has only changed their version number in last 9 months. We have added features and more features in the last two week than we ever thought we could. 1. XLr8Dictionary Editor - Ability to create indexes - Ability to delete indexes

Re: [U2] Unbelievable or Believable you decide [ad]

2013-07-12 Thread Charlie Noah
Doug, It might be more believable if you checked your spelling, grammar and sentence structure before posting. Just saying... Charlie Noah On 07-12-2013 10:02 AM, Doug Averch wrote: Our competitor, who shall be nameless in this post, has only changed their version number in last 9 months.

[U2] UniData Dynamic File Splitting Question

2013-07-12 Thread Cinda Goff
I work with the North Carolina Community College System which supports the 58 NC colleges. We have an unusual dynamic file issue at a couple of the colleges and am hoping someone could provide some insight/direction. OS - Solaris 10 UniData version 7.2.5 (have upgraded a couple of times in the

Re: [U2] UniData Dynamic File Splitting Question

2013-07-12 Thread Wjhonson
Instead of trying to keep recreating these dynamically every night, why not switch to a non-dynamic form ? -Original Message- From: Cinda Goff go...@nccommunitycolleges.edu To: u2-users u2-users@listserver.u2ug.org Sent: Fri, Jul 12, 2013 9:36 am Subject: [U2] UniData Dynamic

Re: [U2] UniData Dynamic File Splitting Question

2013-07-12 Thread Cinda Goff
We could with some of them but a good number of them need to remain dynamic because they are in total over the 2gb limit. -- Cinda Goff N.C. Community College System Database Administrator 919 807-7060 vRoom Link:

Re: [U2] UniData Dynamic File Splitting Question

2013-07-12 Thread Susan Lynch
Cindy, when some of our customers began having problems with dynamic files, I spent several months working after hours experimenting with dynamic files and doing hex dumps to see what precisely was happening. I would be glad to provide you with a copy of the documentation that I wrote up for our

Re: [U2] UniData Dynamic File Splitting Question

2013-07-12 Thread Susan Lynch
Cinda, my apologies for mis-spelling your name in my previous response . Susan Lynch -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Cinda Goff Sent: Friday, July 12, 2013 12:48 PM To: U2 Users List Subject: Re:

Re: [U2] UniData Dynamic File Splitting Question

2013-07-12 Thread Wjhonson
They don't. You can use distributed files, which are not dynamic in their parts. Each distributed piece can be close to 2Gig and you will never see an issue at all. -Original Message- From: Cinda Goff go...@nccommunitycolleges.edu To: U2 Users List u2-users@listserver.u2ug.org

Re: [U2] UniData Dynamic File Splitting Question

2013-07-12 Thread Baakkonen, Rodney A (Rod) 46K
We have some very large dynamic files. Some are over 100 gigabytes in size. Too me it is weird that you have one dat portion and 45 overflow portions of the file. My 100 gig file has 43 Dat portions and 1 overflow, which is what I try to maintain. I want as few overflow portions of the file as

Re: [U2] UniData Dynamic File Splitting Question

2013-07-12 Thread Dave Laansma
Agreed, the first step is to create the file so there are as many DAT files as necessary and only one or two OVER files. Once you've done that, copied all of the records over to the new file and it remains with only one or two OVER files, THEN do some analytics to establish the SPLIT/MERGE and

Re: [U2] UniData Dynamic File Splitting Question

2013-07-12 Thread Dave Laansma
Frankly, this doesn't look like a very big file at all, and I'm amazed you're getting any 'performance' out of it at all with all those OVER files. Crazy! Sincerely, David Laansma Hubbard Supply Co. Direct: 810-342-7143 Office: 810-234-8681 Fax: 810-234-6142 www.hubbardsupply.com Delivering

Re: [U2] UniData Dynamic File Splitting Question

2013-07-12 Thread Dave Davis
What hash type are you using? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Cinda Goff Sent: Friday, July 12, 2013 12:35 PM To: u2-users@listserver.u2ug.org Subject: [U2] UniData Dynamic File Splitting Question I

Re: [U2] UniData Dynamic File Splitting Question

2013-07-12 Thread Cinda Goff
Definitely crazy. When we rebuild some of files, they fit into one dat and one over so there was no reason for them to split in the first place. Application never purges records in most files so it is not likely a space reclamation issue. I'm used to a split grabbing a large chunk of space

Re: [U2] UniData Dynamic File Splitting Question

2013-07-12 Thread Dave Davis
We've had problems with hash type 0 dynamic files in the past - some files went into severe over-splitting - most groups were empty - we go with hash type 1 dynamic now. What do the keys look like? All numeric? Delimited parts? -Original Message- From:

Re: [U2] UniData Dynamic File Splitting Question

2013-07-12 Thread Cinda Goff
Thanks. Hash type 0 is the only hash supported by the vendor but that gives me something to look into. Keys are all over the place. Lots of files have sequential numeric keys but some of the files affected do have alpha and multi-part keys. --

Re: [U2] UniData Dynamic File Splitting Question

2013-07-12 Thread Wjhonson
This statement of yours is a wonder As for distributed files, Ellucian doesn't support them in the application so they are not an option at this point. Ellucian has an application that reaches in and reads and writes data in some kind of raw form? Otherwise I have no idea how the

Re: [U2] UniData Dynamic File Splitting Question

2013-07-12 Thread Wjhonson
If you're maybe just saying that they won't give you customer support should you choose this method, then don't ask for their support on this file :) Distributed files are quite easy to create and use, you shouldn't need any kind of support. -Original Message- From: Wjhonson

Re: [U2] UniData Dynamic File Splitting Question

2013-07-12 Thread Dave Davis
UniData doesn't do distributed files. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Friday, July 12, 2013 1:38 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UniData Dynamic File Splitting

Re: [U2] uniobjects dll question

2013-07-12 Thread Tony Gravagno
doug chanco wrote: Is it possible to just put the uniobjects dll on a system without installing it? I am working on a home project where I have an android app call a web service to get UV data from my linux server. I have a hosted system running windows server and I am working on a c#

Re: [U2] UniData Dynamic File Splitting Question

2013-07-12 Thread Wjhonson
Ahhh if that's true is amazing. Universe has had this for over twelve years. I guess the number of customers who used it was too small for them to port it to Unidata. -Original Message- From: Dave Davis dda...@harriscomputer.com To: U2 Users List u2-users@listserver.u2ug.org

Re: [U2] UniData Dynamic File Splitting Question

2013-07-12 Thread Baakkonen, Rodney A (Rod) 46K
There are a lot of Universe features I Would like to see in Unidata. Distributed files and all the hashing algorithms would be a nice start. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Friday,

Re: [U2] uniobjects dll question

2013-07-12 Thread Jeff Schasny
S... like I said, you don't need to install it on the client. If I add a reference to the UODOTNET.dll to the project references it includes the .dll on publish. Every time. Granted, I'm writing in VB not C#, so maybe things are different over there where the cool kids hang out. Tony

Re: [U2] UniData Dynamic File Splitting Question

2013-07-12 Thread Kevin King
I agree with Dave, SPLIT/MERGE ratios need to be checked. On Fri, Jul 12, 2013 at 11:00 AM, Dave Laansma dlaan...@hubbardsupply.comwrote: Agreed, the first step is to create the file so there are as many DAT files as necessary and only one or two OVER files. Once you've done that, copied all

Re: [U2] Any advantages to UV on 64-bit OS?

2013-07-12 Thread John Hester
Thanks, Phil and Bill. I'm currently leaning toward staying with 32-bit. -John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Phil Walker Sent: Thursday, July 11, 2013 3:07 PM To: U2 Users List Subject: Re: [U2]

Re: [U2] UniData Dynamic File Splitting Question

2013-07-12 Thread John Jenkins
Check UDT_SPLIT_POLICY in the current release notes. It avoids an unneeded split if a record is re-written and has not changed size. It may apply to your situation. Regards JayJay Sent from my iPad On 12 Jul 2013, at 17:51, Susan Lynch sly...@fwdco.com wrote: Cindy, when some of our

Re: [U2] Any advantages to UV on 64-bit OS?

2013-07-12 Thread John Jenkins
A 64-bit client needs a 64 bit ODBC driver. Both 32 and 64 bit are currently available. Regards JayJay Sent from my iPad On 11 Jul 2013, at 22:35, John Hester jhes...@momtex.com wrote: Hi all, I'm planning to upgrade our UV installation later this year primarily due to the age of

Re: [U2] UniData Dynamic File Splitting Question

2013-07-12 Thread Baakkonen, Rodney A (Rod) 46K
Something is radically wrong here. You only have 44K records in the file with 3277 groups. See if you can run a guide with the -d3 option and also show us the first page of the GROUP.STAT command. From ECL, do a GROUP.STAT UI.LOG.INFO and do a !guide -d3 UI.LOG.INFO. The guide will build 3