免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
最近访问板块 发新帖
查看: 3444 | 回复: 3

sybase建库出现新故障,与大家分享 [复制链接]

论坛徽章:
0
发表于 2008-04-06 09:17 |显示全部楼层
10可用积分
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

以上脚本,执行到红色脚本部分报以下信息,不知道各位前辈是否见过,
希望与大家一起讨论,分享!


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.

论坛徽章:
0
发表于 2008-04-07 16:33 |显示全部楼层

论坛徽章:
0
发表于 2008-05-06 17:27 |显示全部楼层
你看看系统参数设置是否正确

论坛徽章:
1
2017金鸡报晓
日期:2017-01-10 15:19:56
发表于 2008-05-06 17:42 |显示全部楼层
create database时候,把尺寸改小一点试试
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们:huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP