Trace Job Deletion
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 238
- Joined: Fri Jul 25, 2008 8:55 am
Trace Job Deletion
I got a problem.
Today when I logged in to my development enviorment, I could see many of the jobs are got deleted.
Is there a way to find out / Trace how that happend, why that happend? Who has did that?
Is there any place Datastage keep track of these things? Any suggestion will be of great help.
Note: i ahve back up but want to find out what happend actully. Oops tracing is not enabled for hat project
Today when I logged in to my development enviorment, I could see many of the jobs are got deleted.
Is there a way to find out / Trace how that happend, why that happend? Who has did that?
Is there any place Datastage keep track of these things? Any suggestion will be of great help.
Note: i ahve back up but want to find out what happend actully. Oops tracing is not enabled for hat project
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The DS.AUDIT table keeps track of the most recent time that an object was deleted, and by whom. Of course, it may be that nothing has been deleted and you can't see them because the indexing needs rebuilding.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Premium Member
- Posts: 238
- Joined: Fri Jul 25, 2008 8:55 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Use your Administrator client Command window.
Code: Select all
SELECT INSTANCE, PREVDTD, PREVDELETOR FROM DS.AUDIT WHERE PREV_DTD IS NOT NULL AND PREV_DTD <> '' AND CLASS = '2';
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Premium Member
- Posts: 238
- Joined: Fri Jul 25, 2008 8:55 am
-
- Charter Member
- Posts: 299
- Joined: Wed Nov 13, 2002 5:38 pm
- Location: USA
And PREVDTD not PREV_DTD
Code: Select all
SELECT INSTANCE, PREVDTD, PREVDELETOR FROM DS_AUDIT WHERE PREVDTD IS NOT NULL AND PREVDTD <> '' AND CLASS = '2';
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 238
- Joined: Fri Jul 25, 2008 8:55 am