Hi all,
i am working on windows server db2 database ecc6.0 version
Daily we will take off line full backup.
normally backup will finish by 8 morning
today i face that backup not taken and database stop.. no user able to login in sap. showing popup database not connected.
db2diag.log report shows as below
2010-05-15-02.05.26.906000+330 I222579519F370 LEVEL: Severe
PID : 772 TID : 1252 PROC : dmdb6bkp.exe
INSTANCE: DB2TRP NODE : 000
FUNCTION: DB2 UDB, database utilities, sqlubConnectDatabase, probe:1280
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0x00000000055F12E0 : F5FB FFFF ....
2010-05-15-02.05.26.921000+330 I222579891F349 LEVEL: Error
PID : 772 TID : 1252 PROC : dmdb6bkp.exe
INSTANCE: DB2TRP NODE : 000
FUNCTION: DB2 UDB, database utilities, sqlubConnectDatabase, probe:1280
DATA #1 : Hexdump, 4 bytes
0x00000000055F12E0 : F5FB FFFF ....
2010-05-15-02.05.27.328000+330 I222580242F1664 LEVEL: Event
PID : 2468 TID : 4052 PROC : DB2STOP.EXE
INSTANCE: DB2TRP NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleStartStopSingleNode, probe:1130
DATA #1 : String, 39 bytes
C:\PROGRA~1\IBM\SQLLIB\bin\DB2STOP2.EXE
DATA #2 : Hexdump, 256 bytes
0x000000000012A890 : 433A 5C50 524F 4752 417E 315C 4942 4D5C C:\PROGRA~1\IBM\
0x000000000012A8A0 : 5351 4C4C 4942 5C62 696E 5C44 4232 5354 SQLLIB\bin\DB2ST
0x000000000012A8B0 : 4F50 322E 4558 4500 4E4F 4D53 4700 464F OP2.EXE.NOMSG.FO
0x000000000012A8C0 : 5243 4500 534E 0000 0000 0000 0000 0000 RCE.SN..........
0x000000000012A8D0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x000000000012A8E0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x000000000012A8F0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x000000000012A900 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x000000000012A910 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x000000000012A920 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x000000000012A930 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x000000000012A940 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x000000000012A950 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x000000000012A960 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x000000000012A970 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x000000000012A980 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
2010-05-15-02.05.27.453000+330 I222581908F395 LEVEL: Event
PID : 188 TID : 3272 PROC : db2syscs.exe
INSTANCE: DB2TRP 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
0x0000000023A7FE7C : 0000 0000 ....
2010-05-15-02.05.40.859000+330 I222582305F318 LEVEL: Event
PID : 188 TID : 3272 PROC : db2syscs.exe
INSTANCE: DB2TRP NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:108
DATA #1 : String, 47 bytes
Force phase is completed and preparing to stop.
2010-05-15-02.05.40.859000+330 I222582625F398 LEVEL: Event
PID : 188 TID : 3272 PROC : db2syscs.exe
INSTANCE: DB2TRP 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
0x0000000023A7FE98 : 0100 0000 ....
2010-05-15-02.05.40.859000+330 I222583025F418 LEVEL: Event
PID : 188 TID : 3272 PROC : db2syscs.exe
INSTANCE: DB2TRP 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
0x0000000023A7FE98 : 0100 0000 ....
2010-05-15-02.05.40.875000+330 I222583445F297 LEVEL: Event
PID : 188 TID : 3272 PROC : db2syscs.exe
INSTANCE: DB2TRP NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:240
DATA #1 : String, 26 bytes
Stop phase is in progress.
2010-05-15-02.05.40.875000+330 I222583744F312 LEVEL: Event
PID : 188 TID : 3272 PROC : db2syscs.exe
INSTANCE: DB2TRP NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:250
DATA #1 : String, 41 bytes
Requesting system controller termination.
2010-05-15-02.05.41.234000+330 I222584058F413 LEVEL: Warning
PID : 188 TID : 1992 PROC : db2syscs.exe
INSTANCE: DB2TRP 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
0x0000000003F8F7C0 : 0000 0000 ....
2010-05-15-02.05.41.656000+330 I222584473F333 LEVEL: Warning
PID : 1160 TID : 1064 PROC : db2fmp64.exe
INSTANCE: DB2TRP NODE : 000
MESSAGE : Thread of db2fmp terminated with nonzero rc
DATA #1 : Hexdump, 4 bytes
0x0000000003C6FED8 : 95FB FFFF ....
2010-05-15-02.05.41.656000+330 I222584808F333 LEVEL: Warning
PID : 1160 TID : 2072 PROC : db2fmp64.exe
INSTANCE: DB2TRP NODE : 000
MESSAGE : Thread of db2fmp terminated with nonzero rc
DATA #1 : Hexdump, 4 bytes
0x0000000003B5FED8 : 95FB FFFF ....
2010-05-15-02.05.41.718000+330 I222585143F314 LEVEL: Event
PID : 188 TID : 3272 PROC : db2syscs.exe
INSTANCE: DB2TRP NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:260
DATA #1 : String, 43 bytes
System controller termination is completed.
2010-05-15-02.05.41.718000+330 I222585459F393 LEVEL: Event
PID : 188 TID : 3272 PROC : db2syscs.exe
INSTANCE: DB2TRP 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
0x0000000023A7FE90 : 0000 0000 ....
2010-05-15-02.05.49.265000+330 E222585854F311 LEVEL: Event
PID : 188 TID : 3272 PROC : db2syscs.exe
INSTANCE: DB2TRP NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:911
MESSAGE : ADM7514W Database manager has stopped.
STOP : DB2 DBM
2010-05-15-02.05.49.531000+330 I222586167F1665 LEVEL: Event
PID : 3268 TID : 3444 PROC : DB2START.EXE
INSTANCE: DB2TRP NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleStartStopSingleNode, probe:1130
DATA #1 : String, 39 bytes
C:\PROGRA~1\IBM\SQLLIB\bin\DB2STAR2.EXE
DATA #2 : Hexdump, 256 bytes
0x000000000012A8E0 : 433A 5C50 524F 4752 417E 315C 4942 4D5C C:\PROGRA~1\IBM\
0x000000000012A8F0 : 5351 4C4C 4942 5C62 696E 5C44 4232 5354 SQLLIB\bin\DB2ST
0x000000000012A900 : 4152 322E 4558 4500 4E4F 4D53 4700 0000 AR2.EXE.NOMSG...
0x000000000012A910 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x000000000012A920 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x000000000012A930 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x000000000012A940 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x000000000012A950 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x000000000012A960 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x000000000012A970 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x000000000012A980 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x000000000012A990 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x000000000012A9A0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x000000000012A9B0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x000000000012A9C0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x000000000012A9D0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
2010-05-15-10.48.46.706000+330 I222587834F1665 LEVEL: Event
PID : 2584 TID : 2640 PROC : db2start.exe
INSTANCE: DB2TRP NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleStartStopSingleNode, probe:1130
DATA #1 : String, 39 bytes
C:\PROGRA~1\IBM\SQLLIB\bin\DB2STAR2.EXE
DATA #2 : Hexdump, 256 bytes
0x000000000012A8E0 : 433A 5C50 524F 4752 417E 315C 4942 4D5C C:\PROGRA~1\IBM\
0x000000000012A8F0 : 5351 4C4C 4942 5C62 696E 5C44 4232 5354 SQLLIB\bin\DB2ST
0x000000000012A900 : 4152 322E 4558 4500 4E4F 4D53 4700 0000 AR2.EXE.NOMSG...
0x000000000012A910 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x000000000012A920 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x000000000012A930 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x000000000012A940 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x000000000012A950 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x000000000012A960 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x000000000012A970 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x000000000012A980 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x000000000012A990 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x000000000012A9A0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x000000000012A9B0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x000000000012A9C0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x000000000012A9D0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
please suggest me the problem
Thanks in advance
Shashi