DX Infrastructure Manager

Expand all | Collapse all

CA NSM 3.1 Database Maintenance

Jump to Best Answer
  • 1.  CA NSM 3.1 Database Maintenance

    Posted 12-31-2018 07:06 AM

    We have an old NSM setup for legacy kit. The mdb and mdb.log files keep growing and filling the disk. What can we do to maintain the mdb and the log?



  • 2.  Re: CA NSM 3.1 Database Maintenance

    Posted 12-31-2018 07:18 AM

    Hi,

     

    Try deleting the unused objects (if there are any) in MDB and see if it works?



  • 3.  Re: CA NSM 3.1 Database Maintenance

    Posted 12-31-2018 07:21 AM

    How would I do that?



  • 4.  Re: CA NSM 3.1 Database Maintenance

    Posted 12-31-2018 09:09 AM

    Logging into 2d map (if available)?



  • 5.  Re: CA NSM 3.1 Database Maintenance

    Posted 01-02-2019 04:50 AM

    There isn't much in the 2dmap, and what is there, is all set to unmanaged. 

     

    This NSM server is mainly used for servicedesk integration and runs the CA Alert Manegement System (AMS). It may be this that's filling the DB.



  • 6.  Re: CA NSM 3.1 Database Maintenance

    Posted 12-31-2018 11:16 AM

    It sounds like your data_engine is failing in the maitenance processes.

    this is usually due to indexes being too fragmented.

     

    What is your back end SQL server type and version?

    What is your data_engine version?

     

    This will help us determine what is the next couse of action.

    You can check out these KB articles.. They have been relevent for this type of issue for a long time.

    Verifying that data_engine is deleting old raw and - CA Knowledge 

    Query to See the Most Current QOS in the DataBase - CA Knowledge 

    What does the alarm "You have exceeded your QoS li - CA Knowledge 

    How does data_engine maintenance and retention wor - CA Knowledge 



  • 7.  Re: CA NSM 3.1 Database Maintenance

    Posted 01-02-2019 04:49 AM

    This post is about NSM 3.1, not Nimsoft. So we don't have a data_engine.



  • 8.  Re: CA NSM 3.1 Database Maintenance

    Posted 01-02-2019 10:02 AM

    Very sorry for the confusion!!!



  • 9.  Re: CA NSM 3.1 Database Maintenance

    Posted 01-02-2019 03:37 PM

    In general when the visibility and category selected is CA Unified Infrastructure Management the responses will be from the perspective of UIM. To have people who are part of the NSM category view this select CA NSM.



  • 10.  Re: CA NSM 3.1 Database Maintenance

    Posted 01-04-2019 04:27 AM

    Noted, I thought however, that NSM still fell under the Infrastructure Management product area.



  • 11.  Re: CA NSM 3.1 Database Maintenance
    Best Answer

    Posted 01-04-2019 04:29 AM

    I'm moving this question to the NSM sub-group of UIM.