473,226 Members | 1,358 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,226 software developers and data experts.

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 3928
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

27
by: Raquel | last post by:
This question if for UDB on LUW. Suppose I take regular database backups of my database Monday: database backup <ts1> Tuesday: Tablespace reorged and imagecopied <ts2> Friday: database...
4
by: Lyn Duong | last post by:
Hi Something bizarrae is happening in my db2 udb on aix 8.1.4 database. I deleted all data from a particular database and to reclaim empty pages I have reorg'd and runstated all tables in this...
9
by: Lara | last post by:
Hello freaks, we have many problems with our online reorg and no idea how to resolve it. We had to do an online reorg beacause of 24 h online business. We start the reorg-statements (table by...
2
by: TomHorner | last post by:
I have several quick questions about reorg's, and a request (favor). 1. The documentation says that reorg "Reorganizes an index or a table" I cannot see how one would reorg ONE particular index...
4
by: News | last post by:
I have 18 years of mainframe DB2, and I just starting working with UDB LUW V8.1 FixPack 6 on Sun Solaris last week. I have been dismayed on the lack of detailed info available in the manuals on...
3
by: kartic_s | last post by:
he brief explanation of the problem is, After DB2 maintenance window performance has gone down, it takes some hours to retrieve the data. We have provided some table spaces to Reorg/Runstat...
9
by: mike_dba | last post by:
I am using DMS raw. I have a tablespace which is defined with 5 containers each allocated at 1.5 GB for a total of about 7.5 GB. I did a major deletion followed by a reorg and a runstats. I am...
0
by: lfhenry | last post by:
Hi, I would like to reorg my HADR DB. I know the IBM HADR recommendation is to use inplace. I made reorg a while back and got some serious locks happening. We are a 24 hour operation. My first...
0
by: tg | last post by:
I have been using the online reorg for over 2 years without any problems. I have just encountered a log full condition after having started the online reorg on the same table that I have been...
0
by: VivesProcSPL | last post by:
Obviously, one of the original purposes of SQL is to make data query processing easy. The language uses many English-like terms and syntax in an effort to make it easy to learn, particularly for...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.