xmeta size abruptly increases in production

venky144 · Post by **venky144** » Sat Aug 21, 2010 9:24 pm

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????

chulett · Post by **chulett** » Sat Aug 21, 2010 9:44 pm

Have your DBA track down the large objects in the database, I would suspect they'll be job log related. Are they being purged on a regular basis?

Edited to add: Found you posted here as well so it seems that may indeed be the case.

venky144 · Post by **venky144** » Sat Aug 21, 2010 9:53 pm

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, but no use although....

chulett · Post by **chulett** » Sun Aug 22, 2010 6:40 am

Have you confirmed what in fact is taking the majority of space in the database? Is it still the log tables? Also sounds like you may want to involve your official support provider if your DBA needs some help identifying tables and recovering space in the database.

venky144 · Post by **venky144** » Mon Aug 23, 2010 1:22 pm

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 regarding this issue to be solved...
thanks chulett for advising....