Results 1 to 4 of 4
  1. #1
    Join Date
    May 2007
    Posts
    56

    Unanswered: Data Replication - Apply pull

    I'm having problems with an old DB2 V7.1 DProp.
    I setup the initial environment using Control Center where I defined source tables and subscriptions. It worked fine, replicating tables between 2 AIX (DB2) servers. Capture and Apply ran on source server. All ASN tables were defined at source server. Now I'm planing to implement a big replication and I am planing to run Apply Pull (at target server). I started Capture with COLD NOPRUNE, and when I started apply at target side I got the following error:
    RGRS: global control record not found.
    CPMSGF: msg catalog is /db2owner/sqllib/msg/en_US/asnapply.cat
    MSGF: MsgNumber is 54.
    The NLS msg is ASN1054S: The Apply program could not find the registration information for source owner DB2OWNER, source table
    STAFF, source view qualifier 0..

    I dropped (as suggested on message of this problem) register table and recreated again but still got the problem.
    If I stop everything and start both capture and apply (push) on source server works fine. What should I do? There is no deep explanation or books that I can look for an answer.
    Thanks

  2. #2
    Join Date
    Jun 2006
    Posts
    471
    in new scenario : verify
    the control server : db keeping asn control tables
    this server is specified in apply startup
    apply needs connection to source-control and target server
    you can always start the apply from command window with additional parameter trcflow and rerout the output to a file. this will show the action and error
    verify that subs_set table keeps correct source and target server
    Best Regards, Guy Przytula
    DB2 UDB LUW certified V6/7/8

  3. #3
    Join Date
    May 2007
    Posts
    56
    Guy,
    I started both capture and apply from command line window (unix) and for scenario 1 (apply push) worked fine. So I stopped both and restarted capture (source server) and apply (now from target server) with option trcflow. I can see apply connecting to source server pulling out the first subscrption and when apply connects back to target gets the error. I'm cutting/paste few lines form the trace:
    ly program compiled at 23:34:21 on May 10 2000 (Level 70108p)
    Apply qualifier is DB2OWNER.
    Control srvr name is SAMPACT.
    Issue Sleep msg.
    Will not invoke ASNLOAD.
    Will not invoke ASNDONE.
    LOGREUSE is specified
    IMSG: Instance name is db2owner.
    IMSG: The log file name is DB2OWNER.APP.
    INIT: file DB2OWNER.PWD is opened
    CEXPC: connect to SAMPACT
    CEXPC: serverIsolationUR is 1. isMvsServer is 0.
    CEXPC: (B)
    CIMPC: serverIsolationUR is 1.
    CIMPC: The local_srvr is SAMPACT.
    ABIND: sqlca.sqlcode is 0
    CIMPC: Userid is DB2OWNER
    INVV: app_qual is DB2OWNER, PID is 6326.
    INVV: pidfile is /tmp/ASNAPPLYDB2OWNER.PID
    CPMSGF: msg catalog is /db2owner/sqllib/msg/en_US/asnapply.cat
    MSGF: MsgNumber is 45.
    The NLS msg is ASN1045I: The Apply program was started using database SAMPACT..
    --- Process next subscription (1) ---
    CEXPC: connect to SAMPACT
    ABIND: sqlca.sqlcode is 0
    CPGCST: Control server timestamp is 2007-05-29-13.21.25.913026
    R1NES: No eligible named event subscription at this moment
    Compiled(P) at 23:34:22 on May 10 2000 (Level 70108p)
    CPGCI: numKeys is 1
    GMI: set type is READ_ONLY
    -------------------
    set_info
    -------------------
    ACTIVATE = 1
    APPLY_QUAL = DB2OWNER
    SET_NAME = STAFF_T1
    WHOS_ON_FIRST = S
    SOURCE_SERVER = SAMPLE
    SOURCE_ALIAS = SAMPLE
    TARGET_SERVER = SAMPLE
    TARGET_ALIAS = PASSIVE
    STATUS = -1
    LASTRUN = 2007-05-29-12.23.46.631181
    REFRESH_TIMING = R
    SLEEP_MINUTES = 2
    EVENT_NAME = null
    LASTSUCCESS = 2007-05-29-08.03.24.000000
    SYNCPOINT = null
    AUX_STMTS = 2
    ARCH_LEVEL = 0201
    -------------------------
    stmt_info i = 0
    -------------------------
    BEFORE_OR_AFTER = A
    STMT_NUMBER = 5
    EI_OR_CALL = E
    SQL_STMT = delete from asn.ibmsnap_applytrail where lastrun < current timestamp - 2 days
    ACCEPT_SQLSTATES = 02000^&#199;^A^]
    -------------------------
    stmt_info i = 1
    -------------------------
    BEFORE_OR_AFTER = A
    STMT_NUMBER = 6
    EI_OR_CALL = E
    SQL_STMT = delete from asn.ibmsnap_trace where trace_time < current timestamp - 2 days
    ACCEPT_SQLSTATES = 02000
    -------------------------
    mem_info i = 0
    -------------------------
    SOURCE_OWNER = DB2OWNER
    SOURCE_TABLE = STAFF
    SOURCE_VIEW_QUAL = 0
    TARGET_OWNER = DB2OWNER
    TARGET_TABLE = STAFF
    TARGET_CONDENSED = Y
    TARGET_COMPLETE = Y
    TARGET_STRUCTURE = 8
    PREDICATES = null
    -------------------------
    col_info i = 0
    -------------------------
    COL_TYPE = A
    TARGET_NAME = ID
    IS_KEY = Y
    COLNO = 0
    EXPRESSION = ID
    -------------------------
    col_info i = 1
    >>>> Now is when the problem occurs:
    -------------------------
    PSET: Commit1 ok
    CEXPC: connect to SAMPLE
    CEXPC: serverIsolationUR is 1. isMvsServer is 0.
    CEXPC: (B)
    ABIND: sqlca.sqlcode is 0
    CPGSST: Source server timestamp is 2007-05-29-14.21.27.657533
    LCKTB:1 cntinue=1; pLockNotFound=0
    LCKTB:2 cntinue=1
    RGRS: global control record not found.
    CPMSGF: msg catalog is /db2owner/sqllib/msg/en_US/asnapply.cat
    MSGF: MsgNumber is 54.
    The NLS msg is ASN1054S: The Apply program could not find the registration information for source owner DB2OWNER, source table
    STAFF, source view qualifier 0..
    CPRDSRC: No register table entry for SOURCE_OWNER = DB2OWNER, SOURCE_TABLE= STAFF, SOURCE_VIEW_QUAL = 0
    PSET: ROLLBACK

    What could be the problem?
    Thanks

  4. #4
    Join Date
    May 2007
    Posts
    56
    Just to update this forum:
    The fix was changing both source and target alias names on ASN.IBMSNAP_SUBS_SET. Thanks.

Posting Permissions

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