Enable "Generate Operational Metadata"

vinay_renu2001 · Post by **vinay_renu2001** » Wed Mar 21, 2012 8:22 am

Hello Everyone!

I would like to enable the option "Generate Operational Metadata" which is in DataStage Administrator ver 8.1 under "General Tab" through a shell script.

I would need to automate this by writing a script which will enable and disable the above mentioned option for all the projects created on a particular IIS Server.

I would like to know the possible options to achieve this?

Appreciate all the inputs!

arvind_ds · Post by **arvind_ds** » Wed Mar 21, 2012 9:58 am

I think this feature of generating operational metadata through script is not available in version 8.1

PaulVL · Post by **PaulVL** » Wed Mar 21, 2012 10:38 am

What are you trying to accomplish?

Perhaps there is another method instead of dynamically toggling that setting.

vinay_renu2001 · Post by **vinay_renu2001** » Wed Mar 21, 2012 11:44 am

Hello Paul,

Thanks for the response.

What i am trying to achieve is, I want to enable the option "Generate Operational Metadata" for a short period of time of One day for example on all the projects on a Server, let the jobs run on all the projects, Then Turn Off the option. So that, the operational metadata that is created during that period can be imported into repository and can generate reports from Metadata Workbench.

vinay_renu2001 · Post by **vinay_renu2001** » Wed Mar 21, 2012 11:58 am

Hello Ernie,

I do not have the liberty to touch the existing code on any projects that are already created & will be created to use the arguement [-opmetadata [TRUE | FALSE]] during run time. This idea is not viable for me at this time.

What i am trying to achieve is to create a report with the list of all the Categories (Directories) under /Jobs and the last job run info in each Category.

eostic · Post by **eostic** » Wed Mar 21, 2012 1:21 pm

I wouldn't suggest using OMD for that...and you certainly don't want to arbitrarily turn on OMD at the project level (it can be done at the administrator client but it not something to do without a lot of awareness of the jobs and the project, etc.).

Do your own inspection using dsjob...it can pull out status of jobs and such...... search the threads here...there must be thousands of entries on the use of, and impact of, dsjob.

Ernie

vinay_renu2001 · Post by **vinay_renu2001** » Thu Mar 22, 2012 9:35 am

Hello Ernie,

Appreciate your response.

This is not at all arbitrary. And, we are fully aware of the repercussions of enabling OMD at project level. For that reason, we do not want to keep it enabled for an extended period of time.

However, i would refrain from discussing more about the non-technical issues.

eostic · Post by **eostic** » Thu Mar 22, 2012 10:31 am

I doubt seriously if there is any "normal" or "formal" way to change that value at the project level programmatically. You may just have to use the GUI.

Ernie