Re: [nv-l] Clearing Snmpcollect_db.mdb

[James Shanks <jshanks@us.ibm.com>]

Unlike UNIX, snmpcollect on Windows automatically collects MIB data from objects in your network by default.  It is stored in the database you have identified -- .mdb files are MS Jet relational databases, which can be read with Microsoft Access.   NetView also provides tools to manipulate the data. If you aren't interested in the MIB data then you can suspend the collection of it, using Start --> Tasks --> Collect MIB data.  Then nothing new will be added the database.   You can purge the database manually using the snmpodump command, "snmpodump -x<number of entries to keep>".   You can also schedule it automatically from nvsetup -> Files and drop down the file window so that it says "Schedule SNMPCollect data to delete"

You can also display the data using the snmpodump and snmpcdump commands.  Type them from the command line with a question mark "snmpodump -?" to see summaries of the options.   I recommend that you spend some time with books available under \usr\ov\books, particularly the User's Guide, to see what this facility can do for you.    

James Shanks
Level 3 Support  for Tivoli NetView for UNIX and Windows
Tivoli Software / IBM Software Group

John F <nvuser2000@yahoo.com> Sent by: owner-nv-l@lists.us.ibm.com 11/22/2003 05:48 AM Please respond to nv-l

To:        lists <nv-l@lists.us.ibm.com>         cc:                 Subject:        [nv-l] Clearing Snmpcollect_db.mdb

Hello lists,
 
NV 7.1.3 under Windows 2000
 
The file Snmpcollect_db.mdb  (under \usr\ov\databases\odbc) is growing in size. How to clear it? Also can anyone inform me which are all the files that are to be cleared periodically and the procedure to clear them ?
 
Thanks,
 
John

---

Do you Yahoo!?
Free Pop-Up Blocker - Get it now