DX NetOps

Hi Team

We have problem in spectrum server. Frequently event.ibd is increasing and it will increase the main application folder size. So kindly share the documents about the same file.

We need the following details also

1.What is the use of event.ibd ?

2.Here what is its role ?

3.How can we reduce the file size?

Path is :  /apps/Spectrum/mysql/data/reporting/event.ibd

Helli Usha,

1. Event.ibd is the file where the event data is stored. It acts as a  data source source for reports . It is present in reporting db which is a data source for Cabi to generate the reports.

2. This is an innodb table . Extension: idb. We use innodb engine for reporting database for the latest releases of Spectrum. Ex: 9.3

Earlier we used to use mysql engine that has the extentions .myi and .myd

3. Incase you have more data (events) comming from the devices, this size grows enormously.

Inorder to reduce its size follow these options

   i) In the Oneclick -> Administration -> Reporting -> Preferences

      i) Reduce the retention period of events as per the events flow.  Default is is 30 days. So 30 days event data is stored.

   ii) Incase the retention policy is archive, change this to purge. So that 30 days older data will be deleted.

HTH

Regards

Kalyan

Hi Kalyan

Thanks for your reply.

I have another query, after changing the preference settings. whether  we need to follow any steps . If yes. please provide the steps.

If we changed to 30 days. after, is event.idb file size reduced automatically.

I am waiting for your reply.

Hello Usha,

No need of any post steps after changing. Just save the changes.  Out of the box , events in event table are stored for 30 days and remaining tables for 90 days. Size may or may not reduce because by doing this data older than 30 days will be purged but incase you get more amount of new data we might not see much change in the size of event table.  It all depends on the amount of events you get per second in the Oneclick.

Have a look at the report maanger install guide under Spectrum bookshelf.

Kalyan

The event table retention period is set independently. Data older than the retention period is archived at 12:30 AM daily.

Hi Kaylan, Daren_Chernoff

I have a similar problem and have the following questions:

• Are we supposed to have multiple .ibd files as im seeing mulile. See Scrren shot below. Is this normal?

• Our OneClick Preferences are setup as follows:

Must we change these settings

Regards

David Tsatsi CC: nobulame

Hi David,

In CA Spectrum 10.x and onward we partitioned the event table, one per week.

Please provide a screenshot of Archive Expert (in the OC Administration web page --> Report Manager).

Thanks,

Silvio

Hi Silvio

The Repor Manager is throwing errors when I open it now. I don't know if its because the drive has 0 bytes available.

We are running version 10.2.2.0.71 of Spectrum

Regards

David Tsatsi

Hi David,

The reporting database should have corrupted due of lack of free disk space.

There are two options to resolve the issue:

a) If you have a backup of reporting database, you can increase the disk size and then restore the reporting database.

b) Initialize the reporting database. See the doc below for details:

Best practices to maintain the size of reporting database (SRM -Spectrum Report Manager) 

Thanks,

Silvio

Hi Silvio

Find attached doc with screen shots.

Regards

Usha,

If this answers your question, can you mark this post as answered?

Kalyan

Hi All

Thanks for your reply .Its very useful to us .

Hi Kalyan / All

I agree with your previous solution . but , i am very eager to know the following concern .

I need to   save only alarms not events in the database (report manager DB;   in our environment report manager server is getting increasing every data. ), and

if i need , shall i export the events  from the OC directly?

Its very urgent.Please revert back as soon as possible.

Thanks

You will still actually need to optimize the event table to reclaim disk space.

Having SRM configured to purge data after x number of days is a real good

start but the optimize is needed to actually get disk space back.

For instance you can optimize the reporting database with the following:

cd $SPECROOT/mysql/bin

mysqlcheck -uroot -proot -o reporting

As a rule of thumb you will need (2 * sizeOfLargestFile in the mysql/data/reporting directory) of available disk space

in order for the optimize to be successful.

Another thing you might want to consider investigating is why is the reporting/event table

growing at such a large rate ... Perhaps their is a device generating an excessive number

of events that would need further investigation.  We provide sample mysql quries which

would be helpful for determining this in the Spectrum_Database_Management_ENU.pdf guide.

Daren

Hi guys,

I'd hate to wake the dead, but I've a question regarding reducing the size of this file. In one of my environments the file takes up over 110GB, which is way more space the (2 * sizeOfLargestFile in the mysql/data/reporting directory) rule of thumb. Is there a way to reduce the file size within a short period of time?

Right now Oneclick is configured to store reporting data for no more than a few days, older data is purged.

Thanks!