Micky I think Karen Kedda gave a great answer to your question but just a thought if you get really stuck ...
In your email you say "The only thing the Report Manager admin guide said was to use the RpmgrInitializeLandscape CLI command (page 62 of the guide), which I guess will work, just not sure if that's what I should be doing. And without a support contract to fall back on..." As a last resort this maybe a possibility as it then possible to pull the events from your DDM in the initialised database. If you are running the DDM at default settings this would populate SRM with 45 days of data. This may be acceptable but depends how far back your customer wants to report. Regards Stephen. From: Mickey Alderson [mailto:[email protected]] Sent: 07 July 2011 16:59 To: Stephen Warne Subject: Re: [spectrum] report manager - mysql Trust me, I wasn't trying to cast any aspersions on your comments, although sometimes my words don't actually match up with the tone I'm trying to convey. I actually agree with you completely, it annoys me when I see those types of questions come up. Just wanted to apologize if my question made me sound like "that guy". The only "answer" I've gotten so far is to suppress whatever device(s) is/are causing the DDM to grow that large, which isn't really an answer. There's just got to be a way to not only deprecate older archive files, as well as shrink/purge files in the DDM. The only thing the Report Manager admin guide said was to use the RpmgrInitializeLandscape CLI command (page 62 of the guide), which I guess will work, just not sure if that's what I should be doing. And without a support contract to fall back on... Thanks for any help you may be able to provide, and my apologies for giving the wrong impression in my original e-mail. -Mickey On Thu, Jul 7, 2011 at 10:14 AM, Stephen Warne <[email protected]<mailto:[email protected]>> wrote: Wow Mickey now you've made me feel REALLY bad. If my earlier comment made you think that there was any way in which your post could fall into the category I was eluding to I must apologise. IMHO your situation and question are exactly the sort of reasons we need to help each other as a community. I am up to my neck in stuff today but I will keep an eye out and if you haven't received an answer by tomorrow afternoon I'll dig a bit. I have a vague recollection that's possible to jettison the archived records but I can't swear to it. Regards Stephen. From: Mickey Alderson [mailto:[email protected]<mailto:[email protected]>] Sent: 07 July 2011 15:19 To: spectrum Subject: [spectrum] report manager - mysql Disclaimer: My apologies in advance if this is an easy issue that I should know... Disclaimer 2: We are currently working without a maintenance agreement due to some financial difficulties that our customer is having, although we hope that will change fairly soon... Spectrum environment: Win2k3, version 9.1.1.7.13 I'm running into an issue where I have over 100Gb of data in the SPECROOT\mysql folder, 64.4Gb of which is in the SPECROOT\mysql\data\archive folder. I ran the db_optimize and db_maintenance scripts last night, which got 5Gb of HD space back, but I need to try to do something with the archive folder, and possibly the file sizes of some of the files in the SPECROOT\mysql\data\reporting folder (for example, the event.MYD file is currently just under 25Gb by itself.) Reading the Report Manager manual didn't exactly help point me in the right direction as to what I need to do, so I'm appealing to the list here for assistance. -- Mickey Alderson Sr. Network Engineer ACS, A Xerox Company mobile. 901.833.4908<tel:901.833.4908> email. [email protected]<mailto:[email protected]> * --To unsubscribe from spectrum, send email to [email protected]<mailto:[email protected]> with the body: unsubscribe spectrum [email protected]<mailto:[email protected]> --- To unsubscribe from spectrum, send email to [email protected] with the body: unsubscribe spectrum [email protected]
