DB2 backup/restore schema – DEV Community

Exporting DDL from EXAMPLE schema: db2look -d MYDB -z EXAMPLE -e -o EXAMPLE.sql Enter fullscreen mode Exit fullscreen mode Exporting knowledge from schema: db2move MYDB export -sn EXAMPLE Enter fullscreen mode Exit fullscreen mode The db2move command will create lots of recordsdata, incluing db2move.lst. It comprises inner tables like EXPLAIN_* and ADVISE_*. In the event […]