Hi all,
what are the possible ways to convert a non partitioned index to a
partitioned index in DB2 V9.7.1?

According to the InfoCenter, the only way is to drop and recreate one index
at a time
(http://publib.boulder.ibm.com/infoce.../t0054730.html)

I was wondering if it were also possible to make the conversion with only
one command, such as REORG TABLE... or something like that?

Regards,
Damir

On 3/4/2010 6:44 AM, Damir wrote:

It should be easy to write a stored procedure that, given a table table
converts all global indexes to local indexes...

Cheers
Serge


--
Serge Rielau
SQL Architect DB2 for LUW
IBM Toronto Lab

Of course it is and that is what we are going to do.
I was just wondering... :-)
Thank you for the quick response!

Regards,
Damir

---
"Serge Rielau" <srielau (AT) ca (DOT) ibm.com> wrote

On Mar 4, 5:25*am, "Damir" <damirwil... (AT) yahoo (DOT) com> wrote:
One thing to add is that DB2 allows creation of partitioned and
nonpartitioned indexes on the same columns. One of the reasons for
allowing this was to ease this conversion where users first create the
desired partitioned indexes and then drop all nonpartitioned indexes.
That way, queries could continue to access the data using indexes when
the partitioned indexes are being created. As to whether the
nonpartitioned indexes should be dropped one by one or all at end,
space considerations may influence this decision.

Naresh