SAP Knowledge Base Article - Preview

2534145 - The NLWP threads of SAP ASE is growing up - SAP ASE

Symptom

  • You can see many NLWP threads that is involved in SAP ASE process from the result of 'prstat' command.
     23885 user     13G   13G sleep    0    0  91:02:51 1.3% dataserver/93
     20629 user     13G   13G cpu3     1    0 119:36:03 1.3% dataserver/99
     24070 user     13G   13G sleep   32    0  97:43:31 0.6% dataserver/108
  • The result of 'pstack' command shows that all NLWP threads are Solaris async I/O library.
    [pstack result]
    ----------------- lwp# 4 / thread# 4 --------------------
    lwp_park
    cond_wait_queue
    cond_wait 
    _aio_idle 
    _aio_do_request
    thread_create_handler
    _lwp_start


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE)
  • SAP Adaptive Server Enterprise Cluster Edition (ASE CE)
  • Solaris on Sparc 64bit
  • Process mode

Product

SAP Adaptive Server Enterprise 12.5 ; SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

  •  Lightweight processes
, KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , 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.