470,596 Members | 1,528 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,596 developers. It's quick & easy.

REORG problems with LONGLOBSDATA and PAGESIZE

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
1 3634
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.

Similar topics

27 posts views Thread by Raquel | last post: by
4 posts views Thread by Lyn Duong | last post: by
2 posts views Thread by TomHorner | last post: by
9 posts views Thread by mike_dba | last post: by
reply views Thread by lfhenry | last post: by
reply views Thread by tg | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.