db_backup_restore

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision		 Previous revision
db_backup_restore [2020/11/24 16:56] – [Logical Backup] andonovjdb_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> </sxh>
  
  
-**5. Extract DDL For certain tables:+**5. Extract DDL For certain tables:** 
 + 
 + 
 +<sxh bash>
 db2look -d dbname -f -a -e -m -t table1 table2 ... -o tablename.ddl db2look -d dbname -f -a -e -m -t table1 table2 ... -o tablename.ddl
 +</sxh>
  
 **6. Verify integrity on tables with check constraint :** **6. Verify integrity on tables with check constraint :**
  • db_backup_restore.1606236969.txt.gz
  • Last modified: 2020/11/24 16:56
  • by andonovj