db2 v9.7 升级后宕机故障
最近将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.
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.
23 同行回答
打了9a补丁，介质目前为止4天了，为发生故障，应该说基本解决了。谢谢！ 收起
昨天晚上打了补丁，不知道是否有用。另外v9.7 db2sysc 的pgsp一直在增长是否正常？现在都700M 收起
直接恢复的。 收起
2014-07-11-05.24.23.800302+480 I7958961A1118 LEVEL: Severe
PID : 22216934 TID : 1054 PROC : db2acd 0
INSTANCE: openeap NODE : 000 DB : KONKA
APPID : *LOCAL.openeap.140710212422
EDUID : 1054 EDUNAME: db2acd 0
FUNCTION: DB2 UDB, global services, sqlzAssertFailed, probe:10
DATA #1 : String, 145 bytes
NON-FATAL ASSERTION FAILED!!!
ASSERTION EXPRESSION: Invalid block eye-catcher (0x0) found at:
SOURCE FILENAME: atmStatsTable.C
LINE NUMBER: 6296
CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol)
[0] 0x09000000019843F4 pdLog + 0xA8
[1] 0x0900000002246414 sqlzAssertFailedValist + 0x1B0
[2] 0x090000000091D478 ossAssertFailureAction + 0x138
[3] 0x090000000094CC38 _ossMemAllocCheck + 0x718
[4] 0x090000000094CD18 _ossMemFree + 0x58
[5] 0x090000000BD26C74 __dt__9AtmServerFv + 0x94
[6] 0x090000000BD15C84 process_tables__3AtmFv + 0x1344
[7] 0x090000000BD1312C iter__3AtmFv + 0x2AC
[8] 0x090000000BD1117C run__3AtmFPCc + 0x1BC
[9] 0x090000000BD1027C db2HmonEvalStats + 0x2BC
2014-07-11-05.24.23.800574+480 I7960080A1109 LEVEL: Severe
PID : 22216934 TID : 1054 PROC : db2acd 0
INSTANCE: openeap NODE : 000 DB : KONKA
APPID : *LOCAL.openeap.140710212422
EDUID : 1054 EDUNAME: db2acd 0
FUNCTION: DB2 UDB, global services, sqlzAssertFailed, probe:10
DATA #1 : String, 136 bytes
NON-FATAL ASSERTION FAILED!!!
ASSERTION EXPRESSION: Invalid pad type (0x0) found at:
SOURCE FILENAME: atmStatsTable.C
LINE NUMBER: 6296
CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol)
[0] 0x09000000019843F4 pdLog + 0xA8
[1] 0x0900000002246414 sqlzAssertFailedValist + 0x1B0
[2] 0x090000000091D478 ossAssertFailureAction + 0x138
[3] 0x090000000094CBE0 _ossMemAllocCheck + 0x6C0
[4] 0x090000000094CD18 _ossMemFree + 0x58
[5] 0x090000000BD26C74 __dt__9AtmServerFv + 0x94
[6] 0x090000000BD15C84 process_tables__3AtmFv + 0x1344
[7] 0x090000000BD1312C iter__3AtmFv + 0x2AC
[8] 0x090000000BD1117C run__3AtmFPCc + 0x1BC
[9] 0x090000000BD1027C db2HmonEvalStats + 0x2BC
2014-07-11-05.24.23.810134+480 E7961190A398 LEVEL: Error
PID : 33619986 TID : 258 PROC : db2wdog 0
INSTANCE: openeap NODE : 000
EDUID : 258 EDUNAME: db2wdog 0
FUNCTION: DB2 UDB, base sys utilities, sqleChildCrashHandler, probe:5469
DATA #1 :
A non-EDU child crashed Process id: 22216934, OSS term code: 0x102, signal: 9
2014-07-11-05.24.23.810355+480 E7961589A464 LEVEL: Warning
PID : 33357830 TID : 258 PROC : db2sysc 0
INSTANCE: openeap NODE : 000
EDUID : 258 EDUNAME: db2sysc 0
FUNCTION: DB2 UDB, routine_infrastructure, sqlerReturnFmpToPool, probe:999
DATA #1 : String, 34 bytes
Removing FMP from pool FMP handle:
DATA #2 : sqlerFmpHandle, PD_SQLER_TYPE_FMP_HANDLE, 16 bytes
fmpPid: 0 pFmpEntry: 0x078000000059f658 收起
PID : 22216934 TID : 1054 PROC : db2acd 0
INSTANCE: openeap NODE : 000 DB : KONKA
APPID : *LOCAL.openeap.140710212422
EDUID : 1054 EDUNAME: db2acd 0
FUNCTION: DB2 UDB, global services, sqlzAssertFailed, probe:10
DATA #1 : String, 145 bytes
NON-FATAL ASSERTION FAILED!!!
ASSERTION EXPRESSION: Invalid block eye-catcher (0x0) found at:
SOURCE FILENAME: atmStatsTable.C
LINE NUMBER: 6296
CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol)
[0] 0x09000000019843F4 pdLog + 0xA8
[1] 0x0900000002246414 sqlzAssertFailedValist + 0x1B0
[2] 0x090000000091D478 ossAssertFailureAction + 0x138
[3] 0x090000000094CC38 _ossMemAllocCheck + 0x718
[4] 0x090000000094CD18 _ossMemFree + 0x58
[5] 0x090000000BD26C74 __dt__9AtmServerFv + 0x94
[6] 0x090000000BD15C84 process_tables__3AtmFv + 0x1344
[7] 0x090000000BD1312C iter__3AtmFv + 0x2AC
[8] 0x090000000BD1117C run__3AtmFPCc + 0x1BC
[9] 0x090000000BD1027C db2HmonEvalStats + 0x2BC
2014-07-11-05.24.23.800574+480 I7960080A1109 LEVEL: Severe
PID : 22216934 TID : 1054 PROC : db2acd 0
INSTANCE: openeap NODE : 000 DB : KONKA
APPID : *LOCAL.openeap.140710212422
EDUID : 1054 EDUNAME: db2acd 0
FUNCTION: DB2 UDB, global services, sqlzAssertFailed, probe:10
DATA #1 : String, 136 bytes
NON-FATAL ASSERTION FAILED!!!
ASSERTION EXPRESSION: Invalid pad type (0x0) found at:
SOURCE FILENAME: atmStatsTable.C
LINE NUMBER: 6296
CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol)
[0] 0x09000000019843F4 pdLog + 0xA8
[1] 0x0900000002246414 sqlzAssertFailedValist + 0x1B0
[2] 0x090000000091D478 ossAssertFailureAction + 0x138
[3] 0x090000000094CBE0 _ossMemAllocCheck + 0x6C0
[4] 0x090000000094CD18 _ossMemFree + 0x58
[5] 0x090000000BD26C74 __dt__9AtmServerFv + 0x94
[6] 0x090000000BD15C84 process_tables__3AtmFv + 0x1344
[7] 0x090000000BD1312C iter__3AtmFv + 0x2AC
[8] 0x090000000BD1117C run__3AtmFPCc + 0x1BC
[9] 0x090000000BD1027C db2HmonEvalStats + 0x2BC
2014-07-11-05.24.23.810134+480 E7961190A398 LEVEL: Error
PID : 33619986 TID : 258 PROC : db2wdog 0
INSTANCE: openeap NODE : 000
EDUID : 258 EDUNAME: db2wdog 0
FUNCTION: DB2 UDB, base sys utilities, sqleChildCrashHandler, probe:5469
DATA #1 :
A non-EDU child crashed Process id: 22216934, OSS term code: 0x102, signal: 9
2014-07-11-05.24.23.810355+480 E7961589A464 LEVEL: Warning
PID : 33357830 TID : 258 PROC : db2sysc 0
INSTANCE: openeap NODE : 000
EDUID : 258 EDUNAME: db2sysc 0
FUNCTION: DB2 UDB, routine_infrastructure, sqlerReturnFmpToPool, probe:999
DATA #1 : String, 34 bytes
Removing FMP from pool FMP handle:
DATA #2 : sqlerFmpHandle, PD_SQLER_TYPE_FMP_HANDLE, 16 bytes
fmpPid: 0 pFmpEntry: 0x078000000059f658 收起
(Static functions may not be resolved correctly, as they are resolved to the nearest symbol)
啥原因啊？ 收起
啥原因啊？ 收起
2014-07-10-16.48.04.118609+480 I7626782A1698 LEVEL: Severe
PID : 6029510 TID : 98178 PROC : db2sysc 0
INSTANCE: openeap NODE : 000 DB :
APPHDL : 0-2053 APPID: *LOCAL.openeap.140710084713
AUTHID : OPENEAP
EDUID : 98178 EDUNAME: db2agent (instance) 0
FUNCTION: DB2 UDB, SQO Latch Tracing, sqlo_xlatch::releaseConflict, probe:10
DATA #1 : String, 27 bytes
unlocking an unlatched lock
DATA #2 : Pointer, 8 bytes
0x0a000207f9fb78e8
DATA #3 : String, 123 bytes
{
lock = { 0x00000000 [ unlocked ] }
identity = SQLQG_F2PC_T::federatedProcessingSnapshotLatch (144)
}
DATA #4 : Hexdump, 8 bytes
0x0A000207F9FB78E8 : 0000 0000 0090 0000 ........
CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol)
[0] 0x09000000019BC7D4 pdLog + 0xE0
[1] 0x0900000001DD75F0 pdLog@glue413 + 0x12C
[2] 0x0900000002005B60 sqloSpinLockReleaseConflict + 0x5C
[3] 0x09000000017E3248 sqloSpinLockReleaseConflict@glue73 + 0x78
[4] 0x0900000003308608 sqlpm_write_locks_indoubt_tran__FP16sqeLocalDatabaseP8sqeAgentP19sqm_snapshot_bufferUiPUiT5P16sqlm_header_i
nfo + 0x64C
[5] 0x0900000003306D14 @92@sqm_snap_db_locks__FPC16sqm_agent_entityRC8sqlo_gmtP19sqm_snapshot_bufferP16sqeLocalDatabaseP14sqlm_col
lectedPCcCUiPP15sqlm + 0x564
[6] 0x09000000011796D0 sqlmonssagnt__FUi13sqm_entity_idP6sqlmaiT1PvP14sqlm_collectedUsT7P5sqlca + 0xD2C
[7] 0x0900000001D9BEBC sqlmonssbackend__FP12SQLE_DB2RA_T + 0x228
[8] 0x090000000205612C sqlesrvr__FP14db2UCinterface + 0x738
[9] 0x09000000017CAB68 sqleMappingFnServer__FP5sqldaP5sqlca + 0x1D0
2014-07-10-16.48.04.129641+480 E7628481A942 LEVEL: Critical
PID : 6029510 TID : 98178 PROC : db2sysc 0
INSTANCE: openeap NODE : 000 DB :
APPHDL : 0-2053 APPID: *LOCAL.openeap.140710084713
AUTHID : OPENEAP
EDUID : 98178 EDUNAME: db2agent (instance) 0
FUNCTION: DB2 UDB, base sys utilities, sqle_panic, probe:10
MESSAGE : ADM14001C An unexpected and critical error has occurred: "Panic".
The instance may have been shutdown as a result. "Automatic" FODC
(First Occurrence Data Capture) has been invoked and diagnostic
information has been recorded in directory
...skipping...
FUNCTION: DB2 UDB, bsu security, sqlexLogPluginMessage, probe:20
DATA #1 : String with size, 66 bytes
Password validation for user spmread failed with rc = -2146500502
2014-07-10-15.59.59.441283+480 I7612374A438 LEVEL: Warning
PID : 6029510 TID : 71450 PROC : db2sysc 0
INSTANCE: openeap NODE : 000 DB : KONKA
APPHDL : 0-1215
EDUID : 71450 EDUNAME: db2agent (KONKA) 0
FUNCTION: DB2 UDB, bsu security, sqlexSlsSystemAuthenticate, probe:150
MESSAGE : application id:
DATA #1 : String with size, 31 bytes
172.40.1.111.41364.140710080050
2014-07-10-15.59.59.443259+480 I7612813A439 LEVEL: Warning
PID : 6029510 TID : 71450 PROC : db2sysc 0
INSTANCE: openeap NODE : 000 DB : KONKA
APPHDL : 0-1216
EDUID : 71450 EDUNAME: db2agent (KONKA) 0
FUNCTION: DB2 UDB, bsu security, sqlexLogPluginMessage, probe:20
DATA #1 : String with size, 66 bytes
Password validation for user spmread failed with rc = -2146500502
2014-07-10-15.59.59.443368+480 I7613253A438 LEVEL: Warning
PID : 6029510 TID : 71450 PROC : db2sysc 0
INSTANCE: openeap NODE : 000 DB : KONKA
APPHDL : 0-1216
EDUID : 71450 EDUNAME: db2agent (KONKA) 0
FUNCTION: DB2 UDB, bsu security, sqlexSlsSystemAuthenticate, probe:150
MESSAGE : application id:
DATA #1 : String with size, 31 bytes
172.40.1.111.41365.140710080051
2014-07-10-15.59.59.445446+480 I7613692A439 LEVEL: Warning
PID : 6029510 TID : 71450 PROC : db2sysc 0
INSTANCE: openeap NODE : 000 DB : KONKA
APPHDL : 0-1217
EDUID : 71450 EDUNAME: db2agent (KONKA) 0
FUNCTION: DB2 UDB, bsu security, sqlexLogPluginMessage, probe:20
DATA #1 : String with size, 66 bytes
Password validation for user spmread failed with rc = -2146500502
2014-07-10-15.59.59.445546+480 I7614132A438 LEVEL: Warning
PID : 6029510 TID : 71450 PROC : db2sysc 0
INSTANCE: openeap NODE : 000 DB : KONKA
APPHDL : 0-1217
EDUID : 71450 EDUNAME: db2agent (KONKA) 0
FUNCTION: DB2 UDB, bsu security, sqlexSlsSystemAuthenticate, probe:150
MESSAGE : application id:
DATA #1 : String with size, 31 bytes
172.40.1.111.41366.140710080052
2014-07-10-15.59.59.449489+480 I7614571A439 LEVEL: Warning
PID : 6029510 TID : 71450 PROC : db2sysc 0
INSTANCE: openeap NODE : 000 DB : KONKA
APPHDL : 0-1218
EDUID : 71450 EDUNAME: db2agent (KONKA) 0
FUNCTION: DB2 UDB, bsu security, sqlexLogPluginMessage, probe:20
DATA #1 : String with size, 66 bytes
Password validation for user spmread failed with rc = -2146500502
2014-07-10-15.59.59.449589+480 I7615011A438 LEVEL: Warning
PID : 6029510 TID : 71450 PROC : db2sysc 0
INSTANCE: openeap NODE : 000 DB : KONKA
APPHDL : 0-1218
EDUID : 71450 EDUNAME: db2agent (KONKA) 0
FUNCTION: DB2 UDB, bsu security, sqlexSlsSystemAuthenticate, probe:150
MESSAGE : application id:
DATA #1 : String with size, 31 bytes
172.40.1.111.41367.140710080053
2014-07-10-15.59.59.452002+480 I7615450A439 LEVEL: Warning
PID : 6029510 TID : 71450 PROC : db2sysc 0
INSTANCE: openeap NODE : 000 DB : KONKA
APPHDL : 0-1219
EDUID : 71450 EDUNAME: db2agent (KONKA) 0
FUNCTION: DB2 UDB, bsu security, sqlexLogPluginMessage, probe:20
DATA #1 : String with size, 66 bytes
Password validation for user spmread failed with rc = -2146500502
2014-07-10-15.59.59.452100+480 I7615890A438 LEVEL: Warning
PID : 6029510 TID : 71450 PROC : db2sysc 0
INSTANCE: openeap NODE : 000 DB : KONKA
APPHDL : 0-1219
EDUID : 71450 EDUNAME: db2agent (KONKA) 0
FUNCTION: DB2 UDB, bsu security, sqlexSlsSystemAuthenticate, probe:150
MESSAGE : application id:
DATA #1 : String with size, 31 bytes
172.40.1.111.41368.140710080054
2014-07-10-15.59.59.453944+480 I7616329A439 LEVEL: Warning
PID : 6029510 TID : 71450 PROC : db2sysc 0
INSTANCE: openeap NODE : 000 DB : KONKA
APPHDL : 0-1220
EDUID : 71450 EDUNAME: db2agent (KONKA) 0
FUNCTION: DB2 UDB, bsu security, sqlexLogPluginMessage, probe:20
DATA #1 : String with size, 66 bytes
Password validation for user spmread failed with rc = -2146500502
2014-07-10-15.59.59.454041+480 I7616769A438 LEVEL: Warning
PID : 6029510 TID : 71450 PROC : db2sysc 0
INSTANCE: openeap NODE : 000 DB : KONKA
APPHDL : 0-1220
EDUID : 71450 EDUNAME: db2agent (KONKA) 0
FUNCTION: DB2 UDB, bsu security, sqlexSlsSystemAuthenticate, probe:150
MESSAGE : application id:
DATA #1 : String with size, 31 bytes
172.40.1.111.41369.140710080055
2014-07-10-15.59.59.457310+480 I7617208A439 LEVEL: Warning
PID : 6029510 TID : 71450 PROC : db2sysc 0
INSTANCE: openeap NODE : 000 DB : KONKA
APPHDL : 0-1221
EDUID : 71450 EDUNAME: db2agent (KONKA) 0
FUNCTION: DB2 UDB, bsu security, sqlexLogPluginMessage, probe:20
DATA #1 : String with size, 66 bytes
Password validation for user spmread failed with rc = -2146500502
2014-07-10-15.59.59.457408+480 I7617648A438 LEVEL: Warning
PID : 6029510 TID : 71450 PROC : db2sysc 0
INSTANCE: openeap NODE : 000 DB : KONKA
APPHDL : 0-1221
EDUID : 71450 EDUNAME: db2agent (KONKA) 0
FUNCTION: DB2 UDB, bsu security, sqlexSlsSystemAuthenticate, probe:150
MESSAGE : application id:
DATA #1 : String with size, 31 bytes
172.40.1.111.41370.140710080056
2014-07-10-15.59.59.459133+480 I7618087A439 LEVEL: Warning
PID : 6029510 TID : 71450 PROC : db2sysc 0
INSTANCE: openeap NODE : 000 DB : KONKA
APPHDL : 0-1222
Standard input 收起
PID : 6029510 TID : 98178 PROC : db2sysc 0
INSTANCE: openeap NODE : 000 DB :
APPHDL : 0-2053 APPID: *LOCAL.openeap.140710084713
AUTHID : OPENEAP
EDUID : 98178 EDUNAME: db2agent (instance) 0
FUNCTION: DB2 UDB, SQO Latch Tracing, sqlo_xlatch::releaseConflict, probe:10
DATA #1 : String, 27 bytes
unlocking an unlatched lock
DATA #2 : Pointer, 8 bytes
0x0a000207f9fb78e8
DATA #3 : String, 123 bytes
{
lock = { 0x00000000 [ unlocked ] }
identity = SQLQG_F2PC_T::federatedProcessingSnapshotLatch (144)
}
DATA #4 : Hexdump, 8 bytes
0x0A000207F9FB78E8 : 0000 0000 0090 0000 ........
CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol)
[0] 0x09000000019BC7D4 pdLog + 0xE0
[1] 0x0900000001DD75F0 pdLog@glue413 + 0x12C
[2] 0x0900000002005B60 sqloSpinLockReleaseConflict + 0x5C
[3] 0x09000000017E3248 sqloSpinLockReleaseConflict@glue73 + 0x78
[4] 0x0900000003308608 sqlpm_write_locks_indoubt_tran__FP16sqeLocalDatabaseP8sqeAgentP19sqm_snapshot_bufferUiPUiT5P16sqlm_header_i
nfo + 0x64C
[5] 0x0900000003306D14 @92@sqm_snap_db_locks__FPC16sqm_agent_entityRC8sqlo_gmtP19sqm_snapshot_bufferP16sqeLocalDatabaseP14sqlm_col
lectedPCcCUiPP15sqlm + 0x564
[6] 0x09000000011796D0 sqlmonssagnt__FUi13sqm_entity_idP6sqlmaiT1PvP14sqlm_collectedUsT7P5sqlca + 0xD2C
[7] 0x0900000001D9BEBC sqlmonssbackend__FP12SQLE_DB2RA_T + 0x228
[8] 0x090000000205612C sqlesrvr__FP14db2UCinterface + 0x738
[9] 0x09000000017CAB68 sqleMappingFnServer__FP5sqldaP5sqlca + 0x1D0
2014-07-10-16.48.04.129641+480 E7628481A942 LEVEL: Critical
PID : 6029510 TID : 98178 PROC : db2sysc 0
INSTANCE: openeap NODE : 000 DB :
APPHDL : 0-2053 APPID: *LOCAL.openeap.140710084713
AUTHID : OPENEAP
EDUID : 98178 EDUNAME: db2agent (instance) 0
FUNCTION: DB2 UDB, base sys utilities, sqle_panic, probe:10
MESSAGE : ADM14001C An unexpected and critical error has occurred: "Panic".
The instance may have been shutdown as a result. "Automatic" FODC
(First Occurrence Data Capture) has been invoked and diagnostic
information has been recorded in directory
...skipping...
FUNCTION: DB2 UDB, bsu security, sqlexLogPluginMessage, probe:20
DATA #1 : String with size, 66 bytes
Password validation for user spmread failed with rc = -2146500502
2014-07-10-15.59.59.441283+480 I7612374A438 LEVEL: Warning
PID : 6029510 TID : 71450 PROC : db2sysc 0
INSTANCE: openeap NODE : 000 DB : KONKA
APPHDL : 0-1215
EDUID : 71450 EDUNAME: db2agent (KONKA) 0
FUNCTION: DB2 UDB, bsu security, sqlexSlsSystemAuthenticate, probe:150
MESSAGE : application id:
DATA #1 : String with size, 31 bytes
172.40.1.111.41364.140710080050
2014-07-10-15.59.59.443259+480 I7612813A439 LEVEL: Warning
PID : 6029510 TID : 71450 PROC : db2sysc 0
INSTANCE: openeap NODE : 000 DB : KONKA
APPHDL : 0-1216
EDUID : 71450 EDUNAME: db2agent (KONKA) 0
FUNCTION: DB2 UDB, bsu security, sqlexLogPluginMessage, probe:20
DATA #1 : String with size, 66 bytes
Password validation for user spmread failed with rc = -2146500502
2014-07-10-15.59.59.443368+480 I7613253A438 LEVEL: Warning
PID : 6029510 TID : 71450 PROC : db2sysc 0
INSTANCE: openeap NODE : 000 DB : KONKA
APPHDL : 0-1216
EDUID : 71450 EDUNAME: db2agent (KONKA) 0
FUNCTION: DB2 UDB, bsu security, sqlexSlsSystemAuthenticate, probe:150
MESSAGE : application id:
DATA #1 : String with size, 31 bytes
172.40.1.111.41365.140710080051
2014-07-10-15.59.59.445446+480 I7613692A439 LEVEL: Warning
PID : 6029510 TID : 71450 PROC : db2sysc 0
INSTANCE: openeap NODE : 000 DB : KONKA
APPHDL : 0-1217
EDUID : 71450 EDUNAME: db2agent (KONKA) 0
FUNCTION: DB2 UDB, bsu security, sqlexLogPluginMessage, probe:20
DATA #1 : String with size, 66 bytes
Password validation for user spmread failed with rc = -2146500502
2014-07-10-15.59.59.445546+480 I7614132A438 LEVEL: Warning
PID : 6029510 TID : 71450 PROC : db2sysc 0
INSTANCE: openeap NODE : 000 DB : KONKA
APPHDL : 0-1217
EDUID : 71450 EDUNAME: db2agent (KONKA) 0
FUNCTION: DB2 UDB, bsu security, sqlexSlsSystemAuthenticate, probe:150
MESSAGE : application id:
DATA #1 : String with size, 31 bytes
172.40.1.111.41366.140710080052
2014-07-10-15.59.59.449489+480 I7614571A439 LEVEL: Warning
PID : 6029510 TID : 71450 PROC : db2sysc 0
INSTANCE: openeap NODE : 000 DB : KONKA
APPHDL : 0-1218
EDUID : 71450 EDUNAME: db2agent (KONKA) 0
FUNCTION: DB2 UDB, bsu security, sqlexLogPluginMessage, probe:20
DATA #1 : String with size, 66 bytes
Password validation for user spmread failed with rc = -2146500502
2014-07-10-15.59.59.449589+480 I7615011A438 LEVEL: Warning
PID : 6029510 TID : 71450 PROC : db2sysc 0
INSTANCE: openeap NODE : 000 DB : KONKA
APPHDL : 0-1218
EDUID : 71450 EDUNAME: db2agent (KONKA) 0
FUNCTION: DB2 UDB, bsu security, sqlexSlsSystemAuthenticate, probe:150
MESSAGE : application id:
DATA #1 : String with size, 31 bytes
172.40.1.111.41367.140710080053
2014-07-10-15.59.59.452002+480 I7615450A439 LEVEL: Warning
PID : 6029510 TID : 71450 PROC : db2sysc 0
INSTANCE: openeap NODE : 000 DB : KONKA
APPHDL : 0-1219
EDUID : 71450 EDUNAME: db2agent (KONKA) 0
FUNCTION: DB2 UDB, bsu security, sqlexLogPluginMessage, probe:20
DATA #1 : String with size, 66 bytes
Password validation for user spmread failed with rc = -2146500502
2014-07-10-15.59.59.452100+480 I7615890A438 LEVEL: Warning
PID : 6029510 TID : 71450 PROC : db2sysc 0
INSTANCE: openeap NODE : 000 DB : KONKA
APPHDL : 0-1219
EDUID : 71450 EDUNAME: db2agent (KONKA) 0
FUNCTION: DB2 UDB, bsu security, sqlexSlsSystemAuthenticate, probe:150
MESSAGE : application id:
DATA #1 : String with size, 31 bytes
172.40.1.111.41368.140710080054
2014-07-10-15.59.59.453944+480 I7616329A439 LEVEL: Warning
PID : 6029510 TID : 71450 PROC : db2sysc 0
INSTANCE: openeap NODE : 000 DB : KONKA
APPHDL : 0-1220
EDUID : 71450 EDUNAME: db2agent (KONKA) 0
FUNCTION: DB2 UDB, bsu security, sqlexLogPluginMessage, probe:20
DATA #1 : String with size, 66 bytes
Password validation for user spmread failed with rc = -2146500502
2014-07-10-15.59.59.454041+480 I7616769A438 LEVEL: Warning
PID : 6029510 TID : 71450 PROC : db2sysc 0
INSTANCE: openeap NODE : 000 DB : KONKA
APPHDL : 0-1220
EDUID : 71450 EDUNAME: db2agent (KONKA) 0
FUNCTION: DB2 UDB, bsu security, sqlexSlsSystemAuthenticate, probe:150
MESSAGE : application id:
DATA #1 : String with size, 31 bytes
172.40.1.111.41369.140710080055
2014-07-10-15.59.59.457310+480 I7617208A439 LEVEL: Warning
PID : 6029510 TID : 71450 PROC : db2sysc 0
INSTANCE: openeap NODE : 000 DB : KONKA
APPHDL : 0-1221
EDUID : 71450 EDUNAME: db2agent (KONKA) 0
FUNCTION: DB2 UDB, bsu security, sqlexLogPluginMessage, probe:20
DATA #1 : String with size, 66 bytes
Password validation for user spmread failed with rc = -2146500502
2014-07-10-15.59.59.457408+480 I7617648A438 LEVEL: Warning
PID : 6029510 TID : 71450 PROC : db2sysc 0
INSTANCE: openeap NODE : 000 DB : KONKA
APPHDL : 0-1221
EDUID : 71450 EDUNAME: db2agent (KONKA) 0
FUNCTION: DB2 UDB, bsu security, sqlexSlsSystemAuthenticate, probe:150
MESSAGE : application id:
DATA #1 : String with size, 31 bytes
172.40.1.111.41370.140710080056
2014-07-10-15.59.59.459133+480 I7618087A439 LEVEL: Warning
PID : 6029510 TID : 71450 PROC : db2sysc 0
INSTANCE: openeap NODE : 000 DB : KONKA
APPHDL : 0-1222
Standard input 收起
是这样的，用v9.1的备份在v9.7下恢复（实例在9.7下新建的），然后db2upgrade 收起
db2 get db cfg
Database Configuration for Database
Database configuration release level = 0x0d00
Database release level = 0x0d00
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) =
Number compatibility = OFF
Varchar2 compatibility = OFF
Date compatibility = OFF
Database page size = 4096
Dynamic SQL Query management (DYN_QUERY_MGMT) = DISABLE
Statement concentrator (STMT_CONC) = OFF
Discovery support for this database (DISCOVER_DB) = ENABLE
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
Decimal floating point rounding mode (DECFLT_ROUNDING) = ROUND_HALF_EVEN
Backup pending = NO
All committed transactions have been written to disk = NO
Rollforward pending = NO
Restore pending = NO
Multi-page file allocation enabled = YES
Log retain for recovery status = RECOVERY
User exit for logging status = YES
Self tuning memory (SELF_TUNING_MEM) = ON
Size of database shared memory (4KB) (DATABASE_MEMORY) = AUTOMATIC(10501469)
Database memory threshold (DB_MEM_THRESH) = 10
Max storage for lock list (4KB) (LOCKLIST) = AUTOMATIC(16160)
Percent. of lock lists per application (MAXLOCKS) = AUTOMATIC(97)
Package cache size (4KB) (PCKCACHESZ) = AUTOMATIC(382733)
Sort heap thres for shared sorts (4KB) (SHEAPTHRES_SHR) = AUTOMATIC(520002)
Sort list heap (4KB) (SORTHEAP) = AUTOMATIC(50000)
Database heap (4KB) (DBHEAP) = AUTOMATIC(12000)
Catalog cache size (4KB) (CATALOGCACHE_SZ) = 2048
Log buffer size (4KB) (LOGBUFSZ) = 2048
Utilities heap size (4KB) (UTIL_HEAP_SZ) = 10000
Buffer pool size (pages) (BUFFPAGE) = 1000
SQL statement heap (4KB) (STMTHEAP) = 4096
Default application heap (4KB) (APPLHEAPSZ) = AUTOMATIC(3072)
Application Memory Size (4KB) (APPL_MEMORY) = AUTOMATIC(40016)
Statistics heap size (4KB) (STAT_HEAP_SZ) = AUTOMATIC(10000)
Interval for checking deadlock (ms) (DLCHKTIME) = 300000
Lock timeout (sec) (LOCKTIMEOUT) = 3600
Changed pages threshold (CHNGPGS_THRESH) = 40
Number of asynchronous page cleaners (NUM_IOCLEANERS) = 4
Number of I/O servers (NUM_IOSERVERS) = 3
Index sort flag (INDEXSORT) = YES
Sequential detect flag (SEQDETECT) = YES
Default prefetch size (pages) (DFT_PREFETCH_SZ) = AUTOMATIC
Track modified pages (TRACKMOD) = NO
Default number of containers = 1
Default tablespace extentsize (pages) (DFT_EXTENT_SZ) = 32
Max number of active applications (MAXAPPLS) = AUTOMATIC(1169)
Average number of active applications (AVG_APPLS) = 30
Max DB files open per application (MAXFILOP) = 61440
Log file size (4KB) (LOGFILSIZ) = 40000
Number of primary log files (LOGPRIMARY) = 30
Number of secondary log files (LOGSECOND) = 20
Changed path to log files (NEWLOGPATH) =
Path to log files = /db2/openeap/openeap/NODE0000/SQL00001/SQLOGDIR/
Overflow log path (OVERFLOWLOGPATH) =
Mirror log path (MIRRORLOGPATH) =
First active log file = S0013915.LOG
Block log on disk full (BLK_LOG_DSK_FUL) = NO
Block non logged operations (BLOCKNONLOGGED) = NO
Percent max primary log space by transaction (MAX_LOG) = 0
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) =
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
HADR log write synchronization mode (HADR_SYNCMODE) = NEARSYNC
HADR peer window duration (seconds) (HADR_PEER_WINDOW) = 0
First log archive method (LOGARCHMETH1) = DISK:/databak/archivelog/
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) = OFF
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) = 60
Auto deletion of recovery objects (AUTO_DEL_REC_OBJ) = OFF
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 statement statistics (AUTO_STMT_STATS) = OFF
Automatic statistics profiling (AUTO_STATS_PROF) = OFF
Automatic profile updates (AUTO_PROF_UPD) = OFF
Automatic reorganization (AUTO_REORG) = OFF
Auto-Revalidation (AUTO_REVAL) = DISABLED
Currently Committed (CUR_COMMIT) = DISABLED
CHAR output with DECIMAL input (DEC_TO_CHAR_FMT) = V95
Enable XML Character operations (ENABLE_XMLCHAR) = YES
WLM Collection Interval (minutes) (WLM_COLLECT_INT) = 0
Monitor Collect Settings
Request metrics (MON_REQ_METRICS) = NONE
Activity metrics (MON_ACT_METRICS) = NONE
Object metrics (MON_OBJ_METRICS) = NONE
Unit of work events (MON_UOW_DATA) = NONE
Lock timeout events (MON_LOCKTIMEOUT) = NONE
Deadlock events (MON_DEADLOCK) = WITHOUT_HIST
Lock wait events (MON_LOCKWAIT) = NONE
Lock wait event threshold (MON_LW_THRESH) = 4294967295
Number of package list entries (MON_PKGLIST_SZ) = 32
Lock event notification level (MON_LCK_MSG_LVL) = 1
SMTP Server (SMTP_SERVER) =
SQL conditional compilation flags (SQL_CCFLAGS) =
Section actuals setting (SECTION_ACTUALS) = NONE
Connect procedure (CONNECT_PROC) = 收起
Database Configuration for Database
Database configuration release level = 0x0d00
Database release level = 0x0d00
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) =
Number compatibility = OFF
Varchar2 compatibility = OFF
Date compatibility = OFF
Database page size = 4096
Dynamic SQL Query management (DYN_QUERY_MGMT) = DISABLE
Statement concentrator (STMT_CONC) = OFF
Discovery support for this database (DISCOVER_DB) = ENABLE
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
Decimal floating point rounding mode (DECFLT_ROUNDING) = ROUND_HALF_EVEN
Backup pending = NO
All committed transactions have been written to disk = NO
Rollforward pending = NO
Restore pending = NO
Multi-page file allocation enabled = YES
Log retain for recovery status = RECOVERY
User exit for logging status = YES
Self tuning memory (SELF_TUNING_MEM) = ON
Size of database shared memory (4KB) (DATABASE_MEMORY) = AUTOMATIC(10501469)
Database memory threshold (DB_MEM_THRESH) = 10
Max storage for lock list (4KB) (LOCKLIST) = AUTOMATIC(16160)
Percent. of lock lists per application (MAXLOCKS) = AUTOMATIC(97)
Package cache size (4KB) (PCKCACHESZ) = AUTOMATIC(382733)
Sort heap thres for shared sorts (4KB) (SHEAPTHRES_SHR) = AUTOMATIC(520002)
Sort list heap (4KB) (SORTHEAP) = AUTOMATIC(50000)
Database heap (4KB) (DBHEAP) = AUTOMATIC(12000)
Catalog cache size (4KB) (CATALOGCACHE_SZ) = 2048
Log buffer size (4KB) (LOGBUFSZ) = 2048
Utilities heap size (4KB) (UTIL_HEAP_SZ) = 10000
Buffer pool size (pages) (BUFFPAGE) = 1000
SQL statement heap (4KB) (STMTHEAP) = 4096
Default application heap (4KB) (APPLHEAPSZ) = AUTOMATIC(3072)
Application Memory Size (4KB) (APPL_MEMORY) = AUTOMATIC(40016)
Statistics heap size (4KB) (STAT_HEAP_SZ) = AUTOMATIC(10000)
Interval for checking deadlock (ms) (DLCHKTIME) = 300000
Lock timeout (sec) (LOCKTIMEOUT) = 3600
Changed pages threshold (CHNGPGS_THRESH) = 40
Number of asynchronous page cleaners (NUM_IOCLEANERS) = 4
Number of I/O servers (NUM_IOSERVERS) = 3
Index sort flag (INDEXSORT) = YES
Sequential detect flag (SEQDETECT) = YES
Default prefetch size (pages) (DFT_PREFETCH_SZ) = AUTOMATIC
Track modified pages (TRACKMOD) = NO
Default number of containers = 1
Default tablespace extentsize (pages) (DFT_EXTENT_SZ) = 32
Max number of active applications (MAXAPPLS) = AUTOMATIC(1169)
Average number of active applications (AVG_APPLS) = 30
Max DB files open per application (MAXFILOP) = 61440
Log file size (4KB) (LOGFILSIZ) = 40000
Number of primary log files (LOGPRIMARY) = 30
Number of secondary log files (LOGSECOND) = 20
Changed path to log files (NEWLOGPATH) =
Path to log files = /db2/openeap/openeap/NODE0000/SQL00001/SQLOGDIR/
Overflow log path (OVERFLOWLOGPATH) =
Mirror log path (MIRRORLOGPATH) =
First active log file = S0013915.LOG
Block log on disk full (BLK_LOG_DSK_FUL) = NO
Block non logged operations (BLOCKNONLOGGED) = NO
Percent max primary log space by transaction (MAX_LOG) = 0
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) =
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
HADR log write synchronization mode (HADR_SYNCMODE) = NEARSYNC
HADR peer window duration (seconds) (HADR_PEER_WINDOW) = 0
First log archive method (LOGARCHMETH1) = DISK:/databak/archivelog/
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) = OFF
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) = 60
Auto deletion of recovery objects (AUTO_DEL_REC_OBJ) = OFF
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 statement statistics (AUTO_STMT_STATS) = OFF
Automatic statistics profiling (AUTO_STATS_PROF) = OFF
Automatic profile updates (AUTO_PROF_UPD) = OFF
Automatic reorganization (AUTO_REORG) = OFF
Auto-Revalidation (AUTO_REVAL) = DISABLED
Currently Committed (CUR_COMMIT) = DISABLED
CHAR output with DECIMAL input (DEC_TO_CHAR_FMT) = V95
Enable XML Character operations (ENABLE_XMLCHAR) = YES
WLM Collection Interval (minutes) (WLM_COLLECT_INT) = 0
Monitor Collect Settings
Request metrics (MON_REQ_METRICS) = NONE
Activity metrics (MON_ACT_METRICS) = NONE
Object metrics (MON_OBJ_METRICS) = NONE
Unit of work events (MON_UOW_DATA) = NONE
Lock timeout events (MON_LOCKTIMEOUT) = NONE
Deadlock events (MON_DEADLOCK) = WITHOUT_HIST
Lock wait events (MON_LOCKWAIT) = NONE
Lock wait event threshold (MON_LW_THRESH) = 4294967295
Number of package list entries (MON_PKGLIST_SZ) = 32
Lock event notification level (MON_LCK_MSG_LVL) = 1
SMTP Server (SMTP_SERVER) =
SQL conditional compilation flags (SQL_CCFLAGS) =
Section actuals setting (SECTION_ACTUALS) = NONE
Connect procedure (CONNECT_PROC) = 收起
$ db2 get dbm cfg
Database Manager Configuration
Node type = Enterprise Server Edition with local and remote clients
Database manager configuration release level = 0x0d00
CPU speed (millisec/instruction) (CPUSPEED) = 2.204273e-07
Communications bandwidth (MB/sec) (COMM_BANDWIDTH) = 1.000000e+02
Max number of concurrently active databases (NUMDB) = 8
Federated Database System Support (FEDERATED) = YES
Transaction processor monitor name (TP_MON_NAME) =
Default charge-back account (DFT_ACCOUNT_STR) =
Java Development Kit installation path (JDK_PATH) = /db2/openeap/sqllib/java/jdk64
Diagnostic error capture level (DIAGLEVEL) = 3
Notify Level (NOTIFYLEVEL) = 3
Diagnostic data directory path (DIAGPATH) = /db2/openeap/sqllib/db2dump/
Alternate diagnostic data directory path (ALT_DIAGPATH) =
Size of rotating db2diag & notify logs (MB) (DIAGSIZE) = 0
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) = OFF
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
Cluster manager (CLUSTER_MGR) =
Database manager authentication (AUTHENTICATION) = SERVER
Alternate authentication (ALTERNATE_AUTH_ENC) = NOT_SPECIFIED
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) = /db2/openeap
Database monitor heap size (4KB) (MON_HEAP_SZ) = AUTOMATIC(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(22891836)
Agent stack size (AGENT_STACK_SZ) = 1024
Sort heap threshold (4KB) (SHEAPTHRES) = 0
Directory cache support (DIR_CACHE) = YES
Application support layer heap size (4KB) (ASLHEAPSZ) = 15
Max requester I/O block size (bytes) (RQRIOBLK) = 32767
Workload impact by throttled utilities(UTIL_IMPACT_LIM) = 10
Priority of agents (AGENTPRI) = SYSTEM
Agent pool size (NUM_POOLAGENTS) = AUTOMATIC(200)
Initial number of agents in pool (NUM_INITAGENTS) = 30
Max number of coordinating agents (MAX_COORDAGENTS) = AUTOMATIC(1000)
Max number of client connections (MAX_CONNECTIONS) = AUTOMATIC(MAX_COORDAGENTS)
Keep fenced process (KEEPFENCED) = YES
Number of pooled fenced processes (FENCED_POOL) = AUTOMATIC(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) = CallCent
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_openeap
Discovery mode (DISCOVER) = SEARCH
Discover server instance (DISCOVER_INST) = ENABLE
SSL server keydb file (SSL_SVR_KEYDB) =
SSL server stash file (SSL_SVR_STASH) =
SSL server certificate label (SSL_SVR_LABEL) =
SSL service name (SSL_SVCENAME) =
SSL cipher specs (SSL_CIPHERSPECS) =
SSL versions (SSL_VERSIONS) =
SSL client keydb file (SSL_CLNT_KEYDB) =
SSL client stash file (SSL_CLNT_STASH) =
Maximum query degree of parallelism (MAX_QUERYDEGREE) = ANY
Enable intra-partition parallelism (INTRA_PARALLEL) = NO
Maximum Asynchronous TQs per query (FEDERATED_ASYNC) = 0
No. of int. communication buffers(4KB)(FCM_NUM_BUFFERS) = AUTOMATIC(4096)
No. of int. communication channels (FCM_NUM_CHANNELS) = AUTOMATIC(2048)
Inter-node comm. parallelism (FCM_PARALLELISM) = 1
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 收起
Database Manager Configuration
Node type = Enterprise Server Edition with local and remote clients
Database manager configuration release level = 0x0d00
CPU speed (millisec/instruction) (CPUSPEED) = 2.204273e-07
Communications bandwidth (MB/sec) (COMM_BANDWIDTH) = 1.000000e+02
Max number of concurrently active databases (NUMDB) = 8
Federated Database System Support (FEDERATED) = YES
Transaction processor monitor name (TP_MON_NAME) =
Default charge-back account (DFT_ACCOUNT_STR) =
Java Development Kit installation path (JDK_PATH) = /db2/openeap/sqllib/java/jdk64
Diagnostic error capture level (DIAGLEVEL) = 3
Notify Level (NOTIFYLEVEL) = 3
Diagnostic data directory path (DIAGPATH) = /db2/openeap/sqllib/db2dump/
Alternate diagnostic data directory path (ALT_DIAGPATH) =
Size of rotating db2diag & notify logs (MB) (DIAGSIZE) = 0
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) = OFF
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
Cluster manager (CLUSTER_MGR) =
Database manager authentication (AUTHENTICATION) = SERVER
Alternate authentication (ALTERNATE_AUTH_ENC) = NOT_SPECIFIED
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) = /db2/openeap
Database monitor heap size (4KB) (MON_HEAP_SZ) = AUTOMATIC(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(22891836)
Agent stack size (AGENT_STACK_SZ) = 1024
Sort heap threshold (4KB) (SHEAPTHRES) = 0
Directory cache support (DIR_CACHE) = YES
Application support layer heap size (4KB) (ASLHEAPSZ) = 15
Max requester I/O block size (bytes) (RQRIOBLK) = 32767
Workload impact by throttled utilities(UTIL_IMPACT_LIM) = 10
Priority of agents (AGENTPRI) = SYSTEM
Agent pool size (NUM_POOLAGENTS) = AUTOMATIC(200)
Initial number of agents in pool (NUM_INITAGENTS) = 30
Max number of coordinating agents (MAX_COORDAGENTS) = AUTOMATIC(1000)
Max number of client connections (MAX_CONNECTIONS) = AUTOMATIC(MAX_COORDAGENTS)
Keep fenced process (KEEPFENCED) = YES
Number of pooled fenced processes (FENCED_POOL) = AUTOMATIC(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) = CallCent
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_openeap
Discovery mode (DISCOVER) = SEARCH
Discover server instance (DISCOVER_INST) = ENABLE
SSL server keydb file (SSL_SVR_KEYDB) =
SSL server stash file (SSL_SVR_STASH) =
SSL server certificate label (SSL_SVR_LABEL) =
SSL service name (SSL_SVCENAME) =
SSL cipher specs (SSL_CIPHERSPECS) =
SSL versions (SSL_VERSIONS) =
SSL client keydb file (SSL_CLNT_KEYDB) =
SSL client stash file (SSL_CLNT_STASH) =
Maximum query degree of parallelism (MAX_QUERYDEGREE) = ANY
Enable intra-partition parallelism (INTRA_PARALLEL) = NO
Maximum Asynchronous TQs per query (FEDERATED_ASYNC) = 0
No. of int. communication buffers(4KB)(FCM_NUM_BUFFERS) = AUTOMATIC(4096)
No. of int. communication channels (FCM_NUM_CHANNELS) = AUTOMATIC(2048)
Inter-node comm. parallelism (FCM_PARALLELISM) = 1
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 收起
$ db2pd -dbptn
Database Partition 0 -- Active -- Up 0 days 00:17:30 -- Date 2014-07-10-17.25.05.306708
Database Partition Memory Controller Statistics
Controller Automatic: Y
Memory Limit: 91567344 KB
Current usage: 42504384 KB
HWM usage: 45546816 KB
Cached memory: 4685824 KB
Individual Memory Consumers:
Name Mem Used (KB) HWM Used (KB) Cached (KB)
========================================================
APPL-KONKA 65216 171008 10944
DBMS-openeap 124480 124480 46848
FMP_RESOURCES 22528 22528 0
PRIVATE 499200 668032 99392
DB-KONKA 41792832 44560768 4528640
LCL-p9306188 128 128 0 收起
Database Partition 0 -- Active -- Up 0 days 00:17:30 -- Date 2014-07-10-17.25.05.306708
Database Partition Memory Controller Statistics
Controller Automatic: Y
Memory Limit: 91567344 KB
Current usage: 42504384 KB
HWM usage: 45546816 KB
Cached memory: 4685824 KB
Individual Memory Consumers:
Name Mem Used (KB) HWM Used (KB) Cached (KB)
========================================================
APPL-KONKA 65216 171008 10944
DBMS-openeap 124480 124480 46848
FMP_RESOURCES 22528 22528 0
PRIVATE 499200 668032 99392
DB-KONKA 41792832 44560768 4528640
LCL-p9306188 128 128 0 收起