database:db2_backup_restore
Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
database:db2_backup_restore [2021/01/01 21:24] 127.0.0.1 external edit |
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 94: | Line 94: | ||
| fcmcli -f inquire_detail_clone | fcmcli -f inquire_detail_clone | ||
| + | ===== Copy a DB and catalog it ===== | ||
| + | |||
| + | Your requirement is similar to cloning database using a split mirror. You can try following steps | ||
| + | |||
| + | * Create instance db2inst1 on new machine if it is not created during db2 installation | ||
| + | * Copy NODE0000 directory to location /home/db2inst1/db2inst1 | ||
| + | * 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** | ||
| + | * Connect to database: **db2 connect to commdb; db2 list tablespaces** | ||
database/db2_backup_restore.1609532694.txt.gz ยท Last modified: 2021/01/01 21:24 by 127.0.0.1
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: GNU Free Documentation License 1.3
