场景:两台服务器一台存储,实现主备切换
方案:实例用户放在存储上,切换到备机,挂载存储,主备机的数据库版本一致,用户ID一致,方案使用在另外三组是正常的。
故障:每次切换,报错SQL1042C An unexpected system error occurred,需要更新实例才能解决,但是具体是那些参数出的问题没有找到。
2014-05-14-10.40.18.657094+480 E58597E1436 LEVEL: Event
PID : 22136 TID : 47833256290624PROC : db2syscr
INSTANCE: jinzhai NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2main, probe:1
START : DB2 DBM
DATA #1 : Build Level, 152 bytes
Instance "jinzhai" uses "64" bits and DB2 code release "SQL09074"
with level identifier "08050107".
Informational tokens are "DB2 v9.7.0.4", "s110330", "IP23243", Fix Pack "4".
DATA #2 : System Info, 440 bytes
System: Linux localhost.localdomain 6 2 x86_64
CPU: total:64 online:64 Cores per socket:32 Threading degree per core:1
Physical Memory(MB): total:64280 free:63569
Virtual Memory(MB): total:130552 free:129841
Swap Memory(MB): total:66272 free:66272
Kernel Params: msgMaxMessageSize:65536 msgMsgMap:65536 msgMaxQueueIDs:64512
msgNumberOfHeaders:65536 msgMaxQueueSize:65536
msgMaxSegmentSize:16 shmMax:68719476736 shmMin:1 shmIDs:16128
shmSegments:16128 semMap:256000 semIDs:16128 semNum:256000
semUndo:256000 semNumPerID:250 semOps:32 semUndoSize:20
semMaxVal:32767 semAdjustOnExit:32767
Cur cpu time limit (seconds) = 0xFFFFFFFF
Cur file size limit (bytes) = 0xFFFFFFFF
Cur data size (bytes) = 0xFFFFFFFF
Cur stack size (bytes) = 0x00A00000
Cur core size (bytes) = 0x00000000
Cur memory size (bytes) = 0xFFFFFFFF
nofiles (descriptors) = 0x00000800
2014-05-14-10.40.18.660691+480 E60034E372 LEVEL: Info
PID : 22136 TID : 47833256290624PROC : db2syscr
INSTANCE: jinzhai NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2main, probe:0
MESSAGE : ADM0506I DB2 has automatically updated the "kernel.sem" kernel
parameter from "32000" to the recommended value "256000".
2014-05-14-10.40.18.667269+480 E60407E369 LEVEL: Info
PID : 22136 TID : 47833256290624PROC : db2syscr
INSTANCE: jinzhai NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2main, probe:0
MESSAGE : ADM0506I DB2 has automatically updated the "kernel.sem" kernel
parameter from "128" to the recommended value "16128".
2014-05-14-10.40.18.667676+480 E60777E371 LEVEL: Info
PID : 22136 TID : 47833256290624PROC : db2syscr
INSTANCE: jinzhai NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2main, probe:0
MESSAGE : ADM0506I DB2 has automatically updated the "kernel.msgmni" kernel
parameter from "16" to the recommended value "64512".
2014-05-14-10.40.18.667970+480 E61149E373 LEVEL: Info
PID : 22136 TID : 47833256290624PROC : db2syscr
INSTANCE: jinzhai NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2main, probe:0
MESSAGE : ADM0506I DB2 has automatically updated the "kernel.shmmni" kernel
parameter from "4096" to the recommended value "16128".
2014-05-14-10.40.18.924745+480 E61523E575 LEVEL: Warning
PID : 22138 TID : 47833256290624PROC : db2sysc 0
INSTANCE: jinzhai NODE : 000
EDUID : 1 EDUNAME: db2sysc 0
FUNCTION: DB2 UDB, oper system services, sqloSystemControllerMain, probe:100
DATA #1 : String, 242 bytes
Address Space Layout Randomization (ASLR) is enabled in this environment.
ASLR may cause intermittent failures in shmat() for any processes other than
db2sysc, and is recommended to be disabled. To disable it, set
kernel.randomize_va_space=0
2014-05-14-10.40.19.066060+480 I62099E534 LEVEL: Event
PID : 22138 TID : 46939437525312PROC : db2sysc 0
INSTANCE: jinzhai NODE : 000
EDUID : 1 EDUNAME: db2sysc 0
FUNCTION: DB2 UDB, fast comm manager, sqkfBufferManager::initBufferManager, prob
e:10
START : Starting FCM Buffer Manager
1 resource group(s).
128 buffers allocated.
Maximum number of buffers supported is 8192.
Total buffer manager memory required for 1 logical and 0 fail-over partition(s)
is 925712 bytes.
2014-05-14-10.40.19.077022+480 I62634E541 LEVEL: Event
PID : 22138 TID : 46939437525312PROC : db2sysc 0
INSTANCE: jinzhai NODE : 000
EDUID : 1 EDUNAME: db2sysc 0
FUNCTION: DB2 UDB, fast comm manager, sqkfChannelManager::initChannelManager, pr
obe:10
START : Starting FCM Channel Manager
1 resource group(s).
128 channels allocated.
Maximum number of channels supported is 8192.
Total channel manager memory required for 1 logical and 0 fail-over partitions(s
) is 507928 bytes.
2014-05-14-10.40.19.078178+480 I63176E540 LEVEL: Event
PID : 22138 TID : 46939437525312PROC : db2sysc 0
INSTANCE: jinzhai NODE : 000
EDUID : 1 EDUNAME: db2sysc 0
FUNCTION: DB2 UDB, fast comm manager, sqkfSessionManager::initSessionManager, pr
obe:10
START : Starting FCM Session Manager
1 resource group(s).
128 sessions allocated.
Maximum number of sessions supported is 64000.
Total session manager memory required for 1 logical and 0 fail-over partitions i
s 1687552 bytes.
2014-05-14-10.40.19.089086+480 I63717E421 LEVEL: Event
PID : 22138 TID : 46939437525312PROC : db2sysc 0
INSTANCE: jinzhai NODE : 000
EDUID : 1 EDUNAME: db2sysc 0
FUNCTION: DB2 UDB, fast comm manager, sqlkf_init_allocate_shared, probe:500
START : FCM infrastructure started
FCM running in non-shared mode; FCM parallelism degree: 1; comm protocol: TCP/IP
v4
2014-05-14-10.40.20.345548+480 E64139E305 LEVEL: Event
PID : 22132 TID : 47126329776736PROC : db2star2
INSTANCE: jinzhai NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StartMain, probe:911
MESSAGE : ADM7513W Database manager has started.
START : DB2 DBM
收起