Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2003
    Posts
    4

    Unhappy Unanswered: capture failed due to error ASN0001E

    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.

  2. #2
    Join Date
    Feb 2003
    Posts
    20

    Re: capture failed due to error ASN0001E

    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).

  3. #3
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: capture failed due to error ASN0001E

    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
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  4. #4
    Join Date
    Nov 2003
    Posts
    4

    Talking

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •