Trace Job Deletion

myukassign · Post by **myukassign** » Wed Nov 05, 2008 4:48 am

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

ray.wurlod · Post by **ray.wurlod** » Wed Nov 05, 2008 7:13 am

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.

chulett · Post by **chulett** » Wed Nov 05, 2008 7:42 am

DataStage has "oops tracing"? Cool.

myukassign · Post by **myukassign** » Wed Nov 05, 2008 8:34 am

how can i see the content of this DS.AUDIT table?

Is there a way i can query that

ray.wurlod · Post by **ray.wurlod** » Wed Nov 05, 2008 8:49 am

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';

myukassign · Post by **myukassign** » Wed Nov 05, 2008 9:00 am

OOPS...

i got an error

"DataStage/SQL: Table "DS.AUDIT" does not exist."

What can be done on it?

chulett · Post by **chulett** » Wed Nov 05, 2008 9:07 am

It's actually DS_AUDIT, I do believe.

throbinson · Post by **throbinson** » Wed Nov 05, 2008 9:47 am

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';

ray.wurlod · Post by **ray.wurlod** » Wed Nov 05, 2008 12:22 pm

I cannot brain today; I have the dumb.

myukassign · Post by **myukassign** » Tue Nov 18, 2008 3:46 am

Got it....

That solved my issue