最近将db2 v9.1升级到 v9.7,aix5 -->aix7.1。升级后发现db2sysc 进程的pgsp不断增加,至最大2,3G,然后数据库无法连接,连接报错:
SQL1224N The database manager is not able to accept new requests, has
terminated all requests in progress, or has terminated the specified request
because of an error or a forced interrupt. SQLSTATE=55032
数据库自动宕机。
Syscall 135.9K Writech 80531
CPU User% Kern% Wait% Idle% Physc Entc% Reads 141 Rawin 0
Total 19.5 0.7 2.3 77.4 1.60 31.99 Writes 15 Ttyout 664
Forks 0 Igets 0
Network BPS I-Pkts O-Pkts B-In B-Out Execs 0 Namei 5
Total 630K 563.5 532.5 192K 438K Runqueue 2.50 Dirblk 0
Waitqueue 0.0
Disk Busy% BPS TPS B-Read B-Writ MEMORY
Total 5.4 4.40M 148.5 4.33M 78.0K PAGING Real,MB 98304
Faults 206 % Comp 49
FileSystem BPS TPS B-Read B-Writ Steals 0 % Noncomp 31
Total 4.39M 155.0 4.32M 78.0K PgspIn 0 % Client 31
PgspOut 0
Name PID CPU% PgSp Owner PageIn 1103 PAGING SPACE
db2sysc 6029510 19.8 602M openeap PageOut 19 Size,MB 65536
topas 20644018 0.0 11.4M root Sios 1119 % Used 0
topas 9175238 0.0 15.1M root % Free 100
java 8978524 0.0 71.4M root NFS (calls/sec)
gil 3670128 0.0 960K root SerV2 0 WPAR Activ 0
getty 7995400 0.0 576K root CliV2 0 WPAR Total 0
vtiol 786456 0.0 2.19M root SerV3 0 Press: "h"-help
java 8454162 0.0 57.6M pconsole CliV3 0 "q"-quit
db2fmp 9240692 0.0 8.70M openeap
hostmibd 5963984 0.0 1.24M root
snmpmibd 6488278 0.0 1.03M root
db2fmd 20054116 0.0 2.05M dasusr1
rpc.lock 6946846 0.0 1.19M root
clcomd 7536872 0.0 1.50M root
snmpdv3n 6160582 0.0 976K root
slp_srvr 6094934 0.0 440K root
db2bp 14811152 0.0 2.75M openeap
db2bp 9109578 0.0 3.87M openeap
reaffin 589842 0.0 640K root
netm 3604590 0.0 448K root
********************************
ulimit -a
time(seconds) unlimited
file(blocks) unlimited
data(kbytes) unlimited
stack(kbytes) 4194304
memory(kbytes) unlimited
coredump(blocks) unlimited
nofiles(descriptors) unlimited
threads(per process) unlimited
processes(per user) unlimited
***************
.nfy日志:
2014-07-10-15.03.59.922423 Instance:openeap Node:000
PID:16777378(db2wdog 0) TID:258 Appid:none
base sys utilities sqleWatchDog Probe:20
ADM0503C An unexpected internal processing error has occurred. All DB2
processes associated with this instance have been shutdown. Diagnostic
information has been recorded. Contact IBM Support for further assistance.
收起