Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746

    Unanswered: rename a MDC table? (SQL0750N)

    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"?

  2. #2
    Join Date
    May 2007
    Location
    somewhere in dbforums
    Posts
    221
    - 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.....
    IBM Certified Database Associate, DB2 9 for LUW

  3. #3
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746
    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?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •