该服务器近期做过的变更情况:
变更前,使用 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
Alter bufferpool information:
Pages left to remove = 0
Current size = 1000
Post-alter size = 1000
db2 get snapshot for database on mydb
Database Snapshot
Database name = MYDB
Database path = /mydb/db2inst1/NODE0000/SQL00001/
Input database alias = MYDB
Database status = Active
Catalog database partition number = 0
Catalog network node name =
Operating system running at database server= LINUX
Location of the database = Local
First database connect timestamp = 2012-04-10 18:26:41.309853
Last reset timestamp =
Last backup timestamp = 2012-04-06 18:46:39.000000
Snapshot timestamp = 2012-04-10 18:27:15.134111
Number of automatic storage paths = 0
High water mark for connections = 5
Application connects = 52
Secondary connects total = 0
Applications connected currently = 4
Appls. executing in db manager currently = 0
Agents associated with applications = 4
Maximum agents associated with applications= 5
Maximum coordinating agents = 5
Locks held currently = 0
Lock waits = 0
Time database waited on locks (ms) = 0
Lock list memory in use (Bytes) = 1000
Deadlocks detected = 0
Lock escalations = 0
Exclusive lock escalations = 0
Agents currently waiting on locks = 0
Lock Timeouts = 0
Number of indoubt transactions = 0
Total Private Sort heap allocated = 0
Total Shared Sort heap allocated = 0
Shared Sort heap high water mark = 0
Total sorts = 0
Total sort time (ms) = 0
Sort overflows = 0
Active sorts = 0
Buffer pool data logical reads = 14306
Buffer pool data physical reads = 13021
Buffer pool temporary data logical reads = 0
Buffer pool temporary data physical reads = 0
Asynchronous pool data page reads = 926
Buffer pool data writes = 0
Asynchronous pool data page writes = 0
Buffer pool index logical reads = 136
Buffer pool index physical reads = 66
Buffer pool temporary index logical reads = 0
Buffer pool temporary index physical reads = 0
Asynchronous pool index page reads = 0
Buffer pool index writes = 0
Asynchronous pool index page writes = 0
Total buffer pool read time (milliseconds) = 68
Total buffer pool write time (milliseconds)= 0
Total elapsed asynchronous read time = 3
Total elapsed asynchronous write time = 0
Asynchronous data read requests = 72
Asynchronous index read requests = 0
No victim buffers available = 0
LSN Gap cleaner triggers = 0
Dirty page steal cleaner triggers = 0
Dirty page threshold cleaner triggers = 0
Time waited for prefetch (ms) = 0
Unread prefetch pages = 0
Direct reads = 50
Direct writes = 0
Direct read requests = 10
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
Host execution elapsed time = 0.000731
Commit statements attempted = 92
Rollback statements attempted = 48
Dynamic statements attempted = 234
Static statements attempted = 140
Failed statement operations = 0
Select SQL statements executed = 46
Update/Insert/Delete statements executed = 0
DDL statements executed = 0
Inactive stmt history memory usage (bytes) = 0
Internal automatic rebinds = 0
Internal rows deleted = 0
Internal rows inserted = 0
Internal rows updated = 0
Internal commits = 52
Internal rollbacks = 0
Internal rollbacks due to deadlock = 0
Rows deleted = 0
Rows inserted = 0
Rows updated = 0
Rows selected = 33
Rows read = 143120
Binds/precompiles attempted = 0
Log space available to the database (Bytes)= 20400000
Log space used by the database (Bytes) = 0
Maximum secondary log space used (Bytes) = 0
Maximum total log space used (Bytes) = 0
Secondary logs allocated currently = 0
Log pages read = 0
Log read time (sec.ns) = 0.000000004
Log pages written = 0
Log write time (sec.ns) = 0.000000004
Number write log IOs = 0
Number read log IOs = 0
Number partial page log IOs = 0
Number log buffer full = 0
Log data found in buffer = 0
Appl id holding the oldest transaction = 1067
Log to be redone for recovery (Bytes) = 0
Log accounted for by dirty pages (Bytes) = 0
File number of first active log = 0
File number of last active log = 2
File number of current active log = 0
File number of log being archived = Not applicable
Package cache lookups = 188
Package cache inserts = 6
Package cache overflows = 0
Package cache high water mark (Bytes) = 118648
Application section lookups = 234
Application section inserts = 46
Catalog cache lookups = 169
Catalog cache inserts = 7
Catalog cache overflows = 0
Catalog cache high water mark = 0
Workspace Information
Shared high water mark = 0
Corresponding shared overflows = 0
Total shared section inserts = 0
Total shared section lookups = 0
Private high water mark = 14088
Corresponding private overflows = 0
Total private section inserts = 46
Total private section lookups = 46
Number of hash joins = 0
Number of hash loops = 0
Number of hash join overflows = 0
Number of small hash join overflows = 0
Memory usage for database:
Memory Pool Type = Backup/Restore/Util Heap
Current size (bytes) = 16384
High water mark (bytes) = 16384
Configured size (bytes) = 20496384
Memory Pool Type = Package Cache Heap
Current size (bytes) = 131072
High water mark (bytes) = 131072
Configured size (bytes) = 3189768192
Memory Pool Type = Catalog Cache Heap
Current size (bytes) = 65536
High water mark (bytes) = 65536
Configured size (bytes) = 3189768192
Memory Pool Type = Buffer Pool Heap
Current size (bytes) = 4325376
High water mark (bytes) = 4325376
Configured size (bytes) = 3189768192
Memory Pool Type = Buffer Pool Heap
Current size (bytes) = 655360
High water mark (bytes) = 655360
Configured size (bytes) = 3189768192
Memory Pool Type = Buffer Pool Heap
Current size (bytes) = 393216
High water mark (bytes) = 393216
Configured size (bytes) = 3189768192
Memory Pool Type = Buffer Pool Heap
Current size (bytes) = 262144
High water mark (bytes) = 262144
Configured size (bytes) = 3189768192
Memory Pool Type = Buffer Pool Heap
Current size (bytes) = 196608
High water mark (bytes) = 196608
Configured size (bytes) = 3189768192
Memory Pool Type = Lock Manager Heap
Current size (bytes) = 491520
High water mark (bytes) = 491520
Configured size (bytes) = 491520
Memory Pool Type = Database Heap
Current size (bytes) = 3555328
High water mark (bytes) = 3555328
Configured size (bytes) = 8175616
Memory Pool Type = Other Memory
Current size (bytes) = 0
High water mark (bytes) = 0
Configured size (bytes) = 12353536
Database Manager Configuration
Node type = Enterprise Server Edition with local and remote clients
Database manager configuration release level = 0x0a00
CPU speed (millisec/instruction) (CPUSPEED) = 3.424496e-07
Communications bandwidth (MB/sec) (COMM_BANDWIDTH) = 1.000000e+02
Max number of concurrently active databases (NUMDB) = 8
Data Links support (DATALINKS) = NO
Federated Database System Support (FEDERATED) = NO
Transaction processor monitor name (TP_MON_NAME) =
Default charge-back account (DFT_ACCOUNT_STR) =
Java Development Kit installation path (JDK_PATH) = /opt/IBMJava2-142
Diagnostic error capture level (DIAGLEVEL) = 3
Notify Level (NOTIFYLEVEL) = 3
Diagnostic data directory path (DIAGPATH) = /opt/db2inst1/sqllib/db2dump
Default database monitor switches
Buffer pool (DFT_MON_BUFPOOL) = ON
Lock (DFT_MON_LOCK) = ON
Sort (DFT_MON_SORT) = ON
Statement (DFT_MON_STMT) = ON
Table (DFT_MON_TABLE) = ON
Timestamp (DFT_MON_TIMESTAMP) = ON
Unit of work (DFT_MON_UOW) = ON
Monitor health of instance and databases (HEALTH_MON) = ON
SYSADM group name (SYSADM_GROUP) = DB2GRP1
SYSCTRL group name (SYSCTRL_GROUP) =
SYSMAINT group name (SYSMAINT_GROUP) =
SYSMON group name (SYSMON_GROUP) =
Client Userid-Password Plugin (CLNT_PW_PLUGIN) =
Client Kerberos Plugin (CLNT_KRB_PLUGIN) =
Group Plugin (GROUP_PLUGIN) =
GSS Plugin for Local Authorization (LOCAL_GSSPLUGIN) =
Server Plugin Mode (SRV_PLUGIN_MODE) = UNFENCED
Server List of GSS Plugins (SRVCON_GSSPLUGIN_LIST) =
Server Userid-Password Plugin (SRVCON_PW_PLUGIN) =
Server Connection Authentication (SRVCON_AUTH) = NOT_SPECIFIED
Database manager authentication (AUTHENTICATION) = SERVER
Cataloging allowed without authority (CATALOG_NOAUTH) = NO
Trust all clients (TRUST_ALLCLNTS) = YES
Trusted client authentication (TRUST_CLNTAUTH) = CLIENT
Bypass federated authentication (FED_NOAUTH) = NO
Default database path (DFTDBPATH) = /opt/db2inst1
Database monitor heap size (4KB) (MON_HEAP_SZ) = 90
Java Virtual Machine heap size (4KB) (JAVA_HEAP_SZ) = 2048
Audit buffer size (4KB) (AUDIT_BUF_SZ) = 0
Size of instance shared memory (4KB) (INSTANCE_MEMORY) = AUTOMATIC
Backup buffer default size (4KB) (BACKBUFSZ) = 1024
Restore buffer default size (4KB) (RESTBUFSZ) = 1024
Sort heap threshold (4KB) (SHEAPTHRES) = 20000
Directory cache support (DIR_CACHE) = YES
Application support layer heap size (4KB) (ASLHEAPSZ) = 15
Max requester I/O block size (bytes) (RQRIOBLK) = 32767
Query heap size (4KB) (QUERY_HEAP_SZ) = 1000
Workload impact by throttled utilities(UTIL_IMPACT_LIM) = 10
Priority of agents (AGENTPRI) = SYSTEM
Max number of existing agents (MAXAGENTS) = 400
Agent pool size (NUM_POOLAGENTS) = 200(calculated)
Initial number of agents in pool (NUM_INITAGENTS) = 0
Max number of coordinating agents (MAX_COORDAGENTS) = (MAXAGENTS - NUM_INITAGENTS)
Max no. of concurrent coordinating agents (MAXCAGENTS) = MAX_COORDAGENTS
Max number of client connections (MAX_CONNECTIONS) = MAX_COORDAGENTS
Keep fenced process (KEEPFENCED) = YES
Number of pooled fenced processes (FENCED_POOL) = MAX_COORDAGENTS
Initial number of fenced processes (NUM_INITFENCED) = 0
Index re-creation time and redo index build (INDEXREC) = RESTART
Transaction manager database name (TM_DATABASE) = 1ST_CONN
Transaction resync interval (sec) (RESYNC_INTERVAL) = 180
SPM name (SPM_NAME) =
SPM log size (SPM_LOG_FILE_SZ) = 256
SPM resync agent limit (SPM_MAX_RESYNC) = 20
SPM log path (SPM_LOG_PATH) =
TCP/IP Service name (SVCENAME) = db2c_db2inst1
Discovery mode (DISCOVER) = SEARCH
Discover server instance (DISCOVER_INST) = ENABLE
Maximum query degree of parallelism (MAX_QUERYDEGREE) = ANY
Enable intra-partition parallelism (INTRA_PARALLEL) = NO
No. of int. communication buffers(4KB)(FCM_NUM_BUFFERS) = 4096
Number of FCM request blocks (FCM_NUM_RQB) = AUTOMATIC
Number of FCM connection entries (FCM_NUM_CONNECT) = AUTOMATIC
Number of FCM message anchors (FCM_NUM_ANCHORS) = AUTOMATIC
Node connection elapse time (sec) (CONN_ELAPSE) = 10
Max number of node connection retries (MAX_CONNRETRIES) = 5
Max time difference between nodes (min) (MAX_TIME_DIFF) = 60
db2start/db2stop timeout (min) (START_STOP_TIME) = 10