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: "COMMANDLINE".
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: "COMMANDLINE".
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: "COMMANDLINE".
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:setEnvIpcQRcvHdl> 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" :
"WorkerThread". The Apply program will become inactive for "5" minutes
and
"0" seconds.