I would try to do both. Make a separate directory for today's data,
then run a job to extract datapoints, say, from midnight to midnight,
and dump them to files with the same names in the new directory.
This can be done with the snmpColDump command, which people
use to truncate their flat files. Then do the nvColToSQL against
the short files, with the -a flag to archive them (discard them) and
append the data in the relational database.
The man page for snmpColDump will first give you hope, and
then it will confuse you. Here's a little ksh sample to help you :
for COLFILE in $COLFILELIST
do
(
snmpColDump -tTI $DIR/$COLFILE | \
awk '{printf("%d\t%d\t%s\t%lg\n", $5, $6,$7,$4 )}' | \
while read line
do
set $line
if [ "$1" -gt "$begintime" ] # make your decision here
then
echo $line
fi
done
) | snmpColDump -r - $TDIR/$COLFILE
The timestamps it uses are in seconds since 1/1/1970 (epoch time),
so you will need a command to return that value.
Cordially,
Leslie A. Clark
IBM Global Services - Systems Mgmt & Networking
Detroit
Yong
ZHOU/China/IBM To: nv-l@lists.tivoli.com
@IBMCN cc: Wei LUO/China/IBM@IBMCN, Ou
Shen/China/IBM@IBMCN
03/14/02 09:27 Subject: [nv-l] SNMPdata -> RDBMS
by
PM snapshot mode
Hi there,
We are using the snapshot mode to dump SNMP data from nv6.0.2 into
database(oracle). The reason why we choose snapshop is customer what the
data existing in both netview flat file (so they can use graph view) and
database (so can use TDS to analysis). Problem is, such an approach forcese
us to clear whole table in database and re-dump into it everyday. As data
growing the procedure costs longer and longer time, quickly reaches
tolerance of customer.
Does anyone has better solutions?
Best Regards,
Zou Yong
Advisory I/T Specialist, Network Technology Service Team, ITS IBM Shanghai
10/F Shui On Plaza, 333 Huai Hai Zhong Road,
Shanghai 200021, P.R.China
Tel: (86)21-63262288x2286 Fax: (86)21-63261177
Notes ID: Yong ZHOU/China/IBM E-Mail: zhouy@cn.ibm.com
---------------------------------------------------------------------
To unsubscribe, e-mail: nv-l-unsubscribe@lists.tivoli.com
For additional commands, e-mail: nv-l-help@lists.tivoli.com
*NOTE*
This is not an Offical Tivoli Support forum. If you need immediate
assistance from Tivoli please call the IBM Tivoli Software Group
help line at 1-800-TIVOLI8(848-6548)
|