Trigger removed

525 pts.
Tags:
AS/400
IBM DB2
RPGLE
How to know if some one had removed the trigger from the file? We have a situation like this so how to know who did that? Shall we get the data from journaling?

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 5  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Anu143
    awaiting quick reply..
    525 pointsBadges:
    report
  • TomLiotta
    The schema journal will have a D/TD entry for the deleted trigger. -- Tom
    125,585 pointsBadges:
    report
  • Anu143
    oh no.. we got journals only for three days .. I restored last months file and found that the trigger was present on the file
    525 pointsBadges:
    report
  • TomLiotta
    If you have system auditing enabled for *DELETE, the system audit journal (QAUDJRN) will have a T/DO entry. You have a basic timeline that begins at the date of your last save and ends at the time you discovered the missing trigger. . Use the DSPAUDJRNE ENTTYP(DO) command to list entries in the time range. Search the output report for the physical name of the trigger to find a precise timestamp. Then use DSPJRN to look at actual T/DO entries from QAUDJRN to see details. . Without useful database journal receivers (that possibly ought to be saved for the previous month), the system audit journal is your only reasonable chance. . Since only a couple people should have authority to delete something like a database trigger, you should only have to ask those few. . Tom
    125,585 pointsBadges:
    report
  • Anu143
    yeah .. you are right tom.. only few are here.. having the authority to do those kind of changes.. many thanks for your help
    525 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following