Sample Data Dictionary

Table INSTANCEINFO_CFG
Desc : Information related to all the instances in the system is stored here.
Columns :
MOTYPEID : Monitor type id. This value is internal and fixed.
MOINSTID : Monitor instance id. This is an unique # generated for each instance. This value is internal and fixed. All statistics data for each instance is identified by this.
DEVICENAME : Name of the device to which this instance is added in the administration console.
INSTANAME : Description of the monitor instance.
SOURCEIP : IP Address of the device from where the statistics data is being collected.
TARGETIP : IP Address of the device on which this instance is running.
CONFIGVALUES : Values of the configuration attributes of the monitor instance in the format name=value pairs separated by ';'.
Host name : narmada
Creating views
View BMC_CFG_VIEW
Desc : This view has the config information for monitors of type 'Adapter for BMC Patrol ( 29753 ) '
Columns :
MOINSTID : same as described in instanceinfo_cfg.
DEVICENAME : same as described in instanceinfo_cfg.
INSTNAME : same as described in instanceinfo_cfg.
SOURCEIP : same as described in instanceinfo_cfg.
TARGETIP : same as described in instanceinfo_cfg.
APP_INST : Application Instance Name
APP_PARAM : Application Parameter Name
APP_TYPE : Application Type Name
COMPUTATION : Measure As
PASSWORD : Password
PORT_NO : Port Number
SCALE_FACTOR : Scaling Factor
USER_NAME : User Name
View BMC_ST_VIEW
Desc : This view has the stats information for monitors of type 'Adapter for BMC Patrol ( 29753 ) '
MOINSTID : same as described in instanceinfo_cfg.
TIMERECORDED : unix time stamp of when this data is collected
VAL : Application Parameter Value ( # )
View AGENTCONN_CFG_VIEW
Desc : This view has the config information for monitors of type 'Agent Connection (27011) '
Columns :
MOINSTID : same as described in instanceinfo_cfg.
DEVICENAME : same as described in instanceinfo_cfg.
INSTNAME : same as described in instanceinfo_cfg.
SOURCEIP : same as described in instanceinfo_cfg.
TARGETIP : same as described in instanceinfo_cfg.
PW_MON_VER : Monitor Version
View AGENTCONN_ST_VIEW
Desc : This view has the stats information for monitors of type 'Agent Connection ( 27011 ) '
MOINSTID : same as described in instanceinfo_cfg.
TIMERECORDED : unix time stamp of when this data is collected
STATUSCHGS : Agent Status Changes ( # )
CONN : Agents Connected ( # )
DISCONN : Agents Disconnected ( # )
NOTCONN : Agents Not Connected ( # )
TOTALAGENTS : Total Agents ( # )
View AGENTSTATUS_CFG_VIEW
Desc : This view has the config information for monitors of type 'Agent Status ( 28601 ) '
Columns :
MOINSTID : same as described in instanceinfo_cfg.
DEVICENAME : same as described in instanceinfo_cfg.
INSTNAME : same as described in instanceinfo_cfg.
SOURCEIP : same as described in instanceinfo_cfg.
TARGETIP : same as described in instanceinfo_cfg.
AGENT_IP : Agent IP
PW_MON_VER : Monitor Version
View AGENTSTATUS_ST_VIEW
Desc : This view has the stats information for monitors of type 'Agent Status ( 28601 ) '
MOINSTID : same as described in instanceinfo_cfg.
TIMERECORDED : unix time stamp of when this data is collected
AVAILABILITY : Availability ( % )
View AIXCPU_CFG_VIEW
Desc : This view has the config information for monitors of type 'AIX CPU ( 43001 ) '
Columns :
MOINSTID : same as described in instanceinfo_cfg.
DEVICENAME : same as described in instanceinfo_cfg.
INSTNAME : same as described in instanceinfo_cfg.
SOURCEIP : same as described in instanceinfo_cfg.
TARGETIP : same as described in instanceinfo_cfg.
PW_MON_VER : Monitor Version
PROCESSOR_NAME : Processor Name
View AIXCPU_ST_VIEW
Desc : This view has the stats information for monitors of type 'AIX CPU ( 43001 ) '
MOINSTID : same as described in instanceinfo_cfg.
TIMERECORDED : unix time stamp of when this data is collected
SYSTIME : % System Time ( % )
USRTIME : % User Time ( % )
WAITTIME : % Wait Time ( % )
IDLETIME : %Idle Time ( % )
CNXTSWTCH : Context Switches ( per sec )
SYSCALLS : System Calls ( per sec )