DB2 9 Compression Dictionary

Jorg Lueke

DB2 9 Compression Dictionary
In reviewing the manual it is clear that tablespaces using partition-by-growth
have one single dictionary. I am assuming this implies that tablespaces for
range partitioned objects still use one dictionary per partition. If yes, the
question is if I do a LOAD RESUME on a partitioned object that contains data,
but no data inthe partition(s) that get loaded, will the utility build a dictionary
for those previously empty partitions?

The manual is a bit unclear and we won't get to testing this quite yet.

Also, users do be aware that we have had tablespaces where DB2 9 built less
efficient dictionaries that DB2 V8 and the reorg job did run out of space.

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

William Favero

Re: DB2 9 Compression Dictionary
(in response to Jorg Lueke)
When a new partition is created for a partition by growth UTS table
space, it does have a dictionary inherited from the previous partition.

Willie

Jorg Lueke wrote:
> In reviewing the manual it is clear that tablespaces using partition-by-growth
> have one single dictionary. I am assuming this implies that tablespaces for
> range partitioned objects still use one dictionary per partition. If yes, the
> question is if I do a LOAD RESUME on a partitioned object that contains data,
> but no data inthe partition(s) that get loaded, will the utility build a dictionary
> for those previously empty partitions?
>
> The manual is a bit unclear and we won't get to testing this quite yet.
>
> Also, users do be aware that we have had tablespaces where DB2 9 built less
> efficient dictionaries that DB2 V8 and the reorg job did run out of space.
>
> ______________________________________________________________________
>
> * IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
> ______________________________________________________________________
>
>
>
> The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms
>
>
>

--
Willie
My DB2 blog --> http://blogs.ittoolbox.com/database/db2zos
Houston, TX, USA

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms