How? I can drop all the constraints, I can drop all my indexes. I can check for triggers... no, no triggers.
But the "rename table a to b" keeps failing with a -750 error.
Yeah, there are still some indexes left: block and diminstion indexes due to the MDC definition so I cannot drop them.

So I assume that those indexes are stopping me: I checked with db2cc and with Data Studio and I cannot find any depending objects. I checked the db2diag message for usefull info.... nothing there.

How can I determine which dependy is blocking my "rename table"?

- For views or materialized query tables, query SYSCAT.VIEWDEP
- For triggers, query SYSCAT.TRIGDEP
- For SQL functions or SQL methods, query SYSCAT.FUNCDEP
- For check constraints, query SYSCAT.CHECKS
- For referential constraints, query SYSCAT.REFERENCES

I guess thats it.....

Thanks, that's usefull info. I think I know: there is a generated column in there... cannot be dropped because that column is used as 1 of the MDC dimensions.
How is that called in english? Shoot yourself in the foot?