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

REORG problems with LONGLOBSDATA and PAGESIZE

P: n/a
DB2 v8.1 FP 11 on AIX 5.2.

A REORG of a table created in a 4KB-PAGESIZE tablespaces with
associated LONG data stored in a 16KB tablespace is failing with the
following error:

SQL2217N The page size of the system temporary table space used by the
REORG
utility must match the page size of the table space(s) in which the
table data
resides (including the LONG and/or LOB column data).

The REORG fails whether it is run against a 4KB-PAGESIZE or a
16KB-PAGESIZE system temporary tablespace.

Any help much appreciated. Thanks.

Aug 4 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Try the REORG without mentioning any TEMPORARY TABLESPACE.

cheers..
Shashi Mannepalli

pike wrote:
DB2 v8.1 FP 11 on AIX 5.2.

A REORG of a table created in a 4KB-PAGESIZE tablespaces with
associated LONG data stored in a 16KB tablespace is failing with the
following error:

SQL2217N The page size of the system temporary table space used by the
REORG
utility must match the page size of the table space(s) in which the
table data
resides (including the LONG and/or LOB column data).

The REORG fails whether it is run against a 4KB-PAGESIZE or a
16KB-PAGESIZE system temporary tablespace.

Any help much appreciated. Thanks.
Aug 4 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.