sybase建庫出現(xiàn)新故障，與大家分享

wangliangkaiser

use master
go

disk init
name='tempdb',
physname='/sybase/data/tempdb',
vdevno=3,
size=20480
go

alter database tempdb
on tempdb=40
go




disk init
name='wkdatadb',
physname='/sybase/data/wkdatadb',
vdevno=4,
size=204800
go

disk init
name='wkindexdb',
physname='/sybase/data/wkindexdb',
vdevno=5,
size=51200
go

disk init
name='wkdblog',
physname='/sybase/data/wkdblog',
vdevno=6,
size=102400
go

disk init
name='hisdatadb',
physname='/sybase/data/hisdatadb',
vdevno=7,
size=1024000
go

disk init
name='hisindexdb',
physname='/sybase/data/hisindexdb',
vdevno=8,
size=153600
go

disk init
name='hisdblog',
physname='/sybase/data/hisdblog',
vdevno=9,
size=204800
go

create database MBFEWKDB
on wkdatadb=400,wkindexdb=100
log on wkdblog=200
go

create database MBFEHISDB
on hisdatadb=2000,hisindexdb=300
log on hisdblog=400
go


use MBFEWKDB
go
sp_addsegment seg_wkdata,MBFEWKDB,wkdatadb
go
sp_addsegment seg_wkindex,MBFEWKDB,wkindexdb
go





use MBFEHISDB
go
sp_addsegment seg_hisdata,MBFEHISDB,hisdatadb
go
sp_addsegment seg_hisindex,MBFEHISDB,hisindexdb
go


use master
go
sp_addlogin 'ccpcuser','key123'
go
sp_addlogin 'mbuser','key456'
go
sp_addlogin 'pbuser','key789'
go
sp_addlogin 'appuser','appuser'
go

use MBFEWKDB
go
sp_addgroup mbfe
go
use MBFEHISDB
go
sp_addgroup mbfe
go

use MBFEWKDB
go
sp_adduser  ccpcuser,ccpcuser,mbfe
go
sp_adduser  mbuser,mbuser,mbfe
go
sp_adduser  pbuser,pbuser,mbfe
go
sp_adduser  appuser,appuser
go

use MBFEHISDB
go
sp_adduser  ccpcuser,ccpcuser,mbfe
go
sp_adduser  mbuser,mbuser,mbfe
go
sp_adduser  pbuser,pbuser,mbfe
go
sp_adduser  appuser,appuser
go

以上腳本，執(zhí)行到紅色腳本部分報以下信息，不知道各位前輩是否見過，
希望與大家一起討論，分享！


Server Message:  Number  1805, Severity  10
Line 1:
CREATE DATABASE: allocating 204800 pages on disk 'wkdatadb'
Server Message:  Number  1805, Severity  10
Line 1:
CREATE DATABASE: allocating 51200 pages on disk 'wkindexdb'
Server Message:  Number  1805, Severity  10
Line 1:
CREATE DATABASE: allocating 102400 pages on disk 'wkdblog'
Server Message:  Number  695, Severity  21
Line 1:
An attempt was made to read logical page '221440' for object '99' in database '7' from disk. Wrong logical page '72960' was brought into cache 'default data cache'.
Server Message:  Number  1813, Severity  16
Line 1:
Cannot open new database 'MBFEWKDB'. CREATE DATABASE is aborted.

chenfeng825

http://manuals.sybase.com/online ... _BookTextView/18324;hf=0

ustcboy

你看看系統(tǒng)參數(shù)設置是否正確

chuxu

create database時候，把尺寸改小一點試試