Skip to Content
0
Former Member
May 12, 2010 at 07:20 AM

Backup not finished

86 Views

Hi All,

I am working on Db2 database, windows server,ecc6.0

Daily we take full offline backup by morning it will finsh. But today it not finished , no user is able to login ,showing popup database not connected . so i restarted server now it is fine. But i not able to find problem why backup is not finished.

in sm21 log report shows

02:05:49 DIA 000 000 SAPSYS BY M SQL error -1224. Work processes in reconnect status

02:06:33 DIA 001 BV 4 Work process is in reconnect status

02:06:33 DIA 002 BV 4 Work process is in reconnect status

02:06:33 DIA 000 BV 4 Work process is in reconnect status

02:06:34 SPO 013 BV 4 Work process is in reconnect status

02:06:41 DIA 003 BV 4 Work process is in reconnect status

02:07:52 BTC 009 900 BUSER BV 4 Work process is in reconnect status

02:07:52 BTC 009 900 BUSER BZ Y Unexpected return value 29 when calling up DbSl

02:07:52 BTC 009 900 BUSER F6 H Database error: TemSe->XRTAB(3)->4 for table TST01 key

02:07:52 BTC 009 900 BUSER D0 1 Transaction Canceled TS 004 ( XRTAB#3#4#TST01 # )

02:07:52 BTC 009 900 BUSER BZ Y Unexpected return value 29 when calling up DbSl

02:07:52 BTC 009 900 BUSER BZ Y Unexpected return value 29 when calling up DbSl

02:07:52 BTC 009 900 BUSER BZ Y Unexpected return value 29 when calling up DbSl

02:07:52 BTC 009 900 BUSER EA Y Failed to read status entry for job DBA:BACKUP_DEV______@020514/3007

02:07:52 BTC 009 900 BUSER EB C > Job DBA:BACKUP_DEV______@020514/3007

02:07:52 BTC 009 900 BUSER BZ Y Unexpected return value 29 when calling up DbSl

02:07:52 BTC 009 900 BUSER F6 H Database error: TemSe->XRTAB(3)->4 for table TST01 key XRTAB#3#4#TST01 #

02:29:58 DIA 004 BV 4 Work process is in reconnect status

02:31:59 DIA 005 BV 4 Work process is in reconnect status

09:20:34 RD Q0 I Operating system call recv failed (error no. 10054)

09:58:03 RD Q0 I Operating system call recv failed (error no. 10054)

please suggest me how to proceed.

Regards

Shashi