1 Nnm Data Warehouse

NNM Data Warehouse

ca.com

Data Warehouse Overview  Data Warehouse provides – Export of topology, event and trend (snmpcollect) data – Summarization of trend and event data – Trimming of trend and event data – Support of relational databases – Embedded database technology when no RDBMS is available – Published schemas for access by customers – Command line interfaces

Slide I - 2

ca.com

Warehouse Data Flow Current Operational Data Stores

Delete

Data Collector Binary Database (SNMP Trend) Binary Event Store (Events

Topology Database

Slide I - 3

Automatic Report Generation Data Warehouse

Summarization

Data Queries

Other Reporting tools

Trim

ca.com

Topology Data in Data Warehouse  To place topology data in data warehouse – ovdwtopo -export

 Previously written topology data is overwritten  -v parameter prints out the summary information of actions taken  -trace parameter traces the operation and stores it in \install_dir\logs\ovdwtopo.trace

Slide I - 4

ca.com

Event Data in Data Warehouse  All events are stored in Binary Event Store  Events are exported to the Data Warehouse by ovdwevent  Can be scheduled to export events periodically  2 options – export events from binary event store – trim data in Data Warehouse

Slide I - 5

ca.com

Event Data export options  To export all new events to the Data Warehouse -export

 To export events that occur between certain times – exportstart 08:00 –exportstop 17:00 – exportnoweekends

 To specify no. of records to be exported – exportmaxrecords 500

Slide I - 6

ca.com

Event Tables  Exported event data placed in following tables – nnm_event_details – nnm_event_varbinds

 To trim old data in the data warehouse – trim (data > 180 days) – trimdetail 60 (data > 60 days) – trimaggregatedepth 5

Slide I - 7

ca.com

Event Filters  Set filters to filter out some events  Filters are stored in nnm_event_limits table ovdweventflt – – – –

Insert with –n node –o object Update by replacing with new node/object Delete with –delete option Display with –display option

eg: ovdweventflt –n node –o ‘*’ –i N ovdweventflt –delete –clean ovdweventflt –display

Slide I - 8

ca.com

SNMP Trend Data in Data Warehouse  Trend (snmpCollect) data is managed using the command ovdwtrend – – – – –

export data from binary source to DW Summarize the data in DW Reduce (delete) some data in DW Delete some or all data from binary source Export data from DW to an archive file

eg: ovdwtrend –export ovdwtrend –exportto raw ovdwtrend –delpriorto [relhours | datetime] ovdwtrend –trimpriorto 24

Slide I - 9

ca.com

Querying the Data Warehouse  ovdwquery – primary query tool to extract data from the database  SQL commands are read from stdin or –file  SQL commands are processed by ODBC driver  Results are written to stdout or –out

Slide I - 10

ca.com

Copying Warehouse data  Copy event or trend data to or from a file ovdwunloader – copy data from Data Warehouse to a file ovdwloader – copy data from a file to the Data Warehouse

 Common parameters – – – –

-rdb datasource -u user -p password -file outputfile

eg: ovdwunloader –file old-data –trend ovdwloader –file old-data

Slide I - 11

ca.com

Clearing the Data Warehouse  You may want to clear your DW to – clear out test data before beginning production work – reconfigure data exports to generate a smaller database footprint

 To clear the DW and return it to the installed state – Stop database processes using ovstop ovdbcheck – Change directory to \install_dir\databases\analysis\default – Remove the following files     

– – – – –

Slide I - 12

solid.db solmsg.out solmsg.bak solerror.out *.log

change directory to default/log and remove all files change directory to default/backup and remove all files change directory to default and execute ovdbrun –x exit execute ovstart ovdbcheck execute ovdwconfig.ovpl –type embedded -load

ca.com