IBM Sterling B2B: Queries to collect locked sessions of Connect:Direct
Queries
select * from CD_SHSSL_ACTIVE_SESSIONS
select * from CD_SHSSL_GROUPS
select * from CD_SHSSL_LOCAL_NODES
select * from CD_SHSSL_REMOTE_NODES
select * from CD_SHSSL_QUEUE
select sum(ACTIVE_SNODE_SESSIONS) from CD_SHSSL_ACTIVE_SESSIONS