[z/OS] [Not Using] IBM DB2 Object Compare

Philip Sevetson

[z/OS] [Not Using] IBM DB2 Object Compare
I am not, I think, a notably slow or poor student. I have used BMC Change Manager, and after three days of training back in 1995, I was capable of using it to drive DB2 object change management in extremely complex projects at three different employers. I have heard from multiple customers that CA RC/Compare is (was?) a similarly useful tool.

I have also _tried_ to use IBM's DB2 Object Comparison Tool. Despite multiple presentations by IBM reps over several years, I have (1) never seen, let alone attended, a class of any length which taught about the tool; (2) never seen, let alone read, a manual which described using the OC Tool in a way that I could then turn around and use myself to generate comprehensible results. For an example of an incomprehensible "tutorial" about part of the OC Tool, I commend you to this link in the Knowledge Center:
https://www.ibm.com/support/knowledgecenter/SSAUVH_12.1.0/topics/gocutmsk0.html

Does anyone have a positive experience of the OC tool? Can you recommend a walkthrough or manual which actually teaches the reader to use OC for real tasks like comparing the contents of two DBs or two Schemas? I'm _this_ close to swearing that it can't be done and recommending that my management drop the tool - it's no better for me to have an unusable tool than to have none at all.

--Phil
**This e-mail, including any attachments, may be confidential, privileged, or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy, or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.**

Jørn Thyssen

RE: [z/OS] [Not Using] IBM DB2 Object Compare
(in response to Philip Sevetson)

Hi Phil,

Please reach out to me off-list. Me or one of my colleagues can walk you through how to use the tool.

I also have an upcoming blog post on how to drive OCT in batch if you prefer JCL over ISPF.

Best regards,

Jørn Thyssen

Rocket Software
77 Fourth Avenue • Waltham, MA • 02451 • USA
E: [login to unmask email] • W: www.rocketsoftware.com 

2019 IBM Champion.

Views are personal. 

Alan Gredell

RE: [z/OS] [Not Using] IBM DB2 Object Compare
(in response to Philip Sevetson)

I am 100% with you, Phil.  For years, I used CA (actually, Platinum) tools for such compares, found it clear and simple to use. My current employer has eschewed all CA products (I hear that they're possibly coming back, YEA!!!) for IBM tools, and I can't make heads or tails out of the documentation for Object Compare, though I have mastered many of the others.

And contacting you off line to "read you in" kind of misses the point.  The did a pretty crummy job with this tool. 

Philip Sevetson

[z/OS] [Not Using] IBM DB2 Object Compare
(in response to Alan Gredell)
Alan,

I’m unhappy about the way OCT is currently documented. Since I can’t make it work, I’m not sure whether it is a good tool or not!

Jorn is going to work with me next week, and is working on a presentation about the product, so there may yet be hope. If I can make heads-or-tails out of it with his help, I’ll try to write something up myself and do a clearer job, possibly for a basic subset like “How to generate a DDL Version” and “How to compare two DDL Versions”.

We badly need the ability to compare in depth across subsystems and schemas, so I’m willing to do this before trying the heavy lift involved in convincing management to change products.

--Phil

From: Alan Gredell [mailto:[login to unmask email]
Sent: Monday, January 28, 2019 10:01 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: [z/OS] [Not Using] IBM DB2 Object Compare


I am 100% with you, Phil. For years, I used CA (actually, Platinum) tools for such compares, found it clear and simple to use. My current employer has eschewed all CA products (I hear that they're possibly coming back, YEA!!!) for IBM tools, and I can't make heads or tails out of the documentation for Object Compare, though I have mastered many of the others.

And contacting you off line to "read you in" kind of misses the point. The did a pretty crummy job with this tool.

-----End Original Message-----
**This e-mail, including any attachments, may be confidential, privileged, or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy, or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.**

Jørn Thyssen

RE: [z/OS] [Not Using] IBM DB2 Object Compare
(in response to Alan Gredell)

Hi Alan,

I will admit the ISPF panels can be somewhat confusing. We're well aware of that and addressing this is important especially as the mainframe skilled people slowly dwindle away.

I personally prefer to drive the compare from a (simple) JCL that just needs minor edits between each run rather than using the ISPF panels.

My offer to Phil also extends to you: I can send the current draft of an upcoming blog post as well as help you with the tool over web-ex or a face-to-face meeting if you're in Europe.



In Reply to Alan Gredell:

I am 100% with you, Phil.  For years, I used CA (actually, Platinum) tools for such compares, found it clear and simple to use. My current employer has eschewed all CA products (I hear that they're possibly coming back, YEA!!!) for IBM tools, and I can't make heads or tails out of the documentation for Object Compare, though I have mastered many of the others.

And contacting you off line to "read you in" kind of misses the point.  The did a pretty crummy job with this tool. 



 

Best regards,

Jørn Thyssen

Rocket Software
77 Fourth Avenue • Waltham, MA • 02451 • USA
E: [login to unmask email] • W: www.rocketsoftware.com 

2018 IBM Champion.

Views are personal.