Re: [U2] RESIZE - dynamic files

2012-07-06 Thread Israel, John R.
The best thing I can say about the MINIMUM.MODULUS is that if you set it close to what you expect the file to need (at least for a while), when you start populating it from scratch, you will not lose the performance as the file keeps splitting. This can make an amazing difference in how long

Re: [U2] RESIZE - dynamic files

2012-07-06 Thread Wols Lists
On 05/07/12 23:58, Rick Nuckolls wrote: Oops, I would of thought that if a file had, say 100,000 bytes, @ 70 percent full, there would be 30,000 bytes empty or dead. Are you suggesting the there would be 70,000 bytes of data and 42,000 bytes of dead space? Do you mean 100,000 bytes of disk

[U2] Monitoring connections on Unidata

2012-07-06 Thread Charles_Shaffer
Is there a way to monitor the number of RPC connections being used at any given time on Unidata 7.1/Redhat 3? We are not using device licensing. Charles Shaffer Senior Analyst NTN-Bower Corporation ___ U2-Users mailing list

Re: [U2] Monitoring connections on Unidata

2012-07-06 Thread Symeon Breen
listuser ? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of charles_shaf...@ntn-bower.com Sent: 06 July 2012 14:54 To: U2 Users List Subject: [U2] Monitoring connections on Unidata Is there a way to monitor the

Re: [U2] Monitoring connections on Unidata

2012-07-06 Thread Charles_Shaffer
What about connections coming from client applications? UniCall, UniObjects, etc. Do they use up licenses also? Charles Shaffer Senior Analyst NTN-Bower Corporation From: Symeon Breen syme...@gmail.com To: 'U2 Users List' u2-users@listserver.u2ug.org, Date: 07/06/2012 10:18 AM

Re: [U2] Monitoring connections on Unidata

2012-07-06 Thread Charles_Shaffer
When I run # ps-A | grep 'udapi_slave' | wc -l Am I getting a count of client connections? Charles Shaffer Senior Analyst NTN-Bower Corporation ___ U2-Users mailing list U2-Users@listserver.u2ug.org

Re: [U2] RESIZE - dynamic files

2012-07-06 Thread Chris Austin
So is there a performance increase in BASIC SELECTS by reducing overflow? Some people are saying to reduce disk space to speed up the BASIC SELECT while others say to reduce overflow.. I'm a bit confused. All of our programs that read that table use a BASIC SELECT WITH.. for a BASIC select do

Re: [U2] RESIZE - dynamic files

2012-07-06 Thread Wjhonson
What do you mean a BASIC SELECT WITH... If you mean you are EXECUTE SELECT CUSTOMER WITH... that is not a BASIC SELECT whose syntax is only OPEN CUSTOMER TO F.CUSTOMER SELECT F.CUSTOMER no WITH -Original Message- From: Chris Austin cjausti...@hotmail.com To: u2-users

Re: [U2] Monitoring connections on Unidata

2012-07-06 Thread John Hester
On UV, counting instances of uvapi_slave tells me how many unirpc connections are active via UOJ. It doesn't include JDBC connections, though. JDBC connections spawn a process called uvserver. If capturing every type of unirpc connection is important, you could determine the PID of unirpcd and

Re: [U2] RESIZE - dynamic files

2012-07-06 Thread Rick Nuckolls
Logically, the graphed solution to varying the split.load value with an x-axis=modulus, y-axis=time_to_select__read_the_whole_file is going to be parabolic, having very slow performance at modulus=1 and modulus = # of records. If you actually want to find the precise low point, ignore all this

Re: [U2] Monitoring connections on Unidata

2012-07-06 Thread Charles_Shaffer
On UV, counting instances of uvapi_slave tells me how many unirpc connections are active via UOJ. It doesn't include JDBC connections, though. JDBC connections spawn a process called uvserver. If capturing every type of unirpc connection is important, you could determine the PID of

Re: [U2] RESIZE - dynamic files

2012-07-06 Thread Susan Lynch
Chris, 10 years ago, when I was administering a UniVerse system, the answer would have been minimize both to the best of your ability. But I don't know how UniVerse has changed in the interim, during which time I have been working on UniData systems, which are enormously different in their

[U2] T30File parameter in Universe 10.3.7

2012-07-06 Thread Allen Egerton
The default value for T30Files is 200, and it's described as controlling the number of dynamic files that can be open on a system at any point in time. Has anyone had practical experience with increasing this limit? And yes I'm asking because we just crashed into this wall --- and it wasn't

Re: [U2] RESIZE - dynamic files

2012-07-06 Thread Wjhonson
You forgot the need to defragment, since someone suggested that my idea of using the intrinsic look-ahead ability is hampered by hard fragmentation. -Original Message- From: Rick Nuckolls r...@lynden.com To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Fri, Jul 6, 2012 11:20 am

Re: [U2] Monitoring connections on Unidata

2012-07-06 Thread John Hester
That sounds like the correct way to determine total license count. In UV at least, there is also a more official way to do it via a built-in subroutine called !GET.USER.COUNTS. I don't know if it exists in UD. I have a simple program I can run at TCL that calls it and reports the numbers:

Re: [U2] T30File parameter in Universe 10.3.7

2012-07-06 Thread mhilbert
Yes, we ran into this limit some time ago at a client site, we set it to 1200. No problems. On Fri, 06 Jul 2012 14:15:00 -0400, Allen Egerton wrote: The default value for T30Files is 200, and it's described as controlling the number of dynamic files that can be open on a system at any point

Re: [U2] Monitoring connections on Unidata

2012-07-06 Thread Charles_Shaffer
John Hester That sounds like the correct way to determine total license count. In UV at least, there is also a more official way to do it via a built-in subroutine called !GET.USER.COUNTS. I don't know if it exists in UD. I have a simple program I can run at TCL that calls it and reports the

Re: [U2] Monitoring connections on Unidata

2012-07-06 Thread Israel, John R.
I wrote a pgm that executes !listuser, captures the license counts from the output (maybe line 4?), rips that data apart and writes the data to a log file (LICENSES). This job runs every 15 minutes. I then wrote a program that runs every morning and exports all the data to a tab-delimited txt

Re: [U2] Monitoring connections on Unidata

2012-07-06 Thread Symeon Breen
Listuser shows rpc connections. The tty shows as udcs, if it is using a uniobjects.net pooled connection, the type is pooled, otherwise it is udt -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of

Re: [U2] Monitoring connections on Unidata

2012-07-06 Thread Charles_Shaffer
I wrote a pgm that executes !listuser, captures the license counts from the output (maybe line 4?), rips that data apart and writes the data to a log file (LICENSES). This job runs every 15 minutes. I then wrote a program that runs every morning and exports all the data to a tab-delimited txt

Re: [U2] Monitoring connections on Unidata

2012-07-06 Thread Charles_Shaffer
Symeon. Listuser shows rpc connections. The tty shows as udcs, if it is using a uniobjects.net pooled connection, the type is pooled, otherwise it is udt Is total license usage, the listuser plus the udcs connections? Charles Shaffer Senior Analyst NTN-Bower Corporation

Re: [U2] Monitoring connections on Unidata

2012-07-06 Thread Israel, John R.
Yes it is. JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of charles_shaf...@ntn-bower.com Sent: Friday, July 06, 2012 2:50 PM To: U2 Users List Cc: u2-users-boun...@listserver.u2ug.org Subject: Re: [U2]

Re: [U2] Monitoring connections on Unidata

2012-07-06 Thread John Hester
What I do to monitor ongoing license usage is run a program via ON.ENTRY that checks the current user count total and writes it to a log record for today's date if it's greater than the current entry. That gives me a high water mark for each day. A program runs during nightly batch processing

Re: [U2] Monitoring connections on Unidata

2012-07-06 Thread Wally Terhune
Note - there is a UniBasic LISTUSER() function that returns the detail lines in a dynamic array for easy parsing. Wally Terhune Technical Support Engineer Rocket Software 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA t: +1 720 475 8055 **e: wterh...@rocketsoftware.com **w:

Re: [U2] T30File parameter in Universe 10.3.7

2012-07-06 Thread John Thompson
Don't use too many dynamic files myself. However, I would imagine if you... Assuming you are on *nix Assuming uvhome is /usr/uv -Login to uv account MASTER OFF ALL -shutdown uv /usr/uv/bin/uv -admin -stop -changed the parameter in /usr/uv/uvconfig (Just use your favorite text editor) -do a