Skip to Content
0
Former Member
May 15, 2010 at 06:29 AM

Backup problem

139 Views

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