Re: Migrating IBM i database files to DB2 LUW -- MIDRANGE-L

date: Wed, 4 Nov 2015 00:07:51 -0500
from: Charles Wilt <charles.wilt@xxxxxxxxx>
subject: Re: Migrating IBM i database files to DB2 LUW

IBM Data Movement Toolkit?

http://www.ibm.com/developerworks/data/library/techarticle/dm-0906datamovement/

Charles

That toolkit sounds like a good idea to check out, if you're budget can

handle it.

I'd probably do this, if the target turns out to be a Windows server, but
it requires some MS Access skill:

- Install Microsoft Access on the target DB2 on Windows server.
- Create an ODBC connection to the source DB2 on i system database.
- Create a local ODBC connection to the target, local DB2 for Windows
database.
- Use Access to create a set of ODBC Linked Tables for all the tables in
your source database schema(s). You can run this step in bulk in Access.
- Use IBM i Navigator "Generate SQL" feature to generate all the SQL to
create all your target database schema objects.
- Run the Navigator generated SQL script(s) on the DB2 for Windows
server to create your target database objects.
- Use Access to create a set of ODBC Linked Tables for all the tables in
your target database schema(s). You can run this step in bulk in Access.
- Using Access, for each table, using VBA, generate and execute an SQL
statement to:
- insert into TARGET_LINKED_TABLE select * from SOURCE_LINKED_TABLE
- In this respect, MS Access can work like 3 part SQL does on the IBM
i database to transparently transfer data across systems.
- I doubt the code to do this step would exceed about 30 lines of VBA
code to migrate the entire database.
- I anticipate that would work extremely well, if your database doesn't
have special columns like LOBs. Special columns like that might give you
some grief, but that's just a guess on my part.

I wouldn't use MS Access to build an industrial strength, production grade
application, but it works very well as conduit between databases for a task
like a migration, if the network connection is fast to each database. If
the network connection is slow to either database (i.e. over a WAN), I
probably wouldn't use this technique, unless the database was a small one.

Mike

On Tue, Nov 3, 2015 at 8:48 PM, <dr2@xxxxxxxx> wrote:

Depending on table size, and a bunch of other items, I might be tempted

to

do a quick csv dump on the iseries side, ftp the table to the target and
then do an import at the target. Used this to do oracle
migrations/refreshes on AIX and it works like a champ.

DR2

I don't have all the details yet, but I have an associate who needs to

migrate data from an AS/400 - iSeries - IBM i system to a DB2 LUW
database,
most likely running on a Windows server.

I am not yet sure which version of either platform yet, but can anyone
provide what options are available which do NOT require the $$$$ DB2
Connect
feature on the midrange side?

-sjl

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

------------------------------

message: 6
date: Wed, 4 Nov 2015 08:01:31 -0500
from: Darryl Freinkel <dhfreinkel@xxxxxxxxx>
subject: What version of the JVM should I use to run HSSF and
XLPARSER4?

I am developing some code to read xlsx spreadsheets and write the contents
to the database.

I am developing the code on a V5.4 system and will promote it to run on a
v7.1 system.

Is there an issue requiring the POI 3.6 version to run on a specific
version of Java?

TIA

--
Darryl Freinkel

------------------------------

message: 7
date: Wed, 4 Nov 2015 14:06:45 +0000
from: Richard Schoen <Richard.Schoen@xxxxxxxxxxxxxxx>
subject: Java and .Net in the same room on 11/12 at WMCPA meeting in
Milwaukee.

Come join me and learn. http://conta.cc/1MwXExe

Joe Pluta, you should attend !! :)

Regards,

Richard Schoen | Director of Document Management Technologies, HelpSystems
T: + 1 952-486-6802
RJS Software Systems | A Division of HelpSystems
richard.schoen@xxxxxxxxxxxxxxx<mailto:richard.schoen@xxxxxxxxxxxxxxx>
www.rjssoftware.com<http://www.rjssoftware.com/>
Visit me on: Twitter<https://twitter.com/richardschoen> | LinkedIn<
http://www.linkedin.com/in/richardschoen>

------------------------------

message: 8
date: Wed, 4 Nov 2015 09:52:40 -0500
from: Buck Calabro <kc2hiz@xxxxxxxxx>
subject: Re: Migrating IBM i database files to DB2 LUW

On 11/3/2015 8:20 PM, Steve Landess wrote:

I don't have all the details yet, but I have an associate who needs to
migrate data from an AS/400 - iSeries - IBM i system to a DB2 LUW
database, most likely running on a Windows server.

I am not yet sure which version of either platform yet, but can anyone
provide what options are available which do NOT require the $$$$ DB2
Connect feature on the midrange side?

I did a subset of our tables for a proof of concept for some GIS work.
The GIS software ran ONLY against DB2 LUW. I forget the details, and it
was a while ago. The budget was zero dollars and 'use your spare time'.

My recollection was that I fired off the API that extracted the SQL DDL
and cut/pasted that DDL onto LUW scripts which created the tables.
Tweaked for LUW differences. Extracting the DDL might be do-able
entirely from SQL now, depending on the IBM i release level.

Then I used Scott's JDBC wrappers to write some RPG programs that read
the IBM i tables (using the cycle, ha!) and then doing an 'INSERT INTO'
on the remote LUW twin table. Inefficient, but it met my needs. It may
be easier to write a 'pull' from the LUW side; I'm an RPG programmer, so
everything looks like an RPG problem to be :-)

--
--buck

Visit wiki.midrange.com and register for an account. Edit a page that
helps you, and because it's public, you'll help someone else, too!

------------------------------

message: 9
date: Wed, 4 Nov 2015 09:26:46 -0600
from: David Gibbs <david@xxxxxxxxxxxx>
subject: Identify a savefile downloaded to a PC?

Folks:

Does anyone know if there is a way to look at a file on a PC and determine
if it is a savefile that was (theoretically) downloaded from the i?

Thanks!

david

--
IBM i on Power Systems: For when you can't afford to be out of business!

I'm riding 100 miles (a full century) in the American Diabetes
Association's Tour de Cure to raise money for diabetes research, education,
advocacy, and awareness. You can make a tax deductible donation to my ride
by visiting http://emailsig.diabetessucks.net. My goal is $6000 but any
amount is appreciated.

See where I get my donations from ... visit
http://emailsig.diabetessucks.net/map for an interactive map (it's a
geeky thing).

------------------------------

message: 10
date: Wed, 4 Nov 2015 09:39:26 -0600
from: "Kevin Bucknum" <Kevin@xxxxxxxxxxxxxxxxxxx>
subject: RE: Identify a savefile downloaded to a PC?

The linux command file will identify it as a savf file.
kevin@MN207-Kubuntu:~/Downloads$ file movsavf.savf
movsavf.savf: IBM OS/400 save file data

The jSAVF utility will tell you whats in the file, but the display is in
French. Pretty easy to figure out however.
http://www.anerty.net/software/file/jSAVF/

Kevin Bucknum
Senior Programmer Analyst
MEDDATA/MEDTRON
Tel: 985-893-2550

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
David Gibbs
Sent: Wednesday, November 04, 2015 9:27 AM
To: midrange-l@xxxxxxxxxxxx
Subject: Identify a savefile downloaded to a PC?

Folks:

Does anyone know if there is a way to look at a file on a PC and
determine if it is a savefile that was (theoretically) downloaded from
the i?

Thanks!

david

--
IBM i on Power Systems: For when you can't afford to be out of business!

I'm riding 100 miles (a full century) in the American Diabetes
Association's Tour de Cure to raise money for diabetes research,
education, advocacy, and awareness. You can make a tax deductible
donation to my ride by visiting http://emailsig.diabetessucks.net. My
goal is $6000 but any amount is appreciated.

See where I get my donations from ... visit
http://emailsig.diabetessucks.net/map for an interactive map (it's a
geeky thing).
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/midrange-l.

------------------------------

Subject: Digest Footer

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) digest list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

------------------------------

End of MIDRANGE-L Digest, Vol 14, Issue 1568
********************************************