I have a database running on the Windows version of DB2 UDB 8.1. I'd like to transfer it all to an AIX 5.3 server running also DB2 UDB 8.1. I already tried backup/restore but it doesn't work, saying it's not possible to restore a DB on a different platform than where it was backed up.
What's the method to do such a thing? Is there a way to dump the DB structure and content of all the tables and reload it on the other system? I checked EXPORT and LOAD but it seems it's only for 1 or several linked tables.