SAP Knowledge Base Article - Preview

2637792 - 936 error The Model database is unavailable after killing a create database - ASE

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

SAP Adaptive Server Enterprise 15.7 ; Sybase Adaptive Server Enterprise 15.0

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.