SAP Knowledge Base Article - Preview

2215920 - How to trace back from sysprocesses an empty spid number as a hostprocess for Java - SAP ASE

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

SAP Adaptive Server Enterprise 15.7

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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.