sybase疯狂打印日志

xumouxin1

有谁知道怎么解决???????

chuxu

你的运行值是否比default小很多？
改回default试试

yymzhj

如果你的操作系统是SCO,再做BCP时疯狂报错，需要修改内核参数
1。用root用户进入scoadmin,选择kernel项
2。增加一个异步IO
3。调整异步IO的参数，将NAIOBUF,NAIOPROC,NAIOREQ调大，其中一个游5调到8，其他调到150就可以了
4。编译内核后重启主机，重启数据库就可以了

xumouxin1

没做BCP啊!!!!
我试试吧,

xumouxin1

刚才查到一个资料:
On any hardware the default disk io structures and max asynch io engine
and server are way under what current systems can do.... Try setting
"disk i/o structures" to 65536 and also "max asynch i/o per engine" and
"max asynch i/o per server" to same value - it always best to have these
three agree. Note that on some OS's, to truly get that many concurrent
I/O's, you may have to change some kernal configs.

不知道行不行啊

xumouxin1

明天再来搞了!!饿死了

xumouxin1

我在做下面操作:
>sp_configure "max async i/os per server",65536
>go

出现如下错误信息:
Msg 5849, Level 16, State 1:
Procedure 'sp_configure', Line 510:
Verification failed for parameter 'max async i/os per server'.

这又是怎么回事? 是不是值太大了?我改成64时可以

chuxu

sp_configure 报错应该是OS的相关参数小了。
For Digital UNIX
In Digital UNIX releases before 3.0 (Digital OSF), the number of outstanding asynchronous I/Os was hard-coded in the operating system kernel in the AIO_MAX parameter (stored in a header file in /sys). Its default value was 64. For those releases, the Adaptive Server I/O-related configuration parameters should be set to 64 so that Adaptive Server can match the operating system's rate of concurrent I/O requests.

不知道OSF1和这个OSF是不是一个东西。
看来在这个系统下，这个值只能是64。

好像tru64下sysconfig -q rt
查看相关参数

[ 本帖最后由 chuxu 于 2007-9-27 20:15 编辑 ]

xumouxin1

上次我就是把max async i/os per server和max async i/os per engine都设为64的,但还是不行啊!!