Hello folks,
I have data collected in every 3 hours. But, I would like to expand this to 1 hour interval by equally dividing with next row.
For example, I want to keep the first value 1987-01-01-00z 2.0, but following all record should be re-written as follow.
1987-01-01-03z 5.0 becomes... (11 Replies)
Hi All,
I need to BCP out a table into a text file along with the table headers. Normal BCP out command only bulk copies the data, and not the headers.
I am using the following command: bcp database1..table1 out file1.dat -c -t\| -b1000 -A8192 -Uuser -Ppassword -efile.dat.err
Regards,... (0 Replies)
Hi
I need to create multiple text files from onc text file on AIX. The data of text files is as below:
**********************************************
**********************************************
DBVERIFY: Release 10.2.0.4.0 - Production on Tue Nov 10 13:45:42 2009
Copyright (c) 1982,... (11 Replies)
Hello friends!
Help me pls to write correct awk and grep statements for my task:
I have got files with name filename.txt
It has such structure:
Start of file
FROM: address@domen.com (12...890) abc
DATE: 11/23/2009 on Std
SUBJECT: any subject
End of file
So, I must check,
if this file... (4 Replies)
I have a text file with irregular spacing between values which makes it really difficult to manipulate. Is there an easy way to convert it into a space delimited text file so that all the spaces, double spaces, triple spaces, tabs between numbers are converted into spaces. The file looks like this:... (5 Replies)
I am on Ubuntu 11.10 using bash.
I want to perform some numeric computations and have the following options:
# Setting verbosity levels
none=0; low=1; medium=2; high=3; debug=4
(( vbLevel=medium ))
if (( vbLevel > low )); then
echo "Test 1, $vbLevel"
fi
vbLevel=$medium
if ];... (3 Replies)
Hi,
I am trying to extract lines from a text file given a text file containing line numbers to be extracted from the first file. How do I go about doing this? Thanks! (1 Reply)
I have the following code and into into trying to simplifying it. Any suggestions please?
pmin = min (p(1), p(2), p(3), p(4), p(5), p(6))
ni = 0
xint = 0.0
yint = 0.0
zint = 0.0
!--------------------------------------------- !
if ((0.99999 * p(1)) <= pmin) then
... (3 Replies)
I hope this makes sense and is possible.
I am trying to match $1 of panel_genes.txt with $3 of RefSeqGene.txt and when a match is found the value in $6 of RefSeqGene.txt
Example: ACTA2 is $1 of panel_genes.txt
ACTA2 NM_001613.2
ACTA2 NM_001141945.1
awk 'FNR==NR {... (4 Replies)
hi all,
trying this using shell/bash with sed/awk/grep
I have two files, one containing one column, the other containing multiple columns (comma delimited).
file1.txt
abc12345
def12345
ghi54321
...
file2.txt
abc1,text1,texta
abc,text2,textb
def123,text3,textc
gh,text4,textd... (6 Replies)
Discussion started by: shogun1970
6 Replies
LEARN ABOUT MOJAVE
iopattern
iopattern(1m) USER COMMANDS iopattern(1m)NAME
iopattern - print disk I/O pattern. Uses DTrace.
SYNOPSIS
iopattern [-v] [-d device] [-f filename] [-m mount_point] [interval [count]]
DESCRIPTION
This prints details on the I/O access pattern for the disks, such as percentage of events that were of a random or sequential nature. By
default totals for all disks are printed.
An event is considered random when the heads seek. This program prints the percentage of events that are random. The size of the seek is
not measured - it's either random or not.
Since this uses DTrace, only users with root privileges can run this command.
OPTIONS -v print timestamp, string
-d device
instance name to snoop (eg, dad0)
-f filename
full pathname of file to snoop
-m mount_point
mountpoint for filesystem to snoop
EXAMPLES
Default output, print I/O summary every 1 second,
# iopattern
Print 10 second samples,
# iopattern 10
Print 12 x 5 second samples,
# iopattern 5 12
Snoop events on the root filesystem only,
# iopattern -m /
FIELDS
%RAN percentage of events of a random nature
%SEQ percentage of events of a sequential nature
COUNT number of I/O events
MIN minimum I/O event size
MAX maximum I/O event size
AVG average I/O event size
KR total kilobytes read during sample
KW total kilobytes written during sample
DEVICE device name
MOUNT mount point
FILE filename (basename) for I/O operation
TIME timestamp, string
IDEA
Ryan Matteson
DOCUMENTATION
See the DTraceToolkit for further documentation under the Docs directory. The DTraceToolkit docs may include full worked examples with ver-
bose descriptions explaining the output.
EXIT
iopattern will run forever until Ctrl-C is hit, or the specified count is reached.
AUTHOR
Brendan Gregg [Sydney, Australia]
SEE ALSO iosnoop(1M), iotop(1M), dtrace(1M)version 0.70 Jul 25, 2005 iopattern(1m)