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