[DB2-L] DB2 9 Compression Dictionary

Walter Janißen

[DB2-L] DB2 9 Compression Dictionary
Yes

In V8 we had a problem with this, because there was a bug in DB2. But after installing a PTF (haven't the number at hand) DB2 works as expected. The empty partitions got their dictionary, when loaded.

As you may know, in DB2 V9 CM there is a new option for LOAD: COPYDICTIONARY. I have tested it and it works, but the syntax is a bit different than described in the cover letter:

LOAD DATA LOG YES COPYDICTIONARY n
INTO TABLE table PART m REPLACE

Mit freundlichen Grüßen
Walter Janißen

ITERGO Informationstechnologie GmbH
Anwendungsentwicklung
Laufzeitarchitektur
Victoriaplatz 2
40198 Düsseldorf
mailto:[login to unmask email]

Vorsitzender des Aufsichtsrats: Jürgen Vetter
Geschäftsführung: Dr. Bettina Anders (Vorsitzende),
Dr. Christian Nymphius, Dr. Michael Regauer, Wolfgang Schön.
Sitz: Düsseldorf, Handelsregister: Amtsgericht Düsseldorf, HRB 37996

-----Ursprüngliche Nachricht-----
Von: DB2 Data Base Discussion List [mailto:[login to unmask email] Im Auftrag von Jorg Lueke
Gesendet: Montag, 22. Dezember 2008 16:28
An: [login to unmask email]
Betreff: [DB2-L] 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

______________________________________________________________________

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




IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html