At my work, we use an application with a DB2 9.7 FixPack 4 database backend. There is some poking around I'd like to do with the data, however, not being an experienced database user, I feel uncomfortable with accessing the database directly. The database does create a nightly backup though.
I was wondering if there's any way of taking that nightly backup and restoring it to a separate server, running DB2 Express-C. I really only need access to the tables, I don't care about the procedures or views or anything else, I just want to be able to run some queries against the tables in the database.
Any help would be appreciated!
NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
This topic has been locked.
1 reply Latest Post - 2012-07-09T21:14:56Z by SystemAdmin
Pinned topic Can I restore a DB2 9 database to a DB2 Express database?
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-07-09T21:14:56Z at 2012-07-09T21:14:56Z by SystemAdmin
SystemAdmin 110000D4XK5837 PostsACCEPTED ANSWER
Re: Can I restore a DB2 9 database to a DB2 Express database?2012-07-09T21:14:56Z in response to JF9Y_Mathew_PattersonHello,
I have never tried, but I would believe it is possible, as long as your backup was not taken from a DPF database.
The best thing to do is to try :-).