Jennifer,

Yes, I get these too... They appear to happen whenever I have a session
doing anything that takes a long time (moving data w/ wait=yes, big sql
query, etc.).

The 'ghost' sessions don't appear to harm anything, although I have
noticed that eventually the server will start acting generally strange
until a halt and restart are done.

I've also noticed that the longer a dsmadmc program is running (even if
the session times out w/ the server) the slower the client responds.  No
real apparent reason for this, either.

I too am running 4.1.2 on AIX 4.3.3

+-----------------------------------------------------------------------+
| Brian T. Huntley                                Systems Administrator |
| Campus Information Services, Clarkson University                      |
| Ph/FAX: 315.268-6723/6570                                             |
| bth AT clarkson DOT edu                                 www.clarkson.edu/cis |
+-----------------------------------------------------------------------+
 UNIX *is* user friendly. It's just selective about who its friends are.
        PGP Public Key available. finger bth AT clarkson DOT edu

On Fri, 23 Feb 2001, Jennifer I. Moore wrote:

// 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)
//
//