2320482 - ASE returns error 10901 and/or error 603 in the log, reporting a lack of aux scan / system descriptors - SAP ASE

• ASE returns error 10901, a shortage of 'number of aux scan descriptors', to the client:
  
  Msg 10901, Level 17, State 1:
  Server 'ASE', Line 1:
  This query requires 8 auxiliary scan descriptors, but currently there are only 1 auxiliary scan descriptors available. Either raise the value of the 'number of aux scan descriptors' configuration parameter or try your query later. 
  
  
  • Example of JConnect application error:
    
    com.sybase.jdbc4.jdbc.SybSQLException: This query requires 8 auxiliary scan descriptors, but currently there are only 1 auxiliary scan descriptors available.
    Either raise the value of the 'number of aux scan descriptors' configuration parameter or try your query later.
    
    
• ASE reports error 603 in the errorlog:
  
  Error: 603, Severity: 17, State: 1
  There are not enough system session descriptors available to run this query. Raise the value of the configuration parameter 'number of aux scan descriptors' or retry your query later. You will need to increase the 'number of aux scan descriptors' to resolve this issue.
  
  
• How to determine what query is using up the 'number of aux scan descriptors' ?

SAP Adaptive Server Enterprise (ASE). All versions.

auxiliary scan descriptors, Error: 10901, SAP ASE, sysdes ,  sdes_hookup , open__byid , open_user_table , get_name , getfullname , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , How To