SQL_MODElockinfo

IBMTivoliCompositeApplicationManagerAgentforMySQLVersion7.
2.
1.
2ReferenceIBM5724-I45NoteBeforeusingthisinformationandtheproductitsupports,readtheinformationin"Notices"onpage81.
Thiseditionappliestoversion7.
2.
1.
2ofIBMTivoliCompositeApplicationManagerAgentforMySQL(productnumber5724-I45)andtoallsubsequentreleasesandmodificationsuntilotherwiseindicatedinneweditions.
CopyrightInternationalBusinessMachinesCorporation2016,2020.
USGovernmentUsersRestrictedRights–Use,duplicationordisclosurerestrictedbyGSAADPScheduleContractwithIBMCorp.
ContentsTables.
vChapter1.
Workspaces.
1Predefinedworkspaces.
1Workspacedescriptions.
2MySQLnavigatoritem.
2Availabilitynavigatoritem.
2Configurationnavigatoritem.
3Databasesnavigatoritem.
3Eventsnavigatoritem.
3InnoDBnavigatoritem.
4Servernavigatoritem.
4Tablesnavigatoritem.
4Chapter2.
Attributes.
5Attributegroupsforthemonitoringagent.
6Attributesineachattributegroup.
8AgentConfigattributegroup.
8ApplicationAvailabilityattributegroup.
9Availabilityattributegroup.
9BufferPoolSizeattributegroup.
12DbCPUattributegroup.
13DbMemoryattributegroup.
13ErrorInfoattributegroup.
14EVENTSattributegroup.
17FILESattributegroup.
20GLOBALSTATUSattributegroup.
20GLOBALVARIABLESattributegroup.
21GlobalStatusInfoattributegroup.
22INNODBLOCKWAITSattributegroup.
22InnodbBufferPoolPagesattributegroup.
23LockInfoattributegroup.
24PARTITIONSattributegroup.
24PerformanceObjectStatusattributegroup.
27PLUGINSattributegroup.
30PROCESSLISTattributegroup.
31RowOperationsattributegroup.
32SCHEMATAattributegroup.
33SESSIONSTATUSattributegroup.
34STATISTICSattributegroup.
35Statusattributegroup.
36TABLESattributegroup.
40TakeActionStatusattributegroup.
42ThreadPoolStatusattributegroup.
44USERPRIVILEGESattributegroup.
46Usersattributegroup.
46Diskcapacityplanningforhistoricaldata.
47Chapter3.
Situations.
49Predefinedsituations.
49iiiSituationdescriptions.
50MySQLnavigatoritem.
51Availabilitynavigatoritem.
51Configurationnavigatoritem.
51Databasesnavigatoritem.
52Eventsnavigatoritem.
52InnoDBnavigatoritem.
52Servernavigatoritem.
52Tablesnavigatoritem.
58Chapter4.
TakeActioncommands.
59PredefinedTakeActioncommands.
59Chapter5.
Policies.
61Predefinedpolicies.
61Chapter6.
Eventmapping.
63AppendixA.
Documentationlibrary.
77Prerequisitedocumentation.
77Relateddocumentation.
77TivoliMonitoringCommunityonServiceManagementConnect.
78Othersourcesofdocumentation.
78Conventionsusedinthedocumentation.
78Notices.
81Trademarks.
82Privacypolicyconsiderations.
83Index.
85ivTables1.
CapacityplanningforhistoricaldataloggedbytheMySQLagent.
48vviChapter1.
WorkspacesAworkspaceistheworkingareaoftheTivoliEnterprisePortalapplicationwindow.
TheNavigatorcontainsalistoftheworkspacesprovidedbytheagent.
AboutworkspacesUsetheNavigatortoselecttheworkspaceyouwanttosee.
Aspartoftheapplicationwindow,thestatusbarshowstheTivoliEnterprisePortalServernameandportnumbertowhichthedisplayedinformationappliesandtheIDofthecurrentuser.
WhenyouselectanitemintheNavigator,adefaultworkspaceisdisplayed.
Whenyouright-clickanavigatoritem,amenuthatincludesaWorkspaceitemisdisplayed.
TheWorkspaceitemcontainsalistofworkspacesforthatnavigatoritem.
Eachworkspacehasatleastoneview.
Someviewshavelinkstootherworkspaces.
YoucanalsousetheWorkspaceGallerytoolasdescribedintheTivoliEnterprisePortalUser'sGuidetoopenworkspaces.
TheworkspacesintheNavigatoraredisplayedinaPhysicalviewthatshowsyourenterpriseasaphysicalmappingoradynamicallypopulatedlogicalviewthatisagent-specific.
YoucanalsocreateaLogicalview.
ThePhysicalviewisthedefaultview.
Thismonitoringagentprovidespredefinedworkspaces.
Youcannotmodifyordeletethepredefinedworkspaces,butyoucancreatenewworkspacesbyeditingthemandsavingthechangeswithadifferentname.
Workspaceviewscanbeanycombinationofquery-basedviews,eventviews,andspecialpurposeviews.
AdditionalinformationaboutworkspacesFormoreinformationaboutcreating,customizing,andworkingwithworkspaces,see"Usingworkspaces"intheTivoliEnterprisePortalUser'sGuide.
Foralistofthepredefinedworkspacesforthismonitoringagentandadescriptionofeachworkspace,seePredefinedworkspacesandtheinformationabouteachindividualworkspace.
Someattributegroupsforthismonitoringagentmightnotberepresentedinthepredefinedworkspacesorviewsforthisagent.
Forafulllistoftheattributegroups,see"Attributegroupsforthemonitoringagent"onpage6.
PredefinedworkspacesTheMySQLagentprovidespredefinedworkspaces,whichareorganizedbynavigatoritem.
MySQLnavigatoritem–MySQLworkspaceAvailabilitynavigatoritem–AgentPerformanceworkspace–Availabilityworkspace–StatisticsworkspaceConfigurationnavigatoritem–AgentConfigurationworkspaceDatabasesnavigatoritem–SchemaworkspaceEventsnavigatoritemCopyrightIBMCorp.
2016,20201–EventsworkspaceInnoDBnavigatoritem–LocksworkspaceServernavigatoritemTablesnavigatoritem–TablesworkspaceWorkspacedescriptionsEachworkspacedescriptionprovidesinformationabouttheworkspacesuchasthepurposeandalistofviewsintheworkspace.
Workspacesarelistedundernavigatoritems.
MySQLnavigatoritemTheworkspacedescriptionsareorganizedbythenavigatoritemtowhichtheworkspacesarerelevant.
MySQLworkspaceThisworkspacecontainsthefollowingview:.
AvailabilitynavigatoritemTheworkspacedescriptionsareorganizedbythenavigatoritemtowhichtheworkspacesarerelevant.
AgentPerformanceworkspaceThisworkspacedisplaysthemonitoringdatathatisrelatedtothestatusandperformanceofeachattributegroupoftheagent.
Thisworkspacecontainsthefollowingviews:CollectionStatusThisviewdisplaysthestatusofdatacollectionfromdifferentattributegroupsoftheagent.
CollectionStatisticsThisviewdisplaysthedatacollectionstatisticsoftheagentattributegroups.
Thestatisticsincludecollectionduration,numberofcollections,cachehitrate,andcachemissrate.
AvailabilityworkspaceTheAvailabilityworkspacedisplaystheoverallhealthoftheapplication.
Thisworkspacecontainsthefollowingviews:AvailabilityDisplaysthestateofeachcomponentintheapplication.
Eachprocessisdisplayedusingadescriptivename,thenameoftherunningprocess,andthestateoftheprocess(UP,DOWN,orPROCESS_DATA_NOT_AVAILABLE).
WhenthestateofthecomponentisDOWN(foraprocess,orservice)itishighlightedwitharedbackground.
ProcessorDisplaystheamountofCPUusedbyeachprocessthatisacomponentoftheapplication.
Thisdisplaysthe2maincomponentsofCPUusage,privilegedtimewhichistimespentinthekernelonbehalfoftheprocessandusermodetime,whichisthetimespentrunningtheprocesscode.
ThreadsDisplaysthenumberofthreadsusedbyeachprocessthatisacomponentoftheapplication.
2IBMTivoliCompositeApplicationManagerAgentforMySQL:MySQLagentReferenceMemoryDisplaystheamountofmemorybeingconsumedbyeachprocessthatisacomponentoftheapplication.
Thistotal(virtual)sizeoftheprocessandthesizeoftheprocessinmemory(workingset)aredisplayed.
StatisticsworkspaceThisworkspacedisplaystheperformancemonitoringdataaboutMySQLprocesses,suchasqueries,cachemisses,serverconnections,andtemporarydata.
Thisworkspacecontainsthefollowingviews:UsageStatisticsDisplaysthepercentageofslowqueries,cachemissrate,fulltablescans,temporarydataonthedisk,andnumberofMySQLserverconnectionsthatareused.
OperationsPerSecondDisplaystherateofoperations,suchasqueriespersecond,keyreadspersecond,temporarydatathatiscreatedpersecond,andreadrequestspersecond.
ConfigurationnavigatoritemTheworkspacedescriptionsareorganizedbythenavigatoritemtowhichtheworkspacesarerelevant.
AgentConfigurationworkspaceThisworkspacedisplaysdetailedinformationabouttheconfigurationparametersoftheMySQLagent.
Thisworkspacecontainsthefollowingviews:PluginsDisplaysthedetailsoftheplugin.
UserPrivilegesDisplaysinformationabouttheglobaluserprivileges.
SessionStatusDisplaysthestatusoftheMySQLserver.
JDBCPortDisplaystheMySQLportthatisconfiguredtoconnecttotheserver.
DatabasesnavigatoritemTheworkspacedescriptionsareorganizedbythenavigatoritemtowhichtheworkspacesarerelevant.
SchemaworkspaceThisworkspacedisplaysinformationaboutthepluginsthatareavailablefortheMySQLserver.
Thisworkspacecontainsthefollowingview:DatabasesDisplaysinformationabouttheMySQLdatabases.
EventsnavigatoritemTheworkspacedescriptionsareorganizedbythenavigatoritemtowhichtheworkspacesarerelevant.
EventsworkspaceThisworkspacedisplaysinformationaboutthetablesintheMySQLdatabase.
Thisworkspacecontainsthefollowingview:EventDetailsDisplaysthedetailsofscheduledevents.
Chapter1.
Workspaces3InnoDBnavigatoritemTheworkspacedescriptionsareorganizedbythenavigatoritemtowhichtheworkspacesarerelevant.
LocksworkspaceThisworkspacedisplaysinformationaboutthetablepartitioning.
Thisworkspacecontainsthefollowingviews:InnoDBLocksDisplaysthedetailsofInnoDBtransactionsthatarecurrentlyblocked.
TableDisplaysthecatalogdetailsforthepartition.
ServernavigatoritemTheworkspacedescriptionsareorganizedbythenavigatoritemtowhichtheworkspacesarerelevant.
TablesnavigatoritemTheworkspacedescriptionsareorganizedbythenavigatoritemtowhichtheworkspacesarerelevant.
TablesworkspaceThisworkspacedisplaysinformationaboutthetableindexes.
Thisworkspacecontainsthefollowingviews:TablesDetailsDisplaysthedetailsofthetablecatalogfortheindex.
PartitionsDisplaysthepartitioningdetailsofthepartitiontable.
StatisticsDisplaysthedetailsoftableindexes.
4IBMTivoliCompositeApplicationManagerAgentforMySQL:MySQLagentReferenceChapter2.
AttributesAttributesaretheapplicationpropertiesthatarebeingmeasuredandreportedbytheIBMTivoliCompositeApplicationManagerAgentforMySQL.
Attributesmakeupthekeyperformanceindicators(KPIs)thatarereportedintheapplicationdashboards,andyoucanusethemtocreateeventingthresholdsforconditionsthatyouwanttomonitor.
AboutattributesAttributesareorganizedintoattributegroups.
Attributesinanattributegrouprelatetoasingleobjectsuchasanapplication,ortoasinglekindofdatasuchasstatusinformation.
Attributesinagroupcanbeusedinqueries,query-basedviews,situations,policyworkflows,takeactiondefinitions,andlaunchapplicationdefinitions.
Chartortableviewsandsituationsaretwoexamplesofhowattributesinagroupcanbeused:ChartortableviewsAttributesaredisplayedinchartandtableviews.
Thechartandtableviewsusequeriestospecifywhichattributevaluestorequestfromamonitoringagent.
YouusethePropertieseditortoapplyfiltersandsetstylestodefinethecontentandappearanceofaviewbasedonanexistingquery.
SituationsYouuseattributestocreatesituationsthatmonitorthestateofyouroperatingsystem,database,orapplication.
Asituationdescribesaconditionyouwanttotest.
Whenyoustartasituation,thevaluesyouassigntothesituationattributesarecomparedwiththevaluescollectedbytheMySQLagentandregistersaneventiftheconditionismet.
YouarealertedtoeventsbyindicatoriconsthataredisplayedintheNavigator.
Attributesareorganizedintoattributegroups,thevaluesofwhichcanbeselectivelydisplayedindashboardsorusedtodefineathreshold.
Afterthedashboardisopened,thethresholdisstarted,orthehistoricaldatacollectionintervalcompletes,datasamplesoftheattributesintheattributegrouparetaken.
DashboardsAttributesaredisplayedinthedashboards.
Thegroupwidgetsusequeriestothedashboarddataprovidertospecifywhichattributevaluestorequestfromamonitoringagent.
YoucanedittheComponentsgroupwidgetsthatdisplayintheApplicationPerformanceDashboardtocontrolthegroupwidgetsthataredisplayed,theirpositioning,andtoadjustthethresholds.
AfterselectinganapplicationtodisplayintheApplicationPerformanceDashboard,selectthegroupnamedComponents,andclickActions>Edittoopentheeditor.
ThresholdsAswellasthethresholdsarereportedinthedashboards,youcanalsodefinethresholdsthatmonitorthestateofyouroperatingsystem,database,orapplicationandopenaneventwhenthethresholdhasbeenexceeded.
Youuseattributestodefinethresholdsthatdescribeaconditionyouwanttotest.
Afterthethresholdisstarted,thevaluesassignedtotheattributesinthethresholddefinitionarecomparedwiththevaluescollectedbytheMySQLagent.
Aftertheconditionismet,aneventisregistered.
YoualertedtoeventsbyindicatoriconsthataredisplayedintheApplicationPerformanceDashboardnavigatorandtheEventstab.
IBMTivoliCompositeApplicationManagerAgentforMySQLprovidespredefineddashboards,thresholds,andhistoricaldatacollectionsthatyoucanbegintouseimmediately.
Whenthesampledvaluesfortheattributesdescribedinathresholdmeetthecondition(suchasattributeAisgreaterthan80%),aneventisopened.
Notethatwhennodatacanbecollectedforaanattributegroup,anemptyresultisreturned(norowsofdata),whenaspecificattributecannotbecollectedthevalue0or""isreturnedunlessotherwisespecifiedinaparticularattribute(forexample"N/A"),andanynumericattributevaluethatisgreaterthanthelargest(positiveornegative)numberthatcanberepresentedbythattypereturnsthecorrespondingmaximumorminimumvalue(forexample,fora32-bitnumber,themaximumvalueis2,147,483,647).
Thesevaluesaredisplayedastextvaluesdefinedbytheattributegroup,suchas"ValueCopyrightIBMCorp.
2016,20205ExceedsMaximum"or"ValueExceedsMinimum".
Formoreinformationaboutusingattributesindashboards,thresholds,andhistoricaldatacollection,seetheApplicationPerformanceDashboardandSmartCloudMonitoring-ApplicationInsightonlinehelp.
Foralistoftheattributegroups,alistoftheattributesineachattributegroup,anddescriptionsoftheattributesforthismonitoringagent,see"Attributegroupsforthemonitoringagent"onpage6and"Attributesineachattributegroup"onpage8.
AdditionalinformationaboutattributesFormoreinformationaboutusingattributesandattributegroups,seetheTivoliEnterprisePortalUser'sGuide.
Foralistoftheattributegroups,alistoftheattributesineachattributegroup,anddescriptionsoftheattributesforthismonitoringagent,see"Attributegroupsforthemonitoringagent"onpage6and"Attributesineachattributegroup"onpage8.
AttributegroupsforthemonitoringagentTheMySQLagentcontainsthefollowingattributegroups.
ForagentsthatuseIBMTivoliMonitoringinfrastructure,attributesareinattributegroups.
Foragentsthatusethelightweightinfrastructure,attributesareindatasets.
Thetablenamedependsonthemaximumtablenamelimitsofthetargetdatabasebeingusedforthehistoricaldatacollection.
Ifthemaximumnameis30characters,anywarehouseorhistoricaltablenamelongerthan30charactersisshortenedto30characters.
Note:AgentsthatusetheTivoliMonitoringinfrastructurerefertothehistoricaltablenameasthewarehousetablename.
Attributegroupname:AgentConfig–Tablename:KSEAGNTCFG–Warehouseorhistoricaltablename:KSE_AGENT_CONFIGorKSEAGNTCFGAttributegroupname:ApplicationAvailability–Tablename:KSEAPPAVL1–Warehouseorhistoricaltablename:KSE_APPLICATION_AVAILABILITYorKSEAPPAVL1Attributegroupname:Availability–Tablename:KSEAVAIL–Warehouseorhistoricaltablename:KSE_AVAILABILITYorKSEAVAILAttributegroupname:BufferPoolSize–Tablename:KSEBUFFERP–Warehouseorhistoricaltablename:KSE_BUFFERPOOLSIZEorKSEBUFFERPAttributegroupname:DbCPU–Tablename:KSEDBCPU–Warehouseorhistoricaltablename:KSE_DB_CPUorKSEDBCPUAttributegroupname:DbMemory–Tablename:KSEDBMEM–Warehouseorhistoricaltablename:KSE_DB_MEMORYorKSEDBMEMAttributegroupname:ErrorInfo–Tablename:KSEERRORIN–Warehouseorhistoricaltablename:KSE_ERRORINFOorKSEERRORIN6IBMTivoliCompositeApplicationManagerAgentforMySQL:MySQLagentReferenceAttributegroupname:EVENTS–Tablename:KSEEVENTS0–Warehouseorhistoricaltablename:KSE_EVENTSorKSEEVENTS0Attributegroupname:FILES–Tablename:KSEFILES0–Warehouseorhistoricaltablename:KSE_FILESorKSEFILES0Attributegroupname:GLOBALSTATUS–Tablename:KSEGLOBAL2–Warehouseorhistoricaltablename:KSE_GLOBAL_STATUSorKSEGLOBAL2Attributegroupname:GLOBALVARIABLES–Tablename:KSEGLOBAL0–Warehouseorhistoricaltablename:KSE_GLOBAL_VARIABLESorKSEGLOBAL0Attributegroupname:GlobalStatusInfo–Tablename:KSEGLOBALS–Warehouseorhistoricaltablename:KSE_GLOBALSTATUSINFOorKSEGLOBALSAttributegroupname:INNODBLOCKWAITS–Tablename:KSEINNODB0–Warehouseorhistoricaltablename:KSE_INNODB_LOCK_WAITSorKSEINNODB0Attributegroupname:InnodbBufferPoolPages–Tablename:KSEINNODBB–Warehouseorhistoricaltablename:KSE_INNODBBUFFERPOOLPAGESorKSEINNODBBAttributegroupname:LockInfo–Tablename:KSELOCKINF–Warehouseorhistoricaltablename:KSE_LOCKINFOorKSELOCKINFAttributegroupname:PARTITIONS–Tablename:KSEPARTIT0–Warehouseorhistoricaltablename:KSE_PARTITIONSorKSEPARTIT0Attributegroupname:PerformanceObjectStatus–Tablename:KSEPOBJST–Warehouseorhistoricaltablename:KSE_PERFORMANCE_OBJECT_STATUSorKSEPOBJSTAttributegroupname:PLUGINS–Tablename:KSEPLUGIN0–Warehouseorhistoricaltablename:KSE_PLUGINSorKSEPLUGIN0Attributegroupname:PROCESSLIST–Tablename:KSEPROCES0–Warehouseorhistoricaltablename:KSE_PROCESSLISTorKSEPROCES0Attributegroupname:RowOperations–Tablename:KSEROWOPER–Warehouseorhistoricaltablename:KSE_ROWOPERATIONSorKSEROWOPERAttributegroupname:SCHEMATA–Tablename:KSESCHEMA0–Warehouseorhistoricaltablename:KSE_SCHEMATAorKSESCHEMA0Chapter2.
Attributes7Attributegroupname:SESSIONSTATUS–Tablename:KSESESSIO0–Warehouseorhistoricaltablename:KSE_SESSION_STATUSorKSESESSIO0Attributegroupname:STATISTICS–Tablename:KSESTATIS0–Warehouseorhistoricaltablename:KSE_STATISTICSorKSESTATIS0Attributegroupname:Status–Tablename:KSESTATUS–Warehouseorhistoricaltablename:KSE_STATUSAttributegroupname:TABLES–Tablename:KSETABLES0–Warehouseorhistoricaltablename:KSE_TABLESorKSETABLES0Attributegroupname:TakeActionStatus–Tablename:KSETACTST–Warehouseorhistoricaltablename:KSE_TAKE_ACTION_STATUSorKSETACTSTAttributegroupname:ThreadPoolStatus–Tablename:KSETHPLST–Warehouseorhistoricaltablename:KSE_THREAD_POOL_STATUSorKSETHPLSTAttributegroupname:USERPRIVILEGES–Tablename:KSEUSERPR0–Warehouseorhistoricaltablename:KSE_USER_PRIVILEGESorKSEUSERPR0Attributegroupname:Users–Tablename:KSEUSERS–Warehouseorhistoricaltablename:KSE_USERSAttributesineachattributegroupAttributesineachMySQLagentattributegroupcollectdatathattheagentusesformonitoring.
Thedescriptionofeachattributegroupcontainsthefollowingdetails:Whethertheattributegroupisahistoricaltypethatyoucanrollofftoadatawarehouse.
Informationsuchaswhethertheattributeisakeyattribute,type,verificationmethod,warehousename(asapplicable),andothernames.
Akeyattributeisanattributethatisusedinwarehouseaggregationtoidentifyrowsofdatathatrepresentthesameobject.
AgentConfigattributegroupContainsinformationontheconfigurationoftheagent.
ThisattributegroupiseligibleforusewithTivoliDataWarehouse.
Thisattributegroupcontainsthefollowingattributes:InstanceNameattributeTheinstancenameoftheagentrepresentingthisMySQL.
Thetypeisstring.
8IBMTivoliCompositeApplicationManagerAgentforMySQL:MySQLagentReferenceThefollowingnamesaredefinedforthisattribute:INSTANCE_NAMEorINST(warehousename),InstanceName(caption),Instance_Name(attributename),andINST(columnname).
IPAddressattributeTheIPaddressoftheMySQLserver.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:IP_ADDRESSorIPADD(warehousename),IPAddress(caption),IP_Address(attributename),andIPADD(columnname).
NodeattributeThemanagedsystemnameoftheagent.
Thisattributeisakeyattribute.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:NODE(warehousename),Node(caption),ORIGINNODE(attributename),andORIGINNODE(columnname).
PortattributeTheconfiguredMySQLport.
Thetypeisinteger(64-bitgauge).
Thefollowingnamesaredefinedforthisattribute:PORT(warehousename),Port(caption),Port(attributename),andPORT(columnname).
TimestampattributeThelocaltimeattheagentwhenthedatawascollected.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:TIMESTAMP(warehousename),Timestamp(caption),Timestamp(attributename),andTIMESTAMP(columnname).
ApplicationAvailabilityattributegroupTheApplicationAvailabilityattributegroupprovidesinformationabouttheavailabilityoftheMySQLservice.
ThisattributegroupiseligibleforusewithTivoliDataWarehouse.
Thisattributegroupcontainsthefollowingattributes:NodeattributeThemanagedsystemnameoftheagent.
Thisattributeisakeyattribute.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:NODE(warehousename),Node(caption),ORIGINNODE(attributename),andORIGINNODE(columnname).
StatusattributeThestatusoftheMySQLservice,suchasupordown.
Thisattributeisakeyattribute.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:STATUSorAPPSTA(warehousename),Status(caption),Status(attributename),andAPPSTA(columnname).
TimestampattributeThelocaltimeattheagentwhenthedatawascollected.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:TIMESTAMP(warehousename),Timestamp(caption),Timestamp(attributename),andTIMESTAMP(columnname).
AvailabilityattributegroupTheAvailabilityattributegroupcontainstheavailabilitydataforallprocessesandservicesthatmakeupthisapplication.
ThisattributegroupiseligibleforusewithTivoliDataWarehouse.
Thisattributegroupcontainsthefollowingattributes:ApplicationComponentattributeThedescriptivenameofapartoftheapplication.
Thisattributeisakeyattribute.
Thetypeisstring.
Chapter2.
Attributes9Thefollowingnamesaredefinedforthisattribute:APPLICATION_COMPONENTorCOMPONENT(warehousename),ApplicationComponent(caption),Application_Component(attributename),andCOMPONENT(columnname).
CommandLineattributeTheprogramnameandanyargumentsspecifiedonthecommandlinewhentheprocesswasstarted.
ForServiceorFunctionalitytest,thisattributehasthevalueN/A.
Thetypeisstringwithenumeratedvalues.
Thefollowingvaluesaredefined:N/A(N/A).
AnyvaluethatdoesnothaveadefinitionhereisdisplayedintheUserInterface.
Thefollowingnamesaredefinedforthisattribute:COMMAND_LINEorCMDLINE(warehousename),CommandLine(caption),Command_Line(attributename),andCMDLINE(columnname).
FullNameattributeThefullnameoftheprocessthatincludesthepath.
Thetypeisstringwithenumeratedvalues.
Thefollowingvaluesaredefined:N/A(N/A).
AnyvaluethatdoesnothaveadefinitionhereisdisplayedintheUserInterface.
Thefollowingnamesaredefinedforthisattribute:FULL_NAMEorFULLNAME(warehousename),FullName(caption),Full_Name(attributename),andFULLNAME(columnname).
FunctionalityTestMessageattributeThetextmessagethatcorrespondstotheFunctionalityTestStatus.
Thisattributeisonlyvalidforfunctionalitytests.
Thetypeisstringwithenumeratedvalues.
Thefollowingvaluesaredefined:N/A(N/A).
AnyvaluethatdoesnothaveadefinitionhereisdisplayedintheUserInterface.
Thefollowingnamesaredefinedforthisattribute:FUNCTIONALITY_TEST_MESSAGEorFUNCMSG(warehousename),FunctionalityTestMessage(caption),Functionality_Test_Message(attributename),andFUNCMSG(columnname).
FunctionalityTestStatusattributeThereturncodeofthefunctionalitytest.
Whenthemonitoredapplicationisrunningcorrectly,'SUCCESS'isdisplayed.
'NOT_RUNNING'isdisplayedwhenitisnotrunningcorrectly.
'N/A'isdisplayedwhentherowdoesnotrepresentafunctionalitytest.
Thetypeisintegerwithenumeratedvalues.
Thefollowingvaluesaredefined:SUCCESS(0),N/A(1),GENERALERROR(2),WARNING(3),NOTRUNNING(4),DEPENDENTNOTRUNNING(5),ALREADYRUNNING(6),PREREQNOTRUNNING(7),TIMEDOUT(8),DOESNTEXIST(9),UNKNOWN(10),DEPENDENTSTILLRUNNING(11),INSUFFICIENTUSERAUTHORITY(12).
AnyvaluethatdoesnothaveadefinitionhereisdisplayedintheUserInterface.
Thefollowingnamesaredefinedforthisattribute:FUNCTIONALITY_TEST_STATUSorFUNCSTATUS(warehousename),FunctionalityTestStatus(caption),Functionality_Test_Status(attributename),andFUNCSTATUS(columnname).
NameattributeThenameoftheprocess,service,orfunctionalitytest.
Thisnamematchestheexecutablenameoftheprocess,theserviceshortnameorthenameoftheprocessusedtotesttheapplication.
Thetypeisstringwithenumeratedvalues.
Thefollowingvaluesaredefined:N/A(N/A).
AnyvaluethatdoesnothaveadefinitionhereisdisplayedintheUserInterface.
Thefollowingnamesaredefinedforthisattribute:NAME(warehousename),Name(caption),Name(attributename),andNAME(columnname).
NodeattributeThemanagedsystemnameoftheagent.
Thisattributeisakeyattribute.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:NODE(warehousename),Node(caption),ORIGINNODE(attributename),andORIGINNODE(columnname).
PageFaultsperSecattributeTherateofpagefaultsfortheprocessmeasuredinfaultspersecond.
Thisattributecontainsonlyvaliddataforprocesses.
Thetypeisinteger(32-bitgauge).
10IBMTivoliCompositeApplicationManagerAgentforMySQL:MySQLagentReferenceThefollowingnamesaredefinedforthisattribute:PAGE_FAULTS_PER_SECorPAGEFAULTS(warehousename),PageFaultsperSec(caption),Page_Faults_per_Sec(attributename),andPAGEFAULTS(columnname).
PercentPrivilegedTimeattributeThepercentageoftheavailableCPUtimebeingusedbythisprocessforprivilegedoperation.
Thetypeisinteger(32-bitgauge).
Thefollowingnamesaredefinedforthisattribute:PERCENT_PRIVILEGED_TIMEorPERCPRIV(warehousename),PercentPrivilegedTime(caption),Percent_Privileged_Time(attributename),andPERCPRIV(columnname).
PercentProcessorTimeattributeThepercentageoftheelapsedtimethatthisprocessusedtheprocessortoexecuteinstructions.
Thetypeisinteger(32-bitgauge).
Thefollowingnamesaredefinedforthisattribute:PERCENT_PROCESSOR_TIMEorPERCPROC(warehousename),PercentProcessorTime(caption),Percent_Processor_Time(attributename),andPERCPROC(columnname).
PercentUserModeTimeattributeThepercentageoftheavailableCPUtimebeingusedbythisprocessforusermodeoperation.
Thetypeisinteger(32-bitgauge).
Thefollowingnamesaredefinedforthisattribute:PERCENT_USER_MODE_TIMEorPERCUSER(warehousename),PercentUserModeTime(caption),Percent_User_Mode_Time(attributename),andPERCUSER(columnname).
PIDattributeTheprocessIDassociatedwiththeprocess.
Thisattributecontainsonlyvaliddataforprocesses.
Thetypeisinteger(32-bitgauge).
Thefollowingnamesaredefinedforthisattribute:PID(warehousename),PID(caption),PID(attributename),andPID(columnname).
StatusattributeThestatusoftheapplicationcomponent.
Forprocesses'UP','DOWN','WARNING',or'PROCESS_DATA_NOT_AVAILABLE':'PROCESS_DATA_NOT_AVAILABLE'isdisplayedforaprocesswhenthematchingprocessisrunningbuttheresourceuseinformationcannotbecollectedforthatprocess.
Forservices'UP','DOWN',or'UNKNOWN':'UNKNOWN'isdisplayedwhentheserviceisnotinstalled.
Forfunctionalitytests:'PASSED'or'FAILED'isdisplayed.
Thetypeisintegerwithenumeratedvalues.
Thefollowingvaluesaredefined:DOWN(0),UP(1),WARNING(2),UNKNOWN(3),PASSED(4),FAILED(5),PROCESSDATANOTAVAILABLE(6).
AnyvaluethatdoesnothaveadefinitionhereisdisplayedintheUserInterface.
Thefollowingnamesaredefinedforthisattribute:STATUS(warehousename),Status(caption),Status(attributename),andSTATUS(columnname).
ThreadCountattributeThenumberofthreadscurrentlyallocatedbythisprocess.
Thisattributecontainsonlyvaliddataforprocesses.
Thetypeisinteger(32-bitgauge).
Thefollowingnamesaredefinedforthisattribute:THREAD_COUNTorTHREADS(warehousename),ThreadCount(caption),Thread_Count(attributename),andTHREADS(columnname).
TimestampattributeThelocaltimeattheagentwhenthedatawascollected.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:TIMESTAMP(warehousename),Timestamp(caption),Timestamp(attributename),andTIMESTAMP(columnname).
Chapter2.
Attributes11TypeattributeThetypeoftheapplicationcomponent.
Componentsareprocesses,services,orfunctionalitytests.
Thetypeisintegerwithenumeratedvalues.
Thefollowingvaluesaredefined:PROCESS(0),SERVICE(1),FUNCTIONALITYTEST(2).
AnyvaluethatdoesnothaveadefinitionhereisdisplayedintheUserInterface.
Thefollowingnamesaredefinedforthisattribute:TYPE(warehousename),Type(caption),Type(attributename),andTYPE(columnname).
VirtualSizeattributeThevirtualsize(inMB)oftheprocess.
Thetypeisinteger(32-bitgauge).
Thefollowingnamesaredefinedforthisattribute:VIRTUAL_SIZEorVIRTSIZE(warehousename),VirtualSize(caption),Virtual_Size(attributename),andVIRTSIZE(columnname).
WorkingSetSizeattributeTheworkingsetsizeoftheprocessinMB.
Thisattributecontainsonlyvaliddataforprocesses.
Thetypeisinteger(32-bitgauge).
Thefollowingnamesaredefinedforthisattribute:WORKING_SET_SIZEorWORKSET(warehousename),WorkingSetSize(caption),Working_Set_Size(attributename),andWORKSET(columnname).
BufferPoolSizeattributegroupTheBufferPoolSizeattributegrouptableprovidesinformationabouttablesindatabases.
ThisattributegroupiseligibleforusewithTivoliDataWarehouse.
Thisattributegroupcontainsthefollowingattributes:dataLengthattributeDATA_LENGTHisthelengthofthedatafile,inMB.
Thetypeisrealnumber(64-bitgauge)withtwodecimalplacesofprecision.
Thefollowingnamesaredefinedforthisattribute:DATALENGTH(warehousename),dataLength(caption),dataLength(attributename),andDATALENGTH(columnname).
indexLengthattributeINDEX_LENGTHisthelengthoftheindexfile,inMB.
Thetypeisrealnumber(64-bitgauge)withtwodecimalplacesofprecision.
Thefollowingnamesaredefinedforthisattribute:INDEXLENGTHorINDEXLENGT(warehousename),indexLength(caption),indexLength(attributename),andINDEXLENGT(columnname).
InstanceNameattributeTheinstancenameoftheagentrepresentingthisMySQL.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:INSTANCE_NAMEorINST(warehousename),InstanceName(caption),Instance_Name(attributename),andINST(columnname).
IPAddressattributeTheIPaddressoftheMySQLserver.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:IP_ADDRESSorIPADD(warehousename),IPAddress(caption),IP_Address(attributename),andIPADD(columnname).
NodeattributeThemanagedsystemnameoftheagent.
Thisattributeisakeyattribute.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:NODE(warehousename),Node(caption),ORIGINNODE(attributename),andORIGINNODE(columnname).
numberOfTablesattributeShowstotalnumberoftables.
Thetypeisinteger(64-bitgauge).
12IBMTivoliCompositeApplicationManagerAgentforMySQL:MySQLagentReferenceThefollowingnamesaredefinedforthisattribute:NUMBEROFTABLESorNUMBEROFTA(warehousename),numberOfTables(caption),numberOfTables(attributename),andNUMBEROFTA(columnname).
PortattributeTheconfiguredMySQLport.
Thetypeisinteger(64-bitgauge).
Thefollowingnamesaredefinedforthisattribute:PORT(warehousename),Port(caption),Port(attributename),andPORT(columnname).
tableSchemaattributeShowstableSchemaNameThisattributeisakeyattribute.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:TABLESCHEMAorTABLESCHEM(warehousename),tableSchema(caption),tableSchema(attributename),andTABLESCHEM(columnname).
TimestampattributeThelocaltimeattheagentwhenthedatawascollected.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:TIMESTAMP(warehousename),Timestamp(caption),Timestamp(attributename),andTIMESTAMP(columnname).
totalLengthattributeShowstotallength(indexlength+datalength)Thetypeisrealnumber(64-bitgauge)withtwodecimalplacesofprecision.
Thefollowingnamesaredefinedforthisattribute:TOTALLENGTHorTOTALLENGT(warehousename),totalLength(caption),totalLength(attributename),andTOTALLENGT(columnname).
DbCPUattributegroupThepercentageoftotalCPUusageofmysqldprocess.
ThisattributegroupiseligibleforusewithTivoliDataWarehouse.
Thisattributegroupcontainsthefollowingattributes:CPUValueattributeThetotalCPUusagepercentageofmysqldprocess.
Thetypeisrealnumber(32-bitgauge)withonedecimalplacesofprecisionwithenumeratedvalues.
Thefollowingvaluesaredefined:N/A(-1).
AnyvaluethatdoesnothaveadefinitionhereisdisplayedintheUserInterface.
Thefollowingnamesaredefinedforthisattribute:CPU_VALUEorCPUVALUE(warehousename),CPUValue(caption),CPU_Value(attributename),andCPUVALUE(columnname).
NodeattributeThemanagedsystemnameoftheagent.
Thisattributeisakeyattribute.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:NODE(warehousename),Node(caption),ORIGINNODE(attributename),andORIGINNODE(columnname).
TimestampattributeThelocaltimeattheagentwhenthedatawascollected.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:TIMESTAMP(warehousename),Timestamp(caption),Timestamp(attributename),andTIMESTAMP(columnname).
DbMemoryattributegroupThememoryusageofmysqldprocessinMB.
ThisattributegroupiseligibleforusewithTivoliDataWarehouse.
Thisattributegroupcontainsthefollowingattributes:Chapter2.
Attributes13MemoryattributeThememoryusageofmysqldprocessinMB.
Thetypeisrealnumber(32-bitgauge)withonedecimalplacesofprecisionwithenumeratedvalues.
Thefollowingvaluesaredefined:N/A(-1).
AnyvaluethatdoesnothaveadefinitionhereisdisplayedintheUserInterface.
Thefollowingnamesaredefinedforthisattribute:MEMORY(warehousename),Memory(caption),Memory(attributename),andMEMORY(columnname).
NodeattributeThemanagedsystemnameoftheagent.
Thisattributeisakeyattribute.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:NODE(warehousename),Node(caption),ORIGINNODE(attributename),andORIGINNODE(columnname).
TimestampattributeThelocaltimeattheagentwhenthedatawascollected.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:TIMESTAMP(warehousename),Timestamp(caption),Timestamp(attributename),andTIMESTAMP(columnname).
ErrorInfoattributegroupTheErrorInfoattributegroupshowsinformationregardingMySQLerrors.
ThisattributegroupiseligibleforusewithTivoliDataWarehouse.
Thisattributegroupcontainsthefollowingattributes:countAddrInfoPermanentErrorsattributeThenumberofpermanenterrorsduringhostname-to-IPreverseDNSresolution.
Thetypeisinteger(32-bitgauge).
Thefollowingnamesaredefinedforthisattribute:COUNTADDRINFOPERMANENTERRORSorCOUNTADDR0(warehousename),countAddrInfoPermanentErrors(caption),countAddrInfoPermanentErrors(attributename),andCOUNTADDR0(columnname).
countAddrInfoTransientErrorsattributeThenumberoftransienterrorsduringhostname-to-IPreverseDNSresolution.
Thetypeisinteger(32-bitgauge).
Thefollowingnamesaredefinedforthisattribute:COUNTADDRINFOTRANSIENTERRORSorCOUNTADDRI(warehousename),countAddrInfoTransientErrors(caption),countAddrInfoTransientErrors(attributename),andCOUNTADDRI(columnname).
countAuthenticationErrorsattributeThenumberoferrorscausedbyfailedauthentication.
Thetypeisinteger(32-bitgauge).
Thefollowingnamesaredefinedforthisattribute:COUNTAUTHENTICATIONERRORSorCOUNTAUTHE(warehousename),countAuthenticationErrors(caption),countAuthenticationErrors(attributename),andCOUNTAUTHE(columnname).
countAuthPluginErrorsattributeThenumberoferrorsreportedbyauthenticationplugins.
Thetypeisinteger(32-bitgauge).
Thefollowingnamesaredefinedforthisattribute:COUNTAUTHPLUGINERRORSorCOUNTAUTHP(warehousename),countAuthPluginErrors(caption),countAuthPluginErrors(attributename),andCOUNTAUTHP(columnname).
countDefaultDatabaseErrorsattributeThenumberoferrorsrelatedtothedefaultdatabase.
Thetypeisinteger(32-bitgauge).
Thefollowingnamesaredefinedforthisattribute:COUNTDEFAULTDATABASEERRORSorCOUNTDEFAU(warehousename),countDefaultDatabaseErrors(caption),countDefaultDatabaseErrors(attributename),andCOUNTDEFAU(columnname).
14IBMTivoliCompositeApplicationManagerAgentforMySQL:MySQLagentReferencecountFCRDNSErrorsattributeThenumberofforward-confirmedreverseDNSerrors.
Thetypeisinteger(32-bitgauge).
Thefollowingnamesaredefinedforthisattribute:COUNTFCRDNSERRORSorCOUNTFCRDN(warehousename),countFCRDNSErrors(caption),countFCRDNSErrors(attributename),andCOUNTFCRDN(columnname).
countFormatErrorsattributeThenumberofhostnameformaterrors.
Thetypeisinteger(32-bitgauge).
Thefollowingnamesaredefinedforthisattribute:COUNTFORMATERRORSorCOUNTFORMA(warehousename),countFormatErrors(caption),countFormatErrors(attributename),andCOUNTFORMA(columnname).
countHandshakeErrorsattributeThenumberoferrorsdetectedatthewireprotocollevel.
Thetypeisinteger(32-bitgauge).
Thefollowingnamesaredefinedforthisattribute:COUNTHANDSHAKEERRORSorCOUNTHANDS(warehousename),countHandshakeErrors(caption),countHandshakeErrors(attributename),andCOUNTHANDS(columnname).
countHostAclErrorsattributeThenumberoferrorsthatoccurbecausenousersarepermittedtoconnectfromtheclienthost.
Thetypeisinteger(32-bitgauge).
Thefollowingnamesaredefinedforthisattribute:COUNTHOSTACLERRORSorCOUNTHOSTA(warehousename),countHostAclErrors(caption),countHostAclErrors(attributename),andCOUNTHOSTA(columnname).
countHostBlockedErrorsattributeThenumberofconnectionsthatwereblockedbecauseSUM_CONNECT_ERRORSexceededthevalueofthemax_connect_errorssystem.
Thetypeisinteger(32-bitgauge).
Thefollowingnamesaredefinedforthisattribute:COUNTHOSTBLOCKEDERRORSorCOUNTHOSTB(warehousename),countHostBlockedErrors(caption),countHostBlockedErrors(attributename),andCOUNTHOSTB(columnname).
countInitConnectErrorsattributeThenumberoferrorscausedbyexecutionfailuresofstatementsintheinit_connectsystemvariablevalue.
Thetypeisinteger(32-bitgauge).
Thefollowingnamesaredefinedforthisattribute:COUNTINITCONNECTERRORSorCOUNTINITC(warehousename),countInitConnectErrors(caption),countInitConnectErrors(attributename),andCOUNTINITC(columnname).
countLocalErrorsattributeThenumberoferrorslocaltotheserverimplementationandnotrelatedtothenetwork,authentication,orauthorization.
Thetypeisinteger(32-bitgauge).
Thefollowingnamesaredefinedforthisattribute:COUNTLOCALERRORSorCOUNTLOCAL(warehousename),countLocalErrors(caption),countLocalErrors(attributename),andCOUNTLOCAL(columnname).
countMaxUserConnectionsErrorsattributeThenumberoferrorscausedbyexceedingper-userconnectionquotas.
Thetypeisinteger(32-bitgauge).
Thefollowingnamesaredefinedforthisattribute:COUNTMAXUSERCONNECTIONSERRORSorCOUNTMAXUS(warehousename),countMaxUserConnectionsErrors(caption),countMaxUserConnectionsErrors(attributename),andCOUNTMAXUS(columnname).
countMaxUserConnectionsPerHourErrorsattributeThenumberoferrorscausedbyexceedingper-userconnections-per-hourquotas.
Thetypeisinteger(32-bitgauge).
Chapter2.
Attributes15Thefollowingnamesaredefinedforthisattribute:COUNTMAXUSERCONNECTIONSPERHOURERRORSorCOUNTMAXU0(warehousename),countMaxUserConnectionsPerHourErrors(caption),countMaxUserConnectionsPerHourErrors(attributename),andCOUNTMAXU0(columnname).
countNameInfoPermanentErrorsattributeThenumberofpermanenterrorsduringIP-to-hostnameDNSresolution.
Thetypeisinteger(32-bitgauge).
Thefollowingnamesaredefinedforthisattribute:COUNTNAMEINFOPERMANENTERRORSorCOUNTNAME0(warehousename),countNameInfoPermanentErrors(caption),countNameInfoPermanentErrors(attributename),andCOUNTNAME0(columnname).
countNameInfoTransientErrorsattributeThenumberoftransienterrorsduringIP-to-hostnameDNSresolution.
Thetypeisinteger(32-bitgauge).
Thefollowingnamesaredefinedforthisattribute:COUNTNAMEINFOTRANSIENTERRORSorCOUNTNAMEI(warehousename),countNameInfoTransientErrors(caption),countNameInfoTransientErrors(attributename),andCOUNTNAMEI(columnname).
countNoAuthPluginErrorsattributeThenumberoferrorsduetorequestsforanunavailableauthenticationplugin.
Thetypeisinteger(32-bitgauge).
Thefollowingnamesaredefinedforthisattribute:COUNTNOAUTHPLUGINERRORSorCOUNTNOAUT(warehousename),countNoAuthPluginErrors(caption),countNoAuthPluginErrors(attributename),andCOUNTNOAUT(columnname).
countProxyUserAclErrorsattributeThenumberoferrorsdetectedwhenproxyuserAisproxiedtoanotheruserBwhodoesexistbutforwhomAdoesnothavethePROXYprivilege.
Thetypeisinteger(32-bitgauge).
Thefollowingnamesaredefinedforthisattribute:COUNTPROXYUSERACLERRORSorCOUNTPROX0(warehousename),countProxyUserAclErrors(caption),countProxyUserAclErrors(attributename),andCOUNTPROX0(columnname).
countProxyUserErrorsattributeThenumberoferrorsdetectedwhenproxyuserAisproxiedtoanotheruserBwhodoesnotexist.
Thetypeisinteger(32-bitgauge).
Thefollowingnamesaredefinedforthisattribute:COUNTPROXYUSERERRORSorCOUNTPROXY(warehousename),countProxyUserErrors(caption),countProxyUserErrors(attributename),andCOUNTPROXY(columnname).
countSSLErrorsattributeThenumberoferrorsduetoSSLproblems.
Thetypeisinteger(32-bitgauge).
Thefollowingnamesaredefinedforthisattribute:COUNTSSLERRORSorCOUNTSSLER(warehousename),countSSLErrors(caption),countSSLErrors(attributename),andCOUNTSSLER(columnname).
countUnknownErrorsattributeThenumberofother,unknownerrorsnotaccountedforbyothercolumnsinthistable.
Thetypeisinteger(32-bitgauge).
Thefollowingnamesaredefinedforthisattribute:COUNTUNKNOWNERRORSorCOUNTUNKNO(warehousename),countUnknownErrors(caption),countUnknownErrors(attributename),andCOUNTUNKNO(columnname).
firstErrorSeenattributeThetimestampofthefirsterrorseenfromtheclientintheIPcolumn.
Thetypeistimestamp.
Thefollowingnamesaredefinedforthisattribute:FIRSTERRORSEENorFIRSTERROR(warehousename),firstErrorSeen(caption),firstErrorSeen(attributename),andFIRSTERROR(columnname).
16IBMTivoliCompositeApplicationManagerAgentforMySQL:MySQLagentReferencefirstSeenattributeThetimestampofthefirstconnectionattemptseenfromtheclientintheIPcolumn.
Thetypeistimestamp.
Thefollowingnamesaredefinedforthisattribute:FIRSTSEEN(warehousename),firstSeen(caption),firstSeen(attributename),andFIRSTSEEN(columnname).
hostattributeTheresolvedDNShostnameforthatclientIP,orNULLifthenameisunknown.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:HOST(warehousename),host(caption),host(attributename),andHOST(columnname).
hostValidatedattributeWhethertheIP-to-hostname-to-IPDNSresolutionwasperformedsuccessfullyfortheclientIP.
IfHOST_VALIDATEDisYESThetypeisstring.
Thefollowingnamesaredefinedforthisattribute:HOSTVALIDATEDorHOSTVALIDA(warehousename),hostValidated(caption),hostValidated(attributename),andHOSTVALIDA(columnname).
IPattributeTheIPaddressoftheclientthatisconnectedtotheserverThisattributeisakeyattribute.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:IP(warehousename),IP(caption),IP(attributename),andIP(columnname).
lastErrorSeenattributeThetimestampofthemostrecenterrorseenfromtheclientintheIPcolumn.
Thetypeistimestamp.
Thefollowingnamesaredefinedforthisattribute:LASTERRORSEENorLASTERRORS(warehousename),lastErrorSeen(caption),lastErrorSeen(attributename),andLASTERRORS(columnname).
lastSeenattributeThetimestampofthemostrecentconnectionattemptseenfromtheclientintheIPcolumn.
Thetypeistimestamp.
Thefollowingnamesaredefinedforthisattribute:LASTSEEN(warehousename),lastSeen(caption),lastSeen(attributename),andLASTSEEN(columnname).
NodeattributeThemanagedsystemnameoftheagent.
Thisattributeisakeyattribute.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:NODE(warehousename),Node(caption),ORIGINNODE(attributename),andORIGINNODE(columnname).
sumConnectErrorsattributeOnlyprotocolhandshakeerrorsarecounted,andonlyforhoststhatpassedvalidation(HOST_VALIDATED=YES).
.
Thetypeisinteger(32-bitgauge).
Thefollowingnamesaredefinedforthisattribute:SUMCONNECTERRORSorSUMCONNECT(warehousename),sumConnectErrors(caption),sumConnectErrors(attributename),andSUMCONNECT(columnname).
TimestampattributeThelocaltimeattheagentwhenthedatawascollected.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:TIMESTAMP(warehousename),Timestamp(caption),Timestamp(attributename),andTIMESTAMP(columnname).
EVENTSattributegroupTheEventsattributegroupprovidesinformationabouttheeventsthataregeneratedinMySQL.
ThisattributegroupiseligibleforusewithTivoliDataWarehouse.
Thisattributegroupcontainsthefollowingattributes:Chapter2.
Attributes17CharacterSetClientattributeThecharactersetclientsessionthatwasusedwhentheeventwasgenerated.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:CHARACTER_SET_CLIENTorCHARACTER_(warehousename),CharacterSetClient(caption),CHARACTER_SET_CLIENT(attributename),andCHARACTER_(columnname).
CollationConnectionattributeThecollationconnectionclientsessionthatwasusedwhentheeventwasgenerated.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:COLLATION_CONNECTIONorCOLLATION_(warehousename),CollationConnection(caption),COLLATION_CONNECTION(attributename),andCOLLATION_(columnname).
CreatedattributeThetimewhentheeventwascreated.
Thetypeistimestamp.
Thefollowingnamesaredefinedforthisattribute:CREATED(warehousename),Created(caption),CREATED(attributename),andCREATED(columnname).
DatabaseCollationattributeThecollationofthedatabaseforthisevent.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:DATABASE_COLLATIONorDATABASE_C(warehousename),DatabaseCollation(caption),DATABASE_COLLATION(attributename),andDATABASE_C(columnname).
DefinerattributeTheaccountoftheuserwhodefinedthisevent.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:DEFINER(warehousename),Definer(caption),DEFINER(attributename),andDEFINER(columnname).
EndsattributeTheendtimeforarepeatedevent(ifdefined).
Thetypeistimestamp.
Thefollowingnamesaredefinedforthisattribute:ENDS(warehousename),Ends(caption),ENDS(attributename),andENDS(columnname).
EventBodyattributeThelanguageofthe'DO'textfortheevent.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:EVENT_BODY(warehousename),EventBody(caption),EVENT_BODY(attributename),andEVENT_BODY(columnname).
EventCatalogattributeThecatalogforthisevent.
Thisattributeisakeyattribute.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:EVENT_CATALOGorEVENT_CATA(warehousename),EventCatalog(caption),EVENT_CATALOG(attributename),andEVENT_CATA(columnname).
EventCommentattributeTheusercommentfortheevent.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:EVENT_COMMENTorEVENT_COMM(warehousename),EventComment(caption),EVENT_COMMENT(attributename),andEVENT_COMM(columnname).
EventDefinationattributeThestatementthatistriggeredbythisevent.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:EVENT_DEFINITIONorEVENT_DEFI(warehousename),EventDefination(caption),EVENT_DEFINITION(attributename),andEVENT_DEFI(columnname).
EventNameattributeThenameofthisevent.
Thisattributeisakeyattribute.
Thetypeisstring.
18IBMTivoliCompositeApplicationManagerAgentforMySQL:MySQLagentReferenceThefollowingnamesaredefinedforthisattribute:EVENT_NAME(warehousename),EventName(caption),EVENT_NAME(attributename),andEVENT_NAME(columnname).
EventSchemaattributeTheschemaforthisevent.
Thisattributeisakeyattribute.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:EVENT_SCHEMAorEVENT_SCHE(warehousename),EventSchema(caption),EVENT_SCHEMA(attributename),andEVENT_SCHE(columnname).
EventTypeattributeTherepetitiontypeofthisevent.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:EVENT_TYPE(warehousename),EventType(caption),EVENT_TYPE(attributename),andEVENT_TYPE(columnname).
ExecuteAtattributeThetimethatisspecifiedforaonetimeevent.
Thetypeistimestamp.
Thefollowingnamesaredefinedforthisattribute:EXECUTE_AT(warehousename),ExecuteAt(caption),EXECUTE_AT(attributename),andEXECUTE_AT(columnname).
IntervalFieldattributeTheunitsoftheintervalthatarespecifiedforarepeatingevent.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:INTERVAL_FIELDorINTERVAL_F(warehousename),IntervalField(caption),INTERVAL_FIELD(attributename),andINTERVAL_F(columnname).
IntervalValueattributeTheintervalthatisspecifiedforarepeatingevent.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:INTERVAL_VALUEorINTERVAL_V(warehousename),IntervalValue(caption),INTERVAL_VALUE(attributename),andINTERVAL_V(columnname).
LastAlteredattributeThetimewhenthiseventwaslastaltered.
Thetypeistimestamp.
Thefollowingnamesaredefinedforthisattribute:LAST_ALTEREDorLAST_ALTER(warehousename),LastAltered(caption),LAST_ALTERED(attributename),andLAST_ALTER(columnname).
LastExecutedattributeThetimewhenthiseventwaslastprocessed.
Thetypeistimestamp.
Thefollowingnamesaredefinedforthisattribute:LAST_EXECUTEDorLAST_EXECU(warehousename),LastExecuted(caption),LAST_EXECUTED(attributename),andLAST_EXECU(columnname).
NodeattributeThemanagedsystemnameoftheagent.
Thisattributeisakeyattribute.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:NODE(warehousename),Node(caption),ORIGINNODE(attributename),andORIGINNODE(columnname).
OnCompletionattributeAcharactervaluethatindicateswhethertopreservetheeventaftercompletion.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:ON_COMPLETIONorON_COMPLET(warehousename),OnCompletion(caption),ON_COMPLETION(attributename),andON_COMPLET(columnname).
OriginatorattributeTheserverIDoftheoriginatingserverfortheevent.
Thetypeisinteger(64-bitgauge).
Thefollowingnamesaredefinedforthisattribute:ORIGINATOR(warehousename),Originator(caption),ORIGINATOR(attributename),andORIGINATOR(columnname).
SQLModeattributeTheSQLmodeoftheserverwhentheeventwascreated.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:SQL_MODE(warehousename),SQLMode(caption),SQL_MODE(attributename),andSQL_MODE(columnname).
Chapter2.
Attributes19StartsattributeThestarttimeforarepeatedevent.
Thetypeistimestamp.
Thefollowingnamesaredefinedforthisattribute:STARTS(warehousename),Starts(caption),STARTS(attributename),andSTARTS(columnname).
StatusattributeThestatusoftheevent,suchasenabled,disabled,orenabledonaslaveserver.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:STATUS(warehousename),Status(caption),STATUS(attributename),andSTATUS(columnname).
TimeZoneattributeThetimezoneforthisevent.
Thisattributeisakeyattribute.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:TIME_ZONE(warehousename),TimeZone(caption),TIME_ZONE(attributename),andTIME_ZONE(columnname).
TimestampattributeThelocaltimeattheagentwhenthedatawascollected.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:TIMESTAMP(warehousename),Timestamp(caption),Timestamp(attributename),andTIMESTAMP(columnname).
FILESattributegroupTheFilesattributegroupprovidesinformationaboutthefilesthatareassociatedwithMySQLtablespaces.
ThisattributegroupiseligibleforusewithTivoliDataWarehouse.
Thisattributegroupcontainsthefollowingattributes:FILENAMEattributeThenameofthefile.
Thisattributeisakeyattribute.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:FILE_NAME(warehousename),FILENAME(caption),FILE_NAME(attributename),andFILE_NAME(columnname).
NodeattributeThemanagedsystemnameoftheagent.
Thisattributeisakeyattribute.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:NODE(warehousename),Node(caption),ORIGINNODE(attributename),andORIGINNODE(columnname).
TABLESPACENAMEattributeThenameofthetablespacethisfileisassociatedwith.
Thisattributeisakeyattribute.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:TABLESPACE_NAMEorTABLESPACE(warehousename),TABLESPACENAME(caption),TABLESPACE_NAME(attributename),andTABLESPACE(columnname).
TimestampattributeThelocaltimeattheagentwhenthedatawascollected.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:TIMESTAMP(warehousename),Timestamp(caption),Timestamp(attributename),andTIMESTAMP(columnname).
GLOBALSTATUSattributegroupTheGlobalStatusattributegroupprovidesinformationabouttheglobalstatusvariablesandtheirvalues.
ThisattributegroupiseligibleforusewithTivoliDataWarehouse.
Thisattributegroupcontainsthefollowingattributes:20IBMTivoliCompositeApplicationManagerAgentforMySQL:MySQLagentReferenceNodeattributeThemanagedsystemnameoftheagent.
Thisattributeisakeyattribute.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:NODE(warehousename),Node(caption),ORIGINNODE(attributename),andORIGINNODE(columnname).
TimestampattributeThelocaltimeattheagentwhenthedatawascollected.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:TIMESTAMP(warehousename),Timestamp(caption),Timestamp(attributename),andTIMESTAMP(columnname).
VariableNameattributeThenameoftheglobalstatusvariable.
Thisattributeisakeyattribute.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:VARIABLE_NAMEorVARIABLE_N(warehousename),VariableName(caption),VARIABLE_NAME(attributename),andVARIABLE_N(columnname).
VariableValueattributeThevalueoftheglobalstatusvariable.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:VARIABLE_VALUEorVARIABLE_V(warehousename),VariableValue(caption),VARIABLE_VALUE(attributename),andVARIABLE_V(columnname).
VariableValueAsIntegerattributeTheintegervalueoftheglobalstatusvariable.
Thetypeisinteger(64-bitgauge).
Thefollowingnamesaredefinedforthisattribute:VARIABLE_VALUE_AS_INTEGERorVARIABLE_I(warehousename),VariableValueAsInteger(caption),VARIABLE_VALUE_AS_INTEGER(attributename),andVARIABLE_I(columnname).
GLOBALVARIABLESattributegroupAllglobalvariablesandtheirvalues,fromthetableGLOBAL_VARIABLES.
ThisattributegroupiseligibleforusewithTivoliDataWarehouse.
Thisattributegroupcontainsthefollowingattributes:NodeattributeThemanagedsystemnameoftheagent.
Thisattributeisakeyattribute.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:NODE(warehousename),Node(caption),ORIGINNODE(attributename),andORIGINNODE(columnname).
TimestampattributeThelocaltimeattheagentwhenthedatawascollected.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:TIMESTAMP(warehousename),Timestamp(caption),Timestamp(attributename),andTIMESTAMP(columnname).
VariableNameattributeTheglobalvariablename.
Thisattributeisakeyattribute.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:VARIABLE_NAMEorVARIABLE_N(warehousename),VariableName(caption),VARIABLE_NAME(attributename),andVARIABLE_N(columnname).
VariableValueattributeThevalueoftheglobalvariable.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:VARIABLE_VALUEorVARIABLE_V(warehousename),VariableValue(caption),VARIABLE_VALUE(attributename),andVARIABLE_V(columnname).
VariableValueAsIntegerattributeTheintegervalueoftheglobalvariable.
Thetypeisinteger(64-bitgauge).
Chapter2.
Attributes21Thefollowingnamesaredefinedforthisattribute:VARIABLE_VALUE_AS_INTEGERorVARIABLE_I(warehousename),VariableValueAsInteger(caption),VARIABLE_VALUE_AS_INTEGER(attributename),andVARIABLE_I(columnname).
GlobalStatusInfoattributegroupTheGlobalStatusInfoattributegrouppresentsthenumberofbytesreceivedandsent,andthetotaluptimedayssincethelasttimeMySQLserverwasrestarted.
ThisattributegroupiseligibleforusewithTivoliDataWarehouse.
Thisattributegroupcontainsthefollowingattributes:bytesReceivedattributeBytesReceivedThetypeisinteger(64-bitgauge).
Thefollowingnamesaredefinedforthisattribute:BYTESRECEIVEDorBYTESRECEI(warehousename),bytesReceived(caption),bytesReceived(attributename),andBYTESRECEI(columnname).
bytesSentattributeBytesSentThetypeisinteger(64-bitgauge).
Thefollowingnamesaredefinedforthisattribute:BYTESSENT(warehousename),bytesSent(caption),bytesSent(attributename),andBYTESSENT(columnname).
NodeattributeThemanagedsystemnameoftheagent.
Thisattributeisakeyattribute.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:NODE(warehousename),Node(caption),ORIGINNODE(attributename),andORIGINNODE(columnname).
TimestampattributeThelocaltimeattheagentwhenthedatawascollected.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:TIMESTAMP(warehousename),Timestamp(caption),Timestamp(attributename),andTIMESTAMP(columnname).
uptimeDaysattributeUptimeDaysThetypeisinteger(32-bitgauge).
Thefollowingnamesaredefinedforthisattribute:UPTIMEDAYS(warehousename),uptimeDays(caption),uptimeDays(attributename),andUPTIMEDAYS(columnname).
INNODBLOCKWAITSattributegroupTheInnoDBLockWaitsattributegroupprovidesinformationabouttheInnoDBtransactionsthatareblockedandthereasonsforblockingthem.
ThisattributegroupiseligibleforusewithTivoliDataWarehouse.
Thisattributegroupcontainsthefollowingattributes:BlockingLockIdattributeTheIDofalockthattheblockingtransactioncurrentlyholds,whichpreventsanothertransactionfromproceeding.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:BLOCKING_LOCK_IDorBLOCKING_L(warehousename),BlockingLockId(caption),blocking_lock_id(attributename),andBLOCKING_L(columnname).
BlockingTrxIdattributeTheIDoftheblockingtransactionthatcurrentlyholdsthecontestedlock.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:BLOCKING_TRX_IDorBLOCKING_T(warehousename),BlockingTrxId(caption),blocking_trx_id(attributename),andBLOCKING_T(columnname).
22IBMTivoliCompositeApplicationManagerAgentforMySQL:MySQLagentReferenceNodeattributeThemanagedsystemnameoftheagent.
Thisattributeisakeyattribute.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:NODE(warehousename),Node(caption),ORIGINNODE(attributename),andORIGINNODE(columnname).
RequestedLockIdattributeTheIDofthelockthattherequestingtransactioniscurrentlyblocking.
Thisattributeisakeyattribute.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:REQUESTED_LOCK_IDorREQUESTED_(warehousename),RequestedLockId(caption),requested_lock_id(attributename),andREQUESTED_(columnname).
RequestingTrxIdattributeTheIDoftherequestingtransactionthatiscurrentlyblocked.
Thisattributeisakeyattribute.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:REQUESTING_TRX_IDorREQUESTING(warehousename),RequestingTrxId(caption),requesting_trx_id(attributename),andREQUESTING(columnname).
TimestampattributeThelocaltimeattheagentwhenthedatawascollected.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:TIMESTAMP(warehousename),Timestamp(caption),Timestamp(attributename),andTIMESTAMP(columnname).
InnodbBufferPoolPagesattributegroupTheInnodbBufferPoolPagesattributegroupreviewsthepagingKPIsfortheInnoDBstorageenginebufferpool.
ThisattributegroupiseligibleforusewithTivoliDataWarehouse.
Thisattributegroupcontainsthefollowingattributes:innodbBufferPoolPagesDataattributeThenumberofpagescontainingdata(dirtyorclean).
Thetypeisinteger(64-bitgauge).
Thefollowingnamesaredefinedforthisattribute:INNODBBUFFERPOOLPAGESDATAorINNODBBUFF(warehousename),innodbBufferPoolPagesData(caption),innodbBufferPoolPagesData(attributename),andINNODBBUFF(columnname).
innodbBufferPoolPagesFreeattributeThenumberoffreepages.
Thetypeisinteger(64-bitgauge).
Thefollowingnamesaredefinedforthisattribute:INNODBBUFFERPOOLPAGESFREEorINNODBBUF0(warehousename),innodbBufferPoolPagesFree(caption),innodbBufferPoolPagesFree(attributename),andINNODBBUF0(columnname).
innodbBufferPoolPagesMiscattributeThenumberofpagesthatarebusybecausetheyhavebeenallocatedforadministrativeoverheadsuchasrowlocksortheadaptivehashindex.
Thetypeisinteger(64-bitgauge).
Thefollowingnamesaredefinedforthisattribute:INNODBBUFFERPOOLPAGESMISCorINNODBBUF1(warehousename),innodbBufferPoolPagesMisc(caption),innodbBufferPoolPagesMisc(attributename),andINNODBBUF1(columnname).
innodbBufferPoolPagesTotalattributeThetotalsizeofbufferpool,inpages.
Thetypeisinteger(64-bitgauge).
Thefollowingnamesaredefinedforthisattribute:INNODBBUFFERPOOLPAGESTOTALorINNODBBUF2(warehousename),innodbBufferPoolPagesTotal(caption),innodbBufferPoolPagesTotal(attributename),andINNODBBUF2(columnname).
Chapter2.
Attributes23NodeattributeThemanagedsystemnameoftheagent.
Thisattributeisakeyattribute.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:NODE(warehousename),Node(caption),ORIGINNODE(attributename),andORIGINNODE(columnname).
TimestampattributeThelocaltimeattheagentwhenthedatawascollected.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:TIMESTAMP(warehousename),Timestamp(caption),Timestamp(attributename),andTIMESTAMP(columnname).
LockInfoattributegroupTheLockInfoattributegroupshowsinformationregardinglocksonwhichtransactionsarewaiting.
ThisattributegroupiseligibleforusewithTivoliDataWarehouse.
Thisattributegroupcontainsthefollowingattributes:LockWaitCountattributeShowsthenumberofInnoDBtransactionsthatarecurrentlyblocked.
Thetypeisinteger(32-bitgauge).
Thefollowingnamesaredefinedforthisattribute:LOCKWAITCOUNTorLOCKWAITCO(warehousename),LockWaitCount(caption),LockWaitCount(attributename),andLOCKWAITCO(columnname).
NodeattributeThemanagedsystemnameoftheagent.
Thisattributeisakeyattribute.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:NODE(warehousename),Node(caption),ORIGINNODE(attributename),andORIGINNODE(columnname).
TimestampattributeThelocaltimeattheagentwhenthedatawascollected.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:TIMESTAMP(warehousename),Timestamp(caption),Timestamp(attributename),andTIMESTAMP(columnname).
PARTITIONSattributegroupThePartitionsattributegroupprovidesinformationaboutthetablepartitionsinMySQL.
ThisattributegroupiseligibleforusewithTivoliDataWarehouse.
Thisattributegroupcontainsthefollowingattributes:AvgRowLengthattributeTheaveragelength(inbytes)oftherowsthatisstoredinthepartition.
Thetypeisinteger(64-bitgauge).
Thefollowingnamesaredefinedforthisattribute:AVG_ROW_LENGTHorAVG_ROW_LE(warehousename),AvgRowLength(caption),AVG_ROW_LENGTH(attributename),andAVG_ROW_LE(columnname).
CheckTimeattributeThetimewhenthispartitionwasmostrecentlychecked.
Thetypeistimestamp.
Thefollowingnamesaredefinedforthisattribute:CHECK_TIME(warehousename),CheckTime(caption),CHECK_TIME(attributename),andCHECK_TIME(columnname).
ChecksumattributeThechecksumforthepartition.
Thetypeisintegerwithenumeratedvalues.
Thefollowingvaluesaredefined:NoValue(-3).
AnyvaluethatdoesnothaveadefinitionhereisdisplayedintheUserInterface.
24IBMTivoliCompositeApplicationManagerAgentforMySQL:MySQLagentReferenceThefollowingnamesaredefinedforthisattribute:CHECKSUM(warehousename),Checksum(caption),CHECKSUM(attributename),andCHECKSUM(columnname).
CreateTimeattributeThetimewhenthispartitionwascreated.
Thetypeistimestamp.
Thefollowingnamesaredefinedforthisattribute:CREATE_TIMEorCREATE_TIM(warehousename),CreateTime(caption),CREATE_TIME(attributename),andCREATE_TIM(columnname).
DataFreeattributeThesize(inbytes)ofallocatedbutunusedstorageforthepartition.
Thetypeisinteger(64-bitgauge).
Thefollowingnamesaredefinedforthisattribute:DATA_FREE(warehousename),DataFree(caption),DATA_FREE(attributename),andDATA_FREE(columnname).
DataLengthattributeThetotalamountofrowdata(inbytes)thatisstoredinthepartition.
Thetypeisinteger(64-bitgauge).
Thefollowingnamesaredefinedforthisattribute:DATA_LENGTHorDATA_LENGT(warehousename),DataLength(caption),DATA_LENGTH(attributename),andDATA_LENGT(columnname).
IndexLengthattributeThelength(inbytes)oftheindexfileforthepartition.
Thetypeisinteger(64-bitgauge).
Thefollowingnamesaredefinedforthisattribute:INDEX_LENGTHorINDEX_LENG(warehousename),IndexLength(caption),INDEX_LENGTH(attributename),andINDEX_LENG(columnname).
MaxDataLengthattributeThemaximumamountofdata(inbytes)thatcanbestoredinthepartition.
Thetypeisintegerwithenumeratedvalues.
Thefollowingvaluesaredefined:NoValue(-3).
AnyvaluethatdoesnothaveadefinitionhereisdisplayedintheUserInterface.
Thefollowingnamesaredefinedforthisattribute:MAX_DATA_LENGTHorMAX_DATA_L(warehousename),MaxDataLength(caption),MAX_DATA_LENGTH(attributename),andMAX_DATA_L(columnname).
NodeattributeThemanagedsystemnameoftheagent.
Thisattributeisakeyattribute.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:NODE(warehousename),Node(caption),ORIGINNODE(attributename),andORIGINNODE(columnname).
NodegroupattributeThenodegroupforthispartition.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:NODEGROUP(warehousename),Nodegroup(caption),NODEGROUP(attributename),andNODEGROUP(columnname).
PartitionCommentattributeTheusercommentforthepartition.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:PARTITION_COMMENTorPARTITION4(warehousename),PartitionComment(caption),PARTITION_COMMENT(attributename),andPARTITION4(columnname).
PartitionDescriptionattributeThedescriptionofpartitioningforthispartitiontable.
Thisattributeisakeyattribute.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:PARTITION_DESCRIPTIONorPARTITION3(warehousename),PartitionDescription(caption),PARTITION_DESCRIPTION(attributename),andPARTITION3(columnname).
PartitionExpressionattributeTheexpressionthatisusedtopartitionthispartitiontable.
Thisattributeisakeyattribute.
Thetypeisstring.
Chapter2.
Attributes25Thefollowingnamesaredefinedforthisattribute:PARTITION_EXPRESSIONorPARTITION2(warehousename),PartitionExpression(caption),PARTITION_EXPRESSION(attributename),andPARTITION2(columnname).
PartitionMethodattributeThetypeofpartitioningthatisenabledforthepartitiontable.
Thisattributeisakeyattribute.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:PARTITION_METHODorPARTITION1(warehousename),PartitionMethod(caption),PARTITION_METHOD(attributename),andPARTITION1(columnname).
PartitionNameattributeThenameofthepartition.
Thisattributeisakeyattribute.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:PARTITION_NAMEorPARTITION_(warehousename),PartitionName(caption),PARTITION_NAME(attributename),andPARTITION_(columnname).
PartitionOrdinalPositionattributeThecurrentpositionintheorderingofpartitionsforthispartitiontable.
Thisattributeisakeyattribute.
Thetypeisintegerwithenumeratedvalues.
Thefollowingvaluesaredefined:NoValue(-3).
AnyvaluethatdoesnothaveadefinitionhereisdisplayedintheUserInterface.
Thefollowingnamesaredefinedforthisattribute:PARTITION_ORDINAL_POSITIONorPARTITION0(warehousename),PartitionOrdinalPosition(caption),PARTITION_ORDINAL_POSITION(attributename),andPARTITION0(columnname).
SubpartitionExpressionattributeTheexpressionthatisusedtosubpartitionthispartition.
Thisattributeisakeyattribute.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:SUBPARTITION_EXPRESSIONorSUBPARTIT2(warehousename),SubpartitionExpression(caption),SUBPARTITION_EXPRESSION(attributename),andSUBPARTIT2(columnname).
SubpartitionMethodattributeThetypeofsubpartitioningthatisenabledforthepartition.
Thisattributeisakeyattribute.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:SUBPARTITION_METHODorSUBPARTIT1(warehousename),SubpartitionMethod(caption),SUBPARTITION_METHOD(attributename),andSUBPARTIT1(columnname).
SubpartitionNameattributeThesubpartitionnameifthispartitionisasubpartition.
Thisattributeisakeyattribute.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:SUBPARTITION_NAMEorSUBPARTITI(warehousename),SubpartitionName(caption),SUBPARTITION_NAME(attributename),andSUBPARTITI(columnname).
SubpartitionOrdinalPositionattributeThecurrentpositionintheorderingofsubpartitionsforthispartition.
Thisattributeisakeyattribute.
Thetypeisintegerwithenumeratedvalues.
Thefollowingvaluesaredefined:NoValue(-3).
AnyvaluethatdoesnothaveadefinitionhereisdisplayedintheUserInterface.
Thefollowingnamesaredefinedforthisattribute:SUBPARTITION_ORDINAL_POSITIONorSUBPARTIT0(warehousename),SubpartitionOrdinalPosition(caption),SUBPARTITION_ORDINAL_POSITION(attributename),andSUBPARTIT0(columnname).
TableCatalogattributeThecatalogforthispartition.
Thisattributeisakeyattribute.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:TABLE_CATALOGorTABLE_CATA(warehousename),TableCatalog(caption),TABLE_CATALOG(attributename),andTABLE_CATA(columnname).
26IBMTivoliCompositeApplicationManagerAgentforMySQL:MySQLagentReferenceTableNameattributeThetablenameforthispartition.
Thisattributeisakeyattribute.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:TABLE_NAME(warehousename),TableName(caption),TABLE_NAME(attributename),andTABLE_NAME(columnname).
TableRowsattributeThenumberoftablerowsthatarestoredinthepartition.
Thetypeisintegerwithenumeratedvalues.
Thefollowingvaluesaredefined:NoValue(-3).
AnyvaluethatdoesnothaveadefinitionhereisdisplayedintheUserInterface.
Thefollowingnamesaredefinedforthisattribute:TABLE_ROWS(warehousename),TableRows(caption),TABLE_ROWS(attributename),andTABLE_ROWS(columnname).
TableSchemaattributeTheschemaofthetableforthispartition.
Thisattributeisakeyattribute.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:TABLE_SCHEMAorTABLE_SCHE(warehousename),TableSchema(caption),TABLE_SCHEMA(attributename),andTABLE_SCHE(columnname).
TablespaceNameattributeThenameofthetablespaceforthispartition.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:TABLESPACE_NAMEorTABLESPACE(warehousename),TablespaceName(caption),TABLESPACE_NAME(attributename),andTABLESPACE(columnname).
TimestampattributeThelocaltimeattheagentwhenthedatawascollected.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:TIMESTAMP(warehousename),Timestamp(caption),Timestamp(attributename),andTIMESTAMP(columnname).
UpdateTimeattributeThetimewhenthispartitionwaslastupdated.
Thetypeistimestamp.
Thefollowingnamesaredefinedforthisattribute:UPDATE_TIMEorUPDATE_TIM(warehousename),UpdateTime(caption),UPDATE_TIME(attributename),andUPDATE_TIM(columnname).
PerformanceObjectStatusattributegroupThePerformanceObjectStatusattributegroupcontainsinformationthatreflectsthestatusofotherattributegroupssoyoucanseethestatusofallperformanceobjectsthatmakeupthisapplicationallatonce.
Eachoftheseotherperformanceattributegroupsisrepresentedbyarowinthistable(orothertypeofview).
Thestatusforanattributegroupreflectstheresultofthelastattempttocollectdataforthatattributegroup,soyoucanseewhethertheagentiscollectingdatacorrectly.
Unlikeotherattributegroups,thePerformanceObjectStatusattributegroupdoesnotreflectthestateofthemonitoredapplication.
Thisattributegroupismostoftenusedtodeterminewhydataisnotavailableforoneoftheperformanceattributegroups.
ThisattributegroupiseligibleforusewithTivoliDataWarehouse.
Thisattributegroupcontainsthefollowingattributes:AverageCollectionDurationattributeTheaveragedurationofalldatacollectionsofthisgroupinseconds.
Thetypeisrealnumber(32-bitcounter)withtwodecimalplacesofprecisionwithenumeratedvalues.
Thefollowingvaluesaredefined:NODATA(-100).
AnyvaluethatdoesnothaveadefinitionhereisdisplayedintheUserInterface.
Thefollowingnamesaredefinedforthisattribute:AVERAGE_COLLECTION_DURATIONorCOLAVGD(warehousename),AverageCollectionDuration(caption),Average_Collection_Duration(attributename),andCOLAVGD(columnname).
Chapter2.
Attributes27CacheHitPercentattributeThepercentageofexternaldatarequestsforthisgroupthatweresatisfiedfromthecache.
Thetypeisrealnumber(32-bitcounter)withtwodecimalplacesofprecision.
Thefollowingnamesaredefinedforthisattribute:CACHE_HIT_PERCENTorCACHPCT(warehousename),CacheHitPercent(caption),Cache_Hit_Percent(attributename),andCACHPCT(columnname).
CacheHitsattributeThenumberoftimesanexternaldatarequestforthisgroupwassatisfiedfromthecache.
Thetypeisinteger(32-bitcounter).
Thefollowingnamesaredefinedforthisattribute:CACHE_HITSorCACHEHT(warehousename),CacheHits(caption),Cache_Hits(attributename),andCACHEHT(columnname).
CacheMissesattributeThenumberoftimesanexternaldatarequestforthisgroupwasnotavailableinthecache.
Thetypeisinteger(32-bitcounter).
Thefollowingnamesaredefinedforthisattribute:CACHE_MISSESorCACHEMS(warehousename),CacheMisses(caption),Cache_Misses(attributename),andCACHEMS(columnname).
ErrorCodeattributeTheerrorcodeassociatedwiththequery.
Thetypeisintegerwithenumeratedvalues.
Thefollowingvaluesaredefined:NOERROR(0),GENERALERROR(1),OBJECTNOTFOUND(2),COUNTERNOTFOUND(3),NAMESPACEERROR(4),OBJECTCURRENTLYUNAVAILABLE(5),COMLIBRARYINITFAILURE(6),SECURITYINITFAILURE(7),PROXYSECURITYFAILURE(9),NOINSTANCESRETURNED(10),ASSOCIATORQUERYFAILED(11),REFERENCEQUERYFAILED(12),NORESPONSERECEIVED(13),CANNOTFINDJOINEDQUERY(14),CANNOTFINDJOINATTRIBUTEINQUERY1RESULTS(15),CANNOTFINDJOINATTRIBUTEINQUERY2RESULTS(16),QUERY1NOTASINGLETON(17),QUERY2NOTASINGLETON(18),NOINSTANCESRETURNEDINQUERY1(19),NOINSTANCESRETURNEDINQUERY2(20),CANNOTFINDROLLUPQUERY(21),CANNOTFINDROLLUPATTRIBUTE(22),FILEOFFLINE(23),NOHOSTNAME(24),MISSINGLIBRARY(25),ATTRIBUTECOUNTMISMATCH(26),ATTRIBUTENAMEMISMATCH(27),COMMONDATAPROVIDERNOTSTARTED(28),CALLBACKREGISTRATIONERROR(29),MDLLOADERROR(30),AUTHENTICATIONFAILED(31),CANNOTRESOLVEHOSTNAME(32),SUBNODEUNAVAILABLE(33),SUBNODENOTFOUNDINCONFIG(34),ATTRIBUTEERROR(35),CLASSPATHERROR(36),CONNECTIONFAILURE(37),FILTERSYNTAXERROR(38),FILENAMEMISSING(39),SQLQUERYERROR(40),SQLFILTERQUERYERROR(41),SQLDBQUERYERROR(42),SQLDBFILTERQUERYERROR(43),PORTOPENFAILED(44),ACCESSDENIED(45),TIMEOUT(46),NOTIMPLEMENTED(47),REQUESTEDABADVALUE(48),RESPONSETOOBIG(49),GENERALRESPONSEERROR(50),SCRIPTNONZERORETURN(51),SCRIPTNOTFOUND(52),SCRIPTLAUNCHERROR(53),CONFFILEDOESNOTEXIST(54),CONFFILEACCESSDENIED(55),INVALIDCONFFILE(56),EIFINITIALIZATIONFAILED(57),CANNOTOPENFORMATFILE(58),FORMATFILESYNTAXERROR(59),REMOTEHOSTUNAVAILABLE(60),EVENTLOGDOESNOTEXIST(61),PINGFILEDOESNOTEXIST(62),NOPINGDEVICEFILES(63),PINGDEVICELISTFILEMISSING(64),SNMPMISSINGPASSWORD(65),DISABLED(66),URLSFILENOTFOUND(67),XMLPARSEERROR(68),NOTINITIALIZED(69),ICMPSOCKETSFAILED(70),DUPLICATECONFFILE(71),DELETEDCONFIGURATION(72).
AnyvaluethatdoesnothaveadefinitionhereisdisplayedintheUserInterface.
Thefollowingnamesaredefinedforthisattribute:ERROR_CODEorERRCODE(warehousename),ErrorCode(caption),Error_Code(attributename),andERRCODE(columnname).
IntervalsSkippedattributeThenumberoftimesabackgrounddatacollectionforthisgroupwasskippedbecausethepreviouscollectionwasstillrunningwhenthenextonewasduetostart.
Thetypeisinteger(32-bitcounter).
Thefollowingnamesaredefinedforthisattribute:INTERVALS_SKIPPEDorINTSKIP(warehousename),IntervalsSkipped(caption),Intervals_Skipped(attributename),andINTSKIP(columnname).
28IBMTivoliCompositeApplicationManagerAgentforMySQL:MySQLagentReferenceLastCollectionDurationattributeThedurationofthemostrecentlycompleteddatacollectionofthisgroupinseconds.
Thetypeisrealnumber(32-bitcounter)withtwodecimalplacesofprecision.
Thefollowingnamesaredefinedforthisattribute:LAST_COLLECTION_DURATIONorCOLDURA(warehousename),LastCollectionDuration(caption),Last_Collection_Duration(attributename),andCOLDURA(columnname).
LastCollectionFinishedattributeThemostrecenttimeadatacollectionofthisgroupfinished.
Thetypeistimestampwithenumeratedvalues.
Thefollowingvaluesaredefined:NOTCOLLECTED(0691231190000000),NOTCOLLECTED(0000000000000001).
AnyvaluethatdoesnothaveadefinitionhereisdisplayedintheUserInterface.
Thefollowingnamesaredefinedforthisattribute:LAST_COLLECTION_FINISHEDorCOLFINI(warehousename),LastCollectionFinished(caption),Last_Collection_Finished(attributename),andCOLFINI(columnname).
LastCollectionStartattributeThemostrecenttimeadatacollectionofthisgroupstarted.
Thetypeistimestampwithenumeratedvalues.
Thefollowingvaluesaredefined:NOTCOLLECTED(0691231190000000),NOTCOLLECTED(0000000000000001).
AnyvaluethatdoesnothaveadefinitionhereisdisplayedintheUserInterface.
Thefollowingnamesaredefinedforthisattribute:LAST_COLLECTION_STARTorCOLSTRT(warehousename),LastCollectionStart(caption),Last_Collection_Start(attributename),andCOLSTRT(columnname).
NodeattributeThemanagedsystemnameoftheagent.
Thisattributeisakeyattribute.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:NODE(warehousename),Node(caption),ORIGINNODE(attributename),andORIGINNODE(columnname).
NumberofCollectionsattributeThenumberofdatacollectionsforthisgroupsincetheagentstarted.
Thetypeisinteger(32-bitcounter).
Thefollowingnamesaredefinedforthisattribute:NUMBER_OF_COLLECTIONSorNUMCOLL(warehousename),NumberofCollections(caption),Number_of_Collections(attributename),andNUMCOLL(columnname).
ObjectNameattributeThenameoftheperformanceobject.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:OBJECT_NAMEorOBJNAME(warehousename),ObjectName(caption),Object_Name(attributename),andOBJNAME(columnname).
ObjectStatusattributeThestatusoftheperformanceobject.
Thetypeisintegerwithenumeratedvalues.
Thefollowingvaluesaredefined:ACTIVE(0),INACTIVE(1).
AnyvaluethatdoesnothaveadefinitionhereisdisplayedintheUserInterface.
Thefollowingnamesaredefinedforthisattribute:OBJECT_STATUSorOBJSTTS(warehousename),ObjectStatus(caption),Object_Status(attributename),andOBJSTTS(columnname).
ObjectTypeattributeThetypeoftheperformanceobject.
Thetypeisintegerwithenumeratedvalues.
Thefollowingvaluesaredefined:WMI(0),PERFMON(1),WMIASSOCIATIONGROUP(2),JMX(3),SNMP(4),SHELLCOMMAND(5),JOINEDGROUPS(6),CIMOM(7),CUSTOM(8),ROLLUPDATA(9),WMIREMOTEDATA(10),LOGFILE(11),JDBC(12),CONFIGDISCOVERY(13),NTEVENTLOG(14),FILTER(15),SNMPEVENT(16),PING(17),DIRECTORDATA(18),DIRECTOREVENT(19),SSHREMOTESHELLCOMMAND(20).
AnyvaluethatdoesnothaveadefinitionhereisdisplayedintheUserInterface.
Chapter2.
Attributes29Thefollowingnamesaredefinedforthisattribute:OBJECT_TYPEorOBJTYPE(warehousename),ObjectType(caption),Object_Type(attributename),andOBJTYPE(columnname).
QueryNameattributeThenameoftheattributegroup.
Thisattributeisakeyattribute.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:QUERY_NAMEorATTRGRP(warehousename),QueryName(caption),Query_Name(attributename),andATTRGRP(columnname).
RefreshIntervalattributeTheintervalatwhichthisgroupisrefreshedinseconds.
Thetypeisinteger(32-bitcounter).
Thefollowingnamesaredefinedforthisattribute:REFRESH_INTERVALorREFRINT(warehousename),RefreshInterval(caption),Refresh_Interval(attributename),andREFRINT(columnname).
TimestampattributeThelocaltimeattheagentwhenthedatawascollected.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:TIMESTAMP(warehousename),Timestamp(caption),Timestamp(attributename),andTIMESTAMP(columnname).
PLUGINSattributegroupThePluginsattributegroupcontainsinformationaboutthepluginsthattheMySQLserversupports.
ThisattributegroupiseligibleforusewithTivoliDataWarehouse.
Thisattributegroupcontainsthefollowingattributes:LoadOptionattributeTheoptionthatwasusedwhileloadingtheplugin,suchasserverstartuporruntime.
Thisattributeisakeyattribute.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:LOAD_OPTIONorLOAD_OPTIO(warehousename),LoadOption(caption),LOAD_OPTION(attributename),andLOAD_OPTIO(columnname).
NodeattributeThemanagedsystemnameoftheagent.
Thisattributeisakeyattribute.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:NODE(warehousename),Node(caption),ORIGINNODE(attributename),andORIGINNODE(columnname).
PluginAuthorattributeTheauthoroftheplugin.
Thisattributeisakeyattribute.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:PLUGIN_AUTHORorPLUGIN_AUT(warehousename),PluginAuthor(caption),PLUGIN_AUTHOR(attributename),andPLUGIN_AUT(columnname).
PluginDescriptionattributeThedescriptionofthisplugin.
Thisattributeisakeyattribute.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:PLUGIN_DESCRIPTIONorPLUGIN_DES(warehousename),PluginDescription(caption),PLUGIN_DESCRIPTION(attributename),andPLUGIN_DES(columnname).
PluginLibraryattributeThesharedobjectthatsuppliedtheplugin.
Thisattributeisakeyattribute.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:PLUGIN_LIBRARYorPLUGIN_LIB(warehousename),PluginLibrary(caption),PLUGIN_LIBRARY(attributename),andPLUGIN_LIB(columnname).
PluginLibraryVersionattributeTheversionofthesharedobjectthatsuppliedtheplugin.
Thisattributeisakeyattribute.
Thetypeisstring.
30IBMTivoliCompositeApplicationManagerAgentforMySQL:MySQLagentReferenceThefollowingnamesaredefinedforthisattribute:PLUGIN_LIBRARY_VERSIONorPLUGIN_LI0(warehousename),PluginLibraryVersion(caption),PLUGIN_LIBRARY_VERSION(attributename),andPLUGIN_LI0(columnname).
PluginLicenseattributeThelicensefortheplugin.
Thisattributeisakeyattribute.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:PLUGIN_LICENSEorPLUGIN_LIC(warehousename),PluginLicense(caption),PLUGIN_LICENSE(attributename),andPLUGIN_LIC(columnname).
PluginNameattributeThenameoftheplugin.
Thisattributeisakeyattribute.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:PLUGIN_NAMEorPLUGIN_NAM(warehousename),PluginName(caption),PLUGIN_NAME(attributename),andPLUGIN_NAM(columnname).
PluginStatusattributeThestatusofthisplugin.
Thisattributeisakeyattribute.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:PLUGIN_STATUSorPLUGIN_STA(warehousename),PluginStatus(caption),PLUGIN_STATUS(attributename),andPLUGIN_STA(columnname).
PluginTypeattributeThetypeoftheplugin.
Thisattributeisakeyattribute.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:PLUGIN_TYPEorPLUGIN_TYP(warehousename),PluginType(caption),PLUGIN_TYPE(attributename),andPLUGIN_TYP(columnname).
PluginTypeVersionattributeTheversionoftheplugintype.
Thisattributeisakeyattribute.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:PLUGIN_TYPE_VERSIONorPLUGIN_TY0(warehousename),PluginTypeVersion(caption),PLUGIN_TYPE_VERSION(attributename),andPLUGIN_TY0(columnname).
PluginVersionattributeTheversionofthisplugin.
Thisattributeisakeyattribute.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:PLUGIN_VERSIONorPLUGIN_VER(warehousename),PluginVersion(caption),PLUGIN_VERSION(attributename),andPLUGIN_VER(columnname).
TimestampattributeThelocaltimeattheagentwhenthedatawascollected.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:TIMESTAMP(warehousename),Timestamp(caption),Timestamp(attributename),andTIMESTAMP(columnname).
PROCESSLISTattributegroupTheProcessListattributegroupprovidesinformationaboutthethreadsthatarecurrentlyrunningwithintheMySQLserver.
ThisattributegroupiseligibleforusewithTivoliDataWarehouse.
Thisattributegroupcontainsthefollowingattributes:COMMANDattributeThetypeofcommandthatthethreadisexecuting.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:COMMAND(warehousename),COMMAND(caption),COMMAND(attributename),andCOMMAND(columnname).
DBattributeThedatabasethatisusedbythethread.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:DB(warehousename),DB(caption),DB(attributename),andDB(columnname).
Chapter2.
Attributes31HOSTattributeThenameofthehostnamethatspawnedthisthread.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:HOST(warehousename),HOST(caption),HOST(attributename),andHOST(columnname).
IDattributeTheIDofthisthread.
Thisattributeisakeyattribute.
Thetypeisinteger(64-bitgauge).
Thefollowingnamesaredefinedforthisattribute:ID(warehousename),ID(caption),ID(attributename),andID(columnname).
INFOattributeTheadditionalinformationaboutthethread.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:INFO(warehousename),INFO(caption),INFO(attributename),andINFO(columnname).
NodeattributeThemanagedsystemnameoftheagent.
Thisattributeisakeyattribute.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:NODE(warehousename),Node(caption),ORIGINNODE(attributename),andORIGINNODE(columnname).
STATEattributeThestateofthisthread.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:STATE(warehousename),STATE(caption),STATE(attributename),andSTATE(columnname).
TIMEattributeThetimethisthreadhasbeenexecutingthiscommand.
Thetypeisinteger(64-bitgauge).
Thefollowingnamesaredefinedforthisattribute:TIME(warehousename),TIME(caption),TIME(attributename),andTIME(columnname).
TimestampattributeThelocaltimeattheagentwhenthedatawascollected.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:TIMESTAMP(warehousename),Timestamp(caption),Timestamp(attributename),andTIMESTAMP(columnname).
USERattributeTheuserresponsibleforspawningthisthread.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:USER(warehousename),USER(caption),USER(attributename),andUSER(columnname).
RowOperationsattributegroupTheRowoperationsattributegroupshowsinformationoftheoperationsperformedonrows.
ThisattributegroupiseligibleforusewithTivoliDataWarehouse.
Thisattributegroupcontainsthefollowingattributes:NodeattributeThemanagedsystemnameoftheagent.
Thisattributeisakeyattribute.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:NODE(warehousename),Node(caption),ORIGINNODE(attributename),andORIGINNODE(columnname).
rowsDeletedattributeThenumberofrowsdeletedfromInnoDBtables.
Thetypeisinteger(64-bitgauge).
Thefollowingnamesaredefinedforthisattribute:ROWSDELETEDorROWSDELETE(warehousename),rowsDeleted(caption),rowsDeleted(attributename),andROWSDELETE(columnname).
32IBMTivoliCompositeApplicationManagerAgentforMySQL:MySQLagentReferencerowsInsertedattributeThenumberofrowsinsertedintoInnoDBtables.
Thetypeisinteger(64-bitgauge).
Thefollowingnamesaredefinedforthisattribute:ROWSINSERTEDorROWSINSERT(warehousename),rowsInserted(caption),rowsInserted(attributename),andROWSINSERT(columnname).
rowsReadattributeThenumberofrowsreadfromInnoDBtables.
Thetypeisinteger(64-bitgauge).
Thefollowingnamesaredefinedforthisattribute:ROWSREAD(warehousename),rowsRead(caption),rowsRead(attributename),andROWSREAD(columnname).
rowsUpdatedattributeThenumberofrowsupdatedinInnoDBtables.
Thetypeisinteger(64-bitgauge).
Thefollowingnamesaredefinedforthisattribute:ROWSUPDATEDorROWSUPDATE(warehousename),rowsUpdated(caption),rowsUpdated(attributename),andROWSUPDATE(columnname).
systemRowsDeletedattributeThenumberofsystemrowsdeletedfromInnoDBtables.
Thetypeisinteger(64-bitgauge).
Thefollowingnamesaredefinedforthisattribute:SYSTEMROWSDELETEDorSYSTEMROWS(warehousename),systemRowsDeleted(caption),systemRowsDeleted(attributename),andSYSTEMROWS(columnname).
systemRowsInsertedattributeThenumberofsystemrowsinsertedintoInnoDBtables.
Thetypeisinteger(64-bitgauge).
Thefollowingnamesaredefinedforthisattribute:SYSTEMROWSINSERTEDorSYSTEMROW1(warehousename),systemRowsInserted(caption),systemRowsInserted(attributename),andSYSTEMROW1(columnname).
systemRowsReadattributeThenumberofsystemrowsreadfromInnoDBtables.
Thetypeisinteger(64-bitgauge).
Thefollowingnamesaredefinedforthisattribute:SYSTEMROWSREADorSYSTEMROW0(warehousename),systemRowsRead(caption),systemRowsRead(attributename),andSYSTEMROW0(columnname).
systemRowsUpdatedattributeThenumberofsystemrowsupdatedinInnoDBtables.
Thetypeisinteger(64-bitgauge).
Thefollowingnamesaredefinedforthisattribute:SYSTEMROWSUPDATEDorSYSTEMROW2(warehousename),systemRowsUpdated(caption),systemRowsUpdated(attributename),andSYSTEMROW2(columnname).
TimestampattributeThelocaltimeattheagentwhenthedatawascollected.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:TIMESTAMP(warehousename),Timestamp(caption),Timestamp(attributename),andTIMESTAMP(columnname).
SCHEMATAattributegroupTheSchemataattributegroupprovidesinformationabouttheMySQLdatabases.
ThisattributegroupiseligibleforusewithTivoliDataWarehouse.
Thisattributegroupcontainsthefollowingattributes:CatalogNameattributeThecatalognameforthisdatabase.
Thisattributeisakeyattribute.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:CATALOG_NAMEorCATALOG_NA(warehousename),CatalogName(caption),CATALOG_NAME(attributename),andCATALOG_NA(columnname).
Chapter2.
Attributes33DefaultCharacterSetNameattributeThedefaultcharactersetforthisdatabase.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:DEFAULT_CHARACTER_SET_NAMEorDEFAULT_CH(warehousename),DefaultCharacterSetName(caption),DEFAULT_CHARACTER_SET_NAME(attributename),andDEFAULT_CH(columnname).
DefaultCollationNameattributeThedefaultcollationforthisdatabase.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:DEFAULT_COLLATION_NAMEorDEFAULT_CO(warehousename),DefaultCollationName(caption),DEFAULT_COLLATION_NAME(attributename),andDEFAULT_CO(columnname).
NodeattributeThemanagedsystemnameoftheagent.
Thisattributeisakeyattribute.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:NODE(warehousename),Node(caption),ORIGINNODE(attributename),andORIGINNODE(columnname).
SchemaNameattributeThenameofthisdatabase.
Thisattributeisakeyattribute.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:SCHEMA_NAMEorSCHEMA_NAM(warehousename),SchemaName(caption),SCHEMA_NAME(attributename),andSCHEMA_NAM(columnname).
SQLPathattributeTheSQLpathforthisdatabase.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:SQL_PATH(warehousename),SQLPath(caption),SQL_PATH(attributename),andSQL_PATH(columnname).
TimestampattributeThelocaltimeattheagentwhenthedatawascollected.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:TIMESTAMP(warehousename),Timestamp(caption),Timestamp(attributename),andTIMESTAMP(columnname).
SESSIONSTATUSattributegroupTheSessionStatusattributegroupprovidesinformationaboutthestatusofsessionvariablesthattheservermaintains.
ThisattributegroupiseligibleforusewithTivoliDataWarehouse.
Thisattributegroupcontainsthefollowingattributes:NodeattributeThemanagedsystemnameoftheagent.
Thisattributeisakeyattribute.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:NODE(warehousename),Node(caption),ORIGINNODE(attributename),andORIGINNODE(columnname).
TimestampattributeThelocaltimeattheagentwhenthedatawascollected.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:TIMESTAMP(warehousename),Timestamp(caption),Timestamp(attributename),andTIMESTAMP(columnname).
VariableNameattributeThenameofthisvariable.
Thisattributeisakeyattribute.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:VARIABLE_NAMEorVARIABLE_N(warehousename),VariableName(caption),VARIABLE_NAME(attributename),andVARIABLE_N(columnname).
34IBMTivoliCompositeApplicationManagerAgentforMySQL:MySQLagentReferenceVariableValueattributeThevalueofthisvariable.
Thisattributeisakeyattribute.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:VARIABLE_VALUEorVARIABLE_V(warehousename),VariableValue(caption),VARIABLE_VALUE(attributename),andVARIABLE_V(columnname).
STATISTICSattributegroupTheStatisticsattributegroupprovidesinformationabouttheindexesthattheMySQLserverusesforquicklyfindingrowswithspecificcolumnvalues.
ThisattributegroupiseligibleforusewithTivoliDataWarehouse.
Thisattributegroupcontainsthefollowingattributes:CardinalityattributeAnestimateofthenumberofuniquerowsforthisindex.
Thetypeisintegerwithenumeratedvalues.
Thefollowingvaluesaredefined:NoValue(-3).
AnyvaluethatdoesnothaveadefinitionhereisdisplayedintheUserInterface.
Thefollowingnamesaredefinedforthisattribute:CARDINALITYorCARDINALIT(warehousename),Cardinality(caption),CARDINALITY(attributename),andCARDINALIT(columnname).
CollationattributeThecollationtypeforthisindex.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:COLLATION(warehousename),Collation(caption),COLLATION(attributename),andCOLLATION(columnname).
ColumnNameattributeThenameofthecolumnforthisindex.
Thisattributeisakeyattribute.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:COLUMN_NAMEorCOLUMN_NAM(warehousename),ColumnName(caption),COLUMN_NAME(attributename),andCOLUMN_NAM(columnname).
CommentattributeTheusercommentforthisindex.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:COMMENTorCOMMENT0(warehousename),Comment(caption),COMMENT(attributename),andCOMMENT0(columnname).
IndexNameattributeThenameofthisindex.
Thisattributeisakeyattribute.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:INDEX_NAME(warehousename),IndexName(caption),INDEX_NAME(attributename),andINDEX_NAME(columnname).
IndexSchemaattributeTheschemaforthisindex.
Thisattributeisakeyattribute.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:INDEX_SCHEMAorINDEX_SCHE(warehousename),IndexSchema(caption),INDEX_SCHEMA(attributename),andINDEX_SCHE(columnname).
IndexTypeattributeThetypeofstorageforthisindex.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:INDEX_TYPE(warehousename),IndexType(caption),INDEX_TYPE(attributename),andINDEX_TYPE(columnname).
NodeattributeThemanagedsystemnameoftheagent.
Thisattributeisakeyattribute.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:NODE(warehousename),Node(caption),ORIGINNODE(attributename),andORIGINNODE(columnname).
Chapter2.
Attributes35NonUniqueattributeABooleanvaluethatindicateswhethertheindexisnon-unique.
Thetypeisinteger(32-bitgauge)withenumeratedvalues.
Thefollowingvaluesaredefined:False(0),True(1).
AnyvaluethatdoesnothaveadefinitionhereisdisplayedintheUserInterface.
Thefollowingnamesaredefinedforthisattribute:NON_UNIQUE(warehousename),NonUnique(caption),NON_UNIQUE(attributename),andNON_UNIQUE(columnname).
NullableattributeThenullablestateforthisindex.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:NULLABLE(warehousename),Nullable(caption),NULLABLE(attributename),andNULLABLE(columnname).
PackedattributeAcharactervaluethatindicateswhethertheindexispacked.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:PACKED(warehousename),Packed(caption),PACKED(attributename),andPACKED(columnname).
SeqInIndexattributeThenumberoftheindexinthetablesequenceofindices.
Thetypeisinteger(64-bitgauge).
Thefollowingnamesaredefinedforthisattribute:SEQ_IN_INDEXorSEQ_IN_IND(warehousename),SeqInIndex(caption),SEQ_IN_INDEX(attributename),andSEQ_IN_IND(columnname).
SubPartattributeThenumberofsubpartitionsforthisindex.
Thetypeisintegerwithenumeratedvalues.
Thefollowingvaluesaredefined:NoValue(-3).
AnyvaluethatdoesnothaveadefinitionhereisdisplayedintheUserInterface.
Thefollowingnamesaredefinedforthisattribute:SUB_PART(warehousename),SubPart(caption),SUB_PART(attributename),andSUB_PART(columnname).
TableCatalogattributeThetablecatalogforthisindex.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:TABLE_CATALOGorTABLE_CATA(warehousename),TableCatalog(caption),TABLE_CATALOG(attributename),andTABLE_CATA(columnname).
TableNameattributeThetablenameforthisindex.
Thisattributeisakeyattribute.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:TABLE_NAME(warehousename),TableName(caption),TABLE_NAME(attributename),andTABLE_NAME(columnname).
TableSchemaattributeThetable'sschemaforthisindex.
Thisattributeisakeyattribute.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:TABLE_SCHEMAorTABLE_SCHE(warehousename),TableSchema(caption),TABLE_SCHEMA(attributename),andTABLE_SCHE(columnname).
TimestampattributeThelocaltimeattheagentwhenthedatawascollected.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:TIMESTAMP(warehousename),Timestamp(caption),Timestamp(attributename),andTIMESTAMP(columnname).
StatusattributegroupTheStatusattributegroupprovidestheoverallstatusoftheMySQLserver.
ThisattributegroupiseligibleforusewithTivoliDataWarehouse.
Thisattributegroupcontainsthefollowingattributes:36IBMTivoliCompositeApplicationManagerAgentforMySQL:MySQLagentReferenceCacheMissRatePercentattributeThepercentageofkeyreadsthatoccurredfromthediskinthelast5minutes.
Thetypeisrealnumber(64-bitgauge)withthreedecimalplacesofprecision.
Thefollowingnamesaredefinedforthisattribute:CACHE_MISS_RATE_PERCENTorCM_PCT(warehousename),CacheMissRatePercent(caption),Cache_Miss_Rate_Percent(attributename),andCM_PCT(columnname).
FullTableScansPercentattributeThepercentageofreadrequestsinthelast5minutesthatindicatefulltablescans.
Thetypeisrealnumber(64-bitgauge)withthreedecimalplacesofprecision.
Thefollowingnamesaredefinedforthisattribute:FULL_TABLE_SCANS_PERCENTorFTS_PCT(warehousename),FullTableScansPercent(caption),Full_Table_Scans_Percent(attributename),andFTS_PCT(columnname).
KeyReadRequestsPerSecattributeThenumberofkeyblockreadspersecondfromaphysicaldiskinthelast5minutes.
Thetypeisrealnumber(64-bitgauge)withthreedecimalplacesofprecision.
Thefollowingnamesaredefinedforthisattribute:KEY_READ_REQUESTS_PER_SECorKEY_READ_R(warehousename),KeyReadRequestsPerSec(caption),Key_Read_Requests_Per_Sec(attributename),andKEY_READ_R(columnname).
KeyReadsPerSecattributeThenumberofkeyblockreadrequestspersecondinthelast5minutes.
Thetypeisrealnumber(64-bitgauge)withthreedecimalplacesofprecision.
Thefollowingnamesaredefinedforthisattribute:KEY_READS_PER_SECorKEY_READS(warehousename),KeyReadsPerSec(caption),Key_Reads_Per_Sec(attributename),andKEY_READS(columnname).
MaxConnectionsattributeThemaximumnumberofpermittedconnectionsthatareconfigured.
Thetypeisinteger(64-bitgauge).
Thefollowingnamesaredefinedforthisattribute:MAX_CONNECTIONSorMAX_CONNEC(warehousename),MaxConnections(caption),Max_Connections(attributename),andMAX_CONNEC(columnname).
NodeattributeThemanagedsystemnameoftheagent.
Thisattributeisakeyattribute.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:NODE(warehousename),Node(caption),ORIGINNODE(attributename),andORIGINNODE(columnname).
OpenTablesattributeThenumberoftablesthatarecurrentlyopen.
Thetypeisinteger(64-bitgauge).
Thefollowingnamesaredefinedforthisattribute:OPEN_TABLESorOPEN_TABLE(warehousename),OpenTables(caption),Open_Tables(attributename),andOPEN_TABLE(columnname).
QueriesattributeThenumberofqueriespersecondthatoccurredsincetheserverwasstarted.
Thetypeisinteger(64-bitgauge).
Thefollowingnamesaredefinedforthisattribute:QUERIESorTQUERIES(warehousename),Queries(caption),Queries(attributename),andTQUERIES(columnname).
QueriesPerSecattributeThenumberofqueriespersecondthatoccurredinthelast5minutes.
Thetypeisrealnumber(64-bitgauge)withthreedecimalplacesofprecision.
Thefollowingnamesaredefinedforthisattribute:QUERIES_PER_SECorQUERIES(warehousename),QueriesPerSec(caption),Queries_Per_Sec(attributename),andQUERIES(columnname).
Chapter2.
Attributes37ReadRequestsFirstPerSecattributeThenumberofreadrequestspersecondforthefirstrowinthelast5minutes.
Thetypeisrealnumber(64-bitgauge)withthreedecimalplacesofprecision.
Thefollowingnamesaredefinedforthisattribute:READ_REQUESTS_FIRST_PER_SECorRDRQ_F(warehousename),ReadRequestsFirstPerSec(caption),Read_Requests_First_Per_Sec(attributename),andRDRQ_F(columnname).
ReadRequestsKeyPerSecattributeThenumberofreadrequestspersecondforarowbasedonakeyinthelast5minutes.
Thetypeisrealnumber(64-bitgauge)withthreedecimalplacesofprecision.
Thefollowingnamesaredefinedforthisattribute:READ_REQUESTS_KEY_PER_SECorRDRQ_KEY(warehousename),ReadRequestsKeyPerSec(caption),Read_Requests_Key_Per_Sec(attributename),andRDRQ_KEY(columnname).
ReadRequestsNextPerSecattributeThenumberofreadrequestspersecondforthenextrowinkeyorderinthelast5minutes.
Thetypeisrealnumber(64-bitgauge)withthreedecimalplacesofprecision.
Thefollowingnamesaredefinedforthisattribute:READ_REQUESTS_NEXT_PER_SECorRDRQ_N(warehousename),ReadRequestsNextPerSec(caption),Read_Requests_Next_Per_Sec(attributename),andRDRQ_N(columnname).
ReadRequestsPreviousPerSecattributeThenumberofreadrequestspersecondforthepreviousrowinkeyorderinthelast5minutes.
Thetypeisrealnumber(64-bitgauge)withthreedecimalplacesofprecision.
Thefollowingnamesaredefinedforthisattribute:READ_REQUESTS_PREVIOUS_PER_SECorRDRQ_P(warehousename),ReadRequestsPreviousPerSec(caption),Read_Requests_Previous_Per_Sec(attributename),andRDRQ_P(columnname).
ReadRequestsRndNextPerSecattributeThenumberofreadrequestspersecondforthenextrowinthedatafileinthelast5minutes.
Thetypeisrealnumber(64-bitgauge)withthreedecimalplacesofprecision.
Thefollowingnamesaredefinedforthisattribute:READ_REQUESTS_RND_NEXT_PER_SECorRDRQRND_N(warehousename),ReadRequestsRndNextPerSec(caption),Read_Requests_Rnd_Next_Per_Sec(attributename),andRDRQRND_N(columnname).
ReadRequestsRndPerSecattributeThenumberofreadrequestspersecondforarowinafixedpositioninthelast5minutes.
Thetypeisrealnumber(64-bitgauge)withthreedecimalplacesofprecision.
Thefollowingnamesaredefinedforthisattribute:READ_REQUESTS_RND_PER_SECorRDRQRND(warehousename),ReadRequestsRndPerSec(caption),Read_Requests_Rnd_Per_Sec(attributename),andRDRQRND(columnname).
ServerConnectionsUsedPercentattributeThepercentageoftheavailableserverconnectionsthatarecurrentlyinuse.
Thetypeisrealnumber(64-bitgauge)withthreedecimalplacesofprecision.
Thefollowingnamesaredefinedforthisattribute:SERVER_CONNECTIONS_USED_PERCENTorSCU_PCT(warehousename),ServerConnectionsUsedPercent(caption),Server_Connections_Used_Percent(attributename),andSCU_PCT(columnname).
SlowQueriesattributeThenumberofslowqueriespersecondthatoccurredsincetheserverwasstarted.
Thetypeisinteger(64-bitgauge).
Thefollowingnamesaredefinedforthisattribute:SLOW_QUERIESorSQ(warehousename),SlowQueries(caption),Slow_Queries(attributename),andSQ(columnname).
SlowQueriesPerSecattributeThenumberofslowqueriespersecondthatoccurredinthelast5minutes.
Thetypeisrealnumber(64-bitgauge)withthreedecimalplacesofprecision.
38IBMTivoliCompositeApplicationManagerAgentforMySQL:MySQLagentReferenceThefollowingnamesaredefinedforthisattribute:SLOW_QUERIES_PER_SECorSLOW_QUERI(warehousename),SlowQueriesPerSec(caption),Slow_Queries_Per_Sec(attributename),andSLOW_QUERI(columnname).
SlowQueriesPercentattributeThepercentageofqueriesthatwereslowinthelast5minutes.
Thetypeisrealnumber(64-bitgauge)withthreedecimalplacesofprecision.
Thefollowingnamesaredefinedforthisattribute:SLOW_QUERIES_PERCENTorSLWQ_PCT(warehousename),SlowQueriesPercent(caption),Slow_Queries_Percent(attributename),andSLWQ_PCT(columnname).
TableCachePercentUsedattributeThepercentageoftheavailabletablecacheoftheserverthatiscurrentlyinuse.
Thetypeisrealnumber(64-bitgauge)withthreedecimalplacesofprecision.
Thefollowingnamesaredefinedforthisattribute:TABLE_CACHE_PERCENT_USEDorTCPU(warehousename),TableCachePercentUsed(caption),Table_Cache_Percent_Used(attributename),andTCPU(columnname).
TableOpenCacheattributeTheconfigurednumberofopentablesforallthreads.
Thetypeisinteger(64-bitgauge).
Thefollowingnamesaredefinedforthisattribute:TABLE_OPEN_CACHEorT_OPEN_CAC(warehousename),TableOpenCache(caption),Table_Open_Cache(attributename),andT_OPEN_CAC(columnname).
TemporaryDiskTablesCreatedPerSecattributeThenumberoftemporarytablespersecondthatwerecreatedondiskinthelast5minutes.
Thetypeisrealnumber(64-bitgauge)withthreedecimalplacesofprecision.
Thefollowingnamesaredefinedforthisattribute:TEMPORARY_DISK_TABLES_CREATED_PER_SECorCRTD_TMPDT(warehousename),TemporaryDiskTablesCreatedPerSec(caption),Temporary_Disk_Tables_Created_Per_Sec(attributename),andCRTD_TMPDT(columnname).
TemporaryTablesCreatedPerSecattributeThenumberoftemporarytablesthatwerecreatedpersecondinthelast5minutes.
Thetypeisrealnumber(64-bitgauge)withthreedecimalplacesofprecision.
Thefollowingnamesaredefinedforthisattribute:TEMPORARY_TABLES_CREATED_PER_SECorCRTD_TMPT(warehousename),TemporaryTablesCreatedPerSec(caption),Temporary_Tables_Created_Per_Sec(attributename),andCRTD_TMPT(columnname).
TemporaryTablesOnDiskPercentattributeThepercentageoftemporarytablesthatarecreatedondiskinthelast5minutes.
Thetypeisrealnumber(64-bitgauge)withthreedecimalplacesofprecision.
Thefollowingnamesaredefinedforthisattribute:TEMPORARY_TABLES_ON_DISK_PERCENTorTTOD_PCT(warehousename),TemporaryTablesOnDiskPercent(caption),Temporary_Tables_On_Disk_Percent(attributename),andTTOD_PCT(columnname).
ThreadsConnectedattributeThenumberofcurrentlyconnectedthreads.
Thetypeisinteger(64-bitgauge).
Thefollowingnamesaredefinedforthisattribute:THREADS_CONNECTEDorTHREADS_CO(warehousename),ThreadsConnected(caption),Threads_Connected(attributename),andTHREADS_CO(columnname).
TimestampattributeThelocaltimeattheagentwhenthedatawascollected.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:TIMESTAMP(warehousename),Timestamp(caption),Timestamp(attributename),andTIMESTAMP(columnname).
Chapter2.
Attributes39TABLESattributegroupTheTablesattributegroupprovidesinformationabouttheMySQLtablespaces.
ThisattributegroupiseligibleforusewithTivoliDataWarehouse.
Thisattributegroupcontainsthefollowingattributes:AutoIncrementattributeThecurrentvaluefortheauto-incrementcolumn.
Thetypeisintegerwithenumeratedvalues.
Thefollowingvaluesaredefined:NoValue(-3).
AnyvaluethatdoesnothaveadefinitionhereisdisplayedintheUserInterface.
Thefollowingnamesaredefinedforthisattribute:AUTO_INCREMENTorAUTO_INCRE(warehousename),AutoIncrement(caption),AUTO_INCREMENT(attributename),andAUTO_INCRE(columnname).
AvgRowLengthattributeTheaveragelengthoftherowsinthetable.
Thetypeisintegerwithenumeratedvalues.
Thefollowingvaluesaredefined:NoValue(-3).
AnyvaluethatdoesnothaveadefinitionhereisdisplayedintheUserInterface.
Thefollowingnamesaredefinedforthisattribute:AVG_ROW_LENGTHorAVG_ROW_LE(warehousename),AvgRowLength(caption),AVG_ROW_LENGTH(attributename),andAVG_ROW_LE(columnname).
CheckTimeattributeThetimewhenthetablewaslastchecked.
Thetypeistimestamp.
Thefollowingnamesaredefinedforthisattribute:CHECK_TIME(warehousename),CheckTime(caption),CHECK_TIME(attributename),andCHECK_TIME(columnname).
ChecksumattributeThechecksumforthistable.
Thetypeisintegerwithenumeratedvalues.
Thefollowingvaluesaredefined:NoValue(-3).
AnyvaluethatdoesnothaveadefinitionhereisdisplayedintheUserInterface.
Thefollowingnamesaredefinedforthisattribute:CHECKSUM(warehousename),Checksum(caption),CHECKSUM(attributename),andCHECKSUM(columnname).
CreateOptionsattributeTheoptionsthatwereusedforcreatingthetable.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:CREATE_OPTIONSorCREATE_OPT(warehousename),CreateOptions(caption),CREATE_OPTIONS(attributename),andCREATE_OPT(columnname).
CreateTimeattributeThetimewhenthetablewascreated.
Thetypeistimestamp.
Thefollowingnamesaredefinedforthisattribute:CREATE_TIMEorCREATE_TIM(warehousename),CreateTime(caption),CREATE_TIME(attributename),andCREATE_TIM(columnname).
DataFreeattributeThedatathatisfreeforthistable.
Thetypeisintegerwithenumeratedvalues.
Thefollowingvaluesaredefined:NoValue(-3).
AnyvaluethatdoesnothaveadefinitionhereisdisplayedintheUserInterface.
Thefollowingnamesaredefinedforthisattribute:DATA_FREE(warehousename),DataFree(caption),DATA_FREE(attributename),andDATA_FREE(columnname).
DataLengthattributeThedatalengthforthistable.
Thetypeisintegerwithenumeratedvalues.
Thefollowingvaluesaredefined:NoValue(-3).
AnyvaluethatdoesnothaveadefinitionhereisdisplayedintheUserInterface.
40IBMTivoliCompositeApplicationManagerAgentforMySQL:MySQLagentReferenceThefollowingnamesaredefinedforthisattribute:DATA_LENGTHorDATA_LENGT(warehousename),DataLength(caption),DATA_LENGTH(attributename),andDATA_LENGT(columnname).
EngineattributeTheenginetypeofthistable.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:ENGINE(warehousename),Engine(caption),ENGINE(attributename),andENGINE(columnname).
IndexLengthattributeTheindexlengthforthistable.
Thetypeisintegerwithenumeratedvalues.
Thefollowingvaluesaredefined:NoValue(-3).
AnyvaluethatdoesnothaveadefinitionhereisdisplayedintheUserInterface.
Thefollowingnamesaredefinedforthisattribute:INDEX_LENGTHorINDEX_LENG(warehousename),IndexLength(caption),INDEX_LENGTH(attributename),andINDEX_LENG(columnname).
MaxDataLengthattributeThemaximumdatalengthforthistable.
Thetypeisintegerwithenumeratedvalues.
Thefollowingvaluesaredefined:NoValue(-3).
AnyvaluethatdoesnothaveadefinitionhereisdisplayedintheUserInterface.
Thefollowingnamesaredefinedforthisattribute:MAX_DATA_LENGTHorMAX_DATA_L(warehousename),MaxDataLength(caption),MAX_DATA_LENGTH(attributename),andMAX_DATA_L(columnname).
NodeattributeThemanagedsystemnameoftheagent.
Thisattributeisakeyattribute.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:NODE(warehousename),Node(caption),ORIGINNODE(attributename),andORIGINNODE(columnname).
RowFormatattributeTherowformatofthistable.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:ROW_FORMAT(warehousename),RowFormat(caption),ROW_FORMAT(attributename),andROW_FORMAT(columnname).
TableCatalogattributeThecatalogforthistable.
Thisattributeisakeyattribute.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:TABLE_CATALOGorTABLE_CATA(warehousename),TableCatalog(caption),TABLE_CATALOG(attributename),andTABLE_CATA(columnname).
TableCollationattributeTheencodingthatwasusedforthecollationofthetable.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:TABLE_COLLATIONorTABLE_COLL(warehousename),TableCollation(caption),TABLE_COLLATION(attributename),andTABLE_COLL(columnname).
TableCommentattributeTheusercommentforthistable.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:TABLE_COMMENTorTABLE_COMM(warehousename),TableComment(caption),TABLE_COMMENT(attributename),andTABLE_COMM(columnname).
TableNameattributeThenameofthistable.
Thisattributeisakeyattribute.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:TABLE_NAME(warehousename),TableName(caption),TABLE_NAME(attributename),andTABLE_NAME(columnname).
Chapter2.
Attributes41TableRowsattributeThenumberofrowsinthetable.
Thetypeisintegerwithenumeratedvalues.
Thefollowingvaluesaredefined:NoValue(-3).
AnyvaluethatdoesnothaveadefinitionhereisdisplayedintheUserInterface.
Thefollowingnamesaredefinedforthisattribute:TABLE_ROWS(warehousename),TableRows(caption),TABLE_ROWS(attributename),andTABLE_ROWS(columnname).
TableSchemaattributeTheschemaofthistable.
Thisattributeisakeyattribute.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:TABLE_SCHEMAorTABLE_SCHE(warehousename),TableSchema(caption),TABLE_SCHEMA(attributename),andTABLE_SCHE(columnname).
TableTypeattributeThetypeofthistable.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:TABLE_TYPE(warehousename),TableType(caption),TABLE_TYPE(attributename),andTABLE_TYPE(columnname).
TimestampattributeThelocaltimeattheagentwhenthedatawascollected.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:TIMESTAMP(warehousename),Timestamp(caption),Timestamp(attributename),andTIMESTAMP(columnname).
UpdateTimeattributeThetimewhenthetablewaslastupdated.
Thetypeistimestamp.
Thefollowingnamesaredefinedforthisattribute:UPDATE_TIMEorUPDATE_TIM(warehousename),UpdateTime(caption),UPDATE_TIME(attributename),andUPDATE_TIM(columnname).
VersionattributeTheversionofthistable.
Thetypeisintegerwithenumeratedvalues.
Thefollowingvaluesaredefined:NoValue(-3).
AnyvaluethatdoesnothaveadefinitionhereisdisplayedintheUserInterface.
Thefollowingnamesaredefinedforthisattribute:VERSION(warehousename),Version(caption),VERSION(attributename),andVERSION(columnname).
TakeActionStatusattributegroupTheTakeActionStatusdatasetcontainsinformationabouttheresultsofactionsthisagentran.
ThisattributegroupiseligibleforusewithTivoliDataWarehouse.
Thisattributegroupcontainsthefollowingattributes:ActionAppReturnCodeattributeTheapplicationreturncodeoftheactionistheactualreturncodeofthecommandrun.
Thetypeisinteger(32-bitnumericproperty).
Thefollowingnamesaredefinedforthisattribute:ACTION_APP_RETURN_CODEorTSKAPRC(warehousename),ActionAppReturnCode(caption),Action_App_Return_Code(attributename),andTSKAPRC(columnname).
ActionCommandattributeThecommandthatwasrunbytheaction.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:ACTION_COMMANDorTSKCMND(warehousename),ActionCommand(caption),Action_Command(attributename),andTSKCMND(columnname).
ActionIDattributeTheidoftheaction.
Thetypeisinteger(32-bitnumericproperty).
Thefollowingnamesaredefinedforthisattribute:ACTION_IDorTSKID(warehousename),ActionID(caption),Action_ID(attributename),andTSKID(columnname).
42IBMTivoliCompositeApplicationManagerAgentforMySQL:MySQLagentReferenceActionInstanceattributeTheinstancethatisassociatedwiththeoutputproducedbyrunningtheaction.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:ACTION_INSTANCEorTSKINST(warehousename),ActionInstance(caption),Action_Instance(attributename),andTSKINST(columnname).
ActionMessageattributeThemessagethatisassociatedwiththereturncodeoftheaction.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:ACTION_MESSAGEorTSKMSGE(warehousename),ActionMessage(caption),Action_Message(attributename),andTSKMSGE(columnname).
ActionNameattributeThenameoftheactionthatwasrun.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:ACTION_NAMEorTSKNAME(warehousename),ActionName(caption),Action_Name(attributename),andTSKNAME(columnname).
ActionNodeattributeThenodewheretheactionran.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:ACTION_NODEorTSKORGN(warehousename),ActionNode(caption),Action_Node(attributename),andTSKORGN(columnname).
ActionOwnerattributeThenameofthesituationoruserthatinitiatedtheaction.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:ACTION_OWNERorTSKOWNR(warehousename),ActionOwner(caption),Action_Owner(attributename),andTSKOWNR(columnname).
ActionResultsattributeTheoutputthatisproducedbyrunningtheaction.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:ACTION_RESULTSorTSKOUTP(warehousename),ActionResults(caption),Action_Results(attributename),andTSKOUTP(columnname).
ActionStatusattributeThereturncodefromtheActionStatusdialog,whichisthereturncodecategorythatisdefinedfortheapplicationreturncode.
Thetypeisinteger(32-bitnumericproperty).
Thefollowingnamesaredefinedforthisattribute:ACTION_STATUSorTSKSTAT(warehousename),ActionStatus(caption),Action_Status(attributename),andTSKSTAT(columnname).
ActionSubnodeattributeThesubnodewheretheactionran.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:ACTION_SUBNODEorTSKSBND(warehousename),ActionSubnode(caption),Action_Subnode(attributename),andTSKSBND(columnname).
ActionTypeattributeThetypeoftheaction.
Thetypeisinteger(32-bitnumericproperty)withenumeratedvalues.
Thefollowingvaluesaredefined:UNKNOWN(0),AUTOMATION(1).
AnyvaluethatdoesnothaveadefinitionhereisdisplayedintheUserInterface.
Thefollowingnamesaredefinedforthisattribute:ACTION_TYPEorTSKTYPE(warehousename),ActionType(caption),Action_Type(attributename),andTSKTYPE(columnname).
NodeattributeThemanagedsystemnameoftheagent.
Thisattributeisakeyattribute.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:NODE(warehousename),Node(caption),ORIGINNODE(attributename),andORIGINNODE(columnname).
TimestampattributeThetimetheeventwasgenerated.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:TIMESTAMP(warehousename),Timestamp(caption),Timestamp(attributename),andTIMESTAMP(columnname).
Chapter2.
Attributes43ThreadPoolStatusattributegroupTheThreadPoolStatusattributegroupcontainsinformationthatreflectsthestatusoftheinternalthreadpoolusedtocollectdataasynchronously.
ThisattributegroupiseligibleforusewithTivoliDataWarehouse.
Thisattributegroupcontainsthefollowingattributes:NodeattributeThemanagedsystemnameoftheagent.
Thisattributeisakeyattribute.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:NODE(warehousename),Node(caption),ORIGINNODE(attributename),andORIGINNODE(columnname).
ThreadPoolActiveThreadsattributeThenumberofthreadsinthethreadpoolcurrentlyactivedoingwork.
Thetypeisinteger(32-bitgauge)withenumeratedvalues.
Thefollowingvaluesaredefined:NODATA(-1),NODATA(-100).
AnyvaluethatdoesnothaveadefinitionhereisdisplayedintheUserInterface.
Thefollowingnamesaredefinedforthisattribute:THREAD_POOL_ACTIVE_THREADSorTPACTTH(warehousename),ThreadPoolActiveThreads(caption),Thread_Pool_Active_Threads(attributename),andTPACTTH(columnname).
ThreadPoolAvgActiveThreadsattributeTheaveragenumberofthreadsinthethreadpoolsimultaneouslyactivedoingwork.
Thetypeisrealnumber(32-bitgauge)withtwodecimalplacesofprecisionwithenumeratedvalues.
Thefollowingvaluesaredefined:NODATA(-1),NODATA(-100).
AnyvaluethatdoesnothaveadefinitionhereisdisplayedintheUserInterface.
Thefollowingnamesaredefinedforthisattribute:THREAD_POOL_AVG_ACTIVE_THREADSorTPAVGAT(warehousename),ThreadPoolAvgActiveThreads(caption),Thread_Pool_Avg_Active_Threads(attributename),andTPAVGAT(columnname).
ThreadPoolAvgJobWaitattributeTheaveragetimeajobspendswaitingonthethreadpoolqueueinseconds.
Thetypeisrealnumber(32-bitgauge)withtwodecimalplacesofprecisionwithenumeratedvalues.
Thefollowingvaluesaredefined:NODATA(-1),NODATA(-100).
AnyvaluethatdoesnothaveadefinitionhereisdisplayedintheUserInterface.
Thefollowingnamesaredefinedforthisattribute:THREAD_POOL_AVG_JOB_WAITorTPAVJBW(warehousename),ThreadPoolAvgJobWait(caption),Thread_Pool_Avg_Job_Wait(attributename),andTPAVJBW(columnname).
ThreadPoolAvgQueueLengthattributeTheaveragelengthofthethreadpoolqueueduringthisrun.
Thetypeisrealnumber(32-bitgauge)withtwodecimalplacesofprecisionwithenumeratedvalues.
Thefollowingvaluesaredefined:NODATA(-1),NODATA(-100).
AnyvaluethatdoesnothaveadefinitionhereisdisplayedintheUserInterface.
Thefollowingnamesaredefinedforthisattribute:THREAD_POOL_AVG_QUEUE_LENGTHorTPAVGQL(warehousename),ThreadPoolAvgQueueLength(caption),Thread_Pool_Avg_Queue_Length(attributename),andTPAVGQL(columnname).
ThreadPoolMaxActiveThreadsattributeThepeaknumberofthreadsinthethreadpoolthatweresimultaneouslyactivedoingwork.
Thetypeisinteger(32-bitcounter)withenumeratedvalues.
Thefollowingvaluesaredefined:NODATA(-1),NODATA(-100).
AnyvaluethatdoesnothaveadefinitionhereisdisplayedintheUserInterface.
Thefollowingnamesaredefinedforthisattribute:THREAD_POOL_MAX_ACTIVE_THREADSorTPMAXAT(warehousename),ThreadPoolMaxActiveThreads(caption),Thread_Pool_Max_Active_Threads(attributename),andTPMAXAT(columnname).
44IBMTivoliCompositeApplicationManagerAgentforMySQL:MySQLagentReferenceThreadPoolMaxQueueLengthattributeThepeaklengththethreadpoolqueuereached.
Thetypeisinteger(32-bitcounter)withenumeratedvalues.
Thefollowingvaluesaredefined:NODATA(-1),NODATA(-100).
AnyvaluethatdoesnothaveadefinitionhereisdisplayedintheUserInterface.
Thefollowingnamesaredefinedforthisattribute:THREAD_POOL_MAX_QUEUE_LENGTHorTPMAXQL(warehousename),ThreadPoolMaxQueueLength(caption),Thread_Pool_Max_Queue_Length(attributename),andTPMAXQL(columnname).
ThreadPoolMaxSizeattributeThemaximumnumberofthreadsthatareallowedtoexistinthethreadpool.
Thetypeisinteger(32-bitnumericproperty)withenumeratedvalues.
Thefollowingvaluesaredefined:NODATA(-1),NODATA(-100).
AnyvaluethatdoesnothaveadefinitionhereisdisplayedintheUserInterface.
Thefollowingnamesaredefinedforthisattribute:THREAD_POOL_MAX_SIZEorTPMAXSZ(warehousename),ThreadPoolMaxSize(caption),Thread_Pool_Max_Size(attributename),andTPMAXSZ(columnname).
ThreadPoolMinActiveThreadsattributeThesmallestnumberofthreadsinthethreadpoolthatweresimultaneouslyactivedoingwork.
Thetypeisinteger(32-bitcounter)withenumeratedvalues.
Thefollowingvaluesaredefined:NODATA(-1),NODATA(-100).
AnyvaluethatdoesnothaveadefinitionhereisdisplayedintheUserInterface.
Thefollowingnamesaredefinedforthisattribute:THREAD_POOL_MIN_ACTIVE_THREADSorTPMINAT(warehousename),ThreadPoolMinActiveThreads(caption),Thread_Pool_Min_Active_Threads(attributename),andTPMINAT(columnname).
ThreadPoolMinQueueLengthattributeTheminimumlengththethreadpoolqueuereached.
Thetypeisinteger(32-bitcounter)withenumeratedvalues.
Thefollowingvaluesaredefined:NODATA(-1),NODATA(-100).
AnyvaluethatdoesnothaveadefinitionhereisdisplayedintheUserInterface.
Thefollowingnamesaredefinedforthisattribute:THREAD_POOL_MIN_QUEUE_LENGTHorTPMINQL(warehousename),ThreadPoolMinQueueLength(caption),Thread_Pool_Min_Queue_Length(attributename),andTPMINQL(columnname).
ThreadPoolQueueLengthattributeThenumberofjobscurrentlywaitinginthethreadpoolqueue.
Thetypeisinteger(32-bitgauge)withenumeratedvalues.
Thefollowingvaluesaredefined:NODATA(-1),NODATA(-100).
AnyvaluethatdoesnothaveadefinitionhereisdisplayedintheUserInterface.
Thefollowingnamesaredefinedforthisattribute:THREAD_POOL_QUEUE_LENGTHorTPQLGTH(warehousename),ThreadPoolQueueLength(caption),Thread_Pool_Queue_Length(attributename),andTPQLGTH(columnname).
ThreadPoolSizeattributeThenumberofthreadscurrentlyexistinginthethreadpool.
Thetypeisinteger(32-bitgauge)withenumeratedvalues.
Thefollowingvaluesaredefined:NODATA(-1),NODATA(-100).
AnyvaluethatdoesnothaveadefinitionhereisdisplayedintheUserInterface.
Thefollowingnamesaredefinedforthisattribute:THREAD_POOL_SIZEorTHPSIZE(warehousename),ThreadPoolSize(caption),Thread_Pool_Size(attributename),andTHPSIZE(columnname).
ThreadPoolTotalJobsattributeThenumberofjobsthatarecompletedbyallthreadsinthepoolsinceagentstart.
Thetypeisinteger(32-bitcounter)withenumeratedvalues.
Thefollowingvaluesaredefined:NODATA(-1),NODATA(-100).
AnyvaluethatdoesnothaveadefinitionhereisdisplayedintheUserInterface.
Thefollowingnamesaredefinedforthisattribute:THREAD_POOL_TOTAL_JOBSorTPTJOBS(warehousename),ThreadPoolTotalJobs(caption),Thread_Pool_Total_Jobs(attributename),andTPTJOBS(columnname).
TimestampattributeThelocaltimeattheagentwhenthedatawascollected.
Thetypeisstring.
Chapter2.
Attributes45Thefollowingnamesaredefinedforthisattribute:TIMESTAMP(warehousename),Timestamp(caption),Timestamp(attributename),andTIMESTAMP(columnname).
USERPRIVILEGESattributegroupInformationonuserprivilegesbycatalog,fromthetableUSER_PRIVILEGES.
ThisattributegroupiseligibleforusewithTivoliDataWarehouse.
Thisattributegroupcontainsthefollowingattributes:GranteeattributeThegranteeforthisprivilege.
Thisattributeisakeyattribute.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:GRANTEE(warehousename),Grantee(caption),GRANTEE(attributename),andGRANTEE(columnname).
IsGrantableattributeWhetherthisprivilegecanbegrantedbythegranteeforthewholecatalog.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:IS_GRANTABLEorIS_GRANTAB(warehousename),IsGrantable(caption),IS_GRANTABLE(attributename),andIS_GRANTAB(columnname).
NodeattributeThemanagedsystemnameoftheagent.
Thisattributeisakeyattribute.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:NODE(warehousename),Node(caption),ORIGINNODE(attributename),andORIGINNODE(columnname).
PrivilegeTypeattributeThetypeofthisprivilege.
Thisattributeisakeyattribute.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:PRIVILEGE_TYPEorPRIVILEGE_(warehousename),PrivilegeType(caption),PRIVILEGE_TYPE(attributename),andPRIVILEGE_(columnname).
TableCatalogattributeThecatalogthisprivilegeappliesto.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:TABLE_CATALOGorTABLE_CATA(warehousename),TableCatalog(caption),TABLE_CATALOG(attributename),andTABLE_CATA(columnname).
TimestampattributeThelocaltimeattheagentwhenthedatawascollected.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:TIMESTAMP(warehousename),Timestamp(caption),Timestamp(attributename),andTIMESTAMP(columnname).
UsersattributegroupTheUsersattributegroupdisplaysinformationofeachuserthatconnectstotheserveralongwithcurrentandtotalconnections.
ThisattributegroupiseligibleforusewithTivoliDataWarehouse.
Thisattributegroupcontainsthefollowingattributes:currentConnectionsattributeCurrentConnectionsattributedisplayscurrentconnectionsfortheuser.
Thetypeisintegerwithenumeratedvalues.
Thefollowingvaluesaredefined:NA(-1).
AnyvaluethatdoesnothaveadefinitionhereisdisplayedintheUserInterface.
Thefollowingnamesaredefinedforthisattribute:CURRENTCONNECTIONSorCURRENTCON(warehousename),currentConnections(caption),currentConnections(attributename),andCURRENTCON(columnname).
NodeattributeThemanagedsystemnameoftheagent.
Thisattributeisakeyattribute.
Thetypeisstring.
46IBMTivoliCompositeApplicationManagerAgentforMySQL:MySQLagentReferenceThefollowingnamesaredefinedforthisattribute:NODE(warehousename),Node(caption),ORIGINNODE(attributename),andORIGINNODE(columnname).
TimestampattributeThelocaltimeattheagentwhenthedatawascollected.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:TIMESTAMP(warehousename),Timestamp(caption),Timestamp(attributename),andTIMESTAMP(columnname).
totalConnectionsattributeTotalConnectionsattributesdisplaystotalconnectionsfortheuser.
Thetypeisintegerwithenumeratedvalues.
Thefollowingvaluesaredefined:NA(-1).
AnyvaluethatdoesnothaveadefinitionhereisdisplayedintheUserInterface.
Thefollowingnamesaredefinedforthisattribute:TOTALCONNECTIONSorTOTALCONNE(warehousename),totalConnections(caption),totalConnections(attributename),andTOTALCONNE(columnname).
userattributeUserattributedisplaystheconnection'sclientusernamefortheconnection,orNo_Valuesifaninternalthread.
Thisattributeisakeyattribute.
Thetypeisstring.
Thefollowingnamesaredefinedforthisattribute:USER(warehousename),user(caption),user(attributename),andUSER(columnname).
DiskcapacityplanningforhistoricaldataDiskcapacityplanningforamonitoringagentisapredictionoftheamountofdiskspacetobeconsumedbythehistoricaldataineachattributegroupthatiscollectinghistoricaldata.
Requireddiskstorageisanimportantfactorwhenyouaredefiningdatacollectionrulesandyourstrategyforhistoricaldatacollection.
TheCapacityplanningforhistoricaldatatableprovidesthefollowinginformation,whichisrequiredtocalculatediskspaceforthismonitoringagent:TableTablenameasitisdisplayedinthewarehousedatabase,iftheattributegroupisconfiguredtobewrittentothewarehouse.
Thetablenamelistedherecorrespondstothetablenamein"Attributegroupsforthemonitoringagent"onpage6.
AttributegroupNameoftheattributegroupthatisusedtocreatethetableinthewarehousedatabaseifitisshortenoughtofitinthetablenamingconstraintsofthedatabasethatisbeingusedforthewarehouse.
TheattributegroupnamelistedherecorrespondstotheWarehousetablenamein"Attributegroupsforthemonitoringagent"onpage6.
Bytesperrow(agent)Estimateoftherecordlengthforeachroworinstancethatiswrittentotheagentdiskforhistoricaldatacollection.
Thisestimatecanbeusedforagentdiskspaceplanningpurposes.
Databasebytesperrow(warehouse)Estimateoftherecordlengthfordetailedrecordsthatarewrittentothewarehousedatabase,iftheattributegroupisconfiguredtobewrittentothewarehouse.
Detailedrecordsarerecordsthathavebeenuploadedfromtheagentforlong-termhistoricaldatacollection.
Thisestimatecanbeusedforwarehousedisk-spaceplanningpurposes.
Aggregatebytesperrow(warehouse)Estimateoftherecordlengthforaggregaterecordsthatarewrittentothewarehousedatabase,iftheattributegroupisconfiguredtobewrittentothewarehouse.
AggregaterecordsarecreatedbytheSummarizationagentforattributegroupsthathavebeenconfiguredforsummarization.
Thisestimatecanbeusedforwarehousedisk-spaceplanningpurposes.
Inadditiontotheinformationinthetables,youmustknowthenumberofrowsofdatathatyouplantocollect.
Anattributegroupcanhavesingleormultiplerowsofdata,dependingontheapplicationChapter2.
Attributes47environmentthatisbeingmonitored.
Forexample,ifyourattributegroupmonitorseachprocessorinyourcomputerandyouhaveadualprocessorcomputer,thenumberofrowsistwo.
Table1.
CapacityplanningforhistoricaldataloggedbytheMySQLagentTableAttributegroupBytesperrow(agent)Databasebytesperrow(warehouse)Aggregatebytesperrow(warehouse)Formoreinformationabouthistoricaldatacollection,see"Managinghistoricaldata"intheIBMTivoliMonitoringAdministrator'sGuide.
48IBMTivoliCompositeApplicationManagerAgentforMySQL:MySQLagentReferenceChapter3.
SituationsAsituationisalogicalexpressioninvolvingoneormoresystemconditions.
Situationsareusedtomonitortheconditionofsystemsinyournetwork.
YoucanmanagesituationsfromtheTivoliEnterprisePortalbyusingtheSituationEditororfromthecommand-lineinterfaceusingthetacmdcommandsforsituations.
YoucanmanageprivatesituationsintheprivateconfigurationXMLfile.
AboutsituationsThemonitoringagentsthatyouusetomonitoryoursystemenvironmentincludeasetofpredefinedsituationsthatyoucanuseas-is.
Youcanalsocreatenewsituationstomeetyourrequirements.
Predefinedsituationscontainattributesthatcheckforsystemconditionscommontomanyenterprises.
UsingpredefinedsituationscanimprovethespeedwithwhichyoucanbeginusingtheIBMTivoliCompositeApplicationManagerAgentforMySQL.
Youcanchangetheconditionsorvaluesbeingmonitoredbyapredefinedsituationtotheconditionsorvaluesbestsuitedtoyourenterprise.
YoucandisplaypredefinedsituationsandcreateyourownsituationsusingtheSituationeditor.
TheSituationeditorinitiallyliststhesituationsassociatedwiththenavigatoritemthatyouselected.
Whenyouclickasituationnameorcreateasituation,apanelopenswiththefollowingtabs:FormulaFormuladescribingtheconditionbeingtested.
DistributionListofmanagedsystems(operatingsystems,subsystems,orapplications)towhichthesituationcanbedistributed.
AlltheMySQLagentmanagedsystemsareassignedbydefault.
ExpertadviceCommentsandinstructionstobereadintheeventworkspace.
ActionCommandtobesenttothesystem.
EIFCustomizeforwardingoftheeventtoanEventIntegrationFacilityreceiver.
(AvailablewhentheTivoliEnterpriseMonitoringServerisconfiguredtoforwardevents.
)UntilOptionstoclosetheeventafteraperiodoftime,orwhenanothersituationbecomestrue.
AdditionalinformationaboutsituationsTheTivoliEnterprisePortalUser'sGuidecontainsmoreinformationaboutpredefinedandcustomsituationsandhowtousethemtorespondtoalerts.
Foralistofthepredefinedsituationsandinformationabouteachindividualsituationforthismonitoringagent,see"Predefinedsituations"onpage49.
PredefinedsituationsThemonitoringagentcontainspredefinedsituations,whichareorganizedbyNavigatoritem.
MySQL–NotapplicableAvailability–KSE_MySQL_Process_DownConfiguration–KSE_MySQL_Service_DownCopyrightIBMCorp.
2016,202049Databases–NotapplicableEvents–NotapplicableInnoDB–NotapplicableServer–KSE_High_CPU_Crit–KSE_High_CPU_Warn–KSE_MySQL_Cache_Miss_Rate_Crit–KSE_MySQL_Cache_Miss_Rate_Warn–KSE_MySQL_Connections_Used_Crit–KSE_MySQL_Connections_Used_High–KSE_MySQL_Full_Table_Scans_High–KSE_MySQL_Queries_Slow–KSE_MySQL_Queries_Slow_Warn–KSE_MySQL_Table_Cache_Used_Crit–KSE_MySQL_Table_Cache_Used_Warn–KSE_Physical_Memory_High_Crit–KSE_Physical_Memory_High_WarnTables–NotapplicableSituationdescriptionsEachsituationdescriptionprovidesinformationaboutthesituationthatyoucanusetomonitortheconditionofsystemsinyournetwork.
Thesituationdescriptionsprovidethefollowinginformation:DescriptionInformationabouttheconditionsthatthesituationtests.
FormulaSyntaxthatcontainsoneormorelogicalexpressionsthatdescribetheconditionsforthesituationtomonitor.
DistributionWhetherthesituationisautomaticallydistributedtoinstancesoftheagentorisavailableformanualdistribution.
RunatstartupWhetherthesituationstartsmonitoringwhentheagentstarts.
SamplingintervalNumberofsecondsthatelapsebetweenonesampleofdatathatthemonitoringagentcollectsfortheserverandthenextsample.
SituationpersistenceWhethertheconditionsspecifiedinthesituationevaluateto"true"forthedefinednumberofoccurrencesinarowbeforethesituationisraised.
Thedefaultofonemeansthatnopersistence-checkingtakesplace.
50IBMTivoliCompositeApplicationManagerAgentforMySQL:MySQLagentReferenceSeveritySeverityofthepredefinedevents:Warning,Informational,orCritical.
ClearingconditionsControlswhenatruesituationcloses:afteraperiod,whenanothersituationistrue,orwhicheveroccursfirstifbothareselected.
MySQLnavigatoritemNopredefinedsituationsareincludedforthisnavigatoritem.
AvailabilitynavigatoritemThesituationdescriptionsareorganizedbythenavigatoritemtowhichthesituationsarerelevant.
KSE_MySQL_Process_DownsituationDescriptionTheMySQLprocessisdown.
(Thissituationhasbeendeprecated.
UsenewsituationMySQL_Service_Down.
)ThesituationisevaluatedforeachdistinctvalueoftheApplication_Componentattribute.
Formula*IF*VALUEKSE_AVAILABILITY.
Status*EQ99See"Attributesineachattributegroup"onpage8fordescriptionsoftheattributesinthisformula.
DistributionThissituationisautomaticallydistributedtoinstancesofthisagent.
RunatstartupYesSamplinginterval15minutesSituationpersistenceThenumberoftimestheconditionspecifiedbythesituationmustoccurforthesituationtobetrueis1.
ErrorconditionsCriticalClearingconditionsThesituationclearswhentheconditionbecomesfalse.
ConfigurationnavigatoritemThesituationdescriptionsareorganizedbythenavigatoritemtowhichthesituationsarerelevant.
KSE_MySQL_Service_DownsituationDescriptionTheMySQLserviceisdown.
ThesituationisevaluatedforeachdistinctvalueoftheStatusattribute.
Formula*IF*VALUEKSE_APPLICATION_AVAILABILITY.
Status*EQ'down'See"Attributesineachattributegroup"onpage8fordescriptionsoftheattributesinthisformula.
DistributionThissituationisautomaticallydistributedtoinstancesofthisagent.
Chapter3.
Situations51RunatstartupYesSamplinginterval1minuteSituationpersistenceThenumberoftimestheconditionspecifiedbythesituationmustoccurforthesituationtobetrueis1.
ErrorconditionsCriticalClearingconditionsThesituationclearswhentheconditionbecomesfalse.
DatabasesnavigatoritemNopredefinedsituationsareincludedforthisnavigatoritem.
EventsnavigatoritemNopredefinedsituationsareincludedforthisnavigatoritem.
InnoDBnavigatoritemNopredefinedsituationsareincludedforthisnavigatoritem.
ServernavigatoritemThesituationdescriptionsareorganizedbythenavigatoritemtowhichthesituationsarerelevant.
KSE_High_CPU_CritsituationDescriptionTheprocessorusageisgreaterthanthecriticalthresholdof80percent.
Theprocessorusageiscalculatedbytheusageofmysqldprocess.
ThesituationisevaluatedforeachdistinctvalueoftheCPU_Valueattribute.
Formula*IF*VALUEKSE_DB_CPU.
CPU_Value*GT80See"Attributesineachattributegroup"onpage8fordescriptionsoftheattributesinthisformula.
DistributionThissituationisautomaticallydistributedtoinstancesofthisagent.
RunatstartupYesSamplinginterval5minutesSituationpersistenceThenumberoftimestheconditionspecifiedbythesituationmustoccurforthesituationtobetrueis1.
ErrorconditionsCriticalClearingconditionsThesituationclearswhentheconditionbecomesfalse.
KSE_High_CPU_Warnsituation52IBMTivoliCompositeApplicationManagerAgentforMySQL:MySQLagentReferenceDescriptionTheprocessorusageisgreaterthanthewarningthresholdof50percent.
TheprocessorusageiscalculatedbytheusageofmysqldprocessThesituationisevaluatedforeachdistinctvalueoftheCPU_Valueattribute.
Formula*IF*VALUEKSE_DB_CPU.
CPU_Value*GT50*AND*VALUEKSE_DB_CPU.
CPU_Value*LE80See"Attributesineachattributegroup"onpage8fordescriptionsoftheattributesinthisformula.
DistributionThissituationisautomaticallydistributedtoinstancesofthisagent.
RunatstartupYesSamplinginterval5minutesSituationpersistenceThenumberoftimestheconditionspecifiedbythesituationmustoccurforthesituationtobetrueis1.
ErrorconditionsWarningClearingconditionsThesituationclearswhentheconditionbecomesfalse.
KSE_MySQL_Cache_Miss_Rate_CritsituationDescriptionThenumberofcacheaccessattemptspersecondthatfailedisgreaterthan80percent.
ThesituationisevaluatedforeachdistinctvalueoftheVARIABLE_NAMEattribute.
Formula*IF*VALUEKSE_STATUS.
Cache_Miss_Rate_Percent*GT80See"Attributesineachattributegroup"onpage8fordescriptionsoftheattributesinthisformula.
DistributionThissituationisautomaticallydistributedtoinstancesofthisagent.
RunatstartupYesSamplinginterval15minutesSituationpersistenceThenumberoftimestheconditionspecifiedbythesituationmustoccurforthesituationtobetrueis1.
ErrorconditionsCriticalClearingconditionsThesituationclearswhentheconditionbecomesfalse.
KSE_MySQL_Cache_Miss_Rate_WarnsituationDescriptionThenumberofcacheaccessattemptspersecondthatfailedisgreaterthan60percent.
Chapter3.
Situations53ThesituationisevaluatedforeachdistinctvalueoftheVARIABLE_NAMEattribute.
Formula*IF*VALUEKSE_STATUS.
Cache_Miss_Rate_Percent*GT60*AND*VALUEKSE_STATUS.
Cache_Miss_Rate_Percent*LE80See"Attributesineachattributegroup"onpage8fordescriptionsoftheattributesinthisformula.
DistributionThissituationisautomaticallydistributedtoinstancesofthisagent.
RunatstartupYesSamplinginterval15minutesSituationpersistenceThenumberoftimestheconditionspecifiedbythesituationmustoccurforthesituationtobetrueis1.
ErrorconditionsWarningClearingconditionsThesituationclearswhentheconditionbecomesfalse.
KSE_MySQL_Connections_Used_CritsituationDescriptionThenumberofconnectionstoMySQLhasexceeded90percentofthemaximumpermittedconnections.
ThesituationisevaluatedforeachdistinctvalueoftheVARIABLE_NAMEattribute.
Formula*IF*VALUEKSE_STATUS.
Server_Connections_Used_Percent*GT90See"Attributesineachattributegroup"onpage8fordescriptionsoftheattributesinthisformula.
DistributionThissituationisautomaticallydistributedtoinstancesofthisagent.
RunatstartupYesSamplinginterval15minutesSituationpersistenceThenumberoftimestheconditionspecifiedbythesituationmustoccurforthesituationtobetrueis1.
ErrorconditionsCriticalClearingconditionsThesituationclearswhentheconditionbecomesfalse.
KSE_MySQL_Connections_Used_HighsituationDescriptionThenumberofconnectionstoMySQLhasexceeded80percentofthemaximumpermittedconnections.
ThesituationisevaluatedforeachdistinctvalueoftheVARIABLE_NAMEattribute.
54IBMTivoliCompositeApplicationManagerAgentforMySQL:MySQLagentReferenceFormula*IF*VALUEKSE_STATUS.
Server_Connections_Used_Percent*GT80*AND*VALUEKSE_STATUS.
Server_Connections_Used_Percent*LE90See"Attributesineachattributegroup"onpage8fordescriptionsoftheattributesinthisformula.
DistributionThissituationisautomaticallydistributedtoinstancesofthisagent.
RunatstartupYesSamplinginterval15minutesSituationpersistenceThenumberoftimestheconditionspecifiedbythesituationmustoccurforthesituationtobetrueis1.
ErrorconditionsWarningClearingconditionsThesituationclearswhentheconditionbecomesfalse.
KSE_MySQL_Full_Table_Scans_HighsituationDescriptionThepercentageoffulltablescansisgreaterthan5.
ThesituationisevaluatedforeachdistinctvalueoftheVARIABLE_NAMEattribute.
Formula*IF*VALUEKSE_STATUS.
Full_Table_Scans_Percent*GT5See"Attributesineachattributegroup"onpage8fordescriptionsoftheattributesinthisformula.
DistributionThissituationisautomaticallydistributedtoinstancesofthisagent.
RunatstartupYesSamplinginterval15minutesSituationpersistenceThenumberoftimestheconditionspecifiedbythesituationmustoccurforthesituationtobetrueis1.
ErrorconditionsWarningClearingconditionsThesituationclearswhentheconditionbecomesfalse.
KSE_MySQL_Queries_SlowsituationDescriptionMorethan20%ofqueriesareslow.
ThesituationisevaluatedforeachdistinctvalueoftheVARIABLE_NAMEattribute.
Formula*IF*VALUEKSE_STATUS.
Slow_Queries_Percent*GT20Chapter3.
Situations55See"Attributesineachattributegroup"onpage8fordescriptionsoftheattributesinthisformula.
DistributionThissituationisautomaticallydistributedtoinstancesofthisagent.
RunatstartupYesSamplinginterval15minutesSituationpersistenceThenumberoftimestheconditionspecifiedbythesituationmustoccurforthesituationtobetrueis1.
ErrorconditionsCriticalClearingconditionsThesituationclearswhentheconditionbecomesfalse.
KSE_MySQL_Queries_Slow_WarnsituationDescriptionThepercentageofslowqueriesisgreaterthan10.
ThesituationisevaluatedforeachdistinctvalueoftheVARIABLE_NAMEattribute.
Formula*IF*VALUEKSE_STATUS.
Slow_Queries_Percent*GT10*AND*VALUEKSE_STATUS.
Slow_Queries_Percent*LE20See"Attributesineachattributegroup"onpage8fordescriptionsoftheattributesinthisformula.
DistributionThissituationisautomaticallydistributedtoinstancesofthisagent.
RunatstartupYesSamplinginterval15minutesSituationpersistenceThenumberoftimestheconditionspecifiedbythesituationmustoccurforthesituationtobetrueis1.
ErrorconditionsWarningClearingconditionsThesituationclearswhentheconditionbecomesfalse.
KSE_MySQL_Table_Cache_Used_CritsituationDescriptionThetablecacheusagehasexceededthecriticalthresholdof90percent.
ThesituationisevaluatedforeachdistinctvalueoftheVARIABLE_NAMEattribute.
Formula*IF*VALUEKSE_STATUS.
Table_Cache_Percent_Used*GT90See"Attributesineachattributegroup"onpage8fordescriptionsoftheattributesinthisformula.
56IBMTivoliCompositeApplicationManagerAgentforMySQL:MySQLagentReferenceDistributionThissituationisautomaticallydistributedtoinstancesofthisagent.
RunatstartupYesSamplinginterval15minutesSituationpersistenceThenumberoftimestheconditionspecifiedbythesituationmustoccurforthesituationtobetrueis1.
ErrorconditionsCriticalClearingconditionsThesituationclearswhentheconditionbecomesfalse.
KSE_MySQL_Table_Cache_Used_WarnsituationDescriptionThetablecacheusagehasexceededthewarningthresholdof80percent.
ThesituationisevaluatedforeachdistinctvalueoftheVARIABLE_NAMEattribute.
Formula*IF*VALUEKSE_STATUS.
Table_Cache_Percent_Used*GT80*AND*VALUEKSE_STATUS.
Table_Cache_Percent_Used*LE90See"Attributesineachattributegroup"onpage8fordescriptionsoftheattributesinthisformula.
DistributionThissituationisautomaticallydistributedtoinstancesofthisagent.
RunatstartupYesSamplinginterval15minutesSituationpersistenceThenumberoftimestheconditionspecifiedbythesituationmustoccurforthesituationtobetrueis1.
ErrorconditionsWarningClearingconditionsThesituationclearswhentheconditionbecomesfalse.
KSE_Physical_Memory_High_CritsituationDescriptionThephysicalmemoryofthemysqldprocessisgreaterthanthecriticalthresholdofoneGB.
ThesituationisevaluatedforeachdistinctvalueoftheMemoryattribute.
Formula*IF*VALUEKSE_DB_MEMORY.
Memory*GT1024See"Attributesineachattributegroup"onpage8fordescriptionsoftheattributesinthisformula.
DistributionThissituationisautomaticallydistributedtoinstancesofthisagent.
Chapter3.
Situations57RunatstartupYesSamplinginterval5minutesSituationpersistenceThenumberoftimestheconditionspecifiedbythesituationmustoccurforthesituationtobetrueis1.
ErrorconditionsCriticalClearingconditionsThesituationclearswhentheconditionbecomesfalse.
KSE_Physical_Memory_High_WarnsituationDescriptionThephysicalmemorythatthemysqldprocessusedisgreaterthanthewarningthresholdof600MB.
ThesituationisevaluatedforeachdistinctvalueoftheMemoryattribute.
Formula*IF*VALUEKSE_DB_MEMORY.
Memory*GT600*AND*VALUEKSE_DB_MEMORY.
Memory*LE1024See"Attributesineachattributegroup"onpage8fordescriptionsoftheattributesinthisformula.
DistributionThissituationisautomaticallydistributedtoinstancesofthisagent.
RunatstartupYesSamplinginterval5minutesSituationpersistenceThenumberoftimestheconditionspecifiedbythesituationmustoccurforthesituationtobetrueis1.
ErrorconditionsWarningClearingconditionsThesituationclearswhentheconditionbecomesfalse.
TablesnavigatoritemNopredefinedsituationsareincludedforthisnavigatoritem.
58IBMTivoliCompositeApplicationManagerAgentforMySQL:MySQLagentReferenceChapter4.
TakeActioncommandsTakeActioncommandscanberunfromtheportalclientorincludedinasituationorapolicy.
AboutTakeActioncommandsWhenincludedinasituation,thecommandrunswhenthesituationbecomestrue.
ATakeActioncommandinasituationisalsoreferredtoasreflexautomation.
WhenyouenableaTakeActioncommandinasituation,youautomatearesponsetosystemconditions.
Forexample,youcanuseaTakeActioncommandtosendacommandtorestartaprocessonthemanagedsystemortosendatextmessagetoacellphone.
Inadvancedautomation,policiesareusedtotakeactions,schedulework,andautomatemanualtasks.
Apolicycomprisesaseriesofautomatedstepscalledactivitiesthatareconnectedtocreateaworkflow.
Afteranactivityiscompleted,theTivoliEnterprisePortalreceivesreturn-codefeedback,andadvancedautomationlogicrespondswithsubsequentactivitiesthatareprescribedbythefeedback.
AbasicTakeActioncommandshowsthereturncodeoftheoperationinamessageboxthatisdisplayedaftertheactioniscompletedorinalogfile.
Afteryouclosethiswindow,nofurtherinformationisavailableforthisaction.
AdditionalinformationaboutTakeActioncommandsFormoreinformationaboutworkingwithTakeActioncommands,see"TakeActioncommands"intheTivoliEnterprisePortalUser'sGuide.
PredefinedTakeActioncommandsNotallagentshavepredefinedTakeActioncommands.
ButyoucancreateTakeActioncommandsforanyagent.
CopyrightIBMCorp.
2016,20205960IBMTivoliCompositeApplicationManagerAgentforMySQL:MySQLagentReferenceChapter5.
PoliciesPoliciesareusedasanadvancedautomationtechniqueforimplementingmorecomplexworkflowstrategiesthanyoucancreatethroughsimpleautomation.
Allagentsdonotprovidepredefinedpolicies,butyoucancreatepoliciesforanyagent.
Apolicyisasetofautomatedsystemprocessesthatcantakeactions,scheduleworkforusers,orautomatemanualtasks.
YouusetheWorkflowEditortodesignpolicies.
Youcontroltheorderinwhichthepolicyexecutesaseriesofautomatedsteps,whicharealsocalledactivities.
Policiesareconnectedtocreateaworkflow.
Afteranactivityiscompleted,theTivoliEnterprisePortalreceivesreturn-codefeedback,andadvancedautomationlogicrespondswithsubsequentactivitiesprescribedbythefeedback.
Formoreinformationaboutworkingwithpolicies,see"Automationwithpolicies"intheTivoliEnterprisePortalUser'sGuide.
ForinformationaboutusingtheWorkflowEditor,seetheIBMTivoliMonitoringAdministrator'sGuideortheTivoliEnterprisePortalonlinehelp.
PredefinedpoliciesNotallagentshavepredefinedpolicies.
Butyoucancreatepoliciesforanyagent.
TheIBMTivoliCompositeApplicationManagerAgentforMySQLdoesnotprovidepredefinedpolicies.
CopyrightIBMCorp.
2016,20206162IBMTivoliCompositeApplicationManagerAgentforMySQL:MySQLagentReferenceChapter6.
EventmappingTheTivoliEventIntegrationFacility(EIF)interfaceisusedtoforwardsituationeventstoTivoliNetcool/OMNIbusorTivoliEnterpriseConsole.
EIFeventsspecifyaneventclass,andtheeventdataisspecifiedasname-valuepairsthatidentifythenameofaneventslotandthevaluefortheslot.
Aneventclasscanhavesubclasses.
IBMTivoliMonitoringprovidesthebaseeventclassdefinitionsandasetofbaseslotsthatareincludedinallmonitoringevents.
Agentsextendthebaseeventclassestodefinesubclassesthatincludeagent-specificslots.
ForMySQLagentevents,theeventclassescorrespondtotheagentattributegroups,andtheagent-specificslotscorrespondtotheattributesintheattributegroup.
ThesituationeditorintheTivoliEnterprisePortalcanbeusedtoperformcustommappingofdatatoEIFslotsinsteadofusingthedefaultmappingdescribedinthistopic.
FormoreinformationaboutEIFslotcustomization,seetheTivoliEnterprisePortalUser'sGuide.
TivoliEnterpriseConsolerequiresthateventclassesandtheirslotsaredefinedinBAROC(BasicRecorderofObjectsinC)files.
EachagentprovidesaBAROCfilethatcontainseventclassdefinitionsfortheagentandisinstalledontheTivoliEnterpriseMonitoringServerintheTECLIBdirectory(install_dir/cms/TECLIBforWindowssystemsandinstall_dir/tables/TEMS_hostname/TECLIBforUNIXsystems)whenapplicationsupportfortheagentisinstalled.
TheBAROCfilefortheagentandthebaseBAROCfilesprovidedwithTivoliMonitoringmustalsobeinstalledontotheTivoliEnterpriseConsole.
Fordetails,see"SettingupeventforwardingtoTivoliEnterpriseConsole"intheIBMTivoliMonitoringInstallationandSetupGuide.
EachoftheeventclassesisachildofKSE_Baseandisdefinedinthekse.
baroc(version7.
2.
1.
2)file.
TheKSE_BaseeventclasscanbeusedforgenericrulesprocessingforanyeventfromtheIBMTivoliCompositeApplicationManagerAgentforMySQL.
ForeventsthataregeneratedbysituationsintheAgentConfigattributegroup,eventsaresentbyusingtheITM_KSE_AGENT_CONFIGeventclass.
Thiseventclasscontainsthefollowingslots:instance_name:STRINGip_address:STRINGnode:STRINGport:REALport_enum:STRINGtimestamp:STRINGForeventsthataregeneratedbysituationsintheApplicationAvailabilityattributegroup,eventsaresentbyusingtheITM_KSE_APPLICATION_AVAILABILITYeventclass.
Thiseventclasscontainsthefollowingslots:kse_status:STRINGnode:STRINGtimestamp:STRINGForeventsthataregeneratedbysituationsintheAvailabilityattributegroup,eventsaresentbyusingtheITM_KSE_AVAILABILITYeventclass.
Thiseventclasscontainsthefollowingslots:application_component:STRINGcommand_line:STRINGcommand_line_enum:STRINGfull_name:STRINGfull_name_enum:STRINGCopyrightIBMCorp.
2016,202063functionality_test_message:STRINGfunctionality_test_message_enum:STRINGfunctionality_test_status:INTEGERfunctionality_test_status_enum:STRINGkse_status:INTEGERkse_status_enum:STRINGname:STRINGname_enum:STRINGnode:STRINGpage_faults_per_sec:INTEGERpercent_privileged_time:INTEGERpercent_processor_time:INTEGERpercent_user_mode_time:INTEGERpid:INTEGERthread_count:INTEGERtimestamp:STRINGtype:INTEGERtype_enum:STRINGvirtual_size:INTEGERworking_set_size:INTEGERForeventsthataregeneratedbysituationsintheBufferPoolSizeattributegroup,eventsaresentbyusingtheITM_KSE_BUFFERPOOLSIZEeventclass.
Thiseventclasscontainsthefollowingslots:datalength:REALdatalength_enum:STRINGindexlength:REALindexlength_enum:STRINGinstance_name:STRINGip_address:STRINGnode:STRINGnumberoftables:REALnumberoftables_enum:STRINGport:REALport_enum:STRINGtableschema:STRINGtimestamp:STRINGtotallength:REALtotallength_enum:STRINGForeventsthataregeneratedbysituationsintheDbCPUattributegroup,eventsaresentbyusingtheITM_KSE_DB_CPUeventclass.
Thiseventclasscontainsthefollowingslots:64IBMTivoliCompositeApplicationManagerAgentforMySQL:MySQLagentReferencecpu_value:REALcpu_value_enum:STRINGnode:STRINGtimestamp:STRINGForeventsthataregeneratedbysituationsintheDbMemoryattributegroup,eventsaresentbyusingtheITM_KSE_DB_MEMORYeventclass.
Thiseventclasscontainsthefollowingslots:memory:REALmemory_enum:STRINGnode:STRINGtimestamp:STRINGForeventsthataregeneratedbysituationsintheErrorInfoattributegroup,eventsaresentbyusingtheITM_KSE_ERRORINFOeventclass.
Thiseventclasscontainsthefollowingslots:countaddrinfopermanenterrors:INTEGERcountaddrinfopermanenterrors_enum:STRINGcountaddrinfotransienterrors:INTEGERcountaddrinfotransienterrors_enum:STRINGcountauthenticationerrors:INTEGERcountauthenticationerrors_enum:STRINGcountauthpluginerrors:INTEGERcountauthpluginerrors_enum:STRINGcountdefaultdatabaseerrors:INTEGERcountdefaultdatabaseerrors_enum:STRINGcountfcrdnserrors:INTEGERcountfcrdnserrors_enum:STRINGcountformaterrors:INTEGERcountformaterrors_enum:STRINGcounthandshakeerrors:INTEGERcounthandshakeerrors_enum:STRINGcounthostaclerrors:INTEGERcounthostaclerrors_enum:STRINGcounthostblockederrors:INTEGERcounthostblockederrors_enum:STRINGcountinitconnecterrors:INTEGERcountinitconnecterrors_enum:STRINGcountlocalerrors:INTEGERcountlocalerrors_enum:STRINGcountmaxuserconnectionserrors:INTEGERcountmaxuserconnectionserrors_enum:STRINGcountmaxuserconnectionsperhourerrors:INTEGERChapter6.
Eventmapping65countmaxuserconnectionsperhourerrors_enum:STRINGcountnameinfopermanenterrors:INTEGERcountnameinfopermanenterrors_enum:STRINGcountnameinfotransienterrors:INTEGERcountnameinfotransienterrors_enum:STRINGcountnoauthpluginerrors:INTEGERcountnoauthpluginerrors_enum:STRINGcountproxyuseraclerrors:INTEGERcountproxyuseraclerrors_enum:STRINGcountproxyusererrors:INTEGERcountproxyusererrors_enum:STRINGcountsslerrors:INTEGERcountsslerrors_enum:STRINGcountunknownerrors:INTEGERcountunknownerrors_enum:STRINGfirsterrorseen:STRINGfirstseen:STRINGhost:STRINGhostvalidated:STRINGip:STRINGlasterrorseen:STRINGlastseen:STRINGnode:STRINGsumconnecterrors:INTEGERsumconnecterrors_enum:STRINGtimestamp:STRINGForeventsthataregeneratedbysituationsintheEVENTSattributegroup,eventsaresentbyusingtheITM_KSE_EVENTSeventclass.
Thiseventclasscontainsthefollowingslots:character_set_client:STRINGcollation_connection:STRINGcreated:STRINGdatabase_collation:STRINGdefiner:STRINGends:STRINGevent_body:STRINGevent_catalog:STRINGevent_comment:STRINGevent_definition:STRINGevent_name:STRING66IBMTivoliCompositeApplicationManagerAgentforMySQL:MySQLagentReferenceevent_schema:STRINGevent_type:STRINGexecute_at:STRINGinterval_field:STRINGinterval_value:STRINGkse_status:STRINGlast_altered:STRINGlast_executed:STRINGnode:STRINGon_completion:STRINGoriginator:REALoriginator_enum:STRINGsql_mode:STRINGstarts:STRINGtimestamp:STRINGtime_zone:STRINGForeventsthataregeneratedbysituationsintheFILESattributegroup,eventsaresentbyusingtheITM_KSE_FILESeventclass.
Thiseventclasscontainsthefollowingslots:file_name:STRINGnode:STRINGtablespace_name:STRINGtimestamp:STRINGForeventsthataregeneratedbysituationsintheGLOBALSTATUSattributegroup,eventsaresentbyusingtheITM_KSE_GLOBAL_STATUSeventclass.
Thiseventclasscontainsthefollowingslots:node:STRINGtimestamp:STRINGvariable_name:STRINGvariable_value:STRINGvariable_value_as_integer:REALvariable_value_as_integer_enum:STRINGForeventsthataregeneratedbysituationsintheGLOBALVARIABLESattributegroup,eventsaresentbyusingtheITM_KSE_GLOBAL_VARIABLESeventclass.
Thiseventclasscontainsthefollowingslots:node:STRINGtimestamp:STRINGvariable_name:STRINGvariable_value:STRINGvariable_value_as_integer:REALvariable_value_as_integer_enum:STRINGForeventsthataregeneratedbysituationsintheGlobalStatusInfoattributegroup,eventsaresentbyusingtheITM_KSE_GLOBALSTATUSINFOeventclass.
Thiseventclasscontainsthefollowingslots:Chapter6.
Eventmapping67bytesreceived:REALbytesreceived_enum:STRINGbytessent:REALbytessent_enum:STRINGnode:STRINGtimestamp:STRINGuptimedays:INTEGERuptimedays_enum:STRINGForeventsthataregeneratedbysituationsintheINNODBLOCKWAITSattributegroup,eventsaresentbyusingtheITM_KSE_INNODB_LOCK_WAITSeventclass.
Thiseventclasscontainsthefollowingslots:blocking_lock_id:STRINGblocking_trx_id:STRINGnode:STRINGrequested_lock_id:STRINGrequesting_trx_id:STRINGtimestamp:STRINGForeventsthataregeneratedbysituationsintheInnodbBufferPoolPagesattributegroup,eventsaresentbyusingtheITM_KSE_INNODBBUFFERPOOLPAGESeventclass.
Thiseventclasscontainsthefollowingslots:innodbbufferpoolpagesdata:REALinnodbbufferpoolpagesdata_enum:STRINGinnodbbufferpoolpagesfree:REALinnodbbufferpoolpagesfree_enum:STRINGinnodbbufferpoolpagesmisc:REALinnodbbufferpoolpagesmisc_enum:STRINGinnodbbufferpoolpagestotal:REALinnodbbufferpoolpagestotal_enum:STRINGnode:STRINGtimestamp:STRINGForeventsthataregeneratedbysituationsintheLockInfoattributegroup,eventsaresentbyusingtheITM_KSE_LOCKINFOeventclass.
Thiseventclasscontainsthefollowingslots:lockwaitcount:INTEGERlockwaitcount_enum:STRINGnode:STRINGtimestamp:STRINGForeventsthataregeneratedbysituationsinthePARTITIONSattributegroup,eventsaresentbyusingtheITM_KSE_PARTITIONSeventclass.
Thiseventclasscontainsthefollowingslots:avg_row_length:REALavg_row_length_enum:STRINGchecksum:INTEGER68IBMTivoliCompositeApplicationManagerAgentforMySQL:MySQLagentReferencechecksum_enum:STRINGcheck_time:STRINGcreate_time:STRINGdata_free:REALdata_free_enum:STRINGdata_length:REALdata_length_enum:STRINGindex_length:REALindex_length_enum:STRINGmax_data_length:INTEGERmax_data_length_enum:STRINGnode:STRINGnodegroup:STRINGpartition_comment:STRINGpartition_description:STRINGpartition_expression:STRINGpartition_method:STRINGpartition_name:STRINGpartition_ordinal_position:INTEGERpartition_ordinal_position_enum:STRINGsubpartition_expression:STRINGsubpartition_method:STRINGsubpartition_name:STRINGsubpartition_ordinal_position:INTEGERsubpartition_ordinal_position_enum:STRINGtablespace_name:STRINGtable_catalog:STRINGtable_name:STRINGtable_rows:INTEGERtable_rows_enum:STRINGtable_schema:STRINGtimestamp:STRINGupdate_time:STRINGForeventsthataregeneratedbysituationsinthePerformanceObjectStatusattributegroup,eventsaresentbyusingtheITM_KSE_PERFORMANCE_OBJECT_STATUSeventclass.
Thiseventclasscontainsthefollowingslots:average_collection_duration:REALaverage_collection_duration_enum:STRINGcache_hits:INTEGERChapter6.
Eventmapping69cache_hit_percent:REALcache_misses:INTEGERerror_code:INTEGERerror_code_enum:STRINGintervals_skipped:INTEGERlast_collection_duration:REALlast_collection_finished:STRINGlast_collection_finished_enum:STRINGlast_collection_start:STRINGlast_collection_start_enum:STRINGnode:STRINGnumber_of_collections:INTEGERobject_name:STRINGobject_status:INTEGERobject_status_enum:STRINGobject_type:INTEGERobject_type_enum:STRINGquery_name:STRINGrefresh_interval:INTEGERtimestamp:STRINGForeventsthataregeneratedbysituationsinthePLUGINSattributegroup,eventsaresentbyusingtheITM_KSE_PLUGINSeventclass.
Thiseventclasscontainsthefollowingslots:load_option:STRINGnode:STRINGplugin_author:STRINGplugin_description:STRINGplugin_library:STRINGplugin_library_version:STRINGplugin_license:STRINGplugin_name:STRINGplugin_status:STRINGplugin_type:STRINGplugin_type_version:STRINGplugin_version:STRINGtimestamp:STRINGForeventsthataregeneratedbysituationsinthePROCESSLISTattributegroup,eventsaresentbyusingtheITM_KSE_PROCESSLISTeventclass.
Thiseventclasscontainsthefollowingslots:command:STRINGdb:STRING70IBMTivoliCompositeApplicationManagerAgentforMySQL:MySQLagentReferencehost:STRINGid:REALid_enum:STRINGkse_info:STRINGnode:STRINGstate:STRINGtime:REALtimestamp:STRINGtime_enum:STRINGuser:STRINGForeventsthataregeneratedbysituationsintheRowOperationsattributegroup,eventsaresentbyusingtheITM_KSE_ROWOPERATIONSeventclass.
Thiseventclasscontainsthefollowingslots:node:STRINGrowsdeleted:REALrowsdeleted_enum:STRINGrowsinserted:REALrowsinserted_enum:STRINGrowsread:REALrowsread_enum:STRINGrowsupdated:REALrowsupdated_enum:STRINGsystemrowsdeleted:REALsystemrowsdeleted_enum:STRINGsystemrowsinserted:REALsystemrowsinserted_enum:STRINGsystemrowsread:REALsystemrowsread_enum:STRINGsystemrowsupdated:REALsystemrowsupdated_enum:STRINGtimestamp:STRINGForeventsthataregeneratedbysituationsintheSCHEMATAattributegroup,eventsaresentbyusingtheITM_KSE_SCHEMATAeventclass.
Thiseventclasscontainsthefollowingslots:catalog_name:STRINGdefault_character_set_name:STRINGdefault_collation_name:STRINGnode:STRINGschema_name:STRINGsql_path:STRINGtimestamp:STRINGChapter6.
Eventmapping71ForeventsthataregeneratedbysituationsintheSESSIONSTATUSattributegroup,eventsaresentbyusingtheITM_KSE_SESSION_STATUSeventclass.
Thiseventclasscontainsthefollowingslots:node:STRINGtimestamp:STRINGvariable_name:STRINGvariable_value:STRINGForeventsthataregeneratedbysituationsintheSTATISTICSattributegroup,eventsaresentbyusingtheITM_KSE_STATISTICSeventclass.
Thiseventclasscontainsthefollowingslots:cardinality:INTEGERcardinality_enum:STRINGcollation:STRINGcolumn_name:STRINGcomment:STRINGindex_name:STRINGindex_schema:STRINGindex_type:STRINGnode:STRINGnon_unique:INTEGERnon_unique_enum:STRINGnullable:STRINGpacked:STRINGseq_in_index:REALseq_in_index_enum:STRINGsub_part:INTEGERsub_part_enum:STRINGtable_catalog:STRINGtable_name:STRINGtable_schema:STRINGtimestamp:STRINGForeventsthataregeneratedbysituationsintheStatusattributegroup,eventsaresentbyusingtheITM_KSE_STATUSeventclass.
Thiseventclasscontainsthefollowingslots:cache_miss_rate_percent:REALcache_miss_rate_percent_enum:STRINGfull_table_scans_percent:REALfull_table_scans_percent_enum:STRINGkey_reads_per_sec:REALkey_reads_per_sec_enum:STRINGkey_read_requests_per_sec:REALkey_read_requests_per_sec_enum:STRINGmax_connections:REAL72IBMTivoliCompositeApplicationManagerAgentforMySQL:MySQLagentReferencemax_connections_enum:STRINGnode:STRINGopen_tables:REALopen_tables_enum:STRINGqueries:REALqueries_enum:STRINGqueries_per_sec:REALqueries_per_sec_enum:STRINGread_requests_first_per_sec:REALread_requests_first_per_sec_enum:STRINGread_requests_key_per_sec:REALread_requests_key_per_sec_enum:STRINGread_requests_next_per_sec:REALread_requests_next_per_sec_enum:STRINGread_requests_previous_per_sec:REALread_requests_previous_per_sec_enum:STRINGread_requests_rnd_next_per_sec:REALread_requests_rnd_next_per_sec_enum:STRINGread_requests_rnd_per_sec:REALread_requests_rnd_per_sec_enum:STRINGserver_connections_used_percent:REALserver_connections_used_percent_enum:STRINGslow_queries:REALslow_queries_enum:STRINGslow_queries_percent:REALslow_queries_percent_enum:STRINGslow_queries_per_sec:REALslow_queries_per_sec_enum:STRINGtable_cache_percent_used:REALtable_cache_percent_used_enum:STRINGtable_open_cache:REALtable_open_cache_enum:STRINGtemporary_disk_tables_created_per_sec:REALtemporary_disk_tables_created_per_sec_enum:STRINGtemporary_tables_created_per_sec:REALtemporary_tables_created_per_sec_enum:STRINGtemporary_tables_on_disk_percent:REALtemporary_tables_on_disk_percent_enum:STRINGthreads_connected:REALChapter6.
Eventmapping73threads_connected_enum:STRINGtimestamp:STRINGForeventsthataregeneratedbysituationsintheTABLESattributegroup,eventsaresentbyusingtheITM_KSE_TABLESeventclass.
Thiseventclasscontainsthefollowingslots:auto_increment:INTEGERauto_increment_enum:STRINGavg_row_length:INTEGERavg_row_length_enum:STRINGchecksum:INTEGERchecksum_enum:STRINGcheck_time:STRINGcreate_options:STRINGcreate_time:STRINGdata_free:INTEGERdata_free_enum:STRINGdata_length:INTEGERdata_length_enum:STRINGengine:STRINGindex_length:INTEGERindex_length_enum:STRINGmax_data_length:INTEGERmax_data_length_enum:STRINGnode:STRINGrow_format:STRINGtable_catalog:STRINGtable_collation:STRINGtable_comment:STRINGtable_name:STRINGtable_rows:INTEGERtable_rows_enum:STRINGtable_schema:STRINGtable_type:STRINGtimestamp:STRINGupdate_time:STRINGversion:INTEGERversion_enum:STRINGForeventsthataregeneratedbysituationsintheTakeActionStatusattributegroup,eventsaresentbyusingtheITM_KSE_TAKE_ACTION_STATUSeventclass.
Thiseventclasscontainsthefollowingslots:action_app_return_code:INTEGER74IBMTivoliCompositeApplicationManagerAgentforMySQL:MySQLagentReferenceaction_command:STRINGaction_id:INTEGERaction_instance:STRINGaction_message:STRINGaction_name:STRINGaction_node:STRINGaction_owner:STRINGaction_results:STRINGaction_status:INTEGERaction_status_enum:STRINGaction_subnode:STRINGaction_type:INTEGERaction_type_enum:STRINGnode:STRINGtimestamp:STRINGForeventsthataregeneratedbysituationsintheThreadPoolStatusattributegroup,eventsaresentbyusingtheITM_KSE_THREAD_POOL_STATUSeventclass.
Thiseventclasscontainsthefollowingslots:node:STRINGthread_pool_active_threads:INTEGERthread_pool_active_threads_enum:STRINGthread_pool_avg_active_threads:REALthread_pool_avg_active_threads_enum:STRINGthread_pool_avg_job_wait:REALthread_pool_avg_job_wait_enum:STRINGthread_pool_avg_queue_length:REALthread_pool_avg_queue_length_enum:STRINGthread_pool_max_active_threads:INTEGERthread_pool_max_active_threads_enum:STRINGthread_pool_max_queue_length:INTEGERthread_pool_max_queue_length_enum:STRINGthread_pool_max_size:INTEGERthread_pool_max_size_enum:STRINGthread_pool_min_active_threads:INTEGERthread_pool_min_active_threads_enum:STRINGthread_pool_min_queue_length:INTEGERthread_pool_min_queue_length_enum:STRINGthread_pool_queue_length:INTEGERthread_pool_queue_length_enum:STRINGthread_pool_size:INTEGERChapter6.
Eventmapping75thread_pool_size_enum:STRINGthread_pool_total_jobs:INTEGERthread_pool_total_jobs_enum:STRINGtimestamp:STRINGForeventsthataregeneratedbysituationsintheUSERPRIVILEGESattributegroup,eventsaresentbyusingtheITM_KSE_USER_PRIVILEGESeventclass.
Thiseventclasscontainsthefollowingslots:grantee:STRINGis_grantable:STRINGnode:STRINGprivilege_type:STRINGtable_catalog:STRINGtimestamp:STRINGForeventsthataregeneratedbysituationsintheUsersattributegroup,eventsaresentbyusingtheITM_KSE_USERSeventclass.
Thiseventclasscontainsthefollowingslots:currentconnections:INTEGERcurrentconnections_enum:STRINGnode:STRINGtimestamp:STRINGtotalconnections:INTEGERtotalconnections_enum:STRINGuser:STRING76IBMTivoliCompositeApplicationManagerAgentforMySQL:MySQLagentReferenceAppendixA.
DocumentationlibraryAvarietyofdocumentationisavailableforinserttheshortproductnamefromthelist.
IBMKnowledgeCentercontainstopicsofinformationfortheproductandlinkstorelevantPDFs.
InIBMKnowledgeCenter,youcancreateacustomPDFthatcontainsonlythetopicsinwhichyouareinterested.
SeethedirectionsforCreatingyourownsetoftopics(http://www.
ibm.
com/support/knowledgecenter/doc/kc_help.
html#create).
PrerequisitedocumentationTousetheinformationaboutthecomponentseffectively,youmusthavesomeprerequisiteknowledge.
ThefollowinginformationforTivoliMonitoringisavailableintheIBMKnowledgeCenter(http://www.
ibm.
com/support/knowledgecenter)togainprerequisiteknowledge:IBMTivoliMonitoringAdministrator'sGuideIBMTivoliMonitoringInstallationandSetupGuideIBMTivoliMonitoringHighAvailabilityGuideforDistributedSystemsIBMTivoliMonitoring:InstallationandConfigurationGuidesforthefollowingagents:OperatingSystemagentsandWarehouseagentsIBMTivoliMonitoring:User'sGuidesforthefollowingagents:AgentlessOSmonitors,LogFileagent,Systempagents,SystemsDirectorbaseagentIBMTivoliMonitoringAgentBuilderUser'sGuideIBMTivoliMonitoringCommandReferenceIBMTivoliMonitoring:MessagesIBMTivoliMonitoringTroubleshootingGuideIBMTivoliMonitoring:Referencesforthefollowingagents:OperatingSystemagentsandWarehouseagentsIBMTivoliMonitoring:TroubleshootingGuidesforthefollowingagents:OperatingSystemagentsandWarehouseagentsTivoliEnterprisePortalUser'sGuideRelateddocumentationThedocumentationforrelatedproductsprovidesusefulinformation.
SeethefollowingproductsinIBMKnowledgeCenter(http://www.
ibm.
com/support/knowledgecenter/):TivoliMonitoringTivoliApplicationDependencyDiscoveryManagerTivoliBusinessServiceManagerTivoliCommonReportingTivoliEnterpriseConsoleTivoliNetcool/OMNIbusTerminologythatisrelevanttoIBMproductsisconsolidatedinoneconvenientlocationsattheIBMTerminologywebsite(http://www.
ibm.
com/software/globalization/terminology).
CopyrightIBMCorp.
2016,202077TivoliMonitoringCommunityonServiceManagementConnectServiceManagementConnect(SMC)isarepositoryoftechnicalinformationthatisorganizedbycommunities.
AccessServiceManagementConnectathttps://www.
ibm.
com/developerworks/servicemanagement.
ForinformationaboutTivoliproducts,seetheApplicationPerformanceManagementcommunity(http://www.
ibm.
com/developerworks/servicemanagement/apm/index.
html).
Connect,learn,andsharewithServiceManagementprofessionals.
Getaccesstodevelopersandproductsupporttechnicalexpertswhoprovidetheirperspectivesandexpertise.
YoucanuseSMCforthesepurposes:Becomeinvolvedwithtransparentdevelopment,anongoing,openengagementbetweenotherusersandIBMdevelopersofTivoliproducts.
Youcanaccessearlydesigns,sprintdemonstrations,productroadmaps,andprereleasecode.
Connectone-on-onewiththeexpertstocollaborateandnetworkaboutTivoliandtheApplicationPerformanceManagementcommunity.
Readblogstobenefitfromtheexpertiseandexperienceofothers.
Usewikisandforumstocollaboratewiththebroaderusercommunity.
OthersourcesofdocumentationYoucanobtainadditionaltechnicaldocumentationaboutmonitoringproductsfromothersources.
Seethefollowingsourcesoftechnicaldocumentationaboutmonitoringproducts:IBMIntegratedServiceManagementLibrary(http://www.
ibm.
com/software/brandcatalog/ismlibrary/)isanonlinecatalogthatcontainsintegrationdocumentationaswellasotherdownloadableproductextensions.
IBMRedbookpublications(http://www.
redbooks.
ibm.
com/)includeRedbookspublications,Redpapers,andRedbookstechnotesthatprovideinformationaboutproductsfromplatformandsolutionperspectives.
Technotes(http://www.
ibm.
com/support/entry/portal/software),whicharefoundthroughtheIBMSoftwareSupportwebsite,providethelatestinformationaboutknownproductlimitationsandworkarounds.
ConventionsusedinthedocumentationSeveralconventionsareusedinthedocumentationforspecialterms,actions,commands,andpathsthataredependentonyouroperatingsystem.
TypefaceconventionsThefollowingtypefaceconventionsareusedinthedocumentation:BoldLowercasecommands,mixed-casecommands,parameters,andenvironmentvariablesthatareotherwisedifficulttodistinguishfromthesurroundingtextInterfacecontrols(checkboxes,pushbuttons,radiobuttons,spinbuttons,fields,folders,icons,listboxes,itemsinsidelistboxes,multicolumnlists,containers,menuchoices,menunames,tabs,propertysheets),labels(suchasTip:)Keywordsandparametersintext78IBMTivoliCompositeApplicationManagerAgentforMySQL:MySQLagentReferenceItalicCitations(examples:titlesofpublications,CDs,andDVDs)Wordsandphrasesdefinedintext(example:anonswitchedlineiscalledapoint-to-pointline)Emphasisofwordsandletters(example:TheLUNaddressmuststartwiththeletterL.
)Newtermsintext,exceptinadefinitionlist(example:aviewisaframeinaworkspacethatcontainsdata.
)Variablesandvaluesyoumustprovide(example:wheremynamerepresents…)MonospaceExamplesandcodeexamplesFilenames,directorynames,pathnames,programmingkeywords,properties,andotherelementsthataredifficulttodistinguishfromthesurroundingtextMessagetextandpromptsTextthatyoumusttypeValuesforargumentsorcommandoptionsBoldmonospaceCommandnames,andnamesofmacrosandutilitiesthatyoucantypeascommandsEnvironmentvariablenamesintextKeywordsParameternamesintext:APIstructureparameters,commandparametersandarguments,andconfigurationparametersProcessnamesRegistryvariablenamesintextScriptnamesOperatingsystem-dependentvariablesandpathsThedirectionoftheslashfordirectorypathsmightvaryinthedocumentation.
Regardlessofwhatyouseeinthedocumentation,followtheseguidelines:ForUNIXorLinux,useaforwardslash(/).
ForWindows,useabackslash(\).
ThenamesofenvironmentvariablesarenotalwaysthesameinWindowsandUNIX.
Forexample,%TEMP%inWindowsisequivalentto$TMPDIRinUNIXorLinux.
Forenvironmentvariables,followtheseguidelines:ForUNIXorLinux,use$variable.
ForWindows,use%variable%.
IfyouareusingthebashshellonaWindowssystem,youcanusetheUNIXconventions.
AppendixA.
Documentationlibrary7980IBMTivoliCompositeApplicationManagerAgentforMySQL:MySQLagentReferenceNoticesThisinformationwasdevelopedforproductsandservicesofferedintheU.
S.
A.
IBMmaynotoffertheproducts,services,orfeaturesdiscussedinthisdocumentinothercountries.
ConsultyourlocalIBMrepresentativeforinformationontheproductsandservicescurrentlyavailableinyourarea.
AnyreferencetoanIBMproduct,program,orserviceisnotintendedtostateorimplythatonlythatIBMproduct,program,orservicemaybeused.
Anyfunctionallyequivalentproduct,program,orservicethatdoesnotinfringeanyIBMintellectualpropertyrightmaybeusedinstead.
However,itistheuser'sresponsibilitytoevaluateandverifytheoperationofanynon-IBMproduct,program,orservice.
IBMmayhavepatentsorpendingpatentapplicationscoveringsubjectmatterdescribedinthisdocument.
Thefurnishingofthisdocumentdoesnotgiveyouanylicensetothesepatents.
Youcansendlicenseinquiries,inwriting,to:IBMDirectorofLicensingIBMCorporationNorthCastleDriveArmonk,NY10504-1785U.
S.
A.
Forlicenseinquiriesregardingdouble-byte(DBCS)information,contacttheIBMIntellectualPropertyDepartmentinyourcountryorsendinquiries,inwriting,to:IntellectualPropertyLicensingLegalandIntellectualPropertyLawIBMJapanLtd.
19-21,Nihonbashi-Hakozakicho,Chuo-kuTokyo103-8510,JapanThefollowingparagraphdoesnotapplytotheUnitedKingdomoranyothercountrywheresuchprovisionsareinconsistentwithlocallaw:INTERNATIONALBUSINESSMACHINESCORPORATIONPROVIDESTHISPUBLICATION"ASIS"WITHOUTWARRANTYOFANYKIND,EITHEREXPRESSORIMPLIED,INCLUDING,BUTNOTLIMITEDTO,THEIMPLIEDWARRANTIESOFNON-INFRINGEMENT,MERCHANTABILITYORFITNESSFORAPARTICULARPURPOSE.
Somestatesdonotallowdisclaimerofexpressorimpliedwarrantiesincertaintransactions,therefore,thisstatementmightnotapplytoyou.
Thisinformationcouldincludetechnicalinaccuraciesortypographicalerrors.
Changesareperiodicallymadetotheinformationherein;thesechangeswillbeincorporatedinneweditionsofthepublication.
IBMmaymakeimprovementsand/orchangesintheproduct(s)and/ortheprogram(s)describedinthispublicationatanytimewithoutnotice.
Anyreferencesinthisinformationtonon-IBMWebsitesareprovidedforconvenienceonlyanddonotinanymannerserveasanendorsementofthoseWebsites.
ThematerialsatthoseWebsitesarenotpartofthematerialsforthisIBMproductanduseofthoseWebsitesisatyourownrisk.
IBMmayuseordistributeanyoftheinformationyousupplyinanywayitbelievesappropriatewithoutincurringanyobligationtoyou.
Licenseesofthisprogramwhowishtohaveinformationaboutitforthepurposeofenabling:(i)theexchangeofinformationbetweenindependentlycreatedprogramsandotherprograms(includingthisone)and(ii)themutualuseoftheinformationwhichhasbeenexchanged,shouldcontact:IBMCorporation2Z4A/10111400BurnetRoadAustin,TX78758U.
S.
A.
CopyrightIBMCorp.
2016,202081Suchinformationmaybeavailable,subjecttoappropriatetermsandconditions,includinginsomecasespaymentofafee.
ThelicensedprogramdescribedinthisdocumentandalllicensedmaterialavailableforitareprovidedbyIBMundertermsoftheIBMCustomerAgreement,IBMInternationalProgramLicenseAgreementoranyequivalentagreementbetweenus.
Anyperformancedatacontainedhereinwasdeterminedinacontrolledenvironment.
Therefore,theresultsobtainedinotheroperatingenvironmentsmayvarysignificantly.
Somemeasurementsmayhavebeenmadeondevelopment-levelsystemsandthereisnoguaranteethatthesemeasurementswillbethesameongenerallyavailablesystems.
Furthermore,somemeasurementmayhavebeenestimatedthroughextrapolation.
Actualresultsmayvary.
Usersofthisdocumentshouldverifytheapplicabledatafortheirspecificenvironment.
Informationconcerningnon-IBMproductswasobtainedfromthesuppliersofthoseproducts,theirpublishedannouncementsorotherpubliclyavailablesources.
IBMhasnottestedthoseproductsandcannotconfirmtheaccuracyofperformance,compatibilityoranyotherclaimsrelatedtonon-IBMproducts.
Questionsonthecapabilitiesofnon-IBMproductsshouldbeaddressedtothesuppliersofthoseproducts.
AllstatementsregardingIBM'sfuturedirectionorintentaresubjecttochangeorwithdrawalwithoutnotice,andrepresentgoalsandobjectivesonly.
AllIBMpricesshownareIBM'ssuggestedretailprices,arecurrentandaresubjecttochangewithoutnotice.
Dealerpricesmayvary.
Thisinformationisforplanningpurposesonly.
Theinformationhereinissubjecttochangebeforetheproductsdescribedbecomeavailable.
Thisinformationcontainsexamplesofdataandreportsusedindailybusinessoperations.
Toillustratethemascompletelyaspossible,theexamplesincludethenamesofindividuals,companies,brands,andproducts.
Allofthesenamesarefictitiousandanysimilaritytothenamesandaddressesusedbyanactualbusinessenterpriseisentirelycoincidental.
COPYRIGHTLICENSE:Thisinformationcontainssampleapplicationprogramsinsourcelanguage,whichillustrateprogrammingtechniquesonvariousoperatingplatforms.
Youmaycopy,modify,anddistributethesesampleprogramsinanyformwithoutpaymenttoIBM,forthepurposesofdeveloping,using,marketingordistributingapplicationprogramsconformingtotheapplicationprogramminginterfacefortheoperatingplatformforwhichthesampleprogramsarewritten.
Theseexampleshavenotbeenthoroughlytestedunderallconditions.
IBM,therefore,cannotguaranteeorimplyreliability,serviceability,orfunctionoftheseprograms.
Youmaycopy,modify,anddistributethesesampleprogramsinanyformwithoutpaymenttoIBMforthepurposesofdeveloping,using,marketing,ordistributingapplicationprogramsconformingtoIBM'sapplicationprogramminginterfaces.
Eachcopyoranyportionofthesesampleprogramsoranyderivativework,mustincludeacopyrightnoticeasfollows:IBM2009.
PortionsofthiscodearederivedfromIBMCorp.
SamplePrograms.
CopyrightIBMCorp.
2009.
Allrightsreserved.
Ifyouareviewingthisinformationinsoftcopyform,thephotographsandcolorillustrationsmightnotbedisplayed.
TrademarksIBM,theIBMlogo,andibm.
comaretrademarksorregisteredtrademarksofInternationalBusinessMachinesCorp.
,registeredinmanyjurisdictionsworldwide.
OtherproductandservicenamesmightbetrademarksofIBMorothercompanies.
AcurrentlistofIBMtrademarksisavailableonthewebatCopyrightandtrademarkinformation(www.
ibm.
com/legal/copytrade.
shtml).
82IBMTivoliCompositeApplicationManagerAgentforMySQL:MySQLagentReferenceIntel,Intellogo,andIntelXeon,aretrademarksorregisteredtrademarksofIntelCorporationoritssubsidiariesintheUnitedStatesandothercountries.
JavaandallJava-basedtrademarksandlogosaretrademarksorregisteredtrademarksofOracleand/oritsaffiliates.
LinuxisaregisteredtrademarkofLinusTorvaldsintheUnitedStates,othercountries,orboth.
MicrosoftandWindowsaretrademarksofMicrosoftCorporationintheUnitedStates,othercountries,orboth.
UNIXisaregisteredtrademarkofTheOpenGroupintheUnitedStatesandothercountries.
Othercompany,product,orservicenamesmaybetrademarksorservicemarksofothers.
PrivacypolicyconsiderationsIBMSoftwareproducts,includingsoftwareasaservicesolutions,("SoftwareOfferings")mayusecookiesorothertechnologiestocollectproductusageinformation,tohelpimprovetheenduserexperience,totailorinteractionswiththeenduserorforotherpurposes.
InmanycasesnopersonallyidentifiableinformationiscollectedbytheSoftwareOfferings.
SomeofourSoftwareOfferingscanhelpenableyoutocollectpersonallyidentifiableinformation.
IfthisSoftwareOfferingusescookiestocollectpersonallyidentifiableinformation,specificinformationaboutthisoffering'suseofcookiesissetforthbelow.
Dependingupontheconfigurationsdeployed,thisSoftwareOfferingmayusesessioncookiesthatcollecteachuser'susernameforpurposesofsessionmanagement,authentication,andsinglesign-onconfiguration.
Thesecookiescannotbedisabled.
IftheconfigurationsdeployedforthisSoftwareOfferingprovideyouascustomertheabilitytocollectpersonallyidentifiableinformationfromendusersviacookiesandothertechnologies,youshouldseekyourownlegaladviceaboutanylawsapplicabletosuchdatacollection,includinganyrequirementsfornoticeandconsent.
Formoreinformationabouttheuseofvarioustechnologies,includingcookies,forthesepurposes,SeeIBM'sPrivacyPolicyathttp://www.
ibm.
com/privacyandIBM'sOnlinePrivacyStatementathttp://www.
ibm.
com/privacy/detailsthesectionentitled"Cookies,WebBeaconsandOtherTechnologies"andthe"IBMSoftwareProductsandSoftware-as-a-ServicePrivacyStatement"athttp://www.
ibm.
com/software/info/product-privacy.
Notices8384IBMTivoliCompositeApplicationManagerAgentforMySQL:MySQLagentReferenceIndexAActionAppReturnCodeattribute42ActionCommandattribute42ActionIDattribute42ActionInstanceattribute43ActionMessageattribute43ActionNameattribute43ActionNodeattribute43ActionOwnerattribute43ActionResultsattribute43ActionStatusattribute43ActionSubnodeattribute43ActionTypeattribute43activities61additionalinformationattributes5situations49TakeActioncommands59Workspaces1AgentConfigattributegroup8AgentConfigurationworkspace3AgentPerformanceworkspace2ApplicationAvailabilityattributegroup9ApplicationComponentattribute9ApplicationPerformanceManagementcommunityonSMC78attributegroupattributes8attributegroupsAgentConfig8ApplicationAvailability9Availability9BufferPoolSize12DbCPU13DbMemory13ErrorInfo14EVENTS17FILES20GLOBALSTATUS20GLOBALVARIABLES21GlobalStatusInfo22INNODBLOCKWAITS22InnodbBufferPoolPages23listofall6LockInfo24overview5PARTITIONS24PerformanceObjectStatus27PLUGINS30PROCESSLIST31RowOperations32SCHEMATA33SESSIONSTATUS34STATISTICS35Status36TABLES40attributegroups(continued)TakeActionStatus42ThreadPoolStatus44USERPRIVILEGES46Users46attributesActionAppReturnCode42ActionCommand42ActionID42ActionInstance43ActionMessage43ActionName43ActionNode43ActionOwner43ActionResults43ActionStatus43ActionSubnode43ActionType43additionalinformation5AgentConfig8ApplicationAvailability9ApplicationComponent9AutoIncrement40Availability9AverageCollectionDuration27AvgRowLength24,40BlockingLockId22BlockingTrxId22BufferPoolSize12bytesReceived22bytesSent22CacheHitPercent28CacheHits28CacheMissRatePercent37CacheMisses28Cardinality35CatalogName33CharacterSetClient18CheckTime24,40Checksum24,40Collation35CollationConnection18ColumnName35COMMAND31CommandLine10Comment35countAddrInfoPermanentErrors14countAddrInfoTransientErrors14countAuthenticationErrors14countAuthPluginErrors14countDefaultDatabaseErrors14countFCRDNSErrors15countFormatErrors15countHandshakeErrors15countHostAclErrors15countHostBlockedErrors15countInitConnectErrors15Index85attributes(continued)countLocalErrors15countMaxUserConnectionsErrors15countMaxUserConnectionsPerHourErrors15countNameInfoPermanentErrors16countNameInfoTransientErrors16countNoAuthPluginErrors16countProxyUserAclErrors16countProxyUserErrors16countSSLErrors16countUnknownErrors16CPUValue13CreateOptions40CreateTime25,40Created18currentConnections46DataFree25,40DataLength25,40DatabaseCollation18dataLength12DB31DbCPU13DbMemory13DefaultCharacterSetName34DefaultCollationName34Definer18Ends18Engine41ErrorCode28ErrorInfo14EventBody18EventCatalog18EventComment18EventDefination18EventName18EventSchema19EventType19EVENTS17ExecuteAt19FILENAME20FILES20firstErrorSeen16firstSeen17FullName10FullTableScansPercent37FunctionalityTestMessage10FunctionalityTestStatus10GLOBALSTATUS20GLOBALVARIABLES21GlobalStatusInfo22Grantee46host17HOST32hostValidated17ID32IndexLength25,41IndexName35IndexSchema35IndexType35indexLength12INFO32INNODBLOCKWAITS22InnodbBufferPoolPages23innodbBufferPoolPagesData23attributes(continued)innodbBufferPoolPagesFree23innodbBufferPoolPagesMisc23innodbBufferPoolPagesTotal23InstanceName8,12IntervalField19IntervalValue19IntervalsSkipped28IP17IPAddress9,12IsGrantable46KeyReadRequestsPerSec37KeyReadsPerSec37LastAltered19LastCollectionDuration29LastCollectionFinished29LastCollectionStart29LastExecuted19lastErrorSeen17lastSeen17LoadOption30LockInfo24LockWaitCount24MaxConnections37MaxDataLength25,41Memory14Name10Node9,10,12–14,17,19–25,29,30,32,34,35,37,41,43,44,46Nodegroup25NonUnique36Nullable36NumberofCollections29numberOfTables12ObjectName29ObjectStatus29ObjectType29OnCompletion19OpenTables37Originator19overview5Packed36PageFaultsperSec10PartitionComment25PartitionDescription25PartitionExpression25PartitionMethod26PartitionName26PartitionOrdinalPosition26PARTITIONS24PercentPrivilegedTime11PercentProcessorTime11PercentUserModeTime11PerformanceObjectStatus27PID11PluginAuthor30PluginDescription30PluginLibrary30PluginLibraryVersion30PluginLicense31PluginName31PluginStatus31PluginType31PluginTypeVersion3186IBMTivoliCompositeApplicationManagerAgentforMySQL:MySQLagentReferenceattributes(continued)PluginVersion31PLUGINS30Port9,13PrivilegeType46PROCESSLIST31Queries37QueriesPerSec37QueryName30ReadRequestsFirstPerSec38ReadRequestsKeyPerSec38ReadRequestsNextPerSec38ReadRequestsPreviousPerSec38ReadRequestsRndNextPerSec38ReadRequestsRndPerSec38RefreshInterval30RequestedLockId23RequestingTrxId23RowFormat41RowOperations32rowsDeleted32rowsInserted33rowsRead33rowsUpdated33SchemaName34SCHEMATA33SeqInIndex36ServerConnectionsUsedPercent38SESSIONSTATUS34SlowQueries38SlowQueriesPerSec38SlowQueriesPercent39SQLMode19SQLPath34Starts20STATE32STATISTICS35Status9,11,20,36SubPart36SubpartitionExpression26SubpartitionMethod26SubpartitionName26SubpartitionOrdinalPosition26sumConnectErrors17systemRowsDeleted33systemRowsInserted33systemRowsRead33systemRowsUpdated33TableCachePercentUsed39TableCatalog26,36,41,46TableCollation41TableComment41TableName27,36,41TableOpenCache39TableRows27,42TableSchema27,36,42TableType42TABLES40tableSchema13TablespaceName27TABLESPACENAME20TakeActionStatus42TemporaryDiskTablesCreatedPerSec39TemporaryTablesCreatedPerSec39attributes(continued)TemporaryTablesOnDiskPercent39ThreadCount11ThreadPoolActiveThreads44ThreadPoolAvgActiveThreads44ThreadPoolAvgJobWait44ThreadPoolAvgQueueLength44ThreadPoolMaxActiveThreads44ThreadPoolMaxQueueLength45ThreadPoolMaxSize45ThreadPoolMinActiveThreads45ThreadPoolMinQueueLength45ThreadPoolQueueLength45ThreadPoolSize45ThreadPoolStatus44ThreadPoolTotalJobs45ThreadsConnected39TIME32TimeZone20Timestamp9,11,13,14,17,20–24,27,30–34,36,39,42,43,45–47totalConnections47totalLength13Type12UpdateTime27,42uptimeDays22user47USER32USERPRIVILEGES46Users46VariableName21,34VariableValue21,35VariableValueAsInteger21Version42VirtualSize12WorkingSetSize12AutoIncrementattribute40Availabilitysituations51workspacesdescriptions2Availabilityattributegroup9Availabilityworkspace2AverageCollectionDurationattribute27AvgRowLengthattribute24,40BBlockingLockIdattribute22BlockingTrxIdattribute22BufferPoolSizeattributegroup12bytesReceivedattribute22bytesSentattribute22CCacheHitPercentattribute28CacheHitsattribute28CacheMissRatePercentattribute37CacheMissesattribute28calculatehistoricaldatadiskspace47capacityplanningforhistoricaldata47Cardinalityattribute35Index87CatalogNameattribute33CharacterSetClientattribute18CheckTimeattribute24,40Checksumattribute24,40Collationattribute35CollationConnectionattribute18ColumnNameattribute35COMMANDattribute31CommandLineattribute10commandsTakeAction59Commentattribute35Configurationsituations51workspacesdescriptions3conventionsindocumentation78cookies83countAddrInfoPermanentErrorsattribute14countAddrInfoTransientErrorsattribute14countAuthenticationErrorsattribute14countAuthPluginErrorsattribute14countDefaultDatabaseErrorsattribute14countFCRDNSErrorsattribute15countFormatErrorsattribute15countHandshakeErrorsattribute15countHostAclErrorsattribute15countHostBlockedErrorsattribute15countInitConnectErrorsattribute15countLocalErrorsattribute15countMaxUserConnectionsErrorsattribute15countMaxUserConnectionsPerHourErrorsattribute15countNameInfoPermanentErrorsattribute16countNameInfoTransientErrorsattribute16countNoAuthPluginErrorsattribute16countProxyUserAclErrorsattribute16countProxyUserErrorsattribute16countSSLErrorsattribute16countUnknownErrorsattribute16CPUValueattribute13CreateOptionsattribute40createPDF77CreateTimeattribute25,40Createdattribute18currentConnectionsattribute46DDataFreeattribute25,40DataLengthattribute25,40DatabaseCollationattribute18Databasessituations52workspacesdescriptions3dataLengthattribute12DBattribute31DbCPUattributegroup13DbMemoryattributegroup13DefaultCharacterSetNameattribute34DefaultCollationNameattribute34Definerattribute18descriptions50diskcapacityplanningforhistoricaldata47documentationIBMTivoliMonitoring77IntegratedServiceManagementLibrary78prerequisite77Redbooks78related77Technotes78EEndsattribute18Engineattribute41ErrorCodeattribute28ErrorInfoattributegroup14eventmapping63EventBodyattribute18EventCatalogattribute18EventCommentattribute18EventDefinationattribute18EventNameattribute18EventSchemaattribute19EventTypeattribute19eventingthresholds,usingattributes5Eventssituations52workspacesdescriptions3EVENTSattributegroup17Eventsworkspace3ExecuteAtattribute19FFILENAMEattribute20FILESattributegroup20firstErrorSeenattribute16firstSeenattribute17FullNameattribute10FullTableScansPercentattribute37FunctionalityTestMessageattribute10FunctionalityTestStatusattribute10GGLOBALSTATUSattributegroup20GLOBALVARIABLESattributegroup21GlobalStatusInfoattributegroup22Granteeattribute46Hhistoricaldatacalculatediskspace47diskcapacityplanning47hostattribute17HOSTattribute32hostValidatedattribute17IIDattribute32IndexLengthattribute25,4188IBMTivoliCompositeApplicationManagerAgentforMySQL:MySQLagentReferenceIndexNameattribute35IndexSchemaattribute35IndexTypeattribute35indexLengthattribute12INFOattribute32InnoDBsituations52workspacesdescriptions4INNODBLOCKWAITSattributegroup22InnodbBufferPoolPagesattributegroup23innodbBufferPoolPagesDataattribute23innodbBufferPoolPagesFreeattribute23innodbBufferPoolPagesMiscattribute23innodbBufferPoolPagesTotalattribute23InstanceNameattribute8,12IntegratedServiceManagementLibrarydocumentation78IntervalFieldattribute19IntervalValueattribute19IntervalsSkippedattribute28IPAddressattribute9,12IPattribute17IsGrantableattribute46KKeyReadRequestsPerSecattribute37KeyReadsPerSecattribute37KSE_High_CPU_Critsituation52KSE_High_CPU_Warnsituation52KSE_MySQL_Cache_Miss_Rate_Critsituation53KSE_MySQL_Cache_Miss_Rate_Warnsituation53KSE_MySQL_Connections_Used_Critsituation54KSE_MySQL_Connections_Used_Highsituation54KSE_MySQL_Full_Table_Scans_Highsituation55KSE_MySQL_Process_Downsituation51KSE_MySQL_Queries_Slowsituation55KSE_MySQL_Queries_Slow_Warnsituation56KSE_MySQL_Service_Downsituation51KSE_MySQL_Table_Cache_Used_Critsituation56KSE_MySQL_Table_Cache_Used_Warnsituation57KSE_Physical_Memory_High_Critsituation57KSE_Physical_Memory_High_Warnsituation58LLastAlteredattribute19LastCollectionDurationattribute29LastCollectionFinishedattribute29LastCollectionStartattribute29LastExecutedattribute19lastErrorSeenattribute17lastSeenattribute17LoadOptionattribute30LockInfoattributegroup24Locksworkspace4LockWaitCountattribute24MMaxConnectionsattribute37MaxDataLengthattribute25,41Memoryattribute14MySQLsituations51workspacesdescriptions2MySQLworkspace2NNameattribute10Nodeattribute9,10,12–14,17,19–25,29,30,32,34,35,37,41,43,44,46Nodegroupattribute25NonUniqueattribute36Nullableattribute36NumberofCollectionsattribute29numberOfTablesattribute12OObjectNameattribute29ObjectStatusattribute29ObjectTypeattribute29OnCompletionattribute19OpenTablesattribute37Originatorattribute19PPackedattribute36PageFaultsperSecattribute10PartitionCommentattribute25PartitionDescriptionattribute25PartitionExpressionattribute25PartitionMethodattribute26PartitionNameattribute26PartitionOrdinalPositionattribute26PARTITIONSattributegroup24pathconventions78PercentPrivilegedTimeattribute11PercentProcessorTimeattribute11PercentUserModeTimeattribute11PerformanceObjectStatusattributegroup27PIDattribute11PluginAuthorattribute30PluginDescriptionattribute30PluginLibraryattribute30PluginLibraryVersionattribute30PluginLicenseattribute31PluginNameattribute31PluginStatusattribute31PluginTypeattribute31PluginTypeVersionattribute31PluginVersionattribute31PLUGINSattributegroup30policies61Portattribute9,13prerequisitedocumentation77privacypolicy83PrivilegeTypeattribute46PROCESSLISTattributegroup31publicationsServiceManagementConnect78SMC,SeeServiceManagementConnectIndex89publications(continued)SeealsodocumentationQQueriesattribute37QueriesPerSecattribute37queries,usingattributes5QueryNameattribute30RReadRequestsFirstPerSecattribute38ReadRequestsKeyPerSecattribute38ReadRequestsNextPerSecattribute38ReadRequestsPreviousPerSecattribute38ReadRequestsRndNextPerSecattribute38ReadRequestsRndPerSecattribute38Redbooks78RefreshIntervalattribute30RequestedLockIdattribute23RequestingTrxIdattribute23RowFormatattribute41RowOperationsattributegroup32rowsDeletedattribute32rowsInsertedattribute33rowsReadattribute33rowsUpdatedattribute33SSchemaNameattribute34Schemaworkspace3SCHEMATAattributegroup33SeqInIndexattribute36Serversituations52workspacesdescriptions4ServerConnectionsUsedPercentattribute38ServiceManagementConnect78SESSIONSTATUSattributegroup34situationsadditionalinformationpredefined,defined49KSE_High_CPU_Crit52KSE_High_CPU_Warn52KSE_MySQL_Cache_Miss_Rate_Crit53KSE_MySQL_Cache_Miss_Rate_Warn53KSE_MySQL_Connections_Used_Crit54KSE_MySQL_Connections_Used_High54KSE_MySQL_Full_Table_Scans_High55KSE_MySQL_Process_Down51KSE_MySQL_Queries_Slow55KSE_MySQL_Queries_Slow_Warn56KSE_MySQL_Service_Down51KSE_MySQL_Table_Cache_Used_Crit56KSE_MySQL_Table_Cache_Used_Warn57KSE_Physical_Memory_High_Crit57KSE_Physical_Memory_High_Warn58overview49predefined49SituationEditor49situations,usingattributes5SlowQueriesattribute38SlowQueriesPerSecattribute38SlowQueriesPercentattribute39SMC,SeeServiceManagementConnectSQLModeattribute19SQLPathattribute34Startsattribute20STATEattribute32STATISTICSattributegroup35Statisticsworkspace3Statusattribute9,11,20Statusattributegroup36SubPartattribute36SubpartitionExpressionattribute26SubpartitionMethodattribute26SubpartitionNameattribute26SubpartitionOrdinalPositionattribute26sumConnectErrorsattribute17systemRowsDeletedattribute33systemRowsInsertedattribute33systemRowsReadattribute33systemRowsUpdatedattribute33TTableCachePercentUsedattribute39TableCatalogattribute26,36,41,46TableCollationattribute41TableCommentattribute41TableNameattribute27,36,41TableOpenCacheattribute39TableRowsattribute27,42TableSchemaattribute27,36,42TableTypeattribute42Tablessituations58workspacesdescriptions4TABLESattributegroup40Tablesworkspace4tableSchemaattribute13TablespaceNameattribute27TABLESPACENAMEattribute20TakeActioncommandsadditionalinformation59overview59predefined59,61TakeActionStatusattributegroup42Technotes78TemporaryDiskTablesCreatedPerSecattribute39TemporaryTablesCreatedPerSecattribute39TemporaryTablesOnDiskPercentattribute39terms77ThreadCountattribute11ThreadPoolActiveThreadsattribute44ThreadPoolAvgActiveThreadsattribute44ThreadPoolAvgJobWaitattribute44ThreadPoolAvgQueueLengthattribute44ThreadPoolMaxActiveThreadsattribute44ThreadPoolMaxQueueLengthattribute45ThreadPoolMaxSizeattribute45ThreadPoolMinActiveThreadsattribute45ThreadPoolMinQueueLengthattribute4590IBMTivoliCompositeApplicationManagerAgentforMySQL:MySQLagentReferenceThreadPoolQueueLengthattribute45ThreadPoolSizeattribute45ThreadPoolStatusattributegroup44ThreadPoolTotalJobsattribute45ThreadsConnectedattribute39TIMEattribute32TimeZoneattribute20Timestampattribute9,11,13,14,17,20–24,27,30–34,36,39,42,43,45–47TivoliEnterpriseConsoleeventmapping63totalConnectionsattribute47totalLengthattribute13Typeattribute12typefaceconventions78UUpdateTimeattribute27,42uptimeDaysattribute22userattribute47USERattribute32USERPRIVILEGESattributegroup46Usersattributegroup46VVariableNameattribute21,34VariableValueAsIntegerattribute21VariableValueattribute21,35variablesconventions78Versionattribute42viewsAgentConfigurationworkspace3AgentPerformanceworkspace2Availabilityworkspace2Eventsworkspace3Locksworkspace4MySQLworkspace2Schemaworkspace3Statisticsworkspace3Tablesworkspace4VirtualSizeattribute12WWorkflowEditor61WorkingSetSizeattribute12workspacesAgentConfiguration3AgentPerformance2Availability2Configuration3Databases3descriptions2Events3InnoDB4Locks4MySQL2predefined1Schema3Server4Statistics3workspaces(continued)Tables4Workspacesadditionalinformation1overview1Index9192IBMTivoliCompositeApplicationManagerAgentforMySQL:MySQLagentReferenceIBM5724-I45