Skip to Content
0
Former Member
Feb 18, 2008 at 05:21 AM

DB2 Block Size

373 Views

Dear Experts,

How to know the block size of a table in DB2?

Currently, we are performing 'move table' to a new tablespace. The process has spent over 30 hours for only one table which have large size and big block. Before doing 'move table' job via DB6CONV, we do not know how many the block size is?

We have to know its block size in order to determine the time consumed by system in the future, so we can predict the down time, because as we monitored, 1 block consumed approximately 20 to 30 seconds.

We use ECC6, DB2 ver 8.2 and AIX 5.3.

Need your quick response.

Thanks and Regards,

Rudi