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