帮忙分析一下db2的日志，错误很多！

显示全部楼层 · 2005-10-30 17:05:33

2006-09-24-17.54.39.879163+480 E643841178C316 LEVEL: Error (OS)
PID : 27923
TID: 4160332352PROC : db2logmgr (YKTBASE) 0
INSTANCE: yktinst1
NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloexec2, probe:2
CALLED: OS, -, unspecified_system_functionOSERR: EINTR (4)
2006-09-24-17.54.39.879627+480 E643841495C513 LEVEL: Error
PID : 27923
TID: 4160332352PROC : db2logmgr (YKTBASE) 0
INSTANCE: yktinst1
NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgInvokeUserexit, probe:1140
MESSAGE : ADM1832EDB2 was unable to find the user exit program when archiving

log file "S0000287.LOG" from

"/diskgrp/cur/yktinst1/yktbase/yktinst1/NODE0000/SQL00001/SQLOGDIR/"

for database "YKTBASE".The error code was "24".
2006-09-24-17.54.39.879872+480 I643842009C422 LEVEL: Error
PID : 27923
TID: 4160332352PROC : db2logmgr (YKTBASE) 0
INSTANCE: yktinst1
NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogFile, probe:3160
MESSAGE : Failed to archive log file S0000287.LOG to USEREXIT from

/diskgrp/cur/yktinst1/yktbase/yktinst1/NODE0000/SQL00001/SQLOGDIR/

with rc = 24.
2006-09-24-17.54.39.882423+480 E643842432C316 LEVEL: Error (OS)
PID : 27923
TID: 4160332352PROC : db2logmgr (YKTBASE) 0
INSTANCE: yktinst1
NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloexec2, probe:2
CALLED: OS, -, unspecified_system_functionOSERR: EINTR (4)
2006-09-24-17.54.39.882819+480 E643842749C494 LEVEL: Error
PID : 27923
TID: 4160332352PROC : db2logmgr (YKTBASE) 0
INSTANCE: yktinst1
NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgInvokeUserexit, probe:1140
MESSAGE : ADM1832EDB2 was unable to find the user exit program when archiving

log file "S0000287.LOG" from

"/diskgrp/nfsback/yktinst1/yktbase/log/NODE0000/" for database

"YKTBASE".The error code was "24".
2006-09-24-17.54.39.883054+480 I643843244C392 LEVEL: Error
PID : 27923
TID: 4160332352PROC : db2logmgr (YKTBASE) 0
INSTANCE: yktinst1
NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogFile, probe:3160
MESSAGE : Failed to archive log file S0000287.LOG to USEREXIT from

/diskgrp/nfsback/yktinst1/yktbase/log/NODE0000/ with rc = 24.
2006-09-24-17.54.39.883208+480 I643843637C374 LEVEL: Warning
PID : 27923
TID: 4160332352PROC : db2logmgr (YKTBASE) 0
INSTANCE: yktinst1
NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgRetryFailedArchive, probe:4780
MESSAGE : Still unable to archive log file 287 due to rc 24 for LOGARCHMETH1

using method 4 and target .
2006-09-24-17.55.00.907000+480 E643844012C316 LEVEL: Error (OS)
PID : 27923
TID: 4160332352PROC : db2logmgr (YKTBASE) 0
INSTANCE: yktinst1
NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloexec2, probe:2
CALLED: OS, -, unspecified_system_functionOSERR: EINTR (4)
2006-09-24-17.55.00.907467+480 E643844329C513 LEVEL: Error
PID : 27923
TID: 4160332352PROC : db2logmgr (YKTBASE) 0
INSTANCE: yktinst1
NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgInvokeUserexit, probe:1140
MESSAGE : ADM1832EDB2 was unable to find the user exit program when archiving

log file "S0000287.LOG" from

"/diskgrp/cur/yktinst1/yktbase/yktinst1/NODE0000/SQL00001/SQLOGDIR/"

for database "YKTBASE".The error code was "24".
2006-09-24-17.55.00.907705+480 I643844843C422 LEVEL: Error
PID : 27923
TID: 4160332352PROC : db2logmgr (YKTBASE) 0
INSTANCE: yktinst1
NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogFile, probe:3160
MESSAGE : Failed to archive log file S0000287.LOG to USEREXIT from

/diskgrp/cur/yktinst1/yktbase/yktinst1/NODE0000/SQL00001/SQLOGDIR/

with rc = 24.
2006-09-24-17.55.00.910035+480 E643845266C316 LEVEL: Error (OS)
PID : 27923
TID: 4160332352PROC : db2logmgr (YKTBASE) 0
INSTANCE: yktinst1
NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloexec2, probe:2
CALLED: OS, -, unspecified_system_functionOSERR: EINTR (4)
2006-09-24-17.55.00.910427+480 E643845583C494 LEVEL: Error
PID : 27923
TID: 4160332352PROC : db2logmgr (YKTBASE) 0
INSTANCE: yktinst1
NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgInvokeUserexit, probe:1140
MESSAGE : ADM1832EDB2 was unable to find the user exit program when archiving

log file "S0000287.LOG" from

"/diskgrp/nfsback/yktinst1/yktbase/log/NODE0000/" for database

"YKTBASE".The error code was "24".
2006-09-24-17.55.00.910658+480 I643846078C392 LEVEL: Error
PID : 27923
TID: 4160332352PROC : db2logmgr (YKTBASE) 0
INSTANCE: yktinst1
NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogFile, probe:3160
MESSAGE : Failed to archive log file S0000287.LOG to USEREXIT from

/diskgrp/nfsback/yktinst1/yktbase/log/NODE0000/ with rc = 24.
2006-09-24-17.55.00.910845+480 I643846471C374 LEVEL: Warning
PID : 27923
TID: 4160332352PROC : db2logmgr (YKTBASE) 0
INSTANCE: yktinst1
NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgRetryFailedArchive, probe:4780
MESSAGE : Still unable to archive log file 287 due to rc 24 for LOGARCHMETH1

using method 4 and target .
2006-09-24-17.55.21.934100+480 E643846846C316 LEVEL: Error (OS)
PID : 27923
TID: 4160332352PROC : db2logmgr (YKTBASE) 0
INSTANCE: yktinst1
NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloexec2, probe:2
CALLED: OS, -, unspecified_system_functionOSERR: EINTR (4)
2006-09-24-17.55.21.934585+480 E643847163C513 LEVEL: Error
PID : 27923
TID: 4160332352PROC : db2logmgr (YKTBASE) 0
INSTANCE: yktinst1
NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgInvokeUserexit, probe:1140
MESSAGE : ADM1832EDB2 was unable to find the user exit program when archiving

log file "S0000287.LOG" from

"/diskgrp/cur/yktinst1/yktbase/yktinst1/NODE0000/SQL00001/SQLOGDIR/"

for database "YKTBASE".The error code was "24".
2006-09-24-17.55.21.934828+480 I643847677C422 LEVEL: Error
PID : 27923
TID: 4160332352PROC : db2logmgr (YKTBASE) 0
INSTANCE: yktinst1
NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogFile, probe:3160
MESSAGE : Failed to archive log file S0000287.LOG to USEREXIT from

/diskgrp/cur/yktinst1/yktbase/yktinst1/NODE0000/SQL00001/SQLOGDIR/

with rc = 24.

千问 · 2005-10-30 17:05:33

userexit 没有编译把

千问 · 2005-10-30 17:05:33

#define RC_NOTFOUND 24/* db2uext2() / file not found */

千问 · 2005-10-30 17:05:33

了解，看了相关userexit的帖子！谢谢！
还有新的问题请问：
系统23日2：00开始离线备份，但是中途就down了，什么原因？

2006-09-23-02.00.01.874886+480 I632655120C1511LEVEL: Event
PID : 14301
TID: 4158190752PROC : db2stop
INSTANCE: yktinst1
NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleStartStopSingleNode, probe:1130
DATA #1 : String, 41 bytes
/diskgrp/cur/yktinst1/sqllib/adm/db2stop2
DATA #2 : Hexdump, 256 bytes
0xFFFFB428 : 2F64 6973 6B67 7270 2F63 7572 2F79 6B74/diskgrp/cur/ykt
0xFFFFB438 : 696E 7374 312F 7371 6C6C 6962 2F61 646Dinst1/sqllib/adm
0xFFFFB448 : 2F64 6232 7374 6F70 3200 4E4F 4D53 4700/db2stop2.NOMSG.
0xFFFFB458 : 464F 5243 4500 534E 0000 0000 0000 0000FORCE.SN........
0xFFFFB468 : 0000 0000 0000 0000 0000 0000 0000 0000................
0xFFFFB478 : 0000 0000 0000 0000 0000 0000 0000 0000................
0xFFFFB488 : 0000 0000 0000 0000 0000 0000 0000 0000................
0xFFFFB498 : 0000 0000 0000 0000 0000 0000 0000 0000................
0xFFFFB4A8 : 0000 0000 0000 0000 0000 0000 0000 0000................
0xFFFFB4B8 : 0000 0000 0000 0000 0000 0000 0000 0000................
0xFFFFB4C8 : 0000 0000 0000 0000 0000 0000 0000 0000................
0xFFFFB4D8 : 0000 0000 0000 0000 0000 0000 0000 0000................
0xFFFFB4E8 : 0000 0000 0000 0000 0000 0000 0000 0000................
0xFFFFB4F8 : 0000 0000 0000 0000 0000 0000 0000 0000................
0xFFFFB508 : 0000 0000 0000 0000 0000 0000 0000 0000................
0xFFFFB518 : 0000 0000 0000 0000 0000 0000 0000 0000................
2006-09-23-02.00.01.907078+480 I632656632C375 LEVEL: Event
PID : 14303
TID: 4158190752PROC : db2stop2
INSTANCE: yktinst1
NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:104
DATA #1 : String, 26 bytes
Force phase is in progress
DATA #2 : Hexdump, 4 bytes
0xFFFFE7CC : 0000 0000
....
2006-09-23-02.00.02.944325+480 E632657008C316 LEVEL: Error (OS)
PID : 13855
TID: 4160332352PROC : db2logmgr (YKTBASE) 0
INSTANCE: yktinst1
NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloexec2, probe:2
CALLED: OS, -, unspecified_system_functionOSERR: EINTR (4)
2006-09-23-02.00.02.944799+480 E632657325C513 LEVEL: Error
PID : 13855
TID: 4160332352PROC : db2logmgr (YKTBASE) 0
INSTANCE: yktinst1
NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgInvokeUserexit, probe:1140
MESSAGE : ADM1832EDB2 was unable to find the user exit program when archiving

log file "S0000287.LOG" from

"/diskgrp/cur/yktinst1/yktbase/yktinst1/NODE0000/SQL00001/SQLOGDIR/"

for database "YKTBASE".The error code was "24".
2006-09-23-02.00.02.945037+480 I632657839C422 LEVEL: Error
PID : 13855
TID: 4160332352PROC : db2logmgr (YKTBASE) 0
INSTANCE: yktinst1
NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogFile, probe:3160
MESSAGE : Failed to archive log file S0000287.LOG to USEREXIT from

/diskgrp/cur/yktinst1/yktbase/yktinst1/NODE0000/SQL00001/SQLOGDIR/

with rc = 24.
2006-09-23-02.00.02.948097+480 E632658262C316 LEVEL: Error (OS)
PID : 13855
TID: 4160332352PROC : db2logmgr (YKTBASE) 0
INSTANCE: yktinst1
NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloexec2, probe:2
CALLED: OS, -, unspecified_system_functionOSERR: EINTR (4)
2006-09-23-02.00.02.948505+480 E632658579C494 LEVEL: Error
PID : 13855
TID: 4160332352PROC : db2logmgr (YKTBASE) 0
INSTANCE: yktinst1
NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgInvokeUserexit, probe:1140
MESSAGE : ADM1832EDB2 was unable to find the user exit program when archiving

log file "S0000287.LOG" from

"/diskgrp/nfsback/yktinst1/yktbase/log/NODE0000/" for database

"YKTBASE".The error code was "24".
2006-09-23-02.00.02.948738+480 I632659074C392 LEVEL: Error
PID : 13855
TID: 4160332352PROC : db2logmgr (YKTBASE) 0
INSTANCE: yktinst1
NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogFile, probe:3160
MESSAGE : Failed to archive log file S0000287.LOG to USEREXIT from

/diskgrp/nfsback/yktinst1/yktbase/log/NODE0000/ with rc = 24.
2006-09-23-02.00.02.948893+480 I632659467C374 LEVEL: Warning
PID : 13855
TID: 4160332352PROC : db2logmgr (YKTBASE) 0
INSTANCE: yktinst1
NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgRetryFailedArchive, probe:4780
MESSAGE : Still unable to archive log file 287 due to rc 24 for LOGARCHMETH1

using method 4 and target .
2006-09-23-02.00.03.188935+480 I632659842C336 LEVEL: Warning
PID : 13856
TID: 4160332352PROC : db2loggr (YKTBASE) 0
INSTANCE: yktinst1
NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpghck, probe:1390
MESSAGE : ExtNum 796, state 401, baselsn 00000000C38E8000 nextlsn

00000000C3BC1FA6
2006-09-23-02.00.03.542223+480 I632660179C308 LEVEL: Event
PID : 14303
TID: 4158190752PROC : db2stop2
INSTANCE: yktinst1
NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:108
DATA #1 : String, 47 bytes
Force phase is completed and preparing to stop.
2006-09-23-02.00.03.542485+480 I632660488C378 LEVEL: Event
PID : 14303
TID: 4158190752PROC : db2stop2
INSTANCE: yktinst1
NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:210
DATA #1 : String, 29 bytes
Deactivate phase is bypassed.
DATA #2 : Hexdump, 4 bytes
0xFFFFE7D0 : 0000 0001
....
2006-09-23-02.00.03.542682+480 I632660867C398 LEVEL: Event
PID : 14303
TID: 4158190752PROC : db2stop2
INSTANCE: yktinst1
NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:230
DATA #1 : String, 49 bytes
Deactivate phase is completed, preparing to stop.
DATA #2 : Hexdump, 4 bytes
0xFFFFE7D0 : 0000 0001
....
2006-09-23-02.00.03.542872+480 I632661266C287 LEVEL: Event
PID : 14303
TID: 4158190752PROC : db2stop2
INSTANCE: yktinst1
NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:240
DATA #1 : String, 26 bytes
Stop phase is in progress.
2006-09-23-02.00.03.543062+480 I632661554C302 LEVEL: Event
PID : 14303
TID: 4158190752PROC : db2stop2
INSTANCE: yktinst1
NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:250
DATA #1 : String, 41 bytes
Requesting system controller termination.
2006-09-23-02.00.03.697981+480 I632661857C395 LEVEL: Warning
PID : 13836
TID: 4160332352PROC : db2sysc 0
INSTANCE: yktinst1
NODE : 000
FUNCTION: DB2 UDB, routine_infrastructure, sqlerKillAllFmps, probe:5
MESSAGE : Bringing down all db2fmp processes as part of db2stop
DATA #1 : Hexdump, 4 bytes
0xFFFFB338 : 0000 0000
....
2006-09-23-02.00.03.698959+480 I632662253C304 LEVEL: Event
PID : 14303
TID: 4158190752PROC : db2stop2
INSTANCE: yktinst1
NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:260
DATA #1 : String, 43 bytes
System controller termination is completed.
2006-09-23-02.00.03.699339+480 I632662558C375 LEVEL: Event
PID : 14303
TID: 4158190752PROC : db2stop2
INSTANCE: yktinst1
NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:270
DATA #1 : String, 26 bytes
Active EDUs to be waited :
DATA #2 : Hexdump, 4 bytes
0xFFFFE7E0 : 0000 0002
....
2006-09-23-02.00.03.699866+480 I632662934C320 LEVEL: Severe
PID : 20316
TID: 4103738592PROC : db2fmp
INSTANCE: yktinst1
NODE : 000
FUNCTION: DB2 UDB, common communication, sqlccipcdarihandshake, probe:4
RETCODE : ZRC=0x800F00FC=-2146500356=SQLO_INV_PARM "Invalid input parameter"
2006-09-23-02.00.03.703649+480 I632663255C314 LEVEL: Warning
PID : 20316
TID: 4103738592PROC : db2fmp
INSTANCE: yktinst1
NODE : 000
MESSAGE : Thread of db2fmp terminated with nonzero rc
DATA #1 : Hexdump, 4 bytes
0xF49A0E40 : FFFF FB95
....
2006-09-23-02.00.03.711078+480 I632663570C373 LEVEL: Event
PID : 14303
TID: 4158190752PROC : db2stop2
INSTANCE: yktinst1
NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:280
DATA #1 : String, 24 bytes
There is no active EDUs.
DATA #2 : Hexdump, 4 bytes
0xFFFFE7E0 : 0000 0000
....
2006-09-23-02.00.03.857391+480 E632663944C301 LEVEL: Event
PID : 14303
TID: 4158190752PROC : db2stop2
INSTANCE: yktinst1
NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:911
MESSAGE : ADM7514WDatabase manager has stopped.
STOP: DB2 DBM
2006-09-23-02.00.04.055391+480 I632664246C1512LEVEL: Event
PID : 14329
TID: 4158190752PROC : db2start
INSTANCE: yktinst1
NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleStartStopSingleNode, probe:1130
DATA #1 : String, 41 bytes
/diskgrp/cur/yktinst1/sqllib/adm/db2star2
DATA #2 : Hexdump, 256 bytes
0xFFFFB358 : 2F64 6973 6B67 7270 2F63 7572 2F79 6B74/diskgrp/cur/ykt
0xFFFFB368 : 696E 7374 312F 7371 6C6C 6962 2F61 646Dinst1/sqllib/adm
0xFFFFB378 : 2F64 6232 7374 6172 3200 4E4F 4D53 4700/db2star2.NOMSG.
0xFFFFB388 : 0000 0000 0000 0000 0000 0000 0000 0000................
0xFFFFB398 : 0000 0000 0000 0000 0000 0000 0000 0000................
0xFFFFB3A8 : 0000 0000 0000 0000 0000 0000 0000 0000................
0xFFFFB3B8 : 0000 0000 0000 0000 0000 0000 0000 0000................
0xFFFFB3C8 : 0000 0000 0000 0000 0000 0000 0000 0000................
0xFFFFB3D8 : 0000 0000 0000 0000 0000 0000 0000 0000................
0xFFFFB3E8 : 0000 0000 0000 0000 0000 0000 0000 0000................
0xFFFFB3F8 : 0000 0000 0000 0000 0000 0000 0000 0000................
0xFFFFB408 : 0000 0000 0000 0000 0000 0000 0000 0000................
0xFFFFB418 : 0000 0000 0000 0000 0000 0000 0000 0000................
0xFFFFB428 : 0000 0000 0000 0000 0000 0000 0000 0000................
0xFFFFB438 : 0000 0000 0000 0000 0000 0000 0000 0000................
0xFFFFB448 : 0000 0000 0000 0000 0000 0000 0000 0000................
2006-09-23-02.00.03.701116+480 I632665759C382 LEVEL: Severe
PID : 13871
TID: 4158459936PROC : db2hmon
INSTANCE: yktinst1
NODE : 000
FUNCTION: DB2 UDB, routine_infrastructure, sqlerFmpThreadInit, probe:40
MESSAGE : Failure during FMP thread initialization
DATA #1 : Hexdump, 4 bytes
0xFFFFE53C : 0000 0036
...6
2006-09-23-02.00.04.208681+480 E632666142C907 LEVEL: Warning
PID : 14335
TID: 4158190144PROC : db2star2
INSTANCE: yktinst1
NODE : 000
FUNCTION: DB2 UDB, base sys utilities, LicCheckProcessors, probe:20
MESSAGE : ADM12017EThe number of processors on this machine exceeds the

defined entitlement of "1" for the product "DB2 企业服务器版". The

number of processors on this machine is "4". You should purchase

additional processor based entitlements from your IBM representative

or authorized dealer and update your license using the License Center

or the db2licm command line utility. For more information on updating

processor based licenses, refer to the Quick Beginnings manual for

your platform. For more information on the db2licm utility, refer to

the DB2 Command Reference.
2006-09-23-02.00.04.407109+480 I632667050C352 LEVEL: Severe
PID : 13871
TID: 4158459936PROC : db2hmon
INSTANCE: yktinst1
NODE : 000
FUNCTION: DB2 UDB, routine_infrastructure, sqlerFmpOneTimeInit, probe:100
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0xFFFFE584 : FFFF FBEE
....
2006-09-23-02.00.05.596263+480 E632667403C1154LEVEL: Event
PID : 14335
TID: 4158190144PROC : db2star2
INSTANCE: yktinst1
NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StartMain, probe:911
MESSAGE : ADM7513WDatabase manager has started.
START : DB2 DBM
DATA #1 : Build Level, 124 bytes
Instance "yktinst1" uses "32" bits and DB2 code release "SQL08022"
with level identifier "03030106".
Informational tokens are "DB2 v8.1.0.89", "OD_14086", "MI00107_14086", FixPak "9".
DATA #2 : System Info, 364 bytes
System: Linux CARD-CENTER1 6 2 ppc64
CPU: total:4 online:4
Physical Memory(MB): total:3828 free:1137
VirtualMemory(MB): total:12018 free:9327
Swap Memory(MB): total:8190 free:8190
Kernel Params: msgMaxMessageSize:8192 msgMsgMap:16384 msgMaxQueueIDs:1024

msgNumberOfHeaders:16384 msgMaxQueueSize:16384

msgMaxSegmentSize:16 shmMax:1073741824 shmMin:1 shmIDs:4096

shmSegments:4096 semMap:32000 semIDs:1024 semNum:32000

semUndo:32000 semNumPerID:250 semOps:32 semUndoSize:20

semMaxVal:32767 semAdjustOnExit:32767
2006-09-23-02.00.05.867602+480 I632668558C348 LEVEL: Severe
PID : 14340
TID: 4158459936PROC : db2bp
INSTANCE: yktinst1
NODE : 000
FUNCTION: DB2 UDB, database utilities, sqlubConnectDatabase, probe:1259
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0xF756EFA4 : FFFF FBF5
....
2006-09-23-02.00.05.867993+480 I632668907C328 LEVEL: Error
PID : 14340
TID: 4158459936PROC : db2bp
INSTANCE: yktinst1
NODE : 000
FUNCTION: DB2 UDB, database utilities, sqlubConnectDatabase, probe:1259
DATA #1 : Hexdump, 4 bytes
0xF756EFA4 : FFFF FBF5
....
2006-09-23-02.00.05.884468+480 E632669236C316 LEVEL: Error (OS)
PID : 14370
TID: 4160332352PROC : db2logmgr (YKTBASE) 0
INSTANCE: yktinst1
NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloexec2, probe:2
CALLED: OS, -, unspecified_system_functionOSERR: EINTR (4)
2006-09-23-02.00.05.886156+480 E632669553C513 LEVEL: Error
PID : 14370
TID: 4160332352PROC : db2logmgr (YKTBASE) 0
INSTANCE: yktinst1
NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgInvokeUserexit, probe:1140
MESSAGE : ADM1832EDB2 was unable to find the user exit program when archiving

log file "S0000287.LOG" from

"/diskgrp/cur/yktinst1/yktbase/yktinst1/NODE0000/SQL00001/SQLOGDIR/"

for database "YKTBASE".The error code was "24".
2006-09-23-02.00.05.886925+480 I632670067C422 LEVEL: Error
PID : 14370
TID: 4160332352PROC : db2logmgr (YKTBASE) 0
INSTANCE: yktinst1
NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogFile, probe:3160
MESSAGE : Failed to archive log file S0000287.LOG to USEREXIT from

/diskgrp/cur/yktinst1/yktbase/yktinst1/NODE0000/SQL00001/SQLOGDIR/

with rc = 24.
2006-09-23-02.00.05.890244+480 E632670490C317 LEVEL: Error (OS)
PID : 14370
TID: 4160332352PROC : db2logmgr (YKTBASE) 0
INSTANCE: yktinst1
NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloexec2, probe:2
CALLED: OS, -, unspecified_system_functionOSERR: ENOENT (2)
2006-09-23-02.00.05.891034+480 E632670808C494 LEVEL: Error
PID : 14370
TID: 4160332352PROC : db2logmgr (YKTBASE) 0
INSTANCE: yktinst1
NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgInvokeUserexit, probe:1140
MESSAGE : ADM1832EDB2 was unable to find the user exit program when archiving

log file "S0000287.LOG" from

"/diskgrp/nfsback/yktinst1/yktbase/log/NODE0000/" for database

"YKTBASE".The error code was "24".
2006-09-23-02.00.05.891274+480 I632671303C392 LEVEL: Error
PID : 14370
TID: 4160332352PROC : db2logmgr (YKTBASE) 0
INSTANCE: yktinst1
NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogFile, probe:3160
MESSAGE : Failed to archive log file S0000287.LOG to USEREXIT from

/diskgrp/nfsback/yktinst1/yktbase/log/NODE0000/ with rc = 24.
2006-09-23-02.00.05.891433+480 I632671696C314 LEVEL: Error
PID : 14370
TID: 4160332352PROC : db2logmgr (YKTBASE) 0
INSTANCE: yktinst1
NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchivePendingLogs, probe:1500
MESSAGE : Log archive failed with rc 24 for LOGARCHMETH1.
2006-09-23-02.00.05.951448+480 I632672011C1511LEVEL: Event
PID : 14414
TID: 4158190752PROC : db2stop
INSTANCE: yktinst1
NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleStartStopSingleNode, probe:1130
DATA #1 : String, 41 bytes
/diskgrp/cur/yktinst1/sqllib/adm/db2stop2
DATA #2 : Hexdump, 256 bytes
0xFFFFB428 : 2F64 6973 6B67 7270 2F63 7572 2F79 6B74/diskgrp/cur/ykt
0xFFFFB438 : 696E 7374 312F 7371 6C6C 6962 2F61 646Dinst1/sqllib/adm
0xFFFFB448 : 2F64 6232 7374 6F70 3200 4E4F 4D53 4700/db2stop2.NOMSG.
0xFFFFB458 : 464F 5243 4500 534E 0000 0000 0000 0000FORCE.SN........
0xFFFFB468 : 0000 0000 0000 0000 0000 0000 0000 0000................
0xFFFFB478 : 0000 0000 0000 0000 0000 0000 0000 0000................
0xFFFFB488 : 0000 0000 0000 0000 0000 0000 0000 0000................
0xFFFFB498 : 0000 0000 0000 0000 0000 0000 0000 0000................
0xFFFFB4A8 : 0000 0000 0000 0000 0000 0000 0000 0000................
0xFFFFB4B8 : 0000 0000 0000 0000 0000 0000 0000 0000................
0xFFFFB4C8 : 0000 0000 0000 0000 0000 0000 0000 0000................
0xFFFFB4D8 : 0000 0000 0000 0000 0000 0000 0000 0000................
0xFFFFB4E8 : 0000 0000 0000 0000 0000 0000 0000 0000................
0xFFFFB4F8 : 0000 0000 0000 0000 0000 0000 0000 0000................
0xFFFFB508 : 0000 0000 0000 0000 0000 0000 0000 0000................
0xFFFFB518 : 0000 0000 0000 0000 0000 0000 0000 0000................
2006-09-23-02.00.05.984611+480 I632673523C375 LEVEL: Event
PID : 14417
TID: 4158190752PROC : db2stop2
INSTANCE: yktinst1
NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:104
DATA #1 : String, 26 bytes
Force phase is in progress
DATA #2 : Hexdump, 4 bytes
0xFFFFE7CC : 0000 0000
....
2006-09-23-02.00.06.621325+480 I632673899C308 LEVEL: Event
PID : 14417
TID: 4158190752PROC : db2stop2
INSTANCE: yktinst1
NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:108
DATA #1 : String, 47 bytes
Force phase is completed and preparing to stop.
2006-09-23-02.00.06.621586+480 I632674208C378 LEVEL: Event
PID : 14417
TID: 4158190752PROC : db2stop2
INSTANCE: yktinst1
NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:210
DATA #1 : String, 29 bytes
Deactivate phase is bypassed.
DATA #2 : Hexdump, 4 bytes
0xFFFFE7D0 : 0000 0001
....
2006-09-23-02.00.06.621791+480 I632674587C398 LEVEL: Event
PID : 14417
TID: 4158190752PROC : db2stop2
INSTANCE: yktinst1
NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:230
DATA #1 : String, 49 bytes
Deactivate phase is completed, preparing to stop.
DATA #2 : Hexdump, 4 bytes
0xFFFFE7D0 : 0000 0001
....
2006-09-23-02.00.06.621986+480 I632674986C287 LEVEL: Event
PID : 14417
TID: 4158190752PROC : db2stop2
INSTANCE: yktinst1
NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:240
DATA #1 : String, 26 bytes
Stop phase is in progress.
2006-09-23-02.00.06.622170+480 I632675274C302 LEVEL: Event
PID : 14417
TID: 4158190752PROC : db2stop2
INSTANCE: yktinst1
NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:250
DATA #1 : String, 41 bytes
Requesting system controller termination.
2006-09-23-02.00.06.652530+480 I632675577C395 LEVEL: Warning
PID : 14350
TID: 4160332352PROC : db2sysc 0
INSTANCE: yktinst1
NODE : 000
FUNCTION: DB2 UDB, routine_infrastructure, sqlerKillAllFmps, probe:5
MESSAGE : Bringing down all db2fmp processes as part of db2stop
DATA #1 : Hexdump, 4 bytes
0xFFFFB358 : 0000 0000
....
2006-09-23-02.00.06.668279+480 I632675973C304 LEVEL: Event
PID : 14417
TID: 4158190752PROC : db2stop2
INSTANCE: yktinst1
NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:260
DATA #1 : String, 43 bytes
System controller termination is completed.
2006-09-23-02.00.06.668523+480 I632676278C373 LEVEL: Event
PID : 14417
TID: 4158190752PROC : db2stop2
INSTANCE: yktinst1
NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:280
DATA #1 : String, 24 bytes
There is no active EDUs.
DATA #2 : Hexdump, 4 bytes
0xFFFFE7E0 : 0000 0000
....
2006-09-23-02.00.06.761482+480 E632676652C301 LEVEL: Event
PID : 14417
TID: 4158190752PROC : db2stop2
INSTANCE: yktinst1
NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:911
MESSAGE : ADM7514WDatabase manager has stopped.
STOP: DB2 DBM
2006-09-23-02.00.06.835654+480 I632676954C1511LEVEL: Event
PID : 14424
TID: 4158190752PROC : db2stop
INSTANCE: yktinst1
NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleStartStopSingleNode, probe:1130
DATA #1 : String, 41 bytes
/diskgrp/cur/yktinst1/sqllib/adm/db2stop2
DATA #2 : Hexdump, 256 bytes
0xFFFFB2F8 : 2F64 6973 6B67 7270 2F63 7572 2F79 6B74/diskgrp/cur/ykt
0xFFFFB308 : 696E 7374 312F 7371 6C6C 6962 2F61 646Dinst1/sqllib/adm
0xFFFFB318 : 2F64 6232 7374 6F70 3200 4E4F 4D53 4700/db2stop2.NOMSG.
0xFFFFB328 : 534E 0000 0000 0000 0000 0000 0000 0000SN..............
0xFFFFB338 : 0000 0000 0000 0000 0000 0000 0000 0000................
0xFFFFB348 : 0000 0000 0000 0000 0000 0000 0000 0000................
0xFFFFB358 : 0000 0000 0000 0000 0000 0000 0000 0000................
0xFFFFB368 : 0000 0000 0000 0000 0000 0000 0000 0000................
0xFFFFB378 : 0000 0000 0000 0000 0000 0000 0000 0000................
0xFFFFB388 : 0000 0000 0000 0000 0000 0000 0000 0000................
0xFFFFB398 : 0000 0000 0000 0000 0000 0000 0000 0000................
0xFFFFB3A8 : 0000 0000 0000 0000 0000 0000 0000 0000................
0xFFFFB3B8 : 0000 0000 0000 0000 0000 0000 0000 0000................
0xFFFFB3C8 : 0000 0000 0000 0000 0000 0000 0000 0000................
0xFFFFB3D8 : 0000 0000 0000 0000 0000 0000 0000 0000................
0xFFFFB3E8 : 0000 0000 0000 0000 0000 0000 0000 0000................
2006-09-23-02.00.07.892446+480 I632678466C348 LEVEL: Severe
PID : 14433
TID: 4158459936PROC : db2bp
INSTANCE: yktinst1
NODE : 000
FUNCTION: DB2 UDB, database utilities, sqlubConnectDatabase, probe:1259
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0xF756EFA4 : FFFF FBF8
....
2006-09-23-02.00.07.892982+480 I632678815C328 LEVEL: Error
PID : 14433
TID: 4158459936PROC : db2bp
INSTANCE: yktinst1
NODE : 000
FUNCTION: DB2 UDB, database utilities, sqlubConnectDatabase, probe:1259
DATA #1 : Hexdump, 4 bytes
0xF756EFA4 : FFFF FBF8
....
2006-09-24-01.00.23.347967+480 I632679144C1512LEVEL: Event
PID : 24065
TID: 4158190752PROC : db2start
INSTANCE: yktinst1
NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleStartStopSingleNode, probe:1130
DATA #1 : String, 41 bytes
/diskgrp/cur/yktinst1/sqllib/adm/db2star2
DATA #2 : Hexdump, 256 bytes
0xFFFFB358 : 2F64 6973 6B67 7270 2F63 7572 2F79 6B74/diskgrp/cur/ykt
0xFFFFB368 : 696E 7374 312F 7371 6C6C 6962 2F61 646Dinst1/sqllib/adm
0xFFFFB378 : 2F64 6232 7374 6172 3200 4E4F 4D53 4700/db2star2.NOMSG.
0xFFFFB388 : 0000 0000 0000 0000 0000 0000 0000 0000................
0xFFFFB398 : 0000 0000 0000 0000 0000 0000 0000 0000................
0xFFFFB3A8 : 0000 0000 0000 0000 0000 0000 0000 0000................
0xFFFFB3B8 : 0000 0000 0000 0000 0000 0000 0000 0000................
0xFFFFB3C8 : 0000 0000 0000 0000 0000 0000 0000 0000................
0xFFFFB3D8 : 0000 0000 0000 0000 0000 0000 0000 0

千问 · 2005-10-30 17:05:33

整个23日的就没有日志了，就看到一个db2bp的命令报错了，就over了？

千问 · 2005-10-30 17:05:33

从日志看没看到你发backup命令阿

千问 · 2005-10-30 17:05:33

你的数据库归档参数怎么设置的？

千问 · 2005-10-30 17:05:33

是脚本进行备份数据库的，每天2：00开始自动执行！
每天都是好的，就23日出了问题？
部分备份的脚本：
BACKDIR=/diskgrp/back/yktbase
db2stop force
db2start
db2 > /dev/null 2>&1 <<!
backup database yktbase to $BACKDIR with 2 buffers buffer 1024 without prompting
quit
!
数据库参数：
Database Configuration for Database yktbase
Database configuration release level = 0x0a00
Database release level = 0x0a00
Database territory = cn
Database code page = 1208
Database code set = utf-8
Database country/region code = 86
Database collating sequence = BINARY
Alternate collating sequence (ALT_COLLATE) =
Database page size = 4096
Dynamic SQL Query management (DYN_QUERY_MGMT) = DISABLE
Discovery support for this database (DISCOVER_DB) = ENABLE
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 = NO
Log retain for recovery status = RECOVERY
User exit for logging status = YES
Data Links Token Expiry Interval (sec) (DL_EXPINT) = 60
Data Links Write Token Init Expiry Intvl(DL_WT_IEXPINT) = 60
Data Links Number of Copies (DL_NUM_COPIES) = 1
Data Links Time after Drop (days) (DL_TIME_DROP) = 1
Data Links Token in Uppercase (DL_UPPER) = NO
Data Links Token Algorithm (DL_TOKEN) = MAC0
Database heap (4KB) (DBHEAP) = 10240
Size of database shared memory (4KB) (DATABASE_MEMORY) = AUTOMATIC
Catalog cache size (4KB) (CATALOGCACHE_SZ) = 2048
Log buffer size (4KB) (LOGBUFSZ) = 2048
Utilities heap size (4KB) (UTIL_HEAP_SZ) = 4096
Buffer pool size (pages) (BUFFPAGE) = 4096
Extended storage segments size (4KB) (ESTORE_SEG_SZ) = 16000
Number of extended storage segments (NUM_ESTORE_SEGS) = 0
Max storage for lock list (4KB) (LOCKLIST) = 20480
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) = 128
Sort heap thres for shared sorts (4KB) (SHEAPTHRES_SHR) = 2000
Sort list heap (4KB) (SORTHEAP) = 4096
SQL statement heap (4KB) (STMTHEAP) = 2048
Default application heap (4KB) (APPLHEAPSZ) = 4096
Package cache size (4KB) (PCKCACHESZ) = 8192
Statistics heap size (4KB) (STAT_HEAP_SZ) = 4384
Interval for checking deadlock (ms) (DLCHKTIME) = 10000
Percent. of lock lists per application (MAXLOCKS) = 10
Lock timeout (sec) (LOCKTIMEOUT) = 60
Changed pages threshold (CHNGPGS_THRESH) = 60
Number of asynchronous page cleaners (NUM_IOCLEANERS) = 2
Number of I/O servers (NUM_IOSERVERS) = 5
Index sort flag (INDEXSORT) = YES
Sequential detect flag (SEQDETECT) = YES
Default prefetch size (pages) (DFT_PREFETCH_SZ) = 32
Track modified pages (TRACKMOD) = ON
Default number of containers = 1
Default tablespace extentsize (pages) (DFT_EXTENT_SZ) = 32
Max number of active applications (MAXAPPLS) = 80
Average number of active applications (AVG_APPLS) = 15
Max DB files open per application (MAXFILOP) = 64
Log file size (4KB) (LOGFILSIZ) = 1024
Number of primary log files (LOGPRIMARY) = 20
Number of secondary log files (LOGSECOND) = 10
Changed path to log files (NEWLOGPATH) =
Path to log files = /diskgrp/back/yktbase
/log/NODE0000/
Overflow log path (OVERFLOWLOGPATH) =
Mirror log path (MIRRORLOGPATH) = /diskgrp/nfsback/yktb
ase/log/NODE0000/
First active log file = S0044421.LOG
Block log on disk full (BLK_LOG_DSK_FUL) = YES
Percent of max active log space by transaction(MAX_LOG) = 50
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) = 120
Log retain for recovery enabled (LOGRETAIN) = RECOVERY
User exit for logging enabled (USEREXIT) = ON
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
First log archive method (LOGARCHMETH1) = USEREXIT
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) = 366
TSM management class (TSM_MGMTCLASS) =
TSM node name (TSM_NODENAME) =
TSM owner (TSM_OWNER) =
TSM password (TSM_PASSWORD) =
Automatic maintenance (AUTO_MAINT) = OFF
Automatic database backup (AUTO_DB_BACKUP) = OFF
Automatic table maintenance (AUTO_TBL_MAINT) = OFF
Automatic runstats (AUTO_RUNSTATS) = OFF
Automatic statistics profiling (AUTO_STATS_PROF) = OFF
Automatic profile updates (AUTO_PROF_UPD) = OFF
Automatic reorganization (AUTO_REORG) = OFF

千问 · 2005-10-30 17:05:33

你的日志不全,怎么到了24号凌晨才有db2start信息啊?
还是查查你的userexit.

千问 · 2005-10-30 17:05:33

从23日2点到24日1点的日志呢？怎么没有了：“