db2mysqldumplookup-tables

how to get dump db2 database?

I have 3 questions :
1. How to get db2 dump database -with command like mysqldump-
2. If I want this dump to contain lookup tables is this possible to do that or I have to export lookup tables manually one by one ?
3. How I can use the output dump file after that ?
thanks in advance

Solution

  • The answers to your questions:

    1. A Mysql dump is called a backup in DB2. It creates a binary file that you can restore in the same kind of platform (Window, Linux). It contains the tables definition (DDL), the data and the security.
    2. and 3. There is another command that just extract the DDL of the defined objects. The tool is called db2look. When using a backup / restore method, you do not need db2look (DDL). You can also extract the data from DB2 with export command. There is a tool that ease the process called db2move that can perform the export, and also the import or load.

    When performing a migration, it is a common practice to use the combination db2look + db2move in order to recreate the database, for example in another platform.

    Documentation about the different commands.