ODBC listener gone off to never-never land?

We're seeing something unusual "from time to time" with the ODBC listener -- in particular, here is a glance screenshot of the main PIN:

HPB1787 B.10.07 HP GlancePlus/iX  16:06:20       Process (Pin 176 - #J7923)
                                 + 0: 0:29                     current avg high 
CPU   SB        *   B..........................................|  27%  18%  36%
Disc  MS               *               SIB         B...........|   79   30   79
Mem   M MS      SD     DF                      F.*.............|  74%  75%  75%
                         Process Selection Summary                              
CPU   *..............................<  0.0% |  NMPRG ODBCLNSE.ODBCSE.SYS
Disc  *..............................<  0.0  |  Elapsed  |  CPU-Tot  |  Disc-Tot
WorkGroup:DS_Default                       N | 16.7 hr   |   0.4 sec |       0  
State O                                                                  O<100%
Last  O                                                                  O<100%
Wait :                OTHER 100% | Compatibility Mode % ..............<    0%
Queue/Priority     :   D202      | Native Mode Switches ..............<    0/sec
Scheduling State   : Long Wait   | Comp. Mode Switches  ..............<    0/sec
Transactions/min   :   0         | Response Time        ..............<   0.00


Note in particular "Wait: OTHER 100%"

I'm at a loss to determine what "other" thing this is waiting upon

[and as it causes new connections to time out, it is rather frustrating to our users]

* To join/leave the list, search archives, change list settings, *
* etc., please visit  http://www.**--****.com/ *

You might try to look at a stack trace in Glance, when
viewing the PIN details. It is function key F3 or similar
and gives you a clue what intrinsic call it might be just
waiting for (probably something socket related).

You could also have a look at the ODBCLOG file (or even
the job listing), but might need to first enable some
logging details. I don't recall the available options
there, but they're most likely documented in the ODBCSE
manual at docs.hp.com ;-)

Lars.

* To join/leave the list, search archives, change list settings, *
* etc., please visit  http://www.**--****.com/ *

If your trace matches the one below, then this is the normal wait state for
ODBCLNSE. It is sitting on a call to IPCRECVCN waiting for a client to
connect. The IPCRECVCN (from trace) intrinsic allows a server process to
receive a socket connection request and then establish a connection called a
virtual circuit (VC). The connection is identified by the returned VC socket
descriptor. The calling process can then employ the IPCSEND and IPCRECV
intrinsics to send and receive data on the connection.

To see the socket details on this you would use the sockinfo utility.

Cordially,

Mike Hornsby
CoFounder
Beechglen Development Inc. (beechglen.com)
513-922-0509
 XXXX@XXXXX.COM 



From Glance:
NMPRG ODBCLNSE.ODBCSE.SYS
Wait : OTHER

Procedure Trace for Pin 94 is:

PC=a.0018799c enable_int+$2c
NM* 0) SP=41856b30 RP=a.0077756c
notify_dispatcher.block_current_process+$338
NM 1) SP=41856b30 RP=a.007793ac notify_dispatcher+$268
NM 2) SP=41856ab0 RP=a.008682c0 ipc_impede+$268
NM 3) SP=418569b0 RP=a.00868044 ?ipc_impede+$8
export stub: a.02012304 sk_block+$1c8
NM 4) SP=41856870 RP=a.02012c7c sk_block_for_completion+$110
NM 5) SP=41856730 RP=a.02044340 sk_accept.wait_for_passive_open_request+$84
NM 6) SP=418565b0 RP=a.02044644 sk_accept+$200
NM 7) SP=418564f0 RP=a.01ff4be0 IPCRECVCN+$2c0
NM 8) SP=418563f0 RP=a.01ff490c ?IPCRECVCN+$8
export stub: 6d2.00012d1c
NM 9) SP=418561b0 RP=6d2.00024d18
NM a) SP=41855630 RP=6d2.000109b4
NM b) SP=418541b0 RP=6d2.00000000

From Sockinfo:

PROCESS DISPLAY  Pin=94   Lsi=$ea.00000bf0  Dest=0 ($.00000000)       8:55
am
            < #j595 / odbclnse,manager.sys / odbclnse.odbcse.sys >

Desc  Type Prot Addr            Num out     Num in IO Flags
----------------------------------------------------------------------------
---
  15* call tcp  21246                 0          0 i  ns,iw


Socket type: call   Protocol: tcp
Flags: ns,iw
Input count: 1   Output count: 0   Iocount: 1
Socket nwtm pointer: $e6.00001410                    Plfd addr: $a.d5498d94
Read  Enabled mask: $60240000 (close-rply,open/connect,timer,irrec-err)
Write Enabled mask: $00000000
Pending mask: $00000000
Pm pointer: $87772260   Pm id: $00000000
State: listening
Cncts initiated: 0   Cncts received: 0
NetIPC error: 0   BSD error: 0   Pm error: 0
Error location: $0000   Error status: 0
Receive timeout: disabled
Source address: 21246

* To join/leave the list, search archives, change list settings, *
* etc., please visit  http://www.**--****.com/ *