database:db2_backup_restore
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
database:db2_backup_restore [2024/05/06 23:37] manu [Cloning using FlashCopy Manager] |
database:db2_backup_restore [2024/05/07 22:48] (current) manu |
||
|---|---|---|---|
| Line 47: | Line 47: | ||
| First start the restore process, that is waiting for PIPE to be used | First start the restore process, that is waiting for PIPE to be used | ||
| <cli prompt='$'> | <cli prompt='$'> | ||
| - | $ db2 restore db MYDB2 from /tmp/mydb2.bkp into MYDB2_clone redirect | + | $ db2 restore db MYDB2 from /backup into MYDB2_clone redirect |
| </cli> | </cli> | ||
| Then start in a second windows, the backup using the PIPE | Then start in a second windows, the backup using the PIPE | ||
| <cli prompt='$'> | <cli prompt='$'> | ||
| - | $ db2 backup db MYDB2 to /tmp/mydb2.bkp | + | $ db2 backup db MYDB2 to /backup |
| </cli> | </cli> | ||
| Line 102: | Line 102: | ||
| * Set owner to db2inst1 for directory NODE0000 and all sub-directories and files under NODE0000 | * Set owner to db2inst1 for directory NODE0000 and all sub-directories and files under NODE0000 | ||
| * Catalog database you want to access. Example: **db2 catalog db commdb on /home/db2inst1** | * Catalog database you want to access. Example: **db2 catalog db commdb on /home/db2inst1** | ||
| - | * Connect to database: db2 connect to mydb; db2 list tablespaces | + | * Connect to database: **db2 connect to commdb; db2 list tablespaces** |
database/db2_backup_restore.1715031474.txt.gz ยท Last modified: 2024/05/06 23:37 by manu
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: GNU Free Documentation License 1.3
