Hi DB2 users,

I am using DB2 UDB V6 on z/OS, the only way that i know for get the
lenght of a index is summarize every column length getting this
information joining the SYSIBM.SYSKEYS and the
SYSIBM.SYSCOLUMNS....someone know a faster and maybe more direct
system for get this informations from DB2?

About reorg online i must define manually the shadow datasets because
if i don't do it, DB2 define the shadow ds on the same volume which
sometime have not enough space...can it depend from SMS settings?