- 论坛徽章:
- 0
|
目前在办理业务时老是报打开一些表出错,但是反复办理就能成功.在业务高峰期更是要提交很多次才能成功.我怀疑是索引文件需要重建或者是数据库需要调整参数.
1,如果是需要重建索引文件,能否使用dbexport和dbimport来实现?
2,调整数据库参数请大家看看onconfig的主要字段.
环境sco 5.05 informix online 7.31 内存2G
# Shared Memory Parameters
LOCKS 800000 # Maximum number of locks
BUFFERS 600000 # Maximum number of shared buffers
NUMAIOVPS # Number of IO vps
PHYSBUFF 128 # Physical log buffer size (Kbytes)
LOGBUFF 128 # Logical log buffer size (Kbytes)
LOGSMAX 150 # Maximum number of logical log files
CLEANERS 5 # Number of buffer cleaner processes
LRUS 8 # Number of LRU queues
LRU_MAX_DIRTY 60 # LRU percent dirty begin cleaning limit
LRU_MIN_DIRTY 55 # LRU percent dirty end cleaning limit
LTXHWM 50 # Long transaction high water mark percentage
LTXEHWM 60 # Long transaction high water mark (exclusive)
onstat -p的结果主要是:
bufreads %cached bufwrits %cached
99.54 90.38
ovlock ovuserthread ovbuff
0 0 0
bufwaits lokwaits lockreqs deadlks dltouts ckpwaits
1873523 257035892 1327787342 786 5 363
另外,看了以前的帖子,说buffers应该是物理内存的25-50%,我是2G的物理内存,
该是2*1000*1000/128吗? 单位是K?? |
|