Bernard,
you can use only :
db2 "inspect check tablespaces tbspaceid <nn> results keep inspect.out",
after that you have to format the output:
db2inspf inspect.out inspect.rpt
You will find a line in the report like:
"The index type is 2 for this table"
after a convert to index-type2.
regards,
Joachim Müller
"Bernard Dhooghe" <no***@attglobal.net> schrieb im Newsbeitrag
news:25**************************@posting.google.c om...
"Mark A" <no****@nowhere.com> wrote in message
news:<Sh****************@news.uswest.net>...
"Pierre Saint-Jacques" <se*****@attglobal.net> wrote in message
news:41**************@attglobal.net... The REORG command in V8 has an option to CONVERT the indexes of any
table from Type 1 to 2.
I'm not sure but I think the syscat.indexes has a column that will
indicate the type.
All indexes will stay of Type 1 on any table after migrate, even new
ones created, until the convert has been done.
HTH, Pierre.
REORG INDEXES will always convert type-1 indexes to type-2 indexes
unless you use the CLEANUP option.
If you use the CONVERT option on the REORG, the indexes will be
converted to type-2, but will not actually be reorged.
REORG is on table level. So to migrate indexes, a table by table
approach is needed at this time.
Knowing for sure if an index is type-1 or type-2 is something more
than nice to know. But I don't find a command for this (or a
documented syscat indicator).
Bernard Dhooghe