help!关于sybase 11.9.2 for UNIXWARE 7.1.1

leo_nnmm

小弟目前在做人行的小额支付系统,执行人行提供的建库createdb.sql后,重起sybase数据库,系统提示:
/home/sybase/install >00:00000:00000:2006/01/08 15:54:13.88 kernel  Running with old database version. Please run buildmaster to rebuild your database
00:00000:00000:2006/01/08 15:54:13.93 kernel  kdconfig: unable to read primary master device
00:00000:00000:2006/01/08 15:54:13.93 kernel  kiconfig: read of config block failed

查看sybase数据库日志SYBASE.log发现系统报692错

望达人帮忙看看到底是什么原因导致这个错误的!!!,多次测试发现,执行createdb.sql时,在create database之前初始化device的操作都是成功,我用的是一般得PC机，内存是256M。
顺便帮我看看是否是需要调一些系统参数???


本人qq:11696515
信箱:leo@easycon.com.cn

人行提供的createdb.sql如下:
use master
go

declare @vdevno int
select @vdevno = max(convert(tinyint, substring(convert(binary(4),d.low), v.low,1))) + 1
from master.dbo.sysdevices d, master.dbo.spt_values v   
where v.type = 'E' and v.number = 3

disk init
    name = "tempdb1",
    physname = "/home/sybase/beps/tempdb1",
    vdevno = @vdevno,
    size = 51200
go
alter database tempdb on tempdb1=100
go

declare @vdevno int
select @vdevno = max(convert(tinyint, substring(convert(binary(4),d.low), v.low,1))) + 1
from master.dbo.sysdevices d, master.dbo.spt_values v   
where v.type = 'E' and v.number = 3

disk init
    name = "ssyscdt",
    physname = "/home/sybase/beps/ssyscdt",
    vdevno = @vdevno,
    size = 102400
go

declare @vdevno int
select @vdevno = max(convert(tinyint, substring(convert(binary(4),d.low), v.low,1))) + 1
from master.dbo.sysdevices d, master.dbo.spt_values v   
where v.type = 'E' and v.number = 3

disk init
    name = "cmtmsgdt1",
    physname = "/home/sybase/beps/cmtmsgdt1",
    vdevno = @vdevno,
    size = 1024000
go


declare @vdevno int
select @vdevno = max(convert(tinyint, substring(convert(binary(4),d.low), v.low,1))) + 1
from master.dbo.sysdevices d, master.dbo.spt_values v   
where v.type = 'E' and v.number = 3

disk init
    name = "cmtmsgdt2",
    physname = "/home/sybase/beps/cmtmsgdt2",
    vdevno = @vdevno,
    size = 1024000
go

declare @vdevno int
select @vdevno = max(convert(tinyint, substring(convert(binary(4),d.low), v.low,1))) + 1
from master.dbo.sysdevices d, master.dbo.spt_values v   
where v.type = 'E' and v.number = 3

disk init
    name = "cmtmsgdt3",
    physname = "/home/sybase/beps/cmtmsgdt3",
    vdevno = @vdevno,
    size = 1024000
go


declare @vdevno int
select @vdevno = max(convert(tinyint, substring(convert(binary(4),d.low), v.low,1))) + 1
from master.dbo.sysdevices d, master.dbo.spt_values v   
where v.type = 'E' and v.number = 3

disk init
    name = "apiqueudt",
    physname = "/home/sybase/beps/apiqueudt",
    vdevno = @vdevno,
    size = 512000
go


declare @vdevno int
select @vdevno = max(convert(tinyint, substring(convert(binary(4),d.low), v.low,1))) + 1
from master.dbo.sysdevices d, master.dbo.spt_values v   
where v.type = 'E' and v.number = 3

disk init
    name = "comqueudt",
    physname = "/home/sybase/beps/comqueudt",
    vdevno = @vdevno,
    size = 512000
go


declare @vdevno int
select @vdevno = max(convert(tinyint, substring(convert(binary(4),d.low), v.low,1))) + 1
from master.dbo.sysdevices d, master.dbo.spt_values v   
where v.type = 'E' and v.number = 3

disk init
    name = "bepstrxsdt",
    physname = "/home/sybase/beps/bepstrxsdt",
    vdevno = @vdevno,
    size = 1024000
go


declare @vdevno int
select @vdevno = max(convert(tinyint, substring(convert(binary(4),d.low), v.low,1))) + 1
from master.dbo.sysdevices d, master.dbo.spt_values v   
where v.type = 'E' and v.number = 3

disk init
    name = "bepsinfodt",
    physname = "/home/sybase/beps/bepsinfodt",
    vdevno = @vdevno,
    size = 512000
go


declare @vdevno int
select @vdevno = max(convert(tinyint, substring(convert(binary(4),d.low), v.low,1))) + 1
from master.dbo.sysdevices d, master.dbo.spt_values v   
where v.type = 'E' and v.number = 3

disk init
    name = "bepspmisdt",
    physname = "/home/sybase/beps/bepspmisdt",
    vdevno = @vdevno,
    size = 512000
go


declare @vdevno int
select @vdevno = max(convert(tinyint, substring(convert(binary(4),d.low), v.low,1))) + 1
from master.dbo.sysdevices d, master.dbo.spt_values v   
where v.type = 'E' and v.number = 3

disk init
    name = "dirwaysidx",
    physname = "/home/sybase/beps/dirwaysidx",
    vdevno = @vdevno,
    size = 1024000
go

declare @vdevno int
select @vdevno = max(convert(tinyint, substring(convert(binary(4),d.low), v.low,1))) + 1
from master.dbo.sysdevices d, master.dbo.spt_values v   
where v.type = 'E' and v.number = 3

disk init
    name = "dirwayslog",
    physname = "/home/sybase/beps/dirwayslog",
    vdevno = @vdevno,
    size = 1024000
go


declare @vdevno int
select @vdevno = max(convert(tinyint, substring(convert(binary(4),d.low), v.low,1))) + 1
from master.dbo.sysdevices d, master.dbo.spt_values v   
where v.type = 'E' and v.number = 3

disk init
    name = "diswayswkdt",
    physname = "/home/sybase/beps/diswayswkdt",
    vdevno = @vdevno,
    size = 358400
go



declare @vdevno int
select @vdevno = max(convert(tinyint, substring(convert(binary(4),d.low), v.low,1))) + 1
from master.dbo.sysdevices d, master.dbo.spt_values v   
where v.type = 'E' and v.number = 3

disk init
    name = "diswayshisdt",
    physname = "/home/sybase/beps/diswayshisdt",
    vdevno = @vdevno,
    size = 1024000
go

declare @vdevno int
select @vdevno = max(convert(tinyint, substring(convert(binary(4),d.low), v.low,1))) + 1
from master.dbo.sysdevices d, master.dbo.spt_values v   
where v.type = 'E' and v.number = 3

disk init
    name = "diswaysidx",
    physname = "/home/sybase/beps/diswaysidx",
    vdevno = @vdevno,
    size = 358400
go

declare @vdevno int
select @vdevno = max(convert(tinyint, substring(convert(binary(4),d.low), v.low,1))) + 1
from master.dbo.sysdevices d, master.dbo.spt_values v   
where v.type = 'E' and v.number = 3

disk init
    name = "diswayslog",
    physname = "/home/sybase/beps/diswayslog",
    vdevno = @vdevno,
    size = 512000
go


create database DIRWAYSDB on
ssyscdt=200,
cmtmsgdt1=2000,
cmtmsgdt2=2000,
cmtmsgdt3=2000,
apiqueudt=1000,
comqueudt=1000,
bepstrxsdt=2000,
bepsinfodt=1000,
bepspmisdt=1000,
dirwaysidx=2000
log on dirwayslog=2000
go

create database DISWAYSDB on
diswayswkdt=700,
diswayshisdt=2000,
diswaysidx=700
log on diswayslog=1000
go

use DIRWAYSDB
go
sp_addsegment seg_ssyscdt,DIRWAYSDB,ssyscdt
go
sp_addsegment seg_cmtmsgdt,DIRWAYSDB,cmtmsgdt1
go
sp_extendsegment seg_cmtmsgdt,DIRWAYSDB,cmtmsgdt2
go
sp_extendsegment seg_cmtmsgdt,DIRWAYSDB,cmtmsgdt3
go
sp_addsegment seg_comqueudt,DIRWAYSDB,comqueudt
go
sp_addsegment seg_apiqueudt,DIRWAYSDB,apiqueudt
go
sp_addsegment seg_bepstrxsdt,DIRWAYSDB,bepstrxsdt
go
sp_addsegment seg_bepsinfodt,DIRWAYSDB,bepsinfodt
go
sp_addsegment seg_bepspmisdt,DIRWAYSDB,bepspmisdt
go
sp_addsegment seg_dirwaysidx,DIRWAYSDB,dirwaysidx
go

use DISWAYSDB
go
sp_addsegment seg_diswayswkdt,DISWAYSDB,diswayswkdt
go
sp_addsegment seg_diswayshisdt,DISWAYSDB,diswayshisdt
go
sp_addsegment seg_diswaysidx,DISWAYSDB,diswaysidx
go


use DIRWAYSDB
go
sp_dropgroup bepsmbfe
go
sp_addgroup bepsmbfe
go
use DISWAYSDB
go
sp_dropgroup bepsmbfe
go
sp_addgroup bepsmbfe
go

use DIRWAYSDB
go
sp_dropuser ccpcuser
go
sp_adduser  ccpcuser,ccpcuser,bepsmbfe
go
sp_dropuser mbuser
go
sp_adduser  mbuser,mbuser,bepsmbfe
go
sp_dropuser pbuser
go
sp_adduser  pbuser,pbuser,bepsmbfe
go
sp_dropuser appuser
go
sp_adduser  appuser,appuser
go

use DISWAYSDB
go
sp_dropuser ccpcuser
go
sp_adduser  ccpcuser,ccpcuser,bepsmbfe
go
sp_dropuser mbuser
go
sp_adduser  mbuser,mbuser,bepsmbfe
go
sp_dropuser pbuser
go
sp_adduser  pbuser,pbuser,bepsmbfe
go
sp_dropuser appuser
go
sp_adduser  appuser,appuser
goSample Text

冷月无声

配置方面：加大你的物理内存的分配并配置适当的user connection；
另外，你是建完库之后第一次启动就出现那些问题的吗？没有执行其他的sql脚本吗？顺便问一下，你的建库时间很长吧？ 大概多久？  
做个dbcc吧！

[ 本帖最后由 冷月无声 于 2006-1-9 11:20 编辑 ]

1017of

00:00000:00000:2006/01/08 15:54:13.88 kernel  Running with old database version. Please run buildmaster to rebuild your database
00:00000:00000:2006/01/08 15:54:13.93 kernel  kiconfig: read of config block failed

leo_nnmm

我将total memory 调成50000即100M,user connection 调成50,初始化时间大概要40分钟左右,没有执行其他脚本,在执行完createdb.sql后,在重起服务前,执行sp_helpdb,系统就报错了