DpropR V7.1

Jim Tobin

DpropR V7.1
Hello,

Has anyone using IBM DB2 Data Propagator V7.1 migrating to V8.2 ever
heard of an Analyzer Tool (pre-V8)?

The only info I found:

"From IBM manual "Migrating to SQL Replication Version 8", SC18-9413-00,
page 34: "Running the Analyzer (z/OS) Run the Analyzer tool (pre-Version
8) from a workstation. Use the resulting report to validate the data in
your control tables. Determine whether there are any problem
registrations or subscription sets. If there are, remove them or fix
them before you migrate. If you attempt to migrate while your
replication environment is not set up correctly, the migration might
fail."
Where is the info on the Analyzer Tool? I can't find anything in the
migration manual except for this. I opened an ETR with IBM in the
meantime. Thanks.

Regards,
Jim Tobin
Online and Database Systems Programming Support
(973) 533-2637
[login to unmask email]



---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Tim R Ohling

Re: DpropR V7.1
(in response to Jim Tobin)
It's the command asnanalyze.

It should be in your documentation. I did a quick search on the web and
found only V8 references handy!

The redbook "A Practical Guide to DB2 UDB Data Replication V8" may also
help.

HTH,
Tim


________________________________

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Tobin, Jim
Sent: Monday, December 04, 2006 11:50 AM
To: [login to unmask email]
Subject: [DB2-L] DpropR V7.1



Hello,

Has anyone using IBM DB2 Data Propagator V7.1 migrating to V8.2 ever
heard of an Analyzer Tool (pre-V8)?

The only info I found:

"From IBM manual "Migrating to SQL Replication Version 8", SC18-9413-00,
page 34: "Running the Analyzer (z/OS) Run the Analyzer tool (pre-Version
8) from a workstation. Use the resulting report to validate the data in
your control tables. Determine whether there are any problem
registrations or subscription sets. If there are, remove them or fix
them before you migrate. If you attempt to migrate while your
replication environment is not set up correctly, the migration might
fail."

Where is the info on the Analyzer Tool? I can't find anything in the
migration manual except for this. I opened an ETR with IBM in the
meantime. Thanks.

Regards,
Jim Tobin
Online and Database Systems Programming Support
(973) 533-2637
[login to unmask email]


------------------------------------------------------------------------
--------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the
archives and home page at http://www.idugdb2-l.org/archives/db2-l.html.
From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences
at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Jim Tobin

Re: DpropR V7.1
(in response to Tim R Ohling)
Tim,

Thanks for your reply. I also found commands ASNANALYZE (V8) and ANALYZE
(V7) to invoke the tool, but from DB2 Connect PE on my desktop. Here's
IBM's reply to my PMR (the full story):

"This question has been raised by other customers, and the main reason

why there isn't much information in the Replication manuals, is
because this tool is provided with UDB.
.
Let me include an excerpt from another PMR , where L2 provided a
brief description and location.
=======================
The analyzer tool shows the contents of the DProp control tables, and
also provides some additional information on the DProp setup
in an html format. In V7, we used the 'analyze' command to get this
report, in V8 we use the 'asnanalyze' command.
.
Do you have a V7 DB2 on any workstation? If you do, then the
analyze.exe and analyze.bnd files should be under /sqllib/bin and
/sqllib/bnd directories.
=======================
.
Now here are some of the reasons why the Analyzer tool (which was
previously available via a tool download) is no longer downloadable.
.
The V7 Analyzer is no longer available on the web for two reasons:
1) The Replication Analyzer is included with DB2 Universal Database V7.
For our z/OS customers, it's supposed to be part of the DB2 Connect PE
they get with their DProp. (believe there was a problem with this at
one point, so a customer might not have it.)
2) Our V7 on UNIX, Windows, and z/OS went out of out of service on
(30 Sept 2004)."

Regards,
Jim Tobin
Online and Database Systems Programming Support
(973) 533-2637
[login to unmask email]


________________________________

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Ohling, Tim R
Sent: Monday, December 04, 2006 2:55 PM
To: [login to unmask email]
Subject: Re: [DB2-L] DpropR V7.1


It's the command asnanalyze.

It should be in your documentation. I did a quick search on the web and
found only V8 references handy!

The redbook "A Practical Guide to DB2 UDB Data Replication V8" may also
help.

HTH,
Tim


________________________________

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Tobin, Jim
Sent: Monday, December 04, 2006 11:50 AM
To: [login to unmask email]
Subject: [DB2-L] DpropR V7.1



Hello,

Has anyone using IBM DB2 Data Propagator V7.1 migrating to V8.2 ever
heard of an Analyzer Tool (pre-V8)?

The only info I found:

"From IBM manual "Migrating to SQL Replication Version 8", SC18-9413-00,
page 34: "Running the Analyzer (z/OS) Run the Analyzer tool (pre-Version
8) from a workstation. Use the resulting report to validate the data in
your control tables. Determine whether there are any problem
registrations or subscription sets. If there are, remove them or fix
them before you migrate. If you attempt to migrate while your
replication environment is not set up correctly, the migration might
fail."

Where is the info on the Analyzer Tool? I can't find anything in the
migration manual except for this. I opened an ETR with IBM in the
meantime. Thanks.

Regards,
Jim Tobin
Online and Database Systems Programming Support
(973) 533-2637
[login to unmask email]


------------------------------------------------------------------------
--------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the
archives and home page at http://www.idugdb2-l.org/archives/db2-l.html.
From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences
at http://conferences.idug.org/index.cfm
------------------------------------------------------------------------
--------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the
archives and home page at http://www.idugdb2-l.org/archives/db2-l.html.
From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences
at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm