Re: For Those Like Me Transitioning From MySQL To The All Great And powerful DB2

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

This looks like it could be good information. One caveat, perhaps - it 
is completely focused on the LUW version of DB2. I don't typically look 
to LUW information to learn how things work in the IBM i version.

One thing I'd say is, one might need to filter out some of the 
information here - things about licensing, for example, are not 
pertinent to the IBM i version, which is integrated into the OS on i, 
instead of being a separate application running in a particular OS.

After digging around a bit, I found this site - 
http://www-304.ibm.com/partnerworld/wps/servlet/ContentHandler/servers/enable/site/db2_porting_i.html 
- it is porting information for porting from several RDBMS' to DB2 on 
IBM i - one of the documents is about porting from DB2 on Linux, Unix, 
Windows to DB2 on IBM i - interesting, eh?

There's also a document there for porting from MySQL to DB2 on IBM i - 
so this should have directly useful information in this arena.

Another tidbit of information - there has been a MySQL storage engine 
that can use the IBM i database in MySQL - there are changes happening 
there, so I'm not sure of the current state, or which versions apply.

Cheers
Vern

On 1/13/2016 5:20 PM, Rob wrote:
> I find this to be a great read...  it answers a lot of my question 
> QUICKLY!
>
> Moving a PHP application to DB2 from MySQL Parts 1, 2 & 3.
>
> http://www.ibm.com/developerworks/data/library/techarticle/dm-1011phpdb2mysql/index.html 
>
> http://www.ibm.com/developerworks/data/library/techarticle/dm-1103phpdb2mysql2/index.html 
>
> http://www.ibm.com/developerworks/data/library/techarticle/dm-1108phpdb2mysql3/ 
>
>
>
> ---
> This email has been checked for viruses by Avast antivirus software.
> https://www.avast.com/antivirus