db_backup_restore

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision
Previous revision
db_backup_restore [2019/10/18 20:04] – external edit 127.0.0.1db_backup_restore [2020/11/24 16:57] (current) andonovj
Line 22: Line 22:
 db2 -tvf ddl_<DBNAME>.sql db2 -tvf ddl_<DBNAME>.sql
 db2move <DBNAME> load db2move <DBNAME> load
 +</sxh>
 +
 +
 +**5. Extract DDL For certain tables:**
 +
 +
 +<sxh bash>
 +db2look -d dbname -f -a -e -m -t table1 table2 ... -o tablename.ddl
 </sxh> </sxh>
  
  • db_backup_restore.1571429096.txt.gz
  • Last modified: 2019/10/18 20:04
  • by 127.0.0.1