建站
咨詢
售后
建站咨詢
新聞中心
這里有您想知道的互聯(lián)網(wǎng)營銷解決方案
DB2備份測(cè)試的開始備份的操作流程
此文章主要講述的是DB2備份測(cè)試的開始備份的實(shí)際操作步驟，如果你對(duì)DB2備份測(cè)試的開始備份的實(shí)際操作步驟有興趣的話，你就可以對(duì)以下的文章點(diǎn)擊觀看了，以下就是文章的詳細(xì)內(nèi)容介紹，望大家借鑒。
成都創(chuàng)新互聯(lián)公司是一家專業(yè)提供井研企業(yè)網(wǎng)站建設(shè),專注與成都網(wǎng)站制作、網(wǎng)站建設(shè)、外貿(mào)網(wǎng)站建設(shè)、H5響應(yīng)式網(wǎng)站、小程序制作等業(yè)務(wù)。10年已為井研眾多企業(yè)、政府機(jī)構(gòu)等服務(wù)。創(chuàng)新互聯(lián)專業(yè)網(wǎng)站設(shè)計(jì)公司優(yōu)惠進(jìn)行中。
DB2, DB2備份數(shù)據(jù)庫, 實(shí)例, 講解
1、做一個(gè)在線全備操作：
- [db2inst1@db2 ~]$ db2 backup db sample online to /tmp/db2inst1/sample/off_back include logs
- Backup successful. The timestamp for this backup image is : 20090917061921
2、創(chuàng)建一個(gè)表，并插入數(shù)據(jù)：
- db2 => connect to sample
- Database Connection Information
- Database server
- = DB2/LINUX 9.1.3
- SQL authorization ID
- = DB2INST1
- Local database alias
- = SAMPLE
- db2 => insert into sales1 select * from sales
- DB20000I
- The SQL command completed successfully.
- db2 => insert into sales1 select * from sales1
- DB20000I
- The SQL command completed successfully.
- db2 => insert into sales1 select * from sales1
- DB20000I
- The SQL command completed successfully
- db2 => select * from sales1
- SALES_DATE SALES_PERSON
- REGION
- SALES
- 12/31/2005 LUCCHESSI
- Ontario-South
- 1
- 12/31/2005 LEE
- Ontario-South
- 3
- 12/31/2005 LEE
- Quebec
- 1
- 12/31/2005 LEE
- Manitoba
- 2
- 12/31/2005 GOUNOT
- Quebec
- 1
- 03/29/2006 LUCCHESSI
- Ontario-South
- 3
- 03/29/2006 LUCCHESSI
- Quebec
- 。。。。。。。。。。。
3、DB2備份測(cè)試之做增量備份：
- [db2inst1@db2 ~]$ db2 backup db sample online incremental to /tmp/db2inst1/sample/off_back include logs
- Backup successful. The timestamp for this backup image is : 20090917062532
4、刪除表操作：
- [db2inst1@db2 off_back]$ db2stop force
- 09/17/2009 06:26:47
- 0
- 0
- SQL1064N
- DB2STOP processing was successful.
- SQL1064N
- DB2STOP processing was successful.
- [db2inst1@db2 off_back]$ db2start
- 09/17/2009 06:26:57
- 0
- 0
- SQL1063N
- DB2START processing was successful.
- SQL1063N
- DB2START processing was successful.
- db2 => connect to sample
- Database Connection Information
- Database server
- = DB2/LINUX 9.1.3
- SQL authorization ID
- = DB2INST1
- Local database alias
- = SAMPLE
- db2 => drop table sales1
- DB20000I
- The SQL command completed successfully.
- db2 => select * from sales1
- SQL0204N
- "DB2INST1.SALES1" is an undefined name.
- SQLSTATE=42704
以上的相關(guān)內(nèi)容就是對(duì)DB2備份測(cè)試的介紹，望你能有所收獲。
【編輯推薦】
- IBM DB2 Content Manager V83與手工配置SSL
- 失敗DB2? access 服務(wù)器配置的正確恢復(fù)流程
- DB2 V9.7啟用索引壓縮大揭秘
- DB2數(shù)據(jù)庫備份參數(shù)修改后報(bào)錯(cuò)如何拯救？
- 手動(dòng)安裝DB2數(shù)據(jù)庫的實(shí)現(xiàn)在UNIX操作環(huán)境下
分享標(biāo)題：DB2備份測(cè)試的開始備份的操作流程
網(wǎng)站地址：http://m.fisionsoft.com.cn/article/dpshicp.html
