os_create_region: shmat(2752523):

jlh

我的SYBASE版本是12.50。系统是LINUX AS  4，服务器是hp Proliant DL360,内存2G，系统参数的设置是
kernel.shmmax = 800000000
数据库的参数是
number of devices 20
number of user connections 100
number of open indexes 2000
numeer of open objects 2000
number of sort buffers 5000
max memory 512000
用sp_configure "memory" 可以看到还有900000K的内存可以调整呢，可是我只要是把default data cache 调到超过50M的时候，重新启动SYBASE就出现了如下提示的错误
00:00000:00000:2006/03/30 14:55:22.19 kernel os_create_region: shmat(2752523):Invalid argument
00:00000:00000:2006/03/30 14:55:22.19 kernel  kbcreate: couldn't create kernel r
egion.
00:00000:00000:2006/03/30 14:55:22.19 kernel  kistartup: could not create shared
memory
向各位请教啦

1017of

shmmax=800000000(bytes)
max memory 512000(2k)
512000*2048=1048576000
which one is bigger?1048576000 or 800000000?

jlh

呵呵，是我看错啦，可是后来我把max memory改为200000，还是一样的效果，所以应该不是那个的原因，虽然那个会引起错误

echoaix

ssm_threshold set to 0试试

jlh

我看看去

chenfeng825

注意是否krg文件导致的！

jlh

我用FIND查了一下，没看到SRG或者是KRG文件呢

jlh

我怀疑是不是shmmax问题
我查了一个SYBASE的说法
os_create_region: shmat (%d): %s
This message is written to the error log when SQL Server fails to
attach at an address. In this message, %d is the shared memory
identifier and %s is an operating system error messag
Action
1. At the operating system level, check which shared memory
processes are using and whether shared memory segments are
being used by SQL Server.
To check this on UNIX, run this command as the “sybase” user:
% ipcs -m
IPC status from workstation1 as of Fri May 26 14:08:25 1995
T ID KEY MODE OWNER GROUP
Shared Memory:
m 256 0x699b7e24 --rw------- sybase sybase
m 257 0x699b7e25 --rw------- sybase sybase
If shared memory segments are being used by SQL Server,
reboot the operating system to clear shared memory or remove
them using the ipcrm operating system command.
ä Note
Before removing the shared memory segments, identify the process that
created them using the command “ipcs -ma” to make sure you only remove
the appropriate segments.
2. Check the $SYBASE directory to see whether there are any *.krg
or *.srg files left from an abnormal SQL Server exit. If any such
files exist, delete them.
3. os_create_region errors can occur when shared memory is not
configured properly on your operating system. Refer to theSystem Administration Guide Supplement for your platform for
information about configuring shared memory properly.
我在以前装的一台机子上查看IPCS时，只要没启动SYBASE，就没有相应的信息，而在这台上我没启动SYBASE也可以看到十几行的内存的使用地址，这就对上了shared memory
processes are using and whether shared memory segments are
being used by SQL Server.