Page 1 of 1
Trace Job Deletion
Posted: Wed Nov 05, 2008 4:48 am
by myukassign
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
Posted: Wed Nov 05, 2008 7:13 am
by ray.wurlod
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.
Posted: Wed Nov 05, 2008 7:42 am
by chulett
DataStage has "oops tracing"? Cool.
Posted: Wed Nov 05, 2008 8:34 am
by myukassign
how can i see the content of this DS.AUDIT table?
Is there a way i can query that
Posted: Wed Nov 05, 2008 8:49 am
by ray.wurlod
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';
Posted: Wed Nov 05, 2008 9:00 am
by myukassign
OOPS...
i got an error
"DataStage/SQL: Table "DS.AUDIT" does not exist."
What can be done on it?
Posted: Wed Nov 05, 2008 9:07 am
by chulett
It's actually DS_AUDIT, I do believe.
Posted: Wed Nov 05, 2008 9:47 am
by throbinson
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';
Posted: Wed Nov 05, 2008 12:22 pm
by ray.wurlod
I cannot brain today; I have the dumb.
Posted: Tue Nov 18, 2008 3:46 am
by myukassign
Got it....
That solved my issue