This article describes how to use DB2dart to restore data. First, DB2 "select creator, name, tid, fid from sysibm. systables where name = tablename "indicates tid and fid. The following describes the main content of the article.
Describes how to use DB2dart to restore data.
Release: | Author: Cher | Source: reposted on the Internet | view: 28
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.
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.