Re: [U2] Monitoring connections on Unidata
No - all you need is listuser - it lists ALL users licences, phantom,udcs, tty etc - it also gives a total licence count at the top which is an absolute total including device licencing. -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 19:53 To: U2 Users List Subject: Re: [U2] Monitoring connections on Unidata 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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - No virus found in this message. Checked by AVG - www.avg.com Version: 2012.0.2195 / Virus Database: 2437/5114 - Release Date: 07/06/12 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Monitoring connections on Unidata
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 U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Monitoring connections on Unidata
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 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 U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - No virus found in this message. Checked by AVG - www.avg.com Version: 2012.0.2195 / Virus Database: 2437/5112 - Release Date: 07/05/12 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Monitoring connections on Unidata
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 Subject:Re: [U2] Monitoring connections on Unidata Sent by:u2-users-boun...@listserver.u2ug.org 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 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 U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - No virus found in this message. Checked by AVG - www.avg.com Version: 2012.0.2195 / Virus Database: 2437/5112 - Release Date: 07/05/12 ___ 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] Monitoring connections on Unidata
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 http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Monitoring connections on Unidata
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 count its immediate children. I think this should
work:
PID=`ps -el | grep unirpcd | awk '{print $4}'`
COUNT=`ps -el | grep $PID | awk '{print $5}' | grep $PID | wc -l`
echo $COUNT
-John
-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 9:21 AM
To: U2 Users List
Subject: Re: [U2] Monitoring connections on Unidata
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
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] Monitoring connections on Unidata
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 count its immediate children. I think this should
work:
PID=`ps -el | grep unirpcd | awk '{print $4}'`
COUNT=`ps -el | grep $PID | awk '{print $5}' | grep $PID | wc -l`
echo $COUNT
-John
Thanks. That works great.
The problem I am having is that our MRP application does a lot of RPC
calls to our Unidata server. We have been having a lot of random problems
and I suspect that we are running out of connections. I am looking for a
way to show that for sure. I am recommending beefing up our licenses and
need to show some justification for the financial expense.
Does the sum of the number of users plus the number of RPC connections
give me the number of licenses in use at the moment?
It seems that way. Right now there are 56 users listed in listuser. There
are 31 RPC connections. This is a total of 87. We have 96 licenses. And
right now everybody seems to be happy. I expect that when problems start
occurring, I will check and find that the total of the list user count and
RPC connections will be greater than 96.
Does that sound right?
Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Monitoring connections on Unidata
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:
0001: CALL !GET.USER.COUNTS (uv.users, max.uv.users, os.users)
0002: PRINT Max UniVerse users: :max.uv.users
0003: PRINT Current UniVerse users: :uv.users
0004: PRINT OS users : :os.users
-John
-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 11:08 AM
To: U2 Users List
Subject: Re: [U2] Monitoring connections on Unidata
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 count its immediate children. I think this should
work:
PID=`ps -el | grep unirpcd | awk '{print $4}'` COUNT=`ps -el | grep
$PID | awk '{print $5}' | grep $PID | wc -l` echo $COUNT
-John
Thanks. That works great.
The problem I am having is that our MRP application does a lot of RPC
calls to our Unidata server. We have been having a lot of random
problems and I suspect that we are running out of connections. I am
looking for a way to show that for sure. I am recommending beefing up
our licenses and need to show some justification for the financial
expense.
Does the sum of the number of users plus the number of RPC connections
give me the number of licenses in use at the moment?
It seems that way. Right now there are 56 users listed in listuser.
There are 31 RPC connections. This is a total of 87. We have 96
licenses. And right now everybody seems to be happy. I expect that
when problems start occurring, I will check and find that the total of
the list user count and RPC connections will be greater than 96.
Does that sound right?
Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
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] Monitoring connections on Unidata
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: 0001: CALL !GET.USER.COUNTS (uv.users, max.uv.users, os.users) 0002: PRINT Max UniVerse users: :max.uv.users 0003: PRINT Current UniVerse users: :uv.users 0004: PRINT OS users : :os.users Thanks. I used the code you shared and some of my own to show the Users, RPC connections and the sum. This will give me a tool to watch the number of connections and compare to the occurrences of problems. Naturally, since it is late on Friday afternoon, things are quieting down. Charles Shaffer Senior Analyst NTN-Bower Corporation ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Monitoring connections on Unidata
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 file and E-mails it to the IT management. Any data over 90
days is purged (so my file is fairly static in size).
Management then open it in Excel and make pretty pictures with charts and pivot
tables. It allows them to track when we are busy, how many licenses we are
using, etc. They have found this to be very helpful.
Maybe this would help.
JRI
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Hester
Sent: Friday, July 06, 2012 2:26 PM
To: U2 Users List
Subject: Re: [U2] Monitoring connections on Unidata
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:
0001: CALL !GET.USER.COUNTS (uv.users, max.uv.users, os.users)
0002: PRINT Max UniVerse users: :max.uv.users
0003: PRINT Current UniVerse users: :uv.users
0004: PRINT OS users : :os.users
-John
-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 11:08 AM
To: U2 Users List
Subject: Re: [U2] Monitoring connections on Unidata
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 count its immediate children. I think this should
work:
PID=`ps -el | grep unirpcd | awk '{print $4}'` COUNT=`ps -el | grep
$PID | awk '{print $5}' | grep $PID | wc -l` echo $COUNT
-John
Thanks. That works great.
The problem I am having is that our MRP application does a lot of RPC calls to
our Unidata server. We have been having a lot of random problems and I suspect
that we are running out of connections. I am looking for a way to show that
for sure. I am recommending beefing up our licenses and need to show some
justification for the financial expense.
Does the sum of the number of users plus the number of RPC connections give me
the number of licenses in use at the moment?
It seems that way. Right now there are 56 users listed in listuser.
There are 31 RPC connections. This is a total of 87. We have 96 licenses.
And right now everybody seems to be happy. I expect that when problems start
occurring, I will check and find that the total of the list user count and RPC
connections will be greater than 96.
Does that sound right?
Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
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] Monitoring connections on Unidata
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 charles_shaf...@ntn-bower.com Sent: 06 July 2012 16:34 To: U2 Users List Cc: u2-users-boun...@listserver.u2ug.org Subject: Re: [U2] Monitoring connections on Unidata 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 Subject:Re: [U2] Monitoring connections on Unidata Sent by:u2-users-boun...@listserver.u2ug.org 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 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 U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - No virus found in this message. Checked by AVG - www.avg.com Version: 2012.0.2195 / Virus Database: 2437/5112 - Release Date: 07/05/12 ___ 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 - No virus found in this message. Checked by AVG - www.avg.com Version: 2012.0.2195 / Virus Database: 2437/5112 - Release Date: 07/05/12 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Monitoring connections on Unidata
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 file and E-mails it to the IT management. Any data over 90 days is purged (so my file is fairly static in size). Management then open it in Excel and make pretty pictures with charts and pivot tables. It allows them to track when we are busy, how many licenses we are using, etc. They have found this to be very helpful. Maybe this would help. JRI You bet. Management loves numbers. Is it Unibasic? Thanks. Charles Shaffer Senior Analyst NTN-Bower Corporation ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Monitoring connections on Unidata
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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Monitoring connections on Unidata
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] Monitoring connections on Unidata 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 file and E-mails it to the IT management. Any data over 90 days is purged (so my file is fairly static in size). Management then open it in Excel and make pretty pictures with charts and pivot tables. It allows them to track when we are busy, how many licenses we are using, etc. They have found this to be very helpful. Maybe this would help. JRI You bet. Management loves numbers. Is it Unibasic? Thanks. Charles Shaffer Senior Analyst NTN-Bower Corporation ___ 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] Monitoring connections on Unidata
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 that sends an email alert if the high water mark is within 5 seats of our total licenses. -John -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 11:41 AM To: U2 Users List Subject: Re: [U2] Monitoring connections on Unidata 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: 0001: CALL !GET.USER.COUNTS (uv.users, max.uv.users, os.users) 0002: PRINT Max UniVerse users: :max.uv.users 0003: PRINT Current UniVerse users: :uv.users 0004: PRINT OS users : :os.users Thanks. I used the code you shared and some of my own to show the Users, RPC connections and the sum. This will give me a tool to watch the number of connections and compare to the occurrences of problems. Naturally, since it is late on Friday afternoon, things are quieting down. Charles Shaffer Senior Analyst NTN-Bower Corporation ___ 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] Monitoring connections on Unidata
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: rocketsoftware.com/u2 -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 12:50 PM To: U2 Users List Cc: u2-users-boun...@listserver.u2ug.org Subject: Re: [U2] Monitoring connections on Unidata 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 file and E-mails it to the IT management. Any data over 90 days is purged (so my file is fairly static in size). Management then open it in Excel and make pretty pictures with charts and pivot tables. It allows them to track when we are busy, how many licenses we are using, etc. They have found this to be very helpful. Maybe this would help. JRI You bet. Management loves numbers. Is it Unibasic? Thanks. Charles Shaffer Senior Analyst NTN-Bower Corporation ___ 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
