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] 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]
