Troubleshooting
Problem
Space occupied by the CMDATA table in the content store database is constantly growing.
Resolving The Problem
The following query could provide information about what takes most of the space in this table:
Oracle:
select data.CMID, o.classid, LENGTH(data.DATAPROP), po.CMID, po.classid, ppo.CMID, ppo.classid
from CMDATA data, CMOBJECTS o, CMOBJECTS po, CMOBJNAMES pn, CMOBJECTS ppo, CMOBJNAMES ppn
where data.CMID = o.cmid and data.DATAPROP is not NULL and
po.CMID=o.PCMID and po.CMID=pn.CMID and pn.ISDEFAULT=1 and
ppo.CMID=po.PCMID and ppo.CMID=ppn.CMID and ppn.ISDEFAULT=1
SQL SERVER:
Change LENGTH(data.DATAPROP) with datalength(data.DATAPROP)
Values in the CLASSID column of the result could be decoded using result of the following SQL:
select * from CMCLASSES
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"ARM Category":[{"code":"a8m50000000Cl3zAAC","label":"Administration"}],"ARM Case Number":"TS014188340","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]
Was this topic helpful?
Document Information
Modified date:
11 December 2023
UID
ibm17095025