Is there a way to extract the data from a DB2 database and load it into another instance on another platform?
The three UNIX platforms we currently support are IBM AIX, HP-UX, and SUN Solaris. I have been reviewing the Data Movement Utilities Guide and Reference for version 8 but don't seem to find what I am looking for. It appears that the export utility was designed for unloading individual tables. From what I have read the db2move utility is the closest thing I have found but it only backs up the user tables and does not include any functions or triggers we may be using. I understand that sometimes a backup of the database can be transferred to another platform if that platform utilizes the same memory page size such as HP-UX and Sun Solaris. However I need to be able to move data between all three platforms.
I am attempting to put an image of the database on a CD that can be loaded into a fresh instance across all three platforms. In other words something similar to the Oracle exp utility. Does anyone have any suggestions that may accommodate my situation? Maybe another utility I have yet to come across? Any assistance you could provide would be greatly appreciated.