【赛迪网－IT技术报道】首先，db2 "select creator,name,tid,fid from sysibm.systables where name = tablename" 查到tid和fid；
然后
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)
2,2,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)
2,2,0,999=
FID,TID,first page为0，num of pages
注：尽量往大了估算。
（责任编辑：卢兆林）
