This article mainly describes how to use DB2 dart to restore data. In order to give a more detailed description, we mainly explain how to list instances, the following is a detailed description of the main content of the article. I hope you will learn more about it.
First, DB2 "select creator, name, tid, fid from sysibm. Tables Ables where name = tablename" finds tid and fid;
Then
- D: \> DB2dart SAMPLE/DDEL
- Table object data formatting start.
- Please enter
- Table ID or name, tablespace ID, first page, num of pages:
- (Suffic page number with 'P' for pool relative)
- 0,999
- 5 of 5 columns in the table will be dumped.
- Column numbers and datatypes of the columns dumped:
- 0 SMALLINT
- 1 VARCHAR ()-VARIABLE LENGTH CHARACTER STRING
- 2 SMALLINT
- 3 VARCHAR ()-VARIABLE LENGTH CHARACTER STRING
- 4 VARCHAR ()-VARIABLE LENGTH CHARACTER STRING
- Default filename for output data file is TS2T2. DEL,
- Do you wish to change filename used? Y/n
- N
- Filename used for output data file is TS2T2. DEL. If existing file, data will
- Be appended to it.
- Formatted data being dumped...
- Dumping Page 0 ....
- Table object data formatting end.
- The requested DB2DART processing has completed successfully!
- Complete DB2DART report found in:
- C: \ PROGRA ~ 1 \ IBM \ SQLLIB \ DB2 \ DART0000 \ SAMPLE. RPT
- D: \>
- Table ID or name, tablespace ID, first page, num of pages:
- (Suffic page number with 'P' for pool relative)
- 0,999, =
- FID, TID, first page is 0, num of pages
Note: estimate as much data as possible.
The above section describes how to use DB2 dart to restore data.