Retrieving the details of the Dataset

manojkumar.sesuraj · New User Joined: 15 Apr 2009 Posts: 43 Location: Mumbai

Hi,
I have a dataset which was created in last week. I want to store all actions which were done by the same dataset.

The actions can be,

> If the dataset was copied by others
> Browse, Edit, View by others
> If any Job has used the dataset

I want to store these details in a report. This report shows,

Dataset name | Date of creation/Changed | Time of creation/Changed | User id/Job Name |

I know, how to find the owner of the dataset. And, I know that SMF is used to store all detais.

Can anybody help me on this!!!

expat · Posted: Fri Jul 17, 2009 11:15 am

Please explain the business requirement for this request. And here are one or two things to ponder regarding your request.

How do you propose to find out if it was copied. The dataset would be open for input, but input to what. You will need to do a lot more investigation for that one.

Browse / Edit by other users. If the dataset is open for output (includes update) but was not updated, how will you tell.

If a job has used the dataset, type 14 or 15 will tell you that.

manojkumar.sesuraj · New User Joined: 15 Apr 2009 Posts: 43 Location: Mumbai

Thanks Expat...

There is no business requirement behind this...
This is just my innovation... From this we can check how many times the dataset was used by others...

Please let me know if it is possible...

expat · Posted: Fri Jul 17, 2009 12:08 pm

This is another reinvent the wheel scenario.

Everything that you need to know is almost certainly already captured by the system in the SMF records. These are usually processed by the performance and capacity planning bods and they produce reports and store the processed data.

If the report does not already exist then the data to easily produce it probably does.

manojkumar.sesuraj · New User Joined: 15 Apr 2009 Posts: 43 Location: Mumbai

Thanks Expat... I ll try with SMF records...