disk access and DB2 - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

disk access and DB2

disk access and DB2# Database - 数据库

M*y2002-09-12 07:09

1 楼

Hi there,
I am performing a very simple experiment with DB2.
The query is: select count(*) from table1
I am interested in the disk I/O activities.
Is there any way to ensure disk access? I.E. to clear
the database's cache. The 2nd (and later)run is lightening fast, presumably no
disk access.
I've tried
1. db2stop, clear the OS cache, db2start
2. select * from some large junk tables and then repeat 1.
The query still runs very fast.
Thank you in advance.
cha

f*h2002-09-12 07:09

2 楼

DB2 keeps statistical information of tables, such as the total count of
tuples. Thus your count query is always superfast. You have to try something
else.

no

【在 M*******y 的大作中提到】

: Hi there,
: I am performing a very simple experiment with DB2.
: The query is: select count(*) from table1
: I am interested in the disk I/O activities.
: Is there any way to ensure disk access? I.E. to clear
: the database's cache. The 2nd (and later)run is lightening fast, presumably no
: disk access.
: I've tried
: 1. db2stop, clear the OS cache, db2start
: 2. select * from some large junk tables and then repeat 1.