Dumps connection state information.
rp_dump [@what, @sentolog]
Specifies the type of connection state information:
thread – dumps information about all user connection threads in OpenSwitch.
mutex – dumps information about all mutexes that OpenSwitch owns.
all – dumps information about all OpenSwitch threads and mutexes. This is the default if you do not specify the type of connection state information.
Specifies whether to write the dump of the connection state information to the OpenSwitch log:
0 – OpenSwitch does not write the dump of the connection state to the OpenSwitch log. This is the default.
1 – OpenSwitch writes the dump of the connection state information to the OpenSwitch log.
1> rp_dump thread 2> go
Returns:
******** THREAD DUMP ********* <spid #15 system pid 21337 state=<NONE> coord=<NONE>> server mask=0x0, busy time='11/06/05 21:53:09', transtate=CS_TRAN_UNDEFINED, app='isql', user='sa', host='loka', db='master', conn=0xee12ac8, current='ase2', next='ase2', pool='POOL1', proc=0x4095b4, cap set=CS_FALSE, next cursor=0, reason code=0, reason text='', function='' (return status = 0)
Use this procedure for debugging.
Use rp_dump when you want more details about user connections.
