DB2: Comandos Backup e Restore: Difference between revisions

From Wiki
 
(One intermediate revision by the same user not shown)
Line 8: Line 8:
== Comando Restore ==
== Comando Restore ==


  db2 "CREATE DATABASE << db2_dbname >> AUTOMATIC STORAGE YES USING CODESET UTF-8 TERRITORY US  
  db2 "CREATE DATABASE '''MYDB''' AUTOMATIC STORAGE YES USING CODESET UTF-8 TERRITORY US  
     COLLATE USING IDENTITY PAGESIZE 4096 DFT_EXTENT_SZ 32"
     COLLATE USING IDENTITY PAGESIZE 4096 DFT_EXTENT_SZ 32"


  db2 "RESTORE DATABASE << db2_dbname >> from /tmp into << db2_dbname >> without prompting"
  db2 "RESTORE DATABASE '''MYDB''' from /tmp into '''MYDB''' without prompting"


== Check backup file ==
== Check backup file ==
Line 39: Line 39:
You can use the "redirected" restore option by generating a file, using command:
You can use the "redirected" restore option by generating a file, using command:


  db2 restore database mydb redirect generate script restore.sql
  db2 restore database '''MYDB''' redirect generate script restore.sql


Once the script is generated, you can change the names, file locations, etc.
Once the script is generated, you can change the names, file locations, etc.
Line 46: Line 46:


  db2 -tvf restore.sql
  db2 -tvf restore.sql


== Ver também ==
== Ver também ==

Latest revision as of 18:05, 1 July 2024

Comando Backup

db2 "BACKUP DATABASE MYDB"

This will generate a file like MYDB.0.db2inst1.DBPART000.20240605211641.001

Comando Restore

db2 "CREATE DATABASE MYDB AUTOMATIC STORAGE YES USING CODESET UTF-8 TERRITORY US 
    COLLATE USING IDENTITY PAGESIZE 4096 DFT_EXTENT_SZ 32"

db2 "RESTORE DATABASE MYDB from /tmp into MYDB without prompting"

Check backup file

 db2ckbkp -H /tmp/

=====================
MEDIA HEADER REACHED:
=====================
Server Database Name           -- MYDB
Server Database Alias          -- MYDB
Client Database Alias          -- MYDB
Timestamp                      -- 20240605211641
Database Partition Number      -- 0
Instance                       -- db2inst1
Database Configuration Type    -- 0 (Non-shared data)
Sequence Number                -- 1
Database Member ID             -- 0
Release ID                     -- 0x1500 (DB2 v11.5.9.0)
AL version                     -- V:11 R:5 M:9 F:0 I:0 SB:0
...
The proper image file name would be:
MYDB.0.db2inst1.DBPART000.20240605211641.001

Restore using redirect file

You can use the "redirected" restore option by generating a file, using command: 

db2 restore database MYDB redirect generate script restore.sql

Once the script is generated, you can change the names, file locations, etc.

And finally, execute the script 

db2 -tvf restore.sql

Ver também


Retrieved from "https://ebasso.net/wiki/index.php?title=DB2:_Comandos_Backup_e_Restore&oldid=8775"