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.
SAP Knowledge Base Article - Preview