Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2008
    Posts
    76

    Unanswered: Dropped Nickname

    Hi Folks,


    Can you please tell me how we find when a nickname was dropped and who dropped it ?

    I have tried list history but it does not list the dropped nickname.

    Please suggest.


    Thanks,
    Pandit

  2. #2
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    If you didn't audit your system, you're out of luck to determine something like this after the fact. You may be able to analyze the log files (if you have archival logging) to find the timestamp of the transaction involving the DROP NICKNAME.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

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