|
首先,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~1IBMSQLLIBDB2DART0000SAMPLE.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 注:尽量往大了估算。
|