Good way to write to a database continuly

[Larshg]

Hi

I want to put the output from
wmstat -w 5
into a database as the command runs - I have this script that right now puts the data into a file.
HOST=`hostname -s`

while [ : ]
do
echo `date +"%d%m%y-%H:%M:%S"` " " `/usr/bin/vmstat -w 1 2|tail -1` >> /home/nmsuser/scripts/log/vmstat_$HOST.log
sleep 10
done

But insted of sending the output into a file - I would like it to go ino a database.

/Larshg

 

[vgersh99]

what DB?
If Oracle, 'man sqlldr'

vlad
+----------------------------+
| #include<disclaimer.h> |
+----------------------------+

 

[cdlvj]

You can pipe (|) an insert into table command with the appropriate data into the appropriate db processor, for INFORMIX - dbaccess.
mysql uses the command mysql.

 

[Larshg]

Its an ORACLE database

>man sqlldr
No reference page found for sqlldr.

My system does not contain man pages for this one.

Does anyone know where I can find thise man pages?

/Larshg

 

[PHV]

Perhaps posting in an Oracle forum ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[fredericofonseca]

look in

http://www.oracle.com.

All documentation is available there.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[vgersh99]

Oracle 9.2 Utilities Manual...

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96652/toc.htm

All the docs are at docs.oracle.com

vlad
+----------------------------+
| #include<disclaimer.h> |
+----------------------------+

 

[cdlvj]

I think that isql is the interactive interface, just pipe your info to isql.

 

[cdlvj]

echo "insert into table values "`date +"%d%m%y-%H:%M:%S"` " " `/usr/bin/vmstat -w 1 2|tail -1` | isql

not correct syntax, but you should get the idea. isql may need the dbname as a parm.