Hi Jennifer,
We have see this problem of Web Admin sessions hanging in earlier
releases (APAR IC28349). We are now running 3.7.3.8 and are not
presently experiencing this. But we have seen some other problems
running SQL queries. One issue is that TSM does not support correlated
sub-queries. When I've issued these complex SQL queries, the query may
run for a very long time or appear to loop and then crash the server.
Another issue we've seen with SQL queries, is that they use database
space for their calculations. We've had some problems with not have
enough contiguous space for the transaction. This is partially true for
us, because we have an old, large, highly fragmented database.
Good luck getting to the bottom of this issue.
Dennis
Subject:
Hung Admin Sessions
Date:
Fri, 23 Feb 2001 19:32:14 -0500
From:
"Jennifer I. Moore" <[EMAIL PROTECTED]>
Gentle Greetings,
Has anyone noticed any situations where Admin sessions on the server get
hung and become "ghost" sessions that will not go away? Cancelling has
no
effect. Opening a separate Admin session and cancelling from there has
no
effect. In some cases, subsequent sessions get hung and a reboot is
necessary. And in other cases, there seems to be no adverse side
effects.
In this case, I was doing some SQL queries on the database, and two user
Admin sessions hung and two Query Admin sessions hung. (Fortunately,
everything else is continuing to run smoothly.) Below is the output
from
"show threads" related to these 4 sessions.
We are running 4.1.2 Server on an IBM M80 running AIX 4.3.3.
Thank you in advance for any help and/or suggestions.
Jennifer
----------------------------
Thread 68: SessionThread
tid=4437, ktid=34577, ptid=52, det=1, zomb=0, join=0, result=0,
sess=31636
Awaiting cond 5c355b04 (mutex 301a65b0) at 10009b38 (outGetNext)
Thread 101: SessionThread
tid=653d, ktid=69811, ptid=52, det=1, zomb=0, join=0, result=0,
sess=31768
Awaiting cond 5c33a484 (mutex 301a65b0) at 10009b38 (outGetNext)
Thread 105: SessionThread
tid=6963, ktid=72547, ptid=52, det=1, zomb=0, join=0, result=0,
sess=30446
Awaiting cond 5c286354 (mutex 301a65b0) at 10009b38 (outGetNext)
Thread 108: SessionThread
tid=6acf, ktid=52079, ptid=52, det=1, zomb=0, join=0, result=0,
sess=31704
Awaiting cond 5c1c69d4 (mutex 301a65b0) at 10009b38 (outGetNext)
--
Dennis Riley
Qwest Communications International Inc.
450 110th NE, Room 103
Bellevue, WA 98004
work: 425-451-5236
fax: 425-453-3589
pager: 800-946-4646.1434047
cell: 425-351-7049
begin:vcard
n:Riley;Dennis
tel;pager:(800)946-4646.1434047
tel;cell:(425)351-7049
tel;fax:(425)453-3589
tel;work:(425)451-5236
x-mozilla-html:FALSE
org:EWEBARS;<BR><IMG SRC="file:///C|/Program Files/Netscape/users/driley/qwest_it.gif" WIDTH=107 HEIGHT=58 ALIGN=left bgcolor="ffffcc">
adr:;;450 110th NE, Room 103;Bellevue;Washington;98004;
version:2.1
email;internet:[EMAIL PROTECTED]
title:TSM Server Specialist <BR><IMG SRC="file:///C|/Program Files/Netscape/users/driley/tivoli_cert.gif" ALIGN=right>
x-mozilla-cpt:;-18080
fn:Riley, Dennis
end:vcard
