All geek questions in one place

Can I reset a DB2 database on an AS400 to Windows or Linux?

The years have passed since I worked with DB2, but I just inherited an outdated application that reads / writes to DB2 via JDBC and runs on AS400. I still don't have many details on the platform or versions, but I wonder if it is even possible to copy a copy of the database on Windows or Linux version of DB2? The application accesses data on a very slow channel, and I would like to be able to cut a copy of the database for local development. Used JDBC driver:

com.ibm.as400.access.AS400JDBCDriver

If this helps ...

Any / all answers are appreciated!

Update: I only found out that the version of DB2 is 7.1 and the platform is iSeries (do I need to request additional information about the platform?)

~~ Cheers ~~

+4
source share
1 answer

If you install iSeries Navigator (at least a database component), you can expand the required schema (or schemas) and select the option “Generate SQL” for various types of objects that SQL recognizes. Then SQL can be ported to any DBMS that you will use.

Of course, this is separate from any data. And there is a significant chance that many objects will not make any sense for any other platform. There is little chance that the "database" will not make much sense on another platform. This will depend on how long the database has existed (it may precede SQL), how progressive the developers have been over the years, how many advantages they have had for the platform functions, etc.

0
source

Source: https://habr.com/ru/post/1435087/

More articles:


All Articles