Converting from a 4G Tablespace to a 32G Tablespace

Robert Catterall

Converting from a 4G Tablespace to a 32G Tablespace
A very late chime-in (which doesn't change the essential fact that, as Steve
discovered, you can't DSN1COPY from a DSSIZE 4G tablespace to a DSSIZE 32G
tablespace): it was mentioned in this thread that the DSSIZE 32G tablespace
would have 5-byte RIDs, while the DSSIZE 4G tablespace has 4-byte RIDs. I
believe that tablespaces with a DSSIZE of 4G or more have 5-byte RIDs. That
being the case, both the DSSIZE 4G tablespace and the DSSIZE 32G tablespace
would have 5-byte RIDs.

Robert


On Mon, Nov 8, 2010 at 10:22 AM, Steve Schuering <
[login to unmask email]> wrote:

> Thanks to everyone who responded. As most of you said, this won't work. I
> ran a test. The DSN1COPY ran without errors but when I tried selecting rows
> in each partition, I got this error.
>
> 00C90101
>
> Explanation: The data manager detected an internal error within DB2. This
> error may indicate inconsistent data or an error
> in internal DB2 control structures or code.
>
>
>
> _____________________________________________________________________
> * IDUG North America * Anaheim, California * May 2-6 2011 *
> http://IDUG.ORG/NA *
> * If you are going to attend only one conference this year, this is it!
> *
> ** The best DB2 technical sessions in the world
> ** Independent, not-for-profit, User Run - the IDUG difference!
> _____________________________________________________________________
>
> If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is
> the home of IDUG's Listserv
>



--
Robert Catterall
DB2 Specialist
IBM US - East
[login to unmask email]

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv