該服務器近期做過的變更情況：

變更前，使用 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

總結

以上是生活随笔為你收集整理的linux db2sysc 内存,db2sysc进程占用linux内存持续增长，请各位指点。的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。