I would like to use SQL's log file to extract information from it.
This file can include four different types of instruction with the number of lines involved for each of them:
-> (1) "INSERT" instruction with the number of lines inserted
-> (2) "UPDATE" instruction with the number of lines updated
-> (3) "DELETE" instruction with the number of lines deleted
-> (4) "COLLECT STATISTICS" instruction with the number of lines involved.
The number of lines involved for "UPDATE" and "COLLECT STATISTICS" has exactly the same appearance in the log file:
-> for "COLLECT STATISTICS" instruction (check "Update completed" below)
-> for "UPDATE" instruction (check "Update completed" below)
The problem I face is the following: I am not interested by the number of lines involved in the "COLLECT STATISTICS" instruction and I am not able to recognize from the log file what kind of expression - "COLLECT STATISTICS" or "UPDATE" - produced "Update completed" in the log file !
So, I thought to cut off from the log file the multi-line record starting with "COLLECT STATISTICS" and ending with "changed." ... but I failed, I failed, I failed !
Thanks in advance for the attention you pay to my request and obviously, any suggestion over welcomed,
Not sure I understand your request. Completing it with sample input data and the relevant code snippet from your failing attempts might help to come to a close interpretation.
for instance, below is the whole content of the log file MyLogFile:
In that log file, we have two kinds of clause:
(1) an UPDATE clause (the first one)
(2) a "COLLECT STATISTICS" clause (the second one).
I want to know how many records were implied in the UPDATE clause only.
Using the following shell command, I got the two records output:
but only the first record is necessary to me (it allows to know the UPDATE clause did not have any effect: "No rows changed"), the second one is related to the "COLLECT STATISTICS" clause and I do not care about the impact of that clause.
The problem I face is the output is exactly the same for the two clauses: I am not able to link the first record from the grep command to the "UPDATE" clause, and the second record to the "COLLECT STATISTICS" !
So I thought to perform a treatment on "MyLogFile", before issuing the grep command, to delete all the information linked with the "COLLECT STATISTICS" clause in order to obtain only the record linked with UPDATE clause when performing "grep" !
But I do not know how to perform that operation ....
I am dealing with some app log, see example below:
22:16:13.601 ClientSession(905)--Connection(5)--SELECT GETDATE()
22:16:13.632 ClientSession(158)--Connection(5)--SELECT 1
22:16:13.632 ClientSession(848)--Connection(6735)--SELECT 1 So far I needed to collect certain column from it, such as... (3 Replies)
Hi,
I have a log file that looks like below and I am wanting to know if there is a better way of parsing it from how I am doing it right now.
I am looking for when an application service is OFFLINE and ONLINE. This log file is getting written into every 30 minutes
... (1 Reply)
I have number in file which contains date and serial number:
2013101000.
The last two digits are serial number (00). So maximum of serial number is 100.
After reaching 100 it becomes 00 with incrementing 10 which is day with max 31.
after reaching 31 it becomes 00 and increments 10... (31 Replies)
Hi,
I am a newbie to scripting.
I have multiple log files (saved as .gz) in a directory that looks like this
01-01-2013 10:00 pn: 123
01-01-2013 10:00 sn: 987
01-01-2013 10:00 Test1
01-01-2013 10:00 Result: Pass
01-01-2013 10:00 Time: 5:00
01-01-2013 10:00 Test2
01-01-2013 10:00... (3 Replies)
Hi,
file=/usr/lib
I need to cut and put it into two variable like
string1=/usr
string2=lib
I made it for string2
string2=${file#/*/}
How to get String1 in the same way which I have get string2.
Use even more code tags ;) (4 Replies)
Hello all,
I am new to scripting and I have written a script that performs an Rsync on my NAS and then moves on to send me an email with the status etc. The problem is that I think Rsync is taking to long to complete and the IF statement is timing out, as it doesn't appear to move on.
Here... (1 Reply)
hi everybody..
I have a string like :
abcd:efgh
xxyy:yyxx
ssddf:kjlioi
ghtyu:jkksk
nhjkk:heuiiue
please tell me how i can display only the characters after ":" in the output
the output should be :
efgh
yyxx
kjlioi
jkksk
heuiiue
please give quick reply.. its urgent..!! (6 Replies)
I need help in parsing the following log files.
10 Apr 2009 0:16:16 * name: Tuna Belly Format: Well done, Price: 999 only
10 Apr 2009 0:16:16 * name: Roast Beef Format: Raw, Price: 55 c
10 Apr 2009 0:16:16 * name: Pasta Format: Dry, Price: 88.43 only
etcetc
I need to parse this... (8 Replies)
Hi,
I have a textfile with several lines like this:
text num: USER text (num) num num
I need all these stuff. Problem is, how to get these stuff after ":".
USER is a username and all chars are possible, even whitespace. So I cant use cut. Any ideas? (3 Replies)
Hi All,
I'm deffently not a Unix specialist so be Gentel.
I need to parse a Log file that looks like that:
2006-06-12 01:00:00,463 ERROR {cleanLoggersFiles} General Error
comverse.compas.shared.exceptions.SystemParametersException: Error in reading parameter FileLocation
at... (4 Replies)