471,887 Members | 1,480 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

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

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 2558

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 YellowAndGreen | last post: by
reply views Thread by zermasroor | last post: by

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.