最近一段时间,系统出现保存数据,打开模块卡,慢的现象,数据库是9.1版本,具体配置信息如下,
Database Configuration for Database bl_prod
Database configuration release level = 0x0b00
Database release level = 0x0b00
Database territory = CN
Database code page = 1386
Database code set = GBK
Database country/region code = 86
Database collating sequence = UNIQUE
Alternate collating sequence (ALT_COLLATE) =
Database page size = 4096
Dynamic SQL Query management (DYN_QUERY_MGMT) = DISABLE
Discovery support for this database (DISCOVER_DB) = DISABLE
Restrict access = NO
Default query optimization class (DFT_QUERYOPT) = 5
Degree of parallelism (DFT_DEGREE) = 1
Continue upon arithmetic exceptions (DFT_SQLMATHWARN) = NO
Default refresh age (DFT_REFRESH_AGE) = 0
Default maintained table types for opt (DFT_MTTB_TYPES) = SYSTEM
Number of frequent values retained (NUM_FREQVALUES) = 10
Number of quantiles retained (NUM_QUANTILES) = 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 = RECOVERY
User exit for logging status = NO
Self tuning memory (SELF_TUNING_MEM) = OFF
Size of database shared memory (4KB) (DATABASE_MEMORY) = COMPUTED
Database memory threshold (DB_MEM_THRESH) = 10
Max storage for lock list (4KB) (LOCKLIST) = 204800
Percent. of lock lists per application (MAXLOCKS) = 90
Package cache size (4KB) (PCKCACHESZ) = 524288
Sort heap thres for shared sorts (4KB) (SHEAPTHRES_SHR) = 524288
Sort list heap (4KB) (SORTHEAP) = 262144
Database heap (4KB) (DBHEAP) = 64000
Catalog cache size (4KB) (CATALOGCACHE_SZ) = 4096
Log buffer size (4KB) (LOGBUFSZ) = 1024
Utilities heap size (4KB) (UTIL_HEAP_SZ) = 12800
Buffer pool size (pages) (BUFFPAGE) = 2097152
Max size of appl. group mem set (4KB) (APPGROUP_MEM_SZ) = 30000
Percent of mem for appl. group heap (GROUPHEAP_RATIO) = 70
Max appl. control heap size (4KB) (APP_CTL_HEAP_SZ) = 3840
SQL statement heap (4KB) (STMTHEAP) = 51200
Default application heap (4KB) (APPLHEAPSZ) = 2048
Statistics heap size (4KB) (STAT_HEAP_SZ) = 51200
Interval for checking deadlock (ms) (DLCHKTIME) = 10000
Lock timeout (sec) (LOCKTIMEOUT) = 30
Changed pages threshold (CHNGPGS_THRESH) = 5
Number of asynchronous page cleaners (NUM_IOCLEANERS) = 16
Number of I/O servers (NUM_IOSERVERS) = 32
Index sort flag (INDEXSORT) = YES
Sequential detect flag (SEQDETECT) = YES
Default prefetch size (pages) (DFT_PREFETCH_SZ) = AUTOMATIC
Track modified pages (TRACKMOD) = ON
Default number of containers = 1
Default tablespace extentsize (pages) (DFT_EXTENT_SZ) = 32
Max number of active applications (MAXAPPLS) = 8192
Average number of active applications (AVG_APPLS) = AUTOMATIC
Max DB files open per application (MAXFILOP) = 180
Log file size (4KB) (LOGFILSIZ) = 32000
Number of primary log files (LOGPRIMARY) = 30
Number of secondary log files (LOGSECOND) = 225
Changed path to log files (NEWLOGPATH) =
Path to log files = /database/db2inst1/db2inst1/NODE0000/SQL00005/SQLOGDIR/
Overflow log path (OVERFLOWLOGPATH) =
Mirror log path (MIRRORLOGPATH) =
First active log file = S0117094.LOG
Block log on disk full (BLK_LOG_DSK_FUL) = NO
Percent max primary log space by transaction (MAX_LOG) = 55
Num. of active log files for 1 active UOW(NUM_LOG_SPAN) = 0
Group commit count (MINCOMMIT) = 1
Percent log file reclaimed before soft chckpt (SOFTMAX) = 100
Log retain for recovery enabled (LOGRETAIN) = RECOVERY
User exit for logging enabled (USEREXIT) = OFF
HADR database role = STANDARD
HADR local host name (HADR_LOCAL_HOST) = 172.20.30.117
HADR local service name (HADR_LOCAL_SVC) = 70005
HADR remote host name (HADR_REMOTE_HOST) = 172.20.30.72
HADR remote service name (HADR_REMOTE_SVC) = 70005
HADR instance name of remote server (HADR_REMOTE_INST) = db2inst1
HADR timeout value (HADR_TIMEOUT) = 180
HADR log write synchronization mode (HADR_SYNCMODE) = SYNC
First log archive method (LOGARCHMETH1) = LOGRETAIN
Options for logarchmeth1 (LOGARCHOPT1) =
Second log archive method (LOGARCHMETH2) = OFF
Options for logarchmeth2 (LOGARCHOPT2) =
Failover log archive path (FAILARCHPATH) =
Number of log archive retries on error (NUMARCHRETRY) = 5
Log archive retry Delay (secs) (ARCHRETRYDELAY) = 20
Vendor options (VENDOROPT) =
Auto restart enabled (AUTORESTART) = ON
Index re-creation time and redo index build (INDEXREC) = SYSTEM (RESTART)
Log pages during index build (LOGINDEXBUILD) = ON
Default number of loadrec sessions (DFT_LOADREC_SES) = 1
Number of database backups to retain (NUM_DB_BACKUPS) = 12
Recovery history retention (days) (REC_HIS_RETENTN) = 366
TSM management class (TSM_MGMTCLASS) =
TSM node name (TSM_NODENAME) =
TSM owner (TSM_OWNER) =
TSM password (TSM_PASSWORD) =
Automatic maintenance (AUTO_MAINT) = ON
Automatic database backup (AUTO_DB_BACKUP) = OFF
Automatic table maintenance (AUTO_TBL_MAINT) = ON
Automatic runstats (AUTO_RUNSTATS) = ON
Automatic statistics profiling (AUTO_STATS_PROF) = OFF
Automatic profile updates (AUTO_PROF_UPD) = OFF
Automatic reorganization (AUTO_REORG) = ON
查看db2diag文件信息,经常出现有如下信息:
2017-06-25-15.16.11.985724+480 I30548738E415 LEVEL: Info
PID : 12277 TID : 139645058795280PROC : db2acd 0
INSTANCE: db2inst1 NODE : 000
APPID : *LOCAL.db2inst1.170625071617
FUNCTION: DB2 UDB, Automatic Table Maintenance, AtmTable::pull_engine, probe:202
MESSAGE : ZRC=0x8604000B=-2046558197=SQLD_NOENT "OBJECT DOES NOT EXIST"
DIA8412C A table "" could not be found.
2017-06-25-15.16.12.130717+480 I30629371E375 LEVEL: Info
PID : 12277 TID : 139645058795280PROC : db2acd 0
INSTANCE: db2inst1 NODE : 000
APPID : *LOCAL.db2inst1.170625071618
FUNCTION: DB2 UDB, Automatic Table Maintenance, AtmTable::iter_action, probe:100
DATA #1 : <preformatted>
AutoStats: SYSIBM .SYSPARTITIONMAPS: TCB not in memory.
2017-06-25-15.16.12.135545+480 I30632861E402 LEVEL: Info
PID : 12277 TID : 139645058795280PROC : db2acd 0
INSTANCE: db2inst1 NODE : 000
APPID : *LOCAL.db2inst1.170625071618
FUNCTION: DB2 UDB, Automatic Table Maintenance, AtmTable::iter_action, probe:1000
DATA #1 : <preformatted>
AutoStats: SYSIBM .SYSHIERARCHIES: New scheduling: to_wait = 150, last_wait = 336
2017-06-25-15.36.11.641203+480 I30714337E382 LEVEL: Info (OS)
PID : 12277 TID : 139645474039568
FUNCTION: DB2 Common, OSSe, ossGetFileInfo, probe:30
MESSAGE : ECF=0x90000037 A directory component in the path doesn't exist
CALLED : OS, -, lstat OSERR: ENOENT (2)
ARG #1 : String, 40 bytes
/home/db2inst1/sqllib/cfg/indicators.xml
也没有error的错误信息,请问这是哪里的问题呢
FUNCTION: DB2 UDB, Automatic Table Maintenance, AtmTable::iter_action, probe:100
DATA #1 : <preformatted>
AutoStats: HR .MONTHAUDITLIST: TCB not in memory.
2017-06-26-03.46.21.854783+480 I47700568E401 LEVEL: Info
PID : 12277 TID : 139645079774992PROC : db2acd 0
INSTANCE: db2inst1 NODE : 000
APPID : *LOCAL.db2inst1.170625194621
FUNCTION: DB2 UDB, Automatic Table Maintenance, AtmTable::iter_action, probe:1000
DATA #1 : <preformatted>
AutoStats: HR .MONTHAUDITLIST: New scheduling: to_wait = 12, last_wait = 335
2017-06-26-03.46.21.854903+480 I47700970E372 LEVEL: Info
PID : 12277 TID : 139645079774992PROC : db2acd 0
INSTANCE: db2inst1 NODE : 000
APPID : *LOCAL.db2inst1.170625194621
FUNCTION: DB2 UDB, Automatic Table Maintenance, AtmTable::iter_action, probe:100
DATA #1 : <preformatted>
AutoStats: HR .OVERWORKSHEET: TCB not in memory.
2017-06-26-03.46.21.855524+480 I47701343E400 LEVEL: Info
PID : 12277 TID : 139645079774992PROC : db2acd 0
INSTANCE: db2inst1 NODE : 000
APPID : *LOCAL.db2inst1.170625194621
FUNCTION: DB2 UDB, Automatic Table Maintenance, AtmTable::iter_action, probe:1000
DATA #1 : <preformatted>
AutoStats: HR .OVERWORKSHEET: New scheduling: to_wait = 12, last_wait = 336
2017-06-26-03.46.21.855627+480 I47701744E376 LEVEL: Info
PID : 12277 TID : 139645079774992PROC : db2acd 0
INSTANCE: db2inst1 NODE : 000
APPID : *LOCAL.db2inst1.170625194621
FUNCTION: DB2 UDB, Automatic Table Maintenance, AtmTable::iter_action, probe:100
DATA #1 : <preformatted>
AutoStats: HR .OVERWORKSHEETITEM: TCB not in memory.