Re: [U2] How to check which sproc is called by user

2013-01-08 Thread Brian Leach
If it is a session hang you're possibly looking at locking issues so check
the lock table to see what is waiting and also check for any group locks
that persist.

If it is UniVerse, It's also a good idea to check the errlog file in the uv
account: if that does not exist, create it as a zero length file (you can go
into the UV account and ED UFD errlog and just file it) and it will log
the last 100 errors.

If you can catch the session that has hung you can use the PORT.STATUS
command to see where they were and their calling stack.

Phil's idea of using the remote item security subroutine to audit calls is
good once you've managed to identify the routine concerned, but it doesn't
help you get to that point.

How is your application constructed? Is it terminal based, UniObjects, Web?
If it is terminal based, create a COMO on the LOGIN for that user session
and see if that helps find it.

If it is UniObjects based and you can clearly identify the user (and you
have the time and space) and nothing else has worked, you can actually watch
their session using a network tracer.

I think we need to know a little more about the context of the problem.

Brian


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ravindranath
Wickramanayake
Sent: 07 January 2013 21:55
To: u2-users@listserver.u2ug.org
Subject: [U2] How to check which sproc is called by user

Hi U2 Guru's

 

Can I tell when a sproc was last executed or who executed it.  If so how.
Some way to get statistics and access logs. Reason we are asking this is we
are having a session hang issue we have tracked it down to a session user
but have no clue which sproc did the call to trouble shoot.

 

Thanks in advance

___
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] How to check which sproc is called by user

2013-01-08 Thread Andy Krause
I will chime in since I work with Ravi and I am dealing with this issue
along with him.

Thanks for the response Brian, PORT.STATUS should be useful for our
situation.

I'll try and be a little more specific and hopefully I know what I'm
talking about:  We have a web application which is using UniObjects and
we are randomly getting multiple (we've seen as many as 9) user sessions
in the LISTU which appear to be hung and it's causing us to reach our
user limit.  We have debugged the web application and verified that all
sessions are being closed properly so we do not believe that it's on the
web side of things.  Although, we cannot duplicate this problem in the
live application either, so we cannot say for sure it's not on the web
side.  My first thought was that the application is calling a PICK
subroutine that is stalling (possibly waiting for input or stuck in an
infinite loop or something).

So, at this point all we know is we are getting these stalled sessions
but we don't know how.  Hopefully with PORT.STATUS we can see whether is
a PICK subroutine that is stalling?

Now, to limit the severity of this problem we discovered there is a
Timeout property of the UniSession object.  However, it seems in the
past we were advised against setting this parameter by Rocket support
and that this timeout should be handled in the unirpcservices file in
the unishared directory?  Does that sound right?  UniAdmin uses the
timeout in the unirpcservices file so I don't think we would want to
shorten the timeout and be booted from UniAdmin sooner.

Thanks in advance for any responses.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach
Sent: Tuesday, January 08, 2013 3:35 AM
To: 'U2 Users List'
Subject: Re: [U2] How to check which sproc is called by user

If it is a session hang you're possibly looking at locking issues so
check the lock table to see what is waiting and also check for any group
locks that persist.

If it is UniVerse, It's also a good idea to check the errlog file in the
uv
account: if that does not exist, create it as a zero length file (you
can go into the UV account and ED UFD errlog and just file it) and it
will log the last 100 errors.

If you can catch the session that has hung you can use the PORT.STATUS
command to see where they were and their calling stack.

Phil's idea of using the remote item security subroutine to audit calls
is good once you've managed to identify the routine concerned, but it
doesn't help you get to that point.

How is your application constructed? Is it terminal based, UniObjects,
Web?
If it is terminal based, create a COMO on the LOGIN for that user
session and see if that helps find it.

If it is UniObjects based and you can clearly identify the user (and you
have the time and space) and nothing else has worked, you can actually
watch their session using a network tracer.

I think we need to know a little more about the context of the problem.

Brian


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ravindranath
Wickramanayake
Sent: 07 January 2013 21:55
To: u2-users@listserver.u2ug.org
Subject: [U2] How to check which sproc is called by user

Hi U2 Guru's

 

Can I tell when a sproc was last executed or who executed it.  If so
how.
Some way to get statistics and access logs. Reason we are asking this is
we are having a session hang issue we have tracked it down to a session
user but have no clue which sproc did the call to trouble shoot.

 

Thanks in advance

___
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] How to check which sproc is called by user

2013-01-08 Thread Bill Haskett

Andy:

The first place I'd look for any UO errors is the UO error log. In UD, 
you need to create a serverdebug item in the @UDTHOME directory (in my 
case this is in E:\U2\ud).  The contents of this item is:


udcs 10 E:\U2\ud\log\udcs\udcs.log

...which indicates maximum logging and the log should go to the location 
indicated.  From there I've always been able to track down UO problems.  
They've mostly been with my UOLOGIN globally cataloged routine, but 
sometimes I see other problems.


I'm not sure how to do this in UV, but it should be fairly easy to track 
down once you activate UO logging.


HTH,

Bill

P.S.  I set all of my UO connections to timeout in 5 minutes (in my 
E:\U2\unishared\unirpc\unirpcservices file).  This causes the Basic  
Developer's Toolkit to not work properly, but you can use any other 
development client  you want, as long as it sends a keepalive.



- Original Message -
*From:* akra...@rammutual.com
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 1/8/2013 6:43 AM
*Subject:* Re: [U2] How to check which sproc is called by user

I will chime in since I work with Ravi and I am dealing with this issue
along with him.

Thanks for the response Brian, PORT.STATUS should be useful for our
situation.

I'll try and be a little more specific and hopefully I know what I'm
talking about:  We have a web application which is using UniObjects and
we are randomly getting multiple (we've seen as many as 9) user sessions
in the LISTU which appear to be hung and it's causing us to reach our
user limit.  We have debugged the web application and verified that all
sessions are being closed properly so we do not believe that it's on the
web side of things.  Although, we cannot duplicate this problem in the
live application either, so we cannot say for sure it's not on the web
side.  My first thought was that the application is calling a PICK
subroutine that is stalling (possibly waiting for input or stuck in an
infinite loop or something).

So, at this point all we know is we are getting these stalled sessions
but we don't know how.  Hopefully with PORT.STATUS we can see whether is
a PICK subroutine that is stalling?

Now, to limit the severity of this problem we discovered there is a
Timeout property of the UniSession object.  However, it seems in the
past we were advised against setting this parameter by Rocket support
and that this timeout should be handled in the unirpcservices file in
the unishared directory?  Does that sound right?  UniAdmin uses the
timeout in the unirpcservices file so I don't think we would want to
shorten the timeout and be booted from UniAdmin sooner.

Thanks in advance for any responses.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach
Sent: Tuesday, January 08, 2013 3:35 AM
To: 'U2 Users List'
Subject: Re: [U2] How to check which sproc is called by user

If it is a session hang you're possibly looking at locking issues so
check the lock table to see what is waiting and also check for any group
locks that persist.

If it is UniVerse, It's also a good idea to check the errlog file in the
uv
account: if that does not exist, create it as a zero length file (you
can go into the UV account and ED UFD errlog and just file it) and it
will log the last 100 errors.

If you can catch the session that has hung you can use the PORT.STATUS
command to see where they were and their calling stack.

Phil's idea of using the remote item security subroutine to audit calls
is good once you've managed to identify the routine concerned, but it
doesn't help you get to that point.

How is your application constructed? Is it terminal based, UniObjects,
Web?
If it is terminal based, create a COMO on the LOGIN for that user
session and see if that helps find it.

If it is UniObjects based and you can clearly identify the user (and you
have the time and space) and nothing else has worked, you can actually
watch their session using a network tracer.

I think we need to know a little more about the context of the problem.

Brian


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ravindranath
Wickramanayake
Sent: 07 January 2013 21:55
To: u2-users@listserver.u2ug.org
Subject: [U2] How to check which sproc is called by user

Hi U2 Guru's

  


Can I tell when a sproc was last executed or who executed it.  If so
how.
Some way to get statistics and access logs. Reason we are asking this is
we are having a session hang issue we have tracked it down to a session
user but have no clue which sproc did the call to trouble shoot.

  


Thanks in advance

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users



Re: [U2] Garbage in locks

2013-01-08 Thread John Hester
Good point.  I would start by checking the health of the uvdlockd
process.  We had an issue a few years ago where a misbehaving JDBC
client application would cause a lot of work for the uvdlockd process.
Eventually the uvdlockd.log file in the uv home directory hit 2GB in
size and uvdlockd stopped working completely.  I ended up implementing a
log rotation script for uvdlockd.

-John 

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Hona, David
Sent: Monday, January 07, 2013 7:36 PM
To: U2 Users List
Subject: Re: [U2] Garbage in locks

Looks like UV? What version or platform? Did these user process normally
exit UV or did they drop connectivity or abnormally terminate from UV??

UV Lock Daemon typically cleans-up non-deadlock locking issues,
including orphaned locks (sometimes :)).


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Holt, Jake
Sent: Tuesday, 8 January 2013 8:17 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Garbage in locks

Is there a way to resync, or clean the lock list?  It seems like every
once in a while we will get garbage in the lock list that will not go
away until we reboot.The users are long since logged off and these
locks do not show up in uniadmin.  It doesn't actually seem to do
anything other than make it hard to find active waiters.

 

 

Example:

 

Active Read Waiters:  Owner   Waiter


Device  Inode Userno  Userno


  10465106915866934427836   62692


  10465106915866934427836   58520


  104651069158669344278365836


  20297666099756827340769560


  20297666099756827340768264


  115824063137137493724007836


  2029766609975682737836 236


  20297666099756827378365216


  20297666099756827378367912


  2029766609975682737836   59820


  20297666099756827378363424


  20297666099756827378367140

 

Thanks,

 

Jake Holt |Information Technology Director

Samsill Corporation 

5740 Hartman Rd | Fort Worth, TX 76119

(817) 536 - 1906 x 217 | Fax (817) 535 - 6900

www.samsill.com

 

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains
information which may be confidential. 
If you are not the intended recipient please advise the sender by return
email, do not use or disclose the contents, and delete the message and
any attachments from your system. Unless specifically indicated, this
email does not constitute formal advice or commitment by the sender or
the Commonwealth Bank of Australia (ABN 48 123 123 124) or its
subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us,
please reply to this e-mail by typing Unsubscribe in the subject line. 
**



___
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