REORG problems with LONGLOBSDATA and PAGESIZE

pike

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

Shashi Mannepalli

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