Hi Karen, I was going through your mail below & found one thing which is in my favor :) "It mention as you scheduled a script to run mysqlcheck and email the result." My interest here is how the mail in spectrum has been scheduled to send that output file as attachment. I have been running one script in spectrum which creates a tracert file whenever there is a down alarm and stores in a directory. I want to attach the file with the original email alarm send to the network administrators.
Appreciation in advance. Thanks, Prashant Karen Kedda wrote: > > I agree with Bill (as always). The optimize.pl and maintenance.pl > scripts will help you keep your DDM database healthy. I use the > $SPECROOT/SG-Support/CsScript/post_olb_script to backup our DDM > database, run optimize.pl, run maintenance.pl, and backup the DDM > database again. It's a little overkill, but it's safe! > > To check for data corruption in the DDM database, you can also run > mysqlcheck. I have scheduled a script to run mysqlcheck and email the > results (see below). I also run mysqlcheck on the SRM reporting > database regularly (it takes a while if you have a large events > table). You can also run mysqlcheck from the command line: > > $ cd $SPECROOT/mysql/bin > $./mysqlcheck -uroot -proot ddmdb > or > $./mysqlcheck --auto-repair -uroot -proot ddmdb > > -------------------------------------------------------------------------------------------------------------- > 20100118_2100 starting mysqlcheck > > ddmdb.attribute OK > ddmdb.db_descriptor OK > ddmdb.event OK > ddmdb.landscape OK > ddmdb.model OK > ddmdb.model_attribute OK > ddmdb.model_name_extension OK > ddmdb.model_type OK > ddmdb.oid_suffix OK > ddmdb.statistic OK > ddmdb.statistic_string OK > ddmdb.statistic_ul64 OK > ddmdb.user_def OK > > 20100118_2104 mysqlcheck complete > > > > > Karen Kedda > Enterprise Monitoring Solutions > Berkley Technology Services LLC > 405 Silverside Rd., Suite 205 > Wilmington, DE 19809 > 302.746.2113 > [email protected] > > > From: "Barnes, William" <[email protected]> > To: "spectrum" <[email protected]> > Cc: "Merih Gulseven (Garanti Teknoloji)" <[email protected]>, > "Baris Dokgoz (Garanti Teknoloji)" <[email protected]> > Date: 01/20/2010 04:03 PM > Subject: Re: [spectrum] Ddm_load -i takes very long time > > > ------------------------------------------------------------------------ > > > > My guess is that you are running into data corruption. We have that > issue frequently on the Archive Manager’s event tables. Usually when > we have problems with connections to ArchMgr, all we have to do is to > go to the ${SPECROOT}/SS/DDM/scripts directory and run the optimize.pl > script. It will take a long time to run, but after it fixes the event > table corruption, the ArchMgr is much happier. > > Our plans are to start scheduling the optimize.pl and the > maintenance.pl scripts to run weekly through cron. We are hoping that > will help keep things cleaner. > > Bill Barnes > Sr Engineer > Comcast > > ------------------------------------------------------------------------ > *From: *"Cihan Subasi (Garanti Teknoloji)" <[email protected]_>* > Reply-To: *"Cihan Subasi (Garanti Teknoloji)" <[email protected]_>* > Date: *Fri, 15 Jan 2010 11:03:46 +0200* > To: *spectrum <[email protected]_>* > Cc: *"Merih Gulseven (Garanti Teknoloji)" <[email protected]_>, > "Baris Dokgoz (Garanti Teknoloji)" <[email protected]_>* > Subject: *[spectrum] Ddm_load -i takes very long time > > Hi, > > We have an issue for a long time with initializing the DDM. Every > 40-45 days the servers starts saying that it is loosing connection to > ArchiveManager and when we see that we save and load the ddm. We are > on 8.1 version and ddm_load -i takes almost forewer and many attempts > to be successfull at the end. I have other servers and ddm_load -i > takes few minutes maybe not, but on my main locat,ons server > initialization takes hours...How can we imporve the initialization > what what should do for to improve DDM and SS performance (best > practice)? > > Thank you for your supports and helps, > > This message and attachments are confidential and intended solely for > the individual(s) stated in this > message. If you received this message although you are not the > addressee, you are responsible to keep the > message confidential. The sender has no responsibility for the > accuracy or correctness of the > information in the message and its attachments. Our company shall have > no liability for any changes > or late receiving, loss of integrity and confidentiality, viruses and > any damages caused in > anyway to your computer system. > Bu mesaj ve ekleri, mesajda gonderildigi belirtilen kisi/kisilere > ozeldir ve gizlidir. Bu mesajin muhatabi > olmamaniza ragmen tarafiniza ulasmis olmasi halinde mesaj iceriginin > gizliligi ve bu gizlilik yukumlulugune > uyulmasi zorunlulugu tarafiniz icin de soz konusudur. Mesaj ve > eklerinde yer alan bilgilerin dogrulugu ve > guncelligi konusunda gonderenin ya da sirketimizin herhangi bir > sorumlulugu bulunmamaktadir. Sirketimiz > mesajin ve bilgilerinin size degisiklige ugrayarak veya gec > ulasmasindan, butunlugunun ve gizliliginin > korunamamasindan, virus icermesinden ve bilgisayar sisteminize > verebilecegi herhangi bir zarardan > sorumlu tutulamaz. > > * --To unsubscribe from spectrum, send email to > [email protected]_with the body: unsubscribe spectrum > [email protected]_ > > * --To unsubscribe from spectrum, send email to [email protected]_ > <mailto:[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] > <mailto:[email protected]> with the body: unsubscribe spectrum > [email protected] > -- Warm Regards, Prashant Thakur Managed Services HCL Infinet Ltd. E-4,5,6, Noida 201301, U.P. (India) Tel: +91-120-2520977/ Extn. (3943) Mob: +91-9958450102 Email:[email protected] www.hcl.in (" The email is subject to Disclaimer as per http://www.hclinfosystems.in/email-disclaimer.htm ") --- To unsubscribe from spectrum, send email to [email protected] with the body: unsubscribe spectrum [email protected]
