Compare DB2 table in both TEST and Prod regions,

All sort of Mainframes Interview Questions.
Forum rules
Post Reply
Prasad
New Member
Posts: 7
Joined: Fri Mar 28, 2014 8:38 pm

Compare DB2 table in both TEST and Prod regions,

Post by Prasad »

I have one interview question if anybody knows answer:

There is a DB2 table in both TEST and Prod regions,

I wanted to compare both and restore test table with prod wherever it is not matching.

How can we do in COBOL-DB2 Program?
Top
User avatar
Anuj Dhawan
Founder
Posts: 2802
Joined: Sun Apr 21, 2013 7:40 pm
Location: Mumbai, India
Contact:
Contact Anuj Dhawan
India

Re: Compare DB2 table in both TEST and Prod regions,

Post by Anuj Dhawan »

One easy way to do that is - unload DB2 tables to datasets. Bring them to a single given region - either to Prod or Test. Now it's a two-file comparison situation.
Thanks,
Anuj

Disclaimer: My comments on this website are my own and do not represent the opinions or suggestions of any other person or business entity, in any way.
Top
Post Reply

Create an account or sign in to join the discussion

You need to be a member in order to post a reply

Create an account

Not a member? register to join our community
Members can start their own topics & subscribe to topics
It’s free and only takes a minute

Register

Sign in

Return to “Interview Questions.”