该博客主要讲述了Linux服务器中，db2sysc进程内存使用持续增长的问题。服务器经历虚拟化迁移后，内存使用率从70%逐渐升高，发现31个db2sysc进程占用内存持续增加。通过`free -m`和`ps -eo pid,comm,rsv`等命令监控，发现内存主要被db2sysc占用，但具体原因不明。博主分享了db2level和数据库快照信息，寻求懂行人士帮助分析原因。"
70208454,6572654,使用JavaScript实现网页主题切换,"['JavaScript', '前端开发', 'CSS']
该服务器近期做过的变更情况：
变更前，使用 sar -r 1 3 看内存使用率服务器内存使用率一直是70%
该服务器原为独立物理服务器，经过虚拟化迁移到EXS上成为虚拟服务器。迁移后发现swap无法启
动。
原因是原物理服务器硬盘控制器为cciss。/etc/fstab 下swap的加载行为：
LABEL=SWAP-cciss/codop swap swap defaults 0 0
虚拟后硬盘控制器变成了sda
所以将/etc/fstab改为如下后，swap可以正常开机挂载。
/dev/sda2 swap swap defaults
0 0
其他未作变更。
现在内存使用率持续增加
free -m
total used free shared buffers cached
Mem: 3042 2210 832 0 179 1112-/+ buffers/cache: 918 2124
Swap: 4102 0 4102
以上标红的数值持续增长，大概每小时增长6m，虽然还有2G多内存，但这样张总有一天要耗尽。。。
我使用 ps -eo pid,comm,rsv|sort +2 -n 对进程占用内存情况进行排序，并分时间段进行对比。发现31
个db2sysc占用内存持续增加，其他进程基本没有变化。
不知是何原因，往懂的人指点指点。。。
free -m
total used free shared buffers cached
Mem: 3042 2210 832 0 179 1112
-/+ buffers/cache: 918 2124
Swap: 4102 0 4102
db2level
DB21085I Instance "db2inst1" uses "32" bits and DB2 code release "SQL08022"
with level identifier "03030106".
Informational tokens are "DB2 v8.1.2.88", "s050422", "MI00117", and FixPak "9".
Product is installed at "/opt/IBM/db2/V8.1".
Bufferpool Snapshot
Bufferpool name = IBMDEFAULTBP
Database name = MYDB
Database path = /mydb/db2inst1/NODE0000/SQL00001/
Input database alias = MYDB
Snapshot timestamp = 2012-04-10 18:16:39.031819
Buffer pool data logical reads = 770036
Buffer pool data physical reads = 745231
Buffer pool temporary data logical reads = 0
Buffer pool temporary data physical reads = 0
Buffer pool data writes = 3
Buffer pool index logical reads = 2168
Buffer pool index physical reads = 329
Buffer pool temporary index logical reads = 0
Buffer pool temporary index physical reads = 0
Total buffer pool read time (milliseconds) = 3705
Total buffer pool write time (milliseconds)= 14
Asynchronous pool data page reads = 125334
Asynchronous pool data page writes = 1
Buffer pool index writes = 2
Asynchronous pool index page reads = 0
Asynchronous pool index page writes = 1
Total elapsed asynchronous read time = 449
Total elapsed asynchronous write time = 8
Asynchronous data read requests = 9329
Asynchronous index read requests = 0
No victim buffers available = 178344
Direct reads = 176
Direct writes = 0
Direct read requests = 28
Direct write requests = 0
Direct reads elapsed time (ms) = 0
Direct write elapsed time (ms) = 0
Database files closed = 0
Data pages copied to extended storage = 0
Index pages copied to extended storage = 0
Data pages copied from extended storage = 0
Index pages copied from extended storage = 0
Unread prefetch pages = 37737
Vectored IOs = 9321
Pages from vectored IOs = 125295
Block IOs = 0
Pages from block IOs = 0
Physical page maps = 0
Node number = 0
Tablespaces using bufferpool = 4
A
最低0.47元/天 解锁文章
1255
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
