該服務器近期做過的變更情況：
變更前，使用 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
)
