2204927 - Error 936 The model database is unavailable. It is being used to create a new database. - SAP ASE

• Error 936 is returned when trying to access 'model' database

use model
go

Msg 936, Level 14, State 1:
Server 'ASE', Line 1:The model database is unavailable. It is being used to create a new database.

• It can also be reported by third party backup tools, for example Commvault

• The following command would show that model database is indeed locked, the dbt_lock counter set to 1 indicates that.

  dbcc traceon(3604)
  go
  dbcc dbtable(model)
  go

  ACTIVE DBTABLES:
    
  dbt_dbid=3  dbt_stat=0x1 (0x0001 (DBT_TXT_LINKED))
  
  <output deleted>
  
  dbt_lock=1  dbt_dbaid=1

  dbcc traceoff(3604)
  go

SAP Adaptive Server Enterprise (ASE). All versions

recovery, dbtable, dbt_lock, locked , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem