Cognos Analytics

Cognos Analytics

Connect, learn, and share with thousands of IBM Cognos Analytics users! 

 View Only

  • 1.  Cognos Content Removal Job

    Posted Tue December 09, 2025 09:26 AM

    Hello All 

    I ran the Cognos content removal job for anything greater than 6 months for saved output. The UI showed it removed it whole lot of entries and I myself deleted some saved output which was way too old (in GBs at least 25-30 GB)

    DBAs ran the Reorg scripts on the database after that, based on this document from IBM and it saved in just MB Reclaiming Content Store database storage space after Content Archival and Removal maintenance. 

    Am I missing anything? The CM tools show less space than what is in the database.

    Thanks 

    Vineet Joshi



    ------------------------------
    Vineet Joshi
    ------------------------------


  • 2.  RE: Cognos Content Removal Job

    Posted Wed December 10, 2025 09:48 AM

    MetaManager

    Vineet - 

    It could be because CM tools read the content tree, not the raw storage footprint.
    The CM metrics don't reflect storage-level fragmentation or large-object behavior in the database.

    OR

    ...and I am not 100% sure but does this process orphan some Cognos reference-only entries.  That could be the case because metadata might not be removed by the standard cleanup job.

    Using MetaManager could help clean up and clear up any questions with deeper visibility and more aggressive cleanup.  

    Happy to walk through typical cleanup checks if you want to validate whether anything was missed.



    ------------------------------
    Daryl Baker
    Director of Software Solutions
    BSP Software - Micro Strategies Inc.
    IL
    ------------------------------

    Original Message


  • 3.  RE: Cognos Content Removal Job

    Posted Thu December 11, 2025 08:24 AM

    Is your backend database MS SQL? The Shrink DB (or similar commands) in MS SQL (and probably all databases) is to remove unused/free space. But many times, in ms sql, i have run a shrink and the unused space is not removed. There are commands that your DBA can run to see the total amount of space, the used space, the unused space, etc. And regardless, I would not expect the database space usage count to match the application space usage count. How different are they?



    ------------------------------
    brenda grossnickle
    BI Programmer Analyst
    FIS
    ------------------------------

    Original Message


  • 4.  RE: Cognos Content Removal Job

    Posted 28 days ago

    Thanks for sharing, Vineet! It sounds like you covered the main steps with the content removal job and reorg scripts. As Daryl and Brenda mentioned, the discrepancy between CM tools and actual DB space is normal due to fragmentation, metadata references, and how CM reports usage. Using MetaManager or DB-specific commands to check used vs. free space can help validate the cleanup.



    ------------------------------
    Global LLC
    ------------------------------

    Original Message


Related Content