db2dart工具使用的总结点滴

ganquan

数据库：
C:\>db2dart sample

表空间：
db2dart sample /ts /tsi 2
db2dart sample /ts <= When prompted for the table space ID,
enter "2".

Identify the object:
C:\>db2 "select creator,name,tid,fid from sysibm.systables where name =
'EMP_PHOTO'"
CREATOR NAME TID FID
------------------ --------------------- ------ ------
DB2 EMP_PHOTO 2 8

To inspect this table, execute either of the following db2dart commands:
db2dart sample /t /tsi 2 /oi 8
db2dart sample /t <= When prompted for the table ID and
table space ID, enter "8 2".

The ORG table in the sample database resides in table space 2 and has an object ID of 2. To
extract all of the data from this table, execute this command:
db2dart sample /ddel
When prompted, enter either of the following lines of input:
2 2 0 1000
ORG 2 0 1000

To determine the index object ID for a table, inspect that table. For example, inspect tables T1 and
T2 in table space DMS1 (which has a table space ID of 3):
db2dart sample /t /tsi 3 /tn T1（大写）

Look for the T1 entry. It should look something like this:
Table inspection start: DB2.T1
Data inspection phase start. Data obj: 4 In pool: 3
Data inspection phase end.
Index inspection phase start. Index obj: 4 In pool: 3
Scanning pages for index itoken(1) root page:258p.
Index inspection phase end.
Table inspection end.

As you can see, both the data object (the table) and the index object have the same table space ID
(4) and object ID (3). To mark this index object as bad, execute the following db2dart command:
db2dart sample /mi /tsi 3 /oi 4

Before moving on to the next section, reset the quiesce state for table space DMS1:
db2 "connect to sample"
db2 "quiesce tablespaces for table kelly.t3 reset"
db2 "connect reset"

ganquan

在db2 v8.1 中提供了一个新的工具：
$db2  inspect  check  database  results  inspect_sample.err

inspect_sample.err文件存放在diaglogpath目录下

bpmfhu

用db2dart对数据库作一致性检查，很少用。但是用db2dart来恢复数据最近经常用，呵呵

ganquan

也把你的笔记贴出来看看

我笨故我在

最初由 bpmfhu 发布
[B]用db2dart对数据库作一致性检查，很少用。但是用db2dart来恢复数据最近经常用，呵呵 [/B]

db2dart 一次一个表一个表的导数据太麻烦,能不能一次把库里的数据都导出?

ganquan

没听说db2dart可以导出一个库的数据。不知道ibm lab是否有其他秘密通道？

bpmfhu

只能单表dump

wangzhonnew

最初由 我笨故我在 发布
[B]

db2dart 一次一个表一个表的导数据[/B]

咦?有这等事?详细说说?

acme1921209

原帖由 ganquan 于 2006-2-10 12:20 发表
在db2 v8.1 中提供了一个新的工具：
$db2  inspect  check  database  results  inspect_sample.err

inspect_sample.err文件存放在diaglogpath目录下

What is the difference (if any) between
inspect check database
and
db2dart:

Major difference is that inspect does not require deactivating the db which
db2dart does.
Another is that inspect cannot do any repair work which db2dart does.

Other is that because inspect checks the physical integrity of the db its
command structure is more detailed (do a db2 ? inspect and look ) and more
precise to specify and filter what to inspect.
Inspect also creates a binary formatted file which has to be formatted with
the propr command (db2inspf I think).

This is just a quick reply. If you Google each (inspect and/or db2dart)
you'll get all the info you need.

[ 本帖最后由 acme1921209 于 2008-1-20 00:23 编辑 ]

wangzhonnew

inspect有的功能dart没有，dart有的一些功能inspect没有，两者互补。
而且inspect一般来说效率会快一点，因为可以用prefetch读数据到bp,dart只能一页一页自己读