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^Ç^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