download DB2 for temporarily use??

[fletchsod]

I have not been able to get DB2 V6.1 to work on Suse Linux so I'm wondering is is there a freeware DB2 somewhere that I can temporarily use while I make the transistion from DB2 to linter via php. I just need the web site working.

Thanks...

 

[MarcLodge]

fletchsod,
This article refers to it:

http://www.theregister.co.uk/2006/01/31/db2_express/

And here is the download page:

http://www-128.ibm.com/developerworks/downloads/im/udbexp/

I've not used it or downloaded it though, so can't vouch for how good it is or isn't.

Marc

 

[fletchsod]

Seem to work pretty well this time. But I am unable to restore the database from backup becuase of 2 platform difference (AIX & Linux). So, does anyone have ideas or suggestion of what I can do. Please feel free to say something. Thanks...

 

[martynh]

Restoring from version 6.1 to 8.2 (I guess this is what you downloaded for free) onto different platforms is going to be a real challenge I'd guess. I've not done it but my first approach would be to look at the export and import commands (and also the load command). These allow transfer of data in ixf (DB2 internal) format which is good if it works for you. Failing that, if your data are character/numeric based then you can transfer data as CSV files. You get into trouble if varchar columns are > 255 bytes.

Import has to be aware of RI constraints but with load you can ignore constraints at load time and check the constraints with "set integrity" once all the data are loaded.

 

[fletchsod]

Well, I did get the restore error saying it is not cross-platform compactible but the restore should be able to work from older version to a newer version of the same platform (though I haven't tried that part).

I'm going to have to create tables manually then use PHP to retrieve data from one platform into a file then put that file onto a different platform and retrieve it from file to be put into the database.

Yea, I can try the csv or import/export command. But all of those problem is we have no way of knowing the exact setting of each of the columns of every tables. Like character length, data type, all of those exact detail. So, seem there is a flaw with any of hte database softwares.

Forunately, we have decided to junk the idea of Linux because it have shares of it's own problem so hopefully that restoring from backup would work onto newer version then convert it to a different Database software via PHP.

 

[gregsimpson]

fletchsod,

Does the db2move utility help you?

http://publib.boulder.ibm.com/infoc...?topic=/com.ibm.db2.udb.doc/core/r0002079.htm

Cheers
Greg

 

[fletchsod]

Um... I'll look into it. Thanks...