Symptom
- While running a third party application on ASE 15.7 SP134 on Linux
- The client does not display any traceable information in:
select * from sysprocesses where spid number order by 1 - The sysprocesses..hostprocesses values are blank, for example:
1> select * from sysprocesses where spid = XXX order by 1
2> go
spid kpid enginenum status suid hostname program_name hostprocess cmd cpu physical_io memusage blocked dbid uid gid tran_name time_blocked network_pktsz fid execlass priority affinity id stmtnum linenum origsuid block_xloid clie ntname clienthostname clientapplname sys_id ses_id loggedindatetime ipaddr nodeid
------ ----------- ----------- ------------ ----------- ------------------------------ ------------------------------ ------------------------------ ------------------------------ ----------- ----------- ----------- ------- ------ ----------- -- --------- ---------------------------------------------------------------- ------------ ------------- ------ ------------------------------ ---------- ------------------------------ ----------- ----------- ----------- ----------- ----------- ---- -------------------------- ------------------------------ ------------------------------ ------ ----------- ------------------------------- ---------------------------------------------------------------- ------
629 208470128 15 sleeping 817 Example20142.xxxxxxx.com NULL LOG SUSPEND 12 3687587 21 0 12 277 16392 $chained_transaction NULL 512 0 EC2 MEDIUM syb_default_pool 1703899387 2 1 NULL 0 0 0 Month day year 11:50AM 10.85.28.36 NULL
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) 15.7
Product
Keywords
JAVA, ct_con_props , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , How To
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.