DSXchange

We found that this particular table in xmeta LOGGING_XMETAGEN_LOGGINGEVENT1466CB5F has around 2.6 million rows...we are deleting all the records having category IIS-DSTAGE-RUN which are the logs stored in the database...i think our problem would be solved....we confirmed from the IBM tech support re...

actually we purged the logs recently and scheduled to purge on a daily basis, which we didnt do it before...but after RTlogging was changed to pre 8.1 loggin and also after clearing the logs upto 50% or so, the size of xmeta doesnt decrease...and we also tried to shrink the xmeta tableas well as DB,...

I am facing the same issue as chanaka, but the db i have is sql server 2005..rest everything is similar...

We have the latest version of datastage 8.1 in our production server,
the size of the xmeta increased to 50gb currently as our project went live from jan1st, 2010...can anyone help me on this????