Delete Operational Metadata

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
mavrick21
Premium Member
Premium Member
Posts: 335
Joined: Sun Apr 23, 2006 11:25 pm

Delete Operational Metadata

Post by mavrick21 »

Hello

Is there a way to selectively delete Operational Metadata from the repository?

Thanks
eostic
Premium Member
Premium Member
Posts: 3838
Joined: Mon Oct 17, 2005 9:34 am

Post by eostic »

Istool has specific syntax for this.....but what release are you on. ?
Ernie Ostic

blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
mavrick21
Premium Member
Premium Member
Posts: 335
Joined: Sun Apr 23, 2006 11:25 pm

Post by mavrick21 »

Ernie,

We're on 8.5 Server Edition FP1 on Linux and our Metadata Repository is on Oracle 11.2.

What we are trying to do is delete out the Operational Metadata older than a year. Thanks for your pointer - I was able to research online and find "istool deletecm". Is this the one I should use? I can't seem to find syntax or examples on how to use this. Would be helpful if you could throw more light on this.

Thanks! Appreciate it!
eostic
Premium Member
Premium Member
Posts: 3838
Joined: Mon Oct 17, 2005 9:34 am

Post by eostic »

In 8.5 it is not via istool.... if memory serves, you will find a purfe omd script in /AsbNode/bin Cant remember its exact name but I recall it being fairly clear by the name.......issue it without args or with -help and it will show the syntax.

11.3 users will find it as..... istool workbench purgeOMD

Ernie


.....dont use deletecm ! That is for deleting common metadata......all tables files columns databases etc.

Ernie
Ernie Ostic

blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
Post Reply