Resizing LOB Tablespaces

Paul Packham

Resizing LOB Tablespaces
Hi,

We are installing the new release of SAP (WAS 620). This has introduced us LOB
tablespaces. A few of these tablespaces are in multi extents, so I tried to release
these extends with a Reorg, not realising that DB2 would not unload/reload the LOBs
and delete/redefine the underlying dataset. So my question is am I OK to use
something like REPRO to copy the tablespace, delete and redefine the cluster and
REPRO the data back in again ?

Thanks,
Paul

This email and any attachments are confidential and intended for the addressee
only. If you are not the named recipient, you must not use, disclose, reproduce,
copy or distribute the contents of this communication. If you have received this
in error, please contact the sender and then delete this email from your system.



Patric Becker

Re: Resizing LOB Tablespaces
(in response to Paul Packham)
Paul,

assuming that you are on OS/390 or z/OS :

The only way to adjust the primary allocation, that is, when you need
to delete / define the LOB table space, is to run the RECOVER utility.

Hope this helps

Regards,
Patric



Patrick Hignett

Re: Resizing LOB Tablespaces
(in response to Patric Becker)
Paul
All you need to do is image copy, alter the PRIQTY and SECQTY and then recover. Do not do a recover to just a straight recover. This has worked fine for me.

Paul Packham wrote:

> Hi,
>
> We are installing the new release of SAP (WAS 620). This has introduced us LOB
> tablespaces. A few of these tablespaces are in multi extents, so I tried to release
> these extends with a Reorg, not realising that DB2 would not unload/reload the LOBs
> and delete/redefine the underlying dataset. So my question is am I OK to use
> something like REPRO to copy the tablespace, delete and redefine the cluster and
> REPRO the data back in again ?
>
> Thanks,
> Paul
>
> This email and any attachments are confidential and intended for the addressee
> only. If you are not the named recipient, you must not use, disclose, reproduce,
> copy or distribute the contents of this communication. If you have received this
> in error, please contact the sender and then delete this email from your system.
>
>
>