Hi,guys,

Does any one have any sense about below information?
it caused capture failed several times one day,but after restarted it,it
was back to normal and worked fine.
Very appreciate your help!

************************************************** ********
2004-01-07-22:07:50 ASN0001: (E) The Capture program encountered an SQL error. The routine name is log_io; the SQL request is a call to DB2's sqlurlog that should have returned data but did not; the table name is ASN.IBMSNAP_TRACE; the SQLCODE is 0; the SQLERRML is ; the SQLERRMC is .


2004-01-07-22:07:50
2004-01-07-22:07:50 ASN0001: (E) The Capture program encountered an SQL error. The routine name is insert_trace(); the SQL request is INSERT INTO; the table name is ASN.IBMSNAP_TRACE; the SQLCODE is 0; the SQLERRML is 1; the SQLERRMC is 2.


2004-01-07-22:07:50
2004-01-07-22:07:50 (I) The highest log sequence number of a successfully captured log record is 0000000000A26EBF6988.

What Release level are you in? If you are using V7, then there was a bug which was fixed in Fixpack 9(I think). If you haven't then apply the latest fixpack (11).

I agree with Anil ...

Replication capture was pretty unstable with FP7 ... Had loads of problems like the one you mention

It's cool with FP9

Cheers
Sathyaram

Thanks for your reply!
the db2 version is db2 6.1 for os/2 with fixpack 11