Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / DB2 Topics / July 2004

Tip: Looking for answers? Try searching our database.

db2 replication

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
ann - 28 Jul 2004 09:33 GMT
I have problem with replication db2 database.
Program Capture view error ASN5150W and ASN0059W.
What i doing wrong?
Knut Stolze - 28 Jul 2004 10:57 GMT
> I have problem with replication db2 database.
> Program Capture view error ASN5150W and ASN0059W.
> What i doing wrong?

What's the DB2 version and platform you are using?
What are you actually doing?

The error messages say the following:

$ db2 "? asn5150w"

ASN5150W MONITOR "<monitor_qualifier>". The program
         "<program_name>" is not running. The server is
         "<server_name>", and the schema is "<schema>".

Explanation:

The alert condition STATUS indicates that the program specified
in this message is not running.

User Response:

Verify the status of the program on the specified server.

$ db2 "? asn0059w"

ASN0059W CAPTURE "<capture_schema>". The SYNCHPOINT field in the
         IBMSNAP_PRUNCNTL table is not zeros for the CAPSTART of
         subscription with MAP_ID "<map_id>".

Explanation:

When the Apply program signals a full refresh to the Capture
program, the Apply program inserts a row for the CAPSTART signal
in the IBMSNAP_SIGNAL table. At the same time, the SYNCHPOINT
column of the IBMSNAP_PRUNCNTL table is set to hex zeroes. The
Capture program then responds to the Apply program to confirm
that the Capture program received the CAPSTART signal, as
follows: the Capture program sets the value for the SYNCHPOINT
column in the IBMSNAP_PRUNCNTL table to the number of the log
sequence that corresponds to the CAPSTART log record.  Because
the Apply program set the value in the SYNCHPOINT column to hex
zeroes, the Apply program checks if a nonzero value has been
inserted by the Capture program. The Capture program updates the
value for SYNCHPOINT, even if the value was not hex zeroes.
However, if the value for SYNCHPOINT is not hex zeroes, the
Capture program issues this warning that the value it found was
not expected.

This warning can occur if you issue the APPLY CAPSTART signal
yourself and do not completely simulate the actions of the Apply
program.

User Response:

This message is for your information only, and no action is
required.

What that means for you, I do not know because we have no details on your
scenario.

Signature

Knut Stolze
Information Integration
IBM Germany / University of Jena

ann - 28 Jul 2004 12:24 GMT
> > I have problem with replication db2 database.
> > Program Capture view error ASN5150W and ASN0059W.
[quoted text clipped - 56 lines]
> What that means for you, I do not know because we have no details on your
> scenario.

It was 1.8.2 on Win2000, but on 1.8.5 replication is working :) hmmm..
Thanks

Ann
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.