473,574 Members | 2,927 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Apply Program Not Moving Data

Having a bear of a time trying to implement replication under 8.2
environment. I've created all of the control structures on both source
and target database and can actually see data being staged in the CD
tables. I look at the subscription sets and see that everything seems
to be pointing to the right tables, etc., and see that apply is
running. The apply log states that the program is running, but nothing
is moving. The only diagnostics that it has are the values of the
startup parameters and messages that is sleeping for 5 minutes. It's
running 8.2 FP9 under AIX 5.3.

I gave up on trying to replicate my real data, and created two simple
databases, with one table having only 1 column. Status of the
subscription set is 0. Both DBs are running under the same instance. I
used the Replication center to get everything kicked off, but was
unable to get apply to start from there and instead launched it from
the command line as: nohup asnapply CONTROL_SERVER= TRGT APPLY_QUAL=AAA
APPLY_PATH="/home/db2inst4" &

Have looked through the supplied documentation and the Redbook for
replication, but didn't find any clues. Hoping someone else here has
seen this before.

Evan
Apply log:

2005-08-03-07.51.41.054929 <setEnvDprRIB > ASN8003D "Apply" : "" :
"Initial" : Program "apply 8.2.0" is starting.
2005-08-03-07.51.43.126290 <asnParmClass:: printParms> ASN0529I "Apply"
: "AAA" : "Initial" : The value of "CONTROL_SERVER " was set to "TRGT"
at startup by the following method: "COMMANDLIN E".
2005-08-03-07.51.43.126734 <asnParmClass:: printParms> ASN0529I "Apply"
: "AAA" : "Initial" : The value of "APPLY_QUAL " was set to "AAA" at s
tartup by the following method: "COMMANDLIN E".
2005-08-03-07.51.43.126762 <asnParmClass:: printParms> ASN0529I "Apply"
: "AAA" : "Initial" : The value of "LOGREUSE" was set to "N" at start
up by the following method: "DEFAULT".
2005-08-03-07.51.43.126790 <asnParmClass:: printParms> ASN0529I "Apply"
: "AAA" : "Initial" : The value of "LOGSTDOUT" was set to "N" at star
tup by the following method: "DEFAULT".
2005-08-03-07.51.43.126817 <asnParmClass:: printParms> ASN0529I "Apply"
: "AAA" : "Initial" : The value of "TERM" was set to "Y" at startup b
y the following method: "DEFAULT".
2005-08-03-07.51.43.126844 <asnParmClass:: printParms> ASN0529I "Apply"
: "AAA" : "Initial" : The value of "PWDFILE" was set to "" at startup
by the following method: "DEFAULT".
2005-08-03-07.51.43.126870 <asnParmClass:: printParms> ASN0529I "Apply"
: "AAA" : "Initial" : The value of "APPLY_PATH " was set to "/home/db2
inst4/" at startup by the following method: "COMMANDLIN E".
2005-08-03-07.51.43.126897 <asnParmClass:: printParms> ASN0529I "Apply"
: "AAA" : "Initial" : The value of "NOTIFY" was set to "N" at startup
by the following method: "DEFAULT".
2005-08-03-07.51.43.126923 <asnParmClass:: printParms> ASN0529I "Apply"
: "AAA" : "Initial" : The value of "SLEEP" was set to "Y" at startup
by the following method: "DEFAULT".
2005-08-03-07.51.43.126950 <asnParmClass:: printParms> ASN0529I "Apply"
: "AAA" : "Initial" : The value of "ERRWAIT" was set to "300" at star
tup by the following method: "DEFAULT".
2005-08-03-07.51.43.126976 <asnParmClass:: printParms> ASN0529I "Apply"
: "AAA" : "Initial" : The value of "COPYONCE" was set to "N" at start
up by the following method: "DEFAULT".
2005-08-03-07.51.43.127004 <asnParmClass:: printParms> ASN0529I "Apply"
: "AAA" : "Initial" : The value of "TRLREUSE" was set to "N" at start
up by the following method: "DEFAULT".
2005-08-03-07.51.43.127030 <asnParmClass:: printParms> ASN0529I "Apply"
: "AAA" : "Initial" : The value of "SPILLFILE" was set to "DISK" at s
tartup by the following method: "DEFAULT".
2005-08-03-07.51.43.127056 <asnParmClass:: printParms> ASN0529I "Apply"
: "AAA" : "Initial" : The value of "LOADXIT" was set to "N" at startu
p by the following method: "DEFAULT".
2005-08-03-07.51.43.127088 <asnParmClass:: printParms> ASN0529I "Apply"
: "AAA" : "Initial" : The value of "SQLERRCONTINUE " was set to "N" at
startup by the following method: "DEFAULT".
2005-08-03-07.51.43.127115 <asnParmClass:: printParms> ASN0529I "Apply"
: "AAA" : "Initial" : The value of "OPT4ONE" was set to "N" at startu
p by the following method: "DEFAULT".
2005-08-03-07.51.43.127141 <asnParmClass:: printParms> ASN0529I "Apply"
: "AAA" : "Initial" : The value of "DELAY" was set to "6" at startup
by the following method: "DEFAULT".
2005-08-03-07.51.43.127167 <asnParmClass:: printParms> ASN0529I "Apply"
: "AAA" : "Initial" : The value of "INAMSG" was set to "Y" at startup
by the following method: "DEFAULT".
2005-08-03-07.51.43.166193 <Asnenv:setEnvI pcQRcvHdl> ASN0594I "Apply"
: "AAA" : "Initial" The program created an IPC queue with keys "(0x300
0004d)".
2005-08-03-07.51.43.167428 <CPCIMPC(08/07)> ASN1045I APPLY "AAA" :
"Initial". The Apply program was started using database "TRGT".
2005-08-03-07.51.43.190577 <CPREST(01/00)> ASN1044I APPLY "AAA" :
"WorkerThre ad". The Apply program will become inactive for "5" minutes
and
"0" seconds.

Nov 12 '05 #1
4 2995
After running the asnanalyze command on the target database where apply
is running, it reported an "inconsiste ncy between IBMSNAP_SUBS_ME MBER
and IBMSNAP_REGISTE R tables." It found my subscription in the former,
but not the latter and had remarks of "Orphan Subscription."

There is no IBM_REGISTER in the target database, but there is one in
source database where capture is running. That table contains one row
for the table I want replicated, and another row that has blanks for
the SOURCE_OWNER and SOURCE_TABLE columns.

I couldn't find any reference in the docs or on the web for "orphan
subscriptions." Has anyone else seen this?

Thanks,
Evan

Nov 12 '05 #2
Hi,

esmith2112 schrieb:
subscription set is 0. Both DBs are running under the same instance. I
used the Replication center to get everything kicked off, but was
unable to get apply to start from there and instead launched it from
the command line as: nohup asnapply CONTROL_SERVER= TRGT APPLY_QUAL=AAA
APPLY_PATH="/home/db2inst4" &

Have looked through the supplied documentation and the Redbook for
replication, but didn't find any clues. Hoping someone else here has
seen this before.


I remember having a lot of problems using replication center and went
for the manual approach as well. Have you created the asnpwd.aut file
and are the connections working?

check with

"asnanalyze -pw $pathtopassword file/asnpwd.aut -db $sourcedb $targetdb
-la DETAILED"

This produces a html-file you can view with any browser. The script
should run on both servers without any errors. If you have decided to
switch automatic full refreshes to off, search

http://www.ibm.com/support for "manual full refresh". There is a nice
article dated 2004-05-17, called

"How do I perform a manual full refresh for update-anywhere replication
instead of using the Apply program to do the full refresh?"

Works for user-copy scenarios as well.

Possibly you have decided to do manual full refreshs and did not set the
member-state to "L" or the appropriate synchtime, synchpoint in
ibmsnap_subs_se t..just a guess

regards,

Norbert
Nov 12 '05 #3
Hi,

esmith2112 schrieb:
After running the asnanalyze command on the target database where apply
is running, it reported an "inconsiste ncy between IBMSNAP_SUBS_ME MBER
and IBMSNAP_REGISTE R tables." It found my subscription in the former,
but not the latter and had remarks of "Orphan Subscription."

There is no IBM_REGISTER in the target database, but there is one in
source database where capture is running. That table contains one row
for the table I want replicated, and another row that has blanks for
the SOURCE_OWNER and SOURCE_TABLE columns.
There should be a corresponding row in ibmsnap_subs_me mbr in the target
database (or the database where the apply control tables resides). If it
is not, your replication setup is just incomplete.
I couldn't find any reference in the docs or on the web for "orphan
subscriptions." Has anyone else seen this?


Yes. Whenever corresponding entries in both capture control and apply
control tables do not match. The detailed asnanalyze output gives some
hints what needs to be where.

Hard to guess just by this few information.

regards,

Norbert

--
off for a Pint

Nov 12 '05 #4
I misspoke in an earlier post. I hadn't run the asnanalyze program with
both the source and target database options simultaneously. Once I did
that, the "orphan subscription" message went away.

I found the document on manually refreshing the data. I did that, but
it still leaves me with a bunch of rows in the CD tables that aren't
getting propagated.

Is there a definitive guide to DB2 replication published anywhere? I
found a book on Amazon, but since it was published in 1999, I have a
feeling that it's a little out of date. Even the Redbook for
replication in version 8 is approaching 3 years. Is it possible that
it's out of date as well?

Does this warrant a call to support? It doesn't seem like a technical
problem, but more of a logical problem where there's a step missing.

Nov 12 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
2581
by: Peter Nolan | last post by:
Hi All, I have written some software that performs ETL processing to load data warehouses. Each program accepts a set of parameters and returns 0 or 1 to the win/unix shell to indicate success or failure. Currently it is run as a set of commands that calls each program and then returns the return code and stops if the program has failed. ...
3
3139
by: Blaise Garant | last post by:
Hi I've made a stylesheet to transform my data into XSL-FO. This stylesheet used to work with MSXSL 4.0 but I've got some issues in ..NET. First, I changed removed all the "node-set()" function since they're not used anymore. But now, I used an <xsl:apply-templates/> and for some reason, it works in some situation but not in others. I...
1
2974
by: Trent | last post by:
Hello,everyone. I'm setting a db2 replication environment using UDB version 8.1.5 running on Windows 2000 servers. The source server is on a Windows server with the capture program running while the target server is on another Windows server running the apply program. This replication set up has a mix of bidirectional and unidirection data...
3
3145
by: almousawi | last post by:
I am working on a DB2 replication program that used to work. I ran the "warm" capture program to get a cold start and I am running the apply program, but, the apply does not replicate the data. I update a test table and I see that the CD table gets new rows. But the apply program does not seem to be doing anything .. I see the asnapply is...
0
1831
by: BC3Tech | last post by:
I'm creating a system that uses XML to store an audit trail of the steps that it has been through in the system. The way the schema is defined, there is a "Tag" for every application that performs modifications to any data, and "Fields" inside the tag that outline the changes that were made. Applications in the flow of the system read in...
0
1641
by: mdb_1974 | last post by:
Hello I tried to do an initial full refresh but I failed - nothing happens (no error at all). Apply works without errors. Details of my environment: I have the following replication scenario: DB2 UDB apply is running on a Solaris machine (DB2 Version 8, fixpack 9a), capture on a z/OS machine (host).
9
3083
by: axs221 | last post by:
I am trying to move some of our large VBA Access front-end file into ActiveX DLL files. I created two DLL files so far, one was a module that contains code to integrate into the QuickBooks accounting software. Another has general utilities. I tried referencing the utilities dll, and it shows up in the object explorer. I instantiated an...
34
29843
by: Tom | last post by:
I'd greatly appreciate advice and code snippets on how to create a ram disk within a C/C++ program. I also need to be able to determine the free space. Thanks in advance for any help.
0
2494
by: metaperl | last post by:
A Comparison of Python Class Objects and Init Files for Program Configuration ============================================================================= Terrence Brannon bauhaus@metaperl.com http://www.livingcosmos.org/Members/sundevil/python/articles/a-comparison-of-python-class-objects-and-init-files-for-program-configuration/view
0
7726
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
8053
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
8237
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7817
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
8098
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
6454
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
5622
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
3741
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
1
1341
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.