469,582 Members | 2,373 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

reorg using system temporary table space for table in tablespaceswith variable page size

GB
The main and index table space have page sizes of 8k
The long data table space has page size of 4k

The page size of the temporary table is 4k
REORG TABLE USERBLAH.MYTABLE USE TEMPTBS;
When I try to run a reorg on my table I get following errors:

2004-07-30-05.15.01.927000 Instance:DB2 Node:000
PID:1252(db2syscs.exe) TID:1628 Appid:AC10C41E.5611.040730031501
relation_data_serv sqlrreorg_table Probe:15 Database:TEST

Reorg: DMS return rc = 06a4 ffff .

2004-07-30-05.15.02.036000 Instance:DB2 Node:000
PID:1252(db2syscs.exe) TID:1628 Appid:AC10C41E.5611.040730031501
relation_data_serv sqlrreorg_sendinfo Probe:105 Database:TEST
DIA1518 Failure processing SQL statement.

ZRC=0xFFFF877E
I suppose this problem is related to the different page sizes no ? How
can I solve this ?

Thanks for your help, Greg

---
using db2 7.2 on win2k
Nov 12 '05 #1
0 2501

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

27 posts views Thread by Raquel | last post: by
6 posts views Thread by gimme_this_gimme_that | last post: by
3 posts views Thread by datapro01 | last post: by
1 post views Thread by Daveyk0 | last post: by
reply views Thread by bwmiller16 | last post: by
3 posts views Thread by jane | last post: by
reply views Thread by suresh191 | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.