Correct use of DB2dart to restore Data

Today, we will discuss with you how to use an instance to explain the correct steps for using DB2dart to restore data, if you are interested in the correct steps for using DB2dart to restore data, you can click the following article to view 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 DB2dart to restore data.

The above content describes how to use DB2dart to restore data.