Please be more specific in what you want to change from what you are currently doing.
Does this code inprocess_cpu.sh:
really work for you? In addition to missing a then, what does the d utility on your system do and what is in the file named 2015-08-16 when you run this command today?
If you want to update the database hourly, why are you creating one log file per day instead of one log file per hour? Why not run:
in your hourly script and run the awk script on the resulting log file instead of reprocessing data being accumulated continuously during the day into a single file.
Good point. I'll run both hourly. Is there a way to merge the hourly files into one per day?
Hi....can you guys help me out in this script??
Below is a text file script....called Bukom.txt and it contains these:
BUKOM 20060101 2.5 2.6 2.7 2.8 2.9 2.3 2.1
BUKOM 20060102 2.4 2.5 2.6 2.7 2.7 2.6 2.4
BUKOM 20060103 2.1 ... (9 Replies)
Hi,
Need to get help from you guys about this issue.
I need to insert data into MySql database from a text file which is located in other server.
The text file is something look like below:
Date | SubscriberNo | Call Duration
20/7/07 | 123456788 | 20
20/7/07 | 123412344 | 30
The... (4 Replies)
Hi....can you guys help me out in this script??
Below is a text file and it contains these:
GEF001 000093625 MKL002510 000001 000000 000000 000000 000000 000000 000001
GEF001 000093625 MKL003604 000001 000000 000000 000000 000000 000000 000001
GEF001 000093625 MKL005675 000001... (4 Replies)
Hi All,
I have a file like this,
data1,data2,,,data5,data6.
i want to write a shell script to replace data3 with "/example/string". which means my data file should look like this .
data1,data2,example/string],,data5,data6.
Could you guys help me to get a sed command or any other command... (8 Replies)
Hi Guys
I need to have a shell script which reads a log file and insert a part of each line into the database. Some sample lines in the file are as below.
20091112091359 MED_RQACK : user_data=60173054304,100232120,20091112091359,;ask_status=0;ask_reason=OK;msg_id=20091112091319... (5 Replies)
If you have a text file and if you want to Insert data to your Database Table, You can do it with these queries
LOAD DATA LOCAL INFILE '/path/yourTextFile.txt' INTO TABLE yourTableName
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
ESCAPED BY '\\'
LINES TERMINATED BY '\n' (0 Replies)
Enclosed is comma separated text file. I need to write a korn shell program that will parse the text file and insert the values into Oracle database.
I need to write the korn shell program on Red Hat Enterprise Linux server.
Oracle database is 10g. (15 Replies)
Hello All:
We are looking to search through 2000 files with around 21,000 statements where we have to search, replace and insert a pattern based on the following:
1) Parse through the file and check for CREATE MULTISET TABLE or CREATE SET TABLE statements.....and they always end with ON... (5 Replies)
I have a test file that I want to read and insert only certain lines into the
the table based on a filter.
1. Rread the log file 12 Hours back Getdate() -12 Hours
2. Extract the following information on for lines that say "DUMP is
complete"
A. Date
B. Database Name
C.... (2 Replies)
Hi Experts,
I have a situation where I need to write a shell script to continuously monitor a log directory with multiple log files and perform following:
1. Read the latest log file continuously and grep "Success" OR "Failure"
2. As it capture either Success or Failure, it has to perform a... (1 Reply)
Discussion started by: rish_max
1 Replies
LEARN ABOUT DEBIAN
sa2
SA2(8) Linux User's Manual SA2(8)NAME
sa2 - Write a daily report in the /var/log/sysstat directory.
SYNOPSIS
/usr/lib/sysstat/sa2
DESCRIPTION
The sa2 command is a shell procedure variant of the sar command which writes a daily report in the /var/log/sysstat/sardd file, where the
dd parameter indicates the current day. The sa2 command handles all of the flags and parameters of the sar command.
The sa2 command is designed to be started automatically by the cron command.
EXAMPLES
To run the sa2 command daily, place the following entry in your root or adm crontab file:
5 19 * * 1-5 /usr/lib/sysstat/sa2 -A &
This will generate a daily report called /var/log/sysstat/sardd It will also remove reports more than one week old.
Debian note
The Debian sysstat package has already placed such an entry in your system crontab. Please refer to the /usr/share/doc/sys-
stat/README.Debian file for details.
FILES
/var/log/sysstat/sardd
Indicate the daily report file, where the dd parameter is a number representing the day of the month.
AUTHOR
Sebastien Godard (sysstat <at> orange.fr)
SEE ALSO sar(1), sadc(8), sa1(8), sadf(1)
http://pagesperso-orange.fr/sebastien.godard/
Linux AUGUST 2010 SA2(8)