2036081 - Errors 16072 and 18273 when attempting to drop user-defined thread pool and user-defined execution class - SAP ASE

• ASE 15.7 and up
• Having user-defined thread pool and user-defined execution class, user binds execution class to a client application / login / stored procedure / default execution class.  Getting error when dropping thread pool and execution class:
  1> drop thread pool test_pool
  2> go
  Msg 16072, Level 16, State 1:
  Server 'sp110', Line 1:
  Threadpool test_pool is in use by an execution class definition. Delete the execution class before trying to drop the threadpool.
  1> sp_dropexeclass EC_test
  2> go
  Msg 18273, Level 16, State 1:
  Server 'sp110', Procedure 'sp_dropexeclass', Line 95:
  Either 'EC_test' is being used so it cannot be dropped or an internal error occurred. Check server errorlog for any additional information.
  (return status = 1)

SAP Adaptive Server Enterprise (ASE) 15.7 and up

thread pool,execution class , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To