06-15-2008
Problem while execution of second set of commands
Hi,
I have a shell script with code
. perf.env
cd $QRY_DIR
for SHELL_FILE in sql1
do
export SNAME=$SHELL_FILE
${SCRIPT_DIR}/perf_qry.sh ${SPOOL_DIR} ${DB_ENVNAME} ${NAME} &
RC=$(expr ${RC:-0} + $? )
sleep 60
if [ $RC == 0 ]
then
echo sysdate>test1
echo query1.txt>>test1
grep -i selected sql_test.txt>>test1
grep -i elapsed sql_test.txt>>test1
awk '/rows selected/ { $0=$1 } /Elapsed/ { split($2, t, ":");$0=3600*t[0]+60*t[1
]+'t[2]+.001*t[3]' }{ out=out sprintf("%s%s",NR==1?"":",","\047"$0"\047") }END{
print("insert into FDW_QUERY_TIME values ("out");") }' test1>test2
fi
done
exit $RC
My problem is after executing the sql1 and the spooling is completed I want to execute the next bit of code after sleep.I actually want to grep the spooled file items.but before spooling is completed the command are executed.
Can any one help me to correct this
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I want group to run one of my unix script as me . I when the script is run it should have my permission's not the group .
I tried this :
1.Have a file called y.ksh
cat y.ksh
echo $LOGNAME >ak_test
2.Output file has this permission
-rwx------ ak_test
3.Then I chnaged... (7 Replies)
Discussion started by: akrathi
7 Replies
2. UNIX for Dummies Questions & Answers
I have a directory. To this directory, for Group bits combination, it is showing as 's'. Which I found out, it means "Set User ID on execution mode". Within this directory I am not able to create subfolder.
Does it mean, only the Owner of this directory will be able to create subdirectories &... (5 Replies)
Discussion started by: videsh77
5 Replies
3. Shell Programming and Scripting
Suppose that you want to mostly not echo commands inside your script during execution (e.g. to not bog the user down with details that they do not care about) but that there is the occaisional script line that you would like to echo before you execute it.
Is there an elegant way to achieve this?... (3 Replies)
Discussion started by: fabulous2
3 Replies
4. Shell Programming and Scripting
Hi,
I have a shell script with code
. perf.env
cd $QRY_DIR
for SHELL_FILE in sql1
do
export SNAME=$SHELL_FILE
${SCRIPT_DIR}/perf_qry.sh ${SPOOL_DIR} ${DB_ENVNAME} ${NAME} &
RC=$(expr ${RC:-0} + $? )
sleep 60
if
then
echo sysdate>test1
echo query1.txt>>test1
grep -i... (0 Replies)
Discussion started by: ran16
0 Replies
5. UNIX for Advanced & Expert Users
Hi i have 3 sql scripts that need to be executed simultaneously, and independent of one another, how do i do that in Unix AIX 5.3 (1 Reply)
Discussion started by: yschd
1 Replies
6. Shell Programming and Scripting
I got a program named as "fastq_to_fasta".
I got a long list of file all named as AB1 and AB2.
My input file is :
071022_L1_AB1.fq
012121_L1_AB1.fq
021213_L1_AB1.fq
012153_L1_AB1.fq
071022_L1_AB2.fq
012121_L1_AB2.fq
021213_L1_AB2.fq
012153_L1_AB2.fq
.
.
.
.
.
.
My desired... (10 Replies)
Discussion started by: patrick87
10 Replies
7. Shell Programming and Scripting
I am trying to run SSH , mkdir and other unix commands using Perl CGI. But i am not able to Execute these commands.
Please help me out !!!!
SSH and mkdir is necessity for me.
I will be thankful to you...!!!!!
I am trying like:
In perl CGI file i am writing like: @list = `ssh... (28 Replies)
Discussion started by: Navrattan Bansa
28 Replies
8. Shell Programming and Scripting
I need to run few commands in a ksh script sequentially.
Some of the commands are jobs submitted to the server and the consecutive commands are dependent on the completion of the jobs submitted to the server.
It works if i separate the commands into different files like this
#!/bin/ksh... (1 Reply)
Discussion started by: prashob123
1 Replies
9. Shell Programming and Scripting
I have a question:
Where would I put the Command line (of any command) so that it executes every time I log on? Where would I put it if I want it to execute every time I start a new shell? (5 Replies)
Discussion started by: Nabeel Nazir
5 Replies
10. Shell Programming and Scripting
I don't know to debug the program todaylive.pl program.
plz someone let me know what are the commands I need to know to debug the perl programs to find out the error on it. (3 Replies)
Discussion started by: ramkumar15
3 Replies
LEARN ABOUT DEBIAN
bup-restore
bup-restore(1) General Commands Manual bup-restore(1)
NAME
bup-restore - extract files from a backup set
SYNOPSIS
bup restore [--outdir=outdir] [-v] [-q]
DESCRIPTION
bup restore extracts files from a backup set (created with bup-save(1)) to the local filesystem.
The specified paths are of the form /branch/revision/path/to/file. The components of the path are as follows:
branch the name of the backup set to restore from; this corresponds to the --name (-n) option to bup save.
revision
the revision of the backup set to restore. The revision latest is always the most recent backup on the given branch. You can dis-
cover other revisions using bup ls /branch.
/path/to/file
the original absolute filesystem path to the file you want to restore. For example, /etc/passwd.
Note: if the /path/to/file is a directory, bup restore will restore that directory as well as recursively restoring all its contents.
If /path/to/file is a directory ending in a slash (ie. /path/to/dir/), bup restore will restore the children of that directory directly to
the current directory (or the --outdir). If the directory does not end in a slash, the children will be restored to a subdirectory of the
current directory. See the EXAMPLES section to see how this works.
OPTIONS
-C, --outdir=outdir
create and change to directory outdir before extracting the files.
-v, --verbose
increase log output. Given once, prints every directory as it is restored; given twice, prints every file and directory.
-q, --quiet
don't show the progress meter. Normally, is stderr is a tty, a progress display is printed that shows the total number of files
restored.
EXAMPLE
Create a simple test backup set:
$ bup index -u /etc
$ bup save -n mybackup /etc/passwd /etc/profile
Restore just one file:
$ bup restore /mybackup/latest/etc/passwd
Restoring: 1, done.
$ ls -l passwd
-rw-r--r-- 1 apenwarr apenwarr 1478 2010-09-08 03:06 passwd
Restore the whole directory (no trailing slash):
$ bup restore -C test1 /mybackup/latest/etc
Restoring: 3, done.
$ find test1
test1
test1/etc
test1/etc/passwd
test1/etc/profile
Restore the whole directory (trailing slash):
$ bup restore -C test2 /mybackup/latest/etc/
Restoring: 2, done.
$ find test2
test2
test2/passwd
test2/profile
SEE ALSO
bup-save(1), bup-ftp(1), bup-fuse(1), bup-web(1)
BUP
Part of the bup(1) suite.
AUTHORS
Avery Pennarun <apenwarr@gmail.com>.
Bup unknown- bup-restore(1)