2637792 - 936 error The Model database is unavailable after killing a create database - ASE | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

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

Symptom

  • Creating an ASE database and running a dump database simultaneously
  • Issue a kill <spid> on the create database
  • The following error is reported when using model

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

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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.