The X-Files: Rebuild Index

Peter Adlersburg

The X-Files: Rebuild Index
Dear DB2-Colleagues,

Recently I ran the following Utility:

LISTDEF RECOVERY_LIST
INCLUDE TABLESPACE DS01*.* PARTLEVEL
EXCLUDE TABLESPACE DS01ASS.* PARTLEVEL
EXCLUDE TABLESPACE DS01UDA.TS01USO1 PARTLEVEL

RECOVER LIST RECOVERY_LIST
TORBA X'0981A343FC04'

REBUILD INDEX LIST RECOVERY_LIST
SORTDEVT SYSDA
SORTNUM 40

Everything runs nice and quick until things come to rebuilding the indexes of
partitioned tables. Here is one output-example:

PROCESSING LIST ITEM: TABLESPACE DS01UDP.TS01USU1 PARTITION
24
INDEXES WILL BE BUILT IN PARALLEL, NUMBER OF TASKS = 7
INDEX NAME= S01.USUKEY2 PART=24 IS EMPTY
INDEX NAME= S01.USUKEY1 PART=24 IS EMPTY
INDEX NAME= S01.USUKEY3 PART=24 IS EMPTY
UNLOAD PHASE STATISTICS - NUMBER OF RECORDS
PROCESSED=0
UNLOAD PHASE COMPLETE - ELAPSED TIME=00:00:00
SORTBLD PHASE STATISTICS - NUMBER OF KEYS=0 FOR INDEX S01.USUKEY2
PART 24
BUILD PHASE STATISTICS - NUMBER OF KEYS=0 FOR INDEX
S01.USUKEY3
BUILD PHASE STATISTICS - NUMBER OF KEYS=0 FOR INDEX
S01.USUKEY1
SORTBLD PHASE STATISTICS. NUMBER OF INDEXES = 3
SORTBLD PHASE COMPLETE, ELAPSED TIME = 00:18:59

ehem ... 19 Minutes for ZERO keys?? and that's just one example. Times for
rebuilding Partitioned Indexes and NPIs for empty partitions range from 6 up to
20 Minutes. Any hints on this pretty considerable times and how to improve /
avoid them are welcome. We're talking DB2 V8 on z/OS.

thanks and kind regards,

peter

______________________________________________________________________

* 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

Steen Rasmussen

Re: The X-Files: Rebuild Index
(in response to Peter Adlersburg)
A wild guess - are the empty partitions migrated ?

Steen Rasmussen
CA



-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf Of Peter Adlersburg
Sent: Monday, December 22, 2008 2:50 AM
To: [login to unmask email]
Subject: [DB2-L] The X-Files: Rebuild Index

Dear DB2-Colleagues,

Recently I ran the following Utility:

LISTDEF RECOVERY_LIST
INCLUDE TABLESPACE DS01*.* PARTLEVEL
EXCLUDE TABLESPACE DS01ASS.* PARTLEVEL
EXCLUDE TABLESPACE DS01UDA.TS01USO1 PARTLEVEL

RECOVER LIST RECOVERY_LIST
TORBA X'0981A343FC04'

REBUILD INDEX LIST RECOVERY_LIST
SORTDEVT SYSDA
SORTNUM 40

Everything runs nice and quick until things come to rebuilding the indexes of
partitioned tables. Here is one output-example:

PROCESSING LIST ITEM: TABLESPACE DS01UDP.TS01USU1 PARTITION
24
INDEXES WILL BE BUILT IN PARALLEL, NUMBER OF TASKS = 7
INDEX NAME= S01.USUKEY2 PART=24 IS EMPTY
INDEX NAME= S01.USUKEY1 PART=24 IS EMPTY
INDEX NAME= S01.USUKEY3 PART=24 IS EMPTY
UNLOAD PHASE STATISTICS - NUMBER OF RECORDS
PROCESSED=0
UNLOAD PHASE COMPLETE - ELAPSED TIME=00:00:00
SORTBLD PHASE STATISTICS - NUMBER OF KEYS=0 FOR INDEX S01.USUKEY2
PART 24
BUILD PHASE STATISTICS - NUMBER OF KEYS=0 FOR INDEX
S01.USUKEY3
BUILD PHASE STATISTICS - NUMBER OF KEYS=0 FOR INDEX
S01.USUKEY1
SORTBLD PHASE STATISTICS. NUMBER OF INDEXES = 3
SORTBLD PHASE COMPLETE, ELAPSED TIME = 00:18:59

ehem ... 19 Minutes for ZERO keys?? and that's just one example. Times for
rebuilding Partitioned Indexes and NPIs for empty partitions range from 6 up to
20 Minutes. Any hints on this pretty considerable times and how to improve /
avoid them are welcome. We're talking DB2 V8 on z/OS.

thanks and kind regards,

peter

______________________________________________________________________

* 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/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

Michael Ebert

Re: The X-Files: Rebuild Index
(in response to Steen Rasmussen)
The time will be spent in the BUILD phase for the two NPIs, USUKEY1 and
USUKEY3; the BUILD phase is a slow, SQL-type update of the index, not a
fast utility-type action. Depending on the index columns (and the
cleverness of the optimiser), the full indexes have to be scanned looking
for entries that point to the recovered partitions in order to remove them
(after the PiT recovery, the partition was empty - but there may have been
millions of entries before; and every index entry of all NPIs may need to
have its RID list updated).

I think DB2 V8 introduced DPSIs to deal with exactly that type of issue.

Dr. Michael Ebert
DB2 & Oracle Database Administrator
aMaDEUS Data Processing
Erding / Munich, Germany




"Rasmussen, Steen" <[login to unmask email]>
To
[login to unmask email]
cc

bcc

Subject
Re: [DB2-L] The X-Files: Rebuild Index





"Rasmussen, Steen" <[login to unmask email]>
Please respond to : DB2 Database Discussion list at IDUG
<[login to unmask email]>
Sent by: DB2 Data Base Discussion List <[login to unmask email]>
22-12-08 10:22


A wild guess - are the empty partitions migrated ?

Steen Rasmussen
CA



-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
Of Peter Adlersburg
Sent: Monday, December 22, 2008 2:50 AM
To: [login to unmask email]
Subject: [DB2-L] The X-Files: Rebuild Index

Dear DB2-Colleagues,

Recently I ran the following Utility:

LISTDEF RECOVERY_LIST
INCLUDE TABLESPACE DS01*.* PARTLEVEL
EXCLUDE TABLESPACE DS01ASS.* PARTLEVEL
EXCLUDE TABLESPACE DS01UDA.TS01USO1 PARTLEVEL

RECOVER LIST RECOVERY_LIST
TORBA X'0981A343FC04'

REBUILD INDEX LIST RECOVERY_LIST
SORTDEVT SYSDA
SORTNUM 40

Everything runs nice and quick until things come to rebuilding the indexes
of
partitioned tables. Here is one output-example:

PROCESSING LIST ITEM: TABLESPACE DS01UDP.TS01USU1 PARTITION
24
INDEXES WILL BE BUILT IN PARALLEL, NUMBER OF TASKS = 7
INDEX NAME= S01.USUKEY2 PART=24 IS EMPTY
INDEX NAME= S01.USUKEY1 PART=24 IS EMPTY
INDEX NAME= S01.USUKEY3 PART=24 IS EMPTY
UNLOAD PHASE STATISTICS - NUMBER OF RECORDS
PROCESSED=0
UNLOAD PHASE COMPLETE - ELAPSED TIME=00:00:00
SORTBLD PHASE STATISTICS - NUMBER OF KEYS=0 FOR INDEX S01.USUKEY2
PART 24
BUILD PHASE STATISTICS - NUMBER OF KEYS=0 FOR INDEX
S01.USUKEY3
BUILD PHASE STATISTICS - NUMBER OF KEYS=0 FOR INDEX
S01.USUKEY1
SORTBLD PHASE STATISTICS. NUMBER OF INDEXES = 3
SORTBLD PHASE COMPLETE, ELAPSED TIME = 00:18:59

ehem ... 19 Minutes for ZERO keys?? and that's just one example. Times for

rebuilding Partitioned Indexes and NPIs for empty partitions range from 6
up to
20 Minutes. Any hints on this pretty considerable times and how to improve
/
avoid them are welcome. We're talking DB2 V8 on z/OS.

thanks and kind regards,

peter




IMPORTANT - CONFIDENTIALITY NOTICE - This e-mail is intended only for
the use of the individual or entity shown above as addressees. It may
contain information which is privileged, confidential or otherwise
protected from disclosure under applicable laws. If the reader of this
transmission is not the intended recipient, you are hereby notified that
any dissemination, printing, distribution, copying, disclosure or the
taking of any action in reliance on the contents of this information is
strictly prohibited. If you have received this transmission in error,
please immediately notify us by reply e-mail or using the address below
and delete the message and any attachments from your system.

Amadeus Data Processing GmbH
Geschäftsführer: Eberhard Haag
Sitz der Gesellschaft: Erding
HR München 48 199
Berghamer Strasse 6
85435 Erding
Germany

______________________________________________________________________

* 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

Peter Adlersburg

Re: The X-Files: Rebuild Index
(in response to Michael Ebert)
Gentlemen,

Thanks so far for your comments. By the way: DPSIs - as suggested by Mr.
Ebert - are out of question, since they must not be unique, which in this case
is a requirement for the NPIs of the table.

kind regards,

peter

______________________________________________________________________

* 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

Steen Rasmussen

Re: The X-Files: Rebuild Index
(in response to Peter Adlersburg)
In fact DPSI's can be unique if they are a superset of the partitioning scheme

Steen Rasmussen
CA



-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf Of Peter Adlersburg
Sent: Monday, December 22, 2008 4:35 AM
To: [login to unmask email]
Subject: Re: [DB2-L] The X-Files: Rebuild Index

Gentlemen,

Thanks so far for your comments. By the way: DPSIs - as suggested by Mr.
Ebert - are out of question, since they must not be unique, which in this case
is a requirement for the NPIs of the table.

kind regards,

peter

______________________________________________________________________

* 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/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

Steen Rasmussen

Re: The X-Files: Rebuild Index
(in response to Steen Rasmussen)
Correction - Phil Grainger mentioned to me that Unique DPSIs (being a superset of the partitioning scheme) aren't supported until you're on DB2 9.
We are pretty current on DB2 V8 maintenance, so I just tried to create a Unique DPSI - but DB2 issues SQL-628 saying the clauses are mutually exclusive in V8.


Steen Rasmussen
CA


-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf Of Peter Adlersburg
Sent: Monday, December 22, 2008 4:35 AM
To: [login to unmask email]
Subject: Re: [DB2-L] The X-Files: Rebuild Index

Gentlemen,

Thanks so far for your comments. By the way: DPSIs - as suggested by Mr.
Ebert - are out of question, since they must not be unique, which in this case
is a requirement for the NPIs of the table.

kind regards,

peter

______________________________________________________________________

* 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/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/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

Peter Backlund

Re: The X-Files: Rebuild Index
(in response to Steen Rasmussen)
Isn't that only in DB2 9?

Peter

Rasmussen, Steen wrote: In fact DPSI's can be unique if they are a superset of the partitioning scheme Steen Rasmussen CA -----Original Message----- From: DB2 Data Base Discussion List [mailto:[login to unmask email]] On Behalf Of Peter Adlersburg Sent: Monday, December 22, 2008 4:35 AM To: [login to unmask email] Subject: Re: [DB2-L] The X-Files: Rebuild Index Gentlemen, Thanks so far for your comments. By the way: DPSIs - as suggested by Mr. Ebert - are out of question, since they must not be unique, which in this case is a requirement for the NPIs of the table. kind regards, peter ______________________________________________________________________ * 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/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
No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.176 / Virus Database: 270.9.19/1860 - Release Date: 2008-12-21 15:08
-- Attend IDUG 2009, North America -- 11-15 May in Denver, Colorado Attend IDUG 2009, Europe -- 5- 9 October in Rome, Italy Learn more at http://www.idug.org +-------------------------------+---------------------------------+ | Peter G Backlund | Telephone: 08 - 38 69 08 | | Peter Backlund DB2-Konsult AB | Mobile: 070 - 764 7554 | | Rasundavagen 94 | Country Code (Sweden): 46 | | S-169 57 SOLNA | Skype: BacklundDB2 | | Sweden | E-mail: [login to unmask email] | +-------------------------------+---------------------------------+ | IBM Database GOLD Consultant | +-------------------------------+---------------------------------+ | Working with DB2 since 1981 ... and forever! | +-----------------------------------------------------------------+

IDUG 2009 - North America * May 11-15, 2009 * Denver, CO, USA

The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at IDUG.ORG 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

Dale Hardy

Re: The X-Files: Rebuild Index
(in response to Peter Backlund)
We are on V8 and have a data partitioned table partitioned and clustered
on a single column, col1, with 2 partitioned indexes defined as unique
Index1 (col1, col2)
Index2 (col1, col3, col4, col2)

DB2 9 will allow you to define a unique index as (col2,col1).

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Rasmussen, Steen
Sent: Monday, December 22, 2008 7:03 AM
To: [login to unmask email]
Subject: Re: [DB2-L] The X-Files: Rebuild Index

Correction - Phil Grainger mentioned to me that Unique DPSIs (being a
superset of the partitioning scheme) aren't supported until you're on
DB2 9.
We are pretty current on DB2 V8 maintenance, so I just tried to create a
Unique DPSI - but DB2 issues SQL-628 saying the clauses are mutually
exclusive in V8.


Steen Rasmussen
CA


-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Peter Adlersburg
Sent: Monday, December 22, 2008 4:35 AM
To: [login to unmask email]
Subject: Re: [DB2-L] The X-Files: Rebuild Index

Gentlemen,

Thanks so far for your comments. By the way: DPSIs - as suggested by Mr.

Ebert - are out of question, since they must not be unique, which in
this case
is a requirement for the NPIs of the table.

kind regards,

peter

______________________________________________________________________

* 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/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/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
*****************************************************************
IF YOU RECEIVED THIS EMAIL IN ERROR, YOU SHOULD NOTIFY THE SENDER
BY REPLY EMAIL AND THEN DELETE IT (INCLUDING ANY ATTACHMENTS).
*****************************************************************

______________________________________________________________________

* 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

Edward Long

Re: The X-Files: Rebuild Index
(in response to Dale Hardy)
While I haven't seen 20 minute zero row rebuilds I have noticed that the V8 utilities construct large numbers of related TCB's even when there is no data to process.
I suspect my longer than expected elapsed times have to do with all those attach's, catalog accesses, SVC99's etc.
In one case, 24 tcb's were attached long enough to determine that there was nothing to do.

Edward Long


--- On Mon, 12/22/08, Hardy, Dale <[login to unmask email]> wrote:

> From: Hardy, Dale <[login to unmask email]>
> Subject: Re: [DB2-L] The X-Files: Rebuild Index
> To: [login to unmask email]
> Date: Monday, December 22, 2008, 11:05 AM
> We are on V8 and have a data partitioned table partitioned
> and clustered
> on a single column, col1, with 2 partitioned indexes
> defined as unique
> Index1 (col1, col2)
> Index2 (col1, col3, col4, col2)
>
> DB2 9 will allow you to define a unique index as
> (col2,col1).
>
> -----Original Message-----
> From: DB2 Data Base Discussion List
> [mailto:[login to unmask email] On
> Behalf Of Rasmussen, Steen
> Sent: Monday, December 22, 2008 7:03 AM
> To: [login to unmask email]
> Subject: Re: [DB2-L] The X-Files: Rebuild Index
>
> Correction - Phil Grainger mentioned to me that Unique
> DPSIs (being a
> superset of the partitioning scheme) aren't supported
> until you're on
> DB2 9.
> We are pretty current on DB2 V8 maintenance, so I just
> tried to create a
> Unique DPSI - but DB2 issues SQL-628 saying the clauses are
> mutually
> exclusive in V8.
>
>
> Steen Rasmussen
> CA
>
>
> -----Original Message-----
> From: DB2 Data Base Discussion List
> [mailto:[login to unmask email] On
> Behalf Of Peter Adlersburg
> Sent: Monday, December 22, 2008 4:35 AM
> To: [login to unmask email]
> Subject: Re: [DB2-L] The X-Files: Rebuild Index
>
> Gentlemen,
>
> Thanks so far for your comments. By the way: DPSIs - as
> suggested by Mr.
>
> Ebert - are out of question, since they must not be unique,
> which in
> this case
> is a requirement for the NPIs of the table.
>
> kind regards,
>
> peter
>
> ______________________________________________________________________
>
> * 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/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/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
> *****************************************************************
> IF YOU RECEIVED THIS EMAIL IN ERROR, YOU SHOULD NOTIFY THE
> SENDER
> BY REPLY EMAIL AND THEN DELETE IT (INCLUDING ANY
> ATTACHMENTS).
> *****************************************************************
>
> ______________________________________________________________________
>
> * 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/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