'Duplicate' a DB2 database for testing.

[Welshbird]

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.

Fee

The question should be [red]Is it worth trying to do?[/red] not [blue] Can it be done?[/blue]

 

[AlexCuse]

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,

Alex

[small]----signature below----[/small]
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

 

[Welshbird]

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.

Fanks,

Fee

The question should be [red]Is it worth trying to do?[/red] not [blue] Can it be done?[/blue]