I am trying to recover a client's data hosted on an iSeries server. It is very probably a DB2. There are 2000+ tables to transfer. I have access with jdbc and tried with DBeaver (which gives the best results) but there are some problems:
- DBeaver stops as soon as one table can't be transferred for whatever reason so I have to retry the whole transfer after skipping that table (you don't seem to be able to ignore the errors and continue the transfer, importing as much as possible).
- I have at least one table that aborts (with "lost connection") after 13 hours although if I export the table in CSV with other tools it completes successfully in a few minutes. All machines are on the same local network and there is no network issue, we tried several times and it always fails on this not-so-big table)
Exporting with other means (like CSV) is a real pain (files are EBCDIC encoded, not real CSV but rather fixed-length... Not viable on that number of tables)
Maybe an even simpler solution would be to use a Postgresql FDW (Foreign Data Wrapper) but I don't know if such a driver exists (maybe via jdbc?)
I would love to be able to use a "backup" of the DB but I haven't found a way to use these SAVF files out of an iSeries machine.
This will be a 2-shot export (first one to understand the data structure and prepare for the final migration while the client still uses the legacy system and second one for the final migration).
So I'm looking for a repeatable and reliable (and ideally free or low cost) solution to extract the data.
