monitoring dynamic server

《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