Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

'Duplicate' a DB2 database for testing.

'Duplicate' a DB2 database for testing.

'Duplicate' a DB2 database for testing.

Hi Guys,

We have a DB2 database sitting on a mainframe in Europe, and we want to make ourselves a local copy of this. The purpose is part familiarisation and part QA and testing.

We have zero budget to do this.

We have no way of using ODBC to do a 'replication' of the database, so we will be using a text dump and load on a daily basis.

Our options are to use a 2 gig workspace on Oracle (which actually isn't local but is also in Europe) or to use a MySQL database which we are running locally.

Does anyone have any thoughts on this? I'm wondering really which of these will enable us to run queries which could then be run directly on the mainframe if required, so I guess SQL compliance is important to us.

Any general thoughts you lot might have would be appreciated.


The question should be Is it worth trying to do? not Can it be done?

RE: 'Duplicate' a DB2 database for testing.

Have you thought about the DB2 express edition?  This would probably be your best option if you want to be able to run the same queries against the mainframe.

Hope this helps,


----signature below----
With all due respect, Don Bot, I don't think we should rely on an accident happening. Let's kill him ourselves.

Ignorance of certain subjects is a great part of wisdom

RE: 'Duplicate' a DB2 database for testing.

I haven't - but I will now! I've sent a link to the techie guy here to ask him to install somewhere that we can have a test.

Good idea.



The question should be Is it worth trying to do? not Can it be done?

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close