If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > Data Replication - Apply pull

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 05-30-07, 09:07
rmarzullo rmarzullo is offline
Registered User
 
Join Date: May 2007
Posts: 56
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
Reply With Quote
  #2 (permalink)  
Old 05-30-07, 09:32
guyprzytula guyprzytula is offline
Registered User
 
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
Reply With Quote
  #3 (permalink)  
Old 05-30-07, 10:14
rmarzullo rmarzullo is offline
Registered User
 
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
Reply With Quote
  #4 (permalink)  
Old 05-30-07, 15:42
rmarzullo rmarzullo is offline
Registered User
 
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.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On