C/S应用系统保存数据卡,如何看数据库哪里存在问题

最近一段时间,系统出现保存数据,打开模块卡,慢的现象,数据库是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的错误信息,请问这是哪里的问题呢

参与15

3同行回答

fengzhencaifengzhencai数据库运维工程师亚飞
FUNCTION: DB2 UDB, Automatic Table Maintenance, AtmTable::iter_action, probe:100DATA #1 : <preformatted>AutoStats: HR .MONTHAUDITLIST: TCB not in memory.2017-06-26-03.46.21.854783+480 I47700568E401 LEVEL: InfoPID : 12277 ...显示全部

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.

收起
互联网服务 · 2017-06-26
浏览3847
sdnx666sdnx666联盟成员系统运维工程师蚂蚁
HADR remote host name (HADR_REMOTE_HOST) = 172.20.30.72HADR remote service name (HADR_REMOTE_SVC) = 70005显示全部

HADR remote host name (HADR_REMOTE_HOST) = 172.20.30.72

HADR remote service name (HADR_REMOTE_SVC) = 70005

收起
互联网服务 · 2017-06-26
浏览4159
JhonJhon技术经理小学生
你可以做nmon看下进程使用情况显示全部

你可以做nmon看下进程使用情况

收起
IT咨询服务 · 2017-06-26
浏览4118

提问者

fengzhencai
数据库运维工程师亚飞

相关问题

相关资料

相关文章

问题状态

  • 发布时间:2017-06-26
  • 关注会员:3 人
  • 问题浏览:6471
  • 最近回答:2017-06-26
  • X社区推广