× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. November 2015

Re: Migrating IBM i database files to DB2 LUW

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
********************************************


As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow-Ups:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.