9 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Hi,
Please let me know if you have any thoughts on how to read a table that has all the oracle sql files or shell scripts at the job and step level to identify all the tables that does merge, update, delete, insert, create, truncate, alter table (ALTER TABLE XYZ RENAME TO ABC) and call them out... (1 Reply)
Discussion started by: techmoris
1 Replies
2. Shell Programming and Scripting
How do I go about programming my system? I have access to multiple data bases but no way to operate them (1 Reply)
Discussion started by: C-lo
1 Replies
3. Shell Programming and Scripting
my queryis :
select distinct m.name, item_count, item from master m join client p on m.name=p.name where item_count = 1 and item > 1;
But how should I update them?
i used update statetment :
Update from client Set item =1 where m.name=p.name and item_count=1 AND item>1
Is this wrong? (1 Reply)
Discussion started by: siya@
1 Replies
4. Shell Programming and Scripting
dear all
please help me !
i need a script for exporting the selected tables of oracle database installed on CentOs.
i waiting your response.
thanks and regards (6 Replies)
Discussion started by: amirzargaran
6 Replies
5. Shell Programming and Scripting
Hi ,
I have a query like
select err_qty,drop_qty,unbld_qty,orig_qty from usage_data;
I need to store the values of these fetched fields in variables,
Need to edit them and update the new values into the table.
Can anyone please help me in writing this piece of code:( (1 Reply)
Discussion started by: Rajesh Putnala
1 Replies
6. Shell Programming and Scripting
All,
I have to create a shell script to comapre the rowcount of 120 tables from two oracle databases. In fact, using informatica the data is loading from 120 source tables to 120 staging tables. After that, they want to have a shell script to comapre the rowcount of all these tables.
1) I... (3 Replies)
Discussion started by: Maya_Pillai
3 Replies
7. Shell Programming and Scripting
Hi ,
I have two tables with same length t1 and t2, I want to cretae a new third table where i put the difference between the elements of t2 and t1,
t3= t1 - t2
t3= t1 - t2
I am new to scripts, any help please? thanks (7 Replies)
Discussion started by: Celine19
7 Replies
8. UNIX for Dummies Questions & Answers
Hi all,
Please see my requirement and post me asap.
Spool all the tables names into a file . Take each table name and check if it is present in any of the scripts in a directory using grep -il command. The script has to loop through the tables list and take each table and find it's presence... (7 Replies)
Discussion started by: Vasundhara
7 Replies
9. Post Here to Contact Site Administrators and Moderators
Need to eventually sync the MY.UNIX userdata to the forums database (and others). Suggestions on the best approach welcome. (0 Replies)
Discussion started by: Neo
0 Replies
MRTG-RRD(1) mrtg MRTG-RRD(1)
NAME
mrtg-rrd - How to use RRDtool with MRTG
SYNOPSIS
After using MRTG for some time you may find some limitations. Mostly in the areas of performance and graphing flexibility. These are
exactly the areas addressed by rrdtool. To learn more about RRDtool check out its website on
http://people.ee.ethz.ch/~oetiker/webtools/rrdtool
RRDTOOL INTEGRATION
When using mrtg with RRDtool you are replacing rateup with the RRDtool perl module RRDs.pm. To enable RRDtool support in mrtg you have to
add the line
LogFormat: rrdtool
MRTG needs access to both the RRDtool perl module RRDs.pm and to the rrdtool executable.
If these two items are not installed in locations where perl can find them on its own, then you can use the following two parameters to
supply the appropriate directories.
For the location of the rrdtool executable you put
PathAdd: /usr/local/rrdtool/bin/
or
PathAdd: c:
rdtoolin
For the location of the perl module it would be:
LibAdd: /usr/local/rrdtool/lib/perl/
or
LibAdd: c:
rdtoolinlibperl
When you have made this modification to the configuration file, several things will happen when you run mrtg again with the new config
file:
1. mrtg will take all your old ".log" files and convert them to ".rrd" format. (The ".log" files don't get touched in the process, so if
things don't work out they are still there.)
2. mrtg will use rrdtool to update its databases. These will have a new format called rrd which is totally different than the native log
format of the classic mrtg.
3. mrtg will not create any webpages of graphs anymore. It will only query the routers for traffic information and update its rrd data-
bases.
The advantage of whole thing is that the mrtg will become much faster. Expect the runtime to drop to 20% of the previous value. (I would
like to get some feedback on this from folks with large installations)
Mind you though, while the logging process of RRDtool is very fast, you are also gaining some time by neither creating graphs nor updating
webpages. The idea behind this is that it is more efficient to create graphs and webpages on demmand. Using a cgi script.
At the moment there is no official script to do this, but two contributers have created such scripts:
14all.cgi
Was the first program to take over the webpage creation and graphing task. It has been developed by Rainer Bawidamann <Rainer.Baw-
idamann@informatik.uni-ulm.de>. You can find a copy on Rainers website:
http://www.uni-ulm.de/~rbawidam/mrtg-rrd/
The program comes with its own documentation
routers.cgi, servers.cgi and generic.cgi
are other cgi frontends to mrtg running with rrdtool. Thier main difference to 14all is, that the web pages it creates are much more
stylish than the ones from mrtg. These tools have been written by Steve Shipway <steve.shipway@adsweu.com>. You can find a copy in
http://www.cheshire.demon.co.uk/pub/
The scripts comes with their own installation instructions.
FUTURE
Just as a side note: MRTG-3 will be based entirely on rrdtool technology. But don't wait for it ... get going now!
AUTHOR
Tobias Oetiker <oetiker@ee.ethz.ch>
3rd Berkeley Distribution 2.9.17 MRTG-RRD(1)