DB2数据库备份测试的操作步骤

以下的文章主要描述的是DB2数据库备份测试的操作步骤，以及在其实际操作中的值得大家注意的事项与其代码的描述，以下就是文章的主要内容的详细描述，望大家在浏览之后会对其有更深的了解。

开始备份【实例讲解】

DB2, DB2备份

1、做一个在线全备操作：

[db2inst1@db2~]$db2backupdbsampleonlineto/tmp/db2inst1/sample/off_backincludelogs Backupsuccessful.Thetimestampforthisbackupimageis:20090917061921

2、创建一个表，并插入数据：

db2=>connecttosample DatabaseConnectionInformation Databaseserver=DB2/LINUX9.1.3 SQLauthorizationID=DB2INST1Localdatabasealias=SAMPLEdb2=>insertintosales1select*fromsales DB20000I TheSQLcommandcompletedsuccessfully. db2=>insertintosales1select*fromsales1 DB20000I TheSQLcommandcompletedsuccessfully. db2=>insertintosales1select*fromsales1 DB20000I TheSQLcommandcompletedsuccessfully db2=>select*fromsales1 SALES_DATESALES_PERSON REGION SALES 12/31/2005LUCCHESSI Ontario-South 1 12/31/2005LEE Ontario-South 3 12/31/2005LEE Quebec 1 12/31/2005LEE Manitoba 2 12/31/2005GOUNOT Quebec 1 03/29/2006LUCCHESSI Ontario-South 3 03/29/2006LUCCHESSI Quebec 。。。。。。。。。。。

3、做增量DB2数据库备份：

[db2inst1@db2~]$db2backupdbsampleonlineincrementalto/tmp/db2inst1/sample/off_backincludelogs Backupsuccessful.Thetimestampforthisbackupimageis:20090917062532

4、删除表操作：

[db2inst1@db2off_back]$db2stopforce 09/17/200906:26:47 0 0 SQL1064N DB2STOPprocessingwassuccessful. SQL1064N DB2STOPprocessingwassuccessful. [db2inst1@db2off_back]$db2start 09/17/200906:26:57 0 0 SQL1063N DB2STARTprocessingwassuccessful. SQL1063N DB2STARTprocessingwassuccessful. db2=>connecttosample DatabaseConnectionInformation Databaseserver=DB2/LINUX9.1.3 SQLauthorizationID=DB2INST1Localdatabasealias=SAMPLEdb2=>droptablesales1 DB20000I TheSQLcommandcompletedsuccessfully. db2=>select*fromsales1 SQL0204N "DB2INST1.SALES1"isanundefinedname. SQLSTATE=42704

以上的相关内容就是对DB2数据库备份测试的介绍，望你能有所收获。

【编辑推荐】