IBM DB2: Difference between revisions
m
Improve link
(New page) |
m (Improve link) |
||
(9 intermediate revisions by 4 users not shown) | |||
Line 1: | Line 1: | ||
For many years IBM DB2 was exclusive to the very expensive Mainframes and other heavy servers, and the only connnectivity from DataFlex was for minor applications. | For many years IBM DB2 was exclusive to the very expensive Mainframes and other heavy servers, and the only connnectivity from DataFlex was for minor applications. | ||
Nowadays IBM DB2 UDB has a free version for use in commercial environments. It is the Express-C edition. | Nowadays IBM DB2 UDB has a free version for use in commercial environments. It is the [http://www-306.ibm.com/software/data/db2/express/ Express-C] edition. | ||
The great things about this database are: | The great things about this database are: | ||
#Its free, with unlimited database size (but server memory <= 4Gb) | #Its free, with unlimited database size (but server memory <= 4Gb) | ||
#DB2 server runs on Windows but also Linux and many others | #DB2 server runs on Windows but also Linux and many others | ||
#The DB2 data can be accessed from DF32 Linux programs as well as VDF and other programmnig environments | #The DB2 data can be accessed from [[DF32]] Linux programs as well as VDF and other programmnig environments | ||
#It is really fast and self tuning, no DBA hours required | #It is really fast and self tuning, no DBA hours required | ||
# | #[[Data Access]] And [[Mertech Data]] have fantastic Connectivity Kits, not only from VDF but also from Linux DataFlex Console Mode systems. | ||
== Running Character Mode DF32 == | == Running Character Mode DF32 == | ||
If you still have a lot of | If you still have a lot of *[[DataFlex| Character mode]] programming. And it is not an option to move to VDF (Because of bandwith, factory environment, etc), I recommend that you have a serious look at: | ||
*Convert your Console Mode program to Linux | |||
*Convert your DataFlex tables to DB2 | |||
This opens up a new world for unleashing your data in a safe way. You can do datamining, run crystal without DataFlex CK, even create Java, .Net or any other applications all using your data. Offcourse this does not take | This opens up a new world for unleashing your data in a safe way. You can do datamining, run crystal without DataFlex CK, even create Java, .Net or any other applications all using your data. Offcourse this does not take [[Data Dictionaries]] into effect, but you most likely did not have these anyway in [[DataFlex|DF32]]. | ||
== Conversion == | == Conversion == | ||
The conversion from Embedded DataFlex to DB2 has some gotcha's | The conversion from Embedded DataFlex to DB2 has some gotcha's; | ||
*DB2 has several options for Collating Sequence. Please carefully select this prior to creating your database matching with your collate.cfg. (Hint: use 'Fill_Field' rather than move 'zzzz' in your old programs), or use the DAW utility CreaDb to create the database matching the Collate.cfg. | |||
*Some nested reports might run slower. Concider creating an SQL View, link this as a table using the Filelist and a INT file, then report from the 'Flat file'. | |||
[[Category:DB2]] |