Problem Dropping Members from a Replication Set
Originally posted: 2007 May 21 04:36 AM
9200Phil
Post new reply
Hi
I'm trying to drop a number of tables from a replication set.
Environment:
DB21085I Instance "db2ods" uses "64" bits and DB2 code release
"SQL08024" with
level identifier "03050106".
Informational tokens are "DB2 v8.1.1.104", "s060120", "U805924", and
FixPak
"11".
Product is installed at "/usr/opt/db2_08_01".
AIX 5.2 rml4
Replicaction environment was migrated to V8 from V7 - many months ago
I might add and has been working successfully.
I have done the following to drop the objects:
1. Issued CAPSTOP for each of the tables to be removed
After CAPSTOP has been processed by Capture:
2. In apply: De-actived the members to be dropped. ie Set member_state
to D in ASN.IBMSNAP_SUBS_MEMBR for the relevant tables
3. Stopped Apply
In Capture Control Tables:
4. Deleted rows from ASN.IBMSNAP_REGISTER & ASN.IBMSNAP_PRUNCNTL
Dropped CD Tables
In Apply Control Tables
5. Deleted the rows from ASN.IBMSNAP_SUBS_COLS and
ASN.IBMSNAP_SUBS_MEMBR
Restarted Apply
On Restart the following occurs:
In the .TRC file:
SAT: APPERRM is ASN1054E APPLY "EAI2MISQ1" : "WorkerThread". The Apply
program could not find a row in the IBMSNAP_REGISTER or IB
MSNAP_PRUNCNTL table that corresponds to the subscription set member
with a set name "EAI2MISS1", for source owner "EAI", source t
able "VD_CUSTOMER", and source view qualifier "1".
CPRDSRC: No register table entry for SOURCE_OWNER = GAM, SOURCE_TABLE=
VD_CUSTOMER, SOURCE_VIEW_QUAL = 1
SAT: ASNLOAD is null
SAT: FULL_REFRESH is null
SAT: SET_INSERTED = 0
SAT: SET_DELETED = 0
SAT: SET_UPDATED = 0
SAT: SET_REWORKED = 0
SAT: SET_REJECTED_TRXS = 0
SAT: STATUS = -1
SAT: LASTRUN = 2007-05-21-08.24.01.484509
SAT: LASTSUCCESS = 2007-05-21-08.23.12.809407
SAT: SYNCHPOINT is 4651498f000000010000
SAT: SYNCHTIME is 2007-05-21-07.26.07.000000
SAT: SOURCE_ALIAS is OIP
SAT: SOURCE_SERVER is OIP
SAT: SOURCE_OWNER is GAM
SAT: SOURCE_TABLE is VD_CUSTOMER
SAT: TARGET_ALIAS is MIS
SAT: TARGET_SERVER is MIS
SAT: TARGET_OWNER is GAM
SAT: TARGET_TABLE is CUSTOMER
SAT: SQLSTATE is null
SAT: SQLERRM is null
SAT: SQLCODE is null
SAT: SQLERRP is null
In ASN.IBMSNAP_APPLY_TRAIL:
db2 "select * from asn.ibmsnap_applytrail order by lastrun desc with
ur " | pg
APPLY_QUAL SET_NAME SET_TYPE WHOS_ON_FIRST ASNLOAD FULL_REFRESH
EFFECTIVE_MEMBERS SET_INSERTED SET_DELETED SET_UPDATED SET_REWORKED
SET_REJECTED_TRXS STATUS LASTRUN LASTSUCCESS SYNCHPOINT SYNCHTIME
SOURCE_SERVER SOURCE_ALIAS SOURCE_OWNER SOURCE_TABLE SOURCE_VIEW_QUAL
TARGET_SERVER TARGET_ALIAS TARGET_OWNER TARGET_TABLE CAPTURE_SCHEMA
TGT_CAPTURE_SCHEMA FEDERATED_SRC_SRVR FEDERATED_TGT_SRVR JRN_LIB
JRN_NAME COMMIT_COUNT OPTION_FLAGS EVENT_NAME ENDTIME SOURCE_CONN_TIME
SQLSTATE SQLCODE SQLERRP SQLERRM APPERRM
------------------ ------------------ -------- ------------- -------
------------ ----------------- ------------ ----------- -----------
------------ ----------------- ------ --------------------------
-------------------------- -----------------------
-------------------------- ------------------ ------------
------------------------------
--------------------------------------------------------------------------------------------------------------------------------
---------------- ------------------ ------------
------------------------------
--------------------------------------------------------------------------------------------------------------------------------
------------------------------ ------------------------------
------------------ ------------------ ---------- ----------
------------ ------------ ------------------
-------------------------- -------------------------- --------
----------- --------
----------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
EAI2MISQ1 EAI2MISS1 R S - - - 0 0 0 0 0 -1 2007-05-21-08.24.01.484509
2007-05-21-08.23.12.809407 x'4651498F000000010000'
2007-05-21-07.26.07.000000 OIP - GAM VD_CUSTOMER 1 MIS - EAI CUSTOMER
ASN ASN - - - - - NNNN - 2007-05-21-08.24.01.610647
2007-05-21-08.24.01.544292 - - - - ASN1054E APPLY "EAI2MISQ1" :
"WorkerThread". The Apply program could not find a row in the
IBMSNAP_REGISTER or IBMSNAP_PRUNCNTL table that corresponds to the
subscription set member with a set name "EAI2MISS1", for source owner
"EAI", source table "VD_CUSTOMER", and source view qualifier "1".
As the rows have been deleted in the Capture Control tables:
Where is apply getting it's information from regards these rows to
'know' they're missing - as they've been dropped from both the Capture
and Apply tables????