Archiving data that you cannot access sounds counter intuitive doesn't it! If you can't access it, why save it?
From the Report Manager Installation and Administration Guide (9.1.3) pp 55 It is critical to understand the difference between the archiving and purging data retention options. Archiving moves the data out of the reporting database into the archiving database. Purging removes the data all together. Ensure that any data you specify to purge will no longer be needed. The data you archive is not available for reports. So if your organization's users are not required to generate historical reports from a period before a particular point in time, you can safely use archiving to remove this data from the reporting database. For example, if you only want to generate reports from the last 90 days, you would specify a 90-day retention period. All data accumulated in the reporting database outside this 90-day window is automatically archived on a daily basis, unless you specified a data retention policy of purge. By archiving or purging older data, you provide more room in the reporting database for current and more recent historical data. This means you can generate reports more quickly and prevent problems that may occur if the report database capacity is reached. It is important to determine how much data you want to save in the SRM database and how much you want to save in the Archive Manager database in Spectrum. We save 30 days of data in Archive Manager and 6 months of data in SRM. By doing so, both of our databases are reasonably sized. If we were to initialize our SRM Database, afterward it would update with the 30 days of data in the Archive Manager and then continue to grow. Be sure you know how much data you have in the Archive Manager ($SPECROOT/SS/DDM/.configrc) if you are considering initializing your SRM DB! Karen Kedda Enterprise Monitoring Solutions Berkley Technology Services LLC 405 Silverside Rd., Suite 205 Wilmington, DE 19809 302.746.2113 [email protected] From: Craig Cook <[email protected]> To: "spectrum" <[email protected]> Date: 07/08/2011 08:53 AM Subject: RE: [spectrum] report manager - mysql > The CA SRM expert reminded me that archived data was essentially unusable, so why keep it. Hmmm… would you mind providing more details on this comment? I recently turned on the archive option, not wanting to destroy data, but reduce the size of our event table (40gigs). Ran a outage report from the start of the year and it seemed to miss some events… i.e. providing inaccurate reporting data. I ran the optimize steps you mentioned and it did reduce the table size. Craig --To unsubscribe from spectrum, send email to [email protected] with the body: unsubscribe spectrum [email protected] ************* CONFIDENTIALITY NOTICE: This e-mail and the transmitted documents contain private, privileged and confidential information belonging to the sender. The information therein is solely for the use of the addressee. If your receipt of this transmission has occurred as the result of an error, please immediately notify us so we can arrange for the return of the documents. In such circumstances, you are advised that you may not disclose, copy, distribute or take any other action in reliance on the information transmitted. --- To unsubscribe from spectrum, send email to [email protected] with the body: unsubscribe spectrum [email protected]
