Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2003
    Posts
    51

    Unanswered: DB2 Version 10 - Replication Problem

    Hi guys,

    I'm upgrating my DB2 dbs, version 9.7 to DB2 v10.1.0.4.

    Problem : when I'm trying to start capture program, I'm getting :

    2014-09-30-16.27.53.261736 ASN0600I "Capture" : "" : "Initial" : Program "capture 10.1.3 (Build 10.1.0.4 Level s140509, PTF IP23577)" is starting.
    2014-09-30-16.27.56.234862 ASN0627E "Capture" : "ASN" : "Initial" : The program stopped because column "ARCH_LEVEL" is missing from the control table "IBMSNAP_CAPPARMS".
    2014-09-30-16.27.56.236749 ASN0008I CAPTURE "ASN" : "Initial". The Capture program was stopped.

    Reason : some of the replication control tables, have changed. This one, IBMSNAP_CAPPARMS, is an example of the change.

    Question : Is there a way , an automatic one, to upgrade all the replication's control table to version 10 ??

    Info :
    Old DB2 level --> v9.7.0.9

    New DB2 level --> v10.1.0.4

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Did you try the manual, by chance?

    http://www-01.ibm.com/support/knowle...u.html?lang=en
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Sep 2003
    Posts
    51
    Hi ,

    of course I tried .... If you want, I can post here a lot of links, explaining how to migrate control tables, CD and CCD tables. I can even, tell you all the columns, in control tables, that changed ... but ....

    I guees you did not understand the question I posted here .. It was : Is there a way , an automatic one, to upgrade all the replication's control table to version 10 ??

    The point, here, is the word : automatic !!!!

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    How's running a migration script not "automatic !!!!"? If that's not automatic enough, you can schedule it via cron or pay someone to run it for you.
    ---
    "It does not work" is not a valid problem statement.

Tags for this Thread

Posting Permissions

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