|
By chance, does anyone have a script that will
reparse a collection of sar statistics, that came from "sar -d", into a file
that can be used by SQL*Loader?
My problem is that the timestamp, which
is just that--no date, is only on the first record of each sample rather than
every record and I don't want the blank lines in between the samples. Perhaps
this is a simple awk routine but I don't know awk well enough to do this.
Any assistance is appreciated!
-w
Here is a sample of the data
I am trying to work with:
SunOS pandora 5.6
Generic_115161-23 sun4u
01/30/01
08:00:00 device
%busy avque r+w/s blks/s avwait avserv
08:01:00 nfs1
0 0.0 0 0 0.0 0.0
sd5
4 0.0 7 132 0.0 6.5
sd5,c
0 0.0 0 0 0.0 0.0
sd5,d
0 0.0 0 0 0.0 0.0
sd5,e
4 0.0 6 132 0.0 7.2
sd22
1 0.1 1 21 0.0 81.3
sd22,a
0 0.0 0 0 0.0 0.0
sd22,b
0 0.0 0 0 0.0 0.0
sd22,c
0 0.0 0 0 0.0 0.0
sd22,d
0 0.0 0 0 0.0 0.0
sd22,e
0 0.0 0 0 0.0 0.0
sd22,g
1 0.1 1 21 0.0 81.3
sd22,h
0 0.0 0 0 0.0 0.0
sd23
2 0.0 3 101 0.0 7.1
sd23,c
0 0.0 0 0 0.0 0.0
sd23,d
0 0.0 0 0 0.0 0.0
sd23,e
2 0.0 3 101 0.0 7.1
sd34
0 0.0 0 0 0.0 0.0
sd45
1 0.1 1 21 0.0 96.4
sd45,a
0 0.0 0 0 0.0 0.0
sd45,b
0 0.0 0 0 0.0 0.0
sd45,c
0 0.0 0 0 0.0 0.0
sd45,d
0 0.0 0 0 0.0 0.0
sd45,e
1 0.1 1 21 0.0 96.4
sd45,g
0 0.0 0 0 0.0 0.0
sd45,h
0 0.0 0 0 0.0 0.0
sd46
0 0.0 0 0 0.0 0.0
sd46,c
0 0.0 0 0 0.0 0.0
sd46,d
0 0.0 0 0 0.0 0.0
sd46,e
0 0.0 0 0 0.0 0.0
sd66
0 0.0 0 0 0.0 0.0
sd125
0 0.0 0 0 0.0 0.0
sd126
0 0.0 0 0 0.0 0.0
sd127
0 0.0 0 0 0.0 0.0
sd127,a
0 0.0 0 0 0.0 0.0
sd127,b
0 0.0 0 0 0.0 0.0
sd127,c
0 0.0 0 0 0.0 0.0
sd127,d
0 0.0 0 0 0.0 0.0
sd127,e
0 0.0 0 0 0.0 0.0
sd127,g
0 0.0 0 0 0.0 0.0
sd328
2 0.0 4 70 0.0 4.9
sd328,c
0 0.0 0 0 0.0 0.0
sd328,d
0 0.0 0 0 0.0 0.0
sd328,e
2 0.0 4 70 0.0 4.9
sd329
0 0.0 0 0 0.0 0.0
sd329,c
0 0.0 0 0 0.0 0.0
sd329,d
0 0.0 0 0 0.0 0.0
sd329,e
0 0.0 0 0 0.0 0.0
sd330 0 0.0 0 0 0.0 0.0
st32
0 0.0 0 0 0.0 0.0
st33
0 0.0 0 0 0.0 0.0
08:02:00 nfs1
0 0.0 0 0 0.0 0.0
sd5
2 0.0 3 82 0.0 7.4
sd5,c
0 0.0 0 0 0.0 0.0
sd5,d
0 0.0 0 0 0.0 0.0
sd5,e
2 0.0 3 82 0.0 9.1
sd22
1 0.0 1 11 0.0 53.6
sd22,a
0 0.0 0 0 0.0 0.0
sd22,b
0 0.0 0 0 0.0 0.0
sd22,c
0 0.0 0 0 0.0 0.0
sd22,d
0 0.0 0 0 0.0 0.0
sd22,e
0 0.0 0 0 0.0 0.0
sd22,g
1 0.0 1 11 0.0 53.6
sd22,h
0 0.0 0 0 0.0 0.0
sd23
1 0.0 1 49 0.0 12.7
sd23,c
0 0.0 0 0 0.0 0.0
sd23,d
0 0.0 0 0 0.0 0.0
sd23,e
1 0.0 1 49 0.0 12.7
sd34
0 0.0 0 0 0.0 0.0
sd45
1 0.0 1 11 0.0 63.4
sd45,a
0 0.0 0 0 0.0 0.0
sd45,b
0 0.0 0 0 0.0 0.0
sd45,c
0 0.0 0 0 0.0 0.0
sd45,d
0 0.0 0 0 0.0 0.0
sd45,e
1 0.0 1 11 0.0 63.4
sd45,g
0 0.0 0 0 0.0 0.0
sd45,h
0 0.0 0 0 0.0 0.0
sd46
0 0.0 0 0 0.0 0.0
sd46,c
0 0.0 0 0 0.0 0.0
sd46,d
0 0.0 0 0 0.0 0.0
sd46,e
0 0.0 0 0 0.0 0.0
sd66
0 0.0 0 0 0.0 0.0
sd125
0 0.0 0 0 0.0 0.0
sd126
0 0.0 0 0 0.0 0.0
sd127
0 0.0 0 0 0.0 0.0
sd127,a
0 0.0 0 0 0.0 0.0
sd127,b
0 0.0 0 0 0.0 0.0
sd127,c
0 0.0 0 0 0.0 0.0
sd127,d
0 0.0 0 0 0.0 0.0
sd127,e
0 0.0 0 0 0.0 0.0
sd127,g
0 0.0 0 0 0.0 0.0
sd328
1 0.0 3 37 0.0 3.7
sd328,c
0 0.0 0 0 0.0 0.0
sd328,d
0 0.0 0 0 0.0 0.0
sd328,e
1 0.0 3 37 0.0 3.7
sd329
0 0.0 0 0 0.0 0.0
sd329,c
0 0.0 0 0 0.0 0.0
sd329,d
0 0.0 0 0 0.0 0.0
sd329,e
0 0.0 0 0 0.0 0.0
sd330
0 0.0 0 0 0.0 0.0
st32
0 0.0 0 0 0.0 0.0
st33
0 0.0 0 0 0.0
0.0
|
