Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2004
    Posts
    26

    Exclamation Unanswered: Replication Betw DB2 7.1 db and DB2 8.1 FP6 db

    Hi, The issue I am having is probably a simple one since i cannot find anything on the web regarding the error I am getting.

    I have setup my replication on AIX and got as far as starting my apply program but get the following error in the ASN.IBMSNAP_APPLYTRACE table:

    ASN1016I APPLY "METPOL9_D". Refresh copying has been disabled. The error code is "5E1603".

    METPOL9_D is the name of my APPLY_Qualifier.

    Please advise, and inform me if any more info is needed reagrding the setup or environment.

  2. #2
    Join Date
    Nov 2004
    Posts
    374

    replication

    this means for registration (capture control tables) full refresh is not allowed.
    asn.ibmsnap_register..
    apply does want to refresh the table : for initial load or to get in synch or for any reason, and is not allowed to....
    Best Regards, Guy Przytula
    DB2/ORA/SQL Services
    DB2 DBA & Advanced DBA Certified
    DB2 Dprop Certified
    http://users.skynet.be/przytula/dbss.html

  3. #3
    Join Date
    Jun 2004
    Posts
    26

    Thumbs down Pass the initial problem

    I have new issue, I enabled Full refresh in the ASN.IBMSNAP_REGISTER table
    SET disable_refresh col to 0.

    I got pass the initial error but getting the error below

    ASN1001E APPLY "METPOL9_D". The Apply program encountered an SQL error. The ERRCODE is "650101". The SQLSTATE is "42601". The SQLCODE is "-104". The SQLERRM is "OPTIMIZE˙PI060" WHERE (NULL)˙<comp_op> <quantifier> <subquery>". The SQLERRP is "SQLNP012". The server name is "". The table name is "DATA.TMPI060".

    In short, all I would like to know is, is DB2 v7.1 compatible with DB2 v8.1 replication. Is there anybody who has managed to get it working across different versions.

    I know there is a difference in architecture but will that cause for the replication not to work.

Posting Permissions

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