¸±¸®½º Á¤º¸


º¯°æ ½ÃÀÛ49.19 ¹é¾÷ ¹× º¹¿ø ¸í·É µµ¿ò¸»

db2 ? backupÀ» ÀÔ·ÂÇϸé À߸øµÈ Á¤º¸°¡ ³ªÅ¸³³´Ï´Ù. ¿Ã¹Ù¸¥ Á¤º¸´Â ´ÙÀ½°ú °°½À´Ï´Ù.

BACKUP DATABASE database-alias [USER username [USING password]]
[TABLESPACE (tblspace-name [ {,tblspace-name} ... ])] [ONLINE]
[INCREMENTAL [DELTA]] [USE TSM [OPEN num-sess SESSIONS]] |
TO dir/dev [ {,dir/dev} ... ] | LOAD lib-name [OPEN num-sess SESSIONS]]
[WITH num-buff BUFFERS] [BUFFER buffer-size] [PARALLELISM n]
[WITHOUT PROMPTING]

db2 ? restore¸¦ ÀÔ·ÂÇϸé À߸øµÈ Á¤º¸°¡ ³ªÅ¸³³´Ï´Ù. ¿Ã¹Ù¸¥ Á¤º¸´Â ´ÙÀ½°ú °°½À´Ï´Ù.

RESTORE DATABASE source-database-alias { restore-options | CONTINUE | ABORT }";
 
restore-options:";
  [USER username [USING password]] [{TABLESPACE [ONLINE] |";
  TABLESPACE (tblspace-name [ {,tblspace-name} ... ]) [ONLINE] |";
  HISTORY FILE [ONLINE]}] [INCREMENTAL [ABORT]]";
  [{USE TSM [OPEN num-sess SESSIONS] |";
  FROM dir/dev [ {,dir/dev} ... ] | LOAD shared-lib";
  [OPEN num-sess SESSIONS]}] [TAKEN AT date-time] [TO target-directory]";
  [INTO target-database-alias] [NEWLOGPATH directory]";
  [WITH num-buff BUFFERS] [BUFFER buffer-size]";
  [DLREPORT file-name] [REPLACE EXISTING] [REDIRECT] [PARALLELISM n]";
  [WITHOUT ROLLING FORWARD] [WITHOUT DATALINK] [WITHOUT PROMPTING]";
º¯°æ ³¡


[ ÆäÀÌÁöÀÇ ¸Ç À§ | ÀÌÀü ÆäÀÌÁö | ´ÙÀ½ ÆäÀÌÁö | ¸ñÂ÷ | »öÀÎ ]