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

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

P: n/a
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
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.