- 论坛徽章:
- 6
|
本帖最后由 andkylee 于 2010-03-09 09:33 编辑
回复 1# snow888
Adaptive Server message: 'Message number: 5861, Severity 16, State 2, Line 1
Message String: The current 'max memory' value '32768', is not sufficient to
change the parameter 'allow updates to system tables' to '1'. 'max memory'
should be greater than 'total logical memory' '33603' required for the
configuration.
'. Error in query: 'select config_admin(1,102,1, 0, NULL, NULL)'.
----------------------------------------------------------------------------------
你是通过资源文件resource file创建的数据库,很不幸运配置的最大可用内存不够用了。配置更新系统表allow updates to system tables的参数需要:
835*2K的内存(33603-32768)。
这个查询select config_admin(1,102,1, 0, NULL, NULL)的意思是将allow updates to system tables改为1,
演示如下:- 1> sp_configure "allow upd"
- 2> go
- Parameter Name Default Memory Used Config Value
- Run Value Unit Type
- ------------------------------ ----------- ----------- ------------
- ------------ -------------------- ----------
- allow updates to system tables 0 0 0
- 0 switch dynamic
- (1 row affected)
- (return status = 0)
- 1> select config_admin(1,102,1, 0, NULL, NULL)
- 2> go
- -----------
- 1
- (1 row affected)
- 1> sp_configure "allow upd"
- 2> go
- Parameter Name Default Memory Used Config Value
- Run Value Unit Type
- ------------------------------ ----------- ----------- ------------
- ------------ -------------------- ----------
- allow updates to system tables 0 0 1
- 1 switch dynamic
- (1 row affected)
- (return status = 0)
复制代码 select config_admin(1,102,0, 0, NULL, NULL)将allow updates to system tables改为0.
演示如下:- 1> sp_configure "allow upd"
- 2> go
- Parameter Name Default Memory Used Config Value
- Run Value Unit Type
- ------------------------------ ----------- ----------- ------------
- ------------ -------------------- ----------
- allow updates to system tables 0 0 1
- 1 switch dynamic
- (1 row affected)
- (return status = 0)
- 1> select config_admin(1,102,0, 0, NULL, NULL)
- 2> go
- -----------
- 1
- (1 row affected)
- 1> sp_configure "allow upd"
- 2> go
- Parameter Name Default Memory Used Config Value
- Run Value Unit Type
- ------------------------------ ----------- ----------- ------------
- ------------ -------------------- ----------
- allow updates to system tables 0 0 0
- 0 switch dynamic
- (1 row affected)
- (return status = 0)
复制代码 Error in query: 'update sysdatabases set status = status | 8 where dbid =
db_id('sybsystemprocs')'.
上面这句话是想将sybsystemprocs数据库加上truncate log on chkpt选项,可是因为内存不足没有执行成功!
Error in query: 'select config_admin(1,102,0, 0, NULL, NULL)'.
这句话意思是将allow updates to system tables参数再改成0,估计也因为内存不足执行不成功。
以上这些语句就是installmaster脚本中的sql。可用去查看一下。
很遗憾,sybase ASE的资源文件模板弄得一团糟糕,各个版本各个平台下的都不一致。很混乱。
我的建议是:配置servername.cfg配置参数文件。然后再执行一下 srvbuildres |
|