Space issue for XMETA_DATA tablespace

sumesh.abraham · Post by **sumesh.abraham** » Wed Jun 18, 2014 12:59 pm

Hello all,

We are seeing issues with XMETA_DATA tablespace in the Dev Data Stage server. Only 1% is free and even after DBA adding 800M to the tablespace, it is used up quickly. I removed lot of test jobs that team created, but when I query the available space it did not have any change.
What are the other things that I can perform to claim space in this tablespace?. We don't have DataStage jobs running on the Dev server via a scheduler and from the initial investigation it does not look like any specific object is taking up much of space. We don't see this issue in Data Stage Prod server.

Appreciate your help.

chulett · Post by **chulett** » Wed Jun 18, 2014 3:20 pm

For grins... what database vendor?

sumesh.abraham · Post by **sumesh.abraham** » Wed Jun 18, 2014 3:36 pm

Hi Craig,

The database vendor is Oracle.

ray.wurlod · Post by **ray.wurlod** » Wed Jun 18, 2014 4:44 pm

Nothing is ever deleted automatically from XMETA; rather things are marked as deleted.

There are some cleanup scripts; check with your support provider to get the script names for Oracle.

ray.wurlod · Post by **ray.wurlod** » Wed Jun 18, 2014 4:48 pm

Are you storing your job logs in XMETA? These will consume a lot of space. That space can be cleared by purging the logs.

Best practice is not to store job logs in XMETA but, rather, to store them locally in the DataStage project.

qt_ky · Post by **qt_ky** » Wed Jun 18, 2014 8:11 pm

Check the Information Server Web Console for any special or custom detailed logging (tracing). If it is turned on for too long, it can eat up the repository space. I saw this happen on a PMR one time. Detailed logging was enabled while reproducing a problem, and then left on. Within a few days, XMETA ballooned up and filled the disk.

sumesh.abraham · Post by **sumesh.abraham** » Wed Jun 18, 2014 9:30 pm

I did an immediate purge for as many as 75 jobs and then queried the free space in XMETA_DATA tablespace. It has not claimed any space. That leaves an impression that the job logs are not stored in XMETA.
How can I check whether the logs are stored in XMETA?

I checked the Information Server Web Console for any special or custom detailed logging. Under 'Log Management' in web console, I can't see any detailed logging enabled.

Now, before contacting IBM support and trying to get the cleanup scripts for Oracle, is there any other thing that I can try to free up the space in XMETA?.

ray.wurlod · Post by **ray.wurlod** » Thu Jun 19, 2014 12:37 am

Use the Administrator client.
Check each project's properties on the Logging tab.
Make sure that "Enable Operational Repository logging" is NOT checked.

(If you are on an earlier version than 8.7, you will need to check in each project's DSParams file for RTLogging and ORLogging settings. ORLogging should be 0 and RTLogging should be 1.)

sumesh.abraham · Post by **sumesh.abraham** » Thu Jun 19, 2014 8:29 am

Good catch. Thank you. I checked the development project and "Enable Operational Repository logging" was checked. I just unchecked it.

In production, this was disabled and there has not been any issue.

While further space issues could be avoided in Dev, is there any tables in XMETA_DATA that I can clean up directly via SQL without causing any issue to the repositoy access?.

Thank you all for the great suggestions given. Appreciate it.

chulett · Post by **chulett** » Thu Jun 19, 2014 9:40 am

Short answer? No.