Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
3 replies Latest Post - ‏2012-08-29T19:15:31Z by smithha
MoatazElSayed
MoatazElSayed
14 Posts
ACCEPTED ANSWER

Pinned topic Table Management is not deleting physically from the repository database

‏2012-08-29T10:29:01Z |
Hi All,

I'm facing issue while using Table Management to delete tables from DB2 repository. Actually the option is working through the application but physically it is not deleting from the repository database.

Do you have any ideas or suggestions?

Regards,
Moataz ElSayed
Updated on 2012-08-29T19:15:31Z at 2012-08-29T19:15:31Z by smithha
  • smithha
    smithha
    162 Posts
    ACCEPTED ANSWER

    Re: Table Management is not deleting physically from the repository database

    ‏2012-08-29T14:00:22Z  in response to MoatazElSayed
    You may need to confirm that the userid in the Analysis Database settings actually has been Granted authority to Delete the physical tables.

    Harald
  • MoatazElSayed
    MoatazElSayed
    14 Posts
    ACCEPTED ANSWER

    Re: Table Management is not deleting physically from the repository database

    ‏2012-08-29T19:06:08Z  in response to MoatazElSayed
    Hi Harald,

    I'm using IAUSER user on DB2. I ensured that the user can drop tables using that user.

    Regards,
    Moataz
    • smithha
      smithha
      162 Posts
      ACCEPTED ANSWER

      Re: Table Management is not deleting physically from the repository database

      ‏2012-08-29T19:15:31Z  in response to MoatazElSayed
      If that's the case, then I'd recommend following up with customer support.

      Harald