您现在的位置:软界网技术中心数据库DB2 > 技术显示
实例讲解使用db2dart恢复数据的具体步骤
2008-7-8 0:00:00   网友评论       阅读次数 点此评论
   

  首先,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

  注:尽量往大了估算。

  

 
      来源: 作者:
 
【评论查看】