欢迎来到天天文库
浏览记录
ID:39765570
大小:129.31 KB
页数:28页
时间:2019-07-11
《monitoring dynamic server 》由会员上传分享,免费在线阅读,更多相关内容在学术论文-天天文库。
1、Module5MonitoringDynamicServerMonitoringDynamicServer11-20035-1©2001,2003InternationalBusinessMachinesCorporationObjectivesAttheendofthismodule,youwillbeableto:®Describetheuseofthesystemmonitoringinterface(SMI)®ConnecttothesysmasterdatabaseandrunsimpleSQLqueries®Useonstattomonitorinforma
2、tionaboutthedatabaseserver®Useonchecktogatherinformationaboutspaceusageandthestatusofindexesandtblspaces®UseISAtomonitorserveractivity5-25-2MonitoringDynamicServerMonitoringUtilitiesThereareseveralwaysyoucanmonitoraserver:®Systemmonitoringinterface(SMI)®onstat®oncheck®ISA5-3DynamicServer
3、providesseveralwaysforyoutomonitoryourdatabaseserver.Theseinterfacesandutilitiesarecoveredinthefollowingpages.MonitoringDynamicServer5-3SystemMonitoringInterfaceTheSystemMonitoringInterface(SMI)isaread-onlyaccessmethodtoadministrativeinformationrelatedtoaDynamicServersystemthat:®Provides
4、SQLaccesstosharedmemorystructuresSharedMemory®ProvidesprofileinformationforspecificusersessionssysmasterDatabase®AllowsaDynamicServeradministratortoeasilyautomatethesystemmonitoringprocess®NOTE:SMIisnotautility!5-4TheSMIprovidesyouwithpoint-in-timeinformationaboutthecontentsofthesharedme
5、morydatastructuresusedbyDynamicServer.TheSMIisimplementedasthesysmasterdatabase.OnesysmasterdatabaseiscreatedforeachDynamicServerinstance.Thesysmasterdatabasecontainsitsownsystem-catalogtablesandasetofvirtualtablesthatserveaspointerstoshared-memorydata.TheSMIisusefulbecauseitsimplifiesth
6、etaskofprogrammingmonitoringfunctionsforrepetitiveuse.5-4MonitoringDynamicServerThesysmasterDatabaseSELECT*FROMsysdatabases;DataDictionarySharedforsysmasterMemory¢Thesysmasterdatabaseiscreatedautomaticallythefirsttimeaserverisinitialized.¢Thedatabasecontainsdatadictionaryinformationthatp
7、ointstosharedmemorystructures.5-5ThesysmasterdatabaseholdsthetablesusedbySMItoretrievediagnosticinformation.Thereisonesysmasterdatabasecreatedforeachserverinstance.Thedatabaseiscreatedautomaticallythefirsttimetheserverisinitialized.Ifthesysmasterdatabasecannotbecreated,th
此文档下载收益归作者所有