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

Search for additional results

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