Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Database comparison of two similar kind of databases

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
Subhu_Chatterbox

New User


Joined: 25 Feb 2010
Posts: 12
Location: Hyd

PostPosted: Fri Feb 26, 2010 4:15 pm    Post subject: Database comparison of two similar kind of databases
Reply with quote

I am having two similar kind of database one is of development and another is of production.
And they are out of synch, lots of data mismatches are there..
I have 2 ideas for that
1. unload those tables into flat files and compare through 3.12. But this is pretty lenghty
2. write query for each table

Is there any other way which we can do for the entire database?or some utility?
Back to top
View user's profile Send private message

Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Fri Feb 26, 2010 4:23 pm    Post subject:
Reply with quote

What your DBAs have to say on that?
Back to top
View user's profile Send private message
PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2422
Location: Netherlands, Amstelveen

PostPosted: Fri Feb 26, 2010 4:26 pm    Post subject:
Reply with quote

Similar tables ? Or are they the same ?
Production tables are always leading, so get those production
tables into your development environment.
Why would one want to know the difference in data between
production and development?
Back to top
View user's profile Send private message
Bharath Bhat

Active User


Joined: 20 Mar 2008
Posts: 283
Location: chennai

PostPosted: Fri Feb 26, 2010 4:35 pm    Post subject:
Reply with quote

I do not worry about data difference between prod and dev. I just unload prod data and refresh dev tables whenever I need proper data.
Back to top
View user's profile Send private message
Subhu_Chatterbox

New User


Joined: 25 Feb 2010
Posts: 12
Location: Hyd

PostPosted: Fri Feb 26, 2010 5:06 pm    Post subject:
Reply with quote

We don't have access to refresh I guess. Being a support team member, we just need to make one report of discrepancies.
So is there anyway of comparing these two as a whole? any utility for this?
Back to top
View user's profile Send private message
Subhu_Chatterbox

New User


Joined: 25 Feb 2010
Posts: 12
Location: Hyd

PostPosted: Fri Feb 26, 2010 5:08 pm    Post subject:
Reply with quote

PeterHolland wrote:
Similar tables ? Or are they the same ?


They are same, but some data needs to be different, as per requirement.
Back to top
View user's profile Send private message
PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2422
Location: Netherlands, Amstelveen

PostPosted: Fri Feb 26, 2010 5:24 pm    Post subject:
Reply with quote

I hope we are talking DB2 tables here, if thats the case (and why can i find that info?) try the following manual :

IBM DB2 Object Comparison Tool for z/OS SC18-9554-08

at :

http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/topic/com.ibm.db2tools.gou.doc.ug/gocugd24.pdf?noframes=true
Back to top
View user's profile Send private message
Subhu_Chatterbox

New User


Joined: 25 Feb 2010
Posts: 12
Location: Hyd

PostPosted: Fri Feb 26, 2010 5:27 pm    Post subject:
Reply with quote

Thanks Peter it helps icon_smile.gif
Back to top
View user's profile Send private message
tomehta

New User


Joined: 18 Aug 2008
Posts: 98
Location: India

PostPosted: Fri Mar 05, 2010 3:04 pm    Post subject:
Reply with quote

Hi Peter,
the tool seems to give compare the definiton of Db2 objects,
is there a way it can be used to compare the data in the application tables. Say I have to compare the data between a prod and a parallel environment table.

thanks
Back to top
View user's profile Send private message
Subhu_Chatterbox

New User


Joined: 25 Feb 2010
Posts: 12
Location: Hyd

PostPosted: Fri Mar 05, 2010 3:13 pm    Post subject:
Reply with quote

yes in case where refreshing is not possible....can anyone suggest any DB2 utility?
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Fri Mar 05, 2010 8:29 pm    Post subject:
Reply with quote

Hello,

Unload both. Use SPUERC to compare the unloaded data.

Keep n mind that if there is anything in the data that is related to current date and/or time, the compare will show this as a mis-match.

If you need a custom coparison, you will need to implement a custom process.
Back to top
View user's profile Send private message
daveporcelan

Active Member


Joined: 01 Dec 2006
Posts: 645
Location: Pennsylvania

PostPosted: Fri Mar 05, 2010 8:48 pm    Post subject:
Reply with quote

We use IBM Optim (formerly PST), but it costs money.

It works great, and you can tell it to ignore timestamps during the compare.

I still do not understand why you would need to know or even care that production and test data is out of sync.

Even if you were to generate a report, by the time someone looked at it, it would be obsolete.

If a batch job or cics transaction ran against either set of data, the results of the report are inaccurate. What then?

This seams to me to be an excerise in futility.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts IMS Database backup info ashek15 IMS DB/DC 14 Wed Nov 16, 2016 5:29 am
No new posts CICS NEW SIT PARAMETERS CICS BEHAVIOR... Kyle Carroll CICS 0 Fri Nov 04, 2016 11:55 pm
No new posts Getting list of tables defined under ... kishpra DB2 2 Wed Aug 24, 2016 10:36 am
No new posts 24x7 online logs using DSN1LOGP (simi... SRICOBSAS DB2 3 Thu Aug 18, 2016 11:52 am
No new posts Database access from COBOL amitmahalkar DB2 1 Wed Jan 27, 2016 11:33 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us