Symptom
- Error 936 is reported when trying to use model, but sp_who does not show any CREATE DATABASE in progress
use model
go
Msg 936, Level 14, State 1
Server '<server>', Line 1
The Model database is unavailable. It is being used to create a new database.
- dbcc dbtable <model> reports the following:
dbcc dbtable(model)
go
DBTABLES:
DB Table at: 0x10004a05640
dbt_dbid=3 dbt_stat=0x 0 (0x0000)
dbt_stat2=0xffff8000 (0x8000 (DBT2_MIXED_LOG_DATA))
dbt_stat3=0x20000 (0x00020000 (DBT3_SYSPARTITIONS_EXISTS))
dbt_stat4=0x 0 (0x00000000)
dbt_runstat=0x0(0x0000)
dbt_state=0x40(0x0040 (DBST_LOCK)) dbt_keep=0 dbt_hdeskeep=0 dbt_next=0x100049fe080 dbt_systask_keep=0 dbt_detachxact_keep 0
dbt_lock=1 dbt_dbaid=1
dbt_verstimestamp= Jun 4 2009 1:43PM dbt_dbname=model
dbt_logrows=0 dbt_extstat=0x0
dbt_lastlogbp=0x1008cf7aca0
dbt_nextseq=17 dbt_oldseq=16
dbt_dbinfobuf.dbi_logvers=7
dbt_dbinfobuf.dbi_upgdvers=35 ... .dbi_upgd_minor=1554
dbt_dbinfobuf.dbi_dbinfovers=5
dbt_dbinfobuf.dbi_sarg_vers=2 dbt_threshstat=0x0
dbt_thresholds=0x10004a06010 dbt_thresh_spin=0x100001fc200
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 15.7
- Sybase Adaptive Server Enterprise (ASE) 15.03
Product
Keywords
model, unavailable , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.