- A query running with parallel mode returns no result after ASE upgrade to 16.0 SP03.
- sp_who results shows that worker processes are in 'sync sleep'.
17 17 sleeping sa (omit) SELECT
17 18 sync sleep sa (omit) WORKER PROCESS
17 19 sync sleep sa (omit) WORKER PROCESS
- A coordinating thread is sleeping at pipe_read()
- Two Worker threads are sleeping at uwrecv()
SAP Adaptive Server Enterprise (ASE) 16.0 SP02 or higher.
DTA, Dynamic Thread Assignment, merge join , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem
About this pageThis 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.