A机的其他信息
Copyright IBM Corp. 2005, 2006 All Rights Reserved. db2top 2.
[\]23:26:07,refresh=2secs(0.004) Memory AIX,part=[1/1],DB2INST1:CCCDB
[d=Y,a=N,e=N,p=ALL] [qp=off]
+--------------+------------+------------+------------+-----------+
Self Tuning......: Off | | 25%| 50%| 75%| 100%| Sort Heap........: 35.6M
Sort HWM.........: 165.9M |Memory hwm% |--- | Private Mem......: 4.6M
Lock List........: 15.3K |Sort Heap% |------------------------ | Private Sort.....: 35.6M
Shared Sort......: 0 |Mem Skew% | | Shared Sort HWM..: 0
Private Work HWM.: 5.2M |Pool Skew% | | PkgCache HWM.....: 54.8M
Catalog Cache HWM: 0 +--------------+--------------------------------------------------+ Shared Work HWM..: 0
Memory Memory Percent Current High Percent Maximum # of
Type Level Pool Total Size WaterMark Max Size Pool(s)
----------- ---------- -------------------- ------- ------------ ------------ ------- ------------ -------
Instance DB2INST1 Monitor 0.03% 416.0K 800.0K 113.04% 368.0K 1
Instance DB2INST1 Other 0.58% 6.8M 6.8M 10.58% 64.8M 1
Database CCCDB Database 1.38% 16.3M 16.4M 6.13% 267.3M 1
Database CCCDB Lock Mgr 3.24% 38.5M 38.5M 100.00% 38.5M 1
Database CCCDB Utility 0.01% 112.0K 176.0K 0.56% 19.5M 1
Database CCCDB Package Cache 4.94% 58.8M 58.8M 1.44% 3.1G 1
Database CCCDB Catalog Cache 0.04% 512.0K 512.0K 0.01% 3.1G 1
Database CCCDB Other 0.00% 0 0 0.00% 11.7M 1
Database CCCDB BufferPool 89.13% 1.0G 1.0G 5.18% 19.1G 5
Application CCCDB Applications 0.59% 7.0M 7.1M 2.20% 320.5M 39
Application CCCDB Appl Control 0.05% 624.0K 624.0K 2.33% 26.2M 39
Quit: q, Help: h Total memory 1.1G
Database Configuration for Database cccdb
Description Parameter Current Value Delayed Value
---------------------------------------------------------------------------------------------------------------
Database configuration release level = 0x0a00
Database release level = 0x0a00
Database territory = US
Database code page = 819
Database code set = ISO8859-1
Database country/region code = 1
Database collating sequence = UNIQUE UNIQUE
Alternate collating sequence (ALT_COLLATE) =
Dynamic SQL Query management (DYN_QUERY_MGMT) = DISABLE DISABLE
Discovery support for this database (DISCOVER_DB) = ENABLE ENABLE
Default query optimization class (DFT_QUERYOPT) = 5 5
Degree of parallelism (DFT_DEGREE) = 1 1
Continue upon arithmetic exceptions (DFT_SQLMATHWARN) = NO NO
Default refresh age (DFT_REFRESH_AGE) = 0 0
Default maintained table types for opt (DFT_MTTB_TYPES) = SYSTEM SYSTEM
Number of frequent values retained (NUM_FREQVALUES) = 10 10
Number of quantiles retained (NUM_QUANTILES) = 20 20
Backup pending = NO
Database is consistent = NO
Rollforward pending = NO
Restore pending = NO
Multi-page file allocation enabled = YES
Log retain for recovery status = NO
User exit for logging status = NO
Data Links Token Expiry Interval (sec) (DL_EXPINT) = 60 60
Data Links Write Token Init Expiry Intvl(DL_WT_IEXPINT) = 60 60
Data Links Number of Copies (DL_NUM_COPIES) = 1 1
Data Links Time after Drop (days) (DL_TIME_DROP) = 1 1
Data Links Token in Uppercase (DL_UPPER) = NO NO
Data Links Token Algorithm (DL_TOKEN) = MAC0 MAC0
Database heap (4KB) (DBHEAP) = 50000 50000
Size of database shared memory (4KB) (DATABASE_MEMORY) = AUTOMATIC(516740) AUTOMATIC(516740)
Catalog cache size (4KB) (CATALOGCACHE_SZ) = (MAXAPPLS*4) (MAXAPPLS*4)
Log buffer size (4KB) (LOGBUFSZ) = 2048 2048
Utilities heap size (4KB) (UTIL_HEAP_SZ) = 5000 5000
Buffer pool size (pages) (BUFFPAGE) = 262144 262144
Extended storage segments size (4KB) (ESTORE_SEG_SZ) = 16000 16000
Number of extended storage segments (NUM_ESTORE_SEGS) = 0 0
Max storage for lock list (4KB) (LOCKLIST) = 8192 8192
Max size of appl. group mem set (4KB) (APPGROUP_MEM_SZ) = 30000 30000
Percent of mem for appl. group heap (GROUPHEAP_RATIO) = 70 70
Max appl. control heap size (4KB) (APP_CTL_HEAP_SZ) = 128 128
Sort heap thres for shared sorts (4KB) (SHEAPTHRES_SHR) = (SHEAPTHRES) (SHEAPTHRES)
Sort list heap (4KB) (SORTHEAP) = 8192 8192
SQL statement heap (4KB) (STMTHEAP) = 4096 4096
Default application heap (4KB) (APPLHEAPSZ) = 2048 2048
Package cache size (4KB) (PCKCACHESZ) = (MAXAPPLS*8) (MAXAPPLS*8)
Statistics heap size (4KB) (STAT_HEAP_SZ) = 4384 4384
Interval for checking deadlock (ms) (DLCHKTIME) = 10000 10000
Percent. of lock lists per application (MAXLOCKS) = 50 50
Lock timeout (sec) (LOCKTIMEOUT) = 30 30
Changed pages threshold (CHNGPGS_THRESH) = 60 60
Number of asynchronous page cleaners (NUM_IOCLEANERS) = 15 15
Number of I/O servers (NUM_IOSERVERS) = 15 15
Index sort flag (INDEXSORT) = YES YES
Sequential detect flag (SEQDETECT) = YES YES
Default prefetch size (pages) (DFT_PREFETCH_SZ) = AUTOMATIC AUTOMATIC
Track modified pages (TRACKMOD) = NO NO
Default number of containers = 1 1
Default tablespace extentsize (pages) (DFT_EXTENT_SZ) = 32 32
Max number of active applications (MAXAPPLS) = 3800 3800
Average number of active applications (AVG_APPLS) = 600 600
Max DB files open per application (MAXFILOP) = 64 64
Log file size (4KB) (LOGFILSIZ) = 7500 7500
Number of primary log files (LOGPRIMARY) = 25 25
Number of secondary log files (LOGSECOND) = 5 5
Changed path to log files (NEWLOGPATH) =
Path to log files = /dbdir/db2inst1/NODE0000/SQL00001/SQLOGDIR/ /dbdir/db2inst1/NODE0000/SQL00001/SQLOGDIR/
Overflow log path (OVERFLOWLOGPATH) =
Mirror log path (MIRRORLOGPATH) =
First active log file =
Block log on disk full (BLK_LOG_DSK_FUL) = NO NO
Percent of max active log space by transaction(MAX_LOG) = 0 0
Num. of active log files for 1 active UOW(NUM_LOG_SPAN) = 0 0
Group commit count (MINCOMMIT) = 1 1
Percent log file reclaimed before soft chckpt (SOFTMAX) = 100 100
Log retain for recovery enabled (LOGRETAIN) = OFF OFF
User exit for logging enabled (USEREXIT) = OFF OFF
HADR database role = STANDARD STANDARD
HADR local host name (HADR_LOCAL_HOST) =
HADR local service name (HADR_LOCAL_SVC) =
HADR remote host name (HADR_REMOTE_HOST) =
HADR remote service name (HADR_REMOTE_SVC) =
HADR instance name of remote server (HADR_REMOTE_INST) =
HADR timeout value (HADR_TIMEOUT) = 120 120
HADR log write synchronization mode (HADR_SYNCMODE) = NEARSYNC NEARSYNC
First log archive method (LOGARCHMETH1) = OFF OFF
Options for logarchmeth1 (LOGARCHOPT1) =
Second log archive method (LOGARCHMETH2) = OFF OFF
Options for logarchmeth2 (LOGARCHOPT2) =
Failover log archive path (FAILARCHPATH) =
Number of log archive retries on error (NUMARCHRETRY) = 5 5
Log archive retry Delay (secs) (ARCHRETRYDELAY) = 20 20
Vendor options (VENDOROPT) =
Auto restart enabled (AUTORESTART) = ON ON
Index re-creation time and redo index build (INDEXREC) = SYSTEM (RESTART) SYSTEM (RESTART)
Log pages during index build (LOGINDEXBUILD) = OFF OFF
Default number of loadrec sessions (DFT_LOADREC_SES) = 1 1
Number of database backups to retain (NUM_DB_BACKUPS) = 12 12
Recovery history retention (days) (REC_HIS_RETENTN) = 366 366
TSM management class (TSM_MGMTCLASS) =
TSM node name (TSM_NODENAME) =
TSM owner (TSM_OWNER) =
TSM password (TSM_PASSWORD) =
Automatic maintenance (AUTO_MAINT) = OFF OFF
Automatic database backup (AUTO_DB_BACKUP) = OFF OFF
Automatic table maintenance (AUTO_TBL_MAINT) = OFF OFF
Automatic runstats (AUTO_RUNSTATS) = OFF OFF
Automatic statistics profiling (AUTO_STATS_PROF) = OFF OFF
Automatic profile updates (AUTO_PROF_UPD) = OFF OFF
Automatic reorganization (AUTO_REORG) = OFF OFF
Database Manager Configuration
Node type = Enterprise Server Edition with local and remote clients
Description Parameter Current Value Delayed Value
---------------------------------------------------------------------------------------------------------------
Database manager configuration release level = 0x0a00
CPU speed (millisec/instruction) (CPUSPEED) = 2.676617e-07 2.676617e-07
Communications bandwidth (MB/sec) (COMM_BANDWIDTH) = 1.000000e+02 1.000000e+02
Max number of concurrently active databases (NUMDB) = 8 8
Data Links support (DATALINKS) = NO NO
Federated Database System Support (FEDERATED) = NO NO
Transaction processor monitor name (TP_MON_NAME) =
Default charge-back account (DFT_ACCOUNT_STR) =
Java Development Kit installation path (JDK_PATH) = /usr/java14 /usr/java14
Diagnostic error capture level (DIAGLEVEL) = 3 3
Notify Level (NOTIFYLEVEL) = 3 3
Diagnostic data directory path (DIAGPATH) = /home/db2inst1/sqllib/db2dump /home/db2inst1/sqllib/db2dump
Default database monitor switches
Buffer pool (DFT_MON_BUFPOOL) = ON ON
Lock (DFT_MON_LOCK) = ON ON
Sort (DFT_MON_SORT) = ON ON
Statement (DFT_MON_STMT) = ON ON
Table (DFT_MON_TABLE) = ON ON
Timestamp (DFT_MON_TIMESTAMP) = ON ON
Unit of work (DFT_MON_UOW) = ON ON
Monitor health of instance and databases (HEALTH_MON) = OFF OFF
SYSADM group name (SYSADM_GROUP) = DB2IADM1 DB2IADM1
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 UNFENCED
Server List of GSS Plugins (SRVCON_GSSPLUGIN_LIST) =
Server Userid-Password Plugin (SRVCON_PW_PLUGIN) =
Server Connection Authentication (SRVCON_AUTH) = NOT_SPECIFIED NOT_SPECIFIED
Database manager authentication (AUTHENTICATION) = SERVER SERVER
Cataloging allowed without authority (CATALOG_NOAUTH) = NO NO
Trust all clients (TRUST_ALLCLNTS) = YES YES
Trusted client authentication (TRUST_CLNTAUTH) = CLIENT CLIENT
Bypass federated authentication (FED_NOAUTH) = NO NO
Default database path (DFTDBPATH) = /home/db2inst1 /home/db2inst1
Database monitor heap size (4KB) (MON_HEAP_SZ) = 90 90
Java Virtual Machine heap size (4KB) (JAVA_HEAP_SZ) = 2048 2048
Audit buffer size (4KB) (AUDIT_BUF_SZ) = 0 0
Size of instance shared memory (4KB) (INSTANCE_MEMORY) = AUTOMATIC(19983) AUTOMATIC(19983)
Backup buffer default size (4KB) (BACKBUFSZ) = 1024 1024
Restore buffer default size (4KB) (RESTBUFSZ) = 1024 1024
Sort heap threshold (4KB) (SHEAPTHRES) = 20000 20000
Directory cache support (DIR_CACHE) = YES YES
Application support layer heap size (4KB) (ASLHEAPSZ) = 15 15
Max requester I/O block size (bytes) (RQRIOBLK) = 32767 32767
Query heap size (4KB) (QUERY_HEAP_SZ) = 5120 5120
Workload impact by throttled utilities(UTIL_IMPACT_LIM) = 10 10
Priority of agents (AGENTPRI) = SYSTEM SYSTEM
Max number of existing agents (MAXAGENTS) = 2801 2800
Agent pool size (NUM_POOLAGENTS) = 1601 1600
Initial number of agents in pool (NUM_INITAGENTS) = 0 0
Max number of coordinating agents (MAX_COORDAGENTS) = 2800 (MAXAGENTS - NUM_INITAGENT
Max no. of concurrent coordinating agents (MAXCAGENTS) = 2800 MAX_COORDAGENTS
Max number of client connections (MAX_CONNECTIONS) = 2800 MAX_COORDAGENTS
Keep fenced process (KEEPFENCED) = YES YES
Number of pooled fenced processes (FENCED_POOL) = MAX_COORDAGENTS MAX_COORDAGENTS
Initial number of fenced processes (NUM_INITFENCED) = 0 0
Index re-creation time and redo index build (INDEXREC) = RESTART RESTART
Transaction manager database name (TM_DATABASE) = 1ST_CONN 1ST_CONN
Transaction resync interval (sec) (RESYNC_INTERVAL) = 180 180
SPM name (SPM_NAME) = gmqz5 gmqz5
SPM log size (SPM_LOG_FILE_SZ) = 256 256
SPM resync agent limit (SPM_MAX_RESYNC) = 20 20
SPM log path (SPM_LOG_PATH) =
TCP/IP Service name (SVCENAME) =
Discovery mode (DISCOVER) = SEARCH SEARCH
Discover server instance (DISCOVER_INST) = ENABLE ENABLE
Maximum query degree of parallelism (MAX_QUERYDEGREE) = ANY ANY
Enable intra-partition parallelism (INTRA_PARALLEL) = NO NO
No. of int. communication buffers(4KB)(FCM_NUM_BUFFERS) = 4096 4096
Number of FCM request blocks (FCM_NUM_RQB) = AUTOMATIC(2048) AUTOMATIC(2048)
Number of FCM connection entries (FCM_NUM_CONNECT) = AUTOMATIC(-1) AUTOMATIC(-1)
Number of FCM message anchors (FCM_NUM_ANCHORS) = AUTOMATIC(-1) AUTOMATIC(-1)
Node connection elapse time (sec) (CONN_ELAPSE) = 10 10
Max number of node connection retries (MAX_CONNRETRIES) = 5 5
Max time difference between nodes (min) (MAX_TIME_DIFF) = 60 60
db2start/db2stop timeout (min) (START_STOP_TIME) = 10 10
db2mtrk -d -i -v
Tracking Memory on: 2013/05/12 at 23:28:17
Memory for instance
Database Monitor Heap is of size 425984 bytes
Other Memory is of size 7192576 bytes
Total: 7618560 bytes
Memory for database: CCCDB
Backup/Restore/Util Heap is of size 114688 bytes
Package Cache is of size 61718528 bytes
Catalog Cache Heap is of size 524288 bytes
Buffer Pool Heap is of size 1108852736 bytes
Buffer Pool Heap is of size 1277952 bytes
Buffer Pool Heap is of size 1015808 bytes
Buffer Pool Heap is of size 884736 bytes
Buffer Pool Heap is of size 819200 bytes
Lock Manager Heap is of size 40468480 bytes
Database Heap is of size 17186816 bytes
Other Memory is of size 0 bytes
Total: 1232863232 bytes
收起