By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,851 Members | 1,668 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,851 IT Pros & Developers. It's quick & easy.

Question on space for a reorg

P: n/a
Running db2 8.1.1 on aix 5.1.

Tried to do an offline reorg on the system tables and could not reorg
SYSIBM.SYSCOLDIST at about 3.5 million rows.

Apparently there was not enough space in the default SYSCATSPACE
tablespace in which DB2 could create the 'shadow' table.

We are trying to determine the space we would need in a temp tablespace
that would be specified in the reorg command. I know I've seen the
formula before but can't seem to locate it.

Is it a simple matter of computing number of rows times avg row length?

Thanks in advance.
Gerry

Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
"Classic" reorg requires as much work space as the table occupies. If
the reorged table is larger than the original; then the work space is
the (new) larger size.

I'd always add 10-20% extra to the workspace required.

The newer "in-place" reorg allows access during the reorg and doesn't
use very much work space. Unfortunately, it dows log all changes and can
create a large number of log records.

I'd opt for the classic version and add additional work space.

Phil Sherman
da*******@yahoo.com wrote:
Running db2 8.1.1 on aix 5.1.

Tried to do an offline reorg on the system tables and could not reorg
SYSIBM.SYSCOLDIST at about 3.5 million rows.

Apparently there was not enough space in the default SYSCATSPACE
tablespace in which DB2 could create the 'shadow' table.

We are trying to determine the space we would need in a temp tablespace
that would be specified in the reorg command. I know I've seen the
formula before but can't seem to locate it.

Is it a simple matter of computing number of rows times avg row length?

Thanks in advance.
Gerry

Nov 12 '05 #2

P: n/a
If you have run stats on the table, the stat FPAGES gives you the number of
pages (4k,8k,...) required to hold the table and therefore the minimum size
of tempspace required.
HTH, Pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
<da*******@yahoo.com> a écrit dans le message de news:
11*********************@f14g2000cwb.googlegroups.c om...
Running db2 8.1.1 on aix 5.1.

Tried to do an offline reorg on the system tables and could not reorg
SYSIBM.SYSCOLDIST at about 3.5 million rows.

Apparently there was not enough space in the default SYSCATSPACE
tablespace in which DB2 could create the 'shadow' table.

We are trying to determine the space we would need in a temp tablespace
that would be specified in the reorg command. I know I've seen the
formula before but can't seem to locate it.

Is it a simple matter of computing number of rows times avg row length?

Thanks in advance.
Gerry


Nov 12 '05 #3

P: n/a
Many thanks

Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.